[New post] PHP code snippet – How to separate test database in laravel unit test?

Subash Chandran posted: "// In your config/database.php bellow mysql add: 'mysql_testing' => [ 'driver' => 'mysql', 'host' => env('TESTING_DB_HOST', 'localhost'), 'database' => env('TESTING_DB_DATABASE', 'forge'), 'username' => env('TESTING_DB_USERNAME', 'forge')," New post on Poopcode PHP code snippet – How to separate test database in laravel unit test? by Subash Chandran // In your config/database.php bellow mysql add: 'mysql_testing' => [ 'driver' => 'mysql', 'host' => env('TESTING_DB_HOST', 'localhost'), 'database' => env('TESTING_DB_DATABASE', 'forge'), 'username' => env('TESTING_DB_USERNAME', 'forge'), 'password' => env('TESTING_DB_PASSWORD', ''), 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => '', 'strict' => false, ], //And now in your .env add the values for: TESTING_DB_HOST=localhost TESTING_DB_DATABASE=homestead_testing TESTING_DB_USERNAME=homestead TESTING_DB_PASSWORD=secret // Now you can run php artisan migrate —database=mysql_testing // And the last thing - open your phpunit.xml file in the app folder and add this: <env name="DB_CONNECTION" value="mysql_testing"/> Read more of this post Subash Chandran | November 20, 2021 at 11:36 am | Tags: how to separate test database in laravel unit test, how to seperate test database in laravel unit test, laravel 8 test database setting, laravel best way to split mysql testgin and production, laravel database test and production, laravel database.php testing, laravel modify column value phpunit, laravel setup test database, laravel test, laravel unit test database, laravel unit test database connection, laravel unit test database with insert data, laravel unit test with database, laravel unit testing database, php feature test laravel, unit test check from db laravel, unit testing database laravel | Categories: Snippets | URL: https://wp.me/pb9kQA-4u6 Comment    See all comments Unsubscribe to no longer receive posts from Poopcode. Change your email settings at Manage Subscriptions. Trouble clicking? Copy and paste this URL into your browser: https://poopcode.com/php-code-snippet-how-to-separate-test-database-in-laravel-unit-test/