sqlalchemy_core_update.py

import time


def test_sqlalchemy_core_update(n=100000):
    init_sqlalchemy(False)
    t0 = time.time()
    engine.execute(
        Customer.__table__.update(),
        [{'name': 'NEW_NAME ' + str(i), '_id': i}
         for i in xrange(1, n+1)]
    )
    print(
        "SQLAlchemy Core: Total time for " + str(n) +
        " records " + str(time.time() - t0) + " secs")