CreateStatisticsPathsTable::up() - Code Metrics - rinvex/laravel-statistics - Measure and Improve Code Quality continuously with Scrutinizer

CreateStatisticsPathsTable::up() A
last analyzed 2020-05-30 02:24 UTC

↳ Parent: CreateStatisticsPathsTable

Complexity

Conditions	1
Paths	1

Size

Total Lines

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	1
nc	1
nop	0
dl	0
loc	16
rs	9.7333
c	0
b	0
f	0

<?php

declare(strict_types=1);

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

class CreateStatisticsPathsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up(): void
    {
        Schema::create(config('rinvex.statistics.tables.paths'), function (Blueprint $table) {
            // Columns
            $table->increments('id');
            $table->string('host');
            $table->string('locale');
            $table->string('path');
            $table->string('method');
            $table->{$this->jsonable()}('parameters')->nullable();
            $table->integer('count')->unsigned()->default(0);

            // Indexes
            $table->unique(['host', 'path', 'method', 'locale']);
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down(): void
    {
        Schema::dropIfExists(config('rinvex.statistics.tables.paths'));
    }

    /**
     * Get jsonable column data type.
     *
     * @return string
     */
    protected function jsonable(): string
    {
        $driverName = DB::connection()->getPdo()->getAttribute(PDO::ATTR_DRIVER_NAME);
        $dbVersion = DB::connection()->getPdo()->getAttribute(PDO::ATTR_SERVER_VERSION);
        $isOldVersion = version_compare($dbVersion, '5.7.8', 'lt');

        return $driverName === 'mysql' && $isOldVersion ? 'text' : 'json';
    }
}


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 CreateStatisticsPathsTable 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.paths'), function (Blueprint $table) {
19			// Columns
20			$table->increments('id');
21			$table->string('host');
22			$table->string('locale');
23			$table->string('path');
24			$table->string('method');
25			$table->{$this->jsonable()}('parameters')->nullable();
26			$table->integer('count')->unsigned()->default(0);
27
28			// Indexes
29			$table->unique(['host', 'path', 'method', 'locale']);
30			});
31			}
32
33			/**
34			* Reverse the migrations.
35			*
36			* @return void
37			*/
38			public function down(): void
39			{
40			Schema::dropIfExists(config('rinvex.statistics.tables.paths'));
41			}
42
43			/**
44			* Get jsonable column data type.
45			*
46			* @return string
47			*/
48			protected function jsonable(): string
49			{
50			$driverName = DB::connection()->getPdo()->getAttribute(PDO::ATTR_DRIVER_NAME);
51			$dbVersion = DB::connection()->getPdo()->getAttribute(PDO::ATTR_SERVER_VERSION);
52			$isOldVersion = version_compare($dbVersion, '5.7.8', 'lt');
53
54			return $driverName === 'mysql' && $isOldVersion ? 'text' : 'json';
55			}
56			}
57

rinvex / laravel-statistics

CreateStatisticsPathsTable::up() A last analyzed 2020-05-30 02:24 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

CreateStatisticsPathsTable::up() A
last analyzed 2020-05-30 02:24 UTC