flask mysql json_flask-sqlalchemy 怎么设置json格式的字段

有两种方法：

1.sqlalchemy中PickleType可以对应任何python对象.

2.可以通过编写方法的方式生成json.

具体代码如下：

#!usr/bin/env python

# coding:utf-8

from flask import Flask

from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)

app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql://root:psw@localhost/test_json'

app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = True

db = SQLAlchemy(app)

class Users(db.Model):

__tablename__ = 'users'

user_id = db.Column(db.Integer, primary_key=True)

user_info = db.Column(db.PickleType)

def __repr__(self):

return self.user_info

class Students(db.Model):

__tablename__ = 'students'

student_id = db.Column(db.Integer, primary_key=True)

student_name = db.Column(db.String(80),