2 Module : Gargantext.Database.Flow
3 Description : Database Flow
4 Copyright : (c) CNRS, 2017-Present
5 License : AGPL + CECILL v3
6 Maintainer : team@gargantext.org
7 Stability : experimental
11 -- check userId CanFillUserCorpus userCorpusId
12 -- check masterUserId CanFillMasterCorpus masterCorpusId
14 -- TODO-ACCESS: check uId CanInsertDoc pId && checkDocType nodeType
15 -- TODO-EVENTS: InsertedNodes
18 {-# OPTIONS_GHC -fno-warn-orphans #-}
20 {-# LANGUAGE ConstrainedClassMethods #-}
21 {-# LANGUAGE ConstraintKinds #-}
22 {-# LANGUAGE InstanceSigs #-}
23 {-# LANGUAGE ScopedTypeVariables #-}
24 {-# LANGUAGE TemplateHaskell #-}
26 module Gargantext.Database.Action.Flow -- (flowDatabase, ngrams2list)
39 , getOrMk_RootWithCorpus
45 , indexAllDocumentsWithPosTag
49 import Control.Lens ((^.), view, _Just, makeLenses)
50 import Data.Aeson.TH (deriveJSON)
52 import Data.HashMap.Strict (HashMap)
53 import Data.Hashable (Hashable)
54 import Data.List (concat)
55 import Data.Map (Map, lookup)
56 import Data.Maybe (catMaybes)
59 import qualified Data.Text as T
60 import Data.Traversable (traverse)
61 import Data.Tuple.Extra (first, second)
62 import GHC.Generics (Generic)
63 import System.FilePath (FilePath)
64 import qualified Data.HashMap.Strict as HashMap
65 import qualified Gargantext.Data.HashMap.Strict.Utils as HashMap
66 import qualified Data.Map as Map
68 import Gargantext.API.Admin.Orchestrator.Types (JobLog(..))
69 import Gargantext.Core (Lang(..), PosTagAlgo(..))
70 import Gargantext.Core.Ext.IMT (toSchoolName)
71 import Gargantext.Core.Ext.IMTUser (readFile_Annuaire)
72 import Gargantext.Core.Flow.Types
73 import Gargantext.Core.Text
74 import Gargantext.Core.Text.Corpus.Parsers (parseFile, FileFormat)
75 import Gargantext.Core.Text.List (buildNgramsLists)
76 import Gargantext.Core.Text.List.Group.WithStem ({-StopSize(..),-} GroupParams(..))
77 import Gargantext.Core.Text.List.Social (FlowSocialListWith)
78 import Gargantext.Core.Text.Terms
79 import Gargantext.Core.Text.Terms.Mono.Stem.En (stemIt)
80 import Gargantext.Core.Types (POS(NP))
81 import Gargantext.Core.Types.Individu (User(..))
82 import Gargantext.Core.Types.Main
83 import Gargantext.Core.Utils.Prefix (unPrefix, unPrefixSwagger)
84 import Gargantext.Database.Action.Flow.List
85 import Gargantext.Database.Action.Flow.Types
86 import Gargantext.Database.Action.Flow.Utils (insertDocNgrams, DocumentIdWithNgrams(..))
87 import Gargantext.Database.Action.Search (searchDocInDatabase)
88 import Gargantext.Database.Admin.Config (userMaster, corpusMasterName)
89 import Gargantext.Database.Admin.Types.Hyperdata
90 import Gargantext.Database.Admin.Types.Node -- (HyperdataDocument(..), NodeType(..), NodeId, UserId, ListId, CorpusId, RootId, MasterCorpusId, MasterUserId)
91 import Gargantext.Database.Prelude
92 import Gargantext.Database.Query.Table.ContextNodeNgrams2
93 import Gargantext.Database.Query.Table.Ngrams
94 import Gargantext.Database.Query.Table.Node
95 import Gargantext.Database.Query.Table.Node.Document.Insert -- (insertDocuments, ReturnId(..), addUniqIdsDoc, addUniqIdsContact, ToDbData(..))
96 import Gargantext.Database.Query.Table.Node.Error (HasNodeError(..))
97 import Gargantext.Database.Query.Table.NodeNgrams (listInsertDb , getCgramsId)
98 import Gargantext.Database.Query.Tree.Root (getOrMkRoot, getOrMk_RootWithCorpus)
99 import Gargantext.Database.Schema.Node (NodePoly(..), node_id)
100 import Gargantext.Database.Types
101 import Gargantext.Prelude
102 import Gargantext.Prelude.Crypto.Hash (Hash)
103 import qualified Gargantext.Core.Text.Corpus.API as API
104 import qualified Gargantext.Database.Query.Table.Node.Document.Add as Doc (add)
106 ------------------------------------------------------------------------
107 -- Imports for upgrade function
108 import Gargantext.Database.Query.Tree.Root (getRootId)
109 import Gargantext.Database.Query.Tree (findNodesId)
110 import qualified Data.List as List
111 ------------------------------------------------------------------------
112 -- TODO use internal with API name (could be old data)
113 data DataOrigin = InternalOrigin { _do_api :: API.ExternalAPIs }
114 | ExternalOrigin { _do_api :: API.ExternalAPIs }
116 deriving (Generic, Eq)
118 makeLenses ''DataOrigin
119 deriveJSON (unPrefix "_do_") ''DataOrigin
120 instance ToSchema DataOrigin where
121 declareNamedSchema = genericDeclareNamedSchema (unPrefixSwagger "_do_")
123 allDataOrigins :: [DataOrigin]
124 allDataOrigins = map InternalOrigin API.externalAPIs
125 <> map ExternalOrigin API.externalAPIs
128 data DataText = DataOld ![NodeId]
129 | DataNew ![[HyperdataDocument]]
131 -- TODO use the split parameter in config file
132 getDataText :: FlowCmdM env err m
138 getDataText (ExternalOrigin api) la q li = liftBase $ DataNew
140 <$> API.get api (_tt_lang la) q li
142 getDataText (InternalOrigin _) _la q _li = do
143 (_masterUserId, _masterRootId, cId) <- getOrMk_RootWithCorpus
144 (UserName userMaster)
146 (Nothing :: Maybe HyperdataCorpus)
147 ids <- map fst <$> searchDocInDatabase cId (stemIt q)
150 -------------------------------------------------------------------------------
151 flowDataText :: ( FlowCmdM env err m
157 -> Maybe FlowSocialListWith
160 flowDataText u (DataOld ids) tt cid mfslw _ = flowCorpusUser (_tt_lang tt) u (Right [cid]) corpusType ids mfslw
162 corpusType = (Nothing :: Maybe HyperdataCorpus)
163 flowDataText u (DataNew txt) tt cid mfslw logStatus = flowCorpus u (Right [cid]) tt mfslw txt logStatus
165 ------------------------------------------------------------------------
167 flowAnnuaire :: (FlowCmdM env err m)
169 -> Either CorpusName [CorpusId]
174 flowAnnuaire u n l filePath logStatus = do
175 docs <- liftBase $ (( splitEvery 500 <$> readFile_Annuaire filePath) :: IO [[HyperdataContact]])
176 flow (Nothing :: Maybe HyperdataAnnuaire) u n l Nothing docs logStatus
178 ------------------------------------------------------------------------
179 flowCorpusFile :: (FlowCmdM env err m)
181 -> Either CorpusName [CorpusId]
182 -> Limit -- Limit the number of docs (for dev purpose)
183 -> TermType Lang -> FileFormat -> FilePath
184 -> Maybe FlowSocialListWith
187 flowCorpusFile u n l la ff fp mfslw logStatus = do
188 eParsed <- liftBase $ parseFile ff fp
191 let docs = splitEvery 500 $ take l parsed
192 flowCorpus u n la mfslw (map (map toHyperdataDocument) docs) logStatus
193 Left e -> panic $ "Error: " <> (T.pack e)
195 ------------------------------------------------------------------------
196 -- | TODO improve the needed type to create/update a corpus
197 -- (For now, Either is enough)
198 flowCorpus :: (FlowCmdM env err m, FlowCorpus a)
200 -> Either CorpusName [CorpusId]
202 -> Maybe FlowSocialListWith
206 flowCorpus = flow (Nothing :: Maybe HyperdataCorpus)
209 flow :: ( FlowCmdM env err m
215 -> Either CorpusName [CorpusId]
217 -> Maybe FlowSocialListWith
221 flow c u cn la mfslw docs logStatus = do
222 -- TODO if public insertMasterDocs else insertUserDocs
223 ids <- traverse (\(idx, doc) -> do
224 id <- insertMasterDocs c la doc
225 logStatus JobLog { _scst_succeeded = Just $ 1 + idx
226 , _scst_failed = Just 0
227 , _scst_remaining = Just $ length docs - idx
228 , _scst_events = Just []
232 flowCorpusUser (la ^. tt_lang) u cn c (concat ids) mfslw
237 ------------------------------------------------------------------------
238 flowCorpusUser :: ( FlowCmdM env err m
243 -> Either CorpusName [CorpusId]
246 -> Maybe FlowSocialListWith
248 flowCorpusUser l user corpusName ctype ids mfslw = do
250 (userId, _rootId, userCorpusId) <- getOrMk_RootWithCorpus user corpusName ctype
251 -- NodeTexts is first
252 _tId <- insertDefaultNode NodeTexts userCorpusId userId
253 -- printDebug "NodeTexts: " tId
255 -- NodeList is second
256 listId <- getOrMkList userCorpusId userId
257 -- _cooc <- insertDefaultNode NodeListCooc listId userId
258 -- TODO: check if present already, ignore
259 _ <- Doc.add userCorpusId ids
261 -- printDebug "Node Text Ids:" tId
264 (masterUserId, _masterRootId, masterCorpusId)
265 <- getOrMk_RootWithCorpus (UserName userMaster) (Left "") ctype
267 --let gp = (GroupParams l 2 3 (StopSize 3))
268 -- Here the PosTagAlgo should be chosen according the Lang
269 let gp = GroupWithPosTag l CoreNLP HashMap.empty
270 ngs <- buildNgramsLists user userCorpusId masterCorpusId mfslw gp
272 -- printDebug "flowCorpusUser:ngs" ngs
274 _userListId <- flowList_DbRepo listId ngs
275 _mastListId <- getOrMkList masterCorpusId masterUserId
276 -- _ <- insertOccsUpdates userCorpusId mastListId
277 -- printDebug "userListId" userListId
279 _ <- insertDefaultNode NodeDashboard userCorpusId userId
280 _ <- insertDefaultNode NodeGraph userCorpusId userId
281 --_ <- mkPhylo userCorpusId userId
283 -- _ <- mkAnnuaire rootUserId userId
287 insertMasterDocs :: ( FlowCmdM env err m
295 insertMasterDocs c lang hs = do
296 (masterUserId, _, masterCorpusId) <- getOrMk_RootWithCorpus (UserName userMaster) (Left corpusMasterName) c
297 (ids', documentsWithId) <- insertDocs masterUserId masterCorpusId (map (toNode masterUserId masterCorpusId) hs )
298 _ <- Doc.add masterCorpusId ids'
300 -- create a corpus with database name (CSV or PubMed)
301 -- add documents to the corpus (create node_node link)
302 -- this will enable global database monitoring
304 -- maps :: IO Map Ngrams (Map NgramsType (Map NodeId Int))
305 mapNgramsDocs' :: HashMap ExtractedNgrams (Map NgramsType (Map NodeId Int))
307 <$> documentIdWithNgrams
308 (extractNgramsT $ withLang lang documentsWithId)
311 lId <- getOrMkList masterCorpusId masterUserId
312 _ <- saveDocNgramsWith lId mapNgramsDocs'
314 -- _cooc <- insertDefaultNode NodeListCooc lId masterUserId
317 saveDocNgramsWith :: ( FlowCmdM env err m)
319 -> HashMap ExtractedNgrams (Map NgramsType (Map NodeId Int))
321 saveDocNgramsWith lId mapNgramsDocs' = do
322 terms2id <- insertExtractedNgrams $ HashMap.keys mapNgramsDocs'
323 let mapNgramsDocs = HashMap.mapKeys extracted2ngrams mapNgramsDocs'
326 mapCgramsId <- listInsertDb lId toNodeNgramsW'
327 $ map (first _ngramsTerms . second Map.keys)
328 $ HashMap.toList mapNgramsDocs
330 -- printDebug "saveDocNgramsWith" mapCgramsId
332 _return <- insertContextNodeNgrams2
333 $ catMaybes [ ContextNodeNgrams2 <$> Just nId
334 <*> (getCgramsId mapCgramsId ngrams_type (_ngramsTerms terms''))
335 <*> Just (fromIntegral w :: Double)
336 | (terms'', mapNgramsTypes) <- HashMap.toList mapNgramsDocs
337 , (ngrams_type, mapNodeIdWeight) <- Map.toList mapNgramsTypes
338 , (nId, w) <- Map.toList mapNodeIdWeight
342 _ <- insertDocNgrams lId $ HashMap.mapKeys (indexNgrams terms2id) mapNgramsDocs
347 ------------------------------------------------------------------------
348 -- TODO Type NodeDocumentUnicised
349 insertDocs :: ( FlowCmdM env err m
356 -> m ([ContextId], [Indexed ContextId a])
357 insertDocs uId cId hs = do
358 let docs = map addUniqId hs
359 newIds <- insertDb uId cId docs
360 -- printDebug "newIds" newIds
362 newIds' = map reId newIds
363 documentsWithId = mergeData (toInserted newIds) (Map.fromList $ map viewUniqId' docs)
364 _ <- Doc.add cId newIds'
365 pure (newIds', documentsWithId)
368 ------------------------------------------------------------------------
369 viewUniqId' :: UniqId a
372 viewUniqId' d = maybe err (\h -> (h,d)) (view uniqId d)
374 err = panic "[ERROR] Database.Flow.toInsert"
377 toInserted :: [ReturnId]
380 Map.fromList . map (\r -> (reUniqId r, r) )
381 . filter (\r -> reInserted r == True)
383 mergeData :: Map Hash ReturnId
385 -> [Indexed NodeId a]
386 mergeData rs = catMaybes . map toDocumentWithId . Map.toList
388 toDocumentWithId (sha,hpd) =
389 Indexed <$> fmap reId (lookup sha rs)
392 ------------------------------------------------------------------------
393 ------------------------------------------------------------------------
394 ------------------------------------------------------------------------
395 documentIdWithNgrams :: HasNodeError err
397 -> Cmd err (HashMap b (Map NgramsType Int)))
398 -> [Indexed NodeId a]
399 -> Cmd err [DocumentIdWithNgrams a b]
400 documentIdWithNgrams f = traverse toDocumentIdWithNgrams
402 toDocumentIdWithNgrams d = do
404 pure $ DocumentIdWithNgrams d e
407 -- | TODO check optimization
408 mapNodeIdNgrams :: (Ord b, Hashable b)
409 => [DocumentIdWithNgrams a b]
414 mapNodeIdNgrams = HashMap.unionsWith (Map.unionWith (Map.unionWith (+))) . fmap f
416 f :: DocumentIdWithNgrams a b
417 -> HashMap b (Map NgramsType (Map NodeId Int))
418 f d = fmap (fmap (Map.singleton nId)) $ documentNgrams d
420 nId = _index $ documentWithId d
423 ------------------------------------------------------------------------
424 instance ExtractNgramsT HyperdataContact
426 extractNgramsT l hc = HashMap.mapKeys (cleanExtractedNgrams 255) <$> extract l hc
428 extract :: TermType Lang -> HyperdataContact
429 -> Cmd err (HashMap ExtractedNgrams (Map NgramsType Int))
431 let authors = map text2ngrams
432 $ maybe ["Nothing"] (\a -> [a])
433 $ view (hc_who . _Just . cw_lastName) hc'
435 pure $ HashMap.fromList $ [(SimpleNgrams a', Map.singleton Authors 1) | a' <- authors ]
438 instance ExtractNgramsT HyperdataDocument
440 extractNgramsT :: TermType Lang
442 -> Cmd err (HashMap ExtractedNgrams (Map NgramsType Int))
443 extractNgramsT lang hd = HashMap.mapKeys (cleanExtractedNgrams 255) <$> extractNgramsT' lang hd
445 extractNgramsT' :: TermType Lang
447 -> Cmd err (HashMap ExtractedNgrams (Map NgramsType Int))
448 extractNgramsT' lang' doc = do
449 let source = text2ngrams
450 $ maybe "Nothing" identity
453 institutes = map text2ngrams
454 $ maybe ["Nothing"] (map toSchoolName . (T.splitOn ", "))
457 authors = map text2ngrams
458 $ maybe ["Nothing"] (T.splitOn ", ")
461 terms' <- map (enrichedTerms (lang' ^. tt_lang) CoreNLP NP)
463 <$> liftBase (extractTerms lang' $ hasText doc)
465 pure $ HashMap.fromList
466 $ [(SimpleNgrams source, Map.singleton Sources 1) ]
467 <> [(SimpleNgrams i', Map.singleton Institutes 1) | i' <- institutes ]
468 <> [(SimpleNgrams a', Map.singleton Authors 1) | a' <- authors ]
469 <> [(EnrichedNgrams t', Map.singleton NgramsTerms 1) | t' <- terms' ]
471 instance (ExtractNgramsT a, HasText a) => ExtractNgramsT (Node a)
473 extractNgramsT l (Node _ _ _ _ _ _ _ h) = extractNgramsT l h
475 instance HasText a => HasText (Node a)
477 hasText (Node _ _ _ _ _ _ _ h) = hasText h
481 -- | TODO putelsewhere
482 -- | Upgrade function
483 -- Suppose all documents are English (this is the case actually)
484 indexAllDocumentsWithPosTag :: FlowCmdM env err m
486 indexAllDocumentsWithPosTag = do
487 rootId <- getRootId (UserName userMaster)
488 corpusIds <- findNodesId rootId [NodeCorpus]
489 docs <- List.concat <$> mapM getDocumentsWithParentId corpusIds
490 _ <- mapM extractInsert (splitEvery 1000 docs)
493 extractInsert :: FlowCmdM env err m
494 => [Node HyperdataDocument] -> m ()
495 extractInsert docs = do
496 let documentsWithId = map (\doc -> Indexed (doc ^. node_id) doc) docs
497 mapNgramsDocs' <- mapNodeIdNgrams
498 <$> documentIdWithNgrams
499 (extractNgramsT $ withLang (Multi EN) documentsWithId)
501 _ <- insertExtractedNgrams $ HashMap.keys mapNgramsDocs'