postgrest-0.2.9.1: REST API for any Postgres database

Safe Haskell	None
Language	Haskell2010

PostgREST.PgQuery

Documentation

type PStmt = Stmt Postgres Source

type StatementT = PStmt -> PStmt Source

data QualifiedTable Source

Constructors

QualifiedTable
Fields qtSchema :: Text qtName :: Text

Instances

Show QualifiedTable

data OrderTerm Source

Constructors

OrderTerm
Fields otTerm :: Text otDirection :: ByteString otNullOrder :: Maybe ByteString

limitT :: Maybe NonnegRange -> StatementT Source

whereT :: Query -> StatementT Source

withT :: PStmt -> Text -> StatementT Source

orderT :: [OrderTerm] -> StatementT Source

parentheticT :: StatementT Source

iffNotT :: PStmt -> StatementT Source

countT :: StatementT Source

countRows :: QualifiedTable -> PStmt Source

asJsonWithCount :: StatementT Source

asJsonRow :: StatementT Source

selectStar :: QualifiedTable -> PStmt Source

returningStarT :: StatementT Source

deleteFrom :: QualifiedTable -> PStmt Source

insertInto :: QualifiedTable -> Vector Text -> Vector (Vector Value) -> PStmt Source

insertSelect :: QualifiedTable -> [Text] -> [Value] -> PStmt Source

update :: QualifiedTable -> [Text] -> [Value] -> PStmt Source

wherePred :: QueryItem -> PStmt Source

orderParse :: Query -> [OrderTerm] Source

orderParseTerm :: Text -> Maybe OrderTerm Source

commaq :: PStmt Source

andq :: PStmt Source

data JsonbPath Source

Constructors

ColIdentifier Text
KeyIdentifier Text
SingleArrow JsonbPath JsonbPath
DoubleArrow JsonbPath JsonbPath

Instances

parseJsonbPath :: Text -> Maybe JsonbPath Source

pgFmtJsonbPath :: Text -> Text Source

pgFmtIdent :: Text -> Text Source

pgFmtLit :: Text -> Text Source

trimNullChars :: Text -> Text Source

fromQt :: QualifiedTable -> Text Source

unquoted :: Value -> Text Source

insertableText :: Text -> Text Source

insertableValue :: Value -> Text Source

paramFilter :: Value -> Text Source