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

Completed

Push — master ( d1d2ef...0e04b4 )

by Kit Loong

created 2020-09-08 10:14 UTC

MySQLRepository::spaceAfterComma() A

↳ Parent: MySQLRepository

Complexity

Conditions	1
Paths	1

Size

Total Lines	3
Code Lines	1

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	2
CRAP Score	1

Importance

Changes

Metric	Value
cc	1
eloc	1
c	0
b	0
f	0
nc	1
nop	1
dl	0
loc	3
ccs	2
cts	2
cp	1
crap	1
rs	10

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

namespace KitLoong\MigrationsGenerator\Repositories;

use KitLoong\MigrationsGenerator\MigrationsGeneratorSetting;

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

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

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

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

        return null;
    }

    private function spaceAfterComma(string $value): string
    {
        return str_replace("','", "', '", $value);
    }
}


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 KitLoong\MigrationsGenerator\MigrationsGeneratorSetting;
11
12		class MySQLRepository
13		{
14	6	public function getEnumPresetValues(string $table, string $columnName): ?string
15		{
16		/** @var MigrationsGeneratorSetting $setting */
17	6	$setting = app(MigrationsGeneratorSetting::class);
18
19	6	$column = $setting->getConnection()->select("SHOW COLUMNS FROM `${table}` where Field = '${columnName}' AND Type LIKE 'enum(%'");
20	6	if (count($column) > 0) {
21	3	return substr(
22	3	str_replace('enum(', '[', $this->spaceAfterComma($column[0]->Type)),
23	3	0,
24	3	-1
25	3	).']';
26		}
27	3	return null;
28		}
29
30	6	public function getSetPresetValues(string $table, string $columnName): ?string
31		{
32		/** @var MigrationsGeneratorSetting $setting */
33	6	$setting = app(MigrationsGeneratorSetting::class);
34
35	6	$column = $setting->getConnection()->select("SHOW COLUMNS FROM `${table}` where Field = '${columnName}' AND Type LIKE 'set(%'");
36	6	if (count($column) > 0) {
37	3	return substr(
38	3	str_replace('set(', '[', $this->spaceAfterComma($column[0]->Type)),
39	3	0,
40	3	-1
41	3	).']';
42		}
43
44	3	return null;
45		}
46
47	6	private function spaceAfterComma(string $value): string
48		{
49	6	return str_replace("','", "', '", $value);
50		}
51		}
52

kitloong / laravel-migrations-generator

Push — master ( d1d2ef...0e04b4 )

MySQLRepository::spaceAfterComma() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like