com.northconcepts.datapipeline.sql.postgresql

Class CreateTableColumn

java.lang.Object

com.northconcepts.datapipeline.jdbc.sql.SqlPart

com.northconcepts.datapipeline.sql.postgresql.PostgresSqlPart

com.northconcepts.datapipeline.sql.postgresql.CreateTableColumn

public class CreateTableColumn
extends PostgresSqlPart

Generates a column definition for a CREATE TABLE statement for PostgreSQL.

Sample Generated SQL:

"email" text NOT NULL CONSTRAINT "email_check" CHECK (email LIKE '%@%')

Constructor Summary

Constructors

Constructor and Description
CreateTableColumn()
CreateTableColumn(String columnName, TableColumnType type)
CreateTableColumn(String columnName, TableColumnType type, Integer length)
CreateTableColumn(String columnName, TableColumnType type, Integer length, Integer scale)

Method Summary

Modifier and Type	Method and Description
void	collectSqlFragment(CodeWriter writer)
String	getCheckConstraintCondition()
String	getCheckConstraintName()
String	getColumnName()
String	getDefaultValue()
Integer	getLength()
Integer	getScale()
TableColumnType	getType()
boolean	isNullable()
boolean	isPrimaryKey()
boolean	isUnique()
CreateTableColumn	setCheckConstraint(String checkConstraintName, String condition) Appends a check constraint to the column definition.
CreateTableColumn	setCheckConstraintCondition(String checkConstraintCondition)
CreateTableColumn	setCheckConstraintName(String checkConstraintName)
CreateTableColumn	setColumnName(String columnName)
CreateTableColumn	setDefaultValue(String defaultValue)
CreateTableColumn	setLength(Integer length)
CreateTableColumn	setNullable(boolean nullable)
CreateTableColumn	setPretty(boolean pretty)
CreateTableColumn	setPrimaryKey(boolean primaryKey)
CreateTableColumn	setScale(Integer scale)
CreateTableColumn	setType(TableColumnType type)
CreateTableColumn	setUnique(boolean unique)

Methods inherited from class com.northconcepts.datapipeline.sql.postgresql.PostgresSqlPart

escapeKeyword

Methods inherited from class com.northconcepts.datapipeline.jdbc.sql.SqlPart

collectParameterValues, getParameterValues, getSqlFragment, isPretty, printSqlParts, toString

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

CreateTableColumn

public CreateTableColumn()

CreateTableColumn

public CreateTableColumn(String columnName,
                         TableColumnType type,
                         Integer length,
                         Integer scale)

CreateTableColumn

public CreateTableColumn(String columnName,
                         TableColumnType type,
                         Integer length)

CreateTableColumn

public CreateTableColumn(String columnName,
                         TableColumnType type)

Method Detail

setPretty

public CreateTableColumn setPretty(boolean pretty)

Overrides:

setPretty in class SqlPart

collectSqlFragment

public void collectSqlFragment(CodeWriter writer)

Specified by:

collectSqlFragment in class SqlPart

getColumnName

public String getColumnName()

setColumnName

public CreateTableColumn setColumnName(String columnName)

getType

public TableColumnType getType()

setType

public CreateTableColumn setType(TableColumnType type)

getLength

public Integer getLength()

setLength

public CreateTableColumn setLength(Integer length)

getScale

public Integer getScale()

setScale

public CreateTableColumn setScale(Integer scale)

isNullable

public boolean isNullable()

setNullable

public CreateTableColumn setNullable(boolean nullable)

isUnique

public boolean isUnique()

setUnique

public CreateTableColumn setUnique(boolean unique)

getDefaultValue

public String getDefaultValue()

setDefaultValue

public CreateTableColumn setDefaultValue(String defaultValue)

getCheckConstraintCondition

public String getCheckConstraintCondition()

setCheckConstraintCondition

public CreateTableColumn setCheckConstraintCondition(String checkConstraintCondition)

getCheckConstraintName

public String getCheckConstraintName()

setCheckConstraintName

public CreateTableColumn setCheckConstraintName(String checkConstraintName)

setCheckConstraint

public CreateTableColumn setCheckConstraint(String checkConstraintName,
                                            String condition)

Appends a check constraint to the column definition.

Sample Generated SQL:

CONSTRAINT "check_constraint_name" CHECK (check_condition)

isPrimaryKey

public boolean isPrimaryKey()

setPrimaryKey

public CreateTableColumn setPrimaryKey(boolean primaryKey)