|
||||||||||
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.mssql.MSSqlBuilder
The SQL Builder for the Microsoft SQL Server.
Field Summary |
Fields inherited from class org.apache.ddlutils.platform.SqlBuilder |
_log, SIZE_PLACEHOLDER |
Constructor Summary | |
MSSqlBuilder(Platform platform)
Creates a new builder instance. |
Method Summary | |
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 |
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. |
String |
getDeleteSql(Table table,
Map pkValues,
boolean genPlaceholders)
Creates the SQL for deleting an object from the specified table. If values are given then a concrete delete statement is created, otherwise an delete statement usable in a prepared statement is build. |
protected String |
getDisableIdentityOverrideSql(Table table)
Returns the SQL to disable identity override mode. |
protected String |
getEnableIdentityOverrideSql(Table table)
Returns the SQL to enable identity override mode. |
String |
getInsertSql(Table table,
Map columnValues,
boolean genPlaceholders)
Creates the SQL for inserting an object into the specified table. If values are given then a concrete insert statement is created, otherwise an insert statement usable in a prepared statement is build. |
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 . |
String |
getUpdateSql(Table table,
Map columnValues,
boolean genPlaceholders)
Creates the SQL for updating an object in the specified table. If values are given then a concrete update statement is created, otherwise an update statement usable in a prepared statement is build. |
protected String |
getValueAsString(Column column,
Object value)
Generates the string representation of the given value. |
protected DateFormat |
getValueDateFormat()
Returns the format object for formatting dates in the specified locale. |
protected DateFormat |
getValueTimeFormat()
Returns the format object for formatting times in the specified locale. |
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 |
processChanges(Database currentModel,
Database desiredModel,
List changes,
CreationParameters params)
Processes the changes. The default argument performs several passes:
|
protected void |
processColumnChange(Table sourceTable,
Table targetTable,
Column sourceColumn,
Column targetColumn,
boolean typeChange)
Processes a change to a column. |
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. |
protected void |
writeCopyDataStatement(Table sourceTable,
Table targetTable)
Writes a statement that copies the data from the source to the target table. Note that this copies only those columns that are in both tables. Database-specific implementations might redefine this method though they usually it suffices to redefine the SqlBuilder.writeCastExpression(Column, Column) method. |
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. |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
public MSSqlBuilder(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
public void dropExternalForeignKeys(Table table) throws IOException
dropExternalForeignKeys
in class SqlBuilder
table
- The table
IOException
protected DateFormat getValueDateFormat()
getValueDateFormat
in class SqlBuilder
protected DateFormat getValueTimeFormat()
getValueTimeFormat
in class SqlBuilder
protected String getValueAsString(Column column, Object value)
getValueAsString
in class SqlBuilder
column
- The columnvalue
- The value
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 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 writeExternalForeignKeyDropStmt(Table table, ForeignKey foreignKey) throws IOException
writeExternalForeignKeyDropStmt
in class SqlBuilder
table
- The tableforeignKey
- The foreign key
IOException
public String getSelectLastIdentityValues(Table table)
null
.
getSelectLastIdentityValues
in class SqlBuilder
table
- The table
null
if the database does not support thisprotected String getEnableIdentityOverrideSql(Table table)
table
- The table to enable the mode for
protected String getDisableIdentityOverrideSql(Table table)
table
- The table to disable the mode for
public String getDeleteSql(Table table, Map pkValues, boolean genPlaceholders)
getDeleteSql
in class SqlBuilder
table
- The tablepkValues
- The primary key values indexed by the column names, can be emptygenPlaceholders
- Whether to generate value placeholders for a
prepared statement
public String getInsertSql(Table table, Map columnValues, boolean genPlaceholders)
getInsertSql
in class SqlBuilder
table
- The tablecolumnValues
- The columns values indexed by the column namesgenPlaceholders
- Whether to generate value placeholders for a
prepared statement
public String getUpdateSql(Table table, Map columnValues, boolean genPlaceholders)
getUpdateSql
in class SqlBuilder
table
- The tablecolumnValues
- Contains the values for the columns to update, and should also
contain the primary key values to identify the object to update
in case genPlaceholders
is false
genPlaceholders
- Whether to generate value placeholders for a
prepared statement (both for the pk values and the object values)
protected void writeCopyDataStatement(Table sourceTable, Table targetTable) throws IOException
SqlBuilder.writeCastExpression(Column, Column)
method.
writeCopyDataStatement
in class SqlBuilder
sourceTable
- The source tabletargetTable
- The target table
IOException
protected void processChanges(Database currentModel, Database desiredModel, List changes, CreationParameters params) throws 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
IOException
protected 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
protected void processColumnChange(Table sourceTable, Table targetTable, Column sourceColumn, Column targetColumn, boolean typeChange) throws IOException
sourceTable
- The current tabletargetTable
- The desired tablesourceColumn
- The current columntargetColumn
- The desired columntypeChange
- Whether this is a type change
IOException
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |