src/Gargantext/Database/Schema/Node_NodeNgramsNodeNgrams.hs

   1 {-|
   2 Module      : Gargantext.Database.Schema.Node_NodeNgrams_NodeNgrams
   3 Description :
   4 Copyright   : (c) CNRS, 2017-Present
   5 License     : AGPL + CECILL v3
   6 Maintainer  : team@gargantext.org
   7 Stability   : experimental
   8 Portability : POSIX
   9
  10 lgrams: listed ngrams
  11
  12 Node_NodeNgrams_NodeNgrams table is used to group ngrams
  13 - first NodeId :: Referential / space node (corpus)
  14 - NodeNgrams where Node is List
  15     - lgrams1_id, lgrams2_id where all lgrams2_id will be added to lgrams1_id
  16 - weight: score the relation
  17
  18 Next Step benchmark:
  19 - recursive queries of postgres
  20 - group with: https://en.wikipedia.org/wiki/Nested_set_model
  21
  22 -}
  23
  24 {-# OPTIONS_GHC -fno-warn-orphans   #-}
  25
  26 {-# LANGUAGE Arrows                 #-}
  27 {-# LANGUAGE FunctionalDependencies #-}
  28 {-# LANGUAGE QuasiQuotes            #-}
  29 {-# LANGUAGE TemplateHaskell        #-}
  30
  31 module Gargantext.Database.Schema.Node_NodeNgramsNodeNgrams
  32   where
  33
  34 import Gargantext.Database.Schema.Prelude
  35 import Gargantext.Database.Admin.Types.Node (CorpusId)
  36 import Gargantext.Database.Schema.Node()
  37 import Gargantext.Prelude
  38
  39 data Node_NodeNgrams_NodeNgrams_Poly node_id nng1_id nng2_id weight =
  40   Node_NodeNgrams_NodeNgrams { _nnn_node_id :: !node_id
  41                              , _nnn_nng1_id :: !nng1_id
  42                              , _nnn_nng2_id :: !nng2_id
  43                              , _nnn_weight  :: !weight
  44                              } deriving (Show)
  45
  46 type Node_NodeNgrams_NodeNgrams_Write =
  47   Node_NodeNgrams_NodeNgrams_Poly
  48     (Column SqlInt4          )
  49     (Maybe (Column SqlInt4  ))
  50     (Column SqlInt4          )
  51     (Maybe (Column SqlFloat8))
  52
  53 type Node_NodeNgrams_NodeNgrams_Read  =
  54   Node_NodeNgrams_NodeNgrams_Poly
  55     (Column SqlInt4  )
  56     (Column SqlInt4  )
  57     (Column SqlInt4  )
  58     (Column SqlFloat8)
  59
  60 type ListNgramsId = Int
  61
  62 type Node_NodeNgrams_NodeNgrams =
  63   Node_NodeNgrams_NodeNgrams_Poly CorpusId (Maybe ListNgramsId) ListNgramsId (Maybe Double)
  64
  65 $(makeAdaptorAndInstance "pNode_NodeNgrams_NodeNgrams"
  66                          ''Node_NodeNgrams_NodeNgrams_Poly)
  67 $(makeLensesWith abbreviatedFields
  68                          ''Node_NodeNgrams_NodeNgrams_Poly)
  69
  70
  71 node_NodeNgrams_NodeNgrams_Table :: Table Node_NodeNgrams_NodeNgrams_Write Node_NodeNgrams_NodeNgrams_Read
  72 node_NodeNgrams_NodeNgrams_Table =
  73   Table "node_nodengrams_nodengrams"
  74        ( pNode_NodeNgrams_NodeNgrams Node_NodeNgrams_NodeNgrams
  75                        { _nnn_node_id = requiredTableField "node_id"
  76                        , _nnn_nng1_id = optionalTableField "node_ngrams1_id"
  77                        , _nnn_nng2_id = requiredTableField "node_ngrams2_id"
  78                        , _nnn_weight  = optionalTableField "weight"
  79                        }
  80        )
  81
  82 instance DefaultFromField SqlInt4 (Maybe Int) where
  83     defaultFromField = fromPGSFromField
  84
  85 instance DefaultFromField SqlFloat8 (Maybe Double) where
  86     defaultFromField = fromPGSFromField
  87