使用Laravel 5.5模型工厂播种数据透视表-mb_strtolower()期望参数1为字符串,给定数组 [英] Seeding pivot table with Laravel 5.5 model factory - mb_strtolower() expects parameter 1 to be string, array given
问题描述
鉴于我有以下表格:
- 用户
- 问题
- 标签
- question_tag
my pivot table with two fields: question_id & tag_id
- users
- questions
- tags
- question_tag
my pivot table with two fields: question_id & tag_id
和我的 App \ Question 模型具有以下关系:
and my App\Question model has the following relationships:
class Question extends Model
{
public function user()
{
return $this->belongsTo(User::class);
}
public function tags()
{
return $this->hasMany(Tag::class);
}
}
我创建了以下工厂:
database/factories/UserFactory.php
$factory->define(App\User::class, function (Faker $faker) {
static $password;
return [
'name' => $faker->name,
'email' => $faker->unique()->safeEmail,
'password' => $password ?: $password = bcrypt('123456')
];
});
database/factories/QuestionFactory.php
$factory->define(App\Question::class, function (Faker $faker) {
static $user_id;
return [
'user_id' => $user_id,
'subject' => $faker->sentence(15),
'body' => $faker->paragraph(10)
];
});
database/factories/TagFactory.php
$factory->define(App\Tag::class, function (Faker $faker) {
return [
'name' => str_slug($faker->words(mt_rand(1, 2))),
'description' => $faker->sentence()
];
});
我试图像这样在虚拟数据播种器中一起使用它们:
I tried to use it all together in my dummy data seeder like this:
class DummyDataSeeder extends Seeder
{
public function run()
{
// Seed dummy users
factory(App\User::class, 10)->create()->each(function($user)
{
// With dummy questions
$user->questions()->saveMany(factory(App\Question::class, 10)->make()->each(function($question)
{
// With dummy tags
$question->tags()->sync(factory(App\Tag::class, 3)->make());
}));
});
}
}
运行播种机时,出现以下错误:
When I run the seeder, I get the following error:
[ErrorException] mb_strtolower()期望参数1为字符串, 给定数组
[ErrorException] mb_strtolower() expects parameter 1 to be string, array given
在模型工厂中这不可能吗?我需要使用其他方法吗?
Is this not possible to do in model factory? Do I need to use a different approach?
推荐答案
我认为您需要对数据透视表使用belongsToMany
I think you need to use belongsToMany for your pivot Table
在您的问题模型中
public function tags()
{
return $this->belongsToMany(Tag::class,'question_tag','tag_id','question_id');
}
与您的标记模型相同
public function questions()
{
return $this->belongsToMany(Question::class,'question_tag','question_id','tag_id');
}
另外,您需要更改
$question->tags()->sync(factory(App\Tag::class, 3)->make());
到
$tags = factory(App\Tag::class, 3)->make();
$tagIds = Tag::select('id')->get()->toArray();
$question->tags()->sync($tagIds);
这意味着您需要在Sync参数中传递ID.
which means you need to pass IDs in Sync argument.
这篇关于使用Laravel 5.5模型工厂播种数据透视表-mb_strtolower()期望参数1为字符串,给定数组的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!