每当数据库种子出现问题时,Laravel 4.1似乎都会删除异常"类DateTime的对象无法转换为字符串"。
例如,假设我运行这个播种机:
use FakerFactory as Faker;
class OrdersTableSeeder extends Seeder {
public function run()
{
$f = Faker::create();
foreach(range(1, 10) as $index)
{
$c = Customer::leftJoin('orders', function($join) {
$join->on('customers.id', '=', 'orders.customer_id');
})
->whereNull('orders.customer_id')
->first();
if (!empty($c)) {
Order::create([
'amazon_order_id' => rand(100, 999) . '-' . rand(1000000, 9999999) . '-' . rand(1000000, 9999999),
'customer_id' => $c->id,
'total' => rand(10, 100) . '.' . rand(1, 99),
'subtotal' => rand(10, 100) . '.' . rand(1, 99),
'first_name' => $c->first_name,
'last_name' => $c->last_name,
'address1' => $c->address1,
'address2' => $c->address2,
'address3' => $c->address3,
'city' => $c->city,
'state' => $c->state,
'county' => $c->county,
'district' => $c->district,
'postal_code' => $c->postalcode,
'country' => $c->country,
'ship_level' => array_rand(['Standard', 'Second', 'Next'], 1),
'status' => array_rand(['Shipped', 'Unshipped', 'Pending'], 1),
'order_date' => $f->dateTime,
'notes' => array_rand(['', $f->text(128)], 1)
]);
}
}
}
}
此播种机具有以下迁移up()
功能:
public function up()
{
Schema::create('orders', function(Blueprint $table)
{
$table->increments('id');
$table->string('amazon_order_id', 19)->unique();
$table->unsignedInteger('customer_id')->references('id')->on('customers');
$table->decimal('total', 8, 2)->index();
$table->decimal('subtotal', 8, 2);
$table->string('first_name')->index();
$table->string('last_name')->index();
$table->string('address1');
$table->string('address2');
$table->string('address3');
$table->string('city');
$table->string('state');
$table->string('county');
$table->string('district');
$table->string('postal_code');
$table->string('country', 2);
$table->string('ship_level');
$table->string('status')->index();
$table->dateTime('order_date')->index();
$table->text('notes');
$table->timestamps();
});
}
以下是php artisan db:seed -vvv
:的输出
Exception trace:
() at C:Amppswwwmysite.devvendorlaravelframeworksrcIlluminateSupporthelpers.php:975
IlluminateExceptionHandler->handleError() at n/a:n/a
preg_replace() at C:Amppswwwmysite.devvendorlaravelframeworksrcIlluminateSupporthelpers.php:975
str_replace_array() at C:Amppswwwmysite.devvendorlaravelframeworksrcIlluminateDatabaseQueryException.php:53
IlluminateDatabaseQueryException->formatMessage() at C:Amppswwwmysite.devvendorlaravelframeworksrcIlluminateDatabaseQueryException.php:35
IlluminateDatabaseQueryException->__construct() at C:Amppswwwmysite.devvendorlaravelframeworksrcIlluminateDatabaseConnection.php:555
IlluminateDatabaseConnection->run() at C:Amppswwwmysite.devvendorlaravelframeworksrcIlluminateDatabaseConnection.php:338
IlluminateDatabaseConnection->statement() at C:Amppswwwmysite.devvendorlaravelframeworksrcIlluminateDatabaseConnection.php:295
IlluminateDatabaseConnection->insert() at C:Amppswwwmysite.devvendorlaravelframeworksrcIlluminateDatabaseQueryProcessorsProcessor.php:30
IlluminateDatabaseQueryProcessorsProcessor->processInsertGetId() at C:Amppswwwmysite.devvendorlaravelframeworksrcIlluminateDatabaseQueryBuilder.php:1724
IlluminateDatabaseQueryBuilder->insertGetId() at n/a:n/a
call_user_func_array() at C:Amppswwwmysite.devvendorlaravelframeworksrcIlluminateDatabaseEloquentBuilder.php:919
IlluminateDatabaseEloquentBuilder->__call() at C:Amppswwwmysite.devvendorlaravelframeworksrcIlluminateDatabaseEloquentModel.php:1502
IlluminateDatabaseEloquentBuilder->insertGetId() at C:Amppswwwmysite.devvendorlaravelframeworksrcIlluminateDatabaseEloquentModel.php:1502
IlluminateDatabaseEloquentModel->insertAndSetId() at C:Amppswwwmysite.devvendorlaravelframeworksrcIlluminateDatabaseEloquentModel.php:1472
IlluminateDatabaseEloquentModel->performInsert() at C:Amppswwwmysite.devvendorlaravelframeworksrcIlluminateDatabaseEloquentModel.php:1383
IlluminateDatabaseEloquentModel->save() at C:Amppswwwmysite.devvendorlaravelframeworksrcIlluminateDatabaseEloquentModel.php:459
IlluminateDatabaseEloquentModel::create() at C:Amppswwwmysite.devappdatabaseseedsOrdersTableSeeder.php:41
OrdersTableSeeder->run() at C:Amppswwwmysite.devvendorlaravelframeworksrcIlluminateDatabaseSeeder.php:37
IlluminateDatabaseSeeder->call() at C:Amppswwwmysite.devappdatabaseseedsDatabaseSeeder.php:25
DatabaseSeeder->run() at C:Amppswwwmysite.devvendorlaravelframeworksrcIlluminateDatabaseConsoleSeedCommand.php:52
IlluminateDatabaseConsoleSeedCommand->fire() at C:Amppswwwmysite.devvendorlaravelframeworksrcIlluminateConsoleCommand.php:108
IlluminateConsoleCommand->execute() at C:Amppswwwmysite.devvendorsymfonyconsoleSymfonyComponentConsoleCommandCommand.php:241
SymfonyComponentConsoleCommandCommand->run() at C:Amppswwwmysite.devvendorlaravelframeworksrcIlluminateConsoleCommand.php:96
IlluminateConsoleCommand->run() at C:Amppswwwmysite.devvendorsymfonyconsoleSymfonyComponentConsoleApplication.php:892
SymfonyComponentConsoleApplication->doRunCommand() at C:Amppswwwmysite.devvendorsymfonyconsoleSymfonyComponentConsoleApplication.php:191
SymfonyComponentConsoleApplication->doRun() at C:Amppswwwmysite.devvendorsymfonyconsoleSymfonyComponentConsoleApplication.php:121
SymfonyComponentConsoleApplication->run() at C:Amppswwwmysite.devartisan:59
这里可能发生了什么?考虑到我甚至没有明确添加DateTime对象,我不会立即发现它有任何问题。。。除了Faker的"order_date"的dateTime,但这应该不是问题。
请注意,customers
表已经创建,并比此表提前一步播种。
这是Laravel 4.1的错误吗?
MySQL DATETIME
列类型需要String
。Faker正在返回PHP DateTime
对象。
从Faker格式化您的DateTime
对象以返回String
:
Order::create([
// Omitted fields above
'order_date' => $f->dateTime->format('Y-m-d H:i:s'),
// Omitted fields below
]);