[sqlalchemy] What is the terminology for ...?
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? Thanks -- 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.
Re: [sqlalchemy] What is the terminology for ...?
On 11 Jun 2015, at 19:09, Tony C cappy2...@gmail.com 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.
Re: [sqlalchemy] What is the terminology for ...?
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.