sqlalchemy update 更新

#将dub中location字段V开头的值，site改为venlov_list = session.query(Sites).filter(Sites.site=='dub',Sites.location.startswith('V')).all()for v in v_list:v.site = 'venlo'session.commit()

nongcunqq

6420人浏览 · 2021-09-10 19:07:34

nongcunqq · 2021-09-10 19:07:34 发布

  items = ss.query(MaterialTest).all()
    print(items)
    for item in items:
        print(item)
        print(item.material)
        item.so = '111'
        ss.commit()

 #将dub中location字段V开头的值，site改为venlo
    v_list = session.query(Sites).filter(Sites.site=='dub',Sites.location.startswith('V')).all()
    for v in v_list:
        v.site = 'venlo'
    session.commit()