python flask sqlalchemy model对象转json_python flask-sqlalchemy 对象转为json

def model_to_json_test():
    from flask import jsonify
    q = db.session.query(WhiteSite).first()  # db = SQLAlchemy()
    q_dict = serialize(q)
    q_json = jsonify(q_dict)
    return q_json
 
 
def serialize(model):
    from sqlalchemy.orm import class_mapper
    columns = [c.key for c in class_mapper(model.__class__).columns]
    return dict((c, getattr(model, c)) for c in columns)

class WhiteSite(db.Model):
    __tablename__ = 'WHITE_SITE'
    site_name = db.Column(db.String(128), primary_key=True)
    comments = db.Column(db.String(1000))
    create_time = db.Column(db.DateTime, default=func.now())
    create_user = db.Column(db.String(128))
    last_modified_time = db.Column(db.DateTime, default=func.now(), onupdate=func.now())
    last_modified_user = db.Column(db.String(512))