[sqlalchemy] Re: SQL Alchemy Closure Table Relationship Definition

2012-01-10 Thread jonstjohn
understand SA and particularly SA relationships. A million thanks! Jon On Jan 9, 11:22 pm, Michael Bayer mike...@zzzcomputing.com wrote: On Jan 9, 2012, at 11:58 PM, jonstjohn wrote: The route and area relationship is similar to the hypothetical problem of a business location.  Suppose you

[sqlalchemy] SQL Alchemy Closure Table Relationship Definition

2012-01-09 Thread jonstjohn
I recently started working with SQL Alchemy for a project that involves climbing areas and routes. Areas are hierarchical in that a single area may contain multiple areas, which in turn may contain other areas. A route is directly associated with a single area, but is also associated with that

[sqlalchemy] Re: SQL Alchemy Closure Table Relationship Definition

2012-01-09 Thread jonstjohn
Michael - I greatly appreciate the time and consideration you put into your thorough reply. It has really helped me better understand how SQL Alchemy handles associations. In particular, it is now apparent to me that there is no clear association between area and route, which makes it not