Module

Data.Postgres.Query

Package: purescript-postgresql
Repository: cakekindel/purescript-postgresql

#Query Source

newtype Query

SQL Query

text - the query string
values - query parameter values
name (optional) - providing this will create this query as a prepared statement

Constructors

Query { name :: Maybe String, text :: String, values :: Array Raw }

Instances

#emptyQuery Source

emptyQuery :: Query

An empty query

#AsQueryParams Source

class AsQueryParams a  where

Any value that can be converted to an array of query parameters

Members

asQueryParams :: a -> Effect (Array Raw)

Instances

AsQueryParams (Array Raw)
(Rep a, AsQueryParams b) => AsQueryParams (Tuple a b)
(Rep a) => AsQueryParams a

#AsQuery Source

class AsQuery a  where

Values that can be rendered as a SQL query

Members

asQuery :: a -> Effect Query

Instances

(AsQuery a) => AsQuery (Effect a)
AsQuery Query
AsQuery String
(AsQueryParams ps) => AsQuery (Tuple String ps)

#QueryRaw Source

type QueryRaw = { name :: Nullable String, rowMode :: String, text :: String, values :: Array Raw }

FFI

#__queryToRaw Source

__queryToRaw :: Query -> QueryRaw

FFI

Modules: Control.Monad.Postgres; Control.Monad.Postgres.Base; Control.Monad.Postgres.Cursor; Control.Monad.Postgres.Session; Data.Postgres; Data.Postgres.Custom; Data.Postgres.Custom.Enum; Data.Postgres.Query; Data.Postgres.Query.Builder; Data.Postgres.Range; Data.Postgres.Raw; Data.Postgres.Result; Data.Postgres.Unresult; Effect.Aff.Postgres.Client; Effect.Aff.Postgres.Pool; Effect.Postgres.Client; Effect.Postgres.Pool