com.webobjects.jdbcadaptor

Class _MySQLPlugIn.MySQLExpression

java.lang.Object

com.webobjects.eoaccess.EOSQLExpression

com.webobjects.jdbcadaptor.JDBCExpression

com.webobjects.jdbcadaptor._MySQLPlugIn.MySQLExpression

Direct Known Subclasses:

MySQLExpression

Enclosing class:

_MySQLPlugIn

public static class _MySQLPlugIn.MySQLExpression
extends JDBCExpression

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	_MySQLPlugIn.MySQLExpression.JoinClauseDefinition Helper class that stores a join definition and helps MySQLExpression 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
MySQLExpression(EOEntity entity)

Method Summary

Modifier and Type	Method and Description
void	addJoinClause(String leftName, String rightName, int semantic) Overriden to not call the super implementation.
String	assembleJoinClause(String leftName, String rightName, int semantic) This is called by super for each join.
String	assembleSelectStatementWithAttributes(NSArray attributes, boolean lock, EOQualifier qualifier, NSArray fetchOrder, String selectString, String columnList, String tableList, String whereClause, String joinClause, String orderByClause, String lockClause) Overriding to add LIMIT clause if _fetchLimit > 0 support MySQL JOIN syntax (similar syntax to what PostgreSQL PlugIn generates)
String	externalNameQuoteCharacter() Overridden because MySQL does not use the default quote character in EOSQLExpression.externalNameQuoteCharacter() which is an empty string.
String	joinClauseString() Overriden to contruct a valid SQL92 JOIN clause as opposed to the Oracle-like SQL the superclass produces.
void	joinExpression() Override so that the joinClause can be constructed after super has iterated though all joins and called our assembleJoinClause to create our array of JoinClauseDefinitions.
void	prepareSelectExpressionWithAttributes(NSArray<EOAttribute> attributes, boolean lock, EOFetchSpecification fetchSpec) Overriding super here so we can grab a fetch range or fetch limit if specified in the EOFetchSpecification.
char	sqlEscapeChar() http://dev.mysql.com/doc/refman/5.5/en/string-comparison-functions.html

Methods inherited from class com.webobjects.jdbcadaptor.JDBCExpression

addSelectListAttribute, allowsNullClauseForConstraint, appendItemToListString, appendItemToOrderByString, appendItemToValueListString, bindVariableDictionaryForAttribute, columnTypeStringForAttribute, formatValueForAttribute, 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, addCreateClauseForAttribute, addInsertListAttribute, addOrderByAttributeOrdering, addUpdateListAttribute, aliasesByRelationshipPath, appendItemToListString, assembleDeleteStatementWithQualifier, assembleInsertStatementWithRow, assembleUpdateStatementWithRow, bindVariableDictionaries, entity, formatSQLString, formatStringValue, 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

MySQLExpression

public MySQLExpression(EOEntity entity)

Method Detail

sqlEscapeChar

public char sqlEscapeChar()

http://dev.mysql.com/doc/refman/5.5/en/string-comparison-functions.html

Overrides:

sqlEscapeChar in class EOSQLExpression

See Also:

EOSQLExpression.sqlEscapeChar()

externalNameQuoteCharacter

public String externalNameQuoteCharacter()

Overridden because MySQL does not use the default quote character in EOSQLExpression.externalNameQuoteCharacter() which is an empty string. Note that quoting is disabled by default and can be enabled by setting property com.webobjects.jdbcadaptor.MySQLExpression.enableIdentifierQuoting to true.

Overrides:

externalNameQuoteCharacter in class JDBCExpression

prepareSelectExpressionWithAttributes

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

Overriding super here so we can grab a fetch range or fetch limit if specified in the EOFetchSpecification. If a fetchRange method returning an NSRange exists in the EOFetchSpecification subclass being passed in, the the fetchLimit will be ignored.

Overrides:

prepareSelectExpressionWithAttributes in class JDBCExpression

See Also:

JDBCExpression.prepareSelectExpressionWithAttributes(NSArray, boolean, EOFetchSpecification)

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)

Overriding to

• add LIMIT clause if _fetchLimit > 0
• support MySQL JOIN syntax (similar syntax to what PostgreSQL PlugIn generates)

Overrides:

assembleSelectStatementWithAttributes in class EOSQLExpression

See Also:

EOSQLExpression.assembleSelectStatementWithAttributes(NSArray, boolean, EOQualifier, NSArray, java.lang.String, String, String, String, String, String, String)

joinClauseString

public String joinClauseString()

Overriden to contruct a valid SQL92 JOIN clause as opposed to the Oracle-like SQL the superclass produces. kieran copied from PostgresqlExpression

Overrides:

joinClauseString in class EOSQLExpression

joinExpression

public void joinExpression()

Override so that the joinClause can be constructed after super has iterated though all joins and called our assembleJoinClause to create our array of JoinClauseDefinitions.

Overrides:

joinExpression in class EOSQLExpression

See Also:

EOSQLExpression.joinExpression()

assembleJoinClause

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

This is called by super for each join. We do not actually construct the join clause as we get called since for SQL92 JOIN syntax we need to know about all joins before we construct the complete join clause. The objective of this implementation is to insert a new unique _MySQLPlugIn.MySQLExpression.JoinClauseDefinition into the _alreadyJoined array of _MySQLPlugIn.MySQLExpression.JoinClauseDefinition objects. The join clause itself is assembled by joinClauseString().

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 kieran based this on logic from PostgresqlExpression

addJoinClause

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

Overriden to not call the super implementation. This simply calls our custom assembleJoinClause

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 kieran copied from PostgresqlExpression