[sqlalchemy] Updating a column to an expression containing itself; Inserting data by lists or tuples

2007-02-06 Thread S.R. Larmes
Hi, I'm trying to get into SQLAlchemy and it has been really great so far, but there are two things I can't figure out how to do: (both are outside of ORM) a) How do I do: UPDATE sometable SET value = value * 0.9 + 1[ + optional WHERE clause ] ? I've tried experimenting with

[sqlalchemy] Re: Updating a column to an expression containing itself; Inserting data by lists or tuples

2007-02-06 Thread S.R. Larmes
Michael Bayer wrote: On Feb 6, 1:20 pm, S.R. Larmes [EMAIL PROTECTED] wrote: a) How do I do: UPDATE sometable SET value = value * 0.9 + 1[ + optional WHERE clause ] ? I've tried experimenting with .update(values=..) or stuff like .execute(value=sometable.c.value*0.9+1