DB::Connection not updated after dynamically changing db name via Config::set in Laravel/Lumen?

Question

I'm trying to connect to db dynamically through:

DB::disconnect('mysql');
Config::set('database.connections.mysql.database', 'db_1');

When I use DB::table('table_from_db_1')->..., it works perfectly. I get data from db_1;

However, when I try to get DB::connection()->getDatabaseName(), it still returns the original db name and NOT the db_1.

Question:

Have you tried to create a second Dataset in configuration. Check this complete example : [link](https://stackoverflow.com/questions/31847054/how-to-use-multiple-databases-in-laravel) — Frédéric Klee, Jun 24 '19 at 14:07
Not an option, I will be having 500+ dynamic databases and no code should be touched when it starts rolling. — ACD, Jun 24 '19 at 14:21
DId you try something like this [link](https://stackoverflow.com/questions/42198046/laravel-change-connection-dynamically) — Frédéric Klee, Jun 24 '19 at 14:31
@FrédéricKlee can't do it like that since I have to change the connection entirely throughout the request lifecycle. — ACD, Jun 25 '19 at 04:36

score 0 · Accepted Answer · answered Jun 25 '19 at 04:35

For anyone having the same problem, solved the issue by using purge instead of disconnect.

DB::purge('mysql'); // purge instead of disconnect
Config::set('database.connections.mysql.database', 'db_1');

Finally, use DB::connection()->getPdo(); inside try-catch to check if connection is valid.

1 Answers1