| Safe Haskell | None |
|---|---|
| Language | Haskell2010 |
PostgREST.QueryBuilder
Description
This module provides functions to consume data types that represent database objects (e.g. Relation, Schema, SqlQuery) and produces SQL Statements.
Any function that outputs a SQL fragment should be in this module.
- addRelations :: Schema -> [Relation] -> Maybe ReadRequest -> ReadRequest -> Either Text ReadRequest
- addJoinConditions :: Schema -> ReadRequest -> Either Text ReadRequest
- callProc :: QualifiedIdentifier -> Object -> Query () (Maybe Value)
- createReadStatement :: SqlQuery -> SqlQuery -> NonnegRange -> Bool -> Bool -> Bool -> Query () ResultsWithCount
- createWriteStatement :: QualifiedIdentifier -> SqlQuery -> SqlQuery -> Bool -> PreferRepresentation -> [Text] -> Bool -> Payload -> Query UniformObjects (Maybe ResultsWithCount)
- inTransaction :: Isolation -> Session a -> Session a
- operators :: [(Text, SqlFragment)]
- pgFmtIdent :: SqlFragment -> SqlFragment
- pgFmtLit :: SqlFragment -> SqlFragment
- requestToQuery :: Schema -> DbRequest -> SqlQuery
- requestToCountQuery :: Schema -> DbRequest -> SqlQuery
- sourceCTEName :: SqlFragment
- unquoted :: Value -> Text
- type ResultsWithCount = (Maybe Int64, Int64, ByteString, ByteString)
- data Isolation
Documentation
addRelations :: Schema -> [Relation] -> Maybe ReadRequest -> ReadRequest -> Either Text ReadRequest Source
createReadStatement :: SqlQuery -> SqlQuery -> NonnegRange -> Bool -> Bool -> Bool -> Query () ResultsWithCount Source
createWriteStatement :: QualifiedIdentifier -> SqlQuery -> SqlQuery -> Bool -> PreferRepresentation -> [Text] -> Bool -> Payload -> Query UniformObjects (Maybe ResultsWithCount) Source
inTransaction :: Isolation -> Session a -> Session a Source
Wrap a session in a transaction of desired isolation level
operators :: [(Text, SqlFragment)] Source
pgFmtLit :: SqlFragment -> SqlFragment Source
requestToQuery :: Schema -> DbRequest -> SqlQuery Source
requestToCountQuery :: Schema -> DbRequest -> SqlQuery Source
type ResultsWithCount = (Maybe Int64, Int64, ByteString, ByteString) Source
The generic query result format used by API responses
Constructors
| ReadCommitted | |
| RepeatableRead | |
| Serializable |