sqlobject-discuss

[SQLObject] Forcing cache refresh of MultipleJoins

[Edmund L. <el...@in...>]

I have a one-to-many relationship of the form:

class A(SQLObject):
    ...
    things = MultipleJoin("B")

class B(SQLObject):
    ...
    aThing = ForeignKey("A")


If I check what things are in A via something like aObj.things, then 
delete one of the B objects that appears in the list directly via 
bObj.destroySelf(), executing the aObj.things again raises a
SQLObjectNotFound error for the just deleted B instance.

Executing aObj.things a second time works though. So there appears to be 
some kind of cache synchronization issue at play here. Is there some way 
to force an object to refresh it's cached values?

...Edmund.

Re: [SQLObject] Forcing cache refresh of MultipleJoins

[Ian B. <ia...@co...>]

On Sun, 2003-07-27 at 20:41, Edmund Lian wrote:
> I have a one-to-many relationship of the form:
> 
> class A(SQLObject):
>     ...
>     things = MultipleJoin("B")
> 
> class B(SQLObject):
>     ...
>     aThing = ForeignKey("A")
> 
> 
> If I check what things are in A via something like aObj.things, then 
> delete one of the B objects that appears in the list directly via 
> bObj.destroySelf(), executing the aObj.things again raises a
> SQLObjectNotFound error for the just deleted B instance.
> 
> Executing aObj.things a second time works though. So there appears to be 
> some kind of cache synchronization issue at play here. Is there some way 
> to force an object to refresh it's cached values?

Hmmm... I have a unit test that I think should cover this particular
case (JoinTest2.test), so I suspect I won't be able to reproduce the
problem.  Are there transactions or threads involved?

  Ian

Re: [SQLObject] Forcing cache refresh of MultipleJoins

[Edmund L. <el...@in...>]

Ian Bicking wrote:

> Hmmm... I have a unit test that I think should cover this particular
> case (JoinTest2.test), so I suspect I won't be able to reproduce the
> problem.  Are there transactions or threads involved?

Really? I'm not doing anything fancy... no transactions or threads. I 
ran the test manually from the command line. The only thing that might 
interfere with this is that Webware and code using SO was running in a 
separate window.

Let me see if I can't write a short snippet that will reproduce the 
problem. I'll get back to you.

...Edmund.