从flask中的sql-alchemy中检索所有表

pip install SQLAlchemy
pip install Flask-SQLAlchemy

app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql://username:password@localhost/db_name'

from flask import Flask
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)
db = SQLAlchemy(app)

class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(50), unique=True)
    email = db.Column(db.String(120), unique=True)

    def __repr__(self):
        return '<User %r>' % self.username

@app.route('/')
def index():
    db.reflect()  # 反射数据库中的所有表
    tables = db.metadata.tables.keys()  # 获取所有表的名称
    return ', '.join(tables)  # 返回所有表的名称，以逗号分隔