public class MySqlBuilder extends SqlBuilder
_log, SIZE_PLACEHOLDER| Constructor and Description |
|---|
MySqlBuilder(Platform platform)
Creates a new builder instance.
|
| Modifier and Type | Method and Description |
|---|---|
void |
dropTable(Table table)
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.
|
protected void |
processChange(Database currentModel,
Database desiredModel,
AddColumnChange change)
Processes the addition of a column to a table.
|
protected void |
processChange(Database currentModel,
Database desiredModel,
PrimaryKeyChange change)
Processes the change of the primary key of a table.
|
protected void |
processChange(Database currentModel,
Database desiredModel,
RemoveColumnChange change)
Processes the removal of a column from a table.
|
protected void |
processChange(Database currentModel,
Database desiredModel,
RemovePrimaryKeyChange change)
Processes the removal of a primary key from a table.
|
protected void |
processColumnChange(Table sourceTable,
Table targetTable,
Column sourceColumn,
Column targetColumn)
Processes a change to a column.
|
protected void |
processTableStructureChanges(Database currentModel,
Database desiredModel,
Table sourceTable,
Table targetTable,
Map parameters,
List changes)
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 void |
writeColumnAutoIncrementStmt(Table table,
Column column)
Prints that the column is an auto increment column.
|
protected void |
writeExternalForeignKeyDropStmt(Table table,
ForeignKey foreignKey)
Generates the statement to drop a foreignkey constraint from the database using an
alter table statement.
|
protected void |
writeTableCreationStmtEnding(Table table,
Map parameters)
Writes the end of the table creation statement.
|
addEscapedCharSequence, alterDatabase, applyForSelectedChanges, areEqual, columnsDiffer, createExternalForeignKeys, createExternalForeignKeys, createTable, createTable, createTables, createTables, createTables, createTemporaryTable, createUniqueIdentifier, dropExternalForeignKeys, dropTable, dropTables, dropTemporaryTable, escapeStringValue, findCorrespondingForeignKey, getBareNativeType, getColumnName, getConstraintName, getDefaultValueHelper, getDeleteSql, getDelimitedIdentifier, getForeignKeyName, getIndent, getIndexName, getInsertSql, getMaxColumnNameLength, getMaxConstraintNameLength, getMaxForeignKeyNameLength, getMaxTableNameLength, getNativeDefaultValue, getNativeType, getPlatform, getPlatformInfo, getRealTargetTableFor, getSqlType, getTableName, getTemporaryTableFor, getUpdateSql, getValueAsString, getValueDateFormat, getValueLocale, getValueNumberFormat, getValueTimeFormat, getWriter, isValidDefaultValue, print, printComment, printDefaultValue, printEndOfStatement, printIdentifier, printIndent, println, println, printlnIdentifier, printStartOfEmbeddedStatement, processChange, processChange, processChange, processChange, processChange, processChange, processChange, processChange, processChanges, processTableStructureChanges, processTableStructureChanges, setIndent, setValueDateFormat, setValueLocale, setValueNumberFormat, setValueTimeFormat, setWriter, shortenName, writeCastExpression, writeColumn, writeColumnDefaultValue, writeColumnDefaultValueStmt, writeColumnNotNullableStmt, writeColumnNullableStmt, writeColumns, writeCopyDataStatement, writeEmbeddedForeignKeysStmt, writeEmbeddedIndexCreateStmt, writeEmbeddedIndicesStmt, writeEmbeddedPrimaryKeysStmt, writeExternalForeignKeyCreateStmt, writeExternalIndexCreateStmt, writeExternalIndexDropStmt, writeExternalIndicesCreateStmt, writeExternalPrimaryKeysCreateStmt, writeForeignReferences, writeLocalReferences, writePrimaryKeyStmt, writeTableAlterStmt, writeTableComment, writeTableCreationStmtpublic MySqlBuilder(Platform platform)
platform - The plaftform this builder belongs topublic void dropTable(Table table) throws IOException
SqlBuilder.dropTable(Database, Table)
if you want that.dropTable in class SqlBuildertable - The table to dropIOExceptionprotected void writeColumnAutoIncrementStmt(Table table, Column column) throws IOException
writeColumnAutoIncrementStmt in class SqlBuildertable - The tablecolumn - The columnIOExceptionprotected boolean shouldGeneratePrimaryKeys(Column[] primaryKeyColumns)
shouldGeneratePrimaryKeys in class SqlBuilderprimaryKeyColumns - The pk columnstrue if a pk statement should be generated for the columnspublic String getSelectLastIdentityValues(Table table)
null.
Normally mysql will return the LAST_INSERT_ID as the column name for the inserted id.
Since ddlutils expects the real column name of the field that is autoincrementing, the
column has an alias of that column name.getSelectLastIdentityValues in class SqlBuildertable - The tablenull if the database does not support thisprotected void writeTableCreationStmtEnding(Table table, Map parameters) throws IOException
writeTableCreationStmtEnding in class SqlBuildertable - The tableparameters - Additional platform-specific parameters for the table creationIOExceptionprotected void writeExternalForeignKeyDropStmt(Table table, ForeignKey foreignKey) throws IOException
writeExternalForeignKeyDropStmt in class SqlBuildertable - The tableforeignKey - The foreign keyIOExceptionprotected void processTableStructureChanges(Database currentModel, Database desiredModel, Table sourceTable, Table targetTable, Map parameters, List changes) throws IOException
AddPrimaryKeyChange changes are
applied via an ALTER TABLE ADD CONSTRAINT statement.processTableStructureChanges in class SqlBuildercurrentModel - The current database schemadesiredModel - The desired database schemasourceTable - The original tabletargetTable - The desired tableparameters - The creation parameters for the tablechanges - The change objects for the target tableIOExceptionprotected void processChange(Database currentModel, Database desiredModel, AddColumnChange change) throws IOException
currentModel - The current database schemadesiredModel - The desired database schemachange - The change objectIOExceptionprotected void processChange(Database currentModel, Database desiredModel, RemoveColumnChange change) throws IOException
currentModel - The current database schemadesiredModel - The desired database schemachange - The change objectIOExceptionprotected void processChange(Database currentModel, Database desiredModel, RemovePrimaryKeyChange change) throws IOException
currentModel - The current database schemadesiredModel - The desired database schemachange - The change objectIOExceptionprotected void processChange(Database currentModel, Database desiredModel, PrimaryKeyChange change) throws IOException
currentModel - The current database schemadesiredModel - The desired database schemachange - The change objectIOExceptionprotected void processColumnChange(Table sourceTable, Table targetTable, Column sourceColumn, Column targetColumn) throws IOException
sourceTable - The current tabletargetTable - The desired tablesourceColumn - The current columntargetColumn - The desired columnIOExceptionCopyright © 2005-2013 Apache Software Foundation. All Rights Reserved.