Safe Haskell	None
Language	Haskell2010

Database.PostgreSQL.Query.SqlBuilder

Contents

Types
SqlBuilder helpers

Synopsis

Types

newtype SqlBuilder Source

Builder wich can be effectively concatenated. Requires Connection inside for string quoting implemented in libpq

Constructors

SqlBuilder
Fields sqlBuild :: Connection -> IO Builder

Instances

IsString SqlBuilder
Generic SqlBuilder
Monoid SqlBuilder
ToSqlBuilder SqlBuilder
Typeable * SqlBuilder
type Rep SqlBuilder

class ToSqlBuilder a where Source

Things which always can be transformed to SqlBuilder

Methods

toSqlBuilder :: a -> SqlBuilder Source

Instances

ToSqlBuilder String
ToSqlBuilder ByteString
ToSqlBuilder Builder
ToSqlBuilder ByteString
ToSqlBuilder Text
ToSqlBuilder Text
ToSqlBuilder SqlBuilder
ToSqlBuilder Qp
ToSqlBuilder FN

data Qp Source

Special constructor to perform old-style query interpolation

Constructors

forall row . ToRow row => Qp Query row

Instances

ToSqlBuilder Qp

SqlBuilder helpers

emptyB :: SqlBuilder Source

Typed synonym of mempty

runSqlBuilder :: Connection -> SqlBuilder -> IO Query Source

Performs parameters interpolation and return ready to execute query

>>> let val = 10
>>> let name = "field"
>>> runSqlBuilder c $ "SELECT * FROM tbl WHERE " <> mkIdent name <> " = " <> mkValue val
"SELECT * FROM tbl WHERE \"field\" = 10"

mkIdent :: Text -> SqlBuilder Source

Shorthand function to convert identifier name to builder

>>> runSqlBuilder c $ mkIdent "simple\"ident"
"\"simple\"\"ident\""

Note correct string quoting made by libpq

mkValue :: ToField a => a -> SqlBuilder Source

Shorthand function to convert single value to builder

>>> runSqlBuilder c $ mkValue "some ' value"
"'some '' value'"

Note correct string quoting

sqlBuilderPure :: Builder -> SqlBuilder Source

Lift pure bytestring builder to SqlBuilder

sqlBuilderFromField :: ToField a => Query -> a -> SqlBuilder Source