er.extensions.jdbc
Class ERXSQLHelper.FrontBaseSQLHelper

java.lang.Object
  er.extensions.jdbc.ERXSQLHelper
      er.extensions.jdbc.ERXSQLHelper.FrontBaseSQLHelper

Enclosing class:

ERXSQLHelper

public static class ERXSQLHelper.FrontBaseSQLHelper
extends ERXSQLHelper

Nested Class Summary

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

ERXSQLHelper.ColumnIndex, ERXSQLHelper.CustomTypes, ERXSQLHelper.DerbySQLHelper, ERXSQLHelper.EROracleSQLHelper, ERXSQLHelper.FrontBaseSQLHelper, ERXSQLHelper.MicrosoftSQLHelper, ERXSQLHelper.MySQLSQLHelper, ERXSQLHelper.OpenBaseSQLHelper, ERXSQLHelper.OracleSQLHelper, ERXSQLHelper.PostgresqlSQLHelper

Field Summary

Fields inherited from class er.extensions.jdbc.ERXSQLHelper

log

Constructor Summary

ERXSQLHelper.FrontBaseSQLHelper()

Method Summary

protected Pattern	commentPattern() Returns a pattern than matches lines that start with "--".
String	limitExpressionForSQL(EOSQLExpression expression, EOFetchSpecification fetchSpecification, String sql, long start, long end)
void	prepareConnectionForSchemaChange(EOEditingContext ec, EOModel model)
void	restoreConnectionSettingsAfterSchemaChange(EOEditingContext ec, EOModel model)
boolean	shouldExecute(String sql)
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) Returns the SQL expression for creating a unique index on the given set of columns
String	sqlForFullTextQuery(ERXFullTextQualifier qualifier, EOSQLExpression expression) Returns the SQL expression for a full text search query.
protected String	sqlForGetNextValFromSequencedNamed(String sequenceName) Returns the SQL required to select the next value from the given sequence.

Methods inherited from class er.extensions.jdbc.ERXSQLHelper

_groupByOrHavingIndex, _orderByIndex, addGroupByClauseToExpression, addGroupByClauseToExpression, addHavingCountClauseToExpression, appendItemToListString, attributesToFetchForEntity, columnIndexesFromColumnNames, columnNamesFromColumnIndexes, commandSeparatorChar, commandSeparatorString, createDependentSchemaSQLForEntities, createIndexSQLForEntities, createIndexSQLForEntities, createSchemaSQLForEntitiesInDatabaseContext, createSchemaSQLForEntitiesInModel, createSchemaSQLForEntitiesInModelAndOptions, createSchemaSQLForEntitiesInModelWithName, createSchemaSQLForEntitiesInModelWithNameAndOptions, createSchemaSQLForEntitiesWithOptions, createSchemaSQLForEntitiesWithOptions, customQueryExpressionHintAsString, defaultOptionDictionary, externalTypeForJDBCType, formatValueForAttribute, getNextValFromSequenceNamed, jdbcTypeForCustomType, migrationTableName, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, newSQLHelper, readFormatForAggregateFunction, reassignExternalTypeForValueTypeOverride, removeSelectFromExpression, rowCountForFetchSpecification, splitSQLStatements, splitSQLStatementsFromFile, splitSQLStatementsFromInputStream, sqlExpressionForFetchSpecification, sqlExpressionForFetchSpecification, sqlForCreateIndex, sqlForCreateUniqueIndex, sqlForRegularExpressionQuery, sqlWhereClauseStringForKey, varcharLargeColumnWidth, varcharLargeJDBCType

Methods inherited from class java.lang.Object

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

Constructor Detail

ERXSQLHelper.FrontBaseSQLHelper

public ERXSQLHelper.FrontBaseSQLHelper()

Method Detail

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

shouldExecute

public boolean shouldExecute(String sql)

Overrides:

shouldExecute in class ERXSQLHelper

limitExpressionForSQL

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

Overrides:

limitExpressionForSQL in class ERXSQLHelper

sqlForFullTextQuery

public String sqlForFullTextQuery(ERXFullTextQualifier qualifier,
                                  EOSQLExpression expression)

Description copied from class: ERXSQLHelper

Returns the SQL expression for a full text search query.

Overrides:

sqlForFullTextQuery in class ERXSQLHelper

Parameters:

qualifier - the full text qualifier

expression - the EOSQLExpression context

Returns:

a SQL expression

sqlForCreateUniqueIndex

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

Description copied from class: ERXSQLHelper

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

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

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

prepareConnectionForSchemaChange

public void prepareConnectionForSchemaChange(EOEditingContext ec,
                                             EOModel model)

Overrides:

prepareConnectionForSchemaChange in class ERXSQLHelper

restoreConnectionSettingsAfterSchemaChange

public void restoreConnectionSettingsAfterSchemaChange(EOEditingContext ec,
                                                       EOModel model)

Overrides:

restoreConnectionSettingsAfterSchemaChange in class ERXSQLHelper

commentPattern

protected Pattern commentPattern()

Returns a pattern than matches lines that start with "--".

Overrides:

commentPattern in class ERXSQLHelper

Returns:

regex pattern that indicates this line is an SQL comment