No easy way to switch between database connections

[codemedic]

When working with multiple databases, it seems not possible to switch between database connections (DSNs).

A typical use case would be in situations where you have two databases which are differently tuned; for the kind of data they deal with. One for configuration lookup, i.e high performance, almost all coming from memory, and the other database server for huge tables, say for example logs or financial transaction history.

If one needs to write a test that would talk to multiple databases, it would be handy to be able to switch between DSNs at will during the test.

[codemedic]

Example test script would look like ...

$I->amConnectedToDb('Database1');
$I->haveInDatabase(...);

$I->amConnectedToDb('Database2');
$I->haveInDatabase(...);
...

[codemedic]

Please can one of you experienced souls review this issue/feature request and the PR

[pribbernow-marc]

Would be very helpful. Thanks for report @codemedic!

[sangar82]

+1! I need this feature!

I work in a big project with a one database for each client. I need to change the connection to connect this DB's.

[sanderbrauwers]

+1

[codemedic]

I have kicked off an extension https://github.com/natterbox/Codeception-MultiDb
Comments and bug reports most welcome.

[gilbitron]

+1

[kappakp88]

+1

[codemedic]

@gilbitron and @kpascal
Guys, please can you have a look at the package natterbox/codeception-multidb on packagist.
More details at https://github.com/natterbox/Codeception-MultiDb

[olleharstedt]

👍

[rogoit]

+1

[tomotomo]

Nice Idea

[raistlin]

I haven't done a deep review on @codemedic code, but seems ok.
Could you create a PR on codeception's website repository to add a brief info of your extension, a simple text line on the readme or other more appropriate file is more than enough.

[rogoit]

I use sqlite connection and switch with _reconfigure on a helper...so i can also read db settings from .env file

[kappakp88]

its great that we all use this and this but how about a working copy example so others can be successful with "this and this" configurations

[rogoit]

We do not have all the same settings because everybody has a special usecase

[codemedic]

@raistlin Please can you point me in the right direction.
Where do I add that? Please can you let me know the location within the repo.

Ta

[goffyara]

[raistlin]

You should create a PR against Codeception web https://github.com/Codeception/codeception.github.com
I think the best place to add the information is on the "Extensions" section.

[Naktibalda]

Db module has this functionality since 2.5.0

https://codeception.com/docs/modules/Db#Example-with-multi-databases
https://codeception.com/docs/modules/Db#amConnectedToDatabase
https://codeception.com/docs/modules/Db#performInDatabase