Dynamically change database connection in cakephp 3

Question

I'm trying to change the database connection used in cakephp 3 on the fly. Every answer to this question that I found refers to cakephp 2 (These three for instance).

This guy found a solution for cakephp 3 having a finite number of databases, and specifically defining which Database would be used by which Table file.

The thing is that I want to create a new database for every new user, and change to his database when he logs in. I can't know in advance all the databases that will exist, to write it in the config/app.php file.

And I can't set the default database in each /src/Model/Table file, because the tables are the same in every database.

José Lorenzo Rodríguez · Accepted Answer · 2015-05-16 12:13:46Z

7

Use the ConnectionManager::config() function to create connections on the fly and the ConnnectionManager::alias() method to make all your Table classes use it by default.

There is a very good article describing the process here:

http://mark-story.com/posts/view/using-cakephp-and-a-horizontally-sharded-database

The only difference is that you can create the connection config on the fly instead of declaring the shards manually as it was shown in that article.

answered May 16, 2015 at 12:13

José Lorenzo Rodríguez

9,62437 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

chopstik Over a year ago

Based on Mark's article I added middleware (CakePHP 3) to create an alias based on form request data, effectively allowing a database change on the fly/at login - see gist.github.com/chopstik/…

Saeid Dadkhah · Accepted Answer · 2017-06-21 04:50:01Z

Change database connection for one model:

In app.php :

'test' => [
            'className' => 'Cake\Database\Connection',
            'driver' => 'Cake\Database\Driver\Mysql',
            'persistent' => false,
            'host' => MySQL_HOST,
            //'port' => 'nonstandard_port_number',
            'port' => MySQL_PORT,
            'username' => MySQL_USER,
            'password' => MySQL_PASS,
            'database' => 'test',
            'encoding' => 'utf8',
            'timezone' => 'UTC',
            'cacheMetadata' => true,
            'quoteIdentifiers' => false,
            'log' => false,
        //'init' => ['SET GLOBAL innodb_stats_on_metadata = 0'],
        ]

In Controller :

$conn = ConnectionManager::get('test');
 $_model = TableRegistry::get('your_alias', ['table' => 'your_table', 'connection' => $conn]);

Pankaj Wanjari · Accepted Answer · 2019-04-28 13:03:57Z

0

Configuring table connections

 namespace App\Model\Table;

 use Cake\ORM\Table;

 class ArticlesTable extends Table
 {
     public static function defaultConnectionName() {
     return 'replica_db';
     }
 }

answered Apr 28, 2019 at 13:03

Pankaj Wanjari

1,2852 gold badges9 silver badges11 bronze badges

Collectives™ on Stack Overflow

Dynamically change database connection in cakephp 3

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related