Re: [sqlalchemy] Wrapper Table needs Joins on SELECT, not on Insert.

2019-07-13 Thread Michael P. McDonnell
Awesome! Thanks! I've been trying to figure out how to do a reliable object -> json conversion (including nested relationships). I'm hoping this is it. On Sat, Jul 13, 2019, 9:53 AM Mike Bayer wrote: > > > On Fri, Jul 12, 2019, at 6:49 PM, Michael P. McDonnell wrote: > > Hey Mike - > > First

Re: [sqlalchemy] Wrapper Table needs Joins on SELECT, not on Insert.

2019-07-13 Thread Mike Bayer
On Fri, Jul 12, 2019, at 6:49 PM, Michael P. McDonnell wrote: > Hey Mike - > > First off - thanks for the association proxy idea - I like that, and even if > heavy handed - specifically like the idea that its a *view* in to column as > opposed to a manipulable column. > The next question is

Re: [sqlalchemy] Wrapper Table needs Joins on SELECT, not on Insert.

2019-07-12 Thread Michael P. McDonnell
And for clarity's sake - I mean without knowing specifically ahead of time its a "task" object. On Fri, Jul 12, 2019 at 5:49 PM Michael P. McDonnell wrote: > Hey Mike - > > First off - thanks for the association proxy idea - I like that, and even > if heavy handed - specifically like the idea

Re: [sqlalchemy] Wrapper Table needs Joins on SELECT, not on Insert.

2019-07-12 Thread Michael P. McDonnell
Hey Mike - First off - thanks for the association proxy idea - I like that, and even if heavy handed - specifically like the idea that its a *view* in to column as opposed to a manipulable column. The next question is - how do I iterate over those association proxy fields within the object? So

Re: [sqlalchemy] Wrapper Table needs Joins on SELECT, not on Insert.

2019-07-12 Thread Mike Bayer
On Fri, Jul 12, 2019, at 11:20 AM, Michael P. McDonnell wrote: > Hey Team - > > So I'm working on a relatively fun hierarchy that allows me to relate tasks > to games. > So I have 2 tables: > > # A Generic Task Definition - not related to anything > class Task_Definition(Base): > def

[sqlalchemy] Wrapper Table needs Joins on SELECT, not on Insert.

2019-07-12 Thread Michael P. McDonnell
Hey Team - So I'm working on a relatively fun hierarchy that allows me to relate tasks to games. So I have 2 tables: # A Generic Task Definition - not related to anything class Task_Definition(Base): def __repr__(self): return ( "") __table__ =