Re: [sqlalchemy] Objects inadvertently being added to session

2015-06-15 Thread T Mark
Hi Mike, Thanks so much for the reply and the pointer. Since I never added anything to the session explicitly, I think I was missing that loading an object implicitly adds that object to the session - which does make sense. Is that right ? thanks again, terry On Monday, June 15, 2015 at

[sqlalchemy] Re: Objects inadvertently being added to session

2015-06-15 Thread T Mark
I forgot to mention: I'm using: - Python 2.7.6 on Linux, - SQLAlchemy version 0.9.9. - PostgreSQL 9.3 Thanks - terry On Monday, June 15, 2015 at 11:12:54 AM UTC-4, T Mark wrote: Hi there, I have been pulling my hair out on this one. I understood that objects make it into the session only

Re: [sqlalchemy] Objects inadvertently being added to session

2015-06-15 Thread Mike Bayer
On 6/15/15 11:12 AM, T Mark wrote: Hi there, I have been pulling my hair out on this one. I understood that objects make it into the session only due to an explicit call to add(). or if they are associated with a parent object that is added to the Session via add(), or if they are

[sqlalchemy] Objects inadvertently being added to session

2015-06-15 Thread T Mark
Hi there, I have been pulling my hair out on this one. I understood that objects make it into the session only due to an explicit call to add(). But, I seem to be seeing objects being added without my explicitly doing so. Is this to be expected ? For instance, I want to establish a

[sqlalchemy] Reproducible oddity in with_for_update()

2015-06-15 Thread Brian Candler
I have an issue which I have boiled down to a full test case below. This test program reproduces the problem with both sqlalchemy 0.9.9 and 1.0.5, under python 2.7.6 and ubuntu 14.04, and PyMySQL-0.6.2. There are a combination of circumstances: 1. After you rollback a session, touching any

Re: [sqlalchemy] Objects inadvertently being added to session

2015-06-15 Thread Mike Bayer
On 6/15/15 11:48 AM, T Mark wrote: Hi Mike, Thanks so much for the reply and the pointer. Since I never added anything to the session explicitly, I think I was missing that loading an object implicitly adds that object to the session - which does make sense. Is that right ? All the

Re: [sqlalchemy] Reproducible oddity in with_for_update()

2015-06-15 Thread Mike Bayer
On 6/15/15 3:01 PM, Brian Candler wrote: I have an issue which I have boiled down to a full test case below. This test program reproduces the problem with both sqlalchemy 0.9.9 and 1.0.5, under python 2.7.6 and ubuntu 14.04, and PyMySQL-0.6.2. There are a combination of circumstances: 1.

Re: [sqlalchemy] Custom Flush

2015-06-15 Thread Richard Collins
Thanks Michael. before_flush looks like the way to go. From what I can see so far, it will alleviate the need to call my add_or_remove function, increasing reliability. On Monday, 15 June 2015 10:27:06 UTC+12, Michael Bayer wrote: On 6/14/15 5:49 PM, Richard Collins wrote: I have an