> On 11 Jun 2015, at 19:09, Tony C <[email protected]> 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
