{-| Module : Gargantext.Database.user Description : User Database management tools Copyright : (c) CNRS, 2017-Present License : AGPL + CECILL v3 Maintainer : team@gargantext.org Stability : experimental Portability : POSIX Functions to deal with users, database side. -} {-# OPTIONS_GHC -fno-warn-orphans #-} {-# LANGUAGE DeriveAnyClass #-} {-# LANGUAGE FunctionalDependencies #-} {-# LANGUAGE Arrows #-} {-# LANGUAGE TemplateHaskell #-} module Gargantext.Database.Schema.User where import Data.Morpheus.Types (GQLType(typeOptions)) import Data.Text (Text) import Data.Time (UTCTime) import qualified Gargantext.API.GraphQL.Utils as GAGU import Gargantext.Core.Utils.Prefix (unPrefix) import Gargantext.Core.Types.Individu (GargPassword, toGargPassword) import Gargantext.Database.Prelude (fromField') import Gargantext.Prelude import GHC.Generics (Generic) import Database.PostgreSQL.Simple.FromField (FromField, fromField) import Data.Aeson.TH (deriveJSON) -- FIXME PLZ : the import below leads to an error, why ? -- import Gargantext.Database.Schema.Prelude hiding (makeLensesWith, abbreviatedFields, makeAdaptorAndInstance) -- When FIXED : Imports to remove: import Control.Lens.TH (makeLensesWith, abbreviatedFields) import Data.Profunctor.Product.TH (makeAdaptorAndInstance) import Opaleye hiding (FromField) import Opaleye.Internal.Table (Table(..)) ------------------------------------------------------------------------ data UserLight = UserLight { userLight_id :: !Int , userLight_username :: !Text , userLight_email :: !Text , userLight_password :: !GargPassword , userLight_forgot_password_uuid :: !(Maybe Text) } deriving (Show, Generic) instance GQLType UserLight where typeOptions _ = GAGU.unPrefix "userLight_" toUserLight :: UserDB -> UserLight toUserLight (UserDB { user_id , user_password , user_username , user_email }) = UserLight { userLight_id = user_id , userLight_username = user_username , userLight_email = user_email , userLight_password = toGargPassword user_password , userLight_forgot_password_uuid = Nothing } data UserPoly id pass llogin suser uname fname lname mail staff active djoined fpuuid = UserDB { user_id :: !id , user_password :: !pass , user_lastLogin :: !llogin , user_isSuperUser :: !suser , user_username :: !uname , user_firstName :: !fname , user_lastName :: !lname , user_email :: !mail , user_isStaff :: !staff , user_isActive :: !active , user_dateJoined :: !djoined , user_forgot_password_uuid :: !fpuuid } deriving (Show, Generic) type UserWrite = UserPoly (Maybe (Column SqlInt4)) (Column SqlText) (Maybe (Column SqlTimestamptz)) (Column SqlBool) (Column SqlText) (Column SqlText) (Column SqlText) (Column SqlText) (Column SqlBool) (Column SqlBool) (Maybe (Column SqlTimestamptz)) (Maybe (Column SqlText)) type UserRead = UserPoly (Column SqlInt4) (Column SqlText) (Column SqlTimestamptz) (Column SqlBool) (Column SqlText) (Column SqlText) (Column SqlText) (Column SqlText) (Column SqlBool) (Column SqlBool) (Column SqlTimestamptz) (Column SqlText) type UserReadNull = UserPoly (Column (Nullable SqlInt4)) (Column (Nullable SqlText)) (Column (Nullable SqlTimestamptz)) (Column (Nullable SqlBool)) (Column (Nullable SqlText)) (Column (Nullable SqlText)) (Column (Nullable SqlText)) (Column (Nullable SqlText)) (Column (Nullable SqlBool)) (Column (Nullable SqlBool)) (Column (Nullable SqlTimestamptz)) (Column (Nullable SqlText)) type UserDB = UserPoly Int Text (Maybe UTCTime) Bool Text Text Text Text Bool Bool UTCTime (Maybe Text) $(makeAdaptorAndInstance "pUserDB" ''UserPoly) $(makeLensesWith abbreviatedFields ''UserPoly) userTable :: Table UserWrite UserRead userTable = Table "auth_user" (pUserDB UserDB { user_id = optionalTableField "id" , user_password = requiredTableField "password" , user_lastLogin = optionalTableField "last_login" , user_isSuperUser = requiredTableField "is_superuser" , user_username = requiredTableField "username" , user_firstName = requiredTableField "first_name" , user_lastName = requiredTableField "last_name" , user_email = requiredTableField "email" , user_isStaff = requiredTableField "is_staff" , user_isActive = requiredTableField "is_active" , user_dateJoined = optionalTableField "date_joined" , user_forgot_password_uuid = optionalTableField "forgot_password_uuid" } ) instance FromField UserLight where fromField = fromField' instance FromField UserDB where fromField = fromField' $(deriveJSON (unPrefix "userLight_") ''UserLight) $(deriveJSON (unPrefix "user_") ''UserPoly)