haskelldb-0.10: SQL unwrapper for Haskell. Contents Index

Database.HaskellDB.Sql.Default Portability non-portable Stability experimental Maintainer haskelldb-users@lists.sourceforge.net

Contents Utilities

Description

Default SQL generation.

Synopsis

mkSqlGenerator :: SqlGenerator -> SqlGenerator defaultSqlGenerator :: SqlGenerator defaultSqlQuery :: SqlGenerator -> PrimQuery -> SqlSelect defaultSqlUpdate :: SqlGenerator -> TableName -> [PrimExpr] -> Assoc -> SqlUpdate defaultSqlDelete :: SqlGenerator -> TableName -> [PrimExpr] -> SqlDelete defaultSqlInsert :: SqlGenerator -> TableName -> Assoc -> SqlInsert defaultSqlInsertQuery :: SqlGenerator -> TableName -> PrimQuery -> SqlInsert defaultSqlCreateDB :: SqlGenerator -> String -> SqlCreate defaultSqlCreateTable :: SqlGenerator -> TableName -> [(Attribute, FieldDesc)] -> SqlCreate defaultSqlDropDB :: SqlGenerator -> String -> SqlDrop defaultSqlDropTable :: SqlGenerator -> TableName -> SqlDrop defaultSqlEmpty :: SqlGenerator -> SqlSelect defaultSqlTable :: SqlGenerator -> TableName -> Scheme -> SqlSelect defaultSqlProject :: SqlGenerator -> Assoc -> SqlSelect -> SqlSelect defaultSqlRestrict :: SqlGenerator -> PrimExpr -> SqlSelect -> SqlSelect defaultSqlBinary :: SqlGenerator -> RelOp -> SqlSelect -> SqlSelect -> SqlSelect defaultSqlSpecial :: SqlGenerator -> SpecialOp -> SqlSelect -> SqlSelect defaultSqlExpr :: SqlGenerator -> PrimExpr -> SqlExpr defaultSqlLiteral :: SqlGenerator -> Literal -> String defaultSqlType :: SqlGenerator -> FieldType -> SqlType toSqlSelect :: SqlSelect -> SqlSelect

Documentation

mkSqlGenerator :: SqlGenerator -> SqlGenerator

defaultSqlGenerator :: SqlGenerator

defaultSqlQuery :: SqlGenerator -> PrimQuery -> SqlSelect

Creates a SqlSelect based on the PrimQuery supplied. Corresponds to the SQL statement SELECT.

defaultSqlUpdate

:: SqlGenerator -> TableName Name of the table to update. -> [PrimExpr] Conditions which must all be true for a row to be updated. -> Assoc Update the data with this. -> SqlUpdate Creates a SqlUpdate. Corresponds to the SQL statement UPDATE which updates data in a table.

defaultSqlDelete

:: SqlGenerator -> TableName Name of the table -> [PrimExpr] Criteria which must all be true for a row to be deleted. -> SqlDelete Creates a SqlDelete. Corresponds to the SQL statement DELETE which deletes rows in a table.

defaultSqlInsert

:: SqlGenerator -> TableName Name of the table -> Assoc What to insert. -> SqlInsert Creates a SqlInsert.

defaultSqlInsertQuery

:: SqlGenerator -> TableName Name of the table -> PrimQuery What to insert -> SqlInsert Creates a SqlInsert. Corresponds to the SQL statement INSERT INTO which is used to insert new rows in a table.

defaultSqlCreateDB

:: SqlGenerator -> String name of the database. -> SqlCreate Use this to create a SqlCreate data type corresponding to the SQL statement CREATE DATABASE which creates a new database.

defaultSqlCreateTable

:: SqlGenerator -> TableName name of the table to be created. -> [(Attribute, FieldDesc)] Column descriptions -> SqlCreate Use this to create a SqlCreate data type corresponding to the SQL statement CREATE which creates a new table.

defaultSqlDropDB :: SqlGenerator -> String -> SqlDrop

Creates a SqlDrop that delete the database with the name given as the first argument.

defaultSqlDropTable :: SqlGenerator -> TableName -> SqlDrop

Creates a SqlDrop that delete the database named in the first argument.

defaultSqlEmpty :: SqlGenerator -> SqlSelect

defaultSqlTable :: SqlGenerator -> TableName -> Scheme -> SqlSelect

defaultSqlProject :: SqlGenerator -> Assoc -> SqlSelect -> SqlSelect

defaultSqlRestrict :: SqlGenerator -> PrimExpr -> SqlSelect -> SqlSelect

defaultSqlBinary :: SqlGenerator -> RelOp -> SqlSelect -> SqlSelect -> SqlSelect

defaultSqlSpecial :: SqlGenerator -> SpecialOp -> SqlSelect -> SqlSelect

defaultSqlExpr :: SqlGenerator -> PrimExpr -> SqlExpr

defaultSqlLiteral :: SqlGenerator -> Literal -> String

defaultSqlType :: SqlGenerator -> FieldType -> SqlType

Utilities

toSqlSelect :: SqlSelect -> SqlSelect

Produced by Haddock version 0.8