Database.HaskellDB.Sql.Default

Default SQL generation.

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

Arguments

:: 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

Arguments

:: 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

Arguments

:: SqlGenerator

-> TableName

Name of the table

-> Assoc

What to insert.

-> SqlInsert

Creates a SqlInsert.

defaultSqlInsertQuery

Arguments

:: 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

Arguments

:: 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

Arguments

:: 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

defaultSqlGroup :: SqlGenerator -> Assoc -> SqlSelect -> SqlSelect

Ensures the groupby value on the SqlSelect either preserves existing grouping or that it will group on all columns (i.e, Mark == All).

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

defaultSqlExpr :: SqlGenerator -> PrimExpr -> SqlExpr

defaultSqlLiteral :: SqlGenerator -> Literal -> String

defaultSqlType :: SqlGenerator -> FieldType -> SqlType

defaultSqlQuote :: SqlGenerator -> String -> String

Utilities

toSqlSelect :: SqlSelect -> SqlSelect

Make sure our SqlSelect statement is really a SqlSelect and not another constructor.