opaleye-sqlite-0.0.0.1: An SQL-generating DSL targeting SQLite

Safe HaskellSafe-Inferred
LanguageHaskell98

Opaleye.SQLite.Internal.HaskellDB.Sql

Contents

Synopsis

SQL data type

newtype SqlTable Source

Constructors

SqlTable String 

Instances

newtype SqlColumn Source

Constructors

SqlColumn String 

Instances

type SqlName = String Source

A valid SQL name for a parameter.

data SqlOrderNulls Source

Constructors

SqlNullsFirst 
SqlNullsLast 

Instances

data SqlOrderDirection Source

Constructors

SqlAsc 
SqlDesc 

Instances

data SqlOrder Source

Constructors

SqlOrder 

Fields

sqlOrderDirection :: SqlOrderDirection
 
sqlOrderNulls :: SqlOrderNulls
 

Instances

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 
DefaultSqlExpr 

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] (NonEmpty [SqlExpr])