[sqlalchemy] Re: executemany upate

2008-10-18 Thread Empty
Hi, Is there a way to do executemany() semantic updates? Suppose I have a list of employee id's and I want to do something like: ids = [1, 2, 3, 4, 5, 6] session.execute( tbl_employees.update(tbl_employees.c.id == ids), tbl_employees.c.status=you're fired ) Just us the in_ syntax

[sqlalchemy] Re: executemany upate

2008-10-18 Thread J Stam
Is there a way to do executemany() semantic updates? Suppose I have a list of employee id's and I want to do something like: ids = [1, 2, 3, 4, 5, 6] session.execute( tbl_employees.update(tbl_employees.c.id == ids), tbl_employees.c.status=you're fired ) Just us the in_ syntax

[sqlalchemy] Re: executemany upate

2008-10-18 Thread Michael Bayer
On Oct 18, 2008, at 10:20 AM, J Stam wrote: Is there a way to do executemany() semantic updates? Suppose I have a list of employee id's and I want to do something like: ids = [1, 2, 3, 4, 5, 6] session.execute( tbl_employees.update(tbl_employees.c.id == ids),