public class OracleDDLGenerator extends DBDDLGenerator<DBMSHandlerOracle>
DBDDLGenerator.DDLActionTypealterColumnPhrase, databaseObjectName, DATATYPE_BLOB, DATATYPE_BOOLEAN, DATATYPE_CHAR, DATATYPE_CLOB, DATATYPE_DATE, DATATYPE_DECIMAL, DATATYPE_FLOAT, DATATYPE_INT_BIG, DATATYPE_INT_SMALL, DATATYPE_INTEGER, DATATYPE_TIME, DATATYPE_TIMESTAMP, DATATYPE_UNIQUEID, DATATYPE_VARCHAR, dbms, ddlColumnDefaults, namePrimaryKeyConstraint| Constructor and Description |
|---|
OracleDDLGenerator(DBMSHandlerOracle dmbsHandler) |
| Modifier and Type | Method and Description |
|---|---|
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 |
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.
|
addAlterTableStmt, addCreateIndexStmt, addCreateRelationStmt, addCreateTableStmt, alterTable, appendColumnDesc, appendElementName, createIndex, createRelation, createTableIndexes, createView, dropObject, isDDLColumnDefaults, setDDLColumnDefaultspublic OracleDDLGenerator(DBMSHandlerOracle dmbsHandler)
protected boolean appendColumnDataType(DataType type, double size, DBTableColumn c, DBSQLBuilder sql)
DBDDLGeneratorappendColumnDataType in class DBDDLGenerator<DBMSHandlerOracle>type - the typesize - the sizec - the table columnsql - the builder that we will append toprotected void createDatabase(DBDatabase db, DBSQLScript script)
DBDDLGeneratorcreateDatabase in class DBDDLGenerator<DBMSHandlerOracle>db - the database to createscript - the sql script to which to append the dll command(s)protected void dropDatabase(DBDatabase db, DBSQLScript script)
DBDDLGeneratordropDatabase in class DBDDLGenerator<DBMSHandlerOracle>db - the database to dropscript - the sql script to which to append the dll command(s)public void getDDLScript(DBDDLGenerator.DDLActionType type, DBObject dbo, DBSQLScript script)
DBDDLGeneratorgetDDLScript in class DBDDLGenerator<DBMSHandlerOracle>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)protected void createSequence(DBDatabase db, DBTableColumn column, DBSQLScript script)
protected void createTable(DBTable t, DBSQLScript script)
DBDDLGeneratorcreateTable in class DBDDLGenerator<DBMSHandlerOracle>t - the table to createscript - the sql script to which to append the dll command(s)protected void addCreateViewStmt(DBView v, DBSQLBuilder sql, DBSQLScript script)
addCreateViewStmt in class DBDDLGenerator<DBMSHandlerOracle>protected void createComment(DBDatabase db, String type, DBExpr expr, String comment, DBSQLScript script)
Copyright © 2008–2023 Apache Software Foundation. All rights reserved.