I tried depth 4, with fine gain control using eagerload_all options.
That works! Cool!
Thanks again for the great job!
Best
Jian
On Aug 22, 10:38 pm, Michael Bayer <[EMAIL PROTECTED]> wrote:
> Hi Jian -
>
> yes, its the PropertyAliasedClauses. I put in a fix + a test based
> on your example in r3410. i didnt yet add a test for more levels
> deep yet, though, so see how that goes.
>
> - mike
>
> On Aug 22, 2007, at 3:07 PM, Jian Luo wrote:
>
> > class Widget(object):
> > pass
>
> > mapper(Widget, widget, properties={
> > 'children': relation(Widget, secondary=widget_rel,
> > primaryjoin=widget_rel.c.parent_id==widget.c.id,
> > secondaryjoin=widget_rel.c.child_id==widget.c.id,
> > lazy=False, join_depth=1,
> > )
> > })
>
> > sess = scoped_session(sessionmaker())()
>
> > and I want eager load the widget whose id=1 and all it's children if
> > any:
>
> > sess.query(Widget).filter(Widget.id==1).all()
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---