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 JDBCExpression

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static 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

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
FrontbaseExpression(EOEntity eoentity)

Method Summary

Modifier and Type	Method and Description
Class	_synchronizationFactoryClass()
void	addCreateClauseForAttribute(EOAttribute attribute)
String	addEscapeChars(String value)
void	addJoinClause(String leftName, String rightName, int semantic) Overridden to not call the super implementation.
void	addOrderByAttributeOrdering(EOSortOrdering eosortordering)
String	assembleDeleteStatementWithQualifier(EOQualifier eoqualifier, String table, String qualifier)
String	assembleInsertStatementWithRow(NSDictionary row, String table, String columns, String values)
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.
String	assembleUpdateStatementWithRow(NSDictionary row, EOQualifier qualifier, String table, String values, String sqlQualifier)
String	columnTypeStringForAttribute(EOAttribute attribute)
String	escapedString(Object obj)
String	externalNameQuoteCharacter()
String	formatValueForAttribute(Object obj, EOAttribute eoattribute)
String	joinClauseString() Overrides the parent implementation to compose the final string expression for the join clauses.
String	lockClause()
boolean	mustUseBindVariableForAttribute(EOAttribute eoattribute)
protected boolean	shouldAllowNull(EOAttribute attribute)
boolean	shouldUseBindVariableForAttribute(EOAttribute eoattribute)
String	sqlStringForAttribute(EOAttribute attribute)
String	sqlStringForCaseInsensitiveLike(String value, String column)
String	sqlStringForKeyValueQualifier(EOKeyValueQualifier eokeyvaluequalifier)
String	sqlStringForSelector(NSSelector selector, Object value)
protected String	sqlStringForSelectorTreatingContainsAsLike(NSSelector qualifierOperator, 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

FrontbaseExpression

public FrontbaseExpression(EOEntity eoentity)

Method Detail

addCreateClauseForAttribute

public void addCreateClauseForAttribute(EOAttribute attribute)

Overrides:

addCreateClauseForAttribute in class EOSQLExpression

shouldAllowNull

protected boolean shouldAllowNull(EOAttribute attribute)

columnTypeStringForAttribute

public String columnTypeStringForAttribute(EOAttribute attribute)

Overrides:

columnTypeStringForAttribute in class JDBCExpression

_synchronizationFactoryClass

public Class _synchronizationFactoryClass()

sqlStringForSelector

public String sqlStringForSelector(NSSelector selector,
                                   Object value)

Overrides:

sqlStringForSelector in class EOSQLExpression

sqlStringForSelectorTreatingContainsAsLike

protected String sqlStringForSelectorTreatingContainsAsLike(NSSelector qualifierOperator,
                                                            Object value)

externalNameQuoteCharacter

public String externalNameQuoteCharacter()

Overrides:

externalNameQuoteCharacter in class JDBCExpression

sqlStringForAttribute

public String sqlStringForAttribute(EOAttribute attribute)

Overrides:

sqlStringForAttribute 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

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

addOrderByAttributeOrdering

public void addOrderByAttributeOrdering(EOSortOrdering eosortordering)

Overrides:

addOrderByAttributeOrdering in class EOSQLExpression

assembleDeleteStatementWithQualifier

public String assembleDeleteStatementWithQualifier(EOQualifier eoqualifier,
                                                   String table,
                                                   String qualifier)

Overrides:

assembleDeleteStatementWithQualifier in class EOSQLExpression

assembleInsertStatementWithRow

public String assembleInsertStatementWithRow(NSDictionary row,
                                             String table,
                                             String columns,
                                             String values)

Overrides:

assembleInsertStatementWithRow in class EOSQLExpression

assembleUpdateStatementWithRow

public String assembleUpdateStatementWithRow(NSDictionary row,
                                             EOQualifier qualifier,
                                             String table,
                                             String values,
                                             String sqlQualifier)

Overrides:

assembleUpdateStatementWithRow in class EOSQLExpression

lockClause

public String lockClause()

Overrides:

lockClause in class JDBCExpression

useBindVariables

public boolean useBindVariables()

Overrides:

useBindVariables in class JDBCExpression

shouldUseBindVariableForAttribute

public boolean shouldUseBindVariableForAttribute(EOAttribute eoattribute)

Overrides:

shouldUseBindVariableForAttribute in class JDBCExpression

mustUseBindVariableForAttribute

public boolean mustUseBindVariableForAttribute(EOAttribute eoattribute)

Overrides:

mustUseBindVariableForAttribute in class JDBCExpression

sqlStringForCaseInsensitiveLike

public String sqlStringForCaseInsensitiveLike(String value,
                                              String column)

Overrides:

sqlStringForCaseInsensitiveLike in class EOSQLExpression

sqlStringForKeyValueQualifier

public String sqlStringForKeyValueQualifier(EOKeyValueQualifier eokeyvaluequalifier)

Overrides:

sqlStringForKeyValueQualifier in class EOSQLExpression

formatValueForAttribute

public String formatValueForAttribute(Object obj,
                                      EOAttribute eoattribute)

Overrides:

formatValueForAttribute in class JDBCExpression

escapedString

public String escapedString(Object obj)

addEscapeChars

public String addEscapeChars(String value)