Database.Relational.SimpleSql

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.

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.

Delete SQL

deletePrefixSQL

Arguments

:: Table r

Table metadata

-> StringSQL

Result SQL

Generate all column delete SQL by specified table.