postgrest-0.2.11.0: REST API for any Postgres database

Safe HaskellNone
LanguageHaskell2010

PostgREST.PgQuery

Documentation

type PStmt = Stmt Postgres Source

type StatementT = PStmt -> PStmt Source

data QualifiedIdentifier Source

Constructors

QualifiedIdentifier 

Fields

qiSchema :: Text
 
qiName :: Text
 

Instances

data OrderTerm Source

Constructors

OrderTerm 

Fields

otTerm :: Text
 
otDirection :: ByteString
 
otNullOrder :: Maybe ByteString
 

limitT :: Maybe NonnegRange -> StatementT Source

whereT :: QualifiedIdentifier -> Query -> StatementT Source

withT :: PStmt -> Text -> StatementT Source

orderT :: [OrderTerm] -> StatementT Source

parentheticT :: StatementT Source

iffNotT :: PStmt -> StatementT Source

countT :: StatementT Source

countRows :: QualifiedIdentifier -> PStmt Source

asCsvWithCount :: QualifiedIdentifier -> StatementT Source

asCsv :: QualifiedIdentifier -> StatementT Source

asJsonWithCount :: StatementT Source

asJson :: StatementT Source

withCount :: StatementT Source

asJsonRow :: StatementT Source

selectStar :: QualifiedIdentifier -> PStmt Source

returningStarT :: StatementT Source

deleteFrom :: QualifiedIdentifier -> PStmt Source

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

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

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

callProc :: QualifiedIdentifier -> Object -> PStmt Source

wherePred :: QualifiedIdentifier -> 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 :: QualifiedIdentifier -> Text -> Text Source

pgFmtIdent :: Text -> Text Source

pgFmtLit :: Text -> Text Source

trimNullChars :: Text -> Text Source

fromQi :: QualifiedIdentifier -> Text Source

unquoted :: Value -> Text Source

insertableText :: Text -> Text Source

insertableValue :: Value -> Text Source

paramFilter :: Value -> Text Source