er.extensions.jdbc

Class ERXSQLHelper.PostgresqlSQLHelper

java.lang.Object

er.extensions.jdbc.ERXSQLHelper

er.extensions.jdbc.ERXSQLHelper.PostgresqlSQLHelper

Enclosing class:

ERXSQLHelper

public static class ERXSQLHelper.PostgresqlSQLHelper
extends ERXSQLHelper

Nested Class Summary

Nested classes/interfaces inherited from class er.extensions.jdbc.ERXSQLHelper

ERXSQLHelper.ColumnIndex, ERXSQLHelper.CustomTypes, ERXSQLHelper.DB2SQLHelper, ERXSQLHelper.DerbySQLHelper, ERXSQLHelper.EROracleSQLHelper, ERXSQLHelper.FirebirdSQLHelper, ERXSQLHelper.FrontBaseSQLHelper, ERXSQLHelper.H2SQLHelper, ERXSQLHelper.MicrosoftSQLHelper, ERXSQLHelper.MySQLSQLHelper, ERXSQLHelper.NoSQLHelper, ERXSQLHelper.OpenBaseSQLHelper, ERXSQLHelper.OracleSQLHelper, ERXSQLHelper.PostgresqlSQLHelper

Field Summary

Fields

Modifier and Type	Field and Description
static String	UNIQUE_CONSTRAINT_EXCEPTION_STATE The exception state string for unique constraint exceptions.
static String	UNIQUE_CONSTRAINT_MESSAGE_FORMAT

Constructor Summary

Constructors

Constructor and Description
PostgresqlSQLHelper()

Method Summary

Modifier and Type	Method and Description
String	externalTypeForJDBCType(JDBCAdaptor adaptor, int jdbcType) For most types, finding the type in jdbc2Info's typeInfo will provide us with a correct type mapping.
boolean	handleDatabaseException(EODatabaseContext databaseContext, Throwable throwable) Returns true if the SQL helper can handle the exception.
String	limitExpressionForSQL(EOSQLExpression expression, EOFetchSpecification fetchSpecification, String sql, long start, long end)
boolean	reassignExternalTypeForValueTypeOverride(EOAttribute attr) Overriden to prevent the external time types set in externalTypeForJDBCType(JDBCAdaptor, int) from being reset.
protected String	sqlForCountDistinct(EOEntity entity) Returns the SQL to count the distinct number of rows.
String	sqlForCreateIndex(String indexName, String tableName, ERXSQLHelper.ColumnIndex... columnIndexes) Returns the SQL expression for creating an index on the given set of columns
String	sqlForCreateUniqueIndex(String indexName, String tableName, ERXSQLHelper.ColumnIndex... columnIndexes) Creates unique index; stolen from the derby helper
protected String	sqlForGetNextValFromSequencedNamed(String sequenceName) Returns the SQL required to select the next value from the given sequence.
String	sqlForRegularExpressionQuery(String key, String value) Returns the SQL expression for a regular expression query.
int	varcharLargeColumnWidth() Returns the width that should be used for a varcharLarge column in migrations.
int	varcharLargeJDBCType() Returns the JDBCType that should be used for a varcharLarge column in migrations.

Methods inherited from class er.extensions.jdbc.ERXSQLHelper

_groupByOrHavingIndex, _orderByIndex, addGroupByClauseToExpression, addGroupByClauseToExpression, addHavingCountClauseToExpression, appendItemToListString, attributesToFetchForEntity, canReliablyPerformDistinctWithSortOrderings, columnIndexesFromColumnNames, columnNamesFromColumnIndexes, commandSeparatorChar, commandSeparatorString, commentPattern, createDependentSchemaSQLForEntities, createIndexSQLForEntities, createIndexSQLForEntities, createSchemaSQLForEntitiesInDatabaseContext, createSchemaSQLForEntitiesInModel, createSchemaSQLForEntitiesInModelAndOptions, createSchemaSQLForEntitiesInModelWithName, createSchemaSQLForEntitiesInModelWithNameAndOptions, createSchemaSQLForEntitiesWithOptions, createSchemaSQLForEntitiesWithOptions, customQueryExpressionHintAsString, defaultOptionDictionary, formatValueForAttribute, getNextValFromSequenceNamed, jdbcTypeForCustomType, maximumElementPerInClause, migrationTableName, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, prepareConnectionForSchemaChange, quoteColumnName, readFormatForAggregateFunction, readFormatForAggregateFunction, removeSelectFromExpression, restoreConnectionSettingsAfterSchemaChange, rowCountForFetchSpecification, shouldExecute, shouldPerformDistinctInMemory, splitSQLStatements, splitSQLStatementsFromFile, splitSQLStatementsFromInputStream, sqlExpressionForFetchSpecification, sqlExpressionForFetchSpecification, sqlForCreateIndex, sqlForCreateUniqueIndex, sqlForFullTextQuery, sqlForSubquery, sqlWhereClauseStringForKey

Methods inherited from class java.lang.Object

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

Field Detail

UNIQUE_CONSTRAINT_EXCEPTION_STATE

public static final String UNIQUE_CONSTRAINT_EXCEPTION_STATE

The exception state string for unique constraint exceptions.

See Also:

Error codes, Constant Field Values

UNIQUE_CONSTRAINT_MESSAGE_FORMAT

public static final String UNIQUE_CONSTRAINT_MESSAGE_FORMAT

See Also:

Constant Field Values

Constructor Detail

PostgresqlSQLHelper

public PostgresqlSQLHelper()

Method Detail

reassignExternalTypeForValueTypeOverride

public boolean reassignExternalTypeForValueTypeOverride(EOAttribute attr)

Overriden to prevent the external time types set in externalTypeForJDBCType(JDBCAdaptor, int) from being reset.

Overrides:

reassignExternalTypeForValueTypeOverride in class ERXSQLHelper

sqlForGetNextValFromSequencedNamed

protected String sqlForGetNextValFromSequencedNamed(String sequenceName)

Description copied from class: ERXSQLHelper

Returns the SQL required to select the next value from the given sequence. This should return a single row with a single column.

Overrides:

sqlForGetNextValFromSequencedNamed in class ERXSQLHelper

Parameters:

sequenceName - the name of the sequence

Returns:

the next sequence value

limitExpressionForSQL

public String limitExpressionForSQL(EOSQLExpression expression,
                                    EOFetchSpecification fetchSpecification,
                                    String sql,
                                    long start,
                                    long end)

Overrides:

limitExpressionForSQL in class ERXSQLHelper

sqlForRegularExpressionQuery

public String sqlForRegularExpressionQuery(String key,
                                           String value)

Description copied from class: ERXSQLHelper

Returns the SQL expression for a regular expression query.

Overrides:

sqlForRegularExpressionQuery in class ERXSQLHelper

Returns:

the regex SQL

externalTypeForJDBCType

public String externalTypeForJDBCType(JDBCAdaptor adaptor,
                                      int jdbcType)

For most types, finding the type in jdbc2Info's typeInfo will provide us with a correct type mapping. For Postgresql, it has the honor of not actually having a type named "integer," so EOF goes on a hunt for a type that MIGHT match (which is just bad, btw) and comes up with "serial". cug: There seems to be also nothing useful for "BLOB", so we return bytea for Type.BLOB; int8 for BIGINT; numeric for DECIMAL; bool for BOOLEAN We know better than EOF. For any other case, we pass it up to the default impl.

Overrides:

externalTypeForJDBCType in class ERXSQLHelper

Parameters:

adaptor - the adaptor to retrieve an external type for

jdbcType - the JDBC type number

Returns:

a guess at the external type name to use

sqlForCreateUniqueIndex

public String sqlForCreateUniqueIndex(String indexName,
                                      String tableName,
                                      ERXSQLHelper.ColumnIndex... columnIndexes)

Creates unique index; stolen from the derby helper

Overrides:

sqlForCreateUniqueIndex in class ERXSQLHelper

Parameters:

indexName - the name of the index to create

tableName - the name of the containing table

columnIndexes - the list of columns to index on

Returns:

a SQL expression

See Also:

ERXSQLHelper.sqlForCreateUniqueIndex(String, String, ColumnIndex...)

Author:

cug - Jun 24, 2008

sqlForCreateIndex

public String sqlForCreateIndex(String indexName,
                                String tableName,
                                ERXSQLHelper.ColumnIndex... columnIndexes)

Description copied from class: ERXSQLHelper

Returns the SQL expression for creating an index on the given set of columns

Overrides:

sqlForCreateIndex in class ERXSQLHelper

Parameters:

indexName - the name of the index to create

tableName - the name of the containing table

columnIndexes - the list of columns to index on

Returns:

a SQL expression

varcharLargeJDBCType

public int varcharLargeJDBCType()

Description copied from class: ERXSQLHelper

Returns the JDBCType that should be used for a varcharLarge column in migrations.

Overrides:

varcharLargeJDBCType in class ERXSQLHelper

Returns:

the JDBCType that should be used for a varcharLarge column in migrations

varcharLargeColumnWidth

public int varcharLargeColumnWidth()

Description copied from class: ERXSQLHelper

Returns the width that should be used for a varcharLarge column in migrations.

Overrides:

varcharLargeColumnWidth in class ERXSQLHelper

Returns:

the width that should be used for a varcharLarge column in migrations

handleDatabaseException

public boolean handleDatabaseException(EODatabaseContext databaseContext,
                                       Throwable throwable)

Description copied from class: ERXSQLHelper

Returns true if the SQL helper can handle the exception. Typical uses are morphing unique constraints to NSValidation exceptions.

Overrides:

handleDatabaseException in class ERXSQLHelper

Returns:

whether or not the SQL helper can handl this exception

sqlForCountDistinct

protected String sqlForCountDistinct(EOEntity entity)

Description copied from class: ERXSQLHelper

Returns the SQL to count the distinct number of rows. The general implementation doesn't support composite primary keys and chooses only one primary key column when formatting the SQL expression.

Concrete classes may override this implementation to add support for composite primary keys according to their database specific SQL syntax.

Overrides:

sqlForCountDistinct in class ERXSQLHelper

Parameters:

entity - the base entity used in this query

Returns:

the formatted SQL count using distinct for the given entity