我将如何转换这个 JSON 以便我可以使用 Flask-SQLAlchemy 将它添加到 MySQL 数据库？

JSON

{"users": [{"username": "userxyz", "id": 4, "email": "[email protected]", "events": [{"event_name": "vday"}, {" event_name": "生日"}]}]}

D B

class User(db.Model):

    id= db.Column(db.Integer, primary_key=True)
    username= db.Column(db.String(80), unique=True, nullable=False)
    email= db.Column(db.String(120), unique=True, nullable=False)
    events= db.relationship('Event', backref='user')

class Event(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    event_name = db.Column(db.String(200), nullable=False)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'))

模式

class UserSchema(ma.ModelSchema):
        events = fields.Nested('EventSchema', many=True)

class Meta:
    model = User

class EventSchema(ma.ModelSchema):
    class Meta:
        model = Event
        exclude = ('id', 'user_id', 'user')