com.webobjects.jdbcadaptor
Class SybasePlugIn.SybaseExpression

java.lang.Object
  com.webobjects.eoaccess.EOSQLExpression
      com.webobjects.jdbcadaptor.JDBCExpression
          com.webobjects.jdbcadaptor.SybasePlugIn.SybaseExpression

Enclosing class:

SybasePlugIn

public static class SybasePlugIn.SybaseExpression
extends JDBCExpression

Nested Class Summary

Nested classes/interfaces 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

SybasePlugIn.SybaseExpression(EOEntity entity)

Method Summary

String	allowsNullClauseForConstraint(boolean allowsNull) Returns according to flag an adaptor specific string for use in a CREATE TABLE statement.
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.
String	lockClause() Overridden by subclasses to return the SQL string used in a SELECT statement to lock selected rows.

Methods inherited from class com.webobjects.jdbcadaptor.JDBCExpression

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

Methods inherited from class com.webobjects.eoaccess.EOSQLExpression

addBindVariableDictionary, addCreateClauseForAttribute, addInsertListAttribute, addJoinClause, addOrderByAttributeOrdering, addUpdateListAttribute, aliasesByRelationshipPath, appendItemToListString, assembleDeleteStatementWithQualifier, assembleInsertStatementWithRow, assembleJoinClause, assembleUpdateStatementWithRow, bindVariableDictionaries, entity, formatSQLString, formatStringValue, joinClauseString, 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

SybasePlugIn.SybaseExpression

public SybasePlugIn.SybaseExpression(EOEntity entity)

Method Detail

allowsNullClauseForConstraint

public String allowsNullClauseForConstraint(boolean allowsNull)

Description copied from class: EOSQLExpression

Returns according to flag an adaptor specific string for use in a CREATE TABLE statement. The returned string indicates whether a column allows null values. EOSQLExpression's implementation returns the empty string if flag is true, "NOT NULL" otherwise. A subclass should override this if its database server's semantics are different.

Overrides:

allowsNullClauseForConstraint in class JDBCExpression

Parameters:

allowsNull - boolean for whether or not columan allows NULL

Returns:

a SQL string that indicates whether a column allows null values, in the correct adaptor format

See Also:

EOSQLExpression.addCreateClauseForAttribute(EOAttribute anEOAttribute)

lockClause

public String lockClause()

Description copied from class: EOSQLExpression

Overridden by subclasses to return the SQL string used in a SELECT statement to lock selected rows. A concrete subclass of EOSQLExpression must override this method to return the string used by its adaptor's RDBMS.

Overrides:

lockClause in class JDBCExpression

Returns:

SQL string used in a SELECT statement to lock selected rows

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)