|
||||||||||
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.sybase.SybaseBuilder
public class SybaseBuilder
The SQL Builder for Sybase.
Field Summary |
---|
Fields inherited from class org.apache.ddlutils.platform.SqlBuilder |
---|
_log, SIZE_PLACEHOLDER |
Constructor Summary | |
---|---|
SybaseBuilder(Platform platform)
Creates a new builder instance. |
Method Summary | |
---|---|
void |
createTable(Database database,
Table table,
java.util.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 |
dropExternalForeignKeys(Table table)
Creates external foreignkey drop statements. |
void |
dropTable(Table table)
Outputs the DDL to drop the table. |
protected java.lang.String |
getDisableIdentityOverrideSql(Table table)
Returns the SQL to disable identity override mode. |
protected java.lang.String |
getEnableIdentityOverrideSql(Table table)
Returns the SQL to enable identity override mode. |
protected java.lang.String |
getNativeDefaultValue(Column column)
Returns the native default value for the column. |
protected java.lang.String |
getQuotationOnStatement()
Returns the statement that turns on the ability to write delimited identifiers. |
java.lang.String |
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,
ColumnDefaultValueChange change)
Processes the change of the default value of a column. |
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 |
processChanges(Database currentModel,
Database desiredModel,
java.util.List changes,
CreationParameters params)
Processes the changes. |
protected void |
processColumnChange(Table sourceTable,
Table targetTable,
Column sourceColumn,
Column targetColumn)
Processes a change to a column. |
protected void |
processTableStructureChanges(Database currentModel,
Database desiredModel,
Table sourceTable,
Table targetTable,
java.util.Map parameters,
java.util.List changes)
Allows database-specific implementations to handle changes in a database specific manner. |
protected void |
writeCastExpression(Column sourceColumn,
Column targetColumn)
Writes a cast expression that converts the value of the source column to the data type of the target column. |
protected void |
writeColumn(Table table,
Column column)
Outputs the DDL for the specified column. |
protected void |
writeCopyDataStatement(Table sourceTable,
Table targetTable)
Writes a statement that copies the data from the source to the target table. |
protected void |
writeExternalForeignKeyDropStmt(Table table,
ForeignKey foreignKey)
Generates the statement to drop a foreignkey constraint from the database using an alter table statement. |
void |
writeExternalIndexDropStmt(Table table,
Index index)
Generates the statement to drop a non-embedded index from the database. |
protected void |
writeTableCreationStmtEnding(Table table,
java.util.Map parameters)
Writes the end of the table creation statement. |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public SybaseBuilder(Platform platform)
platform
- The plaftform this builder belongs toMethod Detail |
---|
public void createTable(Database database, Table table, java.util.Map parameters) throws java.io.IOException
createTable
in class SqlBuilder
database
- The database modeltable
- The tableparameters
- Additional platform-specific parameters for the table creation
java.io.IOException
protected void writeTableCreationStmtEnding(Table table, java.util.Map parameters) throws java.io.IOException
writeTableCreationStmtEnding
in class SqlBuilder
table
- The tableparameters
- Additional platform-specific parameters for the table creation
java.io.IOException
protected void writeColumn(Table table, Column column) throws java.io.IOException
writeColumn
in class SqlBuilder
table
- The table containing the columncolumn
- The column
java.io.IOException
protected java.lang.String getNativeDefaultValue(Column column)
getNativeDefaultValue
in class SqlBuilder
column
- The column
public void dropTable(Table table) throws java.io.IOException
SqlBuilder.dropTable(Database, Table)
if you want that.
dropTable
in class SqlBuilder
table
- The table to drop
java.io.IOException
protected void writeExternalForeignKeyDropStmt(Table table, ForeignKey foreignKey) throws java.io.IOException
writeExternalForeignKeyDropStmt
in class SqlBuilder
table
- The tableforeignKey
- The foreign key
java.io.IOException
public void writeExternalIndexDropStmt(Table table, Index index) throws java.io.IOException
writeExternalIndexDropStmt
in class SqlBuilder
table
- The table the index is onindex
- The index to drop
java.io.IOException
public void dropExternalForeignKeys(Table table) throws java.io.IOException
dropExternalForeignKeys
in class SqlBuilder
table
- The table
java.io.IOException
public java.lang.String getSelectLastIdentityValues(Table table)
null
.
getSelectLastIdentityValues
in class SqlBuilder
table
- The table
null
if the database does not support thisprotected java.lang.String getEnableIdentityOverrideSql(Table table)
table
- The table to enable the mode for
protected java.lang.String getDisableIdentityOverrideSql(Table table)
table
- The table to disable the mode for
protected java.lang.String getQuotationOnStatement()
protected void writeCopyDataStatement(Table sourceTable, Table targetTable) throws java.io.IOException
SqlBuilder.writeCastExpression(Column, Column)
method.
writeCopyDataStatement
in class SqlBuilder
sourceTable
- The source tabletargetTable
- The target table
java.io.IOException
protected void writeCastExpression(Column sourceColumn, Column targetColumn) throws java.io.IOException
writeCastExpression
in class SqlBuilder
sourceColumn
- The source columntargetColumn
- The target column
java.io.IOException
protected void processChanges(Database currentModel, Database desiredModel, java.util.List changes, CreationParameters params) throws java.io.IOException
RemoveForeignKeyChange
and
RemoveIndexChange
come first
to allow for e.g. subsequent primary key changes or column removal.RemoveTableChange
comes after the removal of foreign keys and indices.RemovePrimaryKeyChange
AddPrimaryKeyChange
PrimaryKeyChange
RemoveColumnChange
AddColumnChange
ColumnAutoIncrementChange
ColumnDefaultValueChange
ColumnRequiredChange
ColumnDataTypeChange
ColumnSizeChange
AddTableChange
AddForeignKeyChange
and
AddIndexChange
come last
after table/column/primary key additions or changes.
processChanges
in class SqlBuilder
currentModel
- The current database schemadesiredModel
- The desired database schemachanges
- The changesparams
- The parameters used in the creation of new tables. Note that for existing
tables, the parameters won't be applied
java.io.IOException
protected void processTableStructureChanges(Database currentModel, Database desiredModel, Table sourceTable, Table targetTable, java.util.Map parameters, java.util.List changes) throws java.io.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
java.io.IOException
protected void processChange(Database currentModel, Database desiredModel, AddColumnChange change) throws java.io.IOException
currentModel
- The current database schemadesiredModel
- The desired database schemachange
- The change object
java.io.IOException
protected void processChange(Database currentModel, Database desiredModel, RemoveColumnChange change) throws java.io.IOException
currentModel
- The current database schemadesiredModel
- The desired database schemachange
- The change object
java.io.IOException
protected void processChange(Database currentModel, Database desiredModel, RemovePrimaryKeyChange change) throws java.io.IOException
currentModel
- The current database schemadesiredModel
- The desired database schemachange
- The change object
java.io.IOException
protected void processChange(Database currentModel, Database desiredModel, ColumnDefaultValueChange change) throws java.io.IOException
currentModel
- The current database schemadesiredModel
- The desired database schemachange
- The change object
java.io.IOException
protected void processColumnChange(Table sourceTable, Table targetTable, Column sourceColumn, Column targetColumn) throws java.io.IOException
sourceTable
- The current tabletargetTable
- The desired tablesourceColumn
- The current columntargetColumn
- The desired column
java.io.IOException
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |