How to Run Laravel Database Seeder from PHPUnit Test setUp?

Question

I am trying to recreate the database before each test in some PHPUnit test cases. 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:

1) 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:

Santi Barbat · Accepted Answer · 2020-06-21 13:20:10Z

41

Since version 5.8 you can do:

// Run the DatabaseSeeder...
$this->seed();

// Run a single seeder...
$this->seed(OrderStatusesTableSeeder::class);

Take a look at the documentation

edited Jun 21, 2020 at 13:20

answered Oct 26, 2019 at 17:21

Santi Barbat

2,3332 gold badges23 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ponzio Pilato Over a year ago

How to run multiple seeder? Just multiple single call or I can pass an array to $this->seed()?

Jay K Oct 21 at 21:56

Since version 8, you can pass in an array of seeder classes to $this->seed([...]);

Guillaume Boutin · Accepted Answer · 2018-10-12 16:20:35Z

22

The DatabaseSeeder can be instantiated on its own, and its call method is public.

All you need to do in your CourseTypesTest class would be

(new DatabaseSeeder())->call(TestDatabaseSeeder::class);

Or you can make use of Laravel's app helper as follow

app(DatabaseSeeder::class)->call(TestDatabaseSeeder::class);

answered Oct 12, 2018 at 16:20

Guillaume Boutin

4655 silver badges5 bronze badges

Comments

miken32 · Accepted Answer · 2018-11-09 21:57:05Z

13

The problem is empty space in your --class argument. If you take close look at array '--class' => 'TestDatabaseSeeder ' there is space in the end ... this is the problem. Change it to '--class' => 'TestDatabaseSeeder' and it should work fine.

edited Nov 9, 2018 at 21:57

miken32

42.5k16 gold badges127 silver badges177 bronze badges

answered Jan 22, 2017 at 12:43

Bostjan

8247 silver badges11 bronze badges

2 Comments

gandra404 Over a year ago

Congrat! Empty space .. great :)

pablorsk Over a year ago

If you like migrate only one time your data, check this stackoverflow.com/questions/21893698/…

Eszter Czotter · Accepted Answer · 2024-06-17 05:25:18Z

For those stumbling on this question recently and are using a newer version of Laravel, ever since Laravel 8.0 there is a simpler way to do this.

If you use the Framework's provided base test case Illuminate\Foundation\Testing\TestCase and you use any of the db traits, such as Illuminate\Foundation\Testing\RefreshDatabase, you can just add a protected $seed = true; property to your tests and it will seed the db when doing the migrations.

Example from the documentation:

<?php
 
namespace Tests;
 
use Illuminate\Foundation\Testing\TestCase as BaseTestCase;
use Illuminate\Foundation\Testing\RefreshDatabase;
 
abstract class TestCase extends BaseTestCase
{
    use RefreshDatabase;

    /**
     * Indicates whether the default seeder should run before each test.
     *
     * @var bool
     */
    protected $seed = true;
}

Orici · Accepted Answer · 2024-03-31 11:21:16Z

0

Refresh your database with Artisan:

Artisan::call('migrate:fresh --seed');

This command removes your tables, creates the tables again (runs the migrations) and then seeds the tables with clean data.

answered Mar 31, 2024 at 11:21

Orici

4316 silver badges13 bronze badges

Comments

Madel M6TM · Accepted Answer · 2022-07-07 03:28:12Z

-4

You can try this way. You can execute this command when you run your test.

answered Jul 7, 2022 at 3:28

Madel M6TM

433 bronze badges

1 Comment

Dwight Over a year ago

Please include the source code in the answer body instead of using an image.

Collectives™ on Stack Overflow

How to Run Laravel Database Seeder from PHPUnit Test setUp?

6 Answers 6

2 Comments

Comments

2 Comments

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

2 Comments

Comments

2 Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related