Re: [sqlalchemy] Using sqlalchemy to figure out multi table relationships

2019-07-11 Thread Abdeali Kothari
I was hoping to not do graph traversals myself, because for the more complex cases it gets complicated, and was wondering if there was someone who had figured out the heuristics for some of the more complex cases ^_^ I will take a look at automap, I did see it - but did not realize that it also

Re: [sqlalchemy] Using sqlalchemy to figure out multi table relationships

2019-07-11 Thread Mike Bayer
On Thu, Jul 11, 2019, at 7:41 AM, Abdeali Kothari wrote: > I am trying to use SQLAlchemy to do some smart joins for me without me having > to explicitly figure out the joins during queries. > (i.e. by figuring out the relationships on its own to figure out how the > tables are related to each

Re: [sqlalchemy] Using sqlalchemy to figure out multi table relationships

2019-07-11 Thread Mike Bayer
On Thu, Jul 11, 2019, at 7:41 AM, Abdeali Kothari wrote: > I am trying to use SQLAlchemy to do some smart joins for me without me having > to explicitly figure out the joins during queries. > (i.e. by figuring out the relationships on its own to figure out how the > tables are related to each

[sqlalchemy] Using sqlalchemy to figure out multi table relationships

2019-07-11 Thread Abdeali Kothari
I am trying to use SQLAlchemy to do some smart joins for me without me having to explicitly figure out the joins during queries. (i.e. by figuring out the relationships on its own to figure out how the tables are related to each other) I have an example where i have BookSeries -> Book ->