写一个公共方法
def model_to_dict(result):
from collections import Iterable
try:
if isinstance(result, Iterable):
tmp = [dict(zip(res.__dict__.keys(), res.__dict__.values())) for res in result]
for t in tmp:
t.pop('_sa_instance_state')
else:
tmp = dict(zip(result.__dict__.keys(), result.__dict__.values()))
tmp.pop('_sa_instance_state')
print(tmp)
return tmp
except BaseException as e:
print(e.args)
raise TypeError('Type error of parameter')
应用
@app.route('/detail',methods=["GET","POST"])
def detail():
articles = Article.query.all()
print(articles)
model_to_dict(articles)
return jsonify(model_to_dict(articles))
看下输出:
发现乱码了
中文乱码解决方案
app.config['JSON_AS_ASCII'] = False
最终结果