CreateRolesAndPermissionsTables

Complexity

Total Complexity

4

Size/Duplication

Total Lines	39
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	createTable()	0	6	1
A	up()	0	7	1
A	createPivot()	0	10	1
A	down()	0	7	1

<?php

use Helldar\Roles\Support\Database\BaseMigration;
use Illuminate\Database\Schema\Blueprint;

class CreateRolesAndPermissionsTables extends BaseMigration
{
    public function up()
    {
        $this->createTable($this->roles);
        $this->createTable($this->permissions);

        $this->createPivot($this->user_roles, $this->users, $this->roles, 'user_id', 'role_id');
        $this->createPivot($this->role_permissions, $this->roles, $this->permissions, 'role_id', 'permission_id');
    }

    public function down()
    {
        $this->schema()->disableForeignKeyConstraints();

        $this->dropTables($this->role_permissions, $this->user_roles, $this->permissions, $this->roles);

        $this->schema()->enableForeignKeyConstraints();
    }

    protected function createTable(string $table)
    {
        $this->create($table, function (Blueprint $table) {
            $table->bigIncrements('id');
            $table->string('name')->unique();
            $table->timestamps();
        });
    }

    protected function createPivot(string $table, string $first_table, string $second_table, string $first_key, string $second_key)
    {
        $this->create($table, function (Blueprint $table) use ($first_table, $second_table, $first_key, $second_key) {
            $table->unsignedBigInteger($first_key);
            $table->unsignedBigInteger($second_key);

            $table->foreign($first_key)->references('id')->on($first_table)->onDelete('cascade');
            $table->foreign($second_key)->references('id')->on($second_table)->onDelete('cascade');

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