Database.PostgreSQL.Store.Query.Builder

Documentation

data QueryGenerator a

Generator for queries, its type parameter hints the type needed to generate the attached values

Constructors

Gen Oid (a -> Maybe ByteString)

Code ByteString

With (a -> b) (QueryGenerator b)

Merge (QueryGenerator a) (QueryGenerator a)

Instances

IsString (QueryGenerator a)

Methods

fromString :: String -> QueryGenerator a

Semigroup (QueryGenerator a)

Methods

(<>) :: QueryGenerator a -> QueryGenerator a -> QueryGenerator a

sconcat :: NonEmpty (QueryGenerator a) -> QueryGenerator a

stimes :: Integral b => b -> QueryGenerator a -> QueryGenerator a

Monoid (QueryGenerator a)

Methods

mempty :: QueryGenerator a

mappend :: QueryGenerator a -> QueryGenerator a -> QueryGenerator a

mconcat :: [QueryGenerator a] -> QueryGenerator a

Hashable (QueryGenerator a)

Methods

hashWithSalt :: Int -> QueryGenerator a -> Int

hash :: QueryGenerator a -> Int

assemble :: QueryGenerator a -> a -> Query r

Assemble the query object.

assemblePrep :: ByteString -> QueryGenerator (Tuple p) -> PrepQuery p r

Assemble for query preparation.

withOther :: a -> QueryGenerator a -> QueryGenerator b

Embed a generator which requires an external parameter.

genIdentifier :: ByteString -> QueryGenerator a

Insert an identifying name. Takes care of proper quotation.

genNestedIdentifier :: ByteString -> ByteString -> QueryGenerator a

Connect two identifiers with a dot. Each identifier is surrounded by quotes if necessary.

genQuote :: ByteString -> QueryGenerator a

Surround with quotes and escape delimiting characters.

joinGens :: ByteString -> [QueryGenerator a] -> QueryGenerator a

Join multiple query generators with a piece of code.

withParamN :: forall n r ts. HasElement n ts r => QueryGenerator r -> Tagged n (QueryGenerator (Tuple ts))

Redirect the n-th parameter for the given query

withParam0 :: QueryGenerator r -> QueryGenerator (Tuple (r ': ts))

Redirect the 0th paramter to the given query generator.

withParam1 :: QueryGenerator r -> QueryGenerator (Tuple (t0 ': (r ': ts)))

Redirect the 1st paramter to the given query generator.

withParam2 :: QueryGenerator r -> QueryGenerator (Tuple (t0 ': (t1 ': (r ': ts))))

Redirect the 2nd paramter to the given query generator.

withParam3 :: QueryGenerator r -> QueryGenerator (Tuple (t0 ': (t1 ': (t2 ': (r ': ts)))))

Redirect the 3rd paramter to the given query generator.

withParam4 :: QueryGenerator r -> QueryGenerator (Tuple (t0 ': (t1 ': (t2 ': (t3 ': (r ': ts))))))

Redirect the 4th paramter to the given query generator.

withParam5 :: QueryGenerator r -> QueryGenerator (Tuple (t0 ': (t1 ': (t2 ': (t3 ': (t4 ': (r ': ts)))))))

Redirect the 5th paramter to the given query generator.

withParam6 :: QueryGenerator r -> QueryGenerator (Tuple (t0 ': (t1 ': (t2 ': (t3 ': (t4 ': (t5 ': (r ': ts))))))))

Redirect the 6th paramter to the given query generator.

withParam7 :: QueryGenerator r -> QueryGenerator (Tuple (t0 ': (t1 ': (t2 ': (t3 ': (t4 ': (t5 ': (t6 ': (r ': ts)))))))))

Redirect the 7th paramter to the given query generator.

withParam8 :: QueryGenerator r -> QueryGenerator (Tuple (t0 ': (t1 ': (t2 ': (t3 ': (t4 ': (t5 ': (t6 ': (t7 ': (r ': ts))))))))))

Redirect the 8th paramter to the given query generator.

withParam9 :: QueryGenerator r -> QueryGenerator (Tuple (t0 ': (t1 ': (t2 ': (t3 ': (t4 ': (t5 ': (t6 ': (t7 ': (t8 ': (r ': ts)))))))))))

Redirect the 9th paramter to the given query generator.