1、代码如下:
data_list = db.session.query(Users).all
data_list = q.all()
for item in data_list:
try:
if not item:
continue
if not item.CODE:
continue
body_position = UserDto()
body_position.CODE = item.CODE
body_position.POS = item['POS']
update_user_pos(body_position)
except Exception as e:
LOGGER.error(str(e))
def update_user_pos(dto: UserDto)
try:
db.session.query(Users).filter(Users.CODE == dto.CODE)\
.update({"POS": dto.POS})
db.session.commit()
except Exception as ex:
db.session.rollback()
finally:
db.session.remove()
2、因为在update_user_pos中将session移除了,在第二次获取item.CODE时就会报错
3、处理方式:移除db.session.remove()