Level 4
Hi, you may want to use the PHPUnit Fixture Feature which provides a way to handle Database Entries while a test runs.
Jan 22, 2017
5
Level 1
How to run laravel database seeder from phpunit test setUp?
I am trying to recreate database before each tests in some phpunit teast case. I am using laravel 5.3. Here is TestCase:
class CourseTypesTest extends TestCase
{
public function setUp()
{
parent::setUp();
Artisan::call('migrate');
Artisan::call('db:seed', ['--class' => 'TestDatabaseSeeder ', '--database' => 'testing']);
}
/**
* A basic functional test example.
*
* @return void
*/
public function test_list_course_types()
{
$httpRequest = $this->json('GET', '/api/course-types');
$httpRequest->assertResponseOk();
$httpRequest->seeJson();
}
public function tearDown()
{
Artisan::call('migrate:reset');
parent::tearDown();
}
}
Running phpunit fails with error:
$ phpunit PHPUnit 5.7.5 by Sebastian Bergmann and contributors.
E 1 / 1 (100%)
Time: 2.19 seconds, Memory: 12.00MB
There was 1 error:
- CourseTypesTest::test_list_course_types ReflectionException: Class TestDatabaseSeeder does not exist
D:\www\learn-laravel\my-folder-api\vendor\laravel\framework\src\Illuminate\Container\Container.php:749 D:\www\learn-laravel\my-folder-api\vendor\laravel\framework\src\Illuminate\Container\Container.php:644 D:\www\learn-laravel\my-folder-api\vendor\laravel\framework\src\Illuminate\Foundation\Application.php:709 D:\www\learn-laravel\my-folder-api\vendor\laravel\framework\src\Illuminate\Database\Console\Seeds\SeedCommand.php:74 D:\www\learn-laravel\my-folder-api\vendor\laravel\framework\src\Illuminate\Database\Console\Seeds\SeedCommand.php:63 D:\www\learn-laravel\my-folder-api\vendor\laravel\framework\src\Illuminate\Database\Eloquent\Model.php:2292 D:\www\learn-laravel\my-folder-api\vendor\laravel\framework\src\Illuminate\Database\Console\Seeds\SeedCommand.php:64 D:\www\learn-laravel\my-folder-api\vendor\laravel\framework\src\Illuminate\Container\Container.php:508 D:\www\learn-laravel\my-folder-api\vendor\laravel\framework\src\Illuminate\Console\Command.php:169 D:\www\learn-laravel\my-folder-api\vendor\symfony\console\Command\Command.php:254 D:\www\learn-laravel\my-folder-api\vendor\laravel\framework\src\Illuminate\Console\Command.php:155 D:\www\learn-laravel\my-folder-api\vendor\symfony\console\Application.php:821 D:\www\learn-laravel\my-folder-api\vendor\symfony\console\Application.php:187 D:\www\learn-laravel\my-folder-api\vendor\symfony\console\Application.php:118 D:\www\learn-laravel\my-folder-api\vendor\laravel\framework\src\Illuminate\Console\Application.php:107 D:\www\learn-laravel\my-folder-api\vendor\laravel\framework\src\Illuminate\Foundation\Console\Kernel.php:218 D:\www\learn-laravel\my-folder-api\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php:237 D:\www\learn-laravel\my-folder-api\tests\rest\CourseTypesTest.php:17
ERRORS! Tests: 1, Assertions: 0, Errors: 1.
but this class exists:
Level 1
I have get fix on http://stackoverflow.com/questions/41790764/how-to-run-laravel-database-seeder-from-phpunit-test-setup/41791031#41791031
In short - I had space after the Seeder name.
Level 4
Use Illuminate\Foundation\Testing\DatabaseMigrations to run your migrations and $this->seed('TestDatabaseSeeder') to run your seeder.
2 likes
Level 1
As @prasinoulhs says you can use Illuminate\Foundation\Testing\DatabaseMigrations and i think is cleaner and the right way but, in my case i wasn't able to call $this->seed method from one of my phpunit test (I'm using Lumen 5.3 and maybe that's the reason, anyway). To make it work i just call to my SeedDatabase class from runDatabaseMigrations method from DatabaseMigration class like this:
$this->artisan('db:seed', ['--class' => 'DatabaseSeeder']);
I'm not sure if this is the right way, but does the trick.
Level 15
Can we run this command $this->artisan('db:seed') once and data stays there till application run tests. So, that we don't need to use db:seed in every test class. Making is drastically slow.
Please or to participate in this conversation.