Thanks David On Thursday, June 11, 2015 at 11:53:44 AM UTC-7, David Allouche wrote: > > > On 11 Jun 2015, at 19:09, Tony C <capp...@gmail.com <javascript:>> wrote: > > I'm new to databases, SQL, and SQLAlchemy. I've been going through the > tutorials and docs at SQLAlchemy.org trying to find a solution to > what I believe is a very simple issue with database quiries, however I'm > quite uncertain of the terminology. > > I'm using the declarative form of SQL queries. > > When doing a query on a table with a foreign key, I want to query the data > in the "referenced table". > In uncertain terms, I want the query to be "recursive"- meaning, I want > all of the data from the referenced tables, not just the values of the > foreign keys. > However, I don't know what the exact terminology is in order to search > through help. > > Here is an example: (this is exploratory code only. Error handling and > imports left out for brevity) > > http://pastebin.com/HpNB64t4 > > 1. What is the correct terminology for a recursive query, in SQLAlchemy > parlance? > 2. How do I tell SQL Alchemy to do that? > > > You probably want to read about the following topics in the SQLAlchemy > documentation. > > - relation > - joinedload > > > Regards. >
-- 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 sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.