Laravelでfakerを利用し、Eloquentのcursor()・all()・chunk()の速度を計測するために、テストの点数のデータを登録してみた(第1回)

php artisan make:model Models/Student -m

class CreateStudentsTable extends Migration
{
    public function up()
    {
        Schema::create('students', function (Blueprint $table) {
            $table->bigIncrements('id');
            $table->string('name', 20)->comment('名前');
            $table->bigInteger('japanese')->comment('国語');
            $table->bigInteger('math')->comment('数学');
            $table->bigInteger('english')->comment('英語');
            $table->bigInteger('social_studies')->comment('社会');
            $table->bigInteger('science')->comment('理科');
            $table->timestamps();
        });
    }

    public function down()
    {
        Schema::dropIfExists('students');
    }
}

php artisan migrate
Migrating: 2019_04_07_085555_create_students_table
Migrated:  2019_04_07_085555_create_students_table

class Student extends Model
{
    //明示的にテーブルと紐づけ(記載しない場合、Model名の複数形のテーブルと紐づく(今回ならstudents))
    protected $table = 'students';

    //複数代入に代入を許可しないカラム(主キーなどを設定する)
    protected $guarded = ['id'];

    //データが入ったときに自動でcreated_atとupdate_atにデータが入ることを明示的に表示
    public $timestamps = true;

    //複数代入時に代入を許可するカラム
    protected $fillable = ['name', 'japanese', 'math', 'english', 'social_studies', 'science'];
}

//ファクトリークラスの作成
php artisan make:factory StudentFactory

$factory->define(Student::class, function (Faker $faker) {
    return [
        'name'           => $faker->name,
        'japanese'       => $faker->numberBetween(0, 100),
        'math'           => $faker->numberBetween(0, 100),
        'english'        => $faker->numberBetween(0, 100),
        'social_studies' => $faker->numberBetween(0, 100),
        'science'        => $faker->numberBetween(0, 100),
    ];
});

'faker_locale' => env('APP_FAKER_LOCALE', 'en_US'),

APP_FAKER_LOCALE=ja_JP

//設定変えたので、キャッシュクリア
php artisan config:cache

php artisan make:seed StudentsTableSeeder

class StudentsTableSeeder extends Seeder
{
    public function run()
    {
        factory(Student::class, 10000)->create();
    }
}

class DatabaseSeeder extends Seeder
{
    public function run()
    {
         $this->call(StudentsTableSeeder::class);
    }
}

php artisan db:seed
Seeding: StudentsTableSeeder
Database seeding completed successfully