com.webobjects.jdbcadaptor

Class _H2PlugIn.H2Expression

java.lang.Object

com.webobjects.eoaccess.EOSQLExpression

com.webobjects.jdbcadaptor.JDBCExpression

com.webobjects.jdbcadaptor._H2PlugIn.H2Expression

Enclosing class:

_H2PlugIn

public static class _H2PlugIn.H2Expression
extends JDBCExpression

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	_H2PlugIn.H2Expression.JoinClause Helper class that stores a join definition and helps H2Expression to assemble the correct join clause.

Nested classes/interfaces inherited from class com.webobjects.eoaccess.EOSQLExpression

EOSQLExpression.SQLValue

Field Summary

Fields inherited from class com.webobjects.jdbcadaptor.JDBCExpression

_externalQuoteChar, _inSelect, _jdbcInfo, _rtrimFunctionName

Fields inherited from class com.webobjects.eoaccess.EOSQLExpression

_aliasesByRelationshipPath, _bindings, _contextStack, _defaultDateFormatter, _entity, _joinClauseString, _listString, _NibbleToHex, _orderByString, _statement, _upperFunctionName, _useAliases, _valueListString, _whereClauseString, BindVariableAttributeKey, BindVariableColumnKey, BindVariableNameKey, BindVariablePlaceHolderKey, BindVariableValueKey

Constructor Summary

Constructors

Constructor and Description
H2Expression(EOEntity entity)

Method Summary

Modifier and Type	Method and Description
void	addCreateClauseForAttribute(EOAttribute attribute)
void	addJoinClause(String leftName, String rightName, int semantic) Overridden to not call the super implementation.
String	assembleJoinClause(String leftName, String rightName, int semantic) Overridden to construct a valid SQL92 JOIN clause as opposed to the Oracle-like SQL the superclass produces.
String	assembleSelectStatementWithAttributes(NSArray attributes, boolean lock, EOQualifier qualifier, NSArray fetchOrder, String selectString, String columnList, String tableList, String whereClause, String joinClause, String orderByClause, String lockClause) Overridden to handle correct placements of join conditions and to handle DISTINCT fetches with compareCaseInsensitiveA(De)scending sort orders.
protected boolean	enableBooleanQuoting()
String	formatValueForAttribute(Object value, EOAttribute eoattribute)
String	joinClauseString() Overrides the parent implementation to compose the final string expression for the join clauses.
void	prepareSelectExpressionWithAttributes(NSArray<EOAttribute> attributes, boolean lock, EOFetchSpecification fetchSpec) Overridden so we can get the fetch limit from the fetchSpec.

Methods inherited from class com.webobjects.jdbcadaptor.JDBCExpression

addSelectListAttribute, allowsNullClauseForConstraint, appendItemToListString, appendItemToOrderByString, appendItemToValueListString, bindVariableDictionaryForAttribute, columnTypeStringForAttribute, externalNameQuoteCharacter, jdbcInfo, lockClause, mustUseBindVariableForAttribute, setJDBCInfo, shouldUseBindVariableForAttribute, useBindVariables

Methods inherited from class com.webobjects.eoaccess.EOSQLExpression

_aliasForRelatedAttributeRelationshipPath, _aliasForRelationshipPath, _defaultDateFormatter, _entityForRelationshipPathOrigin, _flattenRelPathEntity, _listString, _orderByString, _rootEntityForExpression, _setEntity, _sqlStringForJoinSemanticMatchSemantic, _stringForDate, _truncatedString, _truncatedStringForData, _valueList, addBindVariableDictionary, addInsertListAttribute, addOrderByAttributeOrdering, addUpdateListAttribute, aliasesByRelationshipPath, appendItemToListString, assembleDeleteStatementWithQualifier, assembleInsertStatementWithRow, assembleUpdateStatementWithRow, bindVariableDictionaries, entity, formatSQLString, formatStringValue, joinExpression, listString, orderByString, prepareConstraintStatementForRelationship, prepareDeleteExpressionForQualifier, prepareInsertExpressionWithRow, prepareUpdateExpressionWithRow, setStatement, setUseAliases, setUseBindVariables, setUseQuotedExternalNames, sqlEscapeChar, sqlPatternFromShellPattern, sqlPatternFromShellPatternWithEscapeCharacter, sqlStringForAttribute, sqlStringForAttributeNamed, sqlStringForAttributePath, sqlStringForCaseInsensitiveLike, sqlStringForConjoinedQualifiers, sqlStringForData, sqlStringForDisjoinedQualifiers, sqlStringForKeyComparisonQualifier, sqlStringForKeyValueQualifier, sqlStringForNegatedQualifier, sqlStringForNumber, sqlStringForQualifier, sqlStringForSchemaObjectName, sqlStringForSelector, sqlStringForString, sqlStringForValue, statement, tableListWithRootEntity, toString, useAliases, useQuotedExternalNames, valueList, whereClauseString

Methods inherited from class java.lang.Object

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

Constructor Detail

H2Expression

public H2Expression(EOEntity entity)

Method Detail

addCreateClauseForAttribute

public void addCreateClauseForAttribute(EOAttribute attribute)

Overrides:

addCreateClauseForAttribute in class EOSQLExpression

enableBooleanQuoting

protected boolean enableBooleanQuoting()

formatValueForAttribute

public String formatValueForAttribute(Object value,
                                      EOAttribute eoattribute)

Overrides:

formatValueForAttribute in class JDBCExpression

prepareSelectExpressionWithAttributes

public void prepareSelectExpressionWithAttributes(NSArray<EOAttribute> attributes,
                                                  boolean lock,
                                                  EOFetchSpecification fetchSpec)

Overridden so we can get the fetch limit from the fetchSpec.

Overrides:

prepareSelectExpressionWithAttributes in class JDBCExpression

Parameters:

attributes - the array of attributes

lock - locking flag

fetchSpec - the fetch specification

assembleSelectStatementWithAttributes

public String assembleSelectStatementWithAttributes(NSArray attributes,
                                                    boolean lock,
                                                    EOQualifier qualifier,
                                                    NSArray fetchOrder,
                                                    String selectString,
                                                    String columnList,
                                                    String tableList,
                                                    String whereClause,
                                                    String joinClause,
                                                    String orderByClause,
                                                    String lockClause)

Overridden to handle correct placements of join conditions and to handle DISTINCT fetches with compareCaseInsensitiveA(De)scending sort orders.

Overrides:

assembleSelectStatementWithAttributes in class EOSQLExpression

Parameters:

attributes - the attributes to select

lock - flag for locking rows in the database

qualifier - the qualifier to restrict the selection

fetchOrder - specifies the fetch order

columnList - the SQL columns to be fetched

tableList - the the SQL tables to be fetched

whereClause - the SQL where clause

joinClause - the SQL join clause

orderByClause - the SQL sort order clause

lockClause - the SQL lock clause

Returns:

the select statement

joinClauseString

public String joinClauseString()

Overrides the parent implementation to compose the final string expression for the join clauses.

Overrides:

joinClauseString in class EOSQLExpression

addJoinClause

public void addJoinClause(String leftName,
                          String rightName,
                          int semantic)

Overridden to not call the super implementation.

Overrides:

addJoinClause in class EOSQLExpression

Parameters:

leftName - the table name on the left side of the clause

rightName - the table name on the right side of the clause

semantic - the join semantic

assembleJoinClause

public String assembleJoinClause(String leftName,
                                 String rightName,
                                 int semantic)

Overridden to construct a valid SQL92 JOIN clause as opposed to the Oracle-like SQL the superclass produces.

Overrides:

assembleJoinClause in class EOSQLExpression

Parameters:

leftName - the table name on the left side of the clause

rightName - the table name on the right side of the clause

semantic - the join semantic

Returns:

the join clause