Laravel Passport Oauth tables reservation (saver)

Readme.md

Laravel Passport OAuth tables reservation (saver)

These seeders is very usefull, when you want php artisan migrate:reset or php artisan migrate:refresh. After full migration reset you need to php artisan passport:install because newly created oauth tables is empty, but if you will use these gists, you will save some time and most importantly - save your current tokens.

Instruction

1. Run php artisan db:seed with only $this->call(OauthTablesReservation::class);
2. Delete this line from DatabaseSeeder. Do any operations you want, like php artisan migrate:refresh
3. Run php artisan db:seed with only $this->call(OauthTablesSeeder::class);

OauthTablesReservation.php

<?php

use Illuminate\Database\Seeder;

class OauthTablesReservation extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        $oauth_tables = [
            'oauth_access_tokens',
            'oauth_auth_codes',
            'oauth_clients',
            'oauth_personal_access_clients',
            'oauth_refresh_tokens',
        ];
        
        foreach ($oauth_tables as $table) {
            DB::statement('DROP TABLE IF EXISTS reserved_' . $table);
            DB::statement('CREATE TABLE reserved_' . $table . ' LIKE ' . $table);
            DB::statement('INSERT reserved_' . $table . ' SELECT * FROM ' . $table);
        }
    }
}

OauthTablesSeeder.php

<?php

use Illuminate\Database\Seeder;

class OauthTablesSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        $oauth_tables = [
            'oauth_access_tokens',
            'oauth_auth_codes',
            'oauth_clients',
            'oauth_personal_access_clients',
            'oauth_refresh_tokens',
        ];

        foreach ($oauth_tables as $table) {
            DB::statement('DROP TABLE IF EXISTS ' . $table);
            DB::statement('CREATE TABLE ' . $table . ' LIKE reserved_' . $table);
            DB::statement('INSERT ' . $table . ' SELECT * FROM reserved_' . $table);
            DB::statement('DROP TABLE IF EXISTS reserved_' . $table);
        }
    }
}