Re: [sqlalchemy] Possible to bulk update with different values?

2016-12-23 Thread mike bayer
Here's Postgresql's UPDATE syntax: https://www.postgresql.org/docs/9.5/static/sql-update.html as you can see the WHERE clause has only one option, so it's one row at a time. On 12/23/2016 03:11 PM, Brian Clark wrote: Is there an update equivalent of this insert statement? inserts =

[sqlalchemy] Possible to bulk update with different values?

2016-12-23 Thread Brian Clark
Is there an update equivalent of this insert statement? inserts = [{"name": "jon", "age": 20"}, {"name": "ashley", "age": 22"}] session.execute( People.__table__.insert().values( inserts ) ) I have this right now but it's still slower than I'd like because it's using