|
||||||||||
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.oracle.Oracle8Builder
The SQL Builder for Oracle.
Field Summary |
Fields inherited from class org.apache.ddlutils.platform.SqlBuilder |
_log, SIZE_PLACEHOLDER |
Constructor Summary | |
Oracle8Builder(Platform platform)
Creates a new builder instance. |
Method Summary | |
protected void |
createAutoIncrementSequence(Table table,
Column column)
Creates the sequence necessary for the auto-increment of the given column. |
protected void |
createAutoIncrementTrigger(Table table,
Column column)
Creates the trigger 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 |
createTemporaryTable(Database database,
Table table,
Map parameters)
Outputs the DDL to create the given temporary table. Per default this is simply a call to SqlBuilder.createTable(Database, Table, Map) . |
protected void |
dropAutoIncrementSequence(Table table,
Column column)
Drops the sequence used for the auto-increment of the given column. |
protected void |
dropAutoIncrementTrigger(Table table,
Column column)
Drops the trigger used for the auto-increment of the given column. |
void |
dropExternalForeignKeys(Table table)
Creates external foreignkey drop statements. |
void |
dropTable(Table table)
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. |
protected void |
dropTemporaryTable(Database database,
Table table)
Outputs the DDL to drop the given temporary table. Per default this is simply a call to SqlBuilder.dropTable(Table) . |
protected String |
getNativeDefaultValue(Column column)
Returns the native default value for the column. |
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 . |
protected void |
printDefaultValue(Object defaultValue,
int typeCode)
Prints the default value of the column. |
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 |
processChange(Database currentModel,
Database desiredModel,
RemovePrimaryKeyChange change)
Processes the removal of a primary key 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. 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. |
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 java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
public Oracle8Builder(Platform platform)
platform
- The plaftform this builder belongs toMethod Detail |
public void createTable(Database database, Table table, Map parameters) throws IOException
createTable
in class SqlBuilder
database
- The database modeltable
- The tableparameters
- Additional platform-specific parameters for the table creation
IOException
public void dropTable(Table table) throws IOException
SqlBuilder.dropTable(Database, Table)
if you want that.
dropTable
in class SqlBuilder
table
- The table to drop
IOException
protected void createAutoIncrementSequence(Table table, Column column) throws IOException
table
- The tablecolumn
- The column
IOException
protected void createAutoIncrementTrigger(Table table, Column column) throws IOException
table
- The tablecolumn
- The column
IOException
protected void dropAutoIncrementSequence(Table table, Column column) throws IOException
table
- The tablecolumn
- The column
IOException
protected void dropAutoIncrementTrigger(Table table, Column column) throws IOException
table
- The tablecolumn
- The column
IOException
protected void createTemporaryTable(Database database, Table table, Map parameters) throws IOException
SqlBuilder.createTable(Database, Table, Map)
.
createTemporaryTable
in class SqlBuilder
database
- The database modeltable
- The tableparameters
- Additional platform-specific parameters for the table creation
IOException
protected void dropTemporaryTable(Database database, Table table) throws IOException
SqlBuilder.dropTable(Table)
.
dropTemporaryTable
in class SqlBuilder
database
- The database modeltable
- The table
IOException
public void dropExternalForeignKeys(Table table) throws IOException
dropExternalForeignKeys
in class SqlBuilder
table
- The table
IOException
public void writeExternalIndexDropStmt(Table table, Index index) throws IOException
writeExternalIndexDropStmt
in class SqlBuilder
table
- The table the index is onindex
- The index to drop
IOException
protected void printDefaultValue(Object defaultValue, int typeCode) throws IOException
printDefaultValue
in class SqlBuilder
defaultValue
- The default valuetypeCode
- The type code to write the default value for
IOException
protected String getNativeDefaultValue(Column column)
getNativeDefaultValue
in class SqlBuilder
column
- The column
protected void writeColumnAutoIncrementStmt(Table table, Column column) throws IOException
writeColumnAutoIncrementStmt
in class SqlBuilder
table
- The tablecolumn
- The column
IOException
public String getSelectLastIdentityValues(Table table)
null
.
getSelectLastIdentityValues
in class SqlBuilder
table
- The table
null
if the database does not support thisprotected void processTableStructureChanges(Database currentModel, Database desiredModel, Table sourceTable, Table targetTable, Map parameters, List changes) throws 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
IOException
protected void processChange(Database currentModel, Database desiredModel, AddColumnChange change) throws IOException
currentModel
- The current database schemadesiredModel
- The desired database schemachange
- The change object
IOException
protected void processChange(Database currentModel, Database desiredModel, RemoveColumnChange change) throws IOException
currentModel
- The current database schemadesiredModel
- The desired database schemachange
- The change object
IOException
protected void processChange(Database currentModel, Database desiredModel, RemovePrimaryKeyChange change) throws IOException
currentModel
- The current database schemadesiredModel
- The desired database schemachange
- The change object
IOException
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |