在 Laravel 迁移文件中填充数据库

2022-01-23 00:00:00 migration php laravel mysql-error-1146

我刚刚学习 Laravel，并且有一个工作迁移文件创建一个用户表.作为迁移的一部分，我正在尝试填充用户记录:

I'm just learning Laravel, and have a working migration file creating a users table. I am trying to populate a user record as part of the migration:

public function up()
{
    Schema::create('users', function($table){

        $table->increments('id');
        $table->string('email', 255);
        $table->string('password', 64);
        $table->boolean('verified');
        $table->string('token', 255);
        $table->timestamps();

        DB::table('users')->insert(
            array(
                'email' => 'name@domain.com',
                'verified' => true
            )
        );

    });
}

但是运行 php artisan migrate 时出现以下错误:

But I'm getting the following error when running php artisan migrate:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'vantage.users' doesn't exist

这显然是因为 Artisan 尚未创建表，但所有文档似乎都说有一种方法可以使用 Fluent Query 来填充数据作为迁移的一部分.

This is obviously because Artisan hasn't yet created the table, but all the documentation seems to say that there is a way of using Fluent Query to populate data as part of a migration.

有人知道怎么做吗?谢谢！

Anyone know how? Thanks!

推荐答案

不要把 DB::insert() 放在 Schema::create() 里面，因为 create 方法必须先完成建表可以插入东西.试试这个:

Don't put the DB::insert() inside of the Schema::create(), because the create method has to finish making the table before you can insert stuff. Try this instead:

public function up()
{
    // Create the table
    Schema::create('users', function($table){
        $table->increments('id');
        $table->string('email', 255);
        $table->string('password', 64);
        $table->boolean('verified');
        $table->string('token', 255);
        $table->timestamps();
    });

    // Insert some stuff
    DB::table('users')->insert(
        array(
            'email' => 'name@domain.com',
            'verified' => true
        )
    );
}

相关文章