Database.PostgreSQL.Store.Query.Builder

Query Builder

type QueryBuilder = State BuilderState ()

Query builder

insertCode :: ByteString -> QueryBuilder

Insert a piece of SQL.

insertTypedValue :: TypedValue -> QueryBuilder

Insert a parameter placeholder into the code and attach the typed value to the query.

insertValue :: Value -> QueryBuilder

Same as insertTypedValue but untyped.

insertValue' :: ByteString -> Value -> QueryBuilder

Extension of insertValue which will add a type hint to the parameter placeholder.

insertQuote :: ByteString -> QueryBuilder

Insert a quote into the code.

insertName :: ByteString -> QueryBuilder

Insert a name into the code. It will be surrounded by double quotes if necessary.

insertCommaSeperated :: [QueryBuilder] -> QueryBuilder

Join several builders into a comma-seperated list.

Generalized Building

class FromQueryBuilder a where

a can be instantiated using the query builder.

Minimal complete definition

buildQuery

Methods

buildQuery :: QueryBuilder -> a

Instances

FromQueryBuilder ByteString

Methods

buildQuery :: QueryBuilder -> ByteString

FromQueryBuilder QueryBuilder

Methods

buildQuery :: QueryBuilder -> QueryBuilder

FromQueryBuilder (Query a)

Methods

buildQuery :: QueryBuilder -> Query a

FromQueryBuilder (ByteString, [TypedValue])

Methods

buildQuery :: QueryBuilder -> (ByteString, [TypedValue])