• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: restricting qualifiers and join entities
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: restricting qualifiers and join entities


  • Subject: Re: restricting qualifiers and join entities
  • From: Lachlan Deck <email@hidden>
  • Date: Wed, 4 Jun 2008 14:44:24 +1000

On 04/06/2008, at 1:19 PM, Lachlan Deck wrote:

On 04/06/2008, at 12:58 PM, Chuck Hill wrote:

On Jun 3, 2008, at 7:26 PM, Lachlan Deck wrote:

Hi there,

Say I have entities Foo and Bar (both of which have an attribute isDeleted) and a join FooBar and I create restricting qualifiers for Foo and Bar of (isDeleted IS NULL OR isDeleted = 0).

Foo.fooBars() still fetches all fooBars even if pointing to a Bar that cannot be instantiated due to the restricting qualifier.

So my question is: should EOF filter such joins automatically (i.e., should I file a bug) or is it just up to me to auto-apply these restricting qualifiers?

I would expect that to work for fetches. In the past I have had a relationship to a subclass in a single table inheritance hierarchy, and I recall that only the correct instances were fetched.

Yeah, and I just checked again and I already have code that automatically creates a restricting qualifier for joins by migrating the restricting qualifiers from the related entities. So I end up with:


9837 INFO [main] (er.extensions.ERXNSLogLog4jBridge, appendln, 38) -
willLoadEntity added restricting qualifier to:FooBar of ((foo.isDeleted <> (java.lang.Boolean)'true') and (bar.isDeleted <> (java.lang.Boolean)'true'))

But if you're right, and EOF already uses this in its qualifier then I probably don't need to be doing that.


But maybe the problem is that of null results for these related entities where the qualifier applies.

I can't see why this should not work, I'd file a bug.

ok.

Have you checked the SQL and verified that they restricting qualifier is not getting generated?

Will have to check again. Thanks.

See logs below. The FooBar restricting qualifier is not being applied properly it seems.


Any ideas Pierre?

----------------------------------------
As an aside, Chuck, this should also answer your question re VI fetches (Subject Re: Inheritance)


On 08/05/2008, at 6:27 AM, Chuck Hill wrote:

On May 7, 2008, at 1:14 PM, Robert Walker wrote:

The only time vertical inheritance makes sense if when you always fetch against leaf nodes of the inheritance tree and only if the inheritance tree is very shallow. Take that to mean one level deep of inheritance with an abstract root entity that you never fetch against.

Anything more complex than that I would recommend single-table.

My 2 cents.

Vertical or horizontal? With vertical this will still select on the root, won't it?

----------------------------------------

with regards,
--

Lachlan Deck

<<<
35238 DEBUG [WorkerThread15] (er.extensions.ERXNSLogLog4jBridge, appendln, 44) -
evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn $MySQLExpression: "SELECT blah blah FROM FooBar t0, Taggable T2, Foo T1 WHERE ((T2.isDeleted <> ? AND T2.isDeleted <> ?) AND t0.fooId = ?) AND T1.id = T2.id AND t0.fooId = T1.id ORDER BY whatever" withBindings: 1:true(isDeleted), 2:true(isDeleted), 3:145310(fooId)>


35242 DEBUG [WorkerThread15] (er.extensions.ERXNSLogLog4jBridge, appendln, 44) -
1 row(s) processed
>>>


<<<
35287 DEBUG [WorkerThread15] (er.extensions.ERXNSLogLog4jBridge, appendln, 44) -
evaluateExpression: <com.webobjects.jdbcadaptor.MySQLPlugIn $MySQLExpression: "SELECT T1.x, T0.y, blah etc FROM Bar t0, Taggable T1 WHERE ((T1.entityType = ? AND T1.isDeleted <> ?) AND t0.id = ?) AND t0.id = T1.id ORDER BY whatever" withBindings: 1:"Bar"(entityType), 2:true(isDeleted), 3:4818(id)>


35292 DEBUG [WorkerThread15] (er.extensions.ERXNSLogLog4jBridge, appendln, 44) -
0 row(s) processed
>>>


35325 ERROR [WorkerThread15] (willow.view.DynamicDirectAction, directActionName, 248) -
Failed to obtain key baz available for object:{values = {... lots of NSKeyValueCoding$Null values as not yet faulted...}; this = "<willow.model.Bar 12f9924 _EOIntegralKeyGlobalID[Bar (java.lang.Long)4818]>"; }


er.extensions.ERXDatabaseContextDelegate$ObjectNotAvailableException: No willow.model.Bar found with globalID: <Bar: [id: '4818'] >
at er .extensions .ERXDatabaseContextDelegate .databaseContextFailedToFetchObject(ERXDatabaseContextDelegate.java:234)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun .reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java: 39)
at sun .reflect .DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java: 25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.webobjects.foundation.NSSelector._safeInvokeMethod(NSSelector.java: 120)
at com.webobjects.foundation._NSDelegate._perform(_NSDelegate.java:225)
at com.webobjects.foundation._NSDelegate.perform(_NSDelegate.java:170)
at com .webobjects .eoaccess.EODatabaseContext._fireFault(EODatabaseContext.java:4384)
at com .webobjects .eoaccess .EOAccessFaultHandler .completeInitializationOfObject(EOAccessFaultHandler.java:85)
at com.webobjects.eocontrol.EOCustomObject.willRead(EOCustomObject.java: 1189)
at com.webobjects.eocontrol._EOMutableKnownKeyDictionary$Initializer $_GenericRecordBinding.valueInObject(_EOMutableKnownKeyDictionary.java: 519)
at com .webobjects .eocontrol.EOCustomObject.storedValueForKey(EOCustomObject.java:1736)
at com.ish.willow.eoaccess.model._Taggable.angelId(_Taggable.java:104)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun .reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java: 39)
at sun .reflect .DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java: 25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.webobjects.foundation.NSKeyValueCoding$ValueAccessor $1.methodValue(NSKeyValueCoding.java:684)
at com.webobjects.foundation.NSKeyValueCoding $_MethodBinding.valueInObject(NSKeyValueCoding.java:1160)
at com .webobjects.eocontrol.EOCustomObject.valueForKey(EOCustomObject.java: 1559)
<...>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden
  • Follow-Ups:
    • Re: restricting qualifiers and join entities
      • From: Chuck Hill <email@hidden>
References: 
 >restricting qualifiers and join entities (From: Lachlan Deck <email@hidden>)
 >Re: restricting qualifiers and join entities (From: Chuck Hill <email@hidden>)
 >Re: restricting qualifiers and join entities (From: Lachlan Deck <email@hidden>)

  • Prev by Date: Re: restricting qualifiers and join entities
  • Next by Date: Re: Parameterized NSArray in 5.3.3
  • Previous by thread: Re: restricting qualifiers and join entities
  • Next by thread: Re: restricting qualifiers and join entities
  • Index(es):
    • Date
    • Thread