com.webobjects.jdbcadaptor
Class _FrontBasePlugIn.FrontbaseExpression

java.lang.Object
  com.webobjects.eoaccess.EOSQLExpression
      com.webobjects.jdbcadaptor.JDBCExpression
          com.webobjects.jdbcadaptor._FrontBasePlugIn.FrontbaseExpression

Enclosing class:

_FrontBasePlugIn

public static class _FrontBasePlugIn.FrontbaseExpression
extends com.webobjects.jdbcadaptor.JDBCExpression

Nested Class Summary

class

_FrontBasePlugIn.FrontbaseExpression.JoinClause Helper class that stores a join definition and helps FrontbaseExpression to assemble the correct join clause.

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

com.webobjects.eoaccess.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

_FrontBasePlugIn.FrontbaseExpression(com.webobjects.eoaccess.EOEntity eoentity)

Method Summary

java.lang.Class	_synchronizationFactoryClass()
void	addCreateClauseForAttribute(com.webobjects.eoaccess.EOAttribute attribute)
java.lang.String	addEscapeChars(java.lang.String value)
void	addJoinClause(java.lang.String leftName, java.lang.String rightName, int semantic) Overridden to not call the super implementation.
void	addOrderByAttributeOrdering(com.webobjects.eocontrol.EOSortOrdering eosortordering)
java.lang.String	assembleDeleteStatementWithQualifier(com.webobjects.eocontrol.EOQualifier eoqualifier, java.lang.String table, java.lang.String qualifier)
java.lang.String	assembleInsertStatementWithRow(com.webobjects.foundation.NSDictionary nsdictionary, java.lang.String table, java.lang.String columns, java.lang.String values)
java.lang.String	assembleJoinClause(java.lang.String leftName, java.lang.String rightName, int semantic) Overridden to construct a valid SQL92 JOIN clause as opposed to the Oracle-like SQL the superclass produces.
java.lang.String	assembleSelectStatementWithAttributes(com.webobjects.foundation.NSArray attributes, boolean lock, com.webobjects.eocontrol.EOQualifier qualifier, com.webobjects.foundation.NSArray fetchOrder, java.lang.String selectString, java.lang.String columnList, java.lang.String tableList, java.lang.String whereClause, java.lang.String joinClause, java.lang.String orderByClause, java.lang.String lockClause) Overridden to handle correct placements of join conditions and to handle DISTINCT fetches with compareCaseInsensitiveA(De)scending sort orders.
java.lang.String	assembleUpdateStatementWithRow(com.webobjects.foundation.NSDictionary dictionary, com.webobjects.eocontrol.EOQualifier qualifier, java.lang.String table, java.lang.String values, java.lang.String sqlQualifier)
java.lang.String	columnTypeStringForAttribute(com.webobjects.eoaccess.EOAttribute attribute)
java.lang.String	escapedString(java.lang.Object obj)
java.lang.String	externalNameQuoteCharacter()
java.lang.String	formatValueForAttribute(java.lang.Object obj, com.webobjects.eoaccess.EOAttribute eoattribute)
java.lang.String	joinClauseString() Overrides the parent implementation to compose the final string expression for the join clauses.
java.lang.String	lockClause()
boolean	mustUseBindVariableForAttribute(com.webobjects.eoaccess.EOAttribute eoattribute)
protected boolean	shouldAllowNull(com.webobjects.eoaccess.EOAttribute attribute)
boolean	shouldUseBindVariableForAttribute(com.webobjects.eoaccess.EOAttribute eoattribute)
java.lang.String	sqlStringForAttribute(com.webobjects.eoaccess.EOAttribute attribute)
java.lang.String	sqlStringForCaseInsensitiveLike(java.lang.String value, java.lang.String column)
java.lang.String	sqlStringForKeyValueQualifier(com.webobjects.eocontrol.EOKeyValueQualifier eokeyvaluequalifier)
java.lang.String	sqlStringForSelector(com.webobjects.foundation.NSSelector qualifierOperator, java.lang.Object value)
boolean	useBindVariables()

Methods inherited from class com.webobjects.jdbcadaptor.JDBCExpression

addSelectListAttribute, allowsNullClauseForConstraint, appendItemToListString, appendItemToOrderByString, appendItemToValueListString, bindVariableDictionaryForAttribute, jdbcInfo, prepareSelectExpressionWithAttributes, setJDBCInfo

Methods inherited from class com.webobjects.eoaccess.EOSQLExpression

_aliasForRelatedAttributeRelationshipPath, _aliasForRelationshipPath, _defaultDateFormatter, _entityForRelationshipPathOrigin, _flattenRelPathEntity, _listString, _orderByString, _rootEntityForExpression, _setEntity, _sqlStringForJoinSemanticMatchSemantic, _stringForDate, _truncatedString, _truncatedStringForData, _valueList, addBindVariableDictionary, addInsertListAttribute, addUpdateListAttribute, aliasesByRelationshipPath, appendItemToListString, bindVariableDictionaries, entity, formatSQLString, formatStringValue, joinExpression, listString, orderByString, prepareConstraintStatementForRelationship, prepareDeleteExpressionForQualifier, prepareInsertExpressionWithRow, prepareUpdateExpressionWithRow, setStatement, setUseAliases, setUseBindVariables, setUseQuotedExternalNames, sqlEscapeChar, sqlPatternFromShellPattern, sqlPatternFromShellPatternWithEscapeCharacter, sqlStringForAttributeNamed, sqlStringForAttributePath, sqlStringForConjoinedQualifiers, sqlStringForData, sqlStringForDisjoinedQualifiers, sqlStringForKeyComparisonQualifier, sqlStringForNegatedQualifier, sqlStringForNumber, sqlStringForQualifier, sqlStringForSchemaObjectName, 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

_FrontBasePlugIn.FrontbaseExpression

public _FrontBasePlugIn.FrontbaseExpression(com.webobjects.eoaccess.EOEntity eoentity)

Method Detail

addCreateClauseForAttribute

public void addCreateClauseForAttribute(com.webobjects.eoaccess.EOAttribute attribute)

Overrides:

addCreateClauseForAttribute in class com.webobjects.eoaccess.EOSQLExpression

shouldAllowNull

protected boolean shouldAllowNull(com.webobjects.eoaccess.EOAttribute attribute)

columnTypeStringForAttribute

public java.lang.String columnTypeStringForAttribute(com.webobjects.eoaccess.EOAttribute attribute)

Overrides:

columnTypeStringForAttribute in class com.webobjects.jdbcadaptor.JDBCExpression

_synchronizationFactoryClass

public java.lang.Class _synchronizationFactoryClass()

sqlStringForSelector

public java.lang.String sqlStringForSelector(com.webobjects.foundation.NSSelector qualifierOperator,
                                             java.lang.Object value)

Overrides:

sqlStringForSelector in class com.webobjects.eoaccess.EOSQLExpression

externalNameQuoteCharacter

public java.lang.String externalNameQuoteCharacter()

Overrides:

externalNameQuoteCharacter in class com.webobjects.jdbcadaptor.JDBCExpression

sqlStringForAttribute

public java.lang.String sqlStringForAttribute(com.webobjects.eoaccess.EOAttribute attribute)

Overrides:

sqlStringForAttribute in class com.webobjects.eoaccess.EOSQLExpression

addJoinClause

public void addJoinClause(java.lang.String leftName,
                          java.lang.String rightName,
                          int semantic)

Overridden to not call the super implementation.

Overrides:

addJoinClause in class com.webobjects.eoaccess.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 java.lang.String assembleJoinClause(java.lang.String leftName,
                                           java.lang.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 com.webobjects.eoaccess.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

assembleSelectStatementWithAttributes

public java.lang.String assembleSelectStatementWithAttributes(com.webobjects.foundation.NSArray attributes,
                                                              boolean lock,
                                                              com.webobjects.eocontrol.EOQualifier qualifier,
                                                              com.webobjects.foundation.NSArray fetchOrder,
                                                              java.lang.String selectString,
                                                              java.lang.String columnList,
                                                              java.lang.String tableList,
                                                              java.lang.String whereClause,
                                                              java.lang.String joinClause,
                                                              java.lang.String orderByClause,
                                                              java.lang.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 com.webobjects.eoaccess.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 java.lang.String joinClauseString()

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

Overrides:

joinClauseString in class com.webobjects.eoaccess.EOSQLExpression

addOrderByAttributeOrdering

public void addOrderByAttributeOrdering(com.webobjects.eocontrol.EOSortOrdering eosortordering)

Overrides:

addOrderByAttributeOrdering in class com.webobjects.eoaccess.EOSQLExpression

assembleDeleteStatementWithQualifier

public java.lang.String assembleDeleteStatementWithQualifier(com.webobjects.eocontrol.EOQualifier eoqualifier,
                                                             java.lang.String table,
                                                             java.lang.String qualifier)

Overrides:

assembleDeleteStatementWithQualifier in class com.webobjects.eoaccess.EOSQLExpression

assembleInsertStatementWithRow

public java.lang.String assembleInsertStatementWithRow(com.webobjects.foundation.NSDictionary nsdictionary,
                                                       java.lang.String table,
                                                       java.lang.String columns,
                                                       java.lang.String values)

Overrides:

assembleInsertStatementWithRow in class com.webobjects.eoaccess.EOSQLExpression

assembleUpdateStatementWithRow

public java.lang.String assembleUpdateStatementWithRow(com.webobjects.foundation.NSDictionary dictionary,
                                                       com.webobjects.eocontrol.EOQualifier qualifier,
                                                       java.lang.String table,
                                                       java.lang.String values,
                                                       java.lang.String sqlQualifier)

Overrides:

assembleUpdateStatementWithRow in class com.webobjects.eoaccess.EOSQLExpression

lockClause

public java.lang.String lockClause()

Overrides:

lockClause in class com.webobjects.jdbcadaptor.JDBCExpression

useBindVariables

public boolean useBindVariables()

Overrides:

useBindVariables in class com.webobjects.jdbcadaptor.JDBCExpression

shouldUseBindVariableForAttribute

public boolean shouldUseBindVariableForAttribute(com.webobjects.eoaccess.EOAttribute eoattribute)

Overrides:

shouldUseBindVariableForAttribute in class com.webobjects.jdbcadaptor.JDBCExpression

mustUseBindVariableForAttribute

public boolean mustUseBindVariableForAttribute(com.webobjects.eoaccess.EOAttribute eoattribute)

Overrides:

mustUseBindVariableForAttribute in class com.webobjects.jdbcadaptor.JDBCExpression

sqlStringForCaseInsensitiveLike

public java.lang.String sqlStringForCaseInsensitiveLike(java.lang.String value,
                                                        java.lang.String column)

Overrides:

sqlStringForCaseInsensitiveLike in class com.webobjects.eoaccess.EOSQLExpression

sqlStringForKeyValueQualifier

public java.lang.String sqlStringForKeyValueQualifier(com.webobjects.eocontrol.EOKeyValueQualifier eokeyvaluequalifier)

Overrides:

sqlStringForKeyValueQualifier in class com.webobjects.eoaccess.EOSQLExpression

formatValueForAttribute

public java.lang.String formatValueForAttribute(java.lang.Object obj,
                                                com.webobjects.eoaccess.EOAttribute eoattribute)

Overrides:

formatValueForAttribute in class com.webobjects.jdbcadaptor.JDBCExpression

escapedString

public java.lang.String escapedString(java.lang.Object obj)

addEscapeChars

public java.lang.String addEscapeChars(java.lang.String value)