Opaleye.Internal.HaskellDB.Sql

SQL data type

data SqlTable

Constructors

SqlTable

Fields

• sqlTableSchemaName :: Maybe String
• sqlTableName :: String

Instances

Show SqlTable

Methods

showsPrec :: Int -> SqlTable -> ShowS

show :: SqlTable -> String

showList :: [SqlTable] -> ShowS

newtype SqlColumn

Constructors

SqlColumn String

Instances

Show SqlColumn

Methods

showsPrec :: Int -> SqlColumn -> ShowS

show :: SqlColumn -> String

showList :: [SqlColumn] -> ShowS

type SqlName = String

A valid SQL name for a parameter.

data SqlOrderNulls

Constructors

SqlNullsFirst

SqlNullsLast

Instances

Show SqlOrderNulls

Methods

showsPrec :: Int -> SqlOrderNulls -> ShowS

show :: SqlOrderNulls -> String

showList :: [SqlOrderNulls] -> ShowS

data SqlOrderDirection

Constructors

SqlAsc

SqlDesc

Instances

Show SqlOrderDirection

Methods

showsPrec :: Int -> SqlOrderDirection -> ShowS

show :: SqlOrderDirection -> String

showList :: [SqlOrderDirection] -> ShowS

data SqlOrder

Constructors

SqlOrder

Fields

• sqlOrderDirection :: SqlOrderDirection
• sqlOrderNulls :: SqlOrderNulls

Instances

Show SqlOrder

Methods

showsPrec :: Int -> SqlOrder -> ShowS

show :: SqlOrder -> String

showList :: [SqlOrder] -> ShowS

data SqlRangeBound

Constructors

Inclusive SqlExpr

Exclusive SqlExpr

PosInfinity

NegInfinity

Instances

Show SqlRangeBound

Methods

showsPrec :: Int -> SqlRangeBound -> ShowS

show :: SqlRangeBound -> String

showList :: [SqlRangeBound] -> ShowS

data SqlDistinct

Constructors

SqlDistinct

SqlNotDistinct

Instances

Show SqlDistinct

Methods

showsPrec :: Int -> SqlDistinct -> ShowS

show :: SqlDistinct -> String

showList :: [SqlDistinct] -> ShowS

data SqlExpr

Expressions in SQL statements.

Constructors

ColumnSqlExpr SqlColumn

CompositeSqlExpr SqlExpr String

BinSqlExpr String SqlExpr SqlExpr

SubscriptSqlExpr SqlExpr SqlExpr

PrefixSqlExpr String SqlExpr

PostfixSqlExpr String SqlExpr

FunSqlExpr String [SqlExpr]

AggrFunSqlExpr String [SqlExpr] [(SqlExpr, SqlOrder)] SqlDistinct

Aggregate functions separate from normal functions.

ConstSqlExpr String

CaseSqlExpr (NonEmpty (SqlExpr, SqlExpr)) SqlExpr

ListSqlExpr (NonEmpty SqlExpr)

ParamSqlExpr (Maybe SqlName) SqlExpr

PlaceHolderSqlExpr

ParensSqlExpr SqlExpr

CastSqlExpr String SqlExpr

DefaultSqlExpr

ArraySqlExpr [SqlExpr]

RangeSqlExpr SqlRangeBound SqlRangeBound

Instances

Show SqlExpr

Methods

showsPrec :: Int -> SqlExpr -> ShowS

show :: SqlExpr -> String

showList :: [SqlExpr] -> ShowS

data SqlUpdate

Data type for SQL UPDATE statements.

Constructors

SqlUpdate SqlTable [(SqlColumn, SqlExpr)] [SqlExpr]

data SqlDelete

Data type for SQL DELETE statements.

Constructors

SqlDelete SqlTable [SqlExpr]

data SqlInsert

Constructors

SqlInsert SqlTable [SqlColumn] (NonEmpty [SqlExpr])