Re: [sqlalchemy] How form a many-to-many relationship with a 3-way association?

2014-04-03 Thread Tony B
Thank you very much! That was the nudge I needed. I saw association proxies in the docs, but wasn't sure that was what I wanted. It was! I had considered making the credits table an object, but wasn't sure it was the correct way. By doing that, in combo with an accessor property on Credit

Re: [sqlalchemy] How form a many-to-many relationship with a 3-way association?

2014-04-02 Thread Michael Bayer
Maybe someone can fill in the details here, but the credit pair as tuple is something you'd do with association proxy. Model plain relationships from document to credit, then credit to role and person; then add an accessor to credit called person_role_tuple, then the association proxy is on