sqlalchemy_orm_update.py

import time

def test_sqlalchemy_orm_update(n=100000):
    init_sqlalchemy(False)
    t0 = time.time()
    customer = Customer.__table__
    for i in xrange(1, n+1):
        stmt = customer.update().where(customer.c.id==i).values(
            {'name': 'NEW_NAME ' + str(i)}
        )
        DBSession.execute(stmt)
        DBSession.commit()
    print(
        "SQLAlchemy ORM: Total time for " + str(n) +
        " records " + str(time.time() - t0) + " secs")