Safe Haskell | Safe-Inferred |
---|---|
Language | Haskell2010 |
Synopsis
- data SqlTable = SqlTable {}
- newtype SqlColumn = SqlColumn String
- type SqlName = String
- data SqlOrderNulls
- data SqlOrderDirection
- data SqlOrder = SqlOrder {}
- data SqlPartition = SqlPartition {
- sqlPartitionBy :: Maybe (NonEmpty SqlExpr)
- sqlOrderBy :: Maybe (NonEmpty (SqlExpr, SqlOrder))
- data SqlRangeBound
- data SqlDistinct
- 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 SqlOrderNulls Source #
Instances
Show SqlOrderNulls Source # | |
Defined in Opaleye.Internal.HaskellDB.Sql showsPrec :: Int -> SqlOrderNulls -> ShowS # show :: SqlOrderNulls -> String # showList :: [SqlOrderNulls] -> ShowS # |
data SqlOrderDirection Source #
Instances
Show SqlOrderDirection Source # | |
Defined in Opaleye.Internal.HaskellDB.Sql showsPrec :: Int -> SqlOrderDirection -> ShowS # show :: SqlOrderDirection -> String # showList :: [SqlOrderDirection] -> ShowS # |
data SqlPartition Source #
SqlPartition | |
|
Instances
Show SqlPartition Source # | |
Defined in Opaleye.Internal.HaskellDB.Sql showsPrec :: Int -> SqlPartition -> ShowS # show :: SqlPartition -> String # showList :: [SqlPartition] -> ShowS # |
data SqlRangeBound Source #
Instances
Show SqlRangeBound Source # | |
Defined in Opaleye.Internal.HaskellDB.Sql showsPrec :: Int -> SqlRangeBound -> ShowS # show :: SqlRangeBound -> String # showList :: [SqlRangeBound] -> ShowS # |
data SqlDistinct Source #
Instances
Show SqlDistinct Source # | |
Defined in Opaleye.Internal.HaskellDB.Sql showsPrec :: Int -> SqlDistinct -> ShowS # show :: SqlDistinct -> String # showList :: [SqlDistinct] -> ShowS # |
Expressions in SQL statements.
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 |
Data type for SQL UPDATE statements.
data OnConflict Source #
DoNothing | Deprecated: Use ON CONFLICT DO NOTHING |