laravel如何为多租户应用设计数据库_Laravel多租户应用数据库设计方法

// app/Http/Middleware/IdentifyTenant.php
public function handle($request, \Closure $next)
{
    $host = $request->getHost();
    $tenantId = explode('.', $host)[0]; // 简化示例

    if (! $tenant = Tenant::where('id', $tenantId)->first()) {
        abort(404);
    }

    // 将租户信息存入运行时上下文
    app()->instance('currentTenant', $tenant);

    // 切换数据库连接（可选，用于独立数据库模式）
    // Config::set('database.connections.tenant.database', $tenant->database_name);

    return $next($request);
}

// app/Models/Scopes/TenantScope.php
class TenantScope implements Scope
{
    public function apply(Builder $builder, Model $model)
    {
        if (app()->runningInConsole() || ! app()->has('currentTenant')) {
            return;
        }

        $tenant = app('currentTenant');
        $builder->where('tenant_id', $tenant->id);
    }
}

// app/Models/Post.php
protected static function booted()
{
    static::addGlobalScope(new TenantScope);
}

// 在模型中监听创建事件
protected static function booted()
{
    static::addGlobalScope(new TenantScope);

    static::creating(function ($model) {
        if (! app()->runningInConsole() && app()->has('currentTenant')) {
            $model->tenant_id = app('currentTenant')->id;
        }
    });
}

Config::set('database.connections.mysql.database', $tenant->db_name);
DB::purge('mysql'); // 清除连接缓存
DB::reconnect('mysql');