|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.apache.ddlutils.platform.SqlBuilder
org.apache.ddlutils.platform.mysql.MySqlBuilder
public class MySqlBuilder
The SQL Builder for MySQL.
Field Summary |
---|
Fields inherited from class org.apache.ddlutils.platform.SqlBuilder |
---|
_log, SIZE_PLACEHOLDER |
Constructor Summary | |
---|---|
MySqlBuilder(Platform platform)
Creates a new builder instance. |
Method Summary | |
---|---|
void |
dropTable(Table table)
Outputs the DDL to drop the table. |
java.lang.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,
java.util.Map parameters,
java.util.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,
java.util.Map parameters)
Writes the end of the table creation statement. |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public MySqlBuilder(Platform platform)
platform
- The plaftform this builder belongs toMethod Detail |
---|
public void dropTable(Table table) throws java.io.IOException
SqlBuilder.dropTable(Database, Table)
if you want that.
dropTable
in class SqlBuilder
table
- The table to drop
java.io.IOException
protected void writeColumnAutoIncrementStmt(Table table, Column column) throws java.io.IOException
writeColumnAutoIncrementStmt
in class SqlBuilder
table
- The tablecolumn
- The column
java.io.IOException
protected boolean shouldGeneratePrimaryKeys(Column[] primaryKeyColumns)
shouldGeneratePrimaryKeys
in class SqlBuilder
primaryKeyColumns
- The pk columns
true
if a pk statement should be generated for the columnspublic java.lang.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 SqlBuilder
table
- The table
null
if the database does not support thisprotected void writeTableCreationStmtEnding(Table table, java.util.Map parameters) throws java.io.IOException
writeTableCreationStmtEnding
in class SqlBuilder
table
- The tableparameters
- Additional platform-specific parameters for the table creation
java.io.IOException
protected void writeExternalForeignKeyDropStmt(Table table, ForeignKey foreignKey) throws java.io.IOException
writeExternalForeignKeyDropStmt
in class SqlBuilder
table
- The tableforeignKey
- The foreign key
java.io.IOException
protected void processTableStructureChanges(Database currentModel, Database desiredModel, Table sourceTable, Table targetTable, java.util.Map parameters, java.util.List changes) throws java.io.IOException
AddPrimaryKeyChange
changes are
applied via an ALTER TABLE ADD CONSTRAINT
statement.
processTableStructureChanges
in class SqlBuilder
currentModel
- 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 table
java.io.IOException
protected void processChange(Database currentModel, Database desiredModel, AddColumnChange change) throws java.io.IOException
currentModel
- The current database schemadesiredModel
- The desired database schemachange
- The change object
java.io.IOException
protected void processChange(Database currentModel, Database desiredModel, RemoveColumnChange change) throws java.io.IOException
currentModel
- The current database schemadesiredModel
- The desired database schemachange
- The change object
java.io.IOException
protected void processChange(Database currentModel, Database desiredModel, RemovePrimaryKeyChange change) throws java.io.IOException
currentModel
- The current database schemadesiredModel
- The desired database schemachange
- The change object
java.io.IOException
protected void processChange(Database currentModel, Database desiredModel, PrimaryKeyChange change) throws java.io.IOException
currentModel
- The current database schemadesiredModel
- The desired database schemachange
- The change object
java.io.IOException
protected void processColumnChange(Table sourceTable, Table targetTable, Column sourceColumn, Column targetColumn) throws java.io.IOException
sourceTable
- The current tabletargetTable
- The desired tablesourceColumn
- The current columntargetColumn
- The desired column
java.io.IOException
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |