Python sqlachemy 批量添加

def test_sqlalchemy_orm_bulk_save_objects(n=100000):
init_sqlalchemy()
t0 = time.time()
for chunk in range(0, n, 10000):
DBSession.bulk_save_objects(
[
Customer(name="NAME " + str(i))
for i in xrange(chunk, min(chunk + 10000, n))
]
)
DBSession.commit()
print(
"SQLAlchemy ORM bulk_save_objects(): Total time for " + str(n) +

---------------------
作者：DHogan
来源：CSDN
原文：https://blog.csdn.net/dongyouyuan/article/details/79236673
版权声明：本文为博主原创文章，转载请附上博文链接！