Re: [sqlalchemy] How do I do this SQL query in SQLAlchemy?

2012-07-03 Thread Michael Bayer
this is a very basic series of joins which can be approached using the techniques described in the ORM tutorial: http://docs.sqlalchemy.org/en/rel_0_7/orm/tutorial.html#querying-with-joins . the parenthesization of the joined tables within subqueries is also not needed and these tables can be j

[sqlalchemy] How do I do this SQL query in SQLAlchemy?

2012-07-02 Thread Jason Phillips
I have a MySQL database with the following structure and was hoping someone could help me convert the SQL query below to SQLAlchemy. *Database structure:* *bottom:* id name middle_id *middle:* id name top_id *top:* id name *Here are my model