| 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 -> NonnegRange -> Bool -> Query () (Maybe ProcResults)
- createReadStatement :: SqlQuery -> SqlQuery -> NonnegRange -> Bool -> Bool -> Bool -> Query () ResultsWithCount
- createWriteStatement :: QualifiedIdentifier -> SqlQuery -> SqlQuery -> Bool -> PreferRepresentation -> [Text] -> Bool -> Payload -> Query UniformObjects (Maybe ResultsWithCount)
- 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)
Documentation
addRelations :: Schema -> [Relation] -> Maybe ReadRequest -> ReadRequest -> Either Text ReadRequest Source
callProc :: QualifiedIdentifier -> Object -> NonnegRange -> Bool -> Query () (Maybe ProcResults) 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
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