Level 73
what happens if you run php artisan test --env=testing so explicitly loading the environment?
And btw, make sure you upgrade the phpunit version as well.
Nov 5, 2024
10
Level 51
PEST using real database instead of test database
Hello developers,
I'm using herd in windows. I have set up 2 database one is real and one is for testing. whenever I'm running php artisan test it is affecting my real database. I tried all the solutions but nothing is working. I'm not able to find out the issue.
whenever I'm trying to check the current environment it is coming as local instead of testing.
.env file
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=db_name
DB_USERNAME=***
DB_PASSWORD=***
phpunit.xml file
<?xml version="1.0" encoding="UTF-8"?>
<phpunit xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="vendor/phpunit/phpunit/phpunit.xsd"
bootstrap="vendor/autoload.php"
colors="true"
>
<testsuites>
<testsuite name="Unit">
<directory>tests/Unit</directory>
</testsuite>
<testsuite name="Feature">
<directory>tests/Feature</directory>
</testsuite>
</testsuites>
<source>
<include>
<directory>app</directory>
</include>
</source>
<php>
<env name="APP_ENV" value="testing"/>
<env name="APP_MAINTENANCE_DRIVER" value="file"/>
<env name="BCRYPT_ROUNDS" value="4"/>
<env name="CACHE_STORE" value="array"/>
<env name="DB_CONNECTION" value="mysql"/>
<env name="DB_HOST" value="127.0.0.1"/>
<env name="DB_PORT" value="3306"/>
<env name="DB_DATABASE" value="test_db"/>
<env name="DB_USERNAME" value="root"/>
<env name="DB_PASSWORD" value="root"/>
<env name="MAIL_MAILER" value="array"/>
<env name="PULSE_ENABLED" value="false"/>
<env name="QUEUE_CONNECTION" value="sync"/>
<env name="SESSION_DRIVER" value="array"/>
<env name="TELESCOPE_ENABLED" value="false"/>
</php>
</phpunit>
TestCase.php file
protected function setUp(): void
{
parent::setUp();
$this->actingAs(User::factory()->create());
dump(app()->environment());
}
I have cleared cache run commands composer dump-autoload nothing is working.
Thanks
Level 51
@Nakov Let me try with this php artisan test --env=testing. I recently installed a new laravel project. Again I need to upgrade phpunit version?
Level 51
@Nakov No luck. I have written this test as well. But it is failing. It is coming as local
it('uses test database for test cases', function () {
dump(app()->environment());
$this->assertEquals('testing', app()->environment());
$this->assertEquals('test_db', config('database.connections.mysql.database'));
});
Level 73
@shariff what does recently means? What does it show if you run composer show phpunit/phpunit ?
and did you do any changes to the Pest.php file?
Level 51
@Nakov
composer show phpunit/phpunit display phpunit version versions : * 11.4.3
In Pest.php I just uncommented this line ->use(Illuminate\Foundation\Testing\RefreshDatabase::class)
Pest.php file
<?php
/*
|--------------------------------------------------------------------------
| Test Case
|--------------------------------------------------------------------------
|
| The closure you provide to your test functions is always bound to a specific PHPUnit test
| case class. By default, that class is "PHPUnit\Framework\TestCase". Of course, you may
| need to change it using the "pest()" function to bind a different classes or traits.
|
*/
pest()->extend(Tests\TestCase::class)
->use(Illuminate\Foundation\Testing\RefreshDatabase::class)
->in('Feature');
/*
|--------------------------------------------------------------------------
| Expectations
|--------------------------------------------------------------------------
|
| When you're writing tests, you often need to check that values meet certain conditions. The
| "expect()" function gives you access to a set of "expectations" methods that you can use
| to assert different things. Of course, you may extend the Expectation API at any time.
|
*/
expect()->extend('toBeOne', function () {
return $this->toBe(1);
});
/*
|--------------------------------------------------------------------------
| Functions
|--------------------------------------------------------------------------
|
| While Pest is very powerful out-of-the-box, you may have some testing code specific to your
| project that you don't want to repeat in every file. Here you can also expose helpers as
| global functions to help you to reduce the number of lines of code in your test files.
|
*/
function something()
{
// ..
}
TestCase.php file
<?php
namespace Tests;
use App\Models\User;
use Illuminate\Foundation\Testing\TestCase as BaseTestCase;
abstract class TestCase extends BaseTestCase
{
protected function setUp(): void
{
parent::setUp();
$this->actingAs(User::factory()->create());
dump(app()->environment());
}
}
Level 73
@shariff really weird, I am trying everything locally to reproduce it, but it simply works.
I tried to see if there are any open issues for Herd, Windows version, and it shows this one: https://github.com/beyondcode/herd-community/issues/601 which is partially related to what is happening to you I guess.
Can you try restarting Herd and see if it will load the changes in your phpunit.xml file, if you updated it after Herd was running.
I am on a Mac, and out of ideas on what can be the issue. Sorry.
Level 51
@Nakov I restarted herd. Same issue.
I am on a Mac, and out of ideas on what can be the issue. Sorry.
No worries at all. Thank you so much for your help! I really appreciate your assistance.
Level 2
I think you've cached your config.
You should be able to run php artisan config:Clear and that should fix it.
Level 1
Hey, @shariff.
You need to create a .env.testing file and set the APP_ENV to testing.
Level 51
@mrkalmdn I did that as well. It is not working
Please or to participate in this conversation.