Database.Relational.Query.SQL

This module defines functions to generate simple SQL strings.

Query suffix

type QuerySuffix = [Keyword]

Type for query suffix words

showsQuerySuffix :: QuerySuffix -> StringSQL

Expand query suffix words

Update SQL

updatePrefixSQL :: Table r -> StringSQL

Generate prefix string of update SQL.

updateSQL'

Arguments

:: String

Table name

-> [StringSQL]

Column name list to update

-> [StringSQL]

Key column name list

-> String

Result SQL

Generate update SQL by specified key and table. Columns name list of table are also required.

updateOtherThanKeySQL'

Arguments

:: String

Table name

-> [StringSQL]

Column name list

-> [Int]

Key column indexes

-> String

Result SQL

Generate update SQL by specified key and table. Columns name list of table are also required.

updateOtherThanKeySQL

Arguments

:: Table r

Table metadata

-> Pi r p

Key columns

-> String

Result SQL

Generate update SQL specified by single key.

Insert SQL

insertPrefixSQL :: Pi r r' -> Table r -> StringSQL

Generate prefix string of insert SQL.

insertSQL

Arguments

:: Pi r r'

Columns selector to insert

-> Table r

Table metadata

-> String

Result SQL

Generate insert SQL.

insertSizedChunkSQL

Arguments

:: Pi r r'

Columns selector to insert

-> Table r

Table metadata

-> Int

Chunk size threshold (column count)

-> (String, Int)

Result SQL and records count of chunk

Generate size measured records chunk insert SQL.

Delete SQL

deletePrefixSQL' :: String -> StringSQL

Generate all column delete SQL by specified table. Untyped table version.

deletePrefixSQL

Arguments

:: Table r

Table metadata

-> StringSQL

Result SQL

Generate all column delete SQL by specified table.