I am trying to insert static data, with the help of the seeder and Eloquent as bellow.
JavaScript
x
use IlluminateDatabaseSeeder;
use AppRole;
class RoleSeeder extends Seeder
{
public function run()
{
Role::insert(array(
array('name' => 'admin'),
array('name' => 'user')
));
}
}
Even after using Eloquent i am getting timestamp null in database.
Advertisement
Answer
The timestamp
columns (created_at and updated_at) will be assigned automatically only if you are using the Eloquent
save()
method and create
method are Eloquent.
While insert
method is not Eloquent, it’s a query builder method. So use create
method instead :
JavaScript
public function run()
{
Role::create(array(
array('name' => 'admin'),
array('name' => 'user')
));
}
When you are using query builder, you have to created_at
and updated_at
value by yourself :
JavaScript
Role::insert(array(
array('name' => 'admin'),
array('name' => 'user'),
array('created_at' => CarbonCarbon::now()),
array('updated_at' => CarbonCarbon::now()),
));