Sample Data Using Laravel

• create a new laravel project. See here

• update the migration for users table in database/migrations/ path to look like this:

   public function up()
   {
       Schema::create('users', function (Blueprint $table) {
           $table->increments('id');
           $table->string('name');
           $table->string('nickname');
           $table->string('email')->unique();
           $table->string('password');
           $table->date('birthdate');
           $table->char('gender');
           $table->integer('group_id')->unsigned();
           $table->rememberToken();
           $table->timestamps();
       });
   }

• then, modify App\User factory in database/factories/ModelFactory.php to look like this

   $factory->define(App\User::class, function (Faker\Generator $faker) {
       return [
           'name' => $faker->name,
           'nickname' => $faker->word,
           'email' => $faker->safeEmail,
           'password' => bcrypt(str_random(10)),
           'remember_token' => str_random(10),
           'birthdate' => $faker->dateTimeBetween('-30 years', 'now'),
           'gender' => $faker->randomElement(['M', 'F']),
           'group_id' => $faker->randomElement([1, 2, 3, 4, 5])
       ];
   });

• from the command prompt, run the migration using this command

   php artisan migrate

• and still in the command prompt, run artisan tinker command

   php artisan tinker

• when you see the prompt >>>, enter this command to generate fake data

   factory(App\User::class, 50)->create()

• now open app\Http\routes.php file and replace it with the following code

   <?php

Route::get('/api/users', function() { $request = request();

// handle sort option
if (request()->has('sort')) {
    list($sortCol, $sortDir) = explode('|', request()->sort);
    $query = App\User::orderBy($sortCol, $sortDir);
} else {
    $query = App\User::orderBy('id', 'asc');
}

if ($request->exists('filter')) {
    $query->where(function($q) use($request) {
        $value = "%{$request->filter}%";
        $q->where('name', 'like', $value)
            ->orWhere('nickname', 'like', $value)
            ->orWhere('email', 'like', $value);
    });
}

$perPage = request()->has('per_page') ? (int) request()->per_page : null;

// The headers 'Access-Control-Allow-Origin' and 'Access-Control-Allow-Methods'
// are to allow you to call this from any domain (see CORS for more info).
// This is for local testing only. You should not do this in production server,
// unless you know what it means.
return response()->json(
        $query->paginate($perPage)
    )
    ->header('Access-Control-Allow-Origin', '*')
    ->header('Access-Control-Allow-Methods', 'GET');

}); ```