MySQL80Keywords::getKeywords() - Code Metrics - Inspection of "Add MySQL 8 reserved keywords" - doctrine/dbal - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Pull Request — master (#3128)

by Michele

created 2018-05-03 15:49 UTC

MySQL80Keywords::getKeywords() B

↳ Parent: MySQL80Keywords

Complexity

Conditions	1
Paths	1

Size

Total Lines	266
Code Lines	264

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	266
rs	8.2857
c	0
b	0
f	0
cc	1
eloc	264
nc	1
nop	0

How to fix Long Method

<?php
/*
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
 * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
 * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
 * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
 * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
 * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
 * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
 * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
 * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
 * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
 * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 *
 * This software consists of voluntary contributions made by many individuals
 * and is licensed under the MIT license. For more information, see
 * <http://www.doctrine-project.org>.
 */

namespace Doctrine\DBAL\Platforms\Keywords;

/**
 * MySQL 8.0 reserved keywords list.
 *
 * @link   www.doctrine-project.org
 */
class MySQL80Keywords extends MySQL57Keywords
{
    /**
     * {@inheritdoc}
     */
    public function getName()
    {
        return 'MySQL80';
    }

    /**
     * {@inheritdoc}
     *
     * @link https://dev.mysql.com/doc/refman/8.0/en/keywords.html
     */
    protected function getKeywords()
    {
        return [
            'ACCESSIBLE',
            'ADD',
            'ADMIN',
            'ALL',
            'ALTER',
            'ANALYZE',
            'AND',
            'AS',
            'ASC',
            'ASENSITIVE',
            'BEFORE',
            'BETWEEN',
            'BIGINT',
            'BINARY',
            'BLOB',
            'BOTH',
            'BY',
            'CALL',
            'CASCADE',
            'CASE',
            'CHANGE',
            'CHAR',
            'CHARACTER',
            'CHECK',
            'COLLATE',
            'COLUMN',
            'CONDITION',
            'CONSTRAINT',
            'CONTINUE',
            'CONVERT',
            'CREATE',
            'CROSS',
            'CUBE',
            'CUME_DIST',
            'CURRENT_DATE',
            'CURRENT_TIME',
            'CURRENT_TIMESTAMP',
            'CURRENT_USER',
            'CURSOR',
            'DATABASE',
            'DATABASES',
            'DAY_HOUR',
            'DAY_MICROSECOND',
            'DAY_MINUTE',
            'DAY_SECOND',
            'DEC',
            'DECIMAL',
            'DECLARE',
            'DEFAULT',
            'DELAYED',
            'DELETE',
            'DENSE_RANK',
            'DESC',
            'DESCRIBE',
            'DETERMINISTIC',
            'DISTINCT',
            'DISTINCTROW',
            'DIV',
            'DOUBLE',
            'DROP',
            'DUAL',
            'EACH',
            'ELSE',
            'ELSEIF',
            'EMPTY',
            'ENCLOSED',
            'ESCAPED',
            'EXCEPT',
            'EXISTS',
            'EXIT',
            'EXPLAIN',
            'FALSE',
            'FETCH',
            'FIRST_VALUE',
            'FLOAT',
            'FLOAT4',
            'FLOAT8',
            'FOR',
            'FORCE',
            'FOREIGN',
            'FROM',
            'FULLTEXT',
            'FUNCTION',
            'GENERATED',
            'GET',
            'GRANT',
            'GROUP',
            'GROUPING',
            'GROUPS',
            'HAVING',
            'HIGH_PRIORITY',
            'HOUR_MICROSECOND',
            'HOUR_MINUTE',
            'HOUR_SECOND',
            'IF',
            'IGNORE',
            'IN',
            'INDEX',
            'INFILE',
            'INNER',
            'INOUT',
            'INSENSITIVE',
            'INSERT',
            'INT',
            'INT1',
            'INT2',
            'INT3',
            'INT4',
            'INT8',
            'INTEGER',
            'INTERVAL',
            'INTO',
            'IO_AFTER_GTIDS',
            'IO_BEFORE_GTIDS',
            'IS',
            'ITERATE',
            'JOIN',
            'JSON_TABLE',
            'KEY',
            'KEYS',
            'KILL',
            'LAG',
            'LAST_VALUE',
            'LEAD',
            'LEADING',
            'LEAVE',
            'LEFT',
            'LIKE',
            'LIMIT',
            'LINEAR',
            'LINES',
            'LOAD',
            'LOCALTIME',
            'LOCALTIMESTAMP',
            'LOCK',
            'LONG',
            'LONGBLOB',
            'LONGTEXT',
            'LOOP',
            'LOW_PRIORITY',
            'MASTER_BIND',
            'MASTER_SSL_VERIFY_SERVER_CERT',
            'MATCH',
            'MAXVALUE',
            'MEDIUMBLOB',
            'MEDIUMINT',
            'MEDIUMTEXT',
            'MIDDLEINT',
            'MINUTE_MICROSECOND',
            'MINUTE_SECOND',
            'MOD',
            'MODIFIES',
            'NATURAL',
            'NO_WRITE_TO_BINLOG',
            'NOT',
            'NTH_VALUE',
            'NTILE',
            'NULL',
            'NUMERIC',
            'OF',
            'ON',
            'OPTIMIZE',
            'OPTIMIZER_COSTS',
            'OPTION',
            'OPTIONALLY',
            'OR',
            'ORDER',
            'OUT',
            'OUTER',
            'OUTFILE',
            'OVER',
            'PARTITION',
            'PERCENT_RANK',
            'PERSIST',
            'PERSIST_ONLY',
            'PRECISION',
            'PRIMARY',
            'PROCEDURE',
            'PURGE',
            'RANGE',
            'RANK',
            'READ',
            'READ_WRITE',
            'READS',
            'REAL',
            'RECURSIVE',
            'REFERENCES',
            'REGEXP',
            'RELEASE',
            'RENAME',
            'REPEAT',
            'REPLACE',
            'REQUIRE',
            'RESIGNAL',
            'RESTRICT',
            'RETURN',
            'REVOKE',
            'RIGHT',
            'RLIKE',
            'ROW',
            'ROWS',
            'ROW_NUMBER',
            'SCHEMA',
            'SCHEMAS',
            'SECOND_MICROSECOND',
            'SELECT',
            'SENSITIVE',
            'SEPARATOR',
            'SET',
            'SHOW',
            'SIGNAL',
            'SMALLINT',
            'SPATIAL',
            'SPECIFIC',
            'SQL',
            'SQL_BIG_RESULT',
            'SQL_CALC_FOUND_ROWS',
            'SQL_SMALL_RESULT',
            'SQLEXCEPTION',
            'SQLSTATE',
            'SQLWARNING',
            'SSL',
            'STARTING',
            'STORED',
            'STRAIGHT_JOIN',
            'SYSTEM',
            'TABLE',
            'TERMINATED',
            'THEN',
            'TINYBLOB',
            'TINYINT',
            'TINYTEXT',
            'TO',
            'TRAILING',
            'TRIGGER',
            'TRUE',
            'UNDO',
            'UNION',
            'UNIQUE',
            'UNLOCK',
            'UNSIGNED',
            'UPDATE',
            'USAGE',
            'USE',
            'USING',
            'UTC_DATE',
            'UTC_TIME',
            'UTC_TIMESTAMP',
            'VALUES',
            'VARBINARY',
            'VARCHAR',
            'VARCHARACTER',
            'VARYING',
            'VIRTUAL',
            'WHEN',
            'WHERE',
            'WHILE',
            'WINDOW',
            'WITH',
            'WRITE',
            'XOR',
            'YEAR_MONTH',
            'ZEROFILL',
        ];
    }
}


1			<?php
2			/*
3			* THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
4			* "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
5			* LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
6			* A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
7			* OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
8			* SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
9			* LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
10			* DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
11			* THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
12			* (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
13			* OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
14			*
15			* This software consists of voluntary contributions made by many individuals
16			* and is licensed under the MIT license. For more information, see
17			* <http://www.doctrine-project.org>.
18			*/
19
20			namespace Doctrine\DBAL\Platforms\Keywords;
21
22			/**
23			* MySQL 8.0 reserved keywords list.
24			*
25			* @link www.doctrine-project.org
26			*/
27			class MySQL80Keywords extends MySQL57Keywords
28			{
29			/**
30			* {@inheritdoc}
31			*/
32			public function getName()
33			{
34			return 'MySQL80';
35			}
36
37			/**
38			* {@inheritdoc}
39			*
40			* @link https://dev.mysql.com/doc/refman/8.0/en/keywords.html
41			*/
42			protected function getKeywords()
43			{
44			return [
45			'ACCESSIBLE',
46			'ADD',
47			'ADMIN',
48			'ALL',
49			'ALTER',
50			'ANALYZE',
51			'AND',
52			'AS',
53			'ASC',
54			'ASENSITIVE',
55			'BEFORE',
56			'BETWEEN',
57			'BIGINT',
58			'BINARY',
59			'BLOB',
60			'BOTH',
61			'BY',
62			'CALL',
63			'CASCADE',
64			'CASE',
65			'CHANGE',
66			'CHAR',
67			'CHARACTER',
68			'CHECK',
69			'COLLATE',
70			'COLUMN',
71			'CONDITION',
72			'CONSTRAINT',
73			'CONTINUE',
74			'CONVERT',
75			'CREATE',
76			'CROSS',
77			'CUBE',
78			'CUME_DIST',
79			'CURRENT_DATE',
80			'CURRENT_TIME',
81			'CURRENT_TIMESTAMP',
82			'CURRENT_USER',
83			'CURSOR',
84			'DATABASE',
85			'DATABASES',
86			'DAY_HOUR',
87			'DAY_MICROSECOND',
88			'DAY_MINUTE',
89			'DAY_SECOND',
90			'DEC',
91			'DECIMAL',
92			'DECLARE',
93			'DEFAULT',
94			'DELAYED',
95			'DELETE',
96			'DENSE_RANK',
97			'DESC',
98			'DESCRIBE',
99			'DETERMINISTIC',
100			'DISTINCT',
101			'DISTINCTROW',
102			'DIV',
103			'DOUBLE',
104			'DROP',
105			'DUAL',
106			'EACH',
107			'ELSE',
108			'ELSEIF',
109			'EMPTY',
110			'ENCLOSED',
111			'ESCAPED',
112			'EXCEPT',
113			'EXISTS',
114			'EXIT',
115			'EXPLAIN',
116			'FALSE',
117			'FETCH',
118			'FIRST_VALUE',
119			'FLOAT',
120			'FLOAT4',
121			'FLOAT8',
122			'FOR',
123			'FORCE',
124			'FOREIGN',
125			'FROM',
126			'FULLTEXT',
127			'FUNCTION',
128			'GENERATED',
129			'GET',
130			'GRANT',
131			'GROUP',
132			'GROUPING',
133			'GROUPS',
134			'HAVING',
135			'HIGH_PRIORITY',
136			'HOUR_MICROSECOND',
137			'HOUR_MINUTE',
138			'HOUR_SECOND',
139			'IF',
140			'IGNORE',
141			'IN',
142			'INDEX',
143			'INFILE',
144			'INNER',
145			'INOUT',
146			'INSENSITIVE',
147			'INSERT',
148			'INT',
149			'INT1',
150			'INT2',
151			'INT3',
152			'INT4',
153			'INT8',
154			'INTEGER',
155			'INTERVAL',
156			'INTO',
157			'IO_AFTER_GTIDS',
158			'IO_BEFORE_GTIDS',
159			'IS',
160			'ITERATE',
161			'JOIN',
162			'JSON_TABLE',
163			'KEY',
164			'KEYS',
165			'KILL',
166			'LAG',
167			'LAST_VALUE',
168			'LEAD',
169			'LEADING',
170			'LEAVE',
171			'LEFT',
172			'LIKE',
173			'LIMIT',
174			'LINEAR',
175			'LINES',
176			'LOAD',
177			'LOCALTIME',
178			'LOCALTIMESTAMP',
179			'LOCK',
180			'LONG',
181			'LONGBLOB',
182			'LONGTEXT',
183			'LOOP',
184			'LOW_PRIORITY',
185			'MASTER_BIND',
186			'MASTER_SSL_VERIFY_SERVER_CERT',
187			'MATCH',
188			'MAXVALUE',
189			'MEDIUMBLOB',
190			'MEDIUMINT',
191			'MEDIUMTEXT',
192			'MIDDLEINT',
193			'MINUTE_MICROSECOND',
194			'MINUTE_SECOND',
195			'MOD',
196			'MODIFIES',
197			'NATURAL',
198			'NO_WRITE_TO_BINLOG',
199			'NOT',
200			'NTH_VALUE',
201			'NTILE',
202			'NULL',
203			'NUMERIC',
204			'OF',
205			'ON',
206			'OPTIMIZE',
207			'OPTIMIZER_COSTS',
208			'OPTION',
209			'OPTIONALLY',
210			'OR',
211			'ORDER',
212			'OUT',
213			'OUTER',
214			'OUTFILE',
215			'OVER',
216			'PARTITION',
217			'PERCENT_RANK',
218			'PERSIST',
219			'PERSIST_ONLY',
220			'PRECISION',
221			'PRIMARY',
222			'PROCEDURE',
223			'PURGE',
224			'RANGE',
225			'RANK',
226			'READ',
227			'READ_WRITE',
228			'READS',
229			'REAL',
230			'RECURSIVE',
231			'REFERENCES',
232			'REGEXP',
233			'RELEASE',
234			'RENAME',
235			'REPEAT',
236			'REPLACE',
237			'REQUIRE',
238			'RESIGNAL',
239			'RESTRICT',
240			'RETURN',
241			'REVOKE',
242			'RIGHT',
243			'RLIKE',
244			'ROW',
245			'ROWS',
246			'ROW_NUMBER',
247			'SCHEMA',
248			'SCHEMAS',
249			'SECOND_MICROSECOND',
250			'SELECT',
251			'SENSITIVE',
252			'SEPARATOR',
253			'SET',
254			'SHOW',
255			'SIGNAL',
256			'SMALLINT',
257			'SPATIAL',
258			'SPECIFIC',
259			'SQL',
260			'SQL_BIG_RESULT',
261			'SQL_CALC_FOUND_ROWS',
262			'SQL_SMALL_RESULT',
263			'SQLEXCEPTION',
264			'SQLSTATE',
265			'SQLWARNING',
266			'SSL',
267			'STARTING',
268			'STORED',
269			'STRAIGHT_JOIN',
270			'SYSTEM',
271			'TABLE',
272			'TERMINATED',
273			'THEN',
274			'TINYBLOB',
275			'TINYINT',
276			'TINYTEXT',
277			'TO',
278			'TRAILING',
279			'TRIGGER',
280			'TRUE',
281			'UNDO',
282			'UNION',
283			'UNIQUE',
284			'UNLOCK',
285			'UNSIGNED',
286			'UPDATE',
287			'USAGE',
288			'USE',
289			'USING',
290			'UTC_DATE',
291			'UTC_TIME',
292			'UTC_TIMESTAMP',
293			'VALUES',
294			'VARBINARY',
295			'VARCHAR',
296			'VARCHARACTER',
297			'VARYING',
298			'VIRTUAL',
299			'WHEN',
300			'WHERE',
301			'WHILE',
302			'WINDOW',
303			'WITH',
304			'WRITE',
305			'XOR',
306			'YEAR_MONTH',
307			'ZEROFILL',
308			];
309			}
310			}
311

doctrine / dbal

Pull Request — master (#3128)

MySQL80Keywords::getKeywords() B

Complexity

Size

Duplication

Importance

How to fix Long Method

Long Method

Duplication Side-by-Side

Filter issues like