Re: [sqlalchemy] Bidirectional relationships with association proxies

2011-09-01 Thread Benjamin Sims
Thanks so much - I realise now that the documentation I should have been reading was: http://www.sqlalchemy.org/docs/orm/relationships.html#backref-arguments Ben On 31 August 2011 22:50, Michael Bayer mike...@zzzcomputing.com wrote: dependency rule tried to blank out primary key means: 1.

[sqlalchemy] Bidirectional relationships with association proxies

2011-08-31 Thread Benjamin Sims
Hi, I'm still having troubles correctly figuring my various many-to-many relations. Originally, this was a 'standard' many-to-many; that is, a secondary table was specified. However, I now need to add further information to the relation and am converting into an AssociationObject. My problem is

Re: [sqlalchemy] Bidirectional relationships with association proxies

2011-08-31 Thread Michael Bayer
dependency rule tried to blank out primary key means: 1. A references B, B has a foreign key to A. 2. A is deleted. 3. each B associated with A must therefore have the foreign key of A set to NULL (this is the default behavior if 'delete' cascade isn't configured). 4. the foreign key on B is