flask使用模块flask_sqlalchemy来根据前端POST请求实现对本地数据库的增删改查（三）---改

上一篇文章已经讲过删了，这篇文章讲下改：

（为了方便演示我创建了一个测试的数据:need_id为20的这些数据）

话不多说，上代码：

#根据id修改对应参数
@app.route('/fix',methods=['POST'])
def fix ():
    js = request.get_json()
    Need_id = js['need_id']
    Title = js['title']
    Applicant_name = js['applicant_name']
    Applicant_number = js['applicant_number']
    Department = js['department']
    Business = js['business']
    System_number = js['system_number']
    Cause = js['cause']
    need.query.filter_by(need_id=Need_id).update({'title': Title})
    need.query.filter_by(need_id=Need_id).update({'applicant_name': Applicant_name})
    need.query.filter_by(need_id=Need_id).update({'applicant_number': Applicant_number})
    need.query.filter_by(need_id=Need_id).update({'department': Department})
    need.query.filter_by(need_id=Need_id).update({'business': Business})
    need.query.filter_by(need_id=Need_id).update({'systemctl_number': System_number})
    need.query.filter_by(need_id=Need_id).update({'cause': Cause})


    db.session.commit()
    return jsonify({"code": "0000", "msg": "请求成功"})
          # except Exception as e:
           #     # 回滚
           #       db.session.rollback()
    # else:
    #     return jsonify({"code": "4500", "msg": "需求找不到"})

 

进入postman 进行请求参数设定;

 

在本地服务器上查看已经请求成功：

 

那我们在进入数据库看看，need_id为20的数据已经修改完毕：

 

---