CreateStatisticsRequestsTable - Code Metrics - Inspection of "Add migrations autoload option to the package" - rinvex/laravel-statistics - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — develop ( e2c7cc...e67cd2 )

by Abdelrahman

created 2020-01-20 23:52 UTC

CreateStatisticsRequestsTable A

↳ Parent: Project

Complexity

Total Complexity

Size/Duplication

Total Lines	72
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	4

Importance

Changes

Metric	Value
wmc	5
lcom	1
cbo	4
dl	0
loc	72
rs	10
c	0
b	0
f	0

3 Methods

Rating	Name	Size	Complexity
A	up()	40	1
A	down()	4	1
A	jsonable()	8	3

<?php

declare(strict_types=1);

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

class CreateStatisticsRequestsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up(): void
    {
        Schema::create(config('rinvex.statistics.tables.requests'), function (Blueprint $table) {
            // Columns
            $table->increments('id');
            $table->integer('route_id')->unsigned();
            $table->integer('agent_id')->unsigned();
            $table->integer('device_id')->unsigned();
            $table->integer('platform_id')->unsigned();
            $table->integer('path_id')->unsigned();
            $table->integer('geoip_id')->unsigned();
            $table->nullableMorphs('user');
            $table->string('session_id');
            $table->integer('status_code');
            $table->string('protocol_version')->nullable();
            $table->text('referer')->nullable();
            $table->string('language');
            $table->boolean('is_no_cache')->default(0);
            $table->boolean('wants_json')->default(0);
            $table->boolean('is_secure')->default(0);
            $table->boolean('is_json')->default(0);
            $table->boolean('is_ajax')->default(0);
            $table->boolean('is_pjax')->default(0);
            $table->timestamp('created_at')->nullable();

            // Indexes
            $table->foreign('route_id')->references('id')->on(config('rinvex.statistics.tables.routes'))
class A
{
    public function foo() { }
}

class B extends A
{
    public function bar() { }
}

/**
 * @param A|B $x
 */
function someFunction($x)
{
    $x->foo(); // This call is fine as the method exists in A and B.
    $x->bar(); // This method only exists in B and might cause an error.
}
                  ->onDelete('cascade')->onUpdate('cascade');
            $table->foreign('agent_id')->references('id')->on(config('rinvex.statistics.tables.agents'))
                  ->onDelete('cascade')->onUpdate('cascade');
            $table->foreign('device_id')->references('id')->on(config('rinvex.statistics.tables.devices'))
                  ->onDelete('cascade')->onUpdate('cascade');
            $table->foreign('platform_id')->references('id')->on(config('rinvex.statistics.tables.platforms'))
                  ->onDelete('cascade')->onUpdate('cascade');
            $table->foreign('path_id')->references('id')->on(config('rinvex.statistics.tables.paths'))
                  ->onDelete('cascade')->onUpdate('cascade');
            $table->foreign('geoip_id')->references('id')->on(config('rinvex.statistics.tables.geoips'))
                  ->onDelete('cascade')->onUpdate('cascade');
        });
    }

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

    /**
     * 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 CreateStatisticsRequestsTable 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.requests'), function (Blueprint $table) {
19			// Columns
20			$table->increments('id');
21			$table->integer('route_id')->unsigned();
22			$table->integer('agent_id')->unsigned();
23			$table->integer('device_id')->unsigned();
24			$table->integer('platform_id')->unsigned();
25			$table->integer('path_id')->unsigned();
26			$table->integer('geoip_id')->unsigned();
27			$table->nullableMorphs('user');
28			$table->string('session_id');
29			$table->integer('status_code');
30			$table->string('protocol_version')->nullable();
31			$table->text('referer')->nullable();
32			$table->string('language');
33			$table->boolean('is_no_cache')->default(0);
34			$table->boolean('wants_json')->default(0);
35			$table->boolean('is_secure')->default(0);
36			$table->boolean('is_json')->default(0);
37			$table->boolean('is_ajax')->default(0);
38			$table->boolean('is_pjax')->default(0);
39			$table->timestamp('created_at')->nullable();
40
41			// Indexes
42			$table->foreign('route_id')->references('id')->on(config('rinvex.statistics.tables.routes'))
			0 ignored issues – show Bug introduced 2020-01-20 23:53 UTC by Report Bug Copy Issue Report The method `references` does only exist in `Illuminate\Database\Schema\ForeignKeyDefinition`, but not in `Illuminate\Support\Fluent`. It seems like the method you are trying to call exists only in some of the possible types. Let’s take a look at an example: class A { public function foo() { } } class B extends A { public function bar() { } } /** * @param A\|B $x / function someFunction($x) { $x->foo(); // This call is fine as the method exists in A and B. $x->bar(); // This method only exists in B and might cause an error. } Available Fixes Add an additional type-check: /* * @param A\|B $x / function someFunction($x) { $x->foo(); if ($x instanceof B) { $x->bar(); } } Only allow a single type to be passed if the variable comes from a parameter: function someFunction(B $x) { /* ... */ } Loading history...
43			->onDelete('cascade')->onUpdate('cascade');
44			$table->foreign('agent_id')->references('id')->on(config('rinvex.statistics.tables.agents'))
45			->onDelete('cascade')->onUpdate('cascade');
46			$table->foreign('device_id')->references('id')->on(config('rinvex.statistics.tables.devices'))
47			->onDelete('cascade')->onUpdate('cascade');
48			$table->foreign('platform_id')->references('id')->on(config('rinvex.statistics.tables.platforms'))
49			->onDelete('cascade')->onUpdate('cascade');
50			$table->foreign('path_id')->references('id')->on(config('rinvex.statistics.tables.paths'))
51			->onDelete('cascade')->onUpdate('cascade');
52			$table->foreign('geoip_id')->references('id')->on(config('rinvex.statistics.tables.geoips'))
53			->onDelete('cascade')->onUpdate('cascade');
54			});
55			}
56
57			/**
58			* Reverse the migrations.
59			*
60			* @return void
61			*/
62			public function down(): void
63			{
64			Schema::dropIfExists(config('rinvex.statistics.tables.requests'));
65			}
66
67			/**
68			* Get jsonable column data type.
69			*
70			* @return string
71			*/
72			protected function jsonable(): string
73			{
74			$driverName = DB::connection()->getPdo()->getAttribute(PDO::ATTR_DRIVER_NAME);
75			$dbVersion = DB::connection()->getPdo()->getAttribute(PDO::ATTR_SERVER_VERSION);
76			$isOldVersion = version_compare($dbVersion, '5.7.8', 'lt');
77
78			return $driverName === 'mysql' && $isOldVersion ? 'text' : 'json';
79			}
80			}
81

rinvex / laravel-statistics

Push — develop ( e2c7cc...e67cd2 )

CreateStatisticsRequestsTable A

Complexity

Size/Duplication

Coupling/Cohesion

Importance

3 Methods

Available Fixes

Duplication Side-by-Side

Filter issues like