SQLServer2012Keywords::getKeywords() - Code Metrics - Inspection of "Merge branch '3.0.x'" - doctrine/dbal - Measure and Improve Code Quality continuously with Scrutinizer

Failed Conditions

Push — master ( 01143c...7811e4 )

by Sergei

created 2020-03-21 15:36 UTC

SQLServer2012Keywords::getKeywords() B

↳ Parent: SQLServer2012Keywords

Complexity

Conditions	1
Paths	1

Size

Total Lines	188
Code Lines	186

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
eloc	186
dl	0
loc	188
rs	8
c	0
b	0
f	0
cc	1
nc	1
nop	0

How to fix Long Method

<?php

declare(strict_types=1);

namespace Doctrine\DBAL\Platforms\Keywords;

/**
 * Microsoft SQL Server 2012 reserved keyword dictionary.
 */
class SQLServer2012Keywords extends KeywordList
{
    public function getName() : string
    {
        return 'SQLServer2012';
    }

    /**
     * {@inheritdoc}
     *
     * @link http://msdn.microsoft.com/en-us/library/aa238507%28v=sql.80%29.aspx
     */
    protected function getKeywords() : array
    {
        return [
            'ADD',
            'ALL',
            'ALTER',
            'AND',
            'ANY',
            'AS',
            'ASC',
            'AUTHORIZATION',
            'BACKUP',
            'BEGIN',
            'BETWEEN',
            'BREAK',
            'BROWSE',
            'BULK',
            'BY',
            'CASCADE',
            'CASE',
            'CHECK',
            'CHECKPOINT',
            'CLOSE',
            'CLUSTERED',
            'COALESCE',
            'COLLATE',
            'COLUMN',
            'COMMIT',
            'COMPUTE',
            'CONSTRAINT',
            'CONTAINS',
            'CONTAINSTABLE',
            'CONTINUE',
            'CONVERT',
            'CREATE',
            'CROSS',
            'CURRENT',
            'CURRENT_DATE',
            'CURRENT_TIME',
            'CURRENT_TIMESTAMP',
            'CURRENT_USER',
            'CURSOR',
            'DATABASE',
            'DBCC',
            'DEALLOCATE',
            'DECLARE',
            'DEFAULT',
            'DELETE',
            'DENY',
            'DESC',
            'DISK',
            'DISTINCT',
            'DISTRIBUTED',
            'DOUBLE',
            'DROP',
            'DUMP',
            'ELSE',
            'END',
            'ERRLVL',
            'ESCAPE',
            'EXCEPT',
            'EXEC',
            'EXECUTE',
            'EXISTS',
            'EXIT',
            'EXTERNAL',
            'FETCH',
            'FILE',
            'FILLFACTOR',
            'FOR',
            'FOREIGN',
            'FREETEXT',
            'FREETEXTTABLE',
            'FROM',
            'FULL',
            'FUNCTION',
            'GOTO',
            'GRANT',
            'GROUP',
            'HAVING',
            'HOLDLOCK',
            'IDENTITY',
            'IDENTITY_INSERT',
            'IDENTITYCOL',
            'IF',
            'IN',
            'INDEX',
            'INNER',
            'INSERT',
            'INTERSECT',
            'INTO',
            'IS',
            'JOIN',
            'KEY',
            'KILL',
            'LEFT',
            'LIKE',
            'LINENO',
            'LOAD',
            'MERGE',
            'NATIONAL',
            'NOCHECK ',
            'NONCLUSTERED',
            'NOT',
            'NULL',
            'NULLIF',
            'OF',
            'OFF',
            'OFFSETS',
            'ON',
            'OPEN',
            'OPENDATASOURCE',
            'OPENQUERY',
            'OPENROWSET',
            'OPENXML',
            'OPTION',
            'OR',
            'ORDER',
            'OUTER',
            'OVER',
            'PERCENT',
            'PIVOT',
            'PLAN',
            'PRECISION',
            'PRIMARY',
            'PRINT',
            'PROC',
            'PROCEDURE',
            'PUBLIC',
            'RAISERROR',
            'READ',
            'READTEXT',
            'RECONFIGURE',
            'REFERENCES',
            'REPLICATION',
            'RESTORE',
            'RESTRICT',
            'RETURN',
            'REVERT',
            'REVOKE',
            'RIGHT',
            'ROLLBACK',
            'ROWCOUNT',
            'ROWGUIDCOL',
            'RULE',
            'SAVE',
            'SCHEMA',
            'SECURITYAUDIT',
            'SELECT',
            'SEMANTICKEYPHRASETABLE',
            'SEMANTICSIMILARITYDETAILSTABLE',
            'SEMANTICSIMILARITYTABLE',
            'SESSION_USER',
            'SET',
            'SETUSER',
            'SHUTDOWN',
            'SOME',
            'STATISTICS',
            'SYSTEM_USER',
            'TABLE',
            'TABLESAMPLE',
            'TEXTSIZE',
            'THEN',
            'TO',
            'TOP',
            'TRAN',
            'TRANSACTION',
            'TRIGGER',
            'TRUNCATE',
            'TRY_CONVERT',
            'TSEQUAL',
            'UNION',
            'UNIQUE',
            'UNPIVOT',
            'UPDATE',
            'UPDATETEXT',
            'USE',
            'USER',
            'VALUES',
            'VARYING',
            'VIEW',
            'WAITFOR',
            'WHEN',
            'WHERE',
            'WHILE',
            'WITH',
            'WITHIN GROUP',
            'WRITETEXT',
        ];
    }
}


1			<?php
2
3			declare(strict_types=1);
4
5			namespace Doctrine\DBAL\Platforms\Keywords;
6
7			/**
8			* Microsoft SQL Server 2012 reserved keyword dictionary.
9			*/
10			class SQLServer2012Keywords extends KeywordList
11			{
12			public function getName() : string
13			{
14			return 'SQLServer2012';
15			}
16
17			/**
18			* {@inheritdoc}
19			*
20			* @link http://msdn.microsoft.com/en-us/library/aa238507%28v=sql.80%29.aspx
21			*/
22			protected function getKeywords() : array
23			{
24			return [
25			'ADD',
26			'ALL',
27			'ALTER',
28			'AND',
29			'ANY',
30			'AS',
31			'ASC',
32			'AUTHORIZATION',
33			'BACKUP',
34			'BEGIN',
35			'BETWEEN',
36			'BREAK',
37			'BROWSE',
38			'BULK',
39			'BY',
40			'CASCADE',
41			'CASE',
42			'CHECK',
43			'CHECKPOINT',
44			'CLOSE',
45			'CLUSTERED',
46			'COALESCE',
47			'COLLATE',
48			'COLUMN',
49			'COMMIT',
50			'COMPUTE',
51			'CONSTRAINT',
52			'CONTAINS',
53			'CONTAINSTABLE',
54			'CONTINUE',
55			'CONVERT',
56			'CREATE',
57			'CROSS',
58			'CURRENT',
59			'CURRENT_DATE',
60			'CURRENT_TIME',
61			'CURRENT_TIMESTAMP',
62			'CURRENT_USER',
63			'CURSOR',
64			'DATABASE',
65			'DBCC',
66			'DEALLOCATE',
67			'DECLARE',
68			'DEFAULT',
69			'DELETE',
70			'DENY',
71			'DESC',
72			'DISK',
73			'DISTINCT',
74			'DISTRIBUTED',
75			'DOUBLE',
76			'DROP',
77			'DUMP',
78			'ELSE',
79			'END',
80			'ERRLVL',
81			'ESCAPE',
82			'EXCEPT',
83			'EXEC',
84			'EXECUTE',
85			'EXISTS',
86			'EXIT',
87			'EXTERNAL',
88			'FETCH',
89			'FILE',
90			'FILLFACTOR',
91			'FOR',
92			'FOREIGN',
93			'FREETEXT',
94			'FREETEXTTABLE',
95			'FROM',
96			'FULL',
97			'FUNCTION',
98			'GOTO',
99			'GRANT',
100			'GROUP',
101			'HAVING',
102			'HOLDLOCK',
103			'IDENTITY',
104			'IDENTITY_INSERT',
105			'IDENTITYCOL',
106			'IF',
107			'IN',
108			'INDEX',
109			'INNER',
110			'INSERT',
111			'INTERSECT',
112			'INTO',
113			'IS',
114			'JOIN',
115			'KEY',
116			'KILL',
117			'LEFT',
118			'LIKE',
119			'LINENO',
120			'LOAD',
121			'MERGE',
122			'NATIONAL',
123			'NOCHECK ',
124			'NONCLUSTERED',
125			'NOT',
126			'NULL',
127			'NULLIF',
128			'OF',
129			'OFF',
130			'OFFSETS',
131			'ON',
132			'OPEN',
133			'OPENDATASOURCE',
134			'OPENQUERY',
135			'OPENROWSET',
136			'OPENXML',
137			'OPTION',
138			'OR',
139			'ORDER',
140			'OUTER',
141			'OVER',
142			'PERCENT',
143			'PIVOT',
144			'PLAN',
145			'PRECISION',
146			'PRIMARY',
147			'PRINT',
148			'PROC',
149			'PROCEDURE',
150			'PUBLIC',
151			'RAISERROR',
152			'READ',
153			'READTEXT',
154			'RECONFIGURE',
155			'REFERENCES',
156			'REPLICATION',
157			'RESTORE',
158			'RESTRICT',
159			'RETURN',
160			'REVERT',
161			'REVOKE',
162			'RIGHT',
163			'ROLLBACK',
164			'ROWCOUNT',
165			'ROWGUIDCOL',
166			'RULE',
167			'SAVE',
168			'SCHEMA',
169			'SECURITYAUDIT',
170			'SELECT',
171			'SEMANTICKEYPHRASETABLE',
172			'SEMANTICSIMILARITYDETAILSTABLE',
173			'SEMANTICSIMILARITYTABLE',
174			'SESSION_USER',
175			'SET',
176			'SETUSER',
177			'SHUTDOWN',
178			'SOME',
179			'STATISTICS',
180			'SYSTEM_USER',
181			'TABLE',
182			'TABLESAMPLE',
183			'TEXTSIZE',
184			'THEN',
185			'TO',
186			'TOP',
187			'TRAN',
188			'TRANSACTION',
189			'TRIGGER',
190			'TRUNCATE',
191			'TRY_CONVERT',
192			'TSEQUAL',
193			'UNION',
194			'UNIQUE',
195			'UNPIVOT',
196			'UPDATE',
197			'UPDATETEXT',
198			'USE',
199			'USER',
200			'VALUES',
201			'VARYING',
202			'VIEW',
203			'WAITFOR',
204			'WHEN',
205			'WHERE',
206			'WHILE',
207			'WITH',
208			'WITHIN GROUP',
209			'WRITETEXT',
210			];
211			}
212			}
213

doctrine / dbal

Push — master ( 01143c...7811e4 )

SQLServer2012Keywords::getKeywords() B

Complexity

Size

Duplication

Importance

How to fix Long Method

Long Method

Duplication Side-by-Side

Filter issues like