opaleye-0.5.0.0: An SQL-generating DSL targeting PostgreSQL

Safe Haskell	Safe
Language	Haskell98

Opaleye.Internal.HaskellDB.Sql

Contents

SQL data type

Synopsis

SQL data type

data SqlTable Source

Constructors

SqlTable
Fields sqlTableSchemaName :: Maybe String sqlTableName :: String

Instances

Show SqlTable Source

newtype SqlColumn Source

Constructors

SqlColumn String

Instances

Show SqlColumn Source

type SqlName = String Source

A valid SQL name for a parameter.

data SqlOrderNulls Source

Constructors

SqlNullsFirst
SqlNullsLast

Instances

Show SqlOrderNulls Source

data SqlOrderDirection Source

Constructors

SqlAsc
SqlDesc

Instances

Show SqlOrderDirection Source

data SqlOrder Source

Constructors

SqlOrder
Fields sqlOrderDirection :: SqlOrderDirection sqlOrderNulls :: SqlOrderNulls

Instances

Show SqlOrder Source

data SqlExpr Source

Expressions in SQL statements.

Constructors

ColumnSqlExpr SqlColumn
CompositeSqlExpr SqlExpr String
BinSqlExpr String SqlExpr SqlExpr
PrefixSqlExpr String SqlExpr
PostfixSqlExpr String SqlExpr
FunSqlExpr String [SqlExpr]
AggrFunSqlExpr String [SqlExpr] [(SqlExpr, SqlOrder)]	Aggregate functions separate from normal functions.
ConstSqlExpr String
CaseSqlExpr [(SqlExpr, SqlExpr)] SqlExpr
ListSqlExpr [SqlExpr]
ParamSqlExpr (Maybe SqlName) SqlExpr
PlaceHolderSqlExpr
ParensSqlExpr SqlExpr
CastSqlExpr String SqlExpr
DefaultSqlExpr
ArraySqlExpr [SqlExpr]

Instances

Show SqlExpr Source

data SqlUpdate Source

Data type for SQL UPDATE statements.

Constructors

SqlUpdate SqlTable [(SqlColumn, SqlExpr)] [SqlExpr]

data SqlDelete Source

Data type for SQL DELETE statements.

Constructors

SqlDelete SqlTable [SqlExpr]

data SqlInsert Source

Constructors

SqlInsert SqlTable [SqlColumn] (NonEmpty [SqlExpr])