haskelldb-0.10: SQL unwrapper for Haskell. Contents Index

Database.HaskellDB.Sql Portability non-portable Stability experimental Maintainer haskelldb-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 :: [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] newSelect :: SqlSelect

Documentation

type SqlTable = String

type SqlColumn = String

data SqlOrder

Constructors SqlAsc SqlDesc

data SqlType

Constructors SqlType String SqlType1 String Int SqlType2 String Int Int

data SqlSelect

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

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] ConstSqlExpr String CaseSqlExpr [(SqlExpr, SqlExpr)] SqlExpr ListSqlExpr [SqlExpr]

newSelect :: SqlSelect

Produced by Haddock version 0.8