Completed
Push — develop ( cc9a49...c1329f )
by Abdelrahman
09:49
created

CreateRolesTable::jsonable()   A

Complexity

Conditions 3
Paths 4

Size

Total Lines 6
Code Lines 4

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
cc 3
eloc 4
nc 4
nop 0
dl 0
loc 6
rs 9.4285
c 0
b 0
f 0
1
<?php
2
3
use Illuminate\Support\Facades\Schema;
4
use Illuminate\Database\Schema\Blueprint;
5
use Illuminate\Database\Migrations\Migration;
6
7
class CreateRolesTable extends Migration
0 ignored issues
show
Coding Style Compatibility introduced by
PSR1 recommends that each class must be in a namespace of at least one level to avoid collisions.

You can fix this by adding a namespace to your class:

namespace YourVendor;

class YourClass { }

When choosing a vendor namespace, try to pick something that is not too generic to avoid conflicts with other libraries.

Loading history...
8
{
9
    /**
10
     * Run the migrations.
11
     *
12
     * @return void
13
     */
14
    public function up()
15
    {
16
        Schema::create(config('cortex.fort.tables.roles'), function (Blueprint $table) {
17
            // Columns
18
            $table->increments('id');
19
            $table->string('name', 150);
20
            $table->{$this->jsonable()}('title')->nullable();
21
            $table->integer('level')->unsigned()->nullable();
22
            $table->integer('scope')->nullable();
23
            $table->auditable();
24
            $table->timestamps();
25
26
            // Indexes
27
            $table->index(['scope']);
28
            $table->unique(['name', 'scope'], 'roles_name_unique');
29
        });
30
    }
31
32
    /**
33
     * Reverse the migrations.
34
     *
35
     * @return void
36
     */
37
    public function down()
38
    {
39
        Schema::drop(config('cortex.fort.tables.roles'));
40
    }
41
42
    /**
43
     * Get jsonable column data type.
44
     *
45
     * @return string
46
     */
47
    protected function jsonable(): string
48
    {
49
        return DB::connection()->getPdo()->getAttribute(PDO::ATTR_DRIVER_NAME) === 'mysql'
50
               && version_compare(DB::connection()->getPdo()->getAttribute(PDO::ATTR_SERVER_VERSION), '5.7.8', 'ge')
51
            ? 'json' : 'text';
52
    }
53
}
54