python flask sqlalchemy model 对象转 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))