[sqlalchemy] Re: SQL Alchemy Closure Table Relationship Definition

2012-01-10 Thread jonstjohn
Thanks for persisting with me - your solution was almost perfect, and really pointing me in the right direction. Below is what eventually worked: areas = relationship('DbArea', backref = backref('routes', order_by = 'DbRoute.name'), secondary = area_relationship_table,

[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

Re: [sqlalchemy] Re: SQL Alchemy Closure Table Relationship Definition

2012-01-09 Thread Michael Bayer
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 have a set of business locations, each in a specific city. The business must be associated with one and only one city. The city is