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
12 {-# LANGUAGE QuasiQuotes #-}
13 {-# LANGUAGE Arrows #-}
15 module Gargantext.Database.Action.Flow.Pairing
19 import Control.Lens (_Just, (^.))
20 import Data.Map (Map, fromList, fromListWith)
21 import Data.Maybe (catMaybes, fromMaybe)
23 import Data.Text (Text)
24 import Gargantext.API.Ngrams.Tools
25 import Gargantext.API.Prelude (GargNoServer)
26 import Gargantext.Core.Types (TableResult(..), Term)
27 import Gargantext.Core.Types.Main
28 import Gargantext.Database
29 import Gargantext.Database.Action.Metrics.NgramsByNode (getNodesByNgramsOnlyUser)
30 import Gargantext.Database.Admin.Config
31 import Gargantext.Database.Admin.Config (nodeTypeId)
32 import Gargantext.Database.Admin.Types.Hyperdata -- (HyperdataContact(..))
33 import Gargantext.Database.Admin.Types.Node -- (AnnuaireId, CorpusId, ListId, DocId, ContactId, NodeId)
34 import Gargantext.Database.Prelude (Cmd, runOpaQuery)
35 import Gargantext.Database.Query.Prelude (leftJoin2, returnA, queryNodeNodeTable)
36 import Gargantext.Database.Query.Table.Node.Children (getAllContacts)
37 import Gargantext.Database.Query.Table.Node.Select (selectNodesWithUsername)
38 import Gargantext.Database.Query.Table.Node (defaultList)
39 import Gargantext.Database.Schema.Ngrams -- (NgramsType(..))
40 import Gargantext.Database.Schema.Node
41 import Gargantext.Prelude hiding (sum)
44 import qualified Data.List as List
45 import qualified Data.Map as Map
46 import qualified Data.Set as Set
47 import qualified Data.Text as DT
51 -- All NodeAnnuaire paired with a Corpus of NodeId nId:
52 -- isPairedWith NodeAnnuaire corpusId
53 isPairedWith :: NodeType -> NodeId -> Cmd err [NodeId]
54 isPairedWith nt nId = runOpaQuery (selectQuery nt nId)
56 selectQuery :: NodeType -> NodeId -> Query (Column PGInt4)
57 selectQuery nt' nId' = proc () -> do
58 (node, node_node) <- queryJoin -< ()
59 restrict -< (node^.node_typename) .== (pgInt4 $ nodeTypeId nt')
60 restrict -< (node_node^.nn_node1_id) .== (toNullable $ pgNodeId nId')
61 returnA -< node^.node_id
63 queryJoin :: Query (NodeRead, NodeNodeReadNull)
64 queryJoin = leftJoin2 queryNodeTable queryNodeNodeTable cond
66 cond (node, node_node) = node^.node_id .== node_node^. nn_node2_id
68 -----------------------------------------------------------------------
69 pairing :: AnnuaireId -> CorpusId -> Maybe ListId -> GargNoServer Int
72 Nothing -> defaultList c
74 dataPaired <- dataPairing a (c,l,Authors) takeName takeName
75 insertDB $ prepareInsert dataPaired
78 dataPairing :: AnnuaireId
79 -> (CorpusId, ListId, NgramsType)
80 -> (ContactName -> Projected)
81 -> (DocAuthor -> Projected)
82 -> GargNoServer (Map ContactId (Set DocId))
83 dataPairing aId (cId, lId, ngt) fc fa = do
84 mc <- getNgramsContactId aId
85 md <- getNgramsDocId cId lId ngt
87 printDebug "ngramsContactId" mc
88 printDebug "ngramsDocId" md
90 from = projectionFrom (Set.fromList $ Map.keys mc) fc
91 to = projectionTo (Set.fromList $ Map.keys md) fa
93 pure $ fusion mc $ align from to md
97 prepareInsert :: Map ContactId (Set DocId) -> [NodeNode]
98 prepareInsert m = map (\(n1,n2) -> NodeNode n1 n2 Nothing Nothing)
100 $ map (\(contactId, setDocIds)
102 -> (contactId, setDocId)
103 ) $ Set.toList setDocIds
107 ------------------------------------------------------------------------
108 type ContactName = Text
109 type DocAuthor = Text
110 type Projected = Text
112 projectionFrom :: Set ContactName -> (ContactName -> Projected) -> Map ContactName Projected
113 projectionFrom ss f = fromList $ map (\s -> (s, f s)) (Set.toList ss)
115 projectionTo :: Set DocAuthor -> (DocAuthor -> Projected) -> Map Projected (Set DocAuthor)
116 projectionTo ss f = fromListWith (<>) $ map (\s -> (f s, Set.singleton s)) (Set.toList ss)
117 ------------------------------------------------------------------------
118 takeName :: Term -> Term
119 takeName texte = DT.toLower texte'
121 texte' = maybe texte (\x -> if DT.length x > 3 then x else texte)
123 lastName' = lastMay . DT.splitOn " "
126 ------------------------------------------------------------------------
127 align :: Map ContactName Projected
128 -> Map Projected (Set DocAuthor)
129 -> Map DocAuthor (Set DocId)
130 -> Map ContactName (Set DocId)
131 align mc ma md = fromListWith (<>)
132 $ map (\c -> (c, getProjection md $ testProjection c mc ma))
135 getProjection :: Map DocAuthor (Set DocId) -> Set DocAuthor -> Set DocId
136 getProjection ma' sa' =
139 else Set.unions $ sets ma' sa'
141 sets ma'' sa'' = Set.map (\s -> lookup s ma'') sa''
142 lookup s' ma''= fromMaybe Set.empty (Map.lookup s' ma'')
144 testProjection :: ContactName
145 -> Map ContactName Projected
146 -> Map Projected (Set DocAuthor)
148 testProjection cn' mc' ma' = case Map.lookup cn' mc' of
150 Just c -> case Map.lookup c ma' of
154 fusion :: Map ContactName (Set ContactId)
155 -> Map ContactName (Set DocId)
156 -> Map ContactId (Set DocId)
157 fusion mc md = Map.fromListWith (<>)
159 $ [ (,) <$> Just cId <*> Map.lookup cn md
160 | (cn, setContactId) <- Map.toList mc
161 , cId <- Set.toList setContactId
163 ------------------------------------------------------------------------
165 getNgramsContactId :: AnnuaireId
166 -> Cmd err (Map ContactName (Set NodeId))
167 getNgramsContactId aId = do
168 contacts <- getAllContacts aId
169 pure $ fromListWith (<>)
171 $ map (\contact -> (,) <$> contact^.(node_hyperdata . hc_who . _Just . cw_lastName)
172 <*> Just ( Set.singleton (contact^.node_id))
176 getNgramsDocId :: CorpusId
179 -> GargNoServer (Map DocAuthor (Set NodeId))
180 getNgramsDocId cId lId nt = do
182 lIds <- selectNodesWithUsername NodeList userMaster
183 let ngs = filterListWithRoot MapTerm $ mapTermListRoot [lId] nt repo
185 groupNodesByNgrams ngs
186 <$> getNodesByNgramsOnlyUser cId (lIds <> [lId]) nt (Map.keys ngs)