com.webobjects.jdbcadaptor
Class OpenBasePlugIn.OpenBaseExpression

java.lang.Object
  |
  +--com.webobjects.eoaccess.EOSQLExpression
        |
        +--com.webobjects.jdbcadaptor.JDBCExpression
              |
              +--com.webobjects.jdbcadaptor.OpenBasePlugIn.OpenBaseExpression

Enclosing class:

OpenBasePlugIn

public static class OpenBasePlugIn.OpenBaseExpression

extends JDBCExpression

Nested Class Summary

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

EOSQLExpression.SQLValue

Field Summary

Fields inherited from class com.webobjects.eoaccess.EOSQLExpression

BindVariableAttributeKey, BindVariableColumnKey, BindVariableNameKey, BindVariablePlaceHolderKey, BindVariableValueKey

Constructor Summary

OpenBasePlugIn.OpenBaseExpression(EOEntity entity)

Method Summary

String	assembleJoinClause(String leftName, String rightName, int semantic) This method is invoked from addJoinClause to return a JOIN clause.
String	assembleSelectStatementWithAttributes(NSArray attributes, boolean lock, EOQualifier qualifier, NSArray fetchOrder, String selectString, String columnList, String tableList, String whereClause, String joinClause, String orderByClause, String lockClause) This method is invoked from prepareSelectExpressionWithAttributes to return an SQL SELECT statement.
char	sqlEscapeChar() Returns the char used for the ESCAPE clause in an SQL LIKE expression.

Methods inherited from class com.webobjects.jdbcadaptor.JDBCExpression

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

Methods inherited from class com.webobjects.eoaccess.EOSQLExpression

addBindVariableDictionary, addCreateClauseForAttribute, addInsertListAttribute, addJoinClause, addOrderByAttributeOrdering, addUpdateListAttribute, aliasesByRelationshipPath, appendItemToListString, assembleDeleteStatementWithQualifier, assembleInsertStatementWithRow, assembleUpdateStatementWithRow, bindVariableDictionaries, entity, formatSQLString, formatStringValue, joinClauseString, joinExpression, listString, orderByString, prepareConstraintStatementForRelationship, prepareDeleteExpressionForQualifier, prepareInsertExpressionWithRow, prepareUpdateExpressionWithRow, setStatement, setUseAliases, setUseBindVariables, setUseQuotedExternalNames, 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

OpenBasePlugIn.OpenBaseExpression

public OpenBasePlugIn.OpenBaseExpression(EOEntity entity)

Method Detail

assembleJoinClause

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

Description copied from class: EOSQLExpression

This method is invoked from addJoinClause to return a JOIN clause. The clause is of the form:

 leftName operator rightName
 

where operator is "=" for an inner join, "*=" for a left-outer join, and "=*" for a right-outer join.

Overrides:

assembleJoinClause in class EOSQLExpression

Parameters:

leftName - specifies leftname

rightName - specifies rightname

semantic - specifies semantic

Returns:

a constructed JOIN clause

See Also:

EOSQLExpression.addJoinClause(String aString, String aString, int anInt)

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)

Description copied from class: EOSQLExpression

This method is invoked from prepareSelectExpressionWithAttributes to return an SQL SELECT statement. The statment is of the form:

 SELECT columnList
 FROM tableList lockClause
 WHERE whereClause AND joinClause
 ORDER BY orderByClause
 

If lockClause is null, it is omitted from the statement. Similarly, if orderByClause is null, the "ORDER BY orderByClause" is omitted. If either whereClause or joinClause is null, the "AND" and null-valued argument are omitted. If both are null, the entire WHERE clause is omitted. attributes, lock, qualifer, fetchOrder arguments to prepareSelectExpressionWithAttributes from which the other assembleSelect... arguments were derived. They are provided for subclasses that need to generate the clauses of the SELECT statement in a particular way.

Overrides:

assembleSelectStatementWithAttributes in class EOSQLExpression

Parameters:

attributes - an NSArray of attributes

lock - flag for locking rows in database

qualifier - an EOQualifier for selecting rows

fetchOrder - specifies fetch order

selectString - SQL SELECT keyword, possibly with DISTINCT

columnList - SQL column list

tableList - SQL table list

whereClause - SQL WHERE clause

joinClause - specifies join condition to add to WHERE clause

orderByClause - SQL ORDER BY clause

lockClause - specifies clause for lock

Returns:

a constructed SELECT statement

See Also:

EOSQLExpression.prepareSelectExpressionWithAttributes(NSArray attributes, boolean lock, EOFetchSpecification fetchSpec)

sqlEscapeChar

public char sqlEscapeChar()

Description copied from class: EOSQLExpression

Returns the char used for the ESCAPE clause in an SQL LIKE expression. The default is backslash '\\'. A subclass should return (char)0 if the database doesn't support LIKE...ESCAPE...

Overrides:

sqlEscapeChar in class EOSQLExpression

Returns:

the ESCAPE char for a LIKE expression