flask返回json数据

定义类后，在里面定义方法to_json():

# 创建对象的基类:
Base = declarative_base()


# Address对象:
class Address(Base):
    # 表的名字:
    __tablename__ = 'address'
    # 表的结构:
    id = Column(Integer, primary_key=True)
    address = Column(String(20))
    status = Column(Integer)

    def to_json(self):
        return {
            'id': self.id,
            'address': self.address,
            'status': self.status
        }

返回dict数据。

返回json数据，使用jsonify：

from flask import Flask, jsonify

@app.route('/ajax')
def ajax():
    session = DBSession()
    try:
        addresses = session.query(Address).filter().all()
        addresses_json = list()
        for address in addresses:
            print(address.address)
            addresses_json.append(address.to_json())
        return jsonify({'addresses': addresses_json})

    except Exception as e:
        print(e)
    finally:
        session.close()

返回的数据如下所示：

{
addresses: [
{
address: "xxx#qq.com",
id: 1,
status: 0
},
{
address: "xxx@163.com",
id: 2,
status: 0
}
]
}