|
||||||||||
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
The SQL Builder for MySQL.
Field Summary |
Fields inherited from class org.apache.ddlutils.platform.SqlBuilder |
_log, SIZE_PLACEHOLDER |
Constructor Summary | |
MySqlBuilder(PlatformInfo info)
Creates a new builder instance. |
Method Summary | |
void |
dropTable(Table table)
Outputs the DDL to drop the table. |
String |
getSelectLastInsertId(Table table)
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 .
Normally mysql will return the LAST_INSERT_ID as the column name for the inserted id. |
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. Per default, only the end of the statement is written, but this can be changed in subclasses. |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
public MySqlBuilder(PlatformInfo info)
info
- The platform infoMethod Detail |
public void dropTable(Table table) throws IOException
dropTable
in class SqlBuilder
table
- The table to drop
IOException
protected void writeColumnAutoIncrementStmt(Table table, Column column) throws IOException
writeColumnAutoIncrementStmt
in class SqlBuilder
table
- The tablecolumn
- The column
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 String getSelectLastInsertId(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.
getSelectLastInsertId
in class SqlBuilder
table
- The table
null
if the database does not support thisprotected void writeTableCreationStmtEnding(Table table, Map parameters) throws IOException
writeTableCreationStmtEnding
in class SqlBuilder
table
- The tableparameters
- Additional platform-specific parameters for the table creation
IOException
protected void writeExternalForeignKeyDropStmt(Table table, ForeignKey foreignKey) throws IOException
writeExternalForeignKeyDropStmt
in class SqlBuilder
table
- The tableforeignKey
- The foreign key
IOException
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |