File path: /sql12/app/src/net/sourceforge/squirrel_sql/client/session/schemainfo/SchemaInfoUpdateCheck.java | File path: /sql12/app/src/net/sourceforge/squirrel_sql/client/session/schemainfo/SchemaInfoUpdateCheck.java | |||
Method name: ProcedureInfo[] createProcdureInfos(Matcher, String, boolean)
|
Method name: TableInfo[] createTableInfos(Matcher, String, String, boolean)
|
|||
Number of AST nodes: 12 | Number of AST nodes: 12 | |||
1 | int endIx = matcher.end(1);↵ | 1 | int endIx = matcher.end(1);↵ | |
2 | int len = matcher.group(1).length();↵ | 2 | int len = matcher.group(1).length();↵ | |
3 | String proc = sql.substring(endIx - len, endIx);↵ | 3 | String table = sql.substring(endIx - len, endIx);↵ | |
4 | String[] splits = proc.split("\\.");↵ | 4 | String[] splits = table.split("\\.");↵ | |
5 | String simpleName = splits[splits.length - 1];↵ | 5 | String simpleName = splits[splits.length - 1];↵ | |
6 | simpleName = removeQuotes(simpleName);↵ | 6 | simpleName = removeQuotes(simpleName);↵ | |
7 | if(isAlterOrDrop)↵ | 7 | if(isAlterOrDrop)↵ | |
8 | {↵ | 8 | {↵ | |
9 | String buf = _session.getSchemaInfo().getCaseSensitiveProcedureName(simpleName);↵ | 9 | String buf = _session.getSchemaInfo().getCaseSensitiveTableName(simpleName);↵ | |
10 | if(null != buf)↵ | 10 | if(null != buf)↵ | |
11 | {↵ | 11 | {↵ | |
12 | simpleName = buf;↵ | 12 | simpleName = buf;↵ | |
13 | }↵ | 13 | }↵ | |
14 | return new ProcedureInfo[]{new ProcedureInfo(null, null, simpleName, null, DatabaseMetaData.procedureResultUnknown, _dmd)};↵ | 14 | return new TableInfo[]{new TableInfo(null, null, simpleName, type, null, _dmd)};↵ | |
15 | }↵ | 15 | }↵ | |
16 | else↵ | 16 | else↵ | |
17 | {↵ | 17 | {↵ | |
18 | // DB2 stores all names in upper case.↵ | 18 | // DB2 stores all names in upper case.↵ | |
19 | // PostgreSQL stores all names in lower case.↵ | 19 | // PostgreSQL stores table names in lower case.↵ | |
20 | // That's why we may not find proc as it was written in the create statement.↵ | 20 | // That's why we may not find table as it was written in the create statement.↵ | |
21 | // So we try out the upper and lower case names too.↵ | 21 | // So we try out the upper and lower case names too.↵ | |
22 | return new ProcedureInfo[]↵ | 22 | return new TableInfo[]↵ | |
23 | {↵ | 23 | {↵ | |
24 | new ProcedureInfo(null, null, simpleName, null, DatabaseMetaData.procedureResultUnknown, _dmd),↵ | 24 | new TableInfo(null, null, simpleName, type, null, _dmd),↵ | |
25 | new ProcedureInfo(null, null, simpleName.toUpperCase(), null, DatabaseMetaData.procedureResultUnknown, _dmd),↵ | 25 | new TableInfo(null, null, simpleName.toUpperCase(), type, null, _dmd),↵ | |
26 | new ProcedureInfo(null, null, simpleName.toLowerCase(), null, DatabaseMetaData.procedureResultUnknown, _dmd)↵ | 26 | new TableInfo(null, null, simpleName.toLowerCase(), type, null, _dmd)↵ | |
27 | };↵ | 27 | };↵ | |
28 | } | 28 |
| |
See real code fragment | See real code fragment |
Number of common nesting structure subtrees | 1 |
Number of refactorable cases | 0 |
Number of non-refactorable cases | 1 |
Time elapsed for finding largest common nesting structure subtrees (ms) | 0.2 |
Clones location | Clones are declared in the same class |
Number of node comparisons | 56 |
Number of mapped statements | 10 |
Number of unmapped statements in the first code fragment | 2 |
Number of unmapped statements in the second code fragment | 2 |
Time elapsed for statement mapping (ms) | 21.1 |
Clone type | Type 2 |
ID | Statement | ID | Statement | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | int endIx = matcher.end(1); | 1 | int endIx = matcher.end(1); | |||||||||||||
2 | int len = matcher.group(1).length(); | 2 | int len = matcher.group(1).length(); | |||||||||||||
3 | String proc = sql.substring(endIx - len, endIx); |
| 3 | String table = sql.substring(endIx - len, endIx); | ||||||||||||
4 | String[] splits = proc.split("\\."); |
| 4 | String[] splits = table.split("\\."); | ||||||||||||
5 | String simpleName = splits[splits.length - 1]; | 5 | String simpleName = splits[splits.length - 1]; | |||||||||||||
6 | simpleName = removeQuotes(simpleName); | 6 | simpleName = removeQuotes(simpleName); | |||||||||||||
7 | if (isAlterOrDrop) | 7 | if (isAlterOrDrop) | |||||||||||||
8 | String buf = _session.getSchemaInfo().getCaseSensitiveProcedureName(simpleName); |
| 8 | String buf = _session.getSchemaInfo().getCaseSensitiveTableName(simpleName); | ||||||||||||
9 | if (null != buf) | 9 | if (null != buf) | |||||||||||||
10 | simpleName = buf; | 10 | simpleName = buf; | |||||||||||||
|
| 11 | return new TableInfo[] {new TableInfo(null, null, simpleName, type, null, _dmd)}; | |||||||||||||
11 | return new ProcedureInfo[] {new ProcedureInfo(null, null, simpleName, null, DatabaseMetaData.procedureResultUnknown, _dmd)}; |
| | |||||||||||||
else | | |||||||||||||||
|
| 12 | return new TableInfo[] {new TableInfo(null, null, simpleName, type, null, _dmd), new TableInfo(null, null, simpleName.toUpperCase(), type, null, _dmd), new TableInfo(null, null, simpleName.toLowerCase(), type, null, _dmd)}; | |||||||||||||
12 | return new ProcedureInfo[] {new ProcedureInfo(null, null, simpleName, null, DatabaseMetaData.procedureResultUnknown, _dmd), new ProcedureInfo(null, null, simpleName.toUpperCase(), null, DatabaseMetaData.procedureResultUnknown, _dmd), new ProcedureInfo(null, null, simpleName.toLowerCase(), null, DatabaseMetaData.procedureResultUnknown, _dmd)}; |
| |
Row | Violation |
---|---|
1 | Expression _session.getSchemaInfo().getCaseSensitiveProcedureName(simpleName) cannot be parameterized, because it has dependencies to/from statements that will be extracted |
2 | Expression _session.getSchemaInfo().getCaseSensitiveTableName(simpleName) cannot be parameterized, because it has dependencies to/from statements that will be extracted |
3 | Unmatched statement return new TableInfo[]{new TableInfo(null,null,simpleName,type,null,_dmd)}; cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted |
4 | Unmatched return new TableInfo[]{new TableInfo(null,null,simpleName,type,null,_dmd)}; |
5 | Unmatched statement return new ProcedureInfo[]{new ProcedureInfo(null,null,simpleName,null,DatabaseMetaData.procedureResultUnknown,_dmd)}; cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted |
6 | Unmatched return new ProcedureInfo[]{new ProcedureInfo(null,null,simpleName,null,DatabaseMetaData.procedureResultUnknown,_dmd)}; |
7 | Unmatched statement return new TableInfo[]{new TableInfo(null,null,simpleName,type,null,_dmd),new TableInfo(null,null,simpleName.toUpperCase(),type,null,_dmd),new TableInfo(null,null,simpleName.toLowerCase(),type,null,_dmd)}; cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted |
8 | Unmatched return new TableInfo[]{new TableInfo(null,null,simpleName,type,null,_dmd),new TableInfo(null,null,simpleName.toUpperCase(),type,null,_dmd),new TableInfo(null,null,simpleName.toLowerCase(),type,null,_dmd)}; |
9 | Unmatched statement return new ProcedureInfo[]{new ProcedureInfo(null,null,simpleName,null,DatabaseMetaData.procedureResultUnknown,_dmd),new ProcedureInfo(null,null,simpleName.toUpperCase(),null,DatabaseMetaData.procedureResultUnknown,_dmd),new ProcedureInfo(null,null,simpleName.toLowerCase(),null,DatabaseMetaData.procedureResultUnknown,_dmd)}; cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted |
10 | Unmatched return new ProcedureInfo[]{new ProcedureInfo(null,null,simpleName,null,DatabaseMetaData.procedureResultUnknown,_dmd),new ProcedureInfo(null,null,simpleName.toUpperCase(),null,DatabaseMetaData.procedureResultUnknown,_dmd),new ProcedureInfo(null,null,simpleName.toLowerCase(),null,DatabaseMetaData.procedureResultUnknown,_dmd)}; |