I have a questions. If the only way to issue executemany is to do a conn.execute(table.insert(), list_of_dict). How users supposed to use postgres on_conflict and mysql on duplicate key update with this? Seems like there would be no way to access .updated in postgres and corresponding .values in mysql, because there are no values have been passed at this point.
On Thursday, 25 May 2017 22:43:55 UTC+3, Mike Bayer wrote: > > > > On 05/25/2017 01:44 PM, Михаил Доронин wrote: > >> SQLAlchemy batches inserts in the ORM as is possible and with Core you > >> do this explicitly, both make use of cursor.executemany() which is then > >> determined by how the DBAPI handles it. > > -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.