Type Members

1.  case class AddColumn(columnName: String, columnType: DataType, default: Option[Default], encode: Option[CompressionEncoding], nullability: Option[Nullability]) extends AlterTableStatement with Product with Serializable
2.  case class AddConstraint(tableConstraint: TableConstraint) extends AlterTableStatement with Product with Serializable
3.  case class AlterTable(tableName: String, statement: AlterTableStatement) extends Statement with Product with Serializable

   Class holding data to alter some table with single AlterTableStatement

   Class holding data to alter some table with single AlterTableStatement

   See also

   http://docs.aws.amazon.com/redshift/latest/dg/r_ALTER_TABLE.html ALTER TABLE table_name { ADD table_constraint | DROP CONSTRAINT constraint_name [ RESTRICT | CASCADE ] | OWNER TO new_owner | RENAME TO new_name | RENAME COLUMN column_name TO new_name | ADD [ COLUMN ] column_name column_type [ DEFAULT default_expr ] [ ENCODE encoding ] [ NOT NULL | NULL ] | DROP [ COLUMN ] column_name [ RESTRICT | CASCADE ] } where table_constraint is: [ CONSTRAINT constraint_name ] { UNIQUE ( column_name [, ... ] ) | PRIMARY KEY ( column_name [, ... ] ) | FOREIGN KEY (column_name [, ... ] ) REFERENCES reftable [ ( refcolumn ) ]}

4.  sealed trait AlterTableStatement extends Ddl

   Sum-type to represent some statement

5.  case class AlterType(columnName: String, dataType: DataType) extends AlterTableStatement with Product with Serializable
6.  case class Begin(isolationLevel: Option[IsolationLevel.type], permission: Option[Permission]) extends Statement with Product with Serializable
7.  case class Column(columnName: String, dataType: DataType, columnAttributes: Set[ColumnAttribute] = Set.empty[ColumnAttribute], columnConstraints: Set[ColumnConstraint] = Set.empty[ColumnConstraint]) extends Ddl with Product with Serializable

   Class holding all information about Redshift's column

   Class holding all information about Redshift's column

   columnName

   column_name

   dataType

   data_type such as INTEGER, VARCHAR, etc

   columnAttributes

   set of column_attributes such as ENCODE

   columnConstraints

   set of column_constraints such as NOT NULL

8.  sealed trait ColumnAttribute extends Ddl

   column_attributes are: [ DEFAULT default_expr ] [ IDENTITY ( seed, step ) ] [ ENCODE encoding ] [ DISTKEY ] [ SORTKEY ]

9.  sealed trait ColumnConstraint extends Ddl

   column_constraints are: [ { NOT NULL | NULL } ] [ { UNIQUE | PRIMARY KEY } ] [ REFERENCES reftable [ ( refcolumn ) ] ]

10.  case class CommentBlock(lines: Vector[String], prepend: Int = 0) extends Statement with Product with Serializable

    Class representing comment block in Ddl file Can be rendered into file along with other Ddl-statements

    Class representing comment block in Ddl file Can be rendered into file along with other Ddl-statements

    lines

    sequence of lines

    prepend

    optional amount of spaces to prepend delimiter (--)

11.  case class CommentOn(tableName: String, comment: String) extends Statement with Product with Serializable

    COMMENT ON { TABLE object_name | COLUMN object_name.column_name | CONSTRAINT constraint_name ON table_name | DATABASE object_name | VIEW object_name } IS 'text'

12.  case class CompressionEncoding(value: CompressionEncodingValue) extends ColumnAttribute with Product with Serializable

    Compression encodings http://docs.aws.amazon.com/redshift/latest/dg/c_Compression_encodings.html

13.  sealed trait CompressionEncodingValue extends Ddl
14.  case class CreateSchema(schemaName: String) extends Statement with Product with Serializable
15.  case class CreateTable(tableName: String, columns: List[Column], tableConstraints: Set[TableConstraint] = Set.empty[TableConstraint], tableAttributes: Set[TableAttribute] = Set.empty[TableAttribute]) extends Statement with Product with Serializable

    Class holding all information about Redshift's table

    Class holding all information about Redshift's table

    tableName

    table_name

    columns

    iterable of all columns DDLs

    tableConstraints

    set of table_constraints such as PRIMARY KEY

    tableAttributes

    set of table_attributes such as DISTSTYLE

16.  sealed trait DataType extends Ddl

    Data types http://docs.aws.amazon.com/redshift/latest/dg/c_Supported_data_types.html

17.  trait Ddl extends AnyRef

    Base class for everything that can be represented as Redshift DDL

18.  case class Default(value: String) extends ColumnAttribute with Product with Serializable
19.  case class DistKeyTable(columnName: String) extends TableAttribute with Product with Serializable
20.  case class Diststyle(diststyle: DiststyleValue) extends TableAttribute with Product with Serializable
21.  sealed trait DiststyleValue extends Ddl
22.  case class DropColumn(columnName: String, mode: Option[DropMode]) extends Ddl with Product with Serializable
23.  case class DropConstraint(constraintName: String, mode: Option[DropMode]) extends AlterTableStatement with Product with Serializable
24.  case class DropMode(value: DropModeValue) extends Ddl with Product with Serializable
25.  sealed trait DropModeValue extends Ddl
26.  case class ForeignKeyTable(columns: NonEmptyList[String], reftable: RefTable) extends TableConstraint with Product with Serializable
27.  case class Identity(seed: Int, step: Int) extends ColumnAttribute with Product with Serializable
28.  case class KeyConstaint(value: KeyConstraintValue) extends ColumnConstraint with Product with Serializable
29.  sealed trait KeyConstraintValue extends Ddl
30.  case class Nullability(value: NullabilityValue) extends ColumnConstraint with Product with Serializable
31.  sealed trait NullabilityValue extends Ddl
32.  case class OwnerTo(newOwner: String) extends AlterTableStatement with Product with Serializable
33.  sealed trait Permission extends Ddl
34.  case class PrimaryKeyTable(columns: NonEmptyList[String]) extends TableConstraint with Product with Serializable
35.  case class ProductType(warnings: List[String], size: Option[Int]) extends DataType with Product with Serializable

    These predefined data types assembles into usual Redshift data types, but can store additional information such as warnings.

    These predefined data types assembles into usual Redshift data types, but can store additional information such as warnings. Using to prevent output on DDL-generation step.

36.  case class RedshiftChar(size: Int) extends DataType with Product with Serializable
37.  case class RedshiftDecimal(precision: Option[Int], scale: Option[Int]) extends DataType with Product with Serializable
38.  case class RedshiftVarchar(size: Int) extends DataType with Product with Serializable
39.  case class RefTable(reftable: String, refcolumn: Option[String]) extends Ddl with Product with Serializable

    Reference table.

    Reference table. Used in foreign key and table constraint

    reftable

    name of table

    refcolumn

    optional column

40.  case class RenameColumn(columnName: String, newName: String) extends AlterTableStatement with Product with Serializable
41.  case class RenameTo(newName: String) extends AlterTableStatement with Product with Serializable
42.  case class SortKeyTable(sortstyle: Option[Sortstyle], columns: NonEmptyList[String]) extends TableAttribute with Product with Serializable
43.  sealed trait Sortstyle extends Ddl
44.  trait Statement extends Ddl with Product with Serializable

    Trait for *independent* SQL DDL statements.

    Trait for *independent* SQL DDL statements. Unlike simple Ddl objects, these can be used as stand-alone commands and be content of file. We're always using semicolon in the end of statements

45.  sealed trait TableAttribute extends Ddl

    table_attributes are: [ DISTSTYLE { EVEN | KEY | ALL } ] [ DISTKEY ( column_name ) ] [ [COMPOUND | INTERLEAVED ] SORTKEY ( column_name [, ...] ) ]

46.  sealed trait TableConstraint extends Ddl

    table_constraints are: [ UNIQUE ( column_name [, ...

    table_constraints are: [ UNIQUE ( column_name [, ... ] ) ] [ PRIMARY KEY ( column_name [, ... ] ) ] [ FOREIGN KEY (column_name [, ... ] ) REFERENCES reftable [ ( refcolumn ) ]

47.  case class UniqueKeyTable(columns: NonEmptyList[String]) extends TableConstraint with Product with Serializable