Unit testing failing on multiple database connection

[shahakshay938]

Laravel Version

10.45.1

PHP Version

8.1.27

Database Driver & Version

mysql Ver 8.2.0 for macos14.0 on arm64 (Homebrew)

Description

I've set up two MySQL database connections and added test cases, but now it's failing because another database connection (the secondary database) was not refreshed by the 'RefreshDatabase' trait.

How I resolved it
Created and used this new trait "RefreshTestDatabase" instead of laravel default "RefreshDatabase" and added this code

`
<?php

namespace Tests;

use App\Console\Kernel;
use Illuminate\Foundation\Testing\RefreshDatabase;
use Illuminate\Foundation\Testing\RefreshDatabaseState;

trait RefreshTestDatabase
{
    use RefreshDatabase;

    protected function refreshTestDatabase()
    {
        if (! RefreshDatabaseState::$migrated) {
            $this->artisan('db:wipe --env=testing --database=mysql');
            $this->artisan('db:wipe --env=testing --database=mysql2');

            $this->artisan('migrate:fresh', $this->migrateFreshUsing());

            $this->app[Kernel::class]->setArtisan(null);

            RefreshDatabaseState::$migrated = true;
        }

        $this->beginDatabaseTransaction();
    }
}

`

Steps To Reproduce

1. Create a new Laravel Breeze project or use an existing one.
2. Set up two database connections.
3. Update models and migrations to use the desired database via the $connection property.
4. Write test cases or use existing ones (default provided by Breeze).
5. Run the tests.