How to create a seed to insert a record?

Question

There is a table with fields:

$table->increments('id'); $table->string('title'); $table->string('meta_description'); $table->string('meta_keywords'); $table->string('image'); $table->string('description'); $table->string('author'); $table->timestamps();

How do I now create a seed to insert a record? I do like this, nothing happens:

 <?php use Illuminate\Database\Seeder; class blog_table_seeder extends Seeder { /** * Run the database seeds. * * @return void */ public function run() { DB::table('blog')->insert([ 'id' => NULL, // Здесь автоинкремент должен быть 'title' => 'тайтл новости', 'meta_description' => 'мета описание', 'meta_keywords' => 'ключевики', 'image' => 'картинка', 'description' => 'Описание', 'author' => 'Автор' // Дата создания, я так понял, автоматом заполняется? ]); } }

Butochnikov Butochnikov 36 1 bronze sign · Accepted Answer · 2015-10-27T11:42:39

 'id' => NULL указывть не надо.

Running migrations on command:

 php artisan db:seed

or

 php artisan db:seed --class=blog_table_seeder

and recommend classes to call so BlogTableSeeder

Butochnikov

36 1 bronze sign

If you run through php artisan db:seed , then you need to write such a thing in the DatabaseSeeder class in the run() method: $this->call('blog_table_seeder'); - Konstantin
Yes, important addition, thank you. - Butochnikov
Everything works, but tell me how to make it so that the current date is automatically substituted? - Onotol
If laravel-way, then Carbon::now() . Documentation here: github.com/briannesbitt/Carbon - Butochnikov

|

VenZell VenZell 18.5k 5 gold signs 30 silver marks 55 bronze marks · Answer 2 · 2015-10-27T12:05:55

First, you do not need to pass id. It will be substituted automatically.

Secondly, the side file, as well as the class, should be called CamelCase in the format.
The file name must match the class name.

Thirdly, if you created the cider manually, execute the command in the console

 composer dump-autoload

being in the project folder.

Do not forget to migrate the team

 php artisan migrate

To sit the database run the command

 php artisan db:seed --class=blog_table_seeder

To your data from your seder hit the database without specifying the class on the command

 php artisan db:seed

It is necessary that the folder DatabaseSeedeer.php following content be in the list of servers:

 <?php use Illuminate\Database\Seeder; class DatabaseSeeder extends Seeder { /** * Run the database seeds. * * @return void */ public function run() { // Для Laravel 5.1 $this->call(blog_table_seeder::class); // Для Laravel 4.2 заменить на // $this->call('blog_table_seeder'); } }

The insert method does not automatically insert date.

There are two solutions.

The first solution is to insert data in the sider:

 <?php use Illuminate\Database\Seeder; class blog_table_seeder extends Seeder { /** * Run the database seeds. * * @return void */ public function run() { DB::table('blog')->insert([ 'title' => 'тайтл новости', 'meta_description' => 'мета описание', 'meta_keywords' => 'ключевики', 'image' => 'картинка', 'description' => 'Описание', 'author' => 'Автор', // заполняем timestamps вручную 'created_at' => date('Ymd H:i:s'), 'updated_at' => date('Ymd H:i:s') ]); } }

The second solution is through adding and using the model:

Blog.php

 <?php // На этом этапе будьте внимательнее с namespace class Blog extends Eloquent { protected $table = 'blog'; }

Ваш сидер.php

 <?php use Illuminate\Database\Seeder; // На этом этапе будьте внимательнее с namespace class blog_table_seeder extends Seeder { /** * Run the database seeds. * * @return void */ public function run() { // метод create автоматически заполнит timestamps Blog::create([ 'title' => 'тайтл новости', 'meta_description' => 'мета описание', 'meta_keywords' => 'ключевики', 'image' => 'картинка', 'description' => 'Описание', 'author' => 'Автор' ]); } }

How to create a seed to insert a record?

2 answers 2

The first solution is to insert data in the sider:

The second solution is through adding and using the model:

More articles: