- 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()