[Laravel]はじめてのマイグレーション

1$ php artisan make:migration create_posts_table

1Created Migration: 2016_11_17_011700_create_posts_table

1$ ls -la database/migrations
2total 28
3drwxr-xr-x 2 ubuntu ubuntu 4096 Nov 19 01:06 ./
4drwxr-xr-x 5 ubuntu ubuntu 4096 Apr 27  2016 ../
5-rw-r--r-- 1 ubuntu ubuntu    1 Apr 27  2016 .gitkeep
6-rw-r--r-- 1 ubuntu ubuntu  699 Apr 27  2016 2014_10_12_000000_create_users_table.php
7-rw-r--r-- 1 ubuntu ubuntu  633 Apr 27  2016 2014_10_12_100000_create_password_resets_table.php
8-rw-r--r-- 1 ubuntu ubuntu  373 Nov 17 01:17 2016_11_17_011700_create_posts_table.php

 1<?php
 2
 3use Illuminate\Database\Schema\Blueprint;
 4use Illuminate\Database\Migrations\Migration;
 5
 6class CreatePostsTable extends Migration
 7{
 8    /**
 9     * Run the migrations.
10     *
11     * @return void
12     */
13    public function up()
14    {
15        //
16    }
17
18    /**
19     * Reverse the migrations.
20     *
21     * @return void
22     */
23    public function down()
24    {
25        //
26    }
27}

 1public function up()
 2{
 3    Schema::create('posts', function (Blueprint $table) {
 4        $table->increments('id');
 5        $table->string('post_body');
 6        $table->timestamps();
 7    });
 8}
 9public function down()
10{
11    Schema::drop('posts');
12}

1$ php artisan migrate

1$ php artisan make:model Model/Post

1Model created successfully.

 1<?php
 2
 3namespace App\Model;
 4
 5use Illuminate\Database\Eloquent\Model;
 6
 7class Post extends Model
 8{
 9    //
10}

1<?php
2namespace App\Model;
3
4use Illuminate\Database\Eloquent\Model;
5
6class Post extends Model
7{
8    protected $table = 'posts';
9}

1$posts = App\Model\Post::all();

1$ php artisan make:model Model/Post -m

1$ php artisan make:seeder UsersTableSeeder

1Seeder created successfully.

 1<?php
 2
 3use Illuminate\Database\Seeder;
 4
 5class UsersTableSeeder extends Seeder
 6{
 7    /**
 8     * Run the database seeds.
 9     *
10     * @return void
11     */
12    public function run()
13    {
14        //
15    }
16}

 1<?php
 2
 3use Hash;
 4use Illuminate\Database\Seeder;
 5use App\Model\User;
 6
 7class UsersTableSeeder extends Seeder
 8{
 9    public function run()
10    {
11        UserModel::create([
12            'account'  => 'atuweb',
13            'password' => Hash::make('password'),
14        ]);
15    }
16}

 1<?php
 2
 3use Illuminate\Database\Seeder;
 4use Illuminate\Database\Eloquent\Model;
 5
 6class DatabaseSeeder extends Seeder
 7{
 8    /**
 9     * Run the database seeds.
10     *
11     * @return void
12     */
13    public function run()
14    {
15        Model::unguard();
16
17        $this->call('UsersTableSeeder');
18        $this->call('PostsTableSeeder');
19
20        Model::reguard();
21    }
22}

1$ php artisan db:seed

1$ php artisan db:seed --class=UserTableSeeder

1$ php artisan migrate:reset

1$ php artisan migrate:reset
2$ php artisan migrate
3$ php artisan db:seed

1$ php artisan migrate:refresh --seed

1{
2    :
3    "require": {
4        "php": ">=5.5.9",
5        "laravel/framework": "5.2.*",
6        "doctrine/dbal": "2.*"
7    },

1$ composer update

1$ php artisan make:migration add_title_and_tag_posts_table

 1<?php
 2
 3use Illuminate\Support\Facades\Schema;
 4use Illuminate\Database\Schema\Blueprint;
 5use Illuminate\Database\Migrations\Migration;
 6
 7class AddTitleAndTagPostsTable extends Migration
 8{
 9    public function up()
10    {
11        Schema::table('posts', function ($table) {
12            $table->string('title')->after('id');
13            $table->string('tags')->after('post_body');
14        });
15    }
16}

 1$ php artisan
 2
 3Laravel Framework version 5.2.45
 4
 5Usage:
 6  command [options] [arguments]
 7
 8Options:
 9  -h, --help            Display this help message
10  -q, --quiet           Do not output any message
11  -V, --version         Display this application version
12      --ansi            Force ANSI output
13      --no-ansi         Disable ANSI output
14  -n, --no-interaction  Do not ask any interactive question
15      --env[=ENV]       The environment the command should run under.
16  -v|vv|vvv, --verbose  Increase the verbosity of messages: 1 for normal output, 2 for more verbose output and 3 for debug
17
18Available commands:
19  clear-compiled      Remove the compiled class file
20  down                Put the application into maintenance mode
21  env                 Display the current framework environment
22  help                Displays help for a command
23  list                Lists commands
24  migrate             Run the database migrations
25  optimize            Optimize the framework for better performance
26  serve               Serve the application on the PHP development server
27  tinker              Interact with your application
28  up                  Bring the application out of maintenance mode
29 app
30  app:name            Set the application namespace
31 auth
32  auth:clear-resets   Flush expired password reset tokens
33 cache
34  cache:clear         Flush the application cache
35  cache:table         Create a migration for the cache database table
36 config
37  config:cache        Create a cache file for faster configuration loading
38  config:clear        Remove the configuration cache file
39 db
40  db:seed             Seed the database with records
41 event
42  event:generate      Generate the missing events and listeners based on registration
43 key
44  key:generate        Set the application key
45 make
46  make:auth           Scaffold basic login and registration views and routes
47  make:console        Create a new Artisan command
48  make:controller     Create a new controller class
49  make:event          Create a new event class
50  make:job            Create a new job class
51  make:listener       Create a new event listener class
52  make:middleware     Create a new middleware class
53  make:migration      Create a new migration file
54  make:model          Create a new Eloquent model class
55  make:policy         Create a new policy class
56  make:provider       Create a new service provider class
57  make:request        Create a new form request class
58  make:seeder         Create a new seeder class
59  make:test           Create a new test class
60 migrate
61  migrate:install     Create the migration repository
62  migrate:refresh     Reset and re-run all migrations
63  migrate:reset       Rollback all database migrations
64  migrate:rollback    Rollback the last database migration
65  migrate:status      Show the status of each migration
66 queue
67  queue:failed        List all of the failed queue jobs
68  queue:failed-table  Create a migration for the failed queue jobs database table
69  queue:flush         Flush all of the failed queue jobs
70  queue:forget        Delete a failed queue job
71  queue:listen        Listen to a given queue
72  queue:restart       Restart queue worker daemons after their current job
73  queue:retry         Retry a failed queue job
74  queue:table         Create a migration for the queue jobs database table
75  queue:work          Process the next job on a queue
76 route
77  route:cache         Create a route cache file for faster route registration
78  route:clear         Remove the route cache file
79  route:list          List all registered routes
80 schedule
81  schedule:run        Run the scheduled commands
82 session
83  session:table       Create a migration for the session database table
84 vendor
85  vendor:publish      Publish any publishable assets from vendor packages
86 view
87  view:clear          Clear all compiled view files