Package org.apache.empire.dbms.sqlserver

Class MSSqlDDLGenerator

java.lang.Object

org.apache.empire.db.DBDDLGenerator<DBMSHandlerMSSQL>

org.apache.empire.dbms.sqlserver.MSSqlDDLGenerator

public class MSSqlDDLGenerator
extends DBDDLGenerator<DBMSHandlerMSSQL>

Nested Class Summary

Nested classes/interfaces inherited from class org.apache.empire.db.DBDDLGenerator

DBDDLGenerator.DDLActionType

Field Summary

Fields inherited from class org.apache.empire.db.DBDDLGenerator

alterColumnPhrase, databaseObjectName, DATATYPE_BLOB, DATATYPE_BOOLEAN, DATATYPE_CHAR, DATATYPE_CLOB, DATATYPE_DATE, DATATYPE_DATETIME, DATATYPE_DECIMAL, DATATYPE_FLOAT, DATATYPE_INT_BIG, DATATYPE_INT_SMALL, DATATYPE_INTEGER, DATATYPE_TIME, DATATYPE_TIMESTAMP, DATATYPE_UNIQUEID, DATATYPE_VARCHAR, dbms, ddlColumnDefaults, log, namePrimaryKeyConstraint

Constructor Summary

Constructors

Constructor	Description
MSSqlDDLGenerator(DBMSHandlerMSSQL dbms)

Method Summary

Modifier and Type	Method	Description
protected void	addCreateIndexStmt(DBIndex index, DBSQLBuilder sql, DBSQLScript script)
protected void	addCreateViewStmt(DBView v, DBSQLBuilder sql, DBSQLScript script)
protected boolean	appendColumnDataType(DataType type, double size, DBTableColumn c, DBSQLBuilder sql)	appends the data type of a column
protected void	appendIndexType(DBIndex index, DBSQLBuilder sql)	Appends the index type when creating an index
protected void	createDatabase(DBDatabase db, DBSQLScript script)	Appends the DDL-Script for creating the given database to an SQL-Script This includes the generation of all tables, views and relations.
void	getDDLScript(DBDDLGenerator.DDLActionType type, DBObject dbo, DBSQLScript script)	Appends the required DLL commands to create, drop or alter an object to the supplied DBDQLScript.
protected void	initDataTypes(DBMSHandlerMSSQL dbms)	sets Oracle specific data types

Methods inherited from class org.apache.empire.db.DBDDLGenerator

addAlterTableStmt, addCreateRelationStmt, addCreateTableStmt, alterTable, appendColumnDesc, appendElementName, appendIndexColumn, createIndex, createRelation, createTable, createTableIndexes, createView, dropDatabase, dropObject, isDDLColumnDefaults, setDDLColumnDefaults

Methods inherited from class java.lang.Object

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

Constructor Details

MSSqlDDLGenerator

public MSSqlDDLGenerator(DBMSHandlerMSSQL dbms)

Method Details

initDataTypes

protected void initDataTypes(DBMSHandlerMSSQL dbms)

sets Oracle specific data types

Parameters:

dbms -

appendColumnDataType

protected boolean appendColumnDataType(DataType type,
 double size,
 DBTableColumn c,
 DBSQLBuilder sql)

Description copied from class: DBDDLGenerator

appends the data type of a column

Overrides:

appendColumnDataType in class DBDDLGenerator<DBMSHandlerMSSQL>

Parameters:

type - the type

size - the size

c - the table column

sql - the builder that we will append to

Returns:

true if further column attributes may be added or false otherwise

createDatabase

protected void createDatabase(DBDatabase db,
 DBSQLScript script)

Description copied from class: DBDDLGenerator

Appends the DDL-Script for creating the given database to an SQL-Script
This includes the generation of all tables, views and relations.

Overrides:

createDatabase in class DBDDLGenerator<DBMSHandlerMSSQL>

Parameters:

db - the database to create

script - the sql script to which to append the dll command(s)

appendIndexType

protected void appendIndexType(DBIndex index,
 DBSQLBuilder sql)

Description copied from class: DBDDLGenerator

Appends the index type when creating an index

Overrides:

appendIndexType in class DBDDLGenerator<DBMSHandlerMSSQL>

Parameters:

index - the index

sql - the sql builder object

addCreateIndexStmt

protected void addCreateIndexStmt(DBIndex index,
 DBSQLBuilder sql,
 DBSQLScript script)

Overrides:

addCreateIndexStmt in class DBDDLGenerator<DBMSHandlerMSSQL>

addCreateViewStmt

protected void addCreateViewStmt(DBView v,
 DBSQLBuilder sql,
 DBSQLScript script)

Overrides:

addCreateViewStmt in class DBDDLGenerator<DBMSHandlerMSSQL>

getDDLScript

public void getDDLScript(DBDDLGenerator.DDLActionType type,
 DBObject dbo,
 DBSQLScript script)

Description copied from class: DBDDLGenerator

Appends the required DLL commands to create, drop or alter an object to the supplied DBDQLScript.

Overrides:

getDDLScript in class DBDDLGenerator<DBMSHandlerMSSQL>

Parameters:

type - operation to perform (CREATE, DROP, ALTER)

dbo - the object for which to perform the operation (DBDatabase, DBTable, DBView, DBColumn, DBRelation)

script - the script to which to add the DDL command(s)