Laravelチュートリアル4 -データベースを使用して処理を書いてみよう

php artisan make:migration create_pets_table --create=pets

<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreatePetsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('pets', function (Blueprint $table) {
            $table->increments('id');
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('pets');
    }
}

<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreatePetsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('pets', function (Blueprint $table) {
            $table->increments('id');
            $table->string('name');
            $table->string('birthday');
            $table->string('gender');
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('pets');
    }
}

$ php artisan migrate

Migrating: 2019_06_05_184203_create_pets_table
Migrated:  2019_06_05_184203_create_pets_table

sqlite3 --version

sqlite3 database/database.sqlite 

SQLite version 3.26.0 2018-12-01 12:34:55
Enter ".help" for usage hints.
sqlite> 

sqlite> .table

migrations       password_resets  pets             users    

sqlite> .schema pets

CREATE TABLE IF NOT EXISTS "pets" ("id" integer not null primary key autoincrement, "name" varchar not null, "birthday" varchar not null, "gender" varchar not null, "created_at" datetime null, "updated_at" datetime null);

CREATE TABLE IF NOT EXISTS "pets" (
    "id" integer not null primary key autoincrement,
    "name" varchar not null, "birthday" varchar not null,
    "gender" varchar not null,
    "created_at" datetime null,
    "updated_at" datetime null
);

INSERT INTO テーブル名(カラム名1, カラム名2, ...) values(データ1, データ2, ...);

sqlite> INSERT INTO pets(name, birthday, gender, created_at, updated_at) values("pochi", "2015/06/06", "male", datetime('now', 'localtime'), datetime('now', 'localtime'));

# カラム名を指定して取得する場合
sqlite> select カラム名1, カラム名2 from テーブル名;

# 全取得する場合
sqlite> select * from テーブル名;

sqlite> select * from pets;

1|pochi|2015/06/06|male|2019-06-06 04:21:03|2019-06-06 04:21:03

php artisan make:model モデル名

php artisan make:model Pet

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Pet extends Model
{
    //
}

Route::get('/select', 'SampleController@select');

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Pet;

class SampleController extends Controller
{
    public function index()
    {
        .
        .
    }

    public function select()
    {
        $pochi = Pet::find(1);

        return view('select', [
            "pochi" => $pochi
        ]);
    }

}

<h2>Pochi</h2>

<table border="1">
    <tr>
        <th>名前</th>
        <th>生年月日</th>
        <th>性別</th>
    </tr>
    <tr>
        <td>{{$pochi->name}}</td>
        <td>{{$pochi->birthday}}</td>
        <td>{{$pochi->gender}}</td>
    </tr>
</table>

Route::get('/select_many', 'SampleController@selectMany');

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Pet;

class SampleController extends Controller
{
    public function index()
    {
        .
        .
    }

    public function select()
    {
        .
        .
    }

    public function selectMany()
    {
        $pets = Pet::orderBy('id', 'asc')->get();

        return view('select_many', [
            "pets" => $pets
        ]);
    }

}

<h2>Pet List</h2>

<table border="1">
    <tr>
        <th>名前</th>
        <th>生年月日</th>
        <th>性別</th>
    </tr>
    @foreach($pets as $pet)
    <tr>
        <td>{{$pet->name}}</td>
        <td>{{$pet->birthday}}</td>
        <td>{{$pet->gender}}</td>
    </tr>
    @endforeach
</table>

# データベースへ接続
$ sqlite3 database/database.sqlite 

# データの追加
sqlite> INSERT INTO pets(name, birthday, gender, created_at, updated_at) values("koro", "2019/06/06", "male", datetime('now', 'localtime'), datetime('now', 'localtime'));

# データの追加
sqlite> INSERT INTO pets(name, birthday, gender, created_at, updated_at) values("yume", "2014/06/06", "female", datetime('now', 'localtime'), datetime('now', 'localtime'));

Route::get('/insert', 'SampleController@insert');

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Pet;

class SampleController extends Controller
{



    public function select()
    {
        .
        .
    }

    public function insert()
    {
        $pet = new Pet();

        $pet->name = "shiro";
        $pet->birthday = "1980/06/16";
        $pet->gender = "female";

        $pet->save();

        return "データを挿入しました";
    }

}

Route::get('/delete', 'SampleController@delete');

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Pet;

class SampleController extends Controller
{


    public function insert()
    {
        .
        .
    }

    public function delete()
    {
        Pet::orderBy('id', 'asc')->first()->delete();

        return "データを削除しました";
    }

}

Route::get('/update', 'SampleController@update');

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Pet;

class SampleController extends Controller
{


    public function delete()
    {
        .
        .
    }

    public function update()
    {
        Pet::orderBy('id', 'asc')->first()->update(['name' => "jonny"]);

        return "データを更新しました";
    }

}

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Pet extends Model
{
    protected $guarded = ['id'];
}