Package org.jumpmind.db.platform.db2

Class Db2DdlBuilder

java.lang.Object

org.jumpmind.db.platform.AbstractDdlBuilder

org.jumpmind.db.platform.db2.Db2DdlBuilder

All Implemented Interfaces:

IDdlBuilder

public class Db2DdlBuilder
extends AbstractDdlBuilder

Field Summary

Fields

Modifier and Type	Field	Description
protected boolean	migrateDataToRemoveColumn

Fields inherited from class org.jumpmind.db.platform.AbstractDdlBuilder

caseSensitive, databaseInfo, databaseName, delimitedIdentifierModeOn, log, scriptModeOn, SIZE_PLACEHOLDER, sqlCommentsOn

Constructor Summary

Constructors

Constructor	Description
Db2DdlBuilder()

Method Summary

Modifier and Type	Method	Description
protected String	getNativeDefaultValue(Column column)	Returns the native default value for the column.
String	getSelectLastIdentityValues(Table table)	Generates the SQL for querying the id that was created in the last insertion operation.
String	mapDefaultValue(Object defaultValue, Column column)
protected void	processChange(Database currentModel, Database desiredModel, AddColumnChange change, StringBuilder ddl)
protected void	processChange(Database currentModel, Database desiredModel, PrimaryKeyChange change, StringBuilder ddl)
protected void	processChange(Database currentModel, Database desiredModel, RemoveColumnChange change, StringBuilder ddl)
protected void	processChange(Database currentModel, Database desiredModel, RemovePrimaryKeyChange change, StringBuilder ddl)
protected void	processTableStructureChanges(Database currentModel, Database desiredModel, Table sourceTable, Table targetTable, List<TableChange> changes, StringBuilder ddl)	Allows database-specific implementations to handle changes in a database specific manner.
protected boolean	writeAlterColumnDataTypeToBigInt(ColumnDataTypeChange change, StringBuilder ddl)
protected void	writeCascadeAttributesForForeignKeyUpdate(ForeignKey key, StringBuilder ddl)
protected void	writeCastExpression(Column sourceColumn, Column targetColumn, StringBuilder ddl)	Writes a cast expression that converts the value of the source column to the data type of the target column.
protected void	writeColumnAutoIncrementStmt(Table table, Column column, StringBuilder ddl)	Prints that the column is an auto increment column.
protected void	writeColumnDefaultValue(Table table, Column column, StringBuilder ddl)	Prints the default value of the column.
protected void	writeColumnType(Table table, Column column, StringBuilder ddl)
void	writeExternalIndexDropStmt(Table table, IIndex index, StringBuilder ddl)	Generates the statement to drop a non-embedded index from the database.
protected void	writeExternalPrimaryKeysCreateStmt(Table table, Column[] primaryKeyColumns, StringBuilder ddl)	Writes the primary key constraints of the table as alter table statements.
protected void	writeReorgStmt(Table table, StringBuilder ddl)

Methods inherited from class org.jumpmind.db.platform.AbstractDdlBuilder

addEscapedCharSequence, alterDatabase, alterDatabase, alterTable, areColumnSizesTheSame, areEqual, areMappedTypesTheSame, copy, createBackupTableFor, createExternalForeignKeys, createExternalForeignKeys, createTable, createTable, createTables, createTables, createTemporaryTable, dropExternalForeignKeys, dropTable, dropTable, dropTables, dropTables, dropTemporaryTable, escapeStringValue, filterChanges, filterColumnSqlType, findCorrespondingForeignKey, findForeignKey, findTable, fixLastIdentityValues, getBackupTableFor, getBareNativeType, getColumnName, getColumnTypeDdl, getConstraintName, getCopyDataColumnMapping, getCopyDataColumnOrderedMapping, getDatabaseInfo, getDefaultValueHelper, getDefinitionForGeneratedColumn, getDeleteSql, getDelimitedIdentifier, getDetectedChanges, getForeignKeyName, getFullyQualifiedIndexNameShorten, getFullyQualifiedTableNameShorten, getGapLimitSize, getIndent, getIndexName, getInsertSql, getNativeType, getRealTargetTableFor, getSize, getSqlType, getTableName, getTemporaryTableFor, getTemporaryTableFor, getTriggerDelimiterReplacementCharacters, getUpdateSql, getValueAsString, getValueDateFormat, getValueLocale, getValueNumberFormat, getValueTimeFormat, hasSize, initCteExpression, isAlterDatabase, isCaseSensitive, isDelimitedIdentifierModeOn, isFullTextIndex, isScriptModeOn, isSpecifyIdentityGapLimit, isSqlCommentsOn, isValidDefaultValue, mergeOrRemovePlatformTypes, printComment, printDefaultValue, printEndOfStatement, printIdentifier, printIndent, println, println, printlnIdentifier, printStartOfEmbeddedStatement, processChange, processChange, processChange, processChange, processChange, processChange, processChange, processChange, processChange, processChange, processChange, processChange, processChange, processChange, processChange, processChanges, processChanges, processTableStructureChanges, processTableStructureChanges, renameTable, replaceDelimiterWithEscapeCharacters, restoreTableFromBackup, setCaseSensitive, setDelimitedIdentifierModeOn, setIndent, setScriptModeOn, setSqlCommentsOn, setTriggerDelimiterReplacementCharacters, setValueDateFormat, setValueLocale, setValueNumberFormat, setValueTimeFormat, shortenName, shouldGeneratePrimaryKeys, shouldUseQuotes, writeCascadeAttributesForForeignKey, writeCascadeAttributesForForeignKeyDelete, writeColumn, writeColumnAutoUpdateStmt, writeColumnDefaultValueStmt, writeColumnEmbeddedPrimaryKey, writeColumnNotNullableStmt, writeColumnNullableStmt, writeColumns, writeColumnTypeDefaultRequired, writeColumnUniqueStmt, writeCopyDataStatement, writeCopyDataStatement, writeEmbeddedForeignKeysStmt, writeEmbeddedIndexCreateStmt, writeEmbeddedIndicesStmt, writeEmbeddedPrimaryKeysStmt, writeExternalForeignKeyCreateStmt, writeExternalForeignKeyDropStmt, writeExternalIndexCreate, writeExternalIndexCreateStmt, writeExternalIndicesCreateStmt, writeFixLastIdentityValues, writeForeignReferences, writeGeneratedColumn, writeIdentityGapLimit, writeLocalReferences, writePrimaryKeyStmt, writeTableAlterStmt, writeTableComment, writeTableCreateOpeningStmt, writeTableCreationStmt, writeTableCreationStmtEnding

Methods inherited from class java.lang.Object

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

Field Details

migrateDataToRemoveColumn

protected boolean migrateDataToRemoveColumn

Constructor Details

Db2DdlBuilder

public Db2DdlBuilder()

Method Details

getNativeDefaultValue

protected String getNativeDefaultValue(Column column)

Description copied from class: AbstractDdlBuilder

Returns the native default value for the column.

Overrides:

getNativeDefaultValue in class AbstractDdlBuilder

Parameters:

column - The column

Returns:

The native default value

writeColumnAutoIncrementStmt

protected void writeColumnAutoIncrementStmt(Table table,
 Column column,
 StringBuilder ddl)

Description copied from class: AbstractDdlBuilder

Prints that the column is an auto increment column.

Overrides:

writeColumnAutoIncrementStmt in class AbstractDdlBuilder

getSelectLastIdentityValues

public String getSelectLastIdentityValues(Table table)

Description copied from class: AbstractDdlBuilder

Generates the SQL for querying the id that was created in the last insertion operation. This is obviously only useful for pk fields that are auto-incrementing. A database that does not support this, will return null.

Overrides:

getSelectLastIdentityValues in class AbstractDdlBuilder

Parameters:

table - The table

Returns:

The sql, or null if the database does not support this

writeExternalIndexDropStmt

public void writeExternalIndexDropStmt(Table table,
 IIndex index,
 StringBuilder ddl)

Description copied from class: AbstractDdlBuilder

Generates the statement to drop a non-embedded index from the database.

Overrides:

writeExternalIndexDropStmt in class AbstractDdlBuilder

writeCastExpression

protected void writeCastExpression(Column sourceColumn,
 Column targetColumn,
 StringBuilder ddl)

Description copied from class: AbstractDdlBuilder

Writes a cast expression that converts the value of the source column to the data type of the target column. Per default, simply the name of the source column is written thereby assuming that any casts happen implicitly.

Overrides:

writeCastExpression in class AbstractDdlBuilder

processTableStructureChanges

protected void processTableStructureChanges(Database currentModel,
 Database desiredModel,
 Table sourceTable,
 Table targetTable,
 List<TableChange> changes,
 StringBuilder ddl)

Description copied from class: AbstractDdlBuilder

Allows database-specific implementations to handle changes in a database specific manner. Any handled change should be applied to the given current model (which is a copy of the real original model) and be removed from the list of changes.
In the default implementation, all AddPrimaryKeyChange changes are applied via an ALTER TABLE ADD CONSTRAINT statement.

Overrides:

processTableStructureChanges in class AbstractDdlBuilder

Parameters:

currentModel - The current database schema

desiredModel - The desired database schema

sourceTable - The original table

targetTable - The desired table

changes - The change objects for the target table

writeAlterColumnDataTypeToBigInt

protected boolean writeAlterColumnDataTypeToBigInt(ColumnDataTypeChange change,
 StringBuilder ddl)

Overrides:

writeAlterColumnDataTypeToBigInt in class AbstractDdlBuilder

processChange

protected void processChange(Database currentModel,
 Database desiredModel,
 AddColumnChange change,
 StringBuilder ddl)

processChange

protected void processChange(Database currentModel,
 Database desiredModel,
 RemoveColumnChange change,
 StringBuilder ddl)

processChange

protected void processChange(Database currentModel,
 Database desiredModel,
 RemovePrimaryKeyChange change,
 StringBuilder ddl)

processChange

protected void processChange(Database currentModel,
 Database desiredModel,
 PrimaryKeyChange change,
 StringBuilder ddl)

writeExternalPrimaryKeysCreateStmt

protected void writeExternalPrimaryKeysCreateStmt(Table table,
 Column[] primaryKeyColumns,
 StringBuilder ddl)

Description copied from class: AbstractDdlBuilder

Writes the primary key constraints of the table as alter table statements.

Overrides:

writeExternalPrimaryKeysCreateStmt in class AbstractDdlBuilder

Parameters:

table - The table

primaryKeyColumns - The primary key columns

writeReorgStmt

protected void writeReorgStmt(Table table,
 StringBuilder ddl)

writeCascadeAttributesForForeignKeyUpdate

protected void writeCascadeAttributesForForeignKeyUpdate(ForeignKey key,
 StringBuilder ddl)

Overrides:

writeCascadeAttributesForForeignKeyUpdate in class AbstractDdlBuilder

mapDefaultValue

public String mapDefaultValue(Object defaultValue,
 Column column)

Specified by:

mapDefaultValue in interface IDdlBuilder

Overrides:

mapDefaultValue in class AbstractDdlBuilder

writeColumnType

protected void writeColumnType(Table table,
 Column column,
 StringBuilder ddl)

Overrides:

writeColumnType in class AbstractDdlBuilder

writeColumnDefaultValue

protected void writeColumnDefaultValue(Table table,
 Column column,
 StringBuilder ddl)

Description copied from class: AbstractDdlBuilder

Prints the default value of the column.

Overrides:

writeColumnDefaultValue in class AbstractDdlBuilder