在Laravel迁移文件中填充数据库 [英] Populating a database in a Laravel migration file
问题描述
我正在学习Laravel，并且有一个有效的迁移文件创建了一个users表.我正在尝试在迁移过程中填充用户记录:
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.
有人知道吗?谢谢！
推荐答案
不要将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
)
);
}
这篇关于在Laravel迁移文件中填充数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
