sqlite-0.4.1: Haskell binding to sqlite3

PortabilityBasic embedding of SQL types in Haskell.
Stabilityprovisional
MaintainerDon Stewart <dons@galois.com>

Database.SQL.Types

Description

Note: the quary part of this modules was imported (with modifications) from the lowest layer of abstraction of HaskellDB.

Synopsis

Documentation

data SQLOrder Source

Constructors

SQLAsc 
SQLDesc 

data SQLSelect Source

Data type for SQL SELECT statements.

Constructors

SQLSelect 

Fields

options :: [String]

DISTINCT, ALL etc. | result, alias. Empty list means select all.

attrs :: [(SQLExpr, String)]
 
tables :: SelectSource

FROM

criteria :: [SQLExpr]

WHERE

groupby :: [SQLExpr]

GROUP BY

orderby :: [(SQLExpr, SQLOrder)]

ORDER BY

extra :: [String]

TOP n, etc.

SQLBin OpName SQLSelect SQLSelect

UNION, etc

Instances

data Join Source

Join with another table.

data TableSource Source

Use empty string for no alias.

data SQLUpdate Source

Data type for SQL UPDATE statements.

Instances

data SQLDelete Source

Data type for SQL DELETE statements.

Constructors

SQLDelete TableName [SQLExpr] 

Instances

data SQLInsert Source

Data type for SQL INSERT statements.

Instances

data SQLCreate a Source

Data type for SQL CREATE statements.

Constructors

SQLCreateDB DatabaseName

Create a database

SQLCreateTable (Table a)

Create a table

Instances

data SQLDrop Source

Data type representing the SQL DROP statement.

Constructors

SQLDropDB DatabaseName

Delete a database

SQLDropTable TableName

Delete a table named SQLTable

Instances

data Table a Source

Constructors

Table 

data Column a Source

We parameterize over column type, since SQL engines do tend to provide their own set of supported datatypes (which may or may not map onto SQL99's set of types.)

Constructors

Column 

Fields

colName :: ColumnName
 
colType :: a
 
colClauses :: [Clause]
 

data SQLType Source

MySQL slanted, but also SQLite friendly if you don't get too fancy..

Instances

data IntType Source

Constructors

TINY 
SMALL 
MEDIUM 
NORMAL 
BIG