Re: [sqlalchemy] Practical ways for dealing with concurrency problems?

2010-11-10 Thread Michael Bayer
Hi Russell - There's a lot going on here, so I'll point you to a few things. 1. the nested sets example, which also has the need to do update table set x=x+1 in order to make room for new entries, thats in the distro at examples/nested_sets/nested_sets.py .That example uses mapper

[sqlalchemy] Practical ways for dealing with concurrency problems?

2010-11-09 Thread Russell Warren
I've got several questions about dealing with concurrency issues in SQLAlchemy. To try and help with the asking, I'll use a small example similar to a situation I've got in an SQLAlchemy application. In this application, there is a table that tracks objects and their order/ position, something