Laravel 9.x中如何有序填充数据表以避免完整性约束冲突

我有一个书店项目，包含publishers（出版社）和books（书籍）两张数据表，对应的迁移文件如下：

Books表迁移文件 #

<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateBooksTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('books', function (Blueprint $table) {
            $table->bigIncrements('id');
            $table->string('name');
            $table->integer('available_quantity');
            $table->string('isbn');
            $table->string('language');
            $table->integer('total_pages');
            $table->float('price');
            $table->string('book_image');
            $table->string('description')->nullable();
            $table->date('published_date');
            $table->unsignedBigInteger('publisher_id');
            $table->foreign('publisher_id')->references('id')->on('publishers');
            $table->unique('isbn');
            $table->softDeletes();
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('books');
    }
}

Publishers表迁移文件 #

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('publishers', function (Blueprint $table) {
            $table->bigIncrements('id');
            $table->string('name')->unique();
            $table->string('address');
            $table->string('phone');
            $table->string('description')->nullable();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('publishers');
    }
};

由于books表的publisher_id字段是关联publishers表id的外键，执行php artisan db:seed时必须先填充publishers表，再填充books表，否则会触发数据库完整性约束冲突。以下是几种实现有序填充的方法：

方法1：根填充类指定执行顺序 #

Laravel默认的DatabaseSeeder是所有填充类的入口，你可以在它的run方法里明确指定填充顺序，确保出版社数据先被插入：

<?php

namespace Database\Seeders;

use Illuminate\Database\Seeder;

class DatabaseSeeder extends Seeder
{
    public function run()
    {
        // 优先填充出版社数据
        $this->call(PublishersTableSeeder::class);
        // 再填充书籍数据
        $this->call(BooksTableSeeder::class);
    }
}

这样执行php artisan db:seed时，会严格按照你定义的顺序运行填充类，避免外键约束问题。

方法2：在书籍填充类中确保出版社数据存在 #

如果需要更灵活的控制，可以在BooksTableSeeder中先检查出版社表是否有数据，没有的话先执行出版社填充：

<?php

namespace Database\Seeders;

use Illuminate\Database\Seeder;
use App\Models\Book;
use App\Models\Publisher;

class BooksTableSeeder extends Seeder
{
    public function run()
    {
        // 若出版社表为空，先执行填充
        if (Publisher::count() === 0) {
            $this->call(PublishersTableSeeder::class);
        }

        // 生成书籍时随机关联已存在的出版社ID
        Book::factory()
            ->count(50)
            ->make()
            ->each(function ($book) {
                $book->publisher_id = Publisher::inRandomOrder()->first()->id;
                $book->save();
            });
    }
}

这种方式即使单独运行BooksTableSeeder（php artisan db:seed --class=BooksTableSeeder），也不会出现外键错误。

方法3：利用模型工厂自动关联（推荐） #

如果使用Laravel的模型工厂，可以直接在书籍工厂中定义与出版社的关联，让Laravel自动处理依赖关系：

定义PublisherFactory #

<?php

namespace Database\Factories;

use App\Models\Publisher;
use Illuminate\Database\Eloquent\Factories\Factory;

class PublisherFactory extends Factory
{
    protected $model = Publisher::class;

    public function definition()
    {
        return [
            'name' => $this->faker->company,
            'address' => $this->faker->address,
            'phone' => $this->faker->phoneNumber,
            'description' => $this->faker->paragraph,
        ];
    }
}

定义BookFactory #

<?php

namespace Database\Factories;

use App\Models\Book;
use App\Models\Publisher;
use Illuminate\Database\Eloquent\Factories\Factory;

class BookFactory extends Factory
{
    protected $model = Book::class;

    public function definition()
    {
        return [
            'name' => $this->faker->sentence(3),
            'available_quantity' => $this->faker->numberBetween(1, 100),
            'isbn' => $this->faker->unique()->isbn13,
            'language' => $this->faker->languageCode,
            'total_pages' => $this->faker->numberBetween(100, 1000),
            'price' => $this->faker->randomFloat(2, 10, 200),
            'book_image' => $this->faker->imageUrl(),
            'description' => $this->faker->paragraph,
            'published_date' => $this->faker->date(),
            // 自动创建并关联出版社，无需手动处理顺序
            'publisher_id' => Publisher::factory(),
        ];
    }
}

在DatabaseSeeder中使用 #

<?php

namespace Database\Seeders;

use Illuminate\Database\Seeder;
use App\Models\Publisher;
use App\Models\Book;

class DatabaseSeeder extends Seeder
{
    public function run()
    {
        // 可选：先批量创建一批出版社，书籍会从中随机关联
        Publisher::factory()->count(10)->create();
        // 创建书籍时，若出版社不足则自动创建新的
        Book::factory()->count(50)->create();
    }
}

这种方式最简洁，Laravel会自动处理关联数据的创建顺序，无需手动控制。

内容的提问来源于stack exchange，提问作者Phú Huỳnh Gia