MySQLRepository::getEnumPresetValues() - Code Metrics - Inspection of "Support Lumen" - kitloong/laravel-migrations-generator - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — 4.x ( da046c...d9a6cf )

by Kit Loong

created 2020-04-07 15:49 UTC

MySQLRepository::getEnumPresetValues() A

↳ Parent: MySQLRepository

Complexity

Conditions	2
Paths	2

Size

Total Lines

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	15
rs	9.7666
c	0
b	0
f	0
cc	2
nc	2
nop	2

<?php
/**
 * Created by PhpStorm.
 * User: liow.kitloong
 * Date: 2020/04/07
 */

namespace KitLoong\MigrationsGenerator\Repositories;

use Illuminate\Support\Facades\DB;
use KitLoong\MigrationsGenerator\MigrationGeneratorSetting;

class MySQLRepository
{
    public function getEnumPresetValues(string $table, string $columnName): ?string
    {
        /** @var MigrationGeneratorSetting $setting */
        $setting = app(MigrationGeneratorSetting::class);

        $column = DB::connection($setting->getConnection())->select("SHOW COLUMNS FROM `${table}` where Field = '${columnName}' AND Type LIKE 'enum(%'");
        if (count($column) > 0) {
            return substr(
                str_replace('enum(', '[', $column[0]->Type),
                0,
                -1
            ).']';
        }
        return null;
    }

    public function getSetPresetValues(string $table, string $columnName): ?string
    {
        /** @var MigrationGeneratorSetting $setting */
        $setting = app(MigrationGeneratorSetting::class);

        $column = DB::connection($setting->getConnection())->select("SHOW COLUMNS FROM `${table}` where Field = '${columnName}' AND Type LIKE 'set(%'");
        if (count($column) > 0) {
            return substr(
                str_replace('set(', '[', $column[0]->Type),
                0,
                -1
            ).']';
        }

        return null;
    }
}


1			<?php
2			/**
3			* Created by PhpStorm.
4			* User: liow.kitloong
5			* Date: 2020/04/07
6			*/
7
8			namespace KitLoong\MigrationsGenerator\Repositories;
9
10			use Illuminate\Support\Facades\DB;
11			use KitLoong\MigrationsGenerator\MigrationGeneratorSetting;
12
13			class MySQLRepository
14			{
15			public function getEnumPresetValues(string $table, string $columnName): ?string
16			{
17			/** @var MigrationGeneratorSetting $setting */
18			$setting = app(MigrationGeneratorSetting::class);
19
20			$column = DB::connection($setting->getConnection())->select("SHOW COLUMNS FROM `${table}` where Field = '${columnName}' AND Type LIKE 'enum(%'");
21			if (count($column) > 0) {
22			return substr(
23			str_replace('enum(', '[', $column[0]->Type),
24			0,
25			-1
26			).']';
27			}
28			return null;
29			}
30
31			public function getSetPresetValues(string $table, string $columnName): ?string
32			{
33			/** @var MigrationGeneratorSetting $setting */
34			$setting = app(MigrationGeneratorSetting::class);
35
36			$column = DB::connection($setting->getConnection())->select("SHOW COLUMNS FROM `${table}` where Field = '${columnName}' AND Type LIKE 'set(%'");
37			if (count($column) > 0) {
38			return substr(
39			str_replace('set(', '[', $column[0]->Type),
40			0,
41			-1
42			).']';
43			}
44
45			return null;
46			}
47			}
48

kitloong / laravel-migrations-generator

Push — 4.x ( da046c...d9a6cf )

MySQLRepository::getEnumPresetValues() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like