Package org.apache.empire.dbms.postgresql

Class PostgresDDLGenerator

java.lang.Object

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

org.apache.empire.dbms.postgresql.PostgresDDLGenerator

public class PostgresDDLGenerator
extends DBDDLGenerator<DBMSHandlerPostgreSQL>

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
PostgresDDLGenerator(DBMSHandlerPostgreSQL dbms)

Method Summary

Modifier and Type	Method	Description
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	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)	Appends the DDL-Script for creating a sequence to an SQL-Script
boolean	isCreateReverseFunction()	Returns whether the reverse function should be created with the database
void	setCreateReverseFunction(boolean createReverseFunction)	Set whether to create the reverse function with the database

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

addAlterTableStmt, addCreateIndexStmt, addCreateRelationStmt, addCreateTableStmt, addCreateViewStmt, alterTable, appendElementName, appendIndexColumn, appendIndexType, createIndex, createRelation, createTable, createTableIndexes, createView, dropDatabase, dropObject, getDDLScript, isDDLColumnDefaults, setDDLColumnDefaults

Methods inherited from class java.lang.Object

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

Constructor Details

PostgresDDLGenerator

public PostgresDDLGenerator(DBMSHandlerPostgreSQL dbms)

Method Details

isCreateReverseFunction

public boolean isCreateReverseFunction()

Returns whether the reverse function should be created with the database

setCreateReverseFunction

public void setCreateReverseFunction(boolean createReverseFunction)

Set whether to create the reverse function with the database

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

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

Parameters:

db - the database to create

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

createSequence

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

Appends the DDL-Script for creating a sequence to an SQL-Script

Parameters:

db - the database to create

column - the column for which to create the sequence

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

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

Parameters:

c - the column which description to append

alter - true if altering an existing column or false otherwise

sql - the sql builder object