[sqlalchemy] Many to many with extra field

2010-10-24 Thread sqlalchemy
I am trying to define relations between persons and teams, however there are multiple possible relationships (player, reserve, coach, trainer). My current set up defines both Person and Team using declarative base classes. For completeness sake; the database is already defined by the front end,

Re: [sqlalchemy] Many to many with extra field

2010-10-24 Thread Michael Bayer
On Oct 24, 2010, at 11:58 AM, sqlalch...@lists.fastmail.net wrote: I am trying to define relations between persons and teams, however there are multiple possible relationships (player, reserve, coach, trainer). My current set up defines both Person and Team using declarative base classes.

Re: [sqlalchemy] Many to many with extra field

2010-10-24 Thread sqlalchemy
Thank a lot; that did it for me, seems I got very close with the explicit secondary join statement, but you finished it right off. Just wanted to take this opportunity to say that I think the Python community is blessed with both your package, but potentially even more the effort you put in to