Portability | non-portable |
---|---|
Stability | experimental |
Maintainer | haskelldb-users@lists.sourceforge.net |
Safe Haskell | None |
Database.HaskellDB.Sql
Description
A data type for SQL.
- type SqlTable = String
- type SqlColumn = String
- type SqlName = String
- data SqlOrder
- data SqlType
- data SqlSelect
- data SqlUpdate = SqlUpdate SqlTable [(SqlColumn, SqlExpr)] [SqlExpr]
- data SqlDelete = SqlDelete SqlTable [SqlExpr]
- data SqlInsert
- data SqlCreate
- = SqlCreateDB String
- | SqlCreateTable SqlTable [(SqlColumn, (SqlType, Bool))]
- data SqlDrop
- data SqlExpr
- = ColumnSqlExpr SqlColumn
- | BinSqlExpr String SqlExpr SqlExpr
- | PrefixSqlExpr String SqlExpr
- | PostfixSqlExpr String SqlExpr
- | FunSqlExpr String [SqlExpr]
- | AggrFunSqlExpr String [SqlExpr]
- | ConstSqlExpr String
- | CaseSqlExpr [(SqlExpr, SqlExpr)] SqlExpr
- | ListSqlExpr [SqlExpr]
- | ExistsSqlExpr SqlSelect
- | ParamSqlExpr (Maybe SqlName) SqlExpr
- | PlaceHolderSqlExpr
- | ParensSqlExpr SqlExpr
- | CastSqlExpr String SqlExpr
- data 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
- foldSqlSelect :: ([String] -> [(SqlColumn, SqlExpr)] -> [(SqlTable, t)] -> [SqlExpr] -> Maybe Mark -> [(SqlExpr, SqlOrder)] -> [String] -> t, String -> t -> t -> t, SqlTable -> t, t) -> SqlSelect -> t
Documentation
data SqlType
data SqlSelect
Data type for SQL SELECT statements.
data SqlUpdate
Data type for SQL UPDATE statements.
data SqlInsert
Data type for SQL INSERT statements.
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 |