com.webobjects.jdbcadaptor

Class MySQLExpression

java.lang.Object

com.webobjects.eoaccess.EOSQLExpression

com.webobjects.jdbcadaptor.JDBCExpression

com.webobjects.jdbcadaptor._MySQLPlugIn.MySQLExpression

com.webobjects.jdbcadaptor.MySQLExpression

public class MySQLExpression
extends _MySQLPlugIn.MySQLExpression

Overrides the default EOF MySQLExpression to adjust the sql generation of string comparisons.

MySQL's default behaviour, as per usual, is to ignore the standards. Thus an sql like performs a case insensitive comparison rather than case sensitive which is vexing.

To enforce standard behaviour you can tell mysql by using like binary for a case sensitive comparison. Thus a case insensitive comparison simply requires using a like in order to obtain the results desired.

Note: This assumes that you're not using binary columns.

The alternative is to define all of your columns as binary columns and specifically specify the collation to use for case insensitive comparisons. But that's a more complex approach in the author's view.

Another approach is to only ever use qualifiers and sort orderings that are case sensitive (semantically) and choose in your model what external type to map to in order to control the behaviour. In my view this is bad practice because you're separating the logic of queries and returning results that are not intended according to the code.

To summarise, if this class is enabled:

• LIKE UPPER(foo) becomes LIKE foo
• LIKE foo becomes LIKE BINARY foo

Author:

ldeck

Properties

Name	Description
com.webobjects.jdbcadaptor.MySQLExpression.enable	set to true to enable this class and change the behavior of the like operator to be case-insensitive.

Nested Class Summary

Nested classes/interfaces inherited from class com.webobjects.jdbcadaptor._MySQLPlugIn.MySQLExpression

_MySQLPlugIn.MySQLExpression.JoinClauseDefinition

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

Constructors

Constructor and Description
MySQLExpression(com.webobjects.eoaccess.EOEntity entity)

Method Summary

Modifier and Type	Method and Description
void	addOrderByAttributeOrdering(com.webobjects.eocontrol.EOSortOrdering sortOrdering)
protected void	appendItemToOrderByString(String sqlString)
protected Pattern	likeOperatorRegex()
protected String	replaceStringForCaseInsensitiveLike(String string)
protected String	replaceStringForCaseSensitiveLike(String string)
String	sqlStringForCaseInsensitiveLike(String valueString, String keyString)
String	sqlStringForKeyComparisonQualifier(com.webobjects.eocontrol.EOKeyComparisonQualifier qualifier)
String	sqlStringForKeyValueQualifier(com.webobjects.eocontrol.EOKeyValueQualifier qualifier)
protected Pattern	upperFunctionNameRegex()

Methods inherited from class com.webobjects.jdbcadaptor._MySQLPlugIn.MySQLExpression

addJoinClause, assembleJoinClause, assembleSelectStatementWithAttributes, externalNameQuoteCharacter, joinClauseString, joinExpression, prepareSelectExpressionWithAttributes, sqlEscapeChar

Methods inherited from class com.webobjects.jdbcadaptor.JDBCExpression

addSelectListAttribute, allowsNullClauseForConstraint, appendItemToListString, 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, 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, sqlStringForConjoinedQualifiers, sqlStringForData, sqlStringForDisjoinedQualifiers, 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(com.webobjects.eoaccess.EOEntity entity)

Parameters:

entity -

Method Detail

addOrderByAttributeOrdering

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

Overrides:

addOrderByAttributeOrdering in class com.webobjects.eoaccess.EOSQLExpression

See Also:

EOSQLExpression.addOrderByAttributeOrdering(com.webobjects.eocontrol.EOSortOrdering)

appendItemToOrderByString

protected void appendItemToOrderByString(String sqlString)

Overrides:

appendItemToOrderByString in class com.webobjects.jdbcadaptor.JDBCExpression

See Also:

JDBCExpression.appendItemToOrderByString(java.lang.String)

likeOperatorRegex

protected Pattern likeOperatorRegex()

replaceStringForCaseInsensitiveLike

protected String replaceStringForCaseInsensitiveLike(String string)

replaceStringForCaseSensitiveLike

protected String replaceStringForCaseSensitiveLike(String string)

sqlStringForCaseInsensitiveLike

public String sqlStringForCaseInsensitiveLike(String valueString,
                                              String keyString)

Overrides:

sqlStringForCaseInsensitiveLike in class com.webobjects.eoaccess.EOSQLExpression

See Also:

EOSQLExpression.sqlStringForCaseInsensitiveLike(java.lang.String, java.lang.String)

sqlStringForKeyComparisonQualifier

public String sqlStringForKeyComparisonQualifier(com.webobjects.eocontrol.EOKeyComparisonQualifier qualifier)

Overrides:

sqlStringForKeyComparisonQualifier in class com.webobjects.eoaccess.EOSQLExpression

See Also:

EOSQLExpression.sqlStringForKeyComparisonQualifier(com.webobjects.eocontrol.EOKeyComparisonQualifier)

sqlStringForKeyValueQualifier

public String sqlStringForKeyValueQualifier(com.webobjects.eocontrol.EOKeyValueQualifier qualifier)

Overrides:

sqlStringForKeyValueQualifier in class com.webobjects.eoaccess.EOSQLExpression

See Also:

EOSQLExpression.sqlStringForKeyValueQualifier(com.webobjects.eocontrol.EOKeyValueQualifier)

upperFunctionNameRegex

protected Pattern upperFunctionNameRegex()