Package edu.internet2.middleware.grouper.ext.org.apache.ddlutils.platform.mckoi

Class MckoiBuilder

java.lang.Object

edu.internet2.middleware.grouper.ext.org.apache.ddlutils.platform.SqlBuilder

edu.internet2.middleware.grouper.ext.org.apache.ddlutils.platform.mckoi.MckoiBuilder

public class MckoiBuilder
extends SqlBuilder

The SQL Builder for the Mckoi database.

Version:

$Revision: 463757 $

Field Summary

Fields inherited from class edu.internet2.middleware.grouper.ext.org.apache.ddlutils.platform.SqlBuilder

_log, SIZE_PLACEHOLDER

Constructor Summary

Constructors

Constructor	Description
MckoiBuilder(Platform platform)	Creates a new builder instance.

Method Summary

Modifier and Type	Method	Description
protected void	createAutoIncrementSequence(Table table, Column column)	Creates the sequence necessary for the auto-increment of the given column.
void	createTable(Database database, Table table, Map parameters)	Outputs the DDL to create the table along with any non-external constraints as well as with external primary keys and indices (but not foreign keys).
protected void	dropAutoIncrementSequence(Table table, Column column)	Drops the sequence used for the auto-increment of the given column.
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	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 void	writeColumnDefaultValue(Table table, Column column)	Prints the default value of the column.

Methods inherited from class edu.internet2.middleware.grouper.ext.org.apache.ddlutils.platform.SqlBuilder

addEscapedCharSequence, alterDatabase, applyForSelectedChanges, areEqual, columnsDiffer, createExternalForeignKeys, createExternalForeignKeys, 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, shouldGeneratePrimaryKeys, writeCastExpression, writeColumn, writeColumnAutoIncrementStmt, writeColumnDefaultValueStmt, writeColumnNotNullableStmt, writeColumnNullableStmt, writeColumns, writeCopyDataStatement, writeEmbeddedForeignKeysStmt, writeEmbeddedIndexCreateStmt, writeEmbeddedIndicesStmt, writeEmbeddedPrimaryKeysStmt, writeExternalForeignKeyCreateStmt, writeExternalForeignKeyDropStmt, writeExternalIndexCreateStmt, writeExternalIndexDropStmt, writeExternalIndicesCreateStmt, writeExternalPrimaryKeysCreateStmt, writeForeignReferences, writeLocalReferences, writePrimaryKeyStmt, writeTableAlterStmt, writeTableComment, writeTableCreationStmt, writeTableCreationStmtEnding

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

MckoiBuilder

public MckoiBuilder(Platform platform)

Creates a new builder instance.

Parameters:

platform - The plaftform this builder belongs to

Method Details

createTable

public void createTable(Database database,
 Table table,
 Map parameters)
                 throws IOException

Outputs the DDL to create the table along with any non-external constraints as well as with external primary keys and indices (but not foreign keys).

Overrides:

createTable in class SqlBuilder

Parameters:

database - The database model

table - The table

parameters - Additional platform-specific parameters for the table creation

Throws:

IOException

dropTable

public void dropTable(Table table)
               throws IOException

Outputs the DDL to drop the table. Note that this method does not drop foreign keys to this table. Use SqlBuilder.dropTable(Database, Table) if you want that.

Overrides:

dropTable in class SqlBuilder

Parameters:

table - The table to drop

Throws:

IOException

createAutoIncrementSequence

protected void createAutoIncrementSequence(Table table,
 Column column)
                                    throws IOException

Creates the sequence necessary for the auto-increment of the given column.

Parameters:

table - The table

column - The column

Throws:

IOException

dropAutoIncrementSequence

protected void dropAutoIncrementSequence(Table table,
 Column column)
                                  throws IOException

Drops the sequence used for the auto-increment of the given column.

Parameters:

table - The table

column - The column

Throws:

IOException

writeColumnDefaultValue

protected void writeColumnDefaultValue(Table table,
 Column column)
                                throws IOException

Prints the default value of the column.

Overrides:

writeColumnDefaultValue in class SqlBuilder

Parameters:

table - The table

column - The column

Throws:

IOException

getSelectLastIdentityValues

public String getSelectLastIdentityValues(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.

Overrides:

getSelectLastIdentityValues in class SqlBuilder

Parameters:

table - The table

Returns:

The sql, or null if the database does not support this

processTableStructureChanges

protected void processTableStructureChanges(Database currentModel,
 Database desiredModel,
 Table sourceTable,
 Table targetTable,
 Map parameters,
 List changes)
                                     throws IOException

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 SqlBuilder

Parameters:

currentModel - The current database schema

desiredModel - The desired database schema

sourceTable - The original table

targetTable - The desired table

parameters - The creation parameters for the table

changes - The change objects for the target table

Throws:

IOException