Completed
Push — master ( 3e9fd3...553853 )
by Abdelrahman
01:29 queued 13s
created

CreateStatisticsDataTable::up()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 15

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
cc 1
nc 1
nop 0
dl 0
loc 15
rs 9.7666
c 0
b 0
f 0
1
<?php
2
3
declare(strict_types=1);
4
5
use Illuminate\Support\Facades\Schema;
6
use Illuminate\Database\Schema\Blueprint;
7
use Illuminate\Database\Migrations\Migration;
8
9
class CreateStatisticsDataTable extends Migration
10
{
11
    /**
12
     * Run the migrations.
13
     *
14
     * @return void
15
     */
16
    public function up(): void
17
    {
18
        Schema::create(config('rinvex.statistics.tables.data'), function (Blueprint $table) {
19
            // Columns
20
            $table->increments('id');
21
            $table->string('session_id');
22
            $table->nullableMorphs('user');
23
            $table->integer('status_code');
24
            $table->text('uri');
25
            $table->string('method');
26
            $table->{$this->jsonable()}('server');
27
            $table->{$this->jsonable()}('input')->nullable();
28
            $table->timestamp('created_at')->nullable();
29
        });
30
    }
31
32
    /**
33
     * Reverse the migrations.
34
     *
35
     * @return void
36
     */
37
    public function down(): void
38
    {
39
        Schema::dropIfExists(config('rinvex.statistics.tables.data'));
40
    }
41
42
    /**
43
     * Get jsonable column data type.
44
     *
45
     * @return string
46
     */
47
    protected function jsonable(): string
48
    {
49
        $driverName = DB::connection()->getPdo()->getAttribute(PDO::ATTR_DRIVER_NAME);
50
        $dbVersion = DB::connection()->getPdo()->getAttribute(PDO::ATTR_SERVER_VERSION);
51
        $isOldVersion = version_compare($dbVersion, '5.7.8', 'lt');
52
53
        return $driverName === 'mysql' && $isOldVersion ? 'text' : 'json';
54
    }
55
}
56