[sqlalchemy] How to update large data?

2013-06-30 Thread MacVictor
array_name contains 10900 price. create_price = [] for x in range(0, 10900): price = Price(int(array_name[x]), extra=0) create_price.append(price) session.add_all(create_price) for y in range(1, 10901): session.query(Person).filter_by(id=y).update({"price_id": session.query(Price).ge

[sqlalchemy] How to update large data?

2013-06-30 Thread MacVictor
Hi, I try update large data: create_price = [] for x in range(0, 10900): price = Price(int(array_name[x]), extra=0) create_price.append(price) session.add_all(create_price) # for y in range(1, 10901): session.query(Person).filter_by(id=y).update({"price_id": create_price[y]},