时间:2021-07-01 10:21:17 帮助过:248人阅读
然后在视图层中
- @api.route(<span style="color: #800000;">‘</span><span style="color: #800000;">/company_goods</span><span style="color: #800000;">‘</span>, methods=[<span style="color: #800000;">‘</span><span style="color: #800000;">GET</span><span style="color: #800000;">‘</span>, <span style="color: #800000;">‘</span><span style="color: #800000;">POST</span><span style="color: #800000;">‘</span><span style="color: #000000;">])
- </span><span style="color: #0000ff;">def</span><span style="color: #000000;"> company_goods():
- </span><span style="color: #0000ff;">if</span> request.method == <span style="color: #800000;">‘</span><span style="color: #800000;">GET</span><span style="color: #800000;">‘</span><span style="color: #000000;">:
- company_id </span>= request.args.get(<span style="color: #800000;">‘</span><span style="color: #800000;">company_id</span><span style="color: #800000;">‘</span>, <span style="color: #800000;">‘‘</span><span style="color: #000000;">)
- category_id </span>= request.args.get(<span style="color: #800000;">‘</span><span style="color: #800000;">category_id</span><span style="color: #800000;">‘</span>, <span style="color: #800000;">‘‘</span><span style="color: #000000;">)
- data</span>=<span style="color: #000000;">CompanyGoodsModel.get_info_by_id(company_id, category_id)
- result</span>=<span style="color: #000000;">[]
- </span><span style="color: #0000ff;">for</span> d <span style="color: #0000ff;">in</span><span style="color: #000000;"> data:
- d.goods_info</span>=eval(d[<span style="color: #800000;">‘</span><span style="color: #800000;">goods_info</span><span style="color: #800000;">‘</span><span style="color: #000000;">])
- result.append(d.to_json())
- </span><span style="color: #0000ff;">if</span> <span style="color: #0000ff;">not</span><span style="color: #000000;"> result:
- </span><span style="color: #0000ff;">return</span> json_response(<span style="color: #800000;">‘</span><span style="color: #800000;">0001</span><span style="color: #800000;">‘</span>, {}, <span style="color: #800000;">‘</span><span style="color: #800000;">数据获取失败 </span><span style="color: #800000;">‘</span><span style="color: #000000;">)
- </span><span style="color: #0000ff;">return</span> json_response(<span style="color: #800000;">‘</span><span style="color: #800000;">0000</span><span style="color: #800000;">‘</span>, result, <span style="color: #800000;">‘</span><span style="color: #800000;">数据获取成功</span><span style="color: #800000;">‘</span>)
将sqlalchemy 查询结果转化成json格式
标签:json格式 company route for base val model app 一个