如何用laravel工厂将数据添加到相关表中

Question

在laravel 8应用程序中，我为带有工厂的广告表添加了伪数据：

$ads = Ad::factory()->count(10)->expired($year, $month)->create([
]);

与数据库/工厂/AdFactory.php:

<?php
namespace DatabaseFactories;
use Config;
use CarbonCarbon;
use AppModelsAd;
use IlluminateDatabaseEloquentFactoriesFactory;
use IlluminateSupportStr;
use CviebrockEloquentSluggableServicesSlugService;
class AdFactory extends Factory
{
protected $model = Ad::class;
public function definition()
{
$text= $this->faker->text;
$slugValue = SlugService::createSlug(Ad::class, 'slug', $text);
return [
'title' => $text,
'ad_token' => $text,
'slug' => $slugValue,
'phone_display' => (rand(1, 3) == 1),
'has_locations' => (rand(1, 4) == 1),
'status' => 'A',
'price' => mt_rand(10, 500),
'ad_type' => (rand(1, 2) == 1 ? 'B' : 'S'),
'description' => $this->faker->paragraphs(rand(1, 4), true),
'creator_id' => rand(1, 5),
];
}
public function expired($year, $month)
{
return $this->state(function (array $attributes) use($year, $month) {
$dateStr= $year.'-'.str_pad($month, 2, "0", STR_PAD_LEFT).'-01';
$startDate= Carbon::createFromFormat('Y-m-d', $dateStr);
return [
'expire_date' => $this->faker->dateTimeInInterval($startDate, '1 month', Config::get('app.timezone'))->format('Y-m-d H:i:s')
];
});
}
}

它工作正常，但我想知道如何将伪数据添加到相关的ad_categories(有ad_id字段(中？definition方法返回ad对象(带有新id(，在哪里可以访问它？

谢谢！

Answer 1

您可以创建一个CategoryFactory类并创建Dummy类别，然后选择一个随机类别作为category_id

对于一对多关系

//...
public function definition()
{
return [
//your code
'creatory_id' => $this->faker->randomElement(Category::all())['id'],
];
}
//...

或

public function definition()
{
return [
//your code
'creatory_id' => factory(Category::class)->create()->id,
];
}

第二个解决方案将为每个广告创建一个新的类别

对于多对多关系

namespace DatabaseFactories;
use AppModelsAdFactory;
use AppModelsCategory;
use IlluminateDatabaseEloquentFactoriesFactory;
use IlluminateSupportStr;
class AdFactory extends Factory
{
/**
* The name of the factory's corresponding model.
*
* @var string
*/
protected $model = Ad::class;
/**
* Configure the model factory.
*
* @return $this
*/
public function configure()
{
return $this->afterCreating(function (Ad $newAd) { 
$adCategory = AdCategory::factory()->count(1)->create([ 'ad_id' => $newAd->id, 'category_id' => $this->faker->randomElement(Category::all())['id']); 
}); 
}
// ...
}

欲了解更多信息，请访问https://laravel.com/docs/8.x/database-testing#factory-回调

以及https://laravel.com/docs/8.x/database-testing#polymorphic-多对多关系