Hi 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? 3. There are two columns in the class which are designated as ForeignKeys. What *should* the ForeignKey() function actually do? I was expecting (not having any background in databases) that this would do the "recursive query) that i"m expecting. However, when I remove ForeignKey() from the class definition, the output does not change at all. I don't understand this. Thanks Tony -- 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.
