[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) but it

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

2007-02-06 Thread Rick Morrison
Well one good thing about the positional-style INSERT is that it just might be useful for implementing INSERT INTO SELECT FROM, which would be a pretty useful addition to the SQL API layer On 2/6/07, S.R. Larmes [EMAIL PROTECTED] wrote: Michael Bayer wrote: On Feb 6, 1:20 pm, S.R.

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

2007-02-06 Thread Michael Bayer
its all good, just not a high priority for me :). feel free to dig in. the insert/update code is already a little intense due to it already having multiple ways to do the same thing, not to mention its some of the first code i wrote in SA and feels a little old, so adding features like these