code-distortion
commented
1 year ago Hi @manu144x. Thanks for your question. Yes, Adapt can manage multiple databases.
When building a single database, you would configure Adapt by setting its config values or adding properties to your test class. Behind the scenes, Adapt builds a CodeDistortion\Adapt\DatabaseDefinition object which contains these settings. It then builds the database based on that.
Adding the method databaseInit(…) to your test class lets you define more of these DatabaseDefinition objects, in a programmatic way. Each one represents a connection that a database will be built for.
You can configure a second one with different settings to the first, including if you have a separate directory of migrations to run instead. Have a look at Building Extra Databases for the settings you can change.
You might like to put databaseInit(…) in a trait so it can be shared between tests more easily. However your code might look something like this:
// tests/Feature/MyFeatureTest.php
use CodeDistortion\Adapt\DatabaseDefinition;
use CodeDistortion\Adapt\AdaptDatabase;
use Tests\TestCase;
class MyFeatureTest extends TestCase
{
use AdaptDatabase;
protected function databaseInit(DatabaseDefinition $database): void
{
// $database contains the settings for your first db, based on
// Adapt's config file and class properties
// prepareConnection(…) creates another DatabaseDefinition.
// It's also based on on your configuration, however you would
// then tweak its settings
$this->prepareConnection('mysql-2')
// 'mysql-2' is your additional connection from config/database.php
->migrations('database/other_migrations_dir');
// … add extra configuration tweaks as needed
}
// … test methods
}I hope that all makes sense. Let me know if you have any questions.
manu144x
I did not find any other way to ask this, I'm asking it here.
We have a Laravel application that uses 2 databases, some for some models, others for other. Is there a way to have both databases initialized and up and running in the exact same way with the same hashing/versioning features?
Thank you.