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 — Frédéric Klee
– Frédéric Klee, Commented Jun 24, 2019 at 14:07
Not an option, I will be having 500+ dynamic databases and no code should be touched when it starts rolling. — ACD
– ACD, Commented Jun 24, 2019 at 14:21
@FrédéricKlee can't do it like that since I have to change the connection entirely throughout the request lifecycle. — ACD
– ACD, Commented Jun 25, 2019 at 4:36

ACD · Accepted Answer · 2019-06-25 04:35:09Z

0

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.

answered Jun 25, 2019 at 4:35

ACD

1,4511 gold badge14 silver badges26 bronze badges

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

1 Answer 1