Safe Haskell	Safe-Inferred
Language	Haskell2010

Opaleye.Internal.HaskellDB.Sql

Contents

SQL data type

Synopsis

data SqlTable = SqlTable {
- sqlTableSchemaName :: Maybe String
- sqlTableName :: String
}
newtype SqlColumn = SqlColumn String
type SqlName = String
data SqlOrderNulls
- = SqlNullsFirst
- | SqlNullsLast
data SqlOrderDirection
- = SqlAsc
- | SqlDesc
data SqlOrder = SqlOrder {
- sqlOrderDirection :: SqlOrderDirection
- sqlOrderNulls :: SqlOrderNulls
}
data SqlPartition = SqlPartition {
- sqlPartitionBy :: Maybe (NonEmpty SqlExpr)
- sqlOrderBy :: Maybe (NonEmpty (SqlExpr, SqlOrder))
}
data SqlRangeBound
- = Inclusive SqlExpr
- | Exclusive SqlExpr
- | PosInfinity
- | NegInfinity
data SqlDistinct
- = SqlDistinct
- | SqlNotDistinct
data SqlExpr
- = 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 [(SqlExpr, SqlOrder)] (Maybe SqlExpr)
- | WndwFunSqlExpr String [SqlExpr] SqlPartition
- | ConstSqlExpr String
- | CaseSqlExpr (NonEmpty (SqlExpr, SqlExpr)) SqlExpr
- | ListSqlExpr (NonEmpty SqlExpr)
- | ParamSqlExpr (Maybe SqlName) SqlExpr
- | PlaceHolderSqlExpr
- | ParensSqlExpr SqlExpr
- | CastSqlExpr String SqlExpr
- | DefaultSqlExpr
- | ArraySqlExpr [SqlExpr]
- | RangeSqlExpr String SqlRangeBound SqlRangeBound
data SqlUpdate = SqlUpdate SqlTable [(SqlColumn, SqlExpr)] [SqlExpr]
data SqlDelete = SqlDelete SqlTable [SqlExpr]
data OnConflict = DoNothing
data SqlInsert = SqlInsert SqlTable [SqlColumn] (NonEmpty [SqlExpr]) (Maybe OnConflict)

SQL data type

data SqlTable Source #

Constructors

SqlTable
Fields sqlTableSchemaName :: Maybe String sqlTableName :: String

Instances

Instances details

Show SqlTable Source #
Instance details Defined in Opaleye.Internal.HaskellDB.Sql Methods showsPrec :: Int -> SqlTable -> ShowS # show :: SqlTable -> String # showList :: [SqlTable] -> ShowS #

newtype SqlColumn Source #

Constructors

SqlColumn String

Instances

Instances details

Show SqlColumn Source #
Instance details Defined in Opaleye.Internal.HaskellDB.Sql Methods showsPrec :: Int -> SqlColumn -> ShowS # show :: SqlColumn -> String # showList :: [SqlColumn] -> ShowS #

type SqlName = String Source #

A valid SQL name for a parameter.

data SqlOrderNulls Source #

Constructors

SqlNullsFirst
SqlNullsLast

Instances

Instances details

Show SqlOrderNulls Source #
Instance details Defined in Opaleye.Internal.HaskellDB.Sql Methods showsPrec :: Int -> SqlOrderNulls -> ShowS # show :: SqlOrderNulls -> String # showList :: [SqlOrderNulls] -> ShowS #

data SqlOrderDirection Source #

Constructors

SqlAsc
SqlDesc

Instances

Instances details

Show SqlOrderDirection Source #
Instance details Defined in Opaleye.Internal.HaskellDB.Sql Methods showsPrec :: Int -> SqlOrderDirection -> ShowS # show :: SqlOrderDirection -> String # showList :: [SqlOrderDirection] -> ShowS #

data SqlOrder Source #

Constructors

SqlOrder
Fields sqlOrderDirection :: SqlOrderDirection sqlOrderNulls :: SqlOrderNulls

Instances

Instances details

Show SqlOrder Source #
Instance details Defined in Opaleye.Internal.HaskellDB.Sql Methods showsPrec :: Int -> SqlOrder -> ShowS # show :: SqlOrder -> String # showList :: [SqlOrder] -> ShowS #

data SqlPartition Source #

Constructors

SqlPartition
Fields sqlPartitionBy :: Maybe (NonEmpty SqlExpr) sqlOrderBy :: Maybe (NonEmpty (SqlExpr, SqlOrder))

Instances

Instances details

Show SqlPartition Source #
Instance details Defined in Opaleye.Internal.HaskellDB.Sql Methods showsPrec :: Int -> SqlPartition -> ShowS # show :: SqlPartition -> String # showList :: [SqlPartition] -> ShowS #

data SqlRangeBound Source #

Constructors

Inclusive SqlExpr
Exclusive SqlExpr
PosInfinity
NegInfinity

Instances

Instances details

Show SqlRangeBound Source #
Instance details Defined in Opaleye.Internal.HaskellDB.Sql Methods showsPrec :: Int -> SqlRangeBound -> ShowS # show :: SqlRangeBound -> String # showList :: [SqlRangeBound] -> ShowS #

data SqlDistinct Source #

Constructors

SqlDistinct
SqlNotDistinct

Instances

Instances details

Show SqlDistinct Source #
Instance details Defined in Opaleye.Internal.HaskellDB.Sql Methods showsPrec :: Int -> SqlDistinct -> ShowS # show :: SqlDistinct -> String # showList :: [SqlDistinct] -> ShowS #

data SqlExpr Source #

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 [(SqlExpr, SqlOrder)] (Maybe SqlExpr)	Aggregate functions separate from normal functions.
WndwFunSqlExpr String [SqlExpr] SqlPartition
ConstSqlExpr String
CaseSqlExpr (NonEmpty (SqlExpr, SqlExpr)) SqlExpr
ListSqlExpr (NonEmpty SqlExpr)
ParamSqlExpr (Maybe SqlName) SqlExpr
PlaceHolderSqlExpr
ParensSqlExpr SqlExpr
CastSqlExpr String SqlExpr
DefaultSqlExpr
ArraySqlExpr [SqlExpr]
RangeSqlExpr String SqlRangeBound SqlRangeBound

Instances

Instances details

Show SqlExpr Source #
Instance details Defined in Opaleye.Internal.HaskellDB.Sql Methods showsPrec :: Int -> SqlExpr -> ShowS # show :: SqlExpr -> String # showList :: [SqlExpr] -> ShowS #

data SqlUpdate Source #

Data type for SQL UPDATE statements.

Constructors

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

data SqlDelete Source #

Data type for SQL DELETE statements.

Constructors

SqlDelete SqlTable [SqlExpr]

data OnConflict Source #

Constructors

DoNothing

Deprecated: Use doNothing instead. DoNothing will be removed in version 0.11

ON CONFLICT DO NOTHING

data SqlInsert Source #

Constructors

SqlInsert SqlTable [SqlColumn] (NonEmpty [SqlExpr]) (Maybe OnConflict)