Package org.jumpmind.db.platform.mysql

Class MySqlDdlBuilder

java.lang.Object

org.jumpmind.db.platform.AbstractDdlBuilder

org.jumpmind.db.platform.mysql.MySqlDdlBuilder

All Implemented Interfaces:

IDdlBuilder

public class MySqlDdlBuilder
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
MySqlDdlBuilder()
MySqlDdlBuilder(String databaseName)

Method Summary

Modifier and Type	Method	Description
protected void	dropTable(Table table, StringBuilder ddl, boolean temporary, boolean recreate)	Outputs the DDL to drop the table.
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	init()
protected boolean	isFullTextIndex(IIndex index)
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	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 boolean	shouldGeneratePrimaryKeys(Column[] primaryKeyColumns)	Determines whether we should generate a primary key constraint for the given primary key columns.
protected boolean	shouldUseQuotes(String defaultValue, Column column)
protected void	writeColumnAutoIncrementStmt(Table table, Column column, StringBuilder ddl)	Prints that the column is an auto increment column.
protected void	writeColumnAutoUpdateStmt(Table table, Column column, StringBuilder ddl)
protected void	writeColumnDefaultValue(Table table, Column column, StringBuilder ddl)	Prints the default value of the column.
protected void	writeColumnDefaultValueStmt(Table table, Column column, StringBuilder ddl)	Prints the default value stmt part for the column.
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.

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, 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, 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, writeAlterColumnDataTypeToBigInt, writeCascadeAttributesForForeignKey, writeCascadeAttributesForForeignKeyDelete, writeCascadeAttributesForForeignKeyUpdate, writeCastExpression, writeColumn, writeColumnEmbeddedPrimaryKey, writeColumnNotNullableStmt, writeColumnNullableStmt, writeColumns, writeColumnType, writeColumnTypeDefaultRequired, writeColumnUniqueStmt, writeCopyDataStatement, writeCopyDataStatement, writeEmbeddedForeignKeysStmt, writeEmbeddedIndexCreateStmt, writeEmbeddedIndicesStmt, writeEmbeddedPrimaryKeysStmt, writeExternalForeignKeyCreateStmt, writeExternalIndexCreate, writeExternalIndexCreateStmt, writeExternalIndexDropStmt, 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

Constructor Details

MySqlDdlBuilder

public MySqlDdlBuilder(String databaseName)

MySqlDdlBuilder

public MySqlDdlBuilder()

Method Details

init

protected void init()

mapDefaultValue

public String mapDefaultValue(Object defaultValue,
 Column column)

Specified by:

mapDefaultValue in interface IDdlBuilder

Overrides:

mapDefaultValue 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

writeColumnDefaultValueStmt

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

Description copied from class: AbstractDdlBuilder

Prints the default value stmt part for the column.

Overrides:

writeColumnDefaultValueStmt 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

writeColumnAutoUpdateStmt

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

Overrides:

writeColumnAutoUpdateStmt in class AbstractDdlBuilder

shouldUseQuotes

protected boolean shouldUseQuotes(String defaultValue,
 Column column)

Overrides:

shouldUseQuotes in class AbstractDdlBuilder

shouldGeneratePrimaryKeys

protected boolean shouldGeneratePrimaryKeys(Column[] primaryKeyColumns)

Description copied from class: AbstractDdlBuilder

Determines whether we should generate a primary key constraint for the given primary key columns.

Overrides:

shouldGeneratePrimaryKeys in class AbstractDdlBuilder

Parameters:

primaryKeyColumns - The pk columns

Returns:

true if a pk statement should be generated for the columns

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

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

isFullTextIndex

protected boolean isFullTextIndex(IIndex index)

Overrides:

isFullTextIndex 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

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)

processColumnChange

protected void processColumnChange(Table sourceTable,
 Table targetTable,
 Column sourceColumn,
 Column targetColumn,
 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