[sqlalchemy] Operations on instance identity criterion with Many-to-Many self-relational table

2008-06-27 Thread MuTPu4
Hello! I have table wordforms and WordformMapping associated with it. Bi- directional self-relation is expressed by using association table with attributes named infinitives and forms. I am using Elixir for mapping definition so I cannot access association table with it's columns explicitly. I am

[sqlalchemy] Re: permanent objects and sessions

2007-07-28 Thread MuTPu4
On Jul 28, 5:36 pm, Michael Bayer [EMAIL PROTECTED] wrote: your best option is probably to keep the objects in a session that's specifically for the global objects. Most important is that if you are using multiple threads, you never call flush() on this session. With regards to threadsafety

[sqlalchemy] Re: permanent objects and sessions

2007-07-28 Thread MuTPu4
On Jul 28, 11:08 pm, Michael Bayer [EMAIL PROTECTED] wrote: theres nothing at all wrong with the above; the only adjustments Id make are to a. leave a global session open for your directory.root, and b. remove all cascade rules from the parent relation (in this case using