Fields::setFunction() - Code Metrics - Inspection of "Small fix (rename methods)" - Compolomus/SQLQueryBuilder - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Branch — develop (a6526d)

by compolom

created 2018-01-24 21:45 UTC

Fields::setFunction() A

↳ Parent: Project

Complexity

Conditions	2
Paths	2

Size

Total Lines	7
Code Lines	4

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	7
rs	9.4285
c	0
b	0
f	0
cc	2
eloc	4
nc	2
nop	1

<?php declare(strict_types=1);

namespace Compolomus\LSQLQueryBuilder\System;

class Fields
{
    use Traits\Helper;

    private $name;

    private $allias = null;

    private $result = null;

    private $functionsList = [
        'COMPRESS',
        'MD5',
        'PASSWORD',
        'SHA',
        'SHA1',
        'UNCOMPRESS',
        'UNCOMPRESSED_LENGTH',
        'VALIDATE_PASSWORD_STRENGTH',

        'AVG',
        'BIT_AND',
        'BIT_OR',
        'BIT_XOR',
        'BIT_COUNT',
        'COUNT',
        'GROUP_CONCAT',
        'JSON_ARRAYAGG',
        'MAX',
        'MIN',
        'STD',
        'STDDEV',
        'STDDEV_POP',
        'STDDEV_SAMP',
        'SUM',
        'VAR_POP',
        'VAR_SAMP',
        'VARIANCE',

        'ASCII',
        'BIN',
        'ORD',
        'CHAR_LENGTH', // multibyte len
        'HEX',
        'OCT',
        'LCASE',
        'LOWER',
        'UCASE',
        'UPPER',
        'REVERSE',
        #'LOAD_FILE', // security
        'TRIM', // rtrim
        'LTRIM',
        'RTRIM',

        'ABS',
        'ACOS',
        'ASIN',
        'ATAN',
        'CEIL',
        'CEILING',
        'COS',
        'COT',
        'CRC32',
        'DEGREES',
        'EXP',
        'FLOOR',
        'LN',
        'LOG',
        'LOG2',
        'LOG10',
        'RADIANS',
        'ROUND',
        'SIGN',
        'SIN',
        'SQRT',
        'TAN',

        'DATE',
        'DAY',
        'DAYNAME',
        'DAYOFMONTH',
        'DAYOFWEEK',
        'DAYOFYEAR',
        'FROM_DAYS',
        'FROM_UNIXTIME',
        'HOUR',
        'LAST_DAY',
        'MICROSECOND',
        'MINUTE',
        'MONTH',
        'MONTHNAME',
        'QUARTER',
        'SECOND',
        'SEC_TO_TIME',
        'TIME',
        'TIME_TO_SEC',
        'TO_DAYS',
        'TO_SECONDS',
        'UNIX_TIMESTAMP',
        'WEEK',
        'WEEKDAY',
        'YEAR',
        'YEARWEEK',
        'WEEKOFYEAR',
    ];

    public function __construct(string $name)
    {
        $this->result = $this->name = $this->escapeField($name);
    }

    public function setAllias(string $alliasName): void
    {
        $this->allias = $this->escapeField($alliasName);
    }

    public function setFunction(string $functionName): void
    {
        if (!in_array(strtoupper($functionName), $this->functionsList)) {
            throw new \InvalidArgumentException('MYSQL Функция ' . $functionName . ' не найдена |SELECT setFunction|');
        }
        $this->result = strtoupper($functionName) . '(' . $this->name . ')';
    }

    public function result(): string
    {
        return $this->result . (!is_null($this->allias) ? ' AS ' . $this->allias : '');
    }
}


1			<?php declare(strict_types=1);
2
3			namespace Compolomus\LSQLQueryBuilder\System;
4
5			class Fields
6			{
7			use Traits\Helper;
8
9			private $name;
10
11			private $allias = null;
12
13			private $result = null;
14
15			private $functionsList = [
16			'COMPRESS',
17			'MD5',
18			'PASSWORD',
19			'SHA',
20			'SHA1',
21			'UNCOMPRESS',
22			'UNCOMPRESSED_LENGTH',
23			'VALIDATE_PASSWORD_STRENGTH',
24
25			'AVG',
26			'BIT_AND',
27			'BIT_OR',
28			'BIT_XOR',
29			'BIT_COUNT',
30			'COUNT',
31			'GROUP_CONCAT',
32			'JSON_ARRAYAGG',
33			'MAX',
34			'MIN',
35			'STD',
36			'STDDEV',
37			'STDDEV_POP',
38			'STDDEV_SAMP',
39			'SUM',
40			'VAR_POP',
41			'VAR_SAMP',
42			'VARIANCE',
43
44			'ASCII',
45			'BIN',
46			'ORD',
47			'CHAR_LENGTH', // multibyte len
48			'HEX',
49			'OCT',
50			'LCASE',
51			'LOWER',
52			'UCASE',
53			'UPPER',
54			'REVERSE',
55			#'LOAD_FILE', // security
56			'TRIM', // rtrim
57			'LTRIM',
58			'RTRIM',
59
60			'ABS',
61			'ACOS',
62			'ASIN',
63			'ATAN',
64			'CEIL',
65			'CEILING',
66			'COS',
67			'COT',
68			'CRC32',
69			'DEGREES',
70			'EXP',
71			'FLOOR',
72			'LN',
73			'LOG',
74			'LOG2',
75			'LOG10',
76			'RADIANS',
77			'ROUND',
78			'SIGN',
79			'SIN',
80			'SQRT',
81			'TAN',
82
83			'DATE',
84			'DAY',
85			'DAYNAME',
86			'DAYOFMONTH',
87			'DAYOFWEEK',
88			'DAYOFYEAR',
89			'FROM_DAYS',
90			'FROM_UNIXTIME',
91			'HOUR',
92			'LAST_DAY',
93			'MICROSECOND',
94			'MINUTE',
95			'MONTH',
96			'MONTHNAME',
97			'QUARTER',
98			'SECOND',
99			'SEC_TO_TIME',
100			'TIME',
101			'TIME_TO_SEC',
102			'TO_DAYS',
103			'TO_SECONDS',
104			'UNIX_TIMESTAMP',
105			'WEEK',
106			'WEEKDAY',
107			'YEAR',
108			'YEARWEEK',
109			'WEEKOFYEAR',
110			];
111
112			public function __construct(string $name)
113			{
114			$this->result = $this->name = $this->escapeField($name);
115			}
116
117			public function setAllias(string $alliasName): void
118			{
119			$this->allias = $this->escapeField($alliasName);
120			}
121
122			public function setFunction(string $functionName): void
123			{
124			if (!in_array(strtoupper($functionName), $this->functionsList)) {
125			throw new \InvalidArgumentException('MYSQL Функция ' . $functionName . ' не найдена \|SELECT setFunction\|');
126			}
127			$this->result = strtoupper($functionName) . '(' . $this->name . ')';
128			}
129
130			public function result(): string
131			{
132			return $this->result . (!is_null($this->allias) ? ' AS ' . $this->allias : '');
133			}
134			}
135

Compolomus / SQLQueryBuilder

Branch — develop (a6526d)

Fields::setFunction() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like