Database.Groundhog.Postgresql

Documentation

withPostgresqlPool

Arguments

:: (MonadBaseControl IO m, MonadIO m)

=> String

connection string

-> Int

number of connections to open

-> (Pool Postgresql -> m a)

-> m a

withPostgresqlConn

Arguments

:: (MonadBaseControl IO m, MonadIO m)

=> String

connection string

-> (Postgresql -> m a)

-> m a

createPostgresqlPool

Arguments

:: MonadIO m

=> String

connection string

-> Int

number of connections to open

-> m (Pool Postgresql)

runDbConn :: (MonadBaseControl IO m, MonadIO m, ConnectionManager cm conn) => DbPersist conn (NoLoggingT m) a -> cm -> m a

Runs action within connection. It can handle a simple connection, a pool of them, etc.

newtype Postgresql

Constructors

Postgresql Connection

Instances

SqlDb Postgresql

FloatingSqlDb Postgresql

DbDescriptor Postgresql

Savepoint Postgresql

ConnectionManager Postgresql Postgresql

SingleConnectionManager Postgresql Postgresql

ConnectionManager (Pool Postgresql) Postgresql

(MonadBaseControl IO m, MonadIO m, MonadLogger m) => SchemaAnalyzer (DbPersist Postgresql m)

(MonadBaseControl IO m, MonadIO m, MonadLogger m) => PersistBackend (DbPersist Postgresql m)

type QueryRaw Postgresql = Snippet Postgresql

type AutoKeyType Postgresql = Int64

type PhantomDb (DbPersist Postgresql m) = Postgresql

module Database.Groundhog

module Database.Groundhog.Generic.Sql.Functions

explicitType :: (Expression Postgresql r a, PersistField a) => a -> Expr Postgresql r a

Put explicit type for expression. It is useful for values which are defaulted to a wrong type. For example, a literal Int from a 64bit machine can be defaulted to a 32bit int by Postgresql. Also a value entered as an external string (geometry, arrays and other complex types have this representation) may need an explicit type.

castType :: Expression Postgresql r a => a -> String -> Expr Postgresql r a

Casts expression to a type. castType value "INT" results in value::INT.

distinctOn :: (db ~ Postgresql, HasSelectOptions a db r, HasDistinct a ~ HFalse, Projection' p db r p') => a -> p -> SelectOptions db r (HasLimit a) (HasOffset a) (HasOrder a) HTrue

Distinct only on certain fields or expressions. For example, select $ CondEmpty distinctOn (lower EmailField, IpField).

showSqlType :: DbTypePrimitive -> String