Re: [sqlalchemy] Dependency rule tried to blank-out primary key column when trying to update using association proxy

2016-02-24 Thread Piotr Dobrogost
On Wednesday, February 24, 2016 at 4:07:07 PM UTC+1, Mike Bayer wrote: > > > There might be an old issue in bitbucket that the way associationproxy > insists on calling clear() without any hook to override, the AP has a > lot of old override hooks that are complicated and difficult to use, and

Re: [sqlalchemy] Dependency rule tried to blank-out primary key column when trying to update using association proxy

2016-02-24 Thread Mike Bayer
On 02/24/2016 09:56 AM, Piotr Dobrogost wrote: On Wednesday, February 24, 2016 at 4:21:58 AM UTC+1, Mike Bayer wrote: in that way you can control exactly what __set__() does and it will never remove a TextValue object where the same identity is coming in on assignment. One more

Re: [sqlalchemy] Dependency rule tried to blank-out primary key column when trying to update using association proxy

2016-02-24 Thread Piotr Dobrogost
On Wednesday, February 24, 2016 at 4:21:58 AM UTC+1, Mike Bayer wrote: in that way you can control exactly what __set__() does and it will > never remove a TextValue object where the same identity is coming in on > assignment. > One more question; is this described somewhere in the docs? I

Re: [sqlalchemy] Dependency rule tried to blank-out primary key column when trying to update using association proxy

2016-02-24 Thread Piotr Dobrogost
On Wednesday, February 24, 2016 at 4:21:58 AM UTC+1, Mike Bayer wrote: in that way you can control exactly what __set__() does and it will > never remove a TextValue object where the same identity is coming in on > assignment. > Mike, thank you very much for your help. Regards, Piotr --

Re: [sqlalchemy] Dependency rule tried to blank-out primary key column when trying to update using association proxy

2016-02-23 Thread Mike Bayer
On 02/23/2016 06:11 PM, Piotr Dobrogost wrote: On Tuesday, February 23, 2016 at 5:44:45 PM UTC+1, Mike Bayer wrote: That the old TextValue objects need to be deleted I understand. What I don't see is what makes SA specifically blank-out primary key column 'text_value.text_id'? the

Re: [sqlalchemy] Dependency rule tried to blank-out primary key column when trying to update using association proxy

2016-02-23 Thread Mike Bayer
On 02/23/2016 10:47 AM, Piotr Dobrogost wrote: Hi! I'm getting AssertionError: Dependency rule tried to blank-out primary key column 'text_value.text_id' on instance '' error while trying to update row using association proxy ('values') like this: |

[sqlalchemy] Dependency rule tried to blank-out primary key column when trying to update using association proxy

2016-02-23 Thread Piotr Dobrogost
Hi! I'm getting AssertionError: Dependency rule tried to blank-out primary key column 'text_value.text_id' on instance '' error while trying to update row using association proxy ('values') like this: session.add(Text(values={'pl': u'org', 'en': u'org'})) text = session.query(Text).one()