Examples of database migration and data filling in Laravel5.2

1. Database migration

Laravel's database migration provides a series of related operations on databases, tables, fields, and indexes. The following takes creating a friendly link table as an example.

1. Create migration

Use Artisan command php artisan make:migration create_links_table

This will generate a file named # in the database/migrations directory ##2017_05_06_151645_create_links_table.php file. The first half of the name "2017_05_06_151645_" is the timestamp added by Laravel. The second half of "create_links_table.php" is the table name.

2. Write logic

Then, open the migration class

2017_05_06_151645_create_links_table.php. There are two methods in it: up() and down(). The up() method creates a table, and the down() method deletes the table.

<?php
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateLinksTable extends Migration
{
    /**
     * 执行迁移
     *
     * @return void
     */
    public function up()
    {
        Schema::create(&#39;links&#39;, function (Blueprint $table){
            $table->engine = &#39;MyISAM&#39;;
            $table->increments(&#39;id&#39;);
            $table->string(&#39;name&#39;)->default(&#39;&#39;)->comment(&#39;名称&#39;);
            $table->string(&#39;title&#39;)->default(&#39;&#39;)->comment(&#39;标题&#39;);
            $table->string(&#39;url&#39;)->default(&#39;&#39;)->comment(&#39;地址&#39;);
            $table->integer(&#39;sort&#39;)->default(50)->comment(&#39;排序&#39;);
        });
    }
    
    /**
     * 回滚迁移
     *
     * @return void
     */
    public function down()
    {
        Schema::drop(&#39;links&#39;);
    }
}

2017_05_06_151645_create_links_table.php

3. Execute migration

Use Artisan command

php artisan migrate

Now, the database has been created A hd_links table and a table hd_migrations recording migrations ("hd_" is the configured table prefix):

Note: If the migration class is manually deleted And the file cannot be re-created. Use the composer dump-autoload command to optimize the automatic loading and the migration can be re-created.

2. Data filling

can be used for testing to fill in some data for the tables in the database.

1. Create the fill

Use the Artisan command

php artisan make:seeder LinksTableSeeder

This will generate a file named # in the database/seeds directory The friendly link filling class of ##LinksTableSeeder.php

. 2. Write logic

Then, open this

LinksTableSeeder.php

file and add two test records.

<?php
use Illuminate\Database\Seeder;
class LinksTableSeeder extends Seeder
{
    /**
     * 运行数据库填充
     *
     * @return void
     */
    public function run()
    {
        $data = [
            [
                &#39;name&#39; => &#39;Laravel 中文社区&#39;,
                &#39;title&#39; => &#39;Laravel China 社区 - 高品质的 Laravel 和 PHP 开发者社区 - Powered by PHPHub&#39;,
                &#39;url&#39; => &#39;https://laravel-china.org/&#39;,
                &#39;sort&#39; => &#39;49&#39;
            ],
            [
                &#39;name&#39; => &#39;GitHub&#39;,
                &#39;title&#39; => &#39;GitHub is where people build software. More than 21 million people use...&#39;,
                &#39;url&#39; => &#39;https://github.com&#39;,
                &#39;sort&#39; => &#39;49&#39;
            ]
        ];

        DB::table(&#39;links&#39;)->insert($data);
    }
}

3. Call filling

In the database filling class DatabaseSeeder.php in the database/seeds directory, call filling in the run() method .

DatabaseSeeder.php file content:

<?php
use Illuminate\Database\Seeder;
class DatabaseSeeder extends Seeder
{
    /**
     * 运行数据库填充
     *
     * @return void
     */
    public function run()
    {
        $this->call(LinksTableSeeder::class);
    }
}

4. Perform filling

Use Artisan command

php artisan db:seed

Now, the hd_links table in the database has 2 records:

The above is the detailed content of Examples of database migration and data filling in Laravel5.2. For more information, please follow other related articles on the PHP Chinese website!