PostgREST.Query.SqlFragment

Any function that outputs a SqlFragment should be in this module.

Documentation

noLocationF :: SqlFragment

type SqlFragment = ByteString

A part of a SQL query that cannot be executed independently

asBinaryF :: FieldName -> SqlFragment

asCsvF :: SqlFragment

asJsonF :: Bool -> SqlFragment

asJsonSingleF :: Bool -> SqlFragment

countF :: Snippet -> Bool -> (Snippet, SqlFragment)

fromQi :: QualifiedIdentifier -> SqlFragment

ftsOperators :: HashMap Text SqlFragment

jsonPlaceHolder :: Maybe ByteString -> Snippet

Equivalent to "$1::json" | TODO: At this stage there shouldn't be a Maybe since ApiRequest should ensure that an INSERT/UPDATE has a body

limitOffsetF :: NonnegRange -> Snippet

locationF :: [Text] -> SqlFragment

normalizedBody :: Maybe ByteString -> Snippet

These CTEs convert a json object into a json array, this way we can use json_populate_recordset for all json payloads Otherwise we'd have to use json_populate_record for json objects and json_populate_recordset for json arrays We do this in SQL to avoid processing the JSON in application code

operators :: HashMap Text SqlFragment

pgFmtColumn :: QualifiedIdentifier -> Text -> SqlFragment

pgFmtIdent :: Text -> SqlFragment

pgFmtJoinCondition :: JoinCondition -> Snippet

pgFmtLogicTree :: QualifiedIdentifier -> LogicTree -> Snippet

pgFmtOrderTerm :: QualifiedIdentifier -> OrderTerm -> Snippet

pgFmtSelectItem :: QualifiedIdentifier -> SelectItem -> Snippet

responseHeadersF :: PgVersion -> SqlFragment

responseStatusF :: PgVersion -> SqlFragment

returningF :: QualifiedIdentifier -> [FieldName] -> SqlFragment

selectBody :: SqlFragment

sourceCTEName :: SqlFragment

unknownEncoder :: ByteString -> Snippet

intercalateSnippet :: ByteString -> [Snippet] -> Snippet