Yes right I tried it just now. Altough taking away lazy=False makes the exceptions go out of my face, it is still not correct. The join over the intermediate table gives me all entries from the intermediate instead of just the ones associated with the one instance I'm querying them from.
Quoting Michael Bayer <[EMAIL PROTECTED]>: > Your test program, which is also becoming a unit test, works if you > convert the eager loads to lazy loads. both problems are related to > the formulation of an eager load against a parent object, which also > has an inheritance relationship to the thing you are eager > loading...there are a few places it gets confused. its not related > to Oracle. > > now the tricky part, is getting the eager loads to work. I will have > to do some more tinkering with the fundamentals of "mapper > inheritance" to get it going. > > On Mar 8, 2006, at 9:52 AM, Florian Boesch wrote: > > > Hi, I've analyzed my previous problem and boiled it down to a test > > program > > (atached). > > There's two issues connected to it both visible in the test > > programm as > > appended tracebacks. > > > > To the basic principle. I have three tables, one base table, one > > table that in > > herits base and antother table that inherits the one that inherits > > from base. > > Expressed in more simple terms, I've got A, B inheriting A, C > > inheriting B. > > > > On why I do such wicked things: Say I've got something like > > content. So there's > > page content. But there can be different kinds of pages, like a > > Link list, a > > news teaser etc. So page would inherit content, and news teaser > > would inherit > > page. On the other hand there can be products, which also inherit > > content. So > > there you are. > > > > Cheers, > > Florian > > <inheritance_test.py> > > ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
