JSON serializ的语句错误

Question

这里我有一些简单的RESTAPI端点，用于创建具有以下模型的乘客对象

 class PassengerModel(db.Model):

    __tablename__ = 'passenger'

    ps_id          = db.Column(db.Integer, primary_key=True, autoincrement=True)
    ps_token_id    = db.Column(db.String(120),unique=True, nullable=False)
    passenger_name = db.Column(db.String(50),unique=True, nullable=False)
    passenger_email= db.Column(db.String(120),unique=True, nullable=False)
    prof_pic       = db.Column(db.String(120),unique=True, nullable=False)
    is_ontrip      = db.Column(db.Boolean, nullable=True)
    created        = db.Column(db.DateTime, default=datetime.datetime.utcnow,nullable=True)
    updated        = db.Column(db.DateTime,nullable=True)

看起来是这样的

passenger_parser = reqparse.RequestParser()

passenger_parser.add_argument('ps_token_id')
passenger_parser.add_argument('passenger_name')
passenger_parser.add_argument('passenger_email')
passenger_parser.add_argument('prof_pic')
passenger_parser.add_argument('is_ontrip')
passenger_parser.add_argument('created')
passenger_parser.add_argument('updated')

class PassengerRegistration(Resource):
    def post(self):
        data = passenger_parser.parse_args()

        if PassengerModel.find_by_email(data['passenger_email']):
            return {'message': 'User {} already exists'.format(data['passenger_name'])}

        new_passenger = PassengerModel(
            ps_token_id     = data['ps_token_id'],
            passenger_name  = data['passenger_name'],
            passenger_email = data['passenger_email'],
            prof_pic        = data['prof_pic'],
            is_ontrip       = data['is_ontrip']
        )

        try:
            new_passenger.save_to_db()
            return {'message': 'passenger {} created'.format(data['passenger_name'])}
        except Exception as e:
            return {'message': 'Something went wrong', 'error': e}, 500

有一次我试图用一个邮递员创建一个新的乘客对象，错误如下

 {
    "ps_token_id":"1@asdsd",
    "passenger_name":"vAAaA",
    "passenger_email":"vAasd@g.com",
    "prof_pic":"asdasdv",
    "is_ontrip":"False"
}

它返回这个错误

TypeError: Object of type StatementError is not JSON serializable

对于is_ontrip，我尝试了0 and 1, true, false使用大括号和不使用大括号。每次都会出现上述错误

我做错了什么

Answer 1

调用new_passenger.save_to_db()时出现了一些问题，这导致SqlAlchemy ^{}

无法将其序列化为JSON，因此需要提供可序列化类型，例如字符串：

... 'error': str(e)}, 500

或者要访问StatementError特定属性，请添加单独的except：

...
except StatementError as se:
    return {'message': 'DB error', 'error': str(se), 'statement': se.statement}, 500