haskelldb-0.12: SQL unwrapper for Haskell.Source codeContentsIndex
Database.HaskellDB.Sql
Portabilitynon-portable
Stabilityexperimental
Maintainerhaskelldb-users@lists.sourceforge.net
Description
A data type for SQL.
Synopsis
type SqlTable = String
type SqlColumn = String
data SqlOrder
= SqlAsc
| SqlDesc
data SqlType
= SqlType String
| SqlType1 String Int
| SqlType2 String Int Int
data SqlSelect
= SqlSelect {
options :: [String]
attrs :: [(SqlColumn, SqlExpr)]
tables :: [(SqlTable, SqlSelect)]
criteria :: [SqlExpr]
groupby :: [(SqlColumn, SqlExpr)]
orderby :: [(SqlExpr, SqlOrder)]
extra :: [String]
}
| SqlBin String SqlSelect SqlSelect
| SqlTable SqlTable
| SqlEmpty
data SqlUpdate = SqlUpdate SqlTable [(SqlColumn, SqlExpr)] [SqlExpr]
data SqlDelete = SqlDelete SqlTable [SqlExpr]
data SqlInsert
= SqlInsert SqlTable [SqlColumn] [SqlExpr]
| SqlInsertQuery SqlTable [SqlColumn] SqlSelect
data SqlCreate
= SqlCreateDB String
| SqlCreateTable SqlTable [(SqlColumn, (SqlType, Bool))]
data SqlDrop
= SqlDropDB String
| SqlDropTable SqlTable
data SqlExpr
= ColumnSqlExpr SqlColumn
| BinSqlExpr String SqlExpr SqlExpr
| PrefixSqlExpr String SqlExpr
| PostfixSqlExpr String SqlExpr
| FunSqlExpr String [SqlExpr]
| ConstSqlExpr String
| CaseSqlExpr [(SqlExpr, SqlExpr)] SqlExpr
| ListSqlExpr [SqlExpr]
| ExistsSqlExpr SqlSelect
newSelect :: SqlSelect
Documentation
type SqlTable = StringSource
type SqlColumn = StringSource
data SqlOrder Source
Constructors
SqlAsc
SqlDesc
data SqlType Source
Constructors
SqlType String
SqlType1 String Int
SqlType2 String Int Int
data SqlSelect Source
Data type for SQL SELECT statements.
Constructors
SqlSelect
options :: [String]DISTINCT, ALL etc.
attrs :: [(SqlColumn, SqlExpr)]result
tables :: [(SqlTable, SqlSelect)]FROM
criteria :: [SqlExpr]WHERE
groupby :: [(SqlColumn, SqlExpr)]GROUP BY
orderby :: [(SqlExpr, SqlOrder)]ORDER BY
extra :: [String]TOP n, etc.
SqlBin String SqlSelect SqlSelectBinary relational operator
SqlTable SqlTableSelect a whole table.
SqlEmptyEmpty select.
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
Data type for SQL INSERT statements.
Constructors
SqlInsert SqlTable [SqlColumn] [SqlExpr]
SqlInsertQuery SqlTable [SqlColumn] SqlSelect
data SqlCreate Source
Data type for SQL CREATE statements.
Constructors
SqlCreateDB StringCreate a database
SqlCreateTable SqlTable [(SqlColumn, (SqlType, Bool))]Create a table.
data SqlDrop Source
Data type representing the SQL DROP statement.
Constructors
SqlDropDB StringDelete a database
SqlDropTable SqlTableDelete a table named SqlTable
data SqlExpr Source
Expressions in SQL statements.
Constructors
ColumnSqlExpr SqlColumn
BinSqlExpr String SqlExpr SqlExpr
PrefixSqlExpr String SqlExpr
PostfixSqlExpr String SqlExpr
FunSqlExpr String [SqlExpr]
ConstSqlExpr String
CaseSqlExpr [(SqlExpr, SqlExpr)] SqlExpr
ListSqlExpr [SqlExpr]
ExistsSqlExpr SqlSelect
newSelect :: SqlSelectSource
Produced by Haddock version 2.6.0