Package org.jumpmind.db.platform.nuodb

Class NuoDbDdlBuilder

java.lang.Object

org.jumpmind.db.platform.AbstractDdlBuilder

org.jumpmind.db.platform.nuodb.NuoDbDdlBuilder

All Implemented Interfaces:

IDdlBuilder

public class NuoDbDdlBuilder
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
NuoDbDdlBuilder()

Method Summary

Modifier and Type	Method	Description
boolean	areColumnSizesTheSame(Column sourceColumn, Column targetColumn)
protected void	dropTable(Table table, StringBuilder ddl, boolean temporary, boolean recreate)	Outputs the DDL to drop the table.
protected String	getFullyQualifiedTableNameShorten(Table table)	The fully qualified table name shorten
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, AddColumnChange change, StringBuilder ddl)
protected void	processChange(Database currentModel, Database desiredModel, ColumnDataTypeChange change, StringBuilder ddl)
protected void	processChange(Database currentModel, Database desiredModel, RemoveColumnChange change, StringBuilder ddl)
protected void	processColumnChange(Table sourceTable, Table targetTable, Column sourceColumn, Column targetColumn, 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 void	writeCascadeAttributesForForeignKey(ForeignKey key, StringBuilder ddl)
protected void	writeColumnAutoIncrementStmt(Table table, Column column, StringBuilder ddl)	Prints that the column is an auto increment column.
protected void	writeColumnNullableStmt(StringBuilder ddl)	Prints that a column is nullable.
protected void	writeExternalForeignKeyCreateStmt(Database database, Table table, ForeignKey key, StringBuilder ddl)	Writes a single foreign key constraint using a alter table statement.
protected void	writeExternalForeignKeyDropStmt(Table table, ForeignKey foreignKey, StringBuilder ddl)	Generates the statement to drop a foreignkey constraint from the database using an alter table statement.
void	writeExternalIndexDropStmt(Table table, IIndex index, StringBuilder ddl)	Generates the statement to drop a non-embedded index from the database.

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

addEscapedCharSequence, alterDatabase, alterDatabase, alterTable, areEqual, areMappedTypesTheSame, copy, createBackupTableFor, createExternalForeignKeys, createExternalForeignKeys, createTable, createTable, createTables, createTables, createTemporaryTable, dropExternalForeignKeys, 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, getGapLimitSize, getIndent, getIndexName, getInsertSql, getNativeDefaultValue, getNativeType, getRealTargetTableFor, getSize, getTableName, getTemporaryTableFor, getTemporaryTableFor, 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, processChanges, processChanges, processTableStructureChanges, processTableStructureChanges, renameTable, restoreTableFromBackup, setCaseSensitive, setDelimitedIdentifierModeOn, setIndent, setScriptModeOn, setSqlCommentsOn, setValueDateFormat, setValueLocale, setValueNumberFormat, setValueTimeFormat, shortenName, shouldGeneratePrimaryKeys, shouldUseQuotes, writeAlterColumnDataTypeToBigInt, writeCascadeAttributesForForeignKeyDelete, writeCascadeAttributesForForeignKeyUpdate, writeCastExpression, writeColumn, writeColumnDefaultValue, writeColumnDefaultValueStmt, writeColumnEmbeddedPrimaryKey, writeColumnNotNullableStmt, writeColumns, writeColumnType, writeColumnTypeDefaultRequired, writeColumnUniqueStmt, writeCopyDataStatement, writeCopyDataStatement, writeEmbeddedForeignKeysStmt, writeEmbeddedIndexCreateStmt, writeEmbeddedIndicesStmt, writeEmbeddedPrimaryKeysStmt, writeExternalIndexCreate, writeExternalIndexCreateStmt, writeExternalIndicesCreateStmt, writeExternalPrimaryKeysCreateStmt, writeFixLastIdentityValues, writeForeignReferences, writeGeneratedColumn, writeIdentityGapLimit, writeLocalReferences, writePrimaryKeyStmt, writeTableAlterStmt, writeTableComment, writeTableCreationStmt, writeTableCreationStmtEnding

Methods inherited from class java.lang.Object

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

Constructor Details

NuoDbDdlBuilder

public NuoDbDdlBuilder()

Method Details

getFullyQualifiedTableNameShorten

protected String getFullyQualifiedTableNameShorten(Table table)

Description copied from class: AbstractDdlBuilder

The fully qualified table name shorten

Overrides:

getFullyQualifiedTableNameShorten in class AbstractDdlBuilder

areColumnSizesTheSame

public boolean areColumnSizesTheSame(Column sourceColumn,
 Column targetColumn)

Specified by:

areColumnSizesTheSame in interface IDdlBuilder

Overrides:

areColumnSizesTheSame in class AbstractDdlBuilder

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

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

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

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

writeExternalForeignKeyDropStmt

protected void writeExternalForeignKeyDropStmt(Table table,
 ForeignKey foreignKey,
 StringBuilder ddl)

Description copied from class: AbstractDdlBuilder

Generates the statement to drop a foreignkey constraint from the database using an alter table statement.

Overrides:

writeExternalForeignKeyDropStmt in class AbstractDdlBuilder

Parameters:

table - The table

foreignKey - The foreign key

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

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,
 ColumnDataTypeChange change,
 StringBuilder ddl)

processColumnChange

protected void processColumnChange(Table sourceTable,
 Table targetTable,
 Column sourceColumn,
 Column targetColumn,
 StringBuilder ddl)

writeColumnNullableStmt

protected void writeColumnNullableStmt(StringBuilder ddl)

Description copied from class: AbstractDdlBuilder

Prints that a column is nullable.

Overrides:

writeColumnNullableStmt in class AbstractDdlBuilder

writeCascadeAttributesForForeignKey

protected void writeCascadeAttributesForForeignKey(ForeignKey key,
 StringBuilder ddl)

Overrides:

writeCascadeAttributesForForeignKey in class AbstractDdlBuilder

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