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 SqlExpr
  • = ColumnSqlExpr SqlColumn
  • | CompositeSqlExpr SqlExpr String
  • | BinSqlExpr String SqlExpr SqlExpr
  • | PrefixSqlExpr String SqlExpr
  • | PostfixSqlExpr String SqlExpr
  • | FunSqlExpr String [SqlExpr]
  • | AggrFunSqlExpr String [SqlExpr] [(SqlExpr, SqlOrder)]
  • | ConstSqlExpr String
  • | CaseSqlExpr (NonEmpty (SqlExpr, SqlExpr)) SqlExpr
  • | ListSqlExpr (NonEmpty SqlExpr)
  • | ParamSqlExpr (Maybe SqlName) SqlExpr
  • | PlaceHolderSqlExpr
  • | ParensSqlExpr SqlExpr
  • | CastSqlExpr String SqlExpr
  • | DefaultSqlExpr
  • | ArraySqlExpr [SqlExpr]
• data SqlUpdate = SqlUpdate SqlTable [(SqlColumn, SqlExpr)] [SqlExpr]
• data SqlDelete = SqlDelete SqlTable [SqlExpr]
• data SqlInsert = SqlInsert SqlTable [SqlColumn] (NonEmpty [SqlExpr])

SQL data type