org.kepler.util.sql

Class PostgreSQL

java.lang.Object

org.kepler.util.sql.DatabaseType

org.kepler.util.sql.PostgreSQL

public class PostgreSQL
extends DatabaseType

An implementation of DatabaseType for PostgreSQL.

Author:

Daniel Crawl

Field Summary

Fields inherited from class org.kepler.util.sql.DatabaseType

_connection, _createIndexes, VERSION_TABLE_NAME

Constructor Summary

Constructors

Modifier	Constructor and Description
protected	PostgreSQL() Only this package (DatabaseFactory) can instantiate.

Method Summary

Modifier and Type	Method and Description
protected boolean	_areForeignKeysIndexed() Returns true if foreign keys are automatically indexed.
protected java.lang.String	_getDriverName() Get the driver class name.
protected java.lang.String	_getJDBCUrl(java.lang.String hostName, java.lang.String port, java.lang.String databaseName) Get a JDBC URL.
protected java.lang.String	_getTypeString(Column column) Get the SQL string of a column type.
protected boolean	_hasGeneratedKeys() Returns true if database supports auto-generated keys in its prepared statements.
protected boolean	_isAutoIncResultReferencedByName() Returns true if an auto-incremented column value in a ResultSet must be referenced with the name instead of position.
void	connect(java.util.Map<java.lang.String,java.lang.String> parameters) Connect to a database.
java.lang.String	getColumnName(java.lang.String columnName) Adjust the name of a column.
java.lang.String	getDefaultTimeStr() Get a string representing the default time.
java.lang.String	getFalseValue() Get a string representation of the false value for a boolean column.
java.lang.String	getName() Get the name of the type.
java.lang.String	getTrueValue() Get a string representation of the true value for a boolean column.
void	renameColumn(java.lang.String oldName, Column newColumn, java.lang.String tableName) Rename a column.
void	setColumnNotNull(Column column, java.lang.String tableName) Set not null constraint to a column.
void	setColumnNull(Column column, java.lang.String tableName) Change a column to allow null values.

Methods inherited from class org.kepler.util.sql.DatabaseType

_arePrimaryKeysIndexed, _combineHostAndPort, _connectInitialize, _executeSQL, _getConnection, _getConnection, _getCreateTableSuffix, _getPort, _hasCatalog, _isIdentifierTooLong, _isTableCached, _needCapitalColumnNames, _needCapitalTableNames, _needIdentityForAutoInc, _needSequencesForAutoInc, addMinorVersion, changeColumnType, commit, copyColumn, createColumn, createColumn, createColumn, createIndex, createIndex, createTables, createTables, createVersionTable, deleteColumn, disconnect, getColumnAlterStr, getColumnDefinition, getColumnDefinition, getColumnNames, getColumnSize, getConnection, getMajorVersion, getMinorVersion, getPrepStatement, getPrimaryFileExtension, getSQLDelete, getSQLInsert, getSQLInsert, getSQLSelect, getSQLSelect, getSQLUpdate, getStatement, getTableName, getVersionString, hasNewerSchema, hasOlderSchema, insert, needAbsolutePathForName, needHostForConnect, needPasswordForConnect, needUserForConnect, procedureExists, rollback, setAutoCommit, tableExists, tableExists, updateMinorVersion

Methods inherited from class java.lang.Object

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

Constructor Detail

PostgreSQL

protected PostgreSQL()

Only this package (DatabaseFactory) can instantiate.

Method Detail

connect

public void connect(java.util.Map<java.lang.String,java.lang.String> parameters)
             throws java.sql.SQLException

Connect to a database.

Overrides:

connect in class DatabaseType

Throws:

java.sql.SQLException

getColumnName

public java.lang.String getColumnName(java.lang.String columnName)

Adjust the name of a column.

Overrides:

getColumnName in class DatabaseType

getFalseValue

public java.lang.String getFalseValue()

Get a string representation of the false value for a boolean column.

Overrides:

getFalseValue in class DatabaseType

getTrueValue

public java.lang.String getTrueValue()

Get a string representation of the true value for a boolean column.

Overrides:

getTrueValue in class DatabaseType

getDefaultTimeStr

public java.lang.String getDefaultTimeStr()

Get a string representing the default time.

Overrides:

getDefaultTimeStr in class DatabaseType

getName

public java.lang.String getName()

Get the name of the type.

Specified by:

getName in class DatabaseType

renameColumn

public void renameColumn(java.lang.String oldName,
                         Column newColumn,
                         java.lang.String tableName)
                  throws java.sql.SQLException

Rename a column.

Specified by:

renameColumn in class DatabaseType

Throws:

java.sql.SQLException

setColumnNull

public void setColumnNull(Column column,
                          java.lang.String tableName)
                   throws java.sql.SQLException

Change a column to allow null values.

Specified by:

setColumnNull in class DatabaseType

Throws:

java.sql.SQLException

setColumnNotNull

public void setColumnNotNull(Column column,
                             java.lang.String tableName)
                      throws java.sql.SQLException

Set not null constraint to a column.

Specified by:

setColumnNotNull in class DatabaseType

Throws:

java.sql.SQLException

_areForeignKeysIndexed

protected boolean _areForeignKeysIndexed()

Returns true if foreign keys are automatically indexed.

Overrides:

_areForeignKeysIndexed in class DatabaseType

_getDriverName

protected java.lang.String _getDriverName()

Get the driver class name.

Specified by:

_getDriverName in class DatabaseType

_getJDBCUrl

protected java.lang.String _getJDBCUrl(java.lang.String hostName,
                                       java.lang.String port,
                                       java.lang.String databaseName)
                                throws java.sql.SQLException

Get a JDBC URL.

Specified by:

_getJDBCUrl in class DatabaseType

Throws:

java.sql.SQLException

_getTypeString

protected java.lang.String _getTypeString(Column column)

Get the SQL string of a column type.

Specified by:

_getTypeString in class DatabaseType

_hasGeneratedKeys

protected boolean _hasGeneratedKeys()

Returns true if database supports auto-generated keys in its prepared statements.

Specified by:

_hasGeneratedKeys in class DatabaseType

_isAutoIncResultReferencedByName

protected boolean _isAutoIncResultReferencedByName()

Returns true if an auto-incremented column value in a ResultSet must be referenced with the name instead of position.

Overrides:

_isAutoIncResultReferencedByName in class DatabaseType