Package org.jumpmind.db.platform.oracle

Class OracleDdlBuilder

java.lang.Object

org.jumpmind.db.platform.AbstractDdlBuilder

org.jumpmind.db.platform.oracle.OracleDdlBuilder

All Implemented Interfaces:

IDdlBuilder

Direct Known Subclasses:

Oracle122DdlBuilder

public class OracleDdlBuilder
extends AbstractDdlBuilder

Field Summary

Fields

Modifier and Type	Field	Description
protected static final String	DATE_TYPE
protected static final String	PREFIX_SEQUENCE
protected static final String	PREFIX_TRIGGER
protected static final String	ROWID_TYPE

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

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

Constructor Summary

Constructors

Constructor	Description
OracleDdlBuilder()

Method Summary

Modifier and Type	Method	Description
protected void	createAutoIncrementSequence(Table table, Column column, StringBuilder ddl)
protected void	createAutoIncrementTrigger(Table table, Column column, StringBuilder ddl)
protected void	createTable(Table table, StringBuilder ddl, boolean temporary, boolean recreate)	Outputs the DDL to create the table along with any non-external constraints as well as with external primary keys and indices (but not foreign keys).
protected void	dropAutoIncrementSequence(Table table, Column column, StringBuilder ddl)
protected void	dropAutoIncrementTrigger(Table table, Column column, StringBuilder ddl)
void	dropExternalForeignKeys(Table table, StringBuilder ddl)	Creates external foreign key drop statements.
protected void	dropTable(Table table, StringBuilder ddl, boolean temporary, boolean recreate)	Outputs the DDL to drop the table.
protected String	getFullyQualifiedIndexNameShorten(Table table, IIndex index)
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	getSqlType(Column column)	Returns the full SQL type specification (including size and precision/scale) for the given column.
String	mapDefaultValue(Object defaultValue, Column column)
protected void	processChange(Database currentModel, Database desiredModel, AddColumnChange change, StringBuilder ddl)
protected boolean	processChange(Database currentModel, Database desiredModel, ColumnAutoIncrementChange change, StringBuilder ddl)
protected void	processChange(Database currentModel, Database desiredModel, ColumnDefaultValueChange change, StringBuilder ddl)
protected void	processChange(Database currentModel, Database desiredModel, ColumnRequiredChange change, StringBuilder ddl)
protected void	processChange(Database currentModel, Database desiredModel, ColumnSizeChange 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	shouldUseQuotes(String defaultValue, Column column)
protected boolean	writeAlterColumnDataTypeToBigInt(ColumnDataTypeChange change, StringBuilder ddl)
protected void	writeCascadeAttributesForForeignKeyDelete(ForeignKey key, StringBuilder ddl)
protected void	writeCascadeAttributesForForeignKeyUpdate(ForeignKey key, StringBuilder ddl)
protected void	writeColumnAutoIncrementStmt(Table table, Column column, StringBuilder ddl)	Prints that the column is an auto increment column.
void	writeExternalIndexDropStmt(Table table, IIndex index, StringBuilder ddl)	Index names in Oracle are unique to a schema and hence Oracle does not use the ON clause

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

addEscapedCharSequence, alterDatabase, alterDatabase, alterTable, areColumnSizesTheSame, areEqual, areMappedTypesTheSame, copy, createBackupTableFor, createExternalForeignKeys, createExternalForeignKeys, createTable, createTables, createTables, createTemporaryTable, 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, getFullyQualifiedTableNameShorten, getGapLimitSize, getIndent, getIndexName, getInsertSql, getNativeType, getRealTargetTableFor, getSize, 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, writeCascadeAttributesForForeignKey, writeCastExpression, writeColumn, writeColumnAutoUpdateStmt, writeColumnDefaultValue, writeColumnDefaultValueStmt, writeColumnEmbeddedPrimaryKey, writeColumnNotNullableStmt, writeColumnNullableStmt, writeColumns, writeColumnType, writeColumnTypeDefaultRequired, writeColumnUniqueStmt, writeCopyDataStatement, writeCopyDataStatement, writeEmbeddedForeignKeysStmt, writeEmbeddedIndexCreateStmt, writeEmbeddedIndicesStmt, writeEmbeddedPrimaryKeysStmt, writeExternalForeignKeyCreateStmt, writeExternalForeignKeyDropStmt, writeExternalIndexCreate, writeExternalIndexCreateStmt, writeExternalIndicesCreateStmt, writeExternalPrimaryKeysCreateStmt, 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

PREFIX_TRIGGER

protected static final String PREFIX_TRIGGER

See Also:

• Constant Field Values

PREFIX_SEQUENCE

protected static final String PREFIX_SEQUENCE

See Also:

• Constant Field Values

ROWID_TYPE

protected static final String ROWID_TYPE

See Also:

• Constant Field Values

DATE_TYPE

protected static final String DATE_TYPE

See Also:

• Constant Field Values

Constructor Details

OracleDdlBuilder

public OracleDdlBuilder()

Method Details

mapDefaultValue

public String mapDefaultValue(Object defaultValue,
 Column column)

Specified by:

mapDefaultValue in interface IDdlBuilder

Overrides:

mapDefaultValue in class AbstractDdlBuilder

shouldUseQuotes

protected boolean shouldUseQuotes(String defaultValue,
 Column column)

Overrides:

shouldUseQuotes in class AbstractDdlBuilder

createTable

protected void createTable(Table table,
 StringBuilder ddl,
 boolean temporary,
 boolean recreate)

Description copied from class: AbstractDdlBuilder

Outputs the DDL to create the table along with any non-external constraints as well as with external primary keys and indices (but not foreign keys).

Overrides:

createTable in class AbstractDdlBuilder

recreate - TODO

dropTable

protected void dropTable(Table table,
 StringBuilder ddl,
 boolean temporary,
 boolean recreate)

Description copied from class: AbstractDdlBuilder

Outputs the DDL to drop the table. Note that this method does not drop foreign keys to this table. Use #dropTable(Database, Table) if you want that.

Overrides:

dropTable in class AbstractDdlBuilder

recreate - TODO

createAutoIncrementSequence

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

createAutoIncrementTrigger

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

dropAutoIncrementSequence

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

dropAutoIncrementTrigger

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

dropExternalForeignKeys

public void dropExternalForeignKeys(Table table,
 StringBuilder ddl)

Description copied from class: AbstractDdlBuilder

Creates external foreign key drop statements.

Overrides:

dropExternalForeignKeys in class AbstractDdlBuilder

Parameters:

table - The table

getFullyQualifiedIndexNameShorten

protected String getFullyQualifiedIndexNameShorten(Table table,
 IIndex index)

Overrides:

getFullyQualifiedIndexNameShorten in class AbstractDdlBuilder

writeExternalIndexDropStmt

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

Index names in Oracle are unique to a schema and hence Oracle does not use the ON clause

Overrides:

writeExternalIndexDropStmt in class AbstractDdlBuilder

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

processChange

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

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

processChange

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

processChange

protected boolean processChange(Database currentModel,
 Database desiredModel,
 ColumnAutoIncrementChange change,
 StringBuilder ddl)

processChange

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

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)

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

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