OracleSqlStateCode - Code Metrics - Inspection of "Refactor PdoOci8 and PdoOci8Statement" - jpina/pdooci8 - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Branch — dev-0.1.x (cbb4c7)

by Josué

created 2016-03-31 11:53 UTC

OracleSqlStateCode F

↳ Parent: Project

Complexity

Total Complexity

169

Size/Duplication

Total Lines	174
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	0

Test Coverage

Coverage

25.47%

Importance

Changes	1
Bugs	0	Features	1

Metric	Value
wmc	169
c	1
b	0
f	1
lcom	0
cbo	0
dl	0
loc	174
ccs	41
cts	161
cp	0.2547
rs	1.5789

2 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	3	1
D	getSqlStateErrorCode()	0	162	168

How to fix Complexity

<?php

namespace Jpina\PdoOci8;

use Jpina\PdoOci8\SqlStateCode;

class OracleSqlStateCode
{
    private function __construct()
    {
    }

    /**
     * @param int $errorCode
     * @return string
     * @see https://docs.oracle.com/cd/F49540_01/DOC/server.815/a58231/appd.htm
     */
    public static function getSqlStateErrorCode($errorCode)
    {
        switch (true) {
            case $errorCode === 0:
                return SqlStateCode::SUCCESSFUL_COMPLETION;
            case $errorCode === 1095 || $errorCode === 1403:
                return SqlStateCode::NO_DATA;
            case $errorCode === 2126:
                return SqlStateCode::INVALID_DESCRIPTOR_COUNT;
            case $errorCode === 2121:
                return SqlStateCode::CONNECTION_DOES_NOT_EXIST;
            case $errorCode >= 3000 && $errorCode <= 3099:
                return SqlStateCode::FEATURE_NOT_SUPPORTED;
            case $errorCode === 1427 || $errorCode === 2112:
                return SqlStateCode::CARDINALITY_VIOLATION;
            case $errorCode === 1401 || $errorCode === 1406:
                return SqlStateCode::STRING_DATA_RIGHT_TRUNCATION;
            case $errorCode === 1405 || $errorCode === 2124:
                return SqlStateCode::INDICATOR_VARIABLE_NOT_SUPPLIED;
            case $errorCode === 1426 || $errorCode === 1438:
            case $errorCode === 1455 || $errorCode === 1457:
                return SqlStateCode::NUMERIC_VALUE_OUT_OF_RANGE;
            case $errorCode >= 1800 && $errorCode <= 1899:
                return SqlStateCode::DATETIME_FIELD_OVERFLOW;
            case $errorCode === 1476:
                return SqlStateCode::DIVISION_BY_ZERO;
            case $errorCode === 911 || $errorCode === 1425:
                return SqlStateCode::INVALID_ESCAPE_CHAR;
            case $errorCode === 1411:
                return SqlStateCode::INDICATOR_OVERFLOW;
            case $errorCode === 1025 || $errorCode === 1488:
            case $errorCode >= 4000 && $errorCode <= 4019:
                return SqlStateCode::INVALID_PARAM_VALUE;
            case $errorCode >= 1479 && $errorCode <= 1480:
                return SqlStateCode::UNTERMINATED_C_STRING;
            case $errorCode === 1424:
                return SqlStateCode::INVALID_ESCAPE_SEQUENCE;
            case $errorCode === 1:
            case $errorCode >= 2290 && $errorCode <= 2299:
                return SqlStateCode::INTEGRITY_CONSTRAINT_VIOLATION_1;
            case $errorCode >= 1001 && $errorCode <= 1003:
            case $errorCode === 1410 || $errorCode === 8006:
            case $errorCode === 2114 || $errorCode === 2117:
            case $errorCode === 2118 || $errorCode === 2122:
                return SqlStateCode::INVALID_CURSOR_STATE;
            case $errorCode === 2091 || $errorCode === 2092:
                return SqlStateCode::TRANSACTION_ROLLBACK;
            case $errorCode === 22 || $errorCode === 251:
            case $errorCode >= 900 && $errorCode <= 999:
            case $errorCode === 1031:
            case $errorCode >= 1490 && $errorCode <= 1493:
            case $errorCode >= 1700 && $errorCode <= 1799:
            case $errorCode >= 1900 && $errorCode <= 2099:
            case $errorCode >= 2140 && $errorCode <= 2289:
            case $errorCode >= 2420 && $errorCode <= 2424:
            case $errorCode >= 2450 && $errorCode <= 2499:
            case $errorCode >= 3276 && $errorCode <= 3299:
            case $errorCode >= 4040 && $errorCode <= 4059:
            case $errorCode >= 4070 && $errorCode <= 4099:
                return SqlStateCode::SYNTAX_ERROR_OR_ACCESS_RULE_VIOLATION_3;
            case $errorCode === 1402:
                return SqlStateCode::WITH_CHECK_OPTION_VIOLATION;
            case $errorCode >= 370 && $errorCode <= 429:
            case $errorCode >= 600 && $errorCode <= 899:
            case $errorCode >= 6430 && $errorCode <= 6449:
            case $errorCode >= 7200 && $errorCode <= 7999:
            case $errorCode >= 9700 && $errorCode <= 9999:
                return SqlStateCode::SYSTEM_ERRORS;
            case $errorCode >= 18 && $errorCode <= 35:
            case $errorCode >= 50 && $errorCode <= 68:
            case $errorCode >= 2376 && $errorCode <= 2399:
            case $errorCode >= 4020 && $errorCode <= 4039:
                return SqlStateCode::RESOURCE_ERROR;
            case $errorCode >= 100 && $errorCode <= 120:
            case $errorCode >= 440 && $errorCode <= 569:
                return SqlStateCode::MULTI_THREADED_SERVER_OR_DETACHED_PROCESS_ERROR;
            case $errorCode >= 150 && $errorCode <= 159:
            case $errorCode === 2128:
            case $errorCode >= 2700 && $errorCode <= 2899:
            case $errorCode >= 3100 && $errorCode <= 3199:
            case $errorCode >= 6200 && $errorCode <= 6249:
                return SqlStateCode::ORACLE_XA_AND_2_TASK_INTERFACE_ERROR;
            case $errorCode >= 200 && $errorCode <= 369:
            case $errorCode >= 1100 && $errorCode <= 1250:
                return SqlStateCode::ARCHIVAL_AND_MEDIA_RECOVERY_ERROR;
            case $errorCode >= 6500 && $errorCode <= 6599:
                return SqlStateCode::PL_SQL_ERROR;
            case $errorCode >= 6000 && $errorCode <= 6149:
            case $errorCode >= 6250 && $errorCode <= 6429:
            case $errorCode >= 6600 && $errorCode <= 6999:
            case $errorCode >= 12100 && $errorCode <= 12299:
            case $errorCode >= 12500 && $errorCode <= 12599:
                return SqlStateCode::SQL_NET_DRIVER_ERROR;
            case $errorCode >= 430 && $errorCode <= 439:
                return SqlStateCode::LICENSING_ERROR;
            case $errorCode >= 570 && $errorCode <= 599:
            case $errorCode >= 7000 && $errorCode <= 7199:
                return SqlStateCode::SQL_CONNECT_ERROR;
            case $errorCode >= 1000 && $errorCode <= 1099:
            case $errorCode >= 1400 && $errorCode <= 1489:
            case $errorCode >= 1495 && $errorCode <= 1499:
            case $errorCode >= 1500 && $errorCode <= 1699:
            case $errorCode >= 2400 && $errorCode <= 2419:
            case $errorCode >= 2425 && $errorCode <= 2449:
            case $errorCode >= 4060 && $errorCode <= 4069:
            case $errorCode >= 8000 && $errorCode <= 8190:
            case $errorCode >= 12000 && $errorCode <= 12019:
            case $errorCode >= 12300 && $errorCode <= 12499:
            case $errorCode >= 12700 && $errorCode <= 21999:
                return SqlStateCode::SQL_EXECUTE_PHASE_ERROR;
            case $errorCode === 2100:
                return SqlStateCode::OUT_OF_MEMORY;
            case $errorCode === 2101:
                return SqlStateCode::INCONSISTENT_CURSOR_CACHE_MISMATCH;
            case $errorCode === 2102:
                return SqlStateCode::INCONSISTENT_CURSOR_CACHE_NO_ENTRY;
            case $errorCode === 2103:
                return SqlStateCode::INCONSISTENT_CURSOR_CACHE_REF_OUT_OF_RANGE;
            case $errorCode === 2104:
                return SqlStateCode::INCONSISTENT_HOST_CACHE_NOT_AVAILABLE;
            case $errorCode === 2105:
                return SqlStateCode::INCONSISTENT_CURSOR_CACHE_NOT_FOUND;
            case $errorCode === 2106:
                return SqlStateCode::INCONSISTENT_CURSOR_CACHE_INVALID_NUMBER;
            case $errorCode === 2107:
                return SqlStateCode::PROGRAM_TOO_OLD;
            case $errorCode === 2108:
                return SqlStateCode::INVALID_DESCRIPTOR_PASSED;
            case $errorCode === 2109:
                return SqlStateCode::INCONSISTENT_HOST_CACHE_REF_OUT_OF_RANGE;
            case $errorCode === 2110:
                return SqlStateCode::INCONSISTENT_HOST_CACHE_INVALID_ENTRY_TYPE;
            case $errorCode === 2111:
                return SqlStateCode::HEAP_CONSISTENCY_ERROR;
            case $errorCode === 2113:
                return SqlStateCode::UNABLE_TO_OPEN_MESSAGE_FILE;
            case $errorCode === 2115:
                return SqlStateCode::CODE_GENERATION_INTERNAL_CONSISTENCY_FAILED;
            case $errorCode === 2116:
                return SqlStateCode::REENTRANT_CODE_GENERATOR_GAVE_INVALID_CONTEXT;
            case $errorCode === 2119:
                return SqlStateCode::INVALID_HSTDEF_ARGUMENT;
            case $errorCode === 2120:
                return SqlStateCode::FIRST_AND_SECOND_ARGS_TO_SQLRCN_BOTH_NULL;
            case $errorCode === 2122:
                return SqlStateCode::INVALID_OPEN_OR_PREPARE;
            case $errorCode === 2123:
                return SqlStateCode::APPLICATION_CONTEXT_NOT_FOUND;
            case $errorCode === 2125:
                return SqlStateCode::CONNECTION_ERROR_NO_ERROR_TEXT;
            case $errorCode === 2127:
                return SqlStateCode::PRECOMPILER_VERSION_MISMATCH;
            case $errorCode === 2129:
                return SqlStateCode::FETCHED_NUMBER_OF_BYTES_IS_ODD;
            case $errorCode === 2130:
                return SqlStateCode::EXEC_TOOLS_INTERFACE_NOT_AVAILABLE;
            case $errorCode >= 10000 && $errorCode <= 10999:
                return SqlStateCode::DEBUG_EVENTS;
        }

        return SqlStateCode::GENERAL_ERROR;
    }
}


1		<?php
2
3		namespace Jpina\PdoOci8;
4
5		use Jpina\PdoOci8\SqlStateCode;
6
7		class OracleSqlStateCode
8		{
9		private function __construct()
10		{
11		}
12
13		/**
14		* @param int $errorCode
15		* @return string
16		* @see https://docs.oracle.com/cd/F49540_01/DOC/server.815/a58231/appd.htm
17		*/
18	3	public static function getSqlStateErrorCode($errorCode)
19		{
20	3	switch (true) {
21	3	case $errorCode === 0:
22	1	return SqlStateCode::SUCCESSFUL_COMPLETION;
23	2	case $errorCode === 1095 \|\| $errorCode === 1403:
24		return SqlStateCode::NO_DATA;
25	2	case $errorCode === 2126:
26		return SqlStateCode::INVALID_DESCRIPTOR_COUNT;
27	2	case $errorCode === 2121:
28		return SqlStateCode::CONNECTION_DOES_NOT_EXIST;
29	2	case $errorCode >= 3000 && $errorCode <= 3099:
30		return SqlStateCode::FEATURE_NOT_SUPPORTED;
31	2	case $errorCode === 1427 \|\| $errorCode === 2112:
32		return SqlStateCode::CARDINALITY_VIOLATION;
33	2	case $errorCode === 1401 \|\| $errorCode === 1406:
34		return SqlStateCode::STRING_DATA_RIGHT_TRUNCATION;
35	2	case $errorCode === 1405 \|\| $errorCode === 2124:
36		return SqlStateCode::INDICATOR_VARIABLE_NOT_SUPPLIED;
37	2	case $errorCode === 1426 \|\| $errorCode === 1438:
38	2	case $errorCode === 1455 \|\| $errorCode === 1457:
39		return SqlStateCode::NUMERIC_VALUE_OUT_OF_RANGE;
40	2	case $errorCode >= 1800 && $errorCode <= 1899:
41		return SqlStateCode::DATETIME_FIELD_OVERFLOW;
42	2	case $errorCode === 1476:
43		return SqlStateCode::DIVISION_BY_ZERO;
44	2	case $errorCode === 911 \|\| $errorCode === 1425:
45		return SqlStateCode::INVALID_ESCAPE_CHAR;
46	2	case $errorCode === 1411:
47		return SqlStateCode::INDICATOR_OVERFLOW;
48	2	case $errorCode === 1025 \|\| $errorCode === 1488:
49	2	case $errorCode >= 4000 && $errorCode <= 4019:
50		return SqlStateCode::INVALID_PARAM_VALUE;
51	2	case $errorCode >= 1479 && $errorCode <= 1480:
52		return SqlStateCode::UNTERMINATED_C_STRING;
53	2	case $errorCode === 1424:
54		return SqlStateCode::INVALID_ESCAPE_SEQUENCE;
55	2	case $errorCode === 1:
56	2	case $errorCode >= 2290 && $errorCode <= 2299:
57		return SqlStateCode::INTEGRITY_CONSTRAINT_VIOLATION_1;
58	2	case $errorCode >= 1001 && $errorCode <= 1003:
59	2	case $errorCode === 1410 \|\| $errorCode === 8006:
60	2	case $errorCode === 2114 \|\| $errorCode === 2117:
61	2	case $errorCode === 2118 \|\| $errorCode === 2122:
62		return SqlStateCode::INVALID_CURSOR_STATE;
63	2	case $errorCode === 2091 \|\| $errorCode === 2092:
64		return SqlStateCode::TRANSACTION_ROLLBACK;
65	2	case $errorCode === 22 \|\| $errorCode === 251:
66	2	case $errorCode >= 900 && $errorCode <= 999:
67	2	case $errorCode === 1031:
68	2	case $errorCode >= 1490 && $errorCode <= 1493:
69	2	case $errorCode >= 1700 && $errorCode <= 1799:
70	2	case $errorCode >= 1900 && $errorCode <= 2099:
71	2	case $errorCode >= 2140 && $errorCode <= 2289:
72	2	case $errorCode >= 2420 && $errorCode <= 2424:
73	2	case $errorCode >= 2450 && $errorCode <= 2499:
74	2	case $errorCode >= 3276 && $errorCode <= 3299:
75	2	case $errorCode >= 4040 && $errorCode <= 4059:
76	2	case $errorCode >= 4070 && $errorCode <= 4099:
77	2	return SqlStateCode::SYNTAX_ERROR_OR_ACCESS_RULE_VIOLATION_3;
78		case $errorCode === 1402:
79		return SqlStateCode::WITH_CHECK_OPTION_VIOLATION;
80		case $errorCode >= 370 && $errorCode <= 429:
81		case $errorCode >= 600 && $errorCode <= 899:
82		case $errorCode >= 6430 && $errorCode <= 6449:
83		case $errorCode >= 7200 && $errorCode <= 7999:
84		case $errorCode >= 9700 && $errorCode <= 9999:
85		return SqlStateCode::SYSTEM_ERRORS;
86		case $errorCode >= 18 && $errorCode <= 35:
87		case $errorCode >= 50 && $errorCode <= 68:
88		case $errorCode >= 2376 && $errorCode <= 2399:
89		case $errorCode >= 4020 && $errorCode <= 4039:
90		return SqlStateCode::RESOURCE_ERROR;
91		case $errorCode >= 100 && $errorCode <= 120:
92		case $errorCode >= 440 && $errorCode <= 569:
93		return SqlStateCode::MULTI_THREADED_SERVER_OR_DETACHED_PROCESS_ERROR;
94		case $errorCode >= 150 && $errorCode <= 159:
95		case $errorCode === 2128:
96		case $errorCode >= 2700 && $errorCode <= 2899:
97		case $errorCode >= 3100 && $errorCode <= 3199:
98		case $errorCode >= 6200 && $errorCode <= 6249:
99		return SqlStateCode::ORACLE_XA_AND_2_TASK_INTERFACE_ERROR;
100		case $errorCode >= 200 && $errorCode <= 369:
101		case $errorCode >= 1100 && $errorCode <= 1250:
102		return SqlStateCode::ARCHIVAL_AND_MEDIA_RECOVERY_ERROR;
103		case $errorCode >= 6500 && $errorCode <= 6599:
104		return SqlStateCode::PL_SQL_ERROR;
105		case $errorCode >= 6000 && $errorCode <= 6149:
106		case $errorCode >= 6250 && $errorCode <= 6429:
107		case $errorCode >= 6600 && $errorCode <= 6999:
108		case $errorCode >= 12100 && $errorCode <= 12299:
109		case $errorCode >= 12500 && $errorCode <= 12599:
110		return SqlStateCode::SQL_NET_DRIVER_ERROR;
111		case $errorCode >= 430 && $errorCode <= 439:
112		return SqlStateCode::LICENSING_ERROR;
113		case $errorCode >= 570 && $errorCode <= 599:
114		case $errorCode >= 7000 && $errorCode <= 7199:
115		return SqlStateCode::SQL_CONNECT_ERROR;
116		case $errorCode >= 1000 && $errorCode <= 1099:
117		case $errorCode >= 1400 && $errorCode <= 1489:
118		case $errorCode >= 1495 && $errorCode <= 1499:
119		case $errorCode >= 1500 && $errorCode <= 1699:
120		case $errorCode >= 2400 && $errorCode <= 2419:
121		case $errorCode >= 2425 && $errorCode <= 2449:
122		case $errorCode >= 4060 && $errorCode <= 4069:
123		case $errorCode >= 8000 && $errorCode <= 8190:
124		case $errorCode >= 12000 && $errorCode <= 12019:
125		case $errorCode >= 12300 && $errorCode <= 12499:
126		case $errorCode >= 12700 && $errorCode <= 21999:
127		return SqlStateCode::SQL_EXECUTE_PHASE_ERROR;
128		case $errorCode === 2100:
129		return SqlStateCode::OUT_OF_MEMORY;
130		case $errorCode === 2101:
131		return SqlStateCode::INCONSISTENT_CURSOR_CACHE_MISMATCH;
132		case $errorCode === 2102:
133		return SqlStateCode::INCONSISTENT_CURSOR_CACHE_NO_ENTRY;
134		case $errorCode === 2103:
135		return SqlStateCode::INCONSISTENT_CURSOR_CACHE_REF_OUT_OF_RANGE;
136		case $errorCode === 2104:
137		return SqlStateCode::INCONSISTENT_HOST_CACHE_NOT_AVAILABLE;
138		case $errorCode === 2105:
139		return SqlStateCode::INCONSISTENT_CURSOR_CACHE_NOT_FOUND;
140		case $errorCode === 2106:
141		return SqlStateCode::INCONSISTENT_CURSOR_CACHE_INVALID_NUMBER;
142		case $errorCode === 2107:
143		return SqlStateCode::PROGRAM_TOO_OLD;
144		case $errorCode === 2108:
145		return SqlStateCode::INVALID_DESCRIPTOR_PASSED;
146		case $errorCode === 2109:
147		return SqlStateCode::INCONSISTENT_HOST_CACHE_REF_OUT_OF_RANGE;
148		case $errorCode === 2110:
149		return SqlStateCode::INCONSISTENT_HOST_CACHE_INVALID_ENTRY_TYPE;
150		case $errorCode === 2111:
151		return SqlStateCode::HEAP_CONSISTENCY_ERROR;
152		case $errorCode === 2113:
153		return SqlStateCode::UNABLE_TO_OPEN_MESSAGE_FILE;
154		case $errorCode === 2115:
155		return SqlStateCode::CODE_GENERATION_INTERNAL_CONSISTENCY_FAILED;
156		case $errorCode === 2116:
157		return SqlStateCode::REENTRANT_CODE_GENERATOR_GAVE_INVALID_CONTEXT;
158		case $errorCode === 2119:
159		return SqlStateCode::INVALID_HSTDEF_ARGUMENT;
160		case $errorCode === 2120:
161		return SqlStateCode::FIRST_AND_SECOND_ARGS_TO_SQLRCN_BOTH_NULL;
162		case $errorCode === 2122:
163		return SqlStateCode::INVALID_OPEN_OR_PREPARE;
164		case $errorCode === 2123:
165		return SqlStateCode::APPLICATION_CONTEXT_NOT_FOUND;
166		case $errorCode === 2125:
167		return SqlStateCode::CONNECTION_ERROR_NO_ERROR_TEXT;
168		case $errorCode === 2127:
169		return SqlStateCode::PRECOMPILER_VERSION_MISMATCH;
170		case $errorCode === 2129:
171		return SqlStateCode::FETCHED_NUMBER_OF_BYTES_IS_ODD;
172		case $errorCode === 2130:
173		return SqlStateCode::EXEC_TOOLS_INTERFACE_NOT_AVAILABLE;
174		case $errorCode >= 10000 && $errorCode <= 10999:
175		return SqlStateCode::DEBUG_EVENTS;
176		}
177
178		return SqlStateCode::GENERAL_ERROR;
179		}
180		}
181

jpina / pdooci8

Branch — dev-0.1.x (cbb4c7)

OracleSqlStateCode F

Complexity

Size/Duplication

Coupling/Cohesion

Test Coverage

Importance

2 Methods

How to fix Complexity

Complex Class

Duplication Side-by-Side

Filter issues like