Python Flask-SQLAlchemy比较两个表

from flask import Flask
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = '数据库连接字符串'
db = SQLAlchemy(app)

class Table1(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(50))
    # 其他列...

class Table2(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(50))
    # 其他列...

def compare_tables():
    table1_columns = set(Table1.__table__.columns.keys())
    table2_columns = set(Table2.__table__.columns.keys())

    common_columns = table1_columns.intersection(table2_columns)
    unique_columns_table1 = table1_columns - table2_columns
    unique_columns_table2 = table2_columns - table1_columns

    return {
        'common_columns': common_columns,
        'unique_columns_table1': unique_columns_table1,
        'unique_columns_table2': unique_columns_table2
    }

@app.route('/')
def index():
    comparison_result = compare_tables()
    return str(comparison_result)