phpunit use right database

@lars64 What exactly did you change? Did you add a new database connection to config/database.php and specify that in your phpunit.xml? E.g. in config/database.php

'sqlite_testing' => [
            'driver'   => 'sqlite',
            'database' => database_path('testing.sqlite'),
            'prefix'   => '',
        ],

and in phpunit.xml

<env name="DB_CONNECTION" value="sqlite_testing"/>

Then just migrate your database ...

php artisan migrate --database=sqlite_testing

... and phpunit uses that database.

@skliche Yes I've that. But when I want to test my api routes I've to change

  'default' => env('DB_CONNECTION', 'mysql'),

to

    'default' => env('DB_CONNECTION', 'mysql_testing'),

@lara_elicit s you need to change the environment on the phpunit.xml

This is my file, you can check it

<?xml version="1.0" encoding="UTF-8"?>
<phpunit backupGlobals="false"
         backupStaticAttributes="false"
         bootstrap="bootstrap/autoload.php"
         colors="true"
         convertErrorsToExceptions="true"
         convertNoticesToExceptions="true"
         convertWarningsToExceptions="true"
         processIsolation="false"
         stopOnFailure="false"
         syntaxCheck="false">
    <testsuites>
        <testsuite name="Application Test Suite">
            <directory>./tests/</directory>
        </testsuite>
    </testsuites>
    <filter>
        <whitelist>
            <directory suffix=".php">app/</directory>
        </whitelist>
    </filter>
    <php>
        <env name="APP_ENV" value="testing"/>
        <env name="CACHE_DRIVER" value="array"/>
        <env name="SESSION_DRIVER" value="array"/>
        <env name="QUEUE_DRIVER" value="sync"/>
        <env name="DB_CONNECTION" value="sqlite"/>
    </php>
</phpunit>

@Mirdrack I've changed DB_CONNECTION in phpunit.xml this is my phpunit.xml file:

<?xml version="1.0" encoding="UTF-8"?>
<phpunit backupGlobals="false"
         backupStaticAttributes="false"
         bootstrap="bootstrap/autoload.php"
         colors="true"
         convertErrorsToExceptions="true"
         convertNoticesToExceptions="true"
         convertWarningsToExceptions="true"
         processIsolation="false"
         stopOnFailure="false">
    <testsuites>
        <testsuite name="Application Test Suite">
            <directory>./tests/</directory>
        </testsuite>
    </testsuites>
    <filter>
        <whitelist>
            <directory suffix=".php">app/</directory>
        </whitelist>
    </filter>
    <php>
        <env name="APP_ENV" value="testing"/>
        <env name="CACHE_DRIVER" value="array"/>
        <env name="SESSION_DRIVER" value="array"/>
        <env name="QUEUE_DRIVER" value="sync"/>
        <env name="DB_CONNECTION" value="mysql_testing"/>
    </php>
</phpunit>
<?xml version="1.0" encoding="UTF-8"?>
<phpunit backupGlobals="false"
         backupStaticAttributes="false"
         bootstrap="bootstrap/autoload.php"
         colors="true"
         convertErrorsToExceptions="true"
         convertNoticesToExceptions="true"
         convertWarningsToExceptions="true"
         processIsolation="false"
         stopOnFailure="false">
    <testsuites>
        <testsuite name="Application Test Suite">
            <directory>./tests/</directory>
        </testsuite>
    </testsuites>
    <filter>
        <whitelist>
            <directory suffix=".php">app/</directory>
        </whitelist>
    </filter>
    <php>
        <env name="APP_ENV" value="testing"/>
        <env name="CACHE_DRIVER" value="array"/>
        <env name="SESSION_DRIVER" value="array"/>
        <env name="QUEUE_DRIVER" value="sync"/>
        <env name="DB_CONNECTION" value="mysql_testing"/>
    </php>
</phpunit>

And my connection for testing:

  'mysql_testing' => [
            'driver'    => 'mysql',
            'host'      => env('TEST_DB_HOST', 'localhost'),
            'database'  => env('TEST_DB_DATABASE', 'forge'),
            'username'  => env('TEST_DB_USERNAME', 'forge'),
            'password'  => env('TEST_DB_PASSWORD', ''),
            'port'      => env('DB_PORT','33060'),
            'charset'   => 'utf8',
            'collation' => 'utf8_unicode_ci',
            'prefix'    => '',
            'strict'    => false,
        ],

@lars64 Does your environment configuration for TEST_DB_DATABASE contain a different database name than your other database configuration?

@skliche yes it does.

@lars64 Ok, sounds like your configuration is ok but is not actually used. Are you using Homestead?

Try the following in your test file:

public function setUp() {
    parent::setUp();
    dd(DB::connection()->getConfig(null));
}

If the above outputs the correct database settings: Please try it with a sqlite database like I described it in my first reply. I have just used those steps on a different project that uses MySQL as the production database and there it works just fine, the tests use the sqlite database.

Hi. Did you manage to resolve this problem? I'm also experiencing this issue. I have the correct connection set in phpunit.xml, but still, my tests are using the production database.

Thx.