Freckle.App.Database

Database access for your App

Documentation

class HasSqlPool app where

Methods

getSqlPool :: app -> SqlPool

Instances

HasSqlPool SqlPool

Defined in Freckle.App.Database

Methods

getSqlPool :: SqlPool -> SqlPool

HasSqlPool site => HasSqlPool (HandlerData child site)

Defined in Freckle.App.Database

Methods

getSqlPool :: HandlerData child site -> SqlPool

type SqlPool = Pool SqlBackend

makePostgresPool :: (MonadUnliftIO m, MonadLoggerIO m) => m SqlPool

makePostgresPoolWith :: (MonadUnliftIO m, MonadLoggerIO m) => PostgresConnectionConf -> m SqlPool

runDB :: (MonadUnliftIO m, MonadTracer m, MonadReader app m, HasSqlPool app, HasStatsClient app) => SqlPersistT m a -> m a

Run a Database action with connection stats and tracing

runDBSimple :: (HasSqlPool app, MonadUnliftIO m, MonadReader app m) => SqlPersistT m a -> m a

data PostgresConnectionConf

Constructors

PostgresConnectionConf

Fields

• pccHost :: String
• pccPort :: Int
• pccUser :: String
• pccPassword :: PostgresPassword
• pccDatabase :: String
• pccPoolSize :: Int
• pccStatementTimeout :: PostgresStatementTimeout
• pccSchema :: Maybe String

Instances

Show PostgresConnectionConf

Defined in Freckle.App.Database

Methods

showsPrec :: Int -> PostgresConnectionConf -> ShowS

show :: PostgresConnectionConf -> String

showList :: [PostgresConnectionConf] -> ShowS

Eq PostgresConnectionConf

Defined in Freckle.App.Database

Methods

(==) :: PostgresConnectionConf -> PostgresConnectionConf -> Bool

(/=) :: PostgresConnectionConf -> PostgresConnectionConf -> Bool

data PostgresPasswordSource

Constructors

PostgresPasswordSourceIamAuth

PostgresPasswordSourceEnv

Instances

Show PostgresPasswordSource

Defined in Freckle.App.Database

Methods

showsPrec :: Int -> PostgresPasswordSource -> ShowS

show :: PostgresPasswordSource -> String

showList :: [PostgresPasswordSource] -> ShowS

Eq PostgresPasswordSource

Defined in Freckle.App.Database

Methods

(==) :: PostgresPasswordSource -> PostgresPasswordSource -> Bool

(/=) :: PostgresPasswordSource -> PostgresPasswordSource -> Bool

data PostgresPassword

Constructors

PostgresPasswordIamAuth

PostgresPasswordStatic String

Instances

Show PostgresPassword

Defined in Freckle.App.Database

Methods

showsPrec :: Int -> PostgresPassword -> ShowS

show :: PostgresPassword -> String

showList :: [PostgresPassword] -> ShowS

Eq PostgresPassword

Defined in Freckle.App.Database

Methods

(==) :: PostgresPassword -> PostgresPassword -> Bool

(/=) :: PostgresPassword -> PostgresPassword -> Bool

data PostgresStatementTimeout

Constructors

PostgresStatementTimeoutSeconds Int

PostgresStatementTimeoutMilliseconds Int

Instances

Show PostgresStatementTimeout

Defined in Freckle.App.Database

Methods

showsPrec :: Int -> PostgresStatementTimeout -> ShowS

show :: PostgresStatementTimeout -> String

showList :: [PostgresStatementTimeout] -> ShowS

Eq PostgresStatementTimeout

Defined in Freckle.App.Database

Methods

(==) :: PostgresStatementTimeout -> PostgresStatementTimeout -> Bool

(/=) :: PostgresStatementTimeout -> PostgresStatementTimeout -> Bool

postgresStatementTimeoutMilliseconds :: PostgresStatementTimeout -> Int

envParseDatabaseConf :: PostgresPasswordSource -> Parser Error PostgresConnectionConf

envPostgresPasswordSource :: Parser Error PostgresPasswordSource