在cakePHP3中动态切换数据库

// 配置多个数据库连接
'Datasources' => [
    'default' => [
        'className' => 'Cake\Database\Connection',
        'driver' => 'Cake\Database\Driver\Mysql',
        'host' => 'localhost',
        'username' => 'root',
        'password' => 'password',
        'database' => 'default_db',
        // 其他数据库连接配置...
    ],
    'secondary' => [
        'className' => 'Cake\Database\Connection',
        'driver' => 'Cake\Database\Driver\Mysql',
        'host' => 'localhost',
        'username' => 'root',
        'password' => 'password',
        'database' => 'secondary_db',
        // 其他数据库连接配置...
    ],
],

// 创建数据库连接管理类
class DatabaseManager {
    public static function switchConnection($connectionName) {
        ConnectionManager::alias($connectionName, 'default');
    }
}

// 实现动态切换逻辑
$tenantId = getCurrentTenantId(); // 获取当前租户标识
if ($tenantId === 'tenant1') {
    DatabaseManager::switchConnection('secondary');
} else {
    DatabaseManager::switchConnection('default');
}

// 使用数据库连接进行操作
$usersTable = TableRegistry::getTableLocator()->get('Users');
$users = $usersTable->find('all')->toArray();