org.apache.ddlutils.platform.mysql
Class MySqlBuilder

java.lang.Object
  extended byorg.apache.ddlutils.platform.SqlBuilder
      extended byorg.apache.ddlutils.platform.mysql.MySqlBuilder

public class MySqlBuilder
extends SqlBuilder

The SQL Builder for MySQL.

Version:
$Revision: 378736 $
Author:
James Strachan, John Marshall/Connectria, Thomas Dudziak

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 org.apache.ddlutils.platform.SqlBuilder
addEscapedCharSequence, alterDatabase, alterDatabase, alterDatabase, alterTable, columnsDiffer, createExternalForeignKeys, createExternalForeignKeys, createTable, createTable, createTables, createTables, createTables, dropExternalForeignKeys, dropTables, escapeStringValue, getColumnName, getConstraintName, getDefaultValueHelper, getDeleteSql, getDelimitedIdentifier, getForeignKeyName, getIndent, getIndexName, getInsertSql, getNativeDefaultValue, getNativeType, getPlatformInfo, getSqlType, getTableName, getUpdateSql, getValueAsString, getValueLocale, getWriter, print, printComment, printEndOfStatement, printIdentifier, printIndent, println, println, printlnIdentifier, printStartOfEmbeddedStatement, setIndent, setValueLocale, setWriter, shortenName, writeColumn, writeColumnAlterStmt, writeColumnDefaultValue, writeColumnDropStmt, writeColumnNotNullableStmt, writeColumnNullableStmt, writeColumns, writeEmbeddedForeignKeysStmt, writeEmbeddedIndexCreateStmt, writeEmbeddedIndicesStmt, writeEmbeddedPrimaryKeysStmt, writeExternalForeignKeyCreateStmt, writeExternalIndexCreateStmt, writeExternalIndexDropStmt, writeExternalIndicesCreateStmt, writeExternalPrimaryKeysCreateStmt, writeForeignReferences, writeLocalReferences, writePrimaryKeyStmt, writeTableAlterStmt, writeTableComment
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

MySqlBuilder

public MySqlBuilder(PlatformInfo info)
Creates a new builder instance.

Parameters:
info - The platform info
Method Detail

dropTable

public void dropTable(Table table)
               throws IOException
Outputs the DDL to drop the table.

Overrides:
dropTable in class SqlBuilder
Parameters:
table - The table to drop
Throws:
IOException

writeColumnAutoIncrementStmt

protected void writeColumnAutoIncrementStmt(Table table,
                                            Column column)
                                     throws IOException
Prints that the column is an auto increment column.

Overrides:
writeColumnAutoIncrementStmt in class SqlBuilder
Parameters:
table - The table
column - The column
Throws:
IOException

shouldGeneratePrimaryKeys

protected boolean shouldGeneratePrimaryKeys(Column[] primaryKeyColumns)
Determines whether we should generate a primary key constraint for the given primary key columns.

Overrides:
shouldGeneratePrimaryKeys in class SqlBuilder
Parameters:
primaryKeyColumns - The pk columns
Returns:
true if a pk statement should be generated for the columns

getSelectLastInsertId

public 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. Since ddlutils expects the real column name of the field that is autoincrementing, the column has an alias of that column name.

Overrides:
getSelectLastInsertId in class SqlBuilder
Parameters:
table - The table
Returns:
The sql, or null if the database does not support this

writeTableCreationStmtEnding

protected void writeTableCreationStmtEnding(Table table,
                                            Map parameters)
                                     throws IOException
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.

Overrides:
writeTableCreationStmtEnding in class SqlBuilder
Parameters:
table - The table
parameters - Additional platform-specific parameters for the table creation
Throws:
IOException

writeExternalForeignKeyDropStmt

protected void writeExternalForeignKeyDropStmt(Table table,
                                               ForeignKey foreignKey)
                                        throws IOException
Generates the statement to drop a foreignkey constraint from the database using an alter table statement.

Overrides:
writeExternalForeignKeyDropStmt in class SqlBuilder
Parameters:
table - The table
foreignKey - The foreign key
Throws:
IOException


Copyright © 2005 Apache Software Foundation. All Rights Reserved.