opaleye-0.2: An SQL-generating DSL targeting PostgreSQL

Safe HaskellSafe-Inferred
LanguageHaskell98

Opaleye.Internal.HaskellDB.Sql

Synopsis

Documentation

type SqlTable = String Source

type SqlColumn = String Source

type SqlName = String Source

A valid SQL name for a parameter.

data SqlOrder Source

Constructors

SqlAsc 
SqlDesc 

Instances

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] [SqlExpr] 

data SqlExpr Source

Expressions in SQL statements.

Constructors

ColumnSqlExpr SqlColumn 
BinSqlExpr String SqlExpr SqlExpr 
PrefixSqlExpr String SqlExpr 
PostfixSqlExpr String SqlExpr 
FunSqlExpr String [SqlExpr] 
AggrFunSqlExpr String [SqlExpr]

Aggregate functions separate from normal functions.

ConstSqlExpr String 
CaseSqlExpr [(SqlExpr, SqlExpr)] SqlExpr 
ListSqlExpr [SqlExpr] 
ParamSqlExpr (Maybe SqlName) SqlExpr 
PlaceHolderSqlExpr 
ParensSqlExpr SqlExpr 
CastSqlExpr String SqlExpr 

Instances

data Mark Source

Constructors

Columns [(SqlColumn, SqlExpr)] 

Instances