Re: [sqlalchemy] How should I eagerly load a property from multiple levels of a self-referential table?

2018-10-26 Thread Alex Wang
Ah, ok. I thought defaultload() meant use whatever was originally specified in the relationship(). That helps a lot! On Friday, October 26, 2018 at 12:34:53 PM UTC-4, Mike Bayer wrote: > > On Fri, Oct 26, 2018 at 12:10 PM Alex Wang > wrote: > > > > I ended up n

Re: [sqlalchemy] How should I eagerly load a property from multiple levels of a self-referential table?

2018-10-26 Thread Alex Wang
like what you suggested and use that? And just to make sure, selectinloads should be the right choice for this kind of nested collection, right? Thanks! On Thursday, October 25, 2018 at 6:54:53 PM UTC-4, Mike Bayer wrote: > > On Thu, Oct 25, 2018 at 4:21 PM Alex Wang > > wrote:

[sqlalchemy] How should I eagerly load a property from multiple levels of a self-referential table?

2018-10-25 Thread Alex Wang
Hi all! I'm trying to write a small script to interface with a database controlled by a third-party application, and I'm not sure the way I set up eager loading is right. The code I have looks something like the following: from sqlalchemy.ext.declarative import declarative_base from