如何使用flask和sqlalchemy在三个多对多模型中制作post数据

from flask import Flask, request
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = '数据库连接地址'
db = SQLAlchemy(app)

# 定义第一个多对多关系的模型类
class Model1(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(50))
    models2 = db.relationship('Model2', secondary='model1_model2', backref='models1')

# 定义第二个多对多关系的模型类
class Model2(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(50))

# 创建关联表
model1_model2 = db.Table('model1_model2',
    db.Column('model1_id', db.Integer, db.ForeignKey('model1.id')),
    db.Column('model2_id', db.Integer, db.ForeignKey('model2.id'))
)

# 定义第三个多对多关系的模型类
class Model3(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(50))
    models2 = db.relationship('Model2', secondary='model2_model3', backref='models3')

# 创建关联表
model2_model3 = db.Table('model2_model3',
    db.Column('model2_id', db.Integer, db.ForeignKey('model2.id')),
    db.Column('model3_id', db.Integer, db.ForeignKey('model3.id'))
)

db.create_all()

@app.route('/post_data', methods=['POST'])
def post_data():
    data = request.get_json()
    
    # 创建模型对象并设置属性值
    model1 = Model1(name=data['model1_name'])
    model2 = Model2(name=data['model2_name'])
    model3 = Model3(name=data['model3_name'])
    
    # 将模型对象添加到数据库会话中
    db.session.add(model1)
    db.session.add(model2)
    db.session.add(model3)
    
    # 提交会话以保存数据
    db.session.commit()
    
    return 'Data posted successfully!'

if __name__ == '__main__':
    app.run()