看来你实际上尚未执行查询。请尝试以下操作:
return jsonify(json_list = qryresult.all())
[编辑]:jsonify的问题是,通常无法自动对对象进行jsonify。甚至Python的日期时间也会失败;)
我过去所做的就是在serialize
需要序列化的类中添加一个额外的属性(例如)。
def dump_datetime(value):
"""Deserialize datetime object into string form for JSON processing."""
if value is None:
return None
return [value.strftime("%Y-%m-%d"), value.strftime("%H:%M:%s")]
class Foo(db.Model):
# ... sqlAlchemy defs here..
def __init__(self, ...):
# self.foo = ...
pass
@property
def serialize(self):
"""Return object data in easily serializable format"""
return {
'id' : self.id,
'modified_at': dump_datetime(self.modified_at),
# This is an example how to deal with Many2Many relations
'many2many' : self.serialize_many2many
}
@property
def serialize_many2many(self):
"""
Return object's relations in easily serializable format.
NB! Calls many2many's serialize property.
"""
return [ item.serialize for item in self.many2many]
现在,对于视图,我可以做到:
return jsonify(json_list=[i.serialize for i in qryresult.all()])
希望这可以帮助