[sqlalchemy] Re: Equivalent of UPDATE ... WHERE ... in ORM?

2009-01-30 Thread James
Perfect - thanks Mike! As I'm using 0.4 (sorry, neglected to mention that) I've gone for the table.update(...).execute() option and it works a treat. On Jan 25, 12:25 am, Michael Bayer mike...@zzzcomputing.com wrote: the update() method on Query accomplishes this.  Make sure you read   the

[sqlalchemy] Re: Equivalent of UPDATE ... WHERE ... in ORM?

2009-01-24 Thread Michael Bayer
the update() method on Query accomplishes this. Make sure you read the docstring for it which describes some various behaviors you'll want to be aware of. alternatively, any SQL expression, like table.update(), UPDATE table can be issued within the ORM's transaction using