Safe Haskell	Safe-Inferred
Language	Haskell2010

Opaleye.SQLite.Internal.HaskellDB.Sql

Contents

SQL data type

Synopsis

newtype SqlTable = SqlTable String
newtype SqlColumn = SqlColumn String
type SqlName = String
data SqlOrderNulls
- = SqlNullsFirst
- | SqlNullsLast
data SqlOrderDirection
- = SqlAsc
- | SqlDesc
data SqlOrder = SqlOrder {
- sqlOrderDirection :: SqlOrderDirection
- sqlOrderNulls :: SqlOrderNulls
}
data SqlExpr
- = ColumnSqlExpr SqlColumn
- | BinSqlExpr String SqlExpr SqlExpr
- | PrefixSqlExpr String SqlExpr
- | PostfixSqlExpr String SqlExpr
- | FunSqlExpr String [SqlExpr]
- | AggrFunSqlExpr String [SqlExpr]
- | ConstSqlExpr String
- | CaseSqlExpr [(SqlExpr, SqlExpr)] SqlExpr
- | ListSqlExpr [SqlExpr]
- | ParamSqlExpr (Maybe SqlName) SqlExpr
- | PlaceHolderSqlExpr
- | ParensSqlExpr SqlExpr
- | CastSqlExpr String SqlExpr
- | DefaultSqlExpr
data SqlUpdate = SqlUpdate SqlTable [(SqlColumn, SqlExpr)] [SqlExpr]
data SqlDelete = SqlDelete SqlTable [SqlExpr]
data SqlInsert = SqlInsert SqlTable [SqlColumn] (NonEmpty [SqlExpr])

SQL data type

newtype SqlTable Source #

Constructors

SqlTable String

Instances

Instances details

Show SqlTable Source #
Instance details Defined in Opaleye.SQLite.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.SQLite.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.SQLite.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.SQLite.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.SQLite.Internal.HaskellDB.Sql Methods showsPrec :: Int -> SqlOrder -> ShowS # show :: SqlOrder -> String # showList :: [SqlOrder] -> ShowS #

data SqlExpr Source #

Expressions in SQL statements.

Constructors

ColumnSqlExpr SqlColumn
BinSqlExpr String SqlExpr SqlExpr
PrefixSqlExpr String SqlExpr
PostfixSqlExpr String SqlExpr
FunSqlExpr String [SqlExpr]
AggrFunSqlExpr String [SqlExpr]	Aggregate functions separate from normal functions.
ConstSqlExpr String
CaseSqlExpr [(SqlExpr, SqlExpr)] SqlExpr
ListSqlExpr [SqlExpr]
ParamSqlExpr (Maybe SqlName) SqlExpr
PlaceHolderSqlExpr
ParensSqlExpr SqlExpr
CastSqlExpr String SqlExpr
DefaultSqlExpr

Instances

Instances details

Show SqlExpr Source #
Instance details Defined in Opaleye.SQLite.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 SqlInsert Source #

Constructors

SqlInsert SqlTable [SqlColumn] (NonEmpty [SqlExpr])