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

sa collections. Regardless, I think the rest of your answer implies a custom solution is appropriate. Cheers, Rob C On Jul 20, 6:44 pm, Michael Bayer <[EMAIL PROTECTED]> wrote: > On Jul 20, 2008, at 1:22 PM, Rob Cowie wrote: > > > > > > > I have a many-to-m

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

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: (companyID, indexID, eventDate, eventType) Would like to provide

[sqlalchemy] Modeling one-to-many with custom constraint

Hi all, I am trying to model the following situation: I have an entity (a committee), which is stored in a single table. Mapping Committee object to this is trivial. Defined in this table is a foreign key (type) which references the pk of a table committee_type. I wish to map Committee obj to