relational-query-0.10.0.0: Typeful, Modular, Relational, algebraic query engine

Copyright2013-2017 Kei Hibino
LicenseBSD3
Maintainerex8k.hibino@gmail.com
Stabilityexperimental
Portabilityunknown
Safe HaskellNone
LanguageHaskell2010

Database.Relational.SimpleSql

Contents

Description

This module defines functions to generate simple SQL strings.

Synopsis

Query suffix

type QuerySuffix = [Keyword] Source #

Type for query suffix words

showsQuerySuffix :: QuerySuffix -> StringSQL Source #

Expand query suffix words

Update SQL

updatePrefixSQL :: Table r -> StringSQL Source #

Generate prefix string of update SQL.

updateOtherThanKeySQL Source #

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 Source #

Generate prefix string of insert SQL.

Delete SQL

deletePrefixSQL Source #

Arguments

:: Table r

Table metadata

-> StringSQL

Result SQL

Generate all column delete SQL by specified table.