sqlalchemy_orm_bulk_update.py

import time


def test_sqlalchemy_orm_bulk_update(n=100000):
    init_sqlalchemy(False)
    t0 = time.time()
    DBSession.bulk_update_mappings(
        Customer,
        [{'name': 'NEW_NAME ' + str(i), 'id': i}
         for i in xrange(1, n+1)]
    )

    DBSession.commit()
    print(
        "SQLAlchemy ORM bulk_update_mappings(): Total time for " + str(n) +
        " records " + str(time.time() - t0) + " secs")