CreatePermissionTables::up() - Code Metrics - Inspection of "[UPDATE] use updated epesi/core structure" - x-systems/epesi-base - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( 7acdf2...feb473 )

by Georgi

created 2019-11-03 12:46 UTC

CreatePermissionTables::up() A

↳ Parent: CreatePermissionTables

Complexity

Conditions	2
Paths	1

Size

Total Lines	71
Code Lines	49

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	2
eloc	49
c	1
b	0
f	0
nc	1
nop	0
dl	0
loc	71
rs	9.1127

How to fix Long Method

<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreatePermissionTables extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        $tableNames = config('permission.table_names');
        $columnNames = config('permission.column_names');

        Schema::create($tableNames['permissions'], function (Blueprint $table) {
            $table->bigIncrements('id');
            $table->string('name');
            $table->string('guard_name');
            $table->timestamps();
        });

        Schema::create($tableNames['roles'], function (Blueprint $table) {
            $table->bigIncrements('id');
            $table->string('name');
            $table->string('guard_name');
            $table->timestamps();
        });

        Schema::create($tableNames['model_has_permissions'], function (Blueprint $table) use ($tableNames, $columnNames) {
            $table->unsignedBigInteger('permission_id');

            $table->string('model_type');
            $table->unsignedBigInteger($columnNames['model_morph_key']);
            $table->index([$columnNames['model_morph_key'], 'model_type', ], 'model_has_permissions_model_id_model_type_index');

            $table->foreign('permission_id')
                ->references('id')
                ->on($tableNames['permissions'])
                ->onDelete('cascade');

            $table->primary(['permission_id', $columnNames['model_morph_key'], 'model_type'],
                    'model_has_permissions_permission_model_type_primary');
        });

        Schema::create($tableNames['model_has_roles'], function (Blueprint $table) use ($tableNames, $columnNames) {
            $table->unsignedBigInteger('role_id');

            $table->string('model_type');
            $table->unsignedBigInteger($columnNames['model_morph_key']);
            $table->index([$columnNames['model_morph_key'], 'model_type', ], 'model_has_roles_model_id_model_type_index');

            $table->foreign('role_id')
                ->references('id')
                ->on($tableNames['roles'])
                ->onDelete('cascade');

            $table->primary(['role_id', $columnNames['model_morph_key'], 'model_type'],
                    'model_has_roles_role_model_type_primary');
        });

        Schema::create($tableNames['role_has_permissions'], function (Blueprint $table) use ($tableNames) {
            $table->unsignedBigInteger('permission_id');
            $table->unsignedBigInteger('role_id');

            $table->foreign('permission_id')
                ->references('id')
                ->on($tableNames['permissions'])
                ->onDelete('cascade');

            $table->foreign('role_id')
                ->references('id')
                ->on($tableNames['roles'])
                ->onDelete('cascade');

            $table->primary(['permission_id', 'role_id'], 'role_has_permissions_permission_id_role_id_primary');
        });

        app('cache')
            ->store(config('permission.cache.store') != 'default' ? config('permission.cache.store') : null)
            ->forget(config('permission.cache.key'));
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        $tableNames = config('permission.table_names');

        Schema::drop($tableNames['role_has_permissions']);
        Schema::drop($tableNames['model_has_roles']);
        Schema::drop($tableNames['model_has_permissions']);
        Schema::drop($tableNames['roles']);
        Schema::drop($tableNames['permissions']);
    }
}


1			<?php
2
3			use Illuminate\Support\Facades\Schema;
4			use Illuminate\Database\Schema\Blueprint;
5			use Illuminate\Database\Migrations\Migration;
6
7			class CreatePermissionTables extends Migration
8			{
9			/**
10			* Run the migrations.
11			*
12			* @return void
13			*/
14			public function up()
15			{
16			$tableNames = config('permission.table_names');
17			$columnNames = config('permission.column_names');
18
19			Schema::create($tableNames['permissions'], function (Blueprint $table) {
20			$table->bigIncrements('id');
21			$table->string('name');
22			$table->string('guard_name');
23			$table->timestamps();
24			});
25
26			Schema::create($tableNames['roles'], function (Blueprint $table) {
27			$table->bigIncrements('id');
28			$table->string('name');
29			$table->string('guard_name');
30			$table->timestamps();
31			});
32
33			Schema::create($tableNames['model_has_permissions'], function (Blueprint $table) use ($tableNames, $columnNames) {
34			$table->unsignedBigInteger('permission_id');
35
36			$table->string('model_type');
37			$table->unsignedBigInteger($columnNames['model_morph_key']);
38			$table->index([$columnNames['model_morph_key'], 'model_type', ], 'model_has_permissions_model_id_model_type_index');
39
40			$table->foreign('permission_id')
41			->references('id')
42			->on($tableNames['permissions'])
43			->onDelete('cascade');
44
45			$table->primary(['permission_id', $columnNames['model_morph_key'], 'model_type'],
46			'model_has_permissions_permission_model_type_primary');
47			});
48
49			Schema::create($tableNames['model_has_roles'], function (Blueprint $table) use ($tableNames, $columnNames) {
50			$table->unsignedBigInteger('role_id');
51
52			$table->string('model_type');
53			$table->unsignedBigInteger($columnNames['model_morph_key']);
54			$table->index([$columnNames['model_morph_key'], 'model_type', ], 'model_has_roles_model_id_model_type_index');
55
56			$table->foreign('role_id')
57			->references('id')
58			->on($tableNames['roles'])
59			->onDelete('cascade');
60
61			$table->primary(['role_id', $columnNames['model_morph_key'], 'model_type'],
62			'model_has_roles_role_model_type_primary');
63			});
64
65			Schema::create($tableNames['role_has_permissions'], function (Blueprint $table) use ($tableNames) {
66			$table->unsignedBigInteger('permission_id');
67			$table->unsignedBigInteger('role_id');
68
69			$table->foreign('permission_id')
70			->references('id')
71			->on($tableNames['permissions'])
72			->onDelete('cascade');
73
74			$table->foreign('role_id')
75			->references('id')
76			->on($tableNames['roles'])
77			->onDelete('cascade');
78
79			$table->primary(['permission_id', 'role_id'], 'role_has_permissions_permission_id_role_id_primary');
80			});
81
82			app('cache')
83			->store(config('permission.cache.store') != 'default' ? config('permission.cache.store') : null)
84			->forget(config('permission.cache.key'));
85			}
86
87			/**
88			* Reverse the migrations.
89			*
90			* @return void
91			*/
92			public function down()
93			{
94			$tableNames = config('permission.table_names');
95
96			Schema::drop($tableNames['role_has_permissions']);
97			Schema::drop($tableNames['model_has_roles']);
98			Schema::drop($tableNames['model_has_permissions']);
99			Schema::drop($tableNames['roles']);
100			Schema::drop($tableNames['permissions']);
101			}
102			}
103

x-systems / epesi-base

Push — master ( 7acdf2...feb473 )

CreatePermissionTables::up() A

Complexity

Size

Duplication

Importance

How to fix Long Method

Long Method

Duplication Side-by-Side

Filter issues like