There might be a way to do it off the relationships API entirely. I do the
following way all the time:
Join the child table, order by it, then use `contains_eager(childfield)` so
sqlalchemy won't do another query for the child data
return self.session.query(Reference) \
.join(Periodical, Reference.periodical_id == Periodical.id)\
.order_by(Periodical.id.asc())\
.contains_eager('_periodical')\ # this lets sqlalchemy know you
loaded the `_periodical` relationship, it will build those objects
.all()
--
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.
