Class FirebirdBuilder
java.lang.Object
edu.internet2.middleware.grouper.ext.org.apache.ddlutils.platform.SqlBuilder
edu.internet2.middleware.grouper.ext.org.apache.ddlutils.platform.firebird.FirebirdBuilder
The SQL Builder for the FireBird database.
- Version:
- $Revision: 231306 $
-
Field Summary
Fields inherited from class edu.internet2.middleware.grouper.ext.org.apache.ddlutils.platform.SqlBuilder
_log, SIZE_PLACEHOLDER
-
Constructor Summary
-
Method Summary
Modifier and TypeMethodDescriptionvoid
createExternalForeignKeys
(Database database) Creates the external foreignkey creation statements for all tables in the database.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).void
Outputs the DDL to drop the table.protected String
getGeneratorName
(Table table, Column column) Determines the name of the generator for an auto-increment column.protected String
getNativeDefaultValue
(Column column) Returns the native default value for the column.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, RemoveColumnChange change) Processes the removal of a column from a table.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
writeColumnAutoIncrementStmt
(Table table, Column column) Prints that the column is an auto increment column.void
writeExternalIndexDropStmt
(Table table, Index index) Generates the statement to drop a non-embedded index from the database.Methods inherited from class edu.internet2.middleware.grouper.ext.org.apache.ddlutils.platform.SqlBuilder
addEscapedCharSequence, alterDatabase, applyForSelectedChanges, areEqual, columnsDiffer, 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, 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, writeColumnDefaultValue, writeColumnDefaultValueStmt, writeColumnNotNullableStmt, writeColumnNullableStmt, writeColumns, writeCopyDataStatement, writeEmbeddedForeignKeysStmt, writeEmbeddedIndexCreateStmt, writeEmbeddedIndicesStmt, writeEmbeddedPrimaryKeysStmt, writeExternalForeignKeyCreateStmt, writeExternalForeignKeyDropStmt, writeExternalIndexCreateStmt, writeExternalIndicesCreateStmt, writeExternalPrimaryKeysCreateStmt, writeForeignReferences, writeLocalReferences, writePrimaryKeyStmt, writeTableAlterStmt, writeTableComment, writeTableCreationStmt, writeTableCreationStmtEnding
-
Constructor Details
-
FirebirdBuilder
Creates a new builder instance.- Parameters:
platform
- The plaftform this builder belongs to
-
-
Method Details
-
createTable
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 classSqlBuilder
- Parameters:
database
- The database modeltable
- The tableparameters
- Additional platform-specific parameters for the table creation- Throws:
IOException
-
dropTable
Outputs the DDL to drop the table. Note that this method does not drop foreign keys to this table. UseSqlBuilder.dropTable(Database, Table)
if you want that.- Overrides:
dropTable
in classSqlBuilder
- Parameters:
table
- The table to drop- Throws:
IOException
-
getGeneratorName
Determines the name of the generator for an auto-increment column.- Parameters:
table
- The tablecolumn
- The auto-increment column- Returns:
- The generator name
-
writeColumnAutoIncrementStmt
Prints that the column is an auto increment column.- Overrides:
writeColumnAutoIncrementStmt
in classSqlBuilder
- Parameters:
table
- The tablecolumn
- The column- Throws:
IOException
-
getSelectLastIdentityValues
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 returnnull
.- Overrides:
getSelectLastIdentityValues
in classSqlBuilder
- Parameters:
table
- The table- Returns:
- The sql, or
null
if the database does not support this
-
getNativeDefaultValue
Returns the native default value for the column.- Overrides:
getNativeDefaultValue
in classSqlBuilder
- Parameters:
column
- The column- Returns:
- The native default value
-
createExternalForeignKeys
Creates the external foreignkey creation statements for all tables in the database.- Overrides:
createExternalForeignKeys
in classSqlBuilder
- Parameters:
database
- The database- Throws:
IOException
-
writeExternalIndexDropStmt
Generates the statement to drop a non-embedded index from the database.- Overrides:
writeExternalIndexDropStmt
in classSqlBuilder
- Parameters:
table
- The table the index is onindex
- The index to drop- Throws:
IOException
-
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, allAddPrimaryKeyChange
changes are applied via anALTER TABLE ADD CONSTRAINT
statement.- Overrides:
processTableStructureChanges
in classSqlBuilder
- Parameters:
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- Throws:
IOException
-
processChange
protected void processChange(Database currentModel, Database desiredModel, AddColumnChange change) throws IOException Processes the addition of a column to a table.- Parameters:
currentModel
- The current database schemadesiredModel
- The desired database schemachange
- The change object- Throws:
IOException
-
processChange
protected void processChange(Database currentModel, Database desiredModel, RemoveColumnChange change) throws IOException Processes the removal of a column from a table.- Parameters:
currentModel
- The current database schemadesiredModel
- The desired database schemachange
- The change object- Throws:
IOException
-