Re: [sqlalchemy] How to use load_only or with_entities with relationships

2019-01-10 Thread Mike Bayer
On Thu, Jan 10, 2019 at 8:34 AM Gmoney wrote: > > Thanks for the very clear reply, that helps understand the underpinnings a > bit more. Hope you didn't take the list of errors as a complaint - just a > list of what I tried... but the error message enhancements look like a good > addition

Re: [sqlalchemy] How to use load_only or with_entities with relationships

2019-01-10 Thread Gmoney
Thanks for the very clear reply, that helps understand the underpinnings a bit more. Hope you didn't take the list of errors as a complaint - just a list of what I tried... but the error message enhancements look like a good addition that will help when I forget all this and repeat it a year

Re: [sqlalchemy] How to use load_only or with_entities with relationships

2019-01-08 Thread Mike Bayer
every case is now listed out for improved error reporting in: https://github.com/sqlalchemy/sqlalchemy/issues/4433 On Wed, Jan 9, 2019 at 12:21 AM Mike Bayer wrote: > > On Tue, Jan 8, 2019 at 4:16 PM Gmoney wrote: > > > > Unable to limit the columns returned from a query using .load_only or

Re: [sqlalchemy] How to use load_only or with_entities with relationships

2019-01-08 Thread Mike Bayer
On Tue, Jan 8, 2019 at 4:16 PM Gmoney wrote: > > Unable to limit the columns returned from a query using .load_only or > .with_entities. I feel like I'm missing a key concept here, and could use > some guidance. > > One column of interest is a relationship - which I'm guessing is my problem. >

[sqlalchemy] How to use load_only or with_entities with relationships

2019-01-08 Thread Gmoney
Unable to limit the columns returned from a query using .load_only or .with_entities. I feel like I'm missing a key concept here, and could use some guidance. One column of interest is a relationship - which I'm guessing is my problem. class Task(Base): __tablename__ = 'TASK' id =