组合单租户和多租户基础架构

from flask import Flask, request

app = Flask(__name__)

@app.route('/')
def index():
    tenant_id = request.headers.get('X-Tenant-ID')
    # 根据tenant_id获取对应的数据库连接和配置
    db_connection = get_db_connection(tenant_id)
    # 处理业务逻辑
    return f"Hello, Tenant {tenant_id}!"

def get_db_connection(tenant_id):
    # 根据tenant_id返回对应的数据库连接
    return f"DB Connection for Tenant {tenant_id}"

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

from flask import Flask, request
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///multi_tenant.db'
db = SQLAlchemy(app)

class Tenant(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(50), unique=True)

class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(50))
    tenant_id = db.Column(db.Integer, db.ForeignKey('tenant.id'))

@app.route('/')
def index():
    tenant_id = request.headers.get('X-Tenant-ID')
    # 根据tenant_id获取对应的数据库连接和配置
    db.session.query(User).filter_by(tenant_id=tenant_id).all()
    # 处理业务逻辑
    return f"Hello, Tenant {tenant_id}!"

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