[sqlalchemy] Re: save/update and caching

2007-11-05 Thread klaus
On 2 Nov., 19:09, Michael Bayer [EMAIL PROTECTED] wrote: On Nov 2, 2007, at 1:15 PM, klaus wrote: Thanks, but this doesn't seem to do what I wanted. The merge modifies the object and therefore tries to update the underlying table on session.flush(). So it might work if you prevented

[sqlalchemy] Re: save/update and caching

2007-11-02 Thread klaus
Thanks, but this doesn't seem to do what I wanted. The merge modifies the object and therefore tries to update the underlying table on session.flush(). So it might work if you prevented the save also. (In my case, the update is not only a waste, it even fails because the table is

[sqlalchemy] Re: save/update and caching

2007-10-31 Thread Michael Bayer
On Oct 31, 2007, at 12:43 PM, klaus wrote: When trying to cache the contents of some small tables, I followed a recipe given by Michael Bayer on this list (at least how I understood it): create a dead session without database connection and move all these objects into it. However, every