this is a wide open question. personally im not a fan locking/cursor games.

but to answer the question "how do we do this", id need to see, "what do we want?" what would you want a code example using this concept to look like ? are we talking ORM, SQL construction layer here ? a method off of engine ? right now, you can just say engine.connection ().cursor() and just do what you want with it. what else ?


On Mar 15, 2006, at 5:22 AM, Florian Boesch wrote:

Hi,

I just noticed that Cherrypy's session implementation locks a row representing a
session by a for update clause.

It releases this lock by closing the cursor.

How do I implement similar behavior in sqlalchemy (aparts from accessing the
underlying db-api and instanciating/closing db-cursors myself)?

Cheers,
Florian


-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel? cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users



-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users

Reply via email to