entityMap|0|type|LINK|mutability|MUTABLE|data|url|https://stackoverflow.blog/2011/07/its-ok-to-ask-and-answer-your-own-questions/|1|https://github.com/laravel/framework/blob/v5.4.12/src/Illuminate/Foundation/Testing/DatabaseMigrations.php|2|https://github.com/laravel/framework/blob/v5.4.12/src/Illuminate/Foundation/Testing/TestCase.php#L69|3|https://github.com/laravel/framework/blob/v5.4.12/src/Illuminate/Foundation/Testing/DatabaseMigrations.php#L14|4|https://phpunit.de/manual/5.7/en/fixtures.html|5|http://andy-carter.com/blog/overriding-extending-a-php-trait-method|blocks|key|eehtr|text|我花了些功夫才弄明白，所以I+thought+I'd+share。|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|4snn0|如果你看一下DatabaseMigrations的源代码，你会发现它有一个由setUp调用的函数runDatabaseMigrations，这个函数被runs+before+every+test调用，并注册一个在teardown上运行的回调。|style|CODE|6eb9s|您可以通过为该函数添加别名来对其进行"extend"+the+trait排序，在原始名称下重新声明一个包含逻辑的新函数(artisan+db:seed)，并在其中调用别名。|erk3o|use+Illuminate\Foundation\Testing\DatabaseMigrations;

class+ExampleTest+extends+TestCase
{
++++use+DatabaseMigrations+{
++++++++runDatabaseMigrations+as+baseRunDatabaseMigrations;
++++}

++++/**
+++++*+Define+hooks+to+migrate+the+database+before+and+after+each+test.
+++++*
+++++*+@return+void
+++++*/
++++public+function+runDatabaseMigrations()
++++{
++++++++$this->baseRunDatabaseMigrations();
++++++++$this->artisan('db:seed');
++++}

++++/**
+++++*+A+basic+functional+test+example.
+++++*
+++++*+@return+void
+++++*/
++++public+function+testBasicExample()
++++{
++++++++$response+=+$this->get('/');

++++++++//+...
++++}
}|code-block|syntax|javascript|47dj6^0|D|J|0|0|6|I|12|5|1C|L|6|I|1|12|5|2|1C|L|3|23|M|4|0|1O|F|I|I|5|0|0^^$0|$1|$2|3|4|5|6|$7|8]]|9|$2|3|4|5|6|$7|A]]|B|$2|3|4|5|6|$7|C]]|D|$2|3|4|5|6|$7|E]]|F|$2|3|4|5|6|$7|G]]|H|$2|3|4|5|6|$7|I]]]|J|@$K|L|M|N|2|O|P|16|Q|@]|R|@$S|17|T|18|K|19]]|6|$]]|$K|U|M|V|2|O|P|1A|Q|@$S|1B|T|1C|W|X]|$S|1D|T|1E|W|X]|$S|1F|T|1G|W|X]]|R|@$S|1H|T|1I|K|1J]|$S|1K|T|1L|K|1M]|$S|1N|T|1O|K|1P]|$S|1Q|T|1R|K|1S]]|6|$]]|$K|Y|M|Z|2|O|P|1T|Q|@$S|1U|T|1V|W|X]]|R|@$S|1W|T|1X|K|1Y]]|6|$]]|$K|10|M|11|2|12|P|1Z|Q|@]|R|@]|6|$13|14]]|$K|15|M|-4|2|O|P|20|Q|@]|R|@]|6|$]]]]

It took me some digging to figure this out, so <a href="https://stackoverflow.blog/2011/07/its-ok-to-ask-and-answer-your-own-questions/">I thought I'd share</a>.

If you look at the source code for the <a href="https://github.com/laravel/framework/blob/v5.4.12/src/Illuminate/Foundation/Testing/DatabaseMigrations.php" rel="noreferrer"><code>DatabaseMigrations</code> trait</a>, then you'll see it has one function <a href="https://github.com/laravel/framework/blob/v5.4.12/src/Illuminate/Foundation/Testing/DatabaseMigrations.php#L14" rel="noreferrer"><code>runDatabaseMigrations</code></a> that's invoked by <a href="https://github.com/laravel/framework/blob/v5.4.12/src/Illuminate/Foundation/Testing/TestCase.php#L69" rel="noreferrer"><code>setUp</code></a> which <a href="https://phpunit.de/manual/5.7/en/fixtures.html" rel="noreferrer">runs before every test</a> and registers a callback to be run on teardown.

You can sort of <a href="http://andy-carter.com/blog/overriding-extending-a-php-trait-method" rel="noreferrer">"extend" the trait</a> by aliasing that function, re-declare a new function with your logic in it (<code>artisan db:seed</code>) under the original name, and call the alias inside it.

<pre><code>use Illuminate\Foundation\Testing\DatabaseMigrations;

class ExampleTest extends TestCase
{
 use DatabaseMigrations {
 runDatabaseMigrations as baseRunDatabaseMigrations;
 }

 /**
 * Define hooks to migrate the database before and after each test.
 *
 * @return void
 */
 public function runDatabaseMigrations()
 {
 $this-&gt;baseRunDatabaseMigrations();
 $this-&gt;artisan('db:seed');
 }

 /**
 * A basic functional test example.
 *
 * @return void
 */
 public function testBasicExample()
 {
 $response = $this-&gt;get('/');

 // ...
 }
}
</code></pre>

entityMap|blocks|key|4gk74|text|如果您希望绕过Artisan的原生DatabaseMigrations和种子器/移植方法，这里有一个替代解决方案。您可以创建自己的特征来为数据库提供种子：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|c47vb|namespace+App\Traits;

use+App\Models\User;
use+App\Models\UserType;

trait+DatabaseSetup+
{

++++public+function+seedDatabase()
++++{
++++++++$user+=+$this->createUser();
++++}

++++public+function+createUser()
++++{
++++++++return+factory(User::class)->create([
++++++++++++'user_type_id'+=>+function+()+{
++++++++++++++++return+factory(UserType::class)->create()->id;
++++++++++++}
++++++++]);
++++}

++++public+function+getVar()+{
++++++++return+'My+Data';
++++}
}|code-block|syntax|javascript|ksf4|然后在你的测试中像这样调用它：|4g7hd|use+App\Traits\DatabaseSetup;

class+MyAwesomeTest+extends+TestCase
{
++++use+DatabaseSetup;
++++use+DatabaseTransactions;

++++protected+$reusableVar;

++++public+function+setUp()
++++{
++++++++parent::setUp();
++++++++$this->seedDatabase();
++++++++$this->reusableVar+=+$this->getVar();
++++}

++++/**
+++++*+@test
+++++*/
++++public+function+test_if_it_is_working()
++++{
++++++++$anotherUser+=+$this->createUser();
++++++++$response+=+$this->get('/');
++++++++$this->seeStatusCode(200);
++++}

}|5l1mi^0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|M|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|N|9|@]|A|@]|B|$F|G]]|$2|H|4|I|6|7|8|O|9|@]|A|@]|B|$]]|$2|J|4|K|6|E|8|P|9|@]|A|@]|B|$F|G]]|$2|L|4|-4|6|7|8|Q|9|@]|A|@]|B|$]]]]

Here is an alternate solution, in case you prefer to bypass Artisan's native DatabaseMigrations and seeder/migration methods. You can create your own trait to seed your database:

<pre><code>namespace App\Traits;

use App\Models\User;
use App\Models\UserType;

trait DatabaseSetup 
{

 public function seedDatabase()
 {
 $user = $this-&gt;createUser();
 }

 public function createUser()
 {
 return factory(User::class)-&gt;create([
 'user_type_id' =&gt; function () {
 return factory(UserType::class)-&gt;create()-&gt;id;
 }
 ]);
 }

 public function getVar() {
 return 'My Data';
 }
}
</code></pre>

Then call it in your test like this: 

<pre><code>use App\Traits\DatabaseSetup;

class MyAwesomeTest extends TestCase
{
 use DatabaseSetup;
 use DatabaseTransactions;

 protected $reusableVar;

 public function setUp()
 {
 parent::setUp();
 $this-&gt;seedDatabase();
 $this-&gt;reusableVar = $this-&gt;getVar();
 }

 /**
 * @test
 */
 public function test_if_it_is_working()
 {
 $anotherUser = $this-&gt;createUser();
 $response = $this-&gt;get('/');
 $this-&gt;seeStatusCode(200);
 }

}
</code></pre>

entityMap|0|type|LINK|mutability|MUTABLE|data|url|https://laravel.com/docs/5.6/testing#creating-and-running-tests|blocks|key|55s7u|text|您所需要做的就是在setUp函数中调用db:seed|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|9uf4j|<?php

use+Illuminate\Foundation\Testing\DatabaseMigrations;

class+ExampleTest+extends+TestCase
{
++++use+DatabaseMigrations;

++++public+function+setUp():+void
++++{
++++++++parent::setUp();

++++++++//+seed+the+database
++++++++$this->artisan('db:seed');
++++++++//+alternatively+you+can+call
++++++++//+$this->seed();
++++}

++++/**
+++++*+A+basic+functional+test+example.
+++++*
+++++*+@return+void
+++++*/
++++public+function+testBasicExample()
++++{
++++++++$response+=+$this->get('/');

++++++++//+...
++++}
}|code-block|syntax|javascript|oce7|参考：https://laravel.com/docs/5.6/testing#creating-and-running-tests|6thal^0|J|7|0|0|3|1R|0|0^^$0|$1|$2|3|4|5|6|$7|8]]]|9|@$A|B|C|D|2|E|F|U|G|@$H|V|I|W|J|K]]|L|@]|6|$]]|$A|M|C|N|2|O|F|X|G|@]|L|@]|6|$P|Q]]|$A|R|C|S|2|E|F|Y|G|@]|L|@$H|Z|I|10|A|11]]|6|$]]|$A|T|C|-4|2|E|F|12|G|@]|L|@]|6|$]]]]

All you need to do is make an artisan call <code>db:seed</code> in the setUp function

<pre><code>&lt;?php

use Illuminate\Foundation\Testing\DatabaseMigrations;

class ExampleTest extends TestCase
{
 use DatabaseMigrations;

 public function setUp(): void
 {
 parent::setUp();

 // seed the database
 $this-&gt;artisan('db:seed');
 // alternatively you can call
 // $this-&gt;seed();
 }

 /**
 * A basic functional test example.
 *
 * @return void
 */
 public function testBasicExample()
 {
 $response = $this-&gt;get('/');

 // ...
 }
}
</code></pre>

ref: <a href="https://laravel.com/docs/5.6/testing#creating-and-running-tests" rel="noreferrer">https://laravel.com/docs/5.6/testing#creating-and-running-tests</a>

entityMap|0|type|LINK|mutability|MUTABLE|data|url|https://laravel.com/api/5.7/Illuminate/Foundation/Testing/TestCase.html#method_seed|blocks|key|cfrtm|text|我知道这个问题已经被回答了好几次了，但我没有看到这个特定的答案，所以我想我应该把它扔进去。|unstyled|depth|inlineStyleRanges|entityRanges|963en|在laravel中有一段时间(至少从v5.5开始)，TestCase类中有一个专门用于调用数据库种子的方法：|offset|length|style|CODE|9tr08|https://laravel.com/api/5.7/Illuminate/Foundation/Testing/TestCase.html#method|r581|使用这种方法，您只需要调用$this->seed('MySeederName');来触发播种器。|6a40k|因此，如果您希望在每次测试之前触发此种子程序，可以将以下setUp函数添加到您的测试类中：|3mi52|public+function+setUp()
{
++++parent::setUp();
++++$this->seed('MySeederName');
}|code-block|syntax|javascript|f6aom|最终结果如下所示：|bhjnn|+$this->artisan('db:seed',['--class'+=>+'MySeederName'])|4booq|或者|2acvo|Artisan::call('db:seed',+['--class'+=>+'MySeederName'])|f05gt|但是语法更清晰一些(在我看来)。|er5t5^0|0|Q|8|0|0|26|0|0|D|S|0|0|0|0|0|0|0|0^^$0|$1|$2|3|4|5|6|$7|8]]]|9|@$A|B|C|D|2|E|F|1A|G|@]|H|@]|6|$]]|$A|I|C|J|2|E|F|1B|G|@$K|1C|L|1D|M|N]]|H|@]|6|$]]|$A|O|C|P|2|E|F|1E|G|@]|H|@$K|1F|L|1G|A|1H]]|6|$]]|$A|Q|C|R|2|E|F|1I|G|@$K|1J|L|1K|M|N]]|H|@]|6|$]]|$A|S|C|T|2|E|F|1L|G|@]|H|@]|6|$]]|$A|U|C|V|2|W|F|1M|G|@]|H|@]|6|$X|Y]]|$A|Z|C|10|2|E|F|1N|G|@]|H|@]|6|$]]|$A|11|C|12|2|W|F|1O|G|@]|H|@]|6|$X|Y]]|$A|13|C|14|2|E|F|1P|G|@]|H|@]|6|$]]|$A|15|C|16|2|W|F|1Q|G|@]|H|@]|6|$X|Y]]|$A|17|C|18|2|E|F|1R|G|@]|H|@]|6|$]]|$A|19|C|-4|2|E|F|1S|G|@]|H|@]|6|$]]]]

I know this question has already been answered several times, but I didn't see this particular answer so I thought I'd throw it in. 

For a while in laravel (at least since v5.5), there's been a method in the <code>TestCase</code> class specifically used for calling a database seeder:

<a href="https://laravel.com/api/5.7/Illuminate/Foundation/Testing/TestCase.html#method_seed" rel="noreferrer">https://laravel.com/api/5.7/Illuminate/Foundation/Testing/TestCase.html#method_seed</a>

with this method, you just need to call <code>$this-&gt;seed('MySeederName');</code> to fire the seeder.

So if you want this seeder to fire before every test, you can add the following setUp function to your test class:

<pre><code>public function setUp()
{
 parent::setUp();
 $this-&gt;seed('MySeederName');
}
</code></pre>

The end result is the same as:

<pre><code> $this-&gt;artisan('db:seed',['--class' =&gt; 'MySeederName'])
</code></pre>

or 

<pre><code>Artisan::call('db:seed', ['--class' =&gt; 'MySeederName'])
</code></pre>

But the syntax is a bit cleaner (in my opinion).

entityMap|blocks|key|50ue4|text|如果您使用的是RefreshDatabase测试特性：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|73eru|abstract+class+TestCase+extends+BaseTestCase
{
++++use+CreatesApplication,+RefreshDatabase+{
++++++++refreshDatabase+as+baseRefreshDatabase;
++++}

++++public+function+refreshDatabase()
++++{
++++++++$this->baseRefreshDatabase();

++++++++//+Seed+the+database+on+every+database+refresh.
++++++++$this->artisan('db:seed');
++++}
}|code-block|syntax|javascript|8sph0^0|7|F|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|M|9|@$A|N|B|O|C|D]]|E|@]|F|$]]|$2|G|4|H|6|I|8|P|9|@]|E|@]|F|$J|K]]|$2|L|4|-4|6|7|8|Q|9|@]|E|@]|F|$]]]]

If you're using the <code>RefreshDatabase</code> testing trait:

<pre><code>abstract class TestCase extends BaseTestCase
{
 use CreatesApplication, RefreshDatabase {
 refreshDatabase as baseRefreshDatabase;
 }

 public function refreshDatabase()
 {
 $this-&gt;baseRefreshDatabase();

 // Seed the database on every database refresh.
 $this-&gt;artisan('db:seed');
 }
}
</code></pre>

entityMap|0|type|LINK|mutability|MUTABLE|data|url|https://laravel.com/docs/8.x/database-testing#running-seeders|blocks|key|d92cd|text|在Laravel+8中，如果您使用的是RefreshDatabase特征，则可以使用以下命令从测试用例中调用种子：|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|70kc4|use+Illuminate\Foundation\Testing\RefreshDatabase;

class+ExampleTest+extends+TestCase
{
++++use+RefreshDatabase;

++++/**
+++++*+A+basic+functional+test+example.
+++++*
+++++*+@return+void
+++++*/
++++public+function+testBasicExample()
++++{
++++++++//+Run+the+DatabaseSeeder...
++++++++$this->seed();

++++++++//+Run+a+specific+seeder...
++++++++$this->seed(OrderStatusSeeder::class);

++++++++$response+=+$this->get('/');

++++++++//+...
++++}
}|code-block|syntax|javascript|afde9|有关更多信息/示例，请参阅文档：https://laravel.com/docs/8.x/database-testing#running-seeders|61uaa^0|J|F|0|0|G|1P|0|0^^$0|$1|$2|3|4|5|6|$7|8]]]|9|@$A|B|C|D|2|E|F|U|G|@$H|V|I|W|J|K]]|L|@]|6|$]]|$A|M|C|N|2|O|F|X|G|@]|L|@]|6|$P|Q]]|$A|R|C|S|2|E|F|Y|G|@]|L|@$H|Z|I|10|A|11]]|6|$]]|$A|T|C|-4|2|E|F|12|G|@]|L|@]|6|$]]]]

With Laravel 8, if you're using the <code>RefreshDatabase</code> trait you can invoke seeding from your test case using below:
<pre><code>use Illuminate\Foundation\Testing\RefreshDatabase;

class ExampleTest extends TestCase
{
 use RefreshDatabase;

 /**
 * A basic functional test example.
 *
 * @return void
 */
 public function testBasicExample()
 {
 // Run the DatabaseSeeder...
 $this-&gt;seed();

 // Run a specific seeder...
 $this-&gt;seed(OrderStatusSeeder::class);

 $response = $this-&gt;get('/');

 // ...
 }
}
</code></pre>
see docs for more information/examples:
<a href="https://laravel.com/docs/8.x/database-testing#running-seeders" rel="noreferrer">https://laravel.com/docs/8.x/database-testing#running-seeders</a>

entityMap|blocks|key|dst0e|text|对于Laravel+8，RefreshDatabase现在正在寻找一个名为"seed“的布尔属性。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|c7il3|++++/**+
+++++*+Illuminate\Foundation\Testing\RefreshDatabase
+++++*+Determine+if+the+seed+task+should+be+run+when+refreshing+the+database.
+++++*
+++++*+@return+bool
+++++*/
++++protected+function+shouldSeed()
++++{
++++++++return+property_exists($this,+'seed')+?+$this->seed+:+false;
++++}|code-block|syntax|javascript|al8rh|只需为您的测试类提供受保护的属性$seed，并将其设置为true+。|1dt7|class+ProjectControllerTest+extends+TestCase
{

++++protected+$seed+=+true;
++++public+function+testCreateProject()
++++{
++++++++$project+=+Project::InRandomOrder()->first();
++++++++$this->assertInstanceOf($project,Project::class);
++++}|futb8|这种方法的好处是，单独的测试不会在每次运行时都进行播种。只有种子必要的测试才会建立数据库。|fetv^0|0|0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|O|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|P|9|@]|A|@]|B|$F|G]]|$2|H|4|I|6|7|8|Q|9|@]|A|@]|B|$]]|$2|J|4|K|6|E|8|R|9|@]|A|@]|B|$F|G]]|$2|L|4|M|6|7|8|S|9|@]|A|@]|B|$]]|$2|N|4|-4|6|7|8|T|9|@]|A|@]|B|$]]]]

With Laravel 8, the RefreshDatabase is now looking for a boolean property called &quot;seed&quot;.
<pre><code> /** 
 * Illuminate\Foundation\Testing\RefreshDatabase
 * Determine if the seed task should be run when refreshing the database.
 *
 * @return bool
 */
 protected function shouldSeed()
 {
 return property_exists($this, 'seed') ? $this-&gt;seed : false;
 }
</code></pre>
Simply give your test class the protected property $seed and set it to true if you wish to seed.
<pre><code>class ProjectControllerTest extends TestCase
{

 protected $seed = true;
 public function testCreateProject()
 {
 $project = Project::InRandomOrder()-&gt;first();
 $this-&gt;assertInstanceOf($project,Project::class);
 }
</code></pre>
The nice part about this method is that individual tests won't seed everytime they are ran. Only seed necessary test will build the database.

Laravel's <a href="https://laravel.com/docs/5.4/database-testing#resetting-the-database-after-each-test" rel="noreferrer">documentation</a> recommends using the <code>DatabaseMigrations</code> trait for migrating and rolling back the database between tests.

<pre><code>use Illuminate\Foundation\Testing\DatabaseMigrations;

class ExampleTest extends TestCase
{
 use DatabaseMigrations;

 /**
 * A basic functional test example.
 *
 * @return void
 */
 public function testBasicExample()
 {
 $response = $this-&gt;get('/');

 // ...
 }
}
</code></pre>

However, I've got some seed data that I would like to use with my tests. If I run:

<pre><code>php artisan migrate --seed
</code></pre>

then it works for the first test, but it fails subsequent tests. This is because the trait rolls back the migration, and when it runs the migration again, it doesn't seed the database. How can I run the database seeds with the migration?

How to seed database migrations for laravel tests?

数据库

 Laravel的documentation建议使用DatabaseMigrations特征在测试之间迁移和回滚数据库。 use Illuminate\Foundation\Testing\DatabaseMigrations;class ExampleTest extends TestCase{    use Dat...

问如何为laravel测试播种数据库迁移？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何为laravel测试播种数据库迁移？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何为laravel测试播种数据库迁移？
EN