Thanks Simon!
I tried your method and it didn't work... because I had been resetting my
query all along and not noticing (!!!) FFS.
After extensive testing this morning, I found that mistake because these 3
forms will generate the same exact sql in the current 1.x release:
# Chained joinedload
q1 = session.query(Collection)\
.options(joinedload('to_items').joinedload('item'))
# Grouped joinedload
q2 = session.query(Collection)\
.options(joinedload('to_items'), joinedload('to_items.item'))
# Compounded joinedload
q3 = session.query(Collection)\
.options(joinedload('to_items'))\
.options(joinedload('to_items.item'))
The same sql is generated and the same relationships are handled in each
case. association_proxy works as expected (seamlessly).
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.