Package org.apache.empire.dbms.oracle

Class OracleDDLGenerator

java.lang.Object

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

org.apache.empire.dbms.oracle.OracleDDLGenerator

public class OracleDDLGenerator
extends DBDDLGenerator<DBMSHandlerOracle>

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
OracleDDLGenerator(DBMSHandlerOracle dmbsHandler)

Method Summary

Modifier and Type	Method	Description
protected void	addCreateIndexStmt(DBIndex index, DBSQLBuilder sql, DBSQLScript script)
protected void	addCreateTableStmt(DBTable table, 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	appendColumnDesc(DBTableColumn c, boolean alter, DBSQLBuilder sql)	Appends a table column definition to a ddl statement
protected void	appendIndexColumn(DBIndex index, DBColumnExpr idxColumn, DBSQLBuilder sql)	Appends an column expression to an index
protected void	createComment(DBDatabase db, String type, DBExpr expr, String comment, DBSQLScript script)
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.
protected void	createSequence(DBDatabase db, DBTableColumn column, DBSQLScript script)	Returns true if the sequence has been created successfully.
protected void	createTable(DBTable t, DBSQLScript script)	Appends the DDL-Script for creating the given table to an SQL-Script
protected void	dropDatabase(DBDatabase db, DBSQLScript script)	Appends the DDL-Script for dropping a database to the given script object
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.

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

addAlterTableStmt, addCreateRelationStmt, alterTable, appendElementName, appendIndexType, createIndex, createRelation, createTableIndexes, createView, dropObject, isDDLColumnDefaults, setDDLColumnDefaults

Methods inherited from class java.lang.Object

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

Constructor Details

OracleDDLGenerator

public OracleDDLGenerator(DBMSHandlerOracle dmbsHandler)

Method Details

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<DBMSHandlerOracle>

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

appendColumnDesc

protected void appendColumnDesc(DBTableColumn c,
 boolean alter,
 DBSQLBuilder sql)

Description copied from class: DBDDLGenerator

Appends a table column definition to a ddl statement

Overrides:

appendColumnDesc in class DBDDLGenerator<DBMSHandlerOracle>

Parameters:

c - the column which description to append

alter - true if altering an existing column or false otherwise

sql - the sql builder object

appendIndexColumn

protected void appendIndexColumn(DBIndex index,
 DBColumnExpr idxColumn,
 DBSQLBuilder sql)

Description copied from class: DBDDLGenerator

Appends an column expression to an index

Overrides:

appendIndexColumn in class DBDDLGenerator<DBMSHandlerOracle>

Parameters:

index - the index for which to append the column

idxColumn - the index column

sql - the SQL builder

addCreateTableStmt

protected void addCreateTableStmt(DBTable table,
 DBSQLBuilder sql,
 DBSQLScript script)

Overrides:

addCreateTableStmt in class DBDDLGenerator<DBMSHandlerOracle>

addCreateIndexStmt

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

Overrides:

addCreateIndexStmt in class DBDDLGenerator<DBMSHandlerOracle>

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<DBMSHandlerOracle>

Parameters:

db - the database to create

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

dropDatabase

protected void dropDatabase(DBDatabase db,
 DBSQLScript script)

Description copied from class: DBDDLGenerator

Appends the DDL-Script for dropping a database to the given script object

Overrides:

dropDatabase in class DBDDLGenerator<DBMSHandlerOracle>

Parameters:

db - the database to drop

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

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<DBMSHandlerOracle>

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)

createSequence

protected void createSequence(DBDatabase db,
 DBTableColumn column,
 DBSQLScript script)

Returns true if the sequence has been created successfully.

createTable

protected void createTable(DBTable t,
 DBSQLScript script)

Description copied from class: DBDDLGenerator

Appends the DDL-Script for creating the given table to an SQL-Script

Overrides:

createTable in class DBDDLGenerator<DBMSHandlerOracle>

Parameters:

t - the table to create

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

addCreateViewStmt

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

Overrides:

addCreateViewStmt in class DBDDLGenerator<DBMSHandlerOracle>

createComment

protected void createComment(DBDatabase db,
 String type,
 DBExpr expr,
 String comment,
 DBSQLScript script)