[sqlalchemy] Re: Modelling a complex(ish) many-to-many association with dates

2008-07-20 Thread Michael Bayer
On Jul 20, 2008, at 1:22 PM, Rob Cowie wrote: I have a many-to-many relationship between 'Company' and 'Index', defined in an association table (CompanyIndex). Schemas below: Company: (companyID, companyName, ...) Index: (indexID, indexName) CompanyIndex:

[sqlalchemy] Re: Modelling a complex(ish) many-to-many association with dates

2008-07-20 Thread Rob Cowie
On reflection, I didn't pose the problem very clearly. What I mean with regard to appending or removing index objects is that the collection returned by company.indices(date) would - on append of an index object - record the association by creating an IndexAssociation object (mapped to the

[sqlalchemy] Re: Modelling a complex(ish) many-to-many association with dates

2008-07-20 Thread Michael Bayer
On Jul 20, 2008, at 2:24 PM, Rob Cowie wrote: On reflection, I didn't pose the problem very clearly. What I mean with regard to appending or removing index objects is that the collection returned by company.indices(date) would - on append of an index object - record the association by