Database.HaskellDB.Sql.Generate

The type of SQL generators.

Documentation

data SqlGenerator

Constructors

SqlGenerator

Fields

sqlQuery :: PrimQuery -> SqlSelect

sqlUpdate :: TableName -> [PrimExpr] -> Assoc -> SqlUpdate

sqlDelete :: TableName -> [PrimExpr] -> SqlDelete

sqlInsert :: TableName -> Assoc -> SqlInsert

sqlInsertQuery :: TableName -> PrimQuery -> SqlInsert

sqlCreateDB :: String -> SqlCreate

sqlCreateTable :: TableName -> [(Attribute, FieldDesc)] -> SqlCreate

sqlDropDB :: String -> SqlDrop

sqlDropTable :: TableName -> SqlDrop

sqlEmpty :: SqlSelect

sqlTable :: TableName -> Scheme -> SqlSelect

sqlProject :: Assoc -> SqlSelect -> SqlSelect

sqlGroup :: Assoc -> SqlSelect -> SqlSelect

Ensures non-aggregate expressions in the select are included in group by clause.

sqlRestrict :: PrimExpr -> SqlSelect -> SqlSelect

sqlBinary :: RelOp -> SqlSelect -> SqlSelect -> SqlSelect

sqlSpecial :: SpecialOp -> SqlSelect -> SqlSelect

sqlExpr :: PrimExpr -> SqlExpr

sqlLiteral :: Literal -> String

sqlType :: FieldType -> SqlType

sqlQuote :: String -> String

Turn a string into a quoted string. Quote characters and any escaping are handled by this function.