php - Laravel中具有关系的种子数据
问题描述
我正在尝试Laravel 5.6
通过faker factory播种我的应用程序,我浏览了链接并且有点困惑,因为我有一些基本的静态数据,例如我有一个公司模型:
class Company extends Model {
use SoftDeletes, HasDataSearchTable, HasSlug;
protected $fillable = [
'name', 'code_link', 'slug', 'establishment', 'parent_id', 'website', 'updates', 'user_id', 'tracked', 'verified', 'active', 'premium', 'status'
];
/**
* The attributes that should be hidden for arrays.
*
* @var array
*/
protected $hidden = [
'created_at','updated_at','deleted_at'
];
public function roles()
{
return $this->belongsToMany('Noetic\Plugins\Conxn\Models\Variables\Company\Role', 'company_role_relation', 'company_id', 'role_id')->withTimestamps();
}
}
和一个关系角色模型:
class Role extends Model
{
use SoftDeletes , HasDataSearchTable;
protected $table='company_role';
protected $fillable = [
'name', 'parent_id'
];
/**
* The attributes that should be hidden for arrays.
*
* @var array
*/
protected $hidden = [
'created_at','updated_at','deleted_at'
];
}
和各自的数据库,我遵循 laravel 约定,现在我想播种数据:
我有一组特定的角色,我手动播种,
class CompanyRoleSeed extends Seeder
{
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
DB::table('company_role')->insert([
['name' => 'Contractor', 'parent_id' => null],
['name' => 'Consultant', 'parent_id' => null],
['name' => 'Manufacturer', 'parent_id' => null],
['name' => 'Miscellaneous', 'parent_id' => null],
['name' => 'Owner', 'parent_id' => null],
['name' => 'Supplier', 'parent_id' => null],
]);
}
}
对于我想创建工厂的公司,我做了:
$factory->define(Company::class, function (Faker $faker) {
return [
'name' => $faker->company,
'code_link' => rand(5, 10),
'slug' => str_slug($faker->company),
'about' => $faker->paragraphs(),
'establishment' => $faker->randomElement('2015', '2016', '2017', '2018'),
'parent_id' => $faker->randomElement(null, '1', '2', '3'),
'website' => $faker->url,
'user_id' => $faker->randomElement('1', '2', '3', '4', '5'),
'updates' => $faker->paragraphs(),
'tracked' => $faker->boolean,
'verified' => $faker->boolean,
'active' => $faker->boolean,
'premium' => $faker->boolean,
'status' => $faker->randomElement('saved', 'draft')
];
});
在公司种子中,我有:
class CompanySeed extends Seeder
{
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
factory(Company::class, 10)->create()->each(function ($company) {
$company->roles()->save(); // Don't now how to execute here
});
}
}
帮帮我$company->roles()->save();
到这里我该怎么办。
欢迎任何指导或即兴创作。
解决方案
您可以查询要分配给公司的角色并将它们与创建的记录相关联,如下所示:
class CompanySeed extends Seeder
{
public function run()
{
$contractorRole = Role::whereName('Contractor')->firstOrFail();
$ownerRole = Role::whereName('Owner')->firstOrFail();
factory(Company::class, 10)->create()->each(function ($company) use ($contractorRole, $ownerRole) {
$company->roles()->attach([
$contractorRole->id,
$ownerRole->id
]);
});
}
}
您可以查看文档以获取相关记录https://laravel.com/docs/5.6/eloquent-relationships#inserting-and-updating-related-models
推荐阅读
- python - 删除收集的静态文件
- python - seaborn pairplot不适用于单个图
- c# - 迁移不会创建数据库
- reactjs - 为 React Native 组合/嵌套/实现 Stack Navigator 和 Tab Navigator React Navigation 组件
- python - 我正在尝试在 python 的帐户页面上显示来自 Azure AD 的照片
- c - Do while 语句中的问题不断循环
- protobuf-net.grpc - 如何在反序列化期间检测环境
- eclipse - Tomcat 不加载 Maven 提供的依赖项
- java - Java 应用程序暂停执行,直到在 Linux RHEL 6 上“单击”控制台窗口
- javascript - 如何使用 JavaScript 计算字符串中不同术语出现的次数?