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.List.Group.WithStem ({-StopSize(..),-} GroupParams(..))
75 import Gargantext.Core.Text.Corpus.Parsers (parseFile, FileFormat)
76 import Gargantext.Core.Text.List (buildNgramsLists)
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.Ngrams
93 import Gargantext.Database.Query.Table.Node
94 import Gargantext.Database.Query.Table.Node.Document.Insert -- (insertDocuments, ReturnId(..), addUniqIdsDoc, addUniqIdsContact, ToDbData(..))
95 import Gargantext.Database.Query.Table.Node.Error (HasNodeError(..))
96 import Gargantext.Database.Query.Table.NodeNgrams (listInsertDb , getCgramsId)
97 import Gargantext.Database.Query.Table.NodeNodeNgrams2
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
234 ------------------------------------------------------------------------
235 flowCorpusUser :: ( FlowCmdM env err m
240 -> Either CorpusName [CorpusId]
243 -> Maybe FlowSocialListWith
245 flowCorpusUser l user corpusName ctype ids mfslw = do
247 (userId, _rootId, userCorpusId) <- getOrMk_RootWithCorpus user corpusName ctype
248 -- NodeTexts is first
249 _tId <- insertDefaultNode NodeTexts userCorpusId userId
250 -- printDebug "NodeTexts: " tId
252 -- NodeList is second
253 listId <- getOrMkList userCorpusId userId
254 -- _cooc <- insertDefaultNode NodeListCooc listId userId
255 -- TODO: check if present already, ignore
256 _ <- Doc.add userCorpusId ids
258 -- printDebug "Node Text Ids:" tId
261 (masterUserId, _masterRootId, masterCorpusId)
262 <- getOrMk_RootWithCorpus (UserName userMaster) (Left "") ctype
264 --let gp = (GroupParams l 2 3 (StopSize 3))
265 let gp = GroupWithPosTag l CoreNLP HashMap.empty
266 ngs <- buildNgramsLists user userCorpusId masterCorpusId mfslw gp
268 _userListId <- flowList_DbRepo listId ngs
269 _mastListId <- getOrMkList masterCorpusId masterUserId
270 -- _ <- insertOccsUpdates userCorpusId mastListId
271 -- printDebug "userListId" userListId
273 _ <- insertDefaultNode NodeDashboard userCorpusId userId
274 _ <- insertDefaultNode NodeGraph userCorpusId userId
275 --_ <- mkPhylo userCorpusId userId
277 -- _ <- mkAnnuaire rootUserId userId
281 insertMasterDocs :: ( FlowCmdM env err m
289 insertMasterDocs c lang hs = do
290 (masterUserId, _, masterCorpusId) <- getOrMk_RootWithCorpus (UserName userMaster) (Left corpusMasterName) c
291 (ids', documentsWithId) <- insertDocs masterUserId masterCorpusId (map (toNode masterUserId masterCorpusId) hs )
292 _ <- Doc.add masterCorpusId ids'
294 -- create a corpus with database name (CSV or PubMed)
295 -- add documents to the corpus (create node_node link)
296 -- this will enable global database monitoring
298 -- maps :: IO Map Ngrams (Map NgramsType (Map NodeId Int))
299 mapNgramsDocs' :: HashMap ExtractedNgrams (Map NgramsType (Map NodeId Int))
301 <$> documentIdWithNgrams
302 (extractNgramsT $ withLang lang documentsWithId)
305 lId <- getOrMkList masterCorpusId masterUserId
306 _ <- saveDocNgramsWith lId mapNgramsDocs'
308 -- _cooc <- insertDefaultNode NodeListCooc lId masterUserId
311 saveDocNgramsWith :: ( FlowCmdM env err m)
313 -> HashMap ExtractedNgrams (Map NgramsType (Map NodeId Int))
315 saveDocNgramsWith lId mapNgramsDocs' = do
316 terms2id <- insertExtractedNgrams $ HashMap.keys mapNgramsDocs'
317 let mapNgramsDocs = HashMap.mapKeys extracted2ngrams mapNgramsDocs'
320 let indexedNgrams = HashMap.mapKeys (indexNgrams terms2id) mapNgramsDocs
323 mapCgramsId <- listInsertDb lId toNodeNgramsW'
324 $ map (first _ngramsTerms . second Map.keys)
325 $ HashMap.toList mapNgramsDocs
328 _return <- insertNodeNodeNgrams2
329 $ catMaybes [ NodeNodeNgrams2 <$> Just nId
330 <*> getCgramsId mapCgramsId ngrams_type (_ngramsTerms terms'')
331 <*> Just (fromIntegral w :: Double)
332 | (terms'', mapNgramsTypes) <- HashMap.toList mapNgramsDocs
333 , (ngrams_type, mapNodeIdWeight) <- Map.toList mapNgramsTypes
334 , (nId, w) <- Map.toList mapNodeIdWeight
337 _ <- insertDocNgrams lId indexedNgrams
342 ------------------------------------------------------------------------
343 -- TODO Type NodeDocumentUnicised
344 insertDocs :: ( FlowCmdM env err m
351 -> m ([DocId], [Indexed NodeId a])
352 insertDocs uId cId hs = do
353 let docs = map addUniqId hs
354 newIds <- insertDb uId cId docs
355 -- printDebug "newIds" newIds
357 newIds' = map reId newIds
358 documentsWithId = mergeData (toInserted newIds) (Map.fromList $ map viewUniqId' docs)
359 _ <- Doc.add cId newIds'
360 pure (newIds', documentsWithId)
363 ------------------------------------------------------------------------
364 viewUniqId' :: UniqId a
367 viewUniqId' d = maybe err (\h -> (h,d)) (view uniqId d)
369 err = panic "[ERROR] Database.Flow.toInsert"
372 toInserted :: [ReturnId]
375 Map.fromList . map (\r -> (reUniqId r, r) )
376 . filter (\r -> reInserted r == True)
378 mergeData :: Map Hash ReturnId
380 -> [Indexed NodeId a]
381 mergeData rs = catMaybes . map toDocumentWithId . Map.toList
383 toDocumentWithId (sha,hpd) =
384 Indexed <$> fmap reId (lookup sha rs)
387 ------------------------------------------------------------------------
388 ------------------------------------------------------------------------
389 ------------------------------------------------------------------------
390 documentIdWithNgrams :: HasNodeError err
392 -> Cmd err (HashMap b (Map NgramsType Int)))
393 -> [Indexed NodeId a]
394 -> Cmd err [DocumentIdWithNgrams a b]
395 documentIdWithNgrams f = traverse toDocumentIdWithNgrams
397 toDocumentIdWithNgrams d = do
399 pure $ DocumentIdWithNgrams d e
402 -- | TODO check optimization
403 mapNodeIdNgrams :: (Ord b, Hashable b)
404 => [DocumentIdWithNgrams a b]
409 mapNodeIdNgrams = HashMap.unionsWith (Map.unionWith (Map.unionWith (+))) . fmap f
411 f :: DocumentIdWithNgrams a b
412 -> HashMap b (Map NgramsType (Map NodeId Int))
413 f d = fmap (fmap (Map.singleton nId)) $ documentNgrams d
415 nId = _index $ documentWithId d
418 ------------------------------------------------------------------------
419 instance ExtractNgramsT HyperdataContact
421 extractNgramsT l hc = HashMap.mapKeys (cleanExtractedNgrams 255) <$> extract l hc
423 extract :: TermType Lang -> HyperdataContact
424 -> Cmd err (HashMap ExtractedNgrams (Map NgramsType Int))
426 let authors = map text2ngrams
427 $ maybe ["Nothing"] (\a -> [a])
428 $ view (hc_who . _Just . cw_lastName) hc'
430 pure $ HashMap.fromList $ [(SimpleNgrams a', Map.singleton Authors 1) | a' <- authors ]
433 instance ExtractNgramsT HyperdataDocument
435 extractNgramsT :: TermType Lang
437 -> Cmd err (HashMap ExtractedNgrams (Map NgramsType Int))
438 extractNgramsT lang hd = HashMap.mapKeys (cleanExtractedNgrams 255) <$> extractNgramsT' lang hd
440 extractNgramsT' :: TermType Lang
442 -> Cmd err (HashMap ExtractedNgrams (Map NgramsType Int))
443 extractNgramsT' lang' doc = do
444 let source = text2ngrams
445 $ maybe "Nothing" identity
448 institutes = map text2ngrams
449 $ maybe ["Nothing"] (map toSchoolName . (T.splitOn ", "))
452 authors = map text2ngrams
453 $ maybe ["Nothing"] (T.splitOn ", ")
456 terms' <- map (enrichedTerms (lang' ^. tt_lang) CoreNLP NP)
458 <$> liftBase (extractTerms lang' $ hasText doc)
460 pure $ HashMap.fromList
461 $ [(SimpleNgrams source, Map.singleton Sources 1) ]
462 <> [(SimpleNgrams i', Map.singleton Institutes 1) | i' <- institutes ]
463 <> [(SimpleNgrams a', Map.singleton Authors 1) | a' <- authors ]
464 <> [(EnrichedNgrams t', Map.singleton NgramsTerms 1) | t' <- terms' ]
466 instance (ExtractNgramsT a, HasText a) => ExtractNgramsT (Node a)
468 extractNgramsT l (Node _ _ _ _ _ _ _ h) = extractNgramsT l h
470 instance HasText a => HasText (Node a)
472 hasText (Node _ _ _ _ _ _ _ h) = hasText h
476 -- | TODO putelsewhere
477 -- | Upgrade function
478 -- Suppose all documents are English (this is the case actually)
479 indexAllDocumentsWithPosTag :: FlowCmdM env err m => m ()
480 indexAllDocumentsWithPosTag = do
481 rootId <- getRootId (UserName userMaster)
482 corpusIds <- findNodesId rootId [NodeCorpus]
483 docs <- List.concat <$> mapM getDocumentsWithParentId corpusIds
485 _ <- mapM extractInsert (splitEvery 1000 docs)
489 extractInsert :: FlowCmdM env err m => [Node HyperdataDocument] -> m ()
490 extractInsert docs = do
491 let documentsWithId = map (\doc -> Indexed (doc ^. node_id) doc) docs
493 mapNgramsDocs' <- mapNodeIdNgrams
494 <$> documentIdWithNgrams
495 (extractNgramsT $ withLang (Multi EN) documentsWithId)
498 _ <- insertExtractedNgrams $ HashMap.keys mapNgramsDocs'