Squeal.PostgreSQL.Session.Statement

Description

A top-level Statement type wraps a Query or Manipulation together with an EncodeParams and a DecodeRow.

Synopsis

data Statement db x y where
- Manipulation :: (All (OidOfNull db) params, SListI row) => EncodeParams db params x -> DecodeRow row y -> Manipulation '[] db params row -> Statement db x y
- Query :: (All (OidOfNull db) params, SListI row) => EncodeParams db params x -> DecodeRow row y -> Query '[] '[] db params row -> Statement db x y
query :: (GenericParams db params x xs, GenericRow row y ys) => Query '[] '[] db params row -> Statement db x y
manipulation :: (GenericParams db params x xs, GenericRow row y ys) => Manipulation '[] db params row -> Statement db x y

Documentation

data Statement db x y where Source #

A Statement consists of a Manipulation or a Query that can be run in a MonadPQ.

Constructors

Manipulation	Constructor for a data manipulation language statement
Fields :: (All (OidOfNull db) params, SListI row) => EncodeParams db params x encoding of parameters -> DecodeRow row y decoding of returned rows -> Manipulation '[] db params row `insertInto`, `update`, or `deleteFrom`, ... -> Statement db x y
Query	Constructor for a structured query language statement
Fields :: (All (OidOfNull db) params, SListI row) => EncodeParams db params x encoding of parameters -> DecodeRow row y decoding of returned rows -> Query '[] '[] db params row `select`, `values`, ... -> Statement db x y

Instances details

Profunctor (Statement db) Source #
Instance details Defined in Squeal.PostgreSQL.Session.Statement Methods dimap :: (a -> b) -> (c -> d) -> Statement db b c -> Statement db a d # lmap :: (a -> b) -> Statement db b c -> Statement db a c # rmap :: (b -> c) -> Statement db a b -> Statement db a c # (#.) :: forall a b c q. Coercible c b => q b c -> Statement db a b -> Statement db a c # (.#) :: forall a b c q. Coercible b a => Statement db b c -> q a b -> Statement db a c #
Functor (Statement db x) Source #
Instance details Defined in Squeal.PostgreSQL.Session.Statement Methods fmap :: (a -> b) -> Statement db x a -> Statement db x b # (<$) :: a -> Statement db x b -> Statement db x a #
RenderSQL (Statement db x y) Source #
Instance details Defined in Squeal.PostgreSQL.Session.Statement Methods renderSQL :: Statement db x y -> ByteString Source #

Arguments

:: (GenericParams db params x xs, GenericRow row y ys)
=> Query '[] '[] db params row	`select`, `values`, ...
-> Statement db x y

Smart constructor for a structured query language statement

Arguments

:: (GenericParams db params x xs, GenericRow row y ys)
=> Manipulation '[] db params row	`insertInto`, `update`, or `deleteFrom`, ...
-> Statement db x y

Smart constructor for a data manipulation language statement