The Assistant

First, if and when you need to merge two databases that now have the same Primary Key ID values for the same table, your screwed. You have to come up with a scheme to change the ID’s, maybe adding 10,000 to each ID, what if you have more than 10,000 rows? The you also have to update all children records, maybe not that easy if you have constraints ... See more

SQLAlchemy introduced that in version 1.0.0 :

Bulk operations - SQLAlchemy docs

With these operations, you can now do bulk inserts or updates!

For instance (if you want the lowest overhead for simple table INSERTs), you can use Session.bulk_insert_mappings() :

loadme = [(1, 'a'),

(2, 'b'),

(3, 'c')]

dicts = [dict(bar=t[0], fly=t[1]) for t in loadme]

s = S... See more