php - 一般错误 : 1 no such table: users in Laravel Unit Test

Question

我创建了以下单元测试:

    <?php

    namespace Tests\Unit;

    use Tests\TestCase;
    use App\User;
    use App\Organization;

    class UserTest extends TestCase
    {
        public function testUserHasOwnedOrganization()
        {
            $user = factory(User::class)->create();
            $organization = factory(Organization::class)->create([
                'organizer_id' => $user->id,
            ]);

            $this->assertContains($organization, $user->owned_organizations);
        }
    }

当我运行它时，我得到:

SQLSTATE[HY000]: General error: 1 no such table: users

然而，当我打开 php artisan tinker :

>>> factory(App\User::class)->create()
=> App\User {#3048
     name: "Margret Armstrong",
     email: "shanel.cormier@example.net",
     email_verified_at: "2020-05-18 01:22:30",
     updated_at: "2020-05-18 01:22:30",
     created_at: "2020-05-18 01:22:30",
     id: 1,
   }

很明显，工厂在工作， table 存在。

这里发生了什么？

谢谢，

Answer 1

当您以一种或另一种方式运行测试时，您将需要迁移数据库。

一种常见的方法是利用 RefreshDatabase特征。

<?php

namespace Tests\Unit;

use Tests\TestCase;
use App\User;
use App\Organization;
use Illuminate\Foundation\Testing\RefreshDatabase;

class UserTest extends TestCase
{
    use RefreshDatabase;

    public function testUserHasOwnedOrganization()
    {
        $user = factory(User::class)->create();
        $organization = factory(Organization::class)->create([
            'organizer_id' => $user->id,
        ]);

        $this->assertContains($organization, $user->owned_organizations);
    }
}

看看能不能帮到你。

您可以在此处找到有关它的更多信息:
https://laravel.com/docs/7.x/database-testing