从SQLAlchemy返回JSON对象，Flask获取3个相关表

from flask import Flask, jsonify
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'your_database_uri'
db = SQLAlchemy(app)

# 定义数据库模型
class Table1(db.Model):
    # 定义表结构
    # ...

class Table2(db.Model):
    # 定义表结构
    # ...

class Table3(db.Model):
    # 定义表结构
    # ...

@app.route('/tables', methods=['GET'])
def get_tables_data():
    # 查询3个相关表的数据
    table1_data = Table1.query.all()
    table2_data = Table2.query.all()
    table3_data = Table3.query.all()

    # 将数据转换为字典列表
    table1_json = [item.to_dict() for item in table1_data]
    table2_json = [item.to_dict() for item in table2_data]
    table3_json = [item.to_dict() for item in table3_data]

    # 构建返回的JSON对象
    response = {
        'table1': table1_json,
        'table2': table2_json,
        'table3': table3_json
    }

    return jsonify(response)

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