Squeal.PostgreSQL.PQ

This module is where Squeal commands actually get executed by LibPQ. It containts two typeclasses, IndexedMonadTransPQ for executing a Definition and MonadPQ for executing a Manipulation or Query, and a PQ type with instances for them.

Using Squeal in your application will come down to defining the schema of your database and including PQ schema schema in your application's monad transformer stack, giving it an instance of MonadPQ.

This module also provides functions for retrieving rows from the Result of executing Squeal commands.

Connection

data Connection

Connection encapsulates a connection to the backend.

Instances

Eq Connection

Defined in Database.PostgreSQL.LibPQ.Internal

Methods

(==) :: Connection -> Connection -> Bool

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

connectdb

Arguments

:: MonadBase IO io

=> ByteString

conninfo

-> io (K Connection schema)

Makes a new connection to the database server.

This function opens a new database connection using the parameters taken from the string conninfo.

The passed string can be empty to use all default parameters, or it can contain one or more parameter settings separated by whitespace. Each parameter setting is in the form keyword = value. Spaces around the equal sign are optional. To write an empty value or a value containing spaces, surround it with single quotes, e.g., keyword = 'a value'. Single quotes and backslashes within the value must be escaped with a backslash, i.e., ' and .

To specify the schema you wish to connect with, use type application.

>>> :set -XDataKinds
>>> :set -XPolyKinds
>>> :set -XTypeOperators
>>> type Schema = '["tab" ::: '[] :=> '["col" ::: 'NoDef :=> 'Null 'PGint2]]
>>> :set -XTypeApplications
>>> :set -XOverloadedStrings
>>> conn <- connectdb @Schema "host=localhost port=5432 dbname=exampledb"

Note that, for now, squeal doesn't offer any protection from connecting with the wrong schema!

finish :: MonadBase IO io => K Connection schema -> io ()

Closes the connection to the server.

withConnection :: forall schema0 schema1 io x. MonadBaseControl IO io => ByteString -> PQ schema0 schema1 io x -> io x

Do connectdb and finish before and after a computation.

lowerConnection :: K Connection (table ': schema) -> K Connection schema

Safely lowerConnection to a smaller schema.

PQ

newtype PQ (schema0 :: SchemaType) (schema1 :: SchemaType) (m :: Type -> Type) (x :: Type)

We keep track of the schema via an Atkey indexed state monad transformer, PQ.

Constructors

PQ

Fields

• unPQ :: K Connection schema0 -> m (K x schema1)

Instances

IndexedMonadTransPQ PQ

Defined in Squeal.PostgreSQL.PQ

Methods

pqAp :: Monad m => PQ schema0 schema1 m (x -> y) -> PQ schema1 schema2 m x -> PQ schema0 schema2 m y

pqJoin :: Monad m => PQ schema0 schema1 m (PQ schema1 schema2 m y) -> PQ schema0 schema2 m y

pqBind :: Monad m => (x -> PQ schema1 schema2 m y) -> PQ schema0 schema1 m x -> PQ schema0 schema2 m y

pqThen :: Monad m => PQ schema1 schema2 m y -> PQ schema0 schema1 m x -> PQ schema0 schema2 m y

pqAndThen :: Monad m => (y -> PQ schema1 schema2 m z) -> (x -> PQ schema0 schema1 m y) -> x -> PQ schema0 schema2 m z

pqEmbed :: Monad m => PQ schema0 schema1 m x -> PQ (table ': schema0) (table ': schema1) m x

define :: MonadBase IO io => Definition schema0 schema1 -> PQ schema0 schema1 io (K Result [])

schema0 ~ schema1 => MFunctor (PQ schema0 schema1 :: (Type -> Type) -> Type -> *)

Defined in Squeal.PostgreSQL.PQ

Methods

hoist :: Monad m => (forall a. m a -> n a) -> PQ schema0 schema1 m b -> PQ schema0 schema1 n b

(MonadBase b m, schema0 ~ schema1) => MonadBase b (PQ schema0 schema1 m)

Defined in Squeal.PostgreSQL.PQ

Methods

liftBase :: b α -> PQ schema0 schema1 m α

(MonadBaseControl b m, schema0 ~ schema1) => MonadBaseControl b (PQ schema0 schema1 m)

Defined in Squeal.PostgreSQL.PQ

Associated Types

type StM (PQ schema0 schema1 m) a :: *

Methods

liftBaseWith :: (RunInBase (PQ schema0 schema1 m) b -> b a) -> PQ schema0 schema1 m a

restoreM :: StM (PQ schema0 schema1 m) a -> PQ schema0 schema1 m a

(MonadBase IO io, schema0 ~ schema, schema1 ~ schema) => MonadPQ schema (PQ schema0 schema1 io)

Defined in Squeal.PostgreSQL.PQ

Methods

manipulateParams :: ToParams x params => Manipulation schema params ys -> x -> PQ schema0 schema1 io (K Result ys)

manipulate :: Manipulation schema [] ys -> PQ schema0 schema1 io (K Result ys)

runQueryParams :: ToParams x params => Query schema params ys -> x -> PQ schema0 schema1 io (K Result ys)

runQuery :: Query schema [] ys -> PQ schema0 schema1 io (K Result ys)

traversePrepared :: (ToParams x params, Traversable list) => Manipulation schema params ys -> list x -> PQ schema0 schema1 io (list (K Result ys))

forPrepared :: (ToParams x params, Traversable list) => list x -> Manipulation schema params ys -> PQ schema0 schema1 io (list (K Result ys))

traversePrepared_ :: (ToParams x params, Foldable list) => Manipulation schema params [] -> list x -> PQ schema0 schema1 io ()

forPrepared_ :: (ToParams x params, Foldable list) => list x -> Manipulation schema params [] -> PQ schema0 schema1 io ()

liftPQ :: (Connection -> IO a) -> PQ schema0 schema1 io a

schema0 ~ schema1 => MonadTrans (PQ schema0 schema1)

Defined in Squeal.PostgreSQL.PQ

Methods

lift :: Monad m => m a -> PQ schema0 schema1 m a

schema0 ~ schema1 => MMonad (PQ schema0 schema1)

Defined in Squeal.PostgreSQL.PQ

Methods

embed :: Monad n => (forall a. m a -> PQ schema0 schema1 n a) -> PQ schema0 schema1 m b -> PQ schema0 schema1 n b

(Monad m, schema0 ~ schema1) => Monad (PQ schema0 schema1 m)

Defined in Squeal.PostgreSQL.PQ

Methods

(>>=) :: PQ schema0 schema1 m a -> (a -> PQ schema0 schema1 m b) -> PQ schema0 schema1 m b

(>>) :: PQ schema0 schema1 m a -> PQ schema0 schema1 m b -> PQ schema0 schema1 m b

return :: a -> PQ schema0 schema1 m a

fail :: String -> PQ schema0 schema1 m a

Monad m => Functor (PQ schema0 schema1 m)

Defined in Squeal.PostgreSQL.PQ

Methods

fmap :: (a -> b) -> PQ schema0 schema1 m a -> PQ schema0 schema1 m b

(<$) :: a -> PQ schema0 schema1 m b -> PQ schema0 schema1 m a

(Monad m, schema0 ~ schema1) => Applicative (PQ schema0 schema1 m)

Defined in Squeal.PostgreSQL.PQ

Methods

pure :: a -> PQ schema0 schema1 m a

(<*>) :: PQ schema0 schema1 m (a -> b) -> PQ schema0 schema1 m a -> PQ schema0 schema1 m b

liftA2 :: (a -> b -> c) -> PQ schema0 schema1 m a -> PQ schema0 schema1 m b -> PQ schema0 schema1 m c

(*>) :: PQ schema0 schema1 m a -> PQ schema0 schema1 m b -> PQ schema0 schema1 m b

(<*) :: PQ schema0 schema1 m a -> PQ schema0 schema1 m b -> PQ schema0 schema1 m a

type StM (PQ schema0 schema1 m) x

Defined in Squeal.PostgreSQL.PQ

type StM (PQ schema0 schema1 m) x = StM m (K x schema0)

runPQ :: Functor m => PQ schema0 schema1 m x -> K Connection schema0 -> m (x, K Connection schema1)

Run a PQ and keep the result and the Connection.

execPQ :: Functor m => PQ schema0 schema1 m x -> K Connection schema0 -> m (K Connection schema1)

Execute a PQ and discard the result but keep the Connection.

evalPQ :: Functor m => PQ schema0 schema1 m x -> K Connection schema0 -> m x

Evaluate a PQ and discard the Connection but keep the result.

class IndexedMonadTransPQ pq where

An Atkey indexed monad is a Functor enriched category. An indexed monad transformer transforms a Monad into an indexed monad. And, IndexedMonadTransPQ is a class for indexed monad transformers that support running Definitions using define and embedding a computation in a larger schema using pqEmbed.

Minimal complete definition

pqAp, pqBind, pqEmbed, define

Methods

pqAp :: Monad m => pq schema0 schema1 m (x -> y) -> pq schema1 schema2 m x -> pq schema0 schema2 m y

indexed analog of <*>

pqJoin :: Monad m => pq schema0 schema1 m (pq schema1 schema2 m y) -> pq schema0 schema2 m y

indexed analog of join

pqBind :: Monad m => (x -> pq schema1 schema2 m y) -> pq schema0 schema1 m x -> pq schema0 schema2 m y

indexed analog of =<<

pqThen :: Monad m => pq schema1 schema2 m y -> pq schema0 schema1 m x -> pq schema0 schema2 m y

indexed analog of flipped >>

pqAndThen :: Monad m => (y -> pq schema1 schema2 m z) -> (x -> pq schema0 schema1 m y) -> x -> pq schema0 schema2 m z

indexed analog of <=<

pqEmbed :: Monad m => pq schema0 schema1 m x -> pq (table ': schema0) (table ': schema1) m x

Safely embed a computation in a larger schema.

define :: MonadBase IO io => Definition schema0 schema1 -> pq schema0 schema1 io (K Result '[])

Run a Definition with exec, we expect that libpq obeys the law

define statement1 & pqThen (define statement2) = define (statement1 >>> statement2)

Instances

IndexedMonadTransPQ PQ

Defined in Squeal.PostgreSQL.PQ

Methods

pqAp :: Monad m => PQ schema0 schema1 m (x -> y) -> PQ schema1 schema2 m x -> PQ schema0 schema2 m y

pqJoin :: Monad m => PQ schema0 schema1 m (PQ schema1 schema2 m y) -> PQ schema0 schema2 m y

pqBind :: Monad m => (x -> PQ schema1 schema2 m y) -> PQ schema0 schema1 m x -> PQ schema0 schema2 m y

pqThen :: Monad m => PQ schema1 schema2 m y -> PQ schema0 schema1 m x -> PQ schema0 schema2 m y

pqAndThen :: Monad m => (y -> PQ schema1 schema2 m z) -> (x -> PQ schema0 schema1 m y) -> x -> PQ schema0 schema2 m z

pqEmbed :: Monad m => PQ schema0 schema1 m x -> PQ (table ': schema0) (table ': schema1) m x

define :: MonadBase IO io => Definition schema0 schema1 -> PQ schema0 schema1 io (K Result [])

class Monad pq => MonadPQ schema pq | pq -> schema where

MonadPQ is an mtl style constraint, similar to MonadState, for using LibPQ to

• manipulateParams runs a Manipulation with params from a type with a ToParams constraint. It calls execParams and doesn't afraid of anything.
• manipulate is like manipulateParams for a parameter-free statement.
• runQueryParams is like manipulateParams for query statements.
• runQuery is like runQueryParams for a parameter-free statement.
• traversePrepared has the same type signature as a composition of traverse and manipulateParams but provides an optimization by preparing the statement with prepare and then traversing a Traversable container with execPrepared. The temporary prepared statement is then deallocated.
• forPrepared is a flipped traversePrepared
• traversePrepared_ is like traversePrepared but works on Foldable containers and returns unit.
• forPrepared_ is a flipped traversePrepared_.
• liftPQ lets you lift actions from LibPQ that require a connection into your monad.

To define an instance, you can minimally define only manipulateParams, traversePrepared, traversePrepared_ and liftPQ. Monad transformers get a default instance.

Methods

manipulateParams

Arguments

:: ToParams x params

=> Manipulation schema params ys

insertRows, update or deleteFrom

-> x

-> pq (K Result ys)

manipulateParams

Arguments

:: (MonadTrans t, MonadPQ schema pq1, pq ~ t pq1)

=> ToParams x params

=> Manipulation schema params ys

insertRows, update or deleteFrom

-> x

-> pq (K Result ys)

manipulate :: Manipulation schema '[] ys -> pq (K Result ys)

runQueryParams

Arguments

:: ToParams x params

=> Query schema params ys

select and friends

-> x

-> pq (K Result ys)

runQuery

Arguments

:: Query schema '[] ys

select and friends

-> pq (K Result ys)

traversePrepared

Arguments

:: (ToParams x params, Traversable list)

=> Manipulation schema params ys

insertRows, update, or deleteFrom, and friends

-> list x

-> pq (list (K Result ys))

traversePrepared

Arguments

:: (MonadTrans t, MonadPQ schema pq1, pq ~ t pq1)

=> (ToParams x params, Traversable list)

=> Manipulation schema params ys

insertRows, update, or deleteFrom, and friends

-> list x

-> pq (list (K Result ys))

forPrepared

Arguments

:: (ToParams x params, Traversable list)

=> list x

-> Manipulation schema params ys

insertRows, update or deleteFrom

-> pq (list (K Result ys))

traversePrepared_

Arguments

:: (ToParams x params, Foldable list)

=> Manipulation schema params '[]

insertRows, update or deleteFrom

-> list x

-> pq ()

traversePrepared_

Arguments

:: (MonadTrans t, MonadPQ schema pq1, pq ~ t pq1)

=> (ToParams x params, Foldable list)

=> Manipulation schema params '[]

insertRows, update or deleteFrom

-> list x

-> pq ()

forPrepared_

Arguments

:: (ToParams x params, Foldable list)

=> list x

-> Manipulation schema params '[]

insertRows, update or deleteFrom

-> pq ()

liftPQ :: (Connection -> IO a) -> pq a

liftPQ :: (MonadTrans t, MonadPQ schema pq1, pq ~ t pq1) => (Connection -> IO a) -> pq a

Instances

MonadPQ schema m => MonadPQ schema (ListT m)

Defined in Squeal.PostgreSQL.PQ

Methods

manipulateParams :: ToParams x params => Manipulation schema params ys -> x -> ListT m (K Result ys)

manipulate :: Manipulation schema [] ys -> ListT m (K Result ys)

runQueryParams :: ToParams x params => Query schema params ys -> x -> ListT m (K Result ys)

runQuery :: Query schema [] ys -> ListT m (K Result ys)

traversePrepared :: (ToParams x params, Traversable list) => Manipulation schema params ys -> list x -> ListT m (list (K Result ys))

forPrepared :: (ToParams x params, Traversable list) => list x -> Manipulation schema params ys -> ListT m (list (K Result ys))

traversePrepared_ :: (ToParams x params, Foldable list) => Manipulation schema params [] -> list x -> ListT m ()

forPrepared_ :: (ToParams x params, Foldable list) => list x -> Manipulation schema params [] -> ListT m ()

liftPQ :: (Connection -> IO a) -> ListT m a

MonadPQ schema m => MonadPQ schema (MaybeT m)

Defined in Squeal.PostgreSQL.PQ

Methods

manipulateParams :: ToParams x params => Manipulation schema params ys -> x -> MaybeT m (K Result ys)

manipulate :: Manipulation schema [] ys -> MaybeT m (K Result ys)

runQueryParams :: ToParams x params => Query schema params ys -> x -> MaybeT m (K Result ys)

runQuery :: Query schema [] ys -> MaybeT m (K Result ys)

traversePrepared :: (ToParams x params, Traversable list) => Manipulation schema params ys -> list x -> MaybeT m (list (K Result ys))

forPrepared :: (ToParams x params, Traversable list) => list x -> Manipulation schema params ys -> MaybeT m (list (K Result ys))

traversePrepared_ :: (ToParams x params, Foldable list) => Manipulation schema params [] -> list x -> MaybeT m ()

forPrepared_ :: (ToParams x params, Foldable list) => list x -> Manipulation schema params [] -> MaybeT m ()

liftPQ :: (Connection -> IO a) -> MaybeT m a

MonadPQ schema m => MonadPQ schema (ExceptT e m)

Defined in Squeal.PostgreSQL.PQ

Methods

manipulateParams :: ToParams x params => Manipulation schema params ys -> x -> ExceptT e m (K Result ys)

manipulate :: Manipulation schema [] ys -> ExceptT e m (K Result ys)

runQueryParams :: ToParams x params => Query schema params ys -> x -> ExceptT e m (K Result ys)

runQuery :: Query schema [] ys -> ExceptT e m (K Result ys)

traversePrepared :: (ToParams x params, Traversable list) => Manipulation schema params ys -> list x -> ExceptT e m (list (K Result ys))

forPrepared :: (ToParams x params, Traversable list) => list x -> Manipulation schema params ys -> ExceptT e m (list (K Result ys))

traversePrepared_ :: (ToParams x params, Foldable list) => Manipulation schema params [] -> list x -> ExceptT e m ()

forPrepared_ :: (ToParams x params, Foldable list) => list x -> Manipulation schema params [] -> ExceptT e m ()

liftPQ :: (Connection -> IO a) -> ExceptT e m a

(Monoid w, MonadPQ schema m) => MonadPQ schema (WriterT w m)

Defined in Squeal.PostgreSQL.PQ

Methods

manipulateParams :: ToParams x params => Manipulation schema params ys -> x -> WriterT w m (K Result ys)

manipulate :: Manipulation schema [] ys -> WriterT w m (K Result ys)

runQueryParams :: ToParams x params => Query schema params ys -> x -> WriterT w m (K Result ys)

runQuery :: Query schema [] ys -> WriterT w m (K Result ys)

traversePrepared :: (ToParams x params, Traversable list) => Manipulation schema params ys -> list x -> WriterT w m (list (K Result ys))

forPrepared :: (ToParams x params, Traversable list) => list x -> Manipulation schema params ys -> WriterT w m (list (K Result ys))

traversePrepared_ :: (ToParams x params, Foldable list) => Manipulation schema params [] -> list x -> WriterT w m ()

forPrepared_ :: (ToParams x params, Foldable list) => list x -> Manipulation schema params [] -> WriterT w m ()

liftPQ :: (Connection -> IO a) -> WriterT w m a

(Monoid w, MonadPQ schema m) => MonadPQ schema (WriterT w m)

Defined in Squeal.PostgreSQL.PQ

Methods

manipulateParams :: ToParams x params => Manipulation schema params ys -> x -> WriterT w m (K Result ys)

manipulate :: Manipulation schema [] ys -> WriterT w m (K Result ys)

runQueryParams :: ToParams x params => Query schema params ys -> x -> WriterT w m (K Result ys)

runQuery :: Query schema [] ys -> WriterT w m (K Result ys)

traversePrepared :: (ToParams x params, Traversable list) => Manipulation schema params ys -> list x -> WriterT w m (list (K Result ys))

forPrepared :: (ToParams x params, Traversable list) => list x -> Manipulation schema params ys -> WriterT w m (list (K Result ys))

traversePrepared_ :: (ToParams x params, Foldable list) => Manipulation schema params [] -> list x -> WriterT w m ()

forPrepared_ :: (ToParams x params, Foldable list) => list x -> Manipulation schema params [] -> WriterT w m ()

liftPQ :: (Connection -> IO a) -> WriterT w m a

MonadPQ schema m => MonadPQ schema (StateT s m)

Defined in Squeal.PostgreSQL.PQ

Methods

manipulateParams :: ToParams x params => Manipulation schema params ys -> x -> StateT s m (K Result ys)

manipulate :: Manipulation schema [] ys -> StateT s m (K Result ys)

runQueryParams :: ToParams x params => Query schema params ys -> x -> StateT s m (K Result ys)

runQuery :: Query schema [] ys -> StateT s m (K Result ys)

traversePrepared :: (ToParams x params, Traversable list) => Manipulation schema params ys -> list x -> StateT s m (list (K Result ys))

forPrepared :: (ToParams x params, Traversable list) => list x -> Manipulation schema params ys -> StateT s m (list (K Result ys))

traversePrepared_ :: (ToParams x params, Foldable list) => Manipulation schema params [] -> list x -> StateT s m ()

forPrepared_ :: (ToParams x params, Foldable list) => list x -> Manipulation schema params [] -> StateT s m ()

liftPQ :: (Connection -> IO a) -> StateT s m a

MonadPQ schema m => MonadPQ schema (StateT s m)

Defined in Squeal.PostgreSQL.PQ

Methods

manipulateParams :: ToParams x params => Manipulation schema params ys -> x -> StateT s m (K Result ys)

manipulate :: Manipulation schema [] ys -> StateT s m (K Result ys)

runQueryParams :: ToParams x params => Query schema params ys -> x -> StateT s m (K Result ys)

runQuery :: Query schema [] ys -> StateT s m (K Result ys)

traversePrepared :: (ToParams x params, Traversable list) => Manipulation schema params ys -> list x -> StateT s m (list (K Result ys))

forPrepared :: (ToParams x params, Traversable list) => list x -> Manipulation schema params ys -> StateT s m (list (K Result ys))

traversePrepared_ :: (ToParams x params, Foldable list) => Manipulation schema params [] -> list x -> StateT s m ()

forPrepared_ :: (ToParams x params, Foldable list) => list x -> Manipulation schema params [] -> StateT s m ()

liftPQ :: (Connection -> IO a) -> StateT s m a

MonadPQ schema m => MonadPQ schema (IdentityT m)

Defined in Squeal.PostgreSQL.PQ

Methods

manipulateParams :: ToParams x params => Manipulation schema params ys -> x -> IdentityT m (K Result ys)

manipulate :: Manipulation schema [] ys -> IdentityT m (K Result ys)

runQueryParams :: ToParams x params => Query schema params ys -> x -> IdentityT m (K Result ys)

runQuery :: Query schema [] ys -> IdentityT m (K Result ys)

traversePrepared :: (ToParams x params, Traversable list) => Manipulation schema params ys -> list x -> IdentityT m (list (K Result ys))

forPrepared :: (ToParams x params, Traversable list) => list x -> Manipulation schema params ys -> IdentityT m (list (K Result ys))

traversePrepared_ :: (ToParams x params, Foldable list) => Manipulation schema params [] -> list x -> IdentityT m ()

forPrepared_ :: (ToParams x params, Foldable list) => list x -> Manipulation schema params [] -> IdentityT m ()

liftPQ :: (Connection -> IO a) -> IdentityT m a

MonadPQ schema m => MonadPQ schema (ContT r m)

Defined in Squeal.PostgreSQL.PQ

Methods

manipulateParams :: ToParams x params => Manipulation schema params ys -> x -> ContT r m (K Result ys)

manipulate :: Manipulation schema [] ys -> ContT r m (K Result ys)

runQueryParams :: ToParams x params => Query schema params ys -> x -> ContT r m (K Result ys)

runQuery :: Query schema [] ys -> ContT r m (K Result ys)

traversePrepared :: (ToParams x params, Traversable list) => Manipulation schema params ys -> list x -> ContT r m (list (K Result ys))

forPrepared :: (ToParams x params, Traversable list) => list x -> Manipulation schema params ys -> ContT r m (list (K Result ys))

traversePrepared_ :: (ToParams x params, Foldable list) => Manipulation schema params [] -> list x -> ContT r m ()

forPrepared_ :: (ToParams x params, Foldable list) => list x -> Manipulation schema params [] -> ContT r m ()

liftPQ :: (Connection -> IO a) -> ContT r m a

MonadPQ schema m => MonadPQ schema (ReaderT r m)

Defined in Squeal.PostgreSQL.PQ

Methods

manipulateParams :: ToParams x params => Manipulation schema params ys -> x -> ReaderT r m (K Result ys)

manipulate :: Manipulation schema [] ys -> ReaderT r m (K Result ys)

runQueryParams :: ToParams x params => Query schema params ys -> x -> ReaderT r m (K Result ys)

runQuery :: Query schema [] ys -> ReaderT r m (K Result ys)

traversePrepared :: (ToParams x params, Traversable list) => Manipulation schema params ys -> list x -> ReaderT r m (list (K Result ys))

forPrepared :: (ToParams x params, Traversable list) => list x -> Manipulation schema params ys -> ReaderT r m (list (K Result ys))

traversePrepared_ :: (ToParams x params, Foldable list) => Manipulation schema params [] -> list x -> ReaderT r m ()

forPrepared_ :: (ToParams x params, Foldable list) => list x -> Manipulation schema params [] -> ReaderT r m ()

liftPQ :: (Connection -> IO a) -> ReaderT r m a

(MonadBase IO io, schema0 ~ schema, schema1 ~ schema) => MonadPQ schema (PQ schema0 schema1 io)

Defined in Squeal.PostgreSQL.PQ

Methods

manipulateParams :: ToParams x params => Manipulation schema params ys -> x -> PQ schema0 schema1 io (K Result ys)

manipulate :: Manipulation schema [] ys -> PQ schema0 schema1 io (K Result ys)

runQueryParams :: ToParams x params => Query schema params ys -> x -> PQ schema0 schema1 io (K Result ys)

runQuery :: Query schema [] ys -> PQ schema0 schema1 io (K Result ys)

traversePrepared :: (ToParams x params, Traversable list) => Manipulation schema params ys -> list x -> PQ schema0 schema1 io (list (K Result ys))

forPrepared :: (ToParams x params, Traversable list) => list x -> Manipulation schema params ys -> PQ schema0 schema1 io (list (K Result ys))

traversePrepared_ :: (ToParams x params, Foldable list) => Manipulation schema params [] -> list x -> PQ schema0 schema1 io ()

forPrepared_ :: (ToParams x params, Foldable list) => list x -> Manipulation schema params [] -> PQ schema0 schema1 io ()

liftPQ :: (Connection -> IO a) -> PQ schema0 schema1 io a

MonadBaseControl IO io => MonadPQ schema (PoolPQ schema io)

MonadPQ instance for PoolPQ.

Defined in Squeal.PostgreSQL.Pool

Methods

manipulateParams :: ToParams x params => Manipulation schema params ys -> x -> PoolPQ schema io (K Result ys)

manipulate :: Manipulation schema [] ys -> PoolPQ schema io (K Result ys)

runQueryParams :: ToParams x params => Query schema params ys -> x -> PoolPQ schema io (K Result ys)

runQuery :: Query schema [] ys -> PoolPQ schema io (K Result ys)

traversePrepared :: (ToParams x params, Traversable list) => Manipulation schema params ys -> list x -> PoolPQ schema io (list (K Result ys))

forPrepared :: (ToParams x params, Traversable list) => list x -> Manipulation schema params ys -> PoolPQ schema io (list (K Result ys))

traversePrepared_ :: (ToParams x params, Foldable list) => Manipulation schema params [] -> list x -> PoolPQ schema io ()

forPrepared_ :: (ToParams x params, Foldable list) => list x -> Manipulation schema params [] -> PoolPQ schema io ()

liftPQ :: (Connection -> IO a) -> PoolPQ schema io a

(Monoid w, MonadPQ schema m) => MonadPQ schema (RWST r w s m)

Defined in Squeal.PostgreSQL.PQ

Methods

manipulateParams :: ToParams x params => Manipulation schema params ys -> x -> RWST r w s m (K Result ys)

manipulate :: Manipulation schema [] ys -> RWST r w s m (K Result ys)

runQueryParams :: ToParams x params => Query schema params ys -> x -> RWST r w s m (K Result ys)

runQuery :: Query schema [] ys -> RWST r w s m (K Result ys)

traversePrepared :: (ToParams x params, Traversable list) => Manipulation schema params ys -> list x -> RWST r w s m (list (K Result ys))

forPrepared :: (ToParams x params, Traversable list) => list x -> Manipulation schema params ys -> RWST r w s m (list (K Result ys))

traversePrepared_ :: (ToParams x params, Foldable list) => Manipulation schema params [] -> list x -> RWST r w s m ()

forPrepared_ :: (ToParams x params, Foldable list) => list x -> Manipulation schema params [] -> RWST r w s m ()

liftPQ :: (Connection -> IO a) -> RWST r w s m a

(Monoid w, MonadPQ schema m) => MonadPQ schema (RWST r w s m)

Defined in Squeal.PostgreSQL.PQ

Methods

manipulateParams :: ToParams x params => Manipulation schema params ys -> x -> RWST r w s m (K Result ys)

manipulate :: Manipulation schema [] ys -> RWST r w s m (K Result ys)

runQueryParams :: ToParams x params => Query schema params ys -> x -> RWST r w s m (K Result ys)

runQuery :: Query schema [] ys -> RWST r w s m (K Result ys)

traversePrepared :: (ToParams x params, Traversable list) => Manipulation schema params ys -> list x -> RWST r w s m (list (K Result ys))

forPrepared :: (ToParams x params, Traversable list) => list x -> Manipulation schema params ys -> RWST r w s m (list (K Result ys))

traversePrepared_ :: (ToParams x params, Foldable list) => Manipulation schema params [] -> list x -> RWST r w s m ()

forPrepared_ :: (ToParams x params, Foldable list) => list x -> Manipulation schema params [] -> RWST r w s m ()

liftPQ :: (Connection -> IO a) -> RWST r w s m a

type PQRun schema = forall m x. Monad m => PQ schema schema m x -> m (K x schema)

A snapshot of the state of a PQ computation.

pqliftWith :: Functor m => (PQRun schema -> m a) -> PQ schema schema m a

Helper function in defining MonadBaseControl instance for PQ.

Result

data Result

Result encapsulates the result of a query (or more precisely, of a single SQL command --- a query string given to sendQuery can contain multiple commands and thus return multiple instances of Result.

Instances

Eq Result

Defined in Database.PostgreSQL.LibPQ

Methods

(==) :: Result -> Result -> Bool

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

Show Result

Defined in Database.PostgreSQL.LibPQ

Methods

showsPrec :: Int -> Result -> ShowS

show :: Result -> String

showList :: [Result] -> ShowS

data Row

Instances

Enum Row

Defined in Database.PostgreSQL.LibPQ

Methods

succ :: Row -> Row

pred :: Row -> Row

toEnum :: Int -> Row

fromEnum :: Row -> Int

enumFrom :: Row -> [Row]

enumFromThen :: Row -> Row -> [Row]

enumFromTo :: Row -> Row -> [Row]

enumFromThenTo :: Row -> Row -> Row -> [Row]

Eq Row

Defined in Database.PostgreSQL.LibPQ

Methods

(==) :: Row -> Row -> Bool

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

Num Row

Defined in Database.PostgreSQL.LibPQ

Methods

(+) :: Row -> Row -> Row

(-) :: Row -> Row -> Row

(*) :: Row -> Row -> Row

negate :: Row -> Row

abs :: Row -> Row

signum :: Row -> Row

fromInteger :: Integer -> Row

Ord Row

Defined in Database.PostgreSQL.LibPQ

Methods

compare :: Row -> Row -> Ordering

(<) :: Row -> Row -> Bool

(<=) :: Row -> Row -> Bool

(>) :: Row -> Row -> Bool

(>=) :: Row -> Row -> Bool

max :: Row -> Row -> Row

min :: Row -> Row -> Row

Show Row

Defined in Database.PostgreSQL.LibPQ

Methods

showsPrec :: Int -> Row -> ShowS

show :: Row -> String

showList :: [Row] -> ShowS

ntuples :: MonadBase IO io => K Result columns -> io Row

Returns the number of rows (tuples) in the query result.

getRow

Arguments

:: (FromRow columns y, MonadBase IO io)

=> Row

row number

-> K Result columns

result

-> io y

Get a row corresponding to a given row number from a Result, throwing an exception if the row number is out of bounds.

getRows

Arguments

:: (FromRow columns y, MonadBase IO io)

=> K Result columns

result

-> io [y]

Get all rows from a Result.

nextRow

Arguments

:: (FromRow columns y, MonadBase IO io)

=> Row

total number of rows

-> K Result columns

result

-> Row

row number

-> io (Maybe (Row, y))

Intended to be used for unfolding in streaming libraries, nextRow takes a total number of rows (which can be found with ntuples) and a Result and given a row number if it's too large returns Nothing, otherwise returning the row along with the next row number.

firstRow

Arguments

:: (FromRow columns y, MonadBase IO io)

=> K Result columns

result

-> io (Maybe y)

Get the first row if possible from a Result.

liftResult :: MonadBase IO io => (Result -> IO x) -> K Result results -> io x

Lifts actions on results from LibPQ.

data ExecStatus

Constructors

EmptyQuery

The string sent to the server was empty.

CommandOk

Successful completion of a command returning no data.

TuplesOk

Successful completion of a command returning data (such as a SELECT or SHOW).

CopyOut

Copy Out (from server) data transfer started.

CopyIn

Copy In (to server) data transfer started.

CopyBoth

Copy In/Out data transfer started.

BadResponse

The server's response was not understood.

NonfatalError

A nonfatal error (a notice or warning) occurred.

FatalError

A fatal error occurred.

SingleTuple

The PGresult contains a single result tuple from the current command. This status occurs only when single-row mode has been selected for the query.

Instances

Enum ExecStatus

Defined in Database.PostgreSQL.LibPQ

Methods

succ :: ExecStatus -> ExecStatus

pred :: ExecStatus -> ExecStatus

toEnum :: Int -> ExecStatus

fromEnum :: ExecStatus -> Int

enumFrom :: ExecStatus -> [ExecStatus]

enumFromThen :: ExecStatus -> ExecStatus -> [ExecStatus]

enumFromTo :: ExecStatus -> ExecStatus -> [ExecStatus]

enumFromThenTo :: ExecStatus -> ExecStatus -> ExecStatus -> [ExecStatus]

Eq ExecStatus

Defined in Database.PostgreSQL.LibPQ

Methods

(==) :: ExecStatus -> ExecStatus -> Bool

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

Show ExecStatus

Defined in Database.PostgreSQL.LibPQ

Methods

showsPrec :: Int -> ExecStatus -> ShowS

show :: ExecStatus -> String

showList :: [ExecStatus] -> ShowS

resultStatus :: MonadBase IO io => K Result results -> io ExecStatus

Returns the result status of the command.

resultErrorMessage :: MonadBase IO io => K Result results -> io (Maybe ByteString)

Returns the error message most recently generated by an operation on the connection.