Database.HaskellDB.Sql

A data type for SQL.

Documentation

type SqlTable = String

type SqlColumn = String

type SqlName = String

A valid SQL name for a parameter.

data SqlOrder

Constructors

SqlAsc

SqlDesc

Instances

Show SqlOrder

data SqlType

Constructors

SqlType String

SqlType1 String Int

SqlType2 String Int Int

Instances

Show SqlType

data SqlSelect

Data type for SQL SELECT statements.

Constructors

SqlSelect

Fields

options :: [String]

DISTINCT, ALL etc.

attrs :: [(SqlColumn, SqlExpr)]

result

tables :: [(SqlTable, SqlSelect)]

FROM

criteria :: [SqlExpr]

WHERE

groupby :: Maybe Mark

GROUP BY

orderby :: [(SqlExpr, SqlOrder)]

ORDER BY

extra :: [String]

TOP n, etc.

SqlBin String SqlSelect SqlSelect

Binary relational operator

SqlTable SqlTable

Select a whole table.

SqlEmpty

Empty select.

Instances

Show SqlSelect

data SqlUpdate

Data type for SQL UPDATE statements.

Constructors

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

data SqlDelete

Data type for SQL DELETE statements.

Constructors

SqlDelete SqlTable [SqlExpr]

data SqlInsert

Data type for SQL INSERT statements.

Constructors

SqlInsert SqlTable [SqlColumn] [SqlExpr]

SqlInsertQuery SqlTable [SqlColumn] SqlSelect

data SqlCreate

Data type for SQL CREATE statements.

Constructors

SqlCreateDB String

Create a database

SqlCreateTable SqlTable [(SqlColumn, (SqlType, Bool))]

Create a table.

data SqlDrop

Data type representing the SQL DROP statement.

Constructors

SqlDropDB String

Delete a database

SqlDropTable SqlTable

Delete a table named SqlTable

data SqlExpr

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]

ExistsSqlExpr SqlSelect

ParamSqlExpr (Maybe SqlName) SqlExpr

PlaceHolderSqlExpr

ParensSqlExpr SqlExpr

CastSqlExpr String SqlExpr

Instances

Show SqlExpr

data Mark

Constructors

All

Columns [(SqlColumn, SqlExpr)]

Instances

Show Mark

newSelect :: SqlSelect

foldSqlExpr :: (SqlColumn -> t, String -> t -> t -> t, String -> t -> t, String -> t -> t, String -> [t] -> t, String -> [t] -> t, String -> t, [(t, t)] -> t -> t, [t] -> t, SqlSelect -> t, Maybe SqlName -> t -> t, t, t -> t, String -> t -> t) -> SqlExpr -> t

Transform a SqlExpr value.

foldSqlSelect :: ([String] -> [(SqlColumn, SqlExpr)] -> [(SqlTable, t)] -> [SqlExpr] -> Maybe Mark -> [(SqlExpr, SqlOrder)] -> [String] -> t, String -> t -> t -> t, SqlTable -> t, t) -> SqlSelect -> t

Transform a SqlSelect value.