laravel 数据填充，如何优化这段代码？

Question

在数据填充时遇到问题，之前都是采用随机数据填充，使用 laravel 模型工厂以及 Faker\Generator 生成随机数据。非常方便。但是我想在程序初始化时，填入一些由我提供的数据，而非随机数据。 假设：我提供的数据为 $name。我有两张表，categories 和 navigations ，两张表存在关联关系，navigations.category_id 对应 categories.id 。我的想法如代码所示，虽然能成功写入数据，但是感觉不好，感谢大佬们提供思路。 代码如下： <?php use Illuminate\Database\Seeder; use Illuminate\Support\Facades\DB; class CategoryTableSeeder extends Seeder { protected $name = [ 'php' => [ [ 'name' => 'php1', 'describe' => 'php1', 'icon' => 'php1' ], [ 'name' => 'php1', 'describe' => 'php1', 'icon' => 'php1' ], [ 'name' => 'php1', 'describe' => 'php1', 'icon' => 'php1' ], ], 'mysql' => [ [ 'name' => 'mysql1', 'describe' => 'mysql1', 'icon' => 'mysql1' ], [ 'name' => 'mysql1', 'describe' => 'mysql1', 'icon' => 'mysql1' ], [ 'name' => 'mysql1', 'describe' => 'mysql1', 'icon' => 'mysql1' ], ], 'vue' => [ [ 'name' => 'vue1', 'describe' => 'vue1', 'icon' => 'vue1' ], [ 'name' => 'vue1', 'describe' => 'vue1', 'icon' => 'vue1' ], [ 'name' => 'vue1', 'describe' => 'vue1', 'icon' => 'vue1' ], [ 'name' => 'vue1', 'describe' => 'vue1', 'icon' => 'vue1' ], [ 'name' => 'vue1', 'describe' => 'vue1', 'icon' => 'vue1' ], ], ]; /** * Run the database seeds. * * @return void */ public function run () { foreach ($this->name as $key => $value) { $id = DB::table('categories')->insertGetId([ 'name' => $key, 'type' => '1', 'created_at' => \Carbon\Carbon::now()->toDateTimeString(), 'updated_at' => \Carbon\Carbon::now()->toDateTimeString(), ]); foreach ($value as $k => $v) { DB::table('navigations')->insert([ 'category_id' => $id, 'name' => $v['name'], 'describe' => $v['describe'], 'icon' => $v['icon'], 'created_at' => \Carbon\Carbon::now()->toDateTimeString(), 'updated_at' => \Carbon\Carbon::now()->toDateTimeString(), ]); } } } }

Answer 1

假设你已经定义好了模型关联关系：

collect($this->name)->map(function () {$item, $category} {
    $categoryModel = Category::create($category);
    // 模型关联填充
    $categoryModel->navigations()->createMany($item);
});