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

2016-12-23 Thread Brian Clark
Got it, thanks! On Friday, December 23, 2016 at 12:11:12 PM UTC-8, Brian Clark wrote: > > 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

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

2016-12-23 Thread Jonathan Vanasco
If you really need to do something like that though, you can always string together raw sql + bindparams, and pipe it all through an `execute` into the dbcursor. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provi

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

2016-12-23 Thread mike bayer
that pattern is not supported in SQLAlchemy Core. On 12/23/2016 03:21 PM, Brian Clark wrote: Seems doable in raw SQL (using postgresql btw) http://stackoverflow.com/questions/18797608/update-multiple-rows-in-same-query-using-postgresql On Friday, December 23, 2016 at 12:11:12 PM UTC-8, Bria

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

2016-12-23 Thread Brian Clark
Seems doable in raw SQL (using postgresql btw) http://stackoverflow.com/questions/18797608/update-multiple-rows-in-same-query-using-postgresql On Friday, December 23, 2016 at 12:11:12 PM UTC-8, Brian Clark wrote: > > Is there an update equivalent of this insert statement? > > inserts = [{"name":