ModifyRolesAndPermissionsTableOptimizeIndexes

Complexity

Total Complexity

4

Size/Duplication

Total Lines	29
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	up()	0	4	1
A	revertIndexes()	0	6	1
A	down()	0	4	1
A	optimizeIndexes()	0	6	1

<?php

use Illuminate\Database\Schema\Blueprint;

class ModifyRolesAndPermissionsTableOptimizeIndexes extends BaseMigration
{
    public function up()
    {
        $this->optimizeIndexes($this->user_roles, 'user_id', 'role_id');
        $this->optimizeIndexes($this->role_permissions, 'role_id', 'permission_id');
    }

    public function down()
    {
        $this->revertIndexes($this->user_roles, 'user_id', 'role_id');
        $this->revertIndexes($this->role_permissions, 'role_id', 'permission_id');
    }

    protected function optimizeIndexes(string $table, string $first_key, string $second_key)
    {
        $this->table($table, function (Blueprint $table) use ($first_key, $second_key) {
            $table->dropPrimary([$first_key, $second_key]);

            $table->index($first_key);
        });
    }

    protected function revertIndexes(string $table, string $first_key, string $second_key)
    {
        $this->table($table, function (Blueprint $table) use ($first_key, $second_key) {
            $table->dropIndex($first_key);

            $table->primary([$first_key, $second_key]);
        });
    }
}