当前位置：网站首页>sqlalchemy bulk insert

sqlalchemy bulk insert

2022-08-06 09:24:00 【Xiaodou Whole Sugar (Cx)】

  1. Session object has provided bulk_save_objectsmethod
    But use this method need to pay attention that it may cause memory overflow

  2. Recommended method

@app.post('/multi')async def multi(db:Session=Depends(get_db)):# db.bulk_save_objectsdb.execute(Student.__table__.insert(),[{"name": 'NAME ' + str(i)} for i in range(100)])return "success"
def get_db():db: Session = SessionLocal()try:yield dbdb.commit()except Exception:db.rollback()finally:db.close()
原网站

版权声明
本文为[Xiaodou Whole Sugar (Cx)]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/218/202208060920324861.html

边栏推荐

猜你喜欢

随机推荐