er.extensions.eof.qualifiers

Class ERXQualifierInSubquery

java.lang.Object

com.webobjects.eocontrol.EOQualifier

er.extensions.eof.qualifiers.ERXQualifierInSubquery

All Implemented Interfaces:

EOQualifierSQLGeneration, EOQualifierEvaluation, Serializable, Cloneable

public class ERXQualifierInSubquery
extends EOQualifier
implements EOQualifierSQLGeneration, Cloneable, EOQualifierEvaluation

Generates a subquery for the qualifier given in argument:

 EOQualifier q = EOQualifier.qualifierWithQualifierFormat("firstName = 'Max'", null);
 ERXQualifierInSubquery qq = new ERXQualifierInSubquery(q, "User", "group");
 EOFetchSpecification fs = new EOFetchSpecification("Group", qq, null);
 

Would generate: "SELECT t0.GROUP_ID, t0.NAME FROM USER t0 WHERE t0.GROUP_ID IN ( SELECT t0.GROUP_ID FROM GROUP t0 WHERE t0.NAME = ? ) " This class can be used to work around the EOF bug where OR queries involving many-to-manies are incorrectly generated It will also generate ... t0.FOREIGN_KEY_ID in (select t1.ID from X where [your qualifier here]) with the 3 arg constructor

See Also:

Serialized Form

Nested Class Summary

Nested classes/interfaces inherited from class com.webobjects.eocontrol.EOQualifier

EOQualifier.Comparison, EOQualifier.ComparisonSupport, EOQualifier.QualifierVariableSubstitutionException

Nested classes/interfaces inherited from interface com.webobjects.eoaccess.EOQualifierSQLGeneration

EOQualifierSQLGeneration._AndQualifierSupport, EOQualifierSQLGeneration._KeyComparisonQualifierSupport, EOQualifierSQLGeneration._KeyValueQualifierSupport, EOQualifierSQLGeneration._NotQualifierSupport, EOQualifierSQLGeneration._OrQualifierSupport, EOQualifierSQLGeneration.Support

Field Summary

Fields

Modifier and Type	Field and Description
protected String	attributeName holds the attribute name
protected String	destinationAttName holds the attribute name
protected String	entityName holds the entity name
protected EOQualifier	qualifier holds the subqualifier
protected String	relationshipName holds the relationship name

Fields inherited from class com.webobjects.eocontrol.EOQualifier

_CLASS, QualifierOperatorCaseInsensitiveLike, QualifierOperatorContains, QualifierOperatorEqual, QualifierOperatorGreaterThan, QualifierOperatorGreaterThanOrEqualTo, QualifierOperatorLessThan, QualifierOperatorLessThanOrEqualTo, QualifierOperatorLike, QualifierOperatorNotEqual

Fields inherited from interface com.webobjects.eocontrol.EOQualifierEvaluation

_CLASS

Constructor Summary

Constructors

Constructor and Description
ERXQualifierInSubquery(EOQualifier qualifier) Public single argument constructor.
ERXQualifierInSubquery(EOQualifier qualifier, String entityName, String relationshipName)
ERXQualifierInSubquery(EOQualifier qualifier, String entityName, String attributeName, String destinationAttName)

Method Summary

Modifier and Type	Method and Description
void	addQualifierKeysToSet(NSMutableSet aSet) Only used with qualifier keys which are not supported in this qualifier at this time.
Object	clone() Implementation of the Clonable interface.
boolean	evaluateWithObject(Object object)
EOQualifier	qualifierMigratedFromEntityRelationshipPath(EOEntity anEntity, String aPath) Implementation of the EOQualifierSQLGeneration interface.
EOQualifier	qualifierWithBindings(NSDictionary someBindings, boolean requiresAll) Creates another qualifier after replacing the values of the bindings.
EOQualifier	schemaBasedQualifierWithRootEntity(EOEntity anEntity) Implementation of the EOQualifierSQLGeneration interface.
String	sqlStringForSQLExpression(EOSQLExpression e) Generates the sql string for the given sql expression.
String	toString() Description of the qualifier
void	validateKeysWithRootClassDescription(EOClassDescription aClassDescription) This qualifier does not perform validation.

Methods inherited from class com.webobjects.eocontrol.EOQualifier

_accept, _isEmpty, allQualifierKeys, allQualifierOperators, bindingKeys, filterArrayWithQualifier, filteredArrayWithQualifier, keyPathForBindingKey, operatorSelectorForSelectorNamed, operatorSelectorForString, qualifierToMatchAllValues, qualifierToMatchAnyValue, qualifierWithQualifierFormat, relationalQualifierOperators, stringForOperatorSelector

Methods inherited from class java.lang.Object

equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

qualifier

protected EOQualifier qualifier

holds the subqualifier

entityName

protected String entityName

holds the entity name

relationshipName

protected String relationshipName

holds the relationship name

attributeName

protected String attributeName

holds the attribute name

destinationAttName

protected String destinationAttName

holds the attribute name

Constructor Detail

ERXQualifierInSubquery

public ERXQualifierInSubquery(EOQualifier qualifier)

Public single argument constructor. Use this constructor for sub-qualification on the same table.

Parameters:

qualifier - sub qualifier

ERXQualifierInSubquery

public ERXQualifierInSubquery(EOQualifier qualifier,
                              String entityName,
                              String relationshipName)

Parameters:

qualifier - sub qualifier

entityName - of the sub qualification

relationshipName - relationship name

ERXQualifierInSubquery

public ERXQualifierInSubquery(EOQualifier qualifier,
                              String entityName,
                              String attributeName,
                              String destinationAttName)

Parameters:

qualifier - sub qualifier

entityName - of the sub qualification

attributeName - foreign key attribute name

destinationAttName - destination key name

Method Detail

addQualifierKeysToSet

public void addQualifierKeysToSet(NSMutableSet aSet)

Only used with qualifier keys which are not supported in this qualifier at this time. Does nothing.

Specified by:

addQualifierKeysToSet in class EOQualifier

Parameters:

aSet - of qualifier keys

qualifierWithBindings

public EOQualifier qualifierWithBindings(NSDictionary someBindings,
                                         boolean requiresAll)

Creates another qualifier after replacing the values of the bindings. Since this qualifier does not support qualifier binding keys a clone of the qualifier is returned.

Specified by:

qualifierWithBindings in class EOQualifier

Parameters:

someBindings - some bindings

requiresAll - tells if the qualifier requires all bindings

Returns:

clone of the current qualifier.

validateKeysWithRootClassDescription

public void validateKeysWithRootClassDescription(EOClassDescription aClassDescription)

This qualifier does not perform validation. This is a no-op method.

Specified by:

validateKeysWithRootClassDescription in class EOQualifier

Parameters:

aClassDescription - to validation the qualifier keys against.

sqlStringForSQLExpression

public String sqlStringForSQLExpression(EOSQLExpression e)

Generates the sql string for the given sql expression. Bulk of the logic for generating the sub-query is in this method.

Specified by:

sqlStringForSQLExpression in interface EOQualifierSQLGeneration

Parameters:

e - a given sql expression

Returns:

sql string for the current sub-query.

schemaBasedQualifierWithRootEntity

public EOQualifier schemaBasedQualifierWithRootEntity(EOEntity anEntity)

Implementation of the EOQualifierSQLGeneration interface. Just clones the qualifier.

Specified by:

schemaBasedQualifierWithRootEntity in interface EOQualifierSQLGeneration

Parameters:

anEntity - an entity.

Returns:

clone of the current qualifier.

qualifierMigratedFromEntityRelationshipPath

public EOQualifier qualifierMigratedFromEntityRelationshipPath(EOEntity anEntity,
                                                               String aPath)

Implementation of the EOQualifierSQLGeneration interface. Just clones the qualifier.

Specified by:

qualifierMigratedFromEntityRelationshipPath in interface EOQualifierSQLGeneration

Parameters:

anEntity - an entity

aPath - relationship path

Returns:

clone of the current qualifier.

toString

public String toString()

Description of the qualifier

Overrides:

toString in class Object

Returns:

human readable description of the qualifier.

clone

public Object clone()

Implementation of the Clonable interface. Clones the current qualifier.

Overrides:

clone in class EOQualifier

Returns:

cloned qualifier.

evaluateWithObject

public boolean evaluateWithObject(Object object)

Specified by:

evaluateWithObject in interface EOQualifierEvaluation

Overrides:

evaluateWithObject in class EOQualifier