Package org.jumpmind.db.platform.informix

Class InformixDdlBuilder

java.lang.Object

org.jumpmind.db.platform.AbstractDdlBuilder

org.jumpmind.db.platform.informix.InformixDdlBuilder

All Implemented Interfaces:

IDdlBuilder

public class InformixDdlBuilder
extends AbstractDdlBuilder

Field Summary

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

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

Constructor Summary

Constructors

Constructor	Description
InformixDdlBuilder()

Method Summary

Modifier and Type	Method	Description
String	getSelectLastIdentityValues(Table table)	Generates the SQL for querying the id that was created in the last insertion operation.
String	getSqlType(Column column)	Returns the full SQL type specification (including size and precision/scale) for the given column.
protected void	processChange(Database currentModel, Database desiredModel, PrimaryKeyChange change, StringBuilder ddl)
protected void	processChange(Database currentModel, Database desiredModel, RemovePrimaryKeyChange change, StringBuilder ddl)
protected void	writeCascadeAttributesForForeignKeyDelete(ForeignKey key, StringBuilder ddl)
protected void	writeCascadeAttributesForForeignKeyUpdate(ForeignKey key, StringBuilder ddl)
protected void	writeColumn(Table table, Column column, StringBuilder ddl)	Outputs the DDL for the specified column.
protected void	writeExternalForeignKeyCreateStmt(Database database, Table table, ForeignKey key, StringBuilder ddl)	Writes a single foreign key constraint using a alter table statement.
protected void	writeExternalPrimaryKeysCreateStmt(Table table, Column[] primaryKeyColumns, StringBuilder ddl)	Writes the primary key constraints of the table as alter table statements.

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, getNativeDefaultValue, getNativeType, getRealTargetTableFor, getSize, getTableName, getTemporaryTableFor, getTemporaryTableFor, getTriggerDelimiterReplacementCharacters, getUpdateSql, getValueAsString, getValueDateFormat, getValueLocale, getValueNumberFormat, getValueTimeFormat, hasSize, initCteExpression, isAlterDatabase, isCaseSensitive, isDelimitedIdentifierModeOn, isFullTextIndex, isScriptModeOn, isSpecifyIdentityGapLimit, isSqlCommentsOn, isValidDefaultValue, mapDefaultValue, 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, processTableStructureChanges, renameTable, replaceDelimiterWithEscapeCharacters, restoreTableFromBackup, setCaseSensitive, setDelimitedIdentifierModeOn, setIndent, setScriptModeOn, setSqlCommentsOn, setTriggerDelimiterReplacementCharacters, setValueDateFormat, setValueLocale, setValueNumberFormat, setValueTimeFormat, shortenName, shouldGeneratePrimaryKeys, shouldUseQuotes, writeAlterColumnDataTypeToBigInt, writeCascadeAttributesForForeignKey, writeCastExpression, writeColumnAutoIncrementStmt, writeColumnAutoUpdateStmt, writeColumnDefaultValue, writeColumnDefaultValueStmt, writeColumnEmbeddedPrimaryKey, writeColumnNotNullableStmt, writeColumnNullableStmt, writeColumns, writeColumnType, writeColumnTypeDefaultRequired, writeColumnUniqueStmt, writeCopyDataStatement, writeCopyDataStatement, writeEmbeddedForeignKeysStmt, writeEmbeddedIndexCreateStmt, writeEmbeddedIndicesStmt, writeEmbeddedPrimaryKeysStmt, writeExternalForeignKeyDropStmt, writeExternalIndexCreate, writeExternalIndexCreateStmt, writeExternalIndexDropStmt, 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

Constructor Details

InformixDdlBuilder

public InformixDdlBuilder()

Method Details

getSqlType

public String getSqlType(Column column)

Description copied from class: AbstractDdlBuilder

Returns the full SQL type specification (including size and precision/scale) for the given column.

Specified by:

getSqlType in interface IDdlBuilder

Overrides:

getSqlType in class AbstractDdlBuilder

Parameters:

column - The column

Returns:

The full SQL type string including the size

writeColumn

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

Description copied from class: AbstractDdlBuilder

Outputs the DDL for the specified column.

Overrides:

writeColumn 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

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

writeExternalForeignKeyCreateStmt

protected void writeExternalForeignKeyCreateStmt(Database database,
 Table table,
 ForeignKey key,
 StringBuilder ddl)

Description copied from class: AbstractDdlBuilder

Writes a single foreign key constraint using a alter table statement.

Overrides:

writeExternalForeignKeyCreateStmt in class AbstractDdlBuilder

Parameters:

database - The database model

table - The table

key - The foreign key

writeCascadeAttributesForForeignKeyUpdate

protected void writeCascadeAttributesForForeignKeyUpdate(ForeignKey key,
 StringBuilder ddl)

Overrides:

writeCascadeAttributesForForeignKeyUpdate in class AbstractDdlBuilder

writeCascadeAttributesForForeignKeyDelete

protected void writeCascadeAttributesForForeignKeyDelete(ForeignKey key,
 StringBuilder ddl)

Overrides:

writeCascadeAttributesForForeignKeyDelete in class AbstractDdlBuilder

processChange

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

processChange

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