File path: /sql12/plugins/db2/src/net/sourceforge/squirrel_sql/plugins/db2/exp/SequenceParentExpander.java | File path: /sql12/plugins/db2/src/net/sourceforge/squirrel_sql/plugins/db2/exp/UDFParentExpander.java | |||
Method name: List
|
Method name: List
|
|||
Number of AST nodes: 8 | Number of AST nodes: 8 | |||
1 | try↵ | 1 | try↵ | |
2 | {↵ | 2 | {↵ | |
3 | pstmt.setString(1, schemaName);↵ | 3 | pstmt.setString(1, schemaName);↵ | |
4 | pstmt.setString(2, filterMatcher.getSqlLikeMatchString());↵ | 4 | pstmt.setString(2, filterMatcher.getSqlLikeMatchString());↵ | |
5 | rs = pstmt.executeQuery();↵ | 5 | rs = pstmt.executeQuery();↵ | |
6 | while (rs.next())↵ | 6 | while (rs.next())↵ | |
7 | {↵ | |||
8 | ↵ | 7 | {↵ | |
9 | IDatabaseObjectInfo si = new DatabaseObjectInfo(catalogName,↵ | 8 | IDatabaseObjectInfo si = new DatabaseObjectInfo(catalogName,↵ | |
10 | schemaName, rs.getString(1),↵ | |||
11 | ↵ | 9 | schemaName, rs.getString(1),↵ | |
12 | DatabaseObjectType.SEQUENCE, md);↵ | 10 | DatabaseObjectType.UDF, md);↵ | |
13 | if(filterMatcher.matches(si.getSimpleName()))↵ | 11 | if(filterMatcher.matches(si.getSimpleName()))↵ | |
14 | {↵ | 12 | {↵ | |
15 | childNodes.add(new ObjectTreeNode(session, si));↵ | 13 | childNodes.add(new ObjectTreeNode(session, si));↵ | |
16 | }↵ | 14 | }↵ | |
17 | }↵ | 15 | }↵ | |
18 | }↵ | 16 | }↵ | |
19 | finally↵ | 17 | finally↵ | |
20 | {↵ | 18 | {↵ | |
21 | SQLUtilities.closeResultSet(rs);↵ | 19 | SQLUtilities.closeResultSet(rs);↵ | |
22 | SQLUtilities.closeStatement(pstmt);↵ | 20 | SQLUtilities.closeStatement(pstmt);↵ | |
23 | } | 21 |
| |
See real code fragment | See real code fragment |
Number of common nesting structure subtrees | 1 |
Number of refactorable cases | 1 |
Number of non-refactorable cases | 0 |
Time elapsed for finding largest common nesting structure subtrees (ms) | 0.4 |
Clones location | Clones are in different classes |
Number of node comparisons | 24 |
Number of mapped statements | 8 |
Number of unmapped statements in the first code fragment | 0 |
Number of unmapped statements in the second code fragment | 0 |
Time elapsed for statement mapping (ms) | 5.4 |
Clone type | Type 2 |
ID | Statement | ID | Statement | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13 | try | 13 | try | |||||||||||
14 | pstmt.setString(1, schemaName); | 14 | pstmt.setString(1, schemaName); | |||||||||||
15 | pstmt.setString(2, filterMatcher.getSqlLikeMatchString()); | 15 | pstmt.setString(2, filterMatcher.getSqlLikeMatchString()); | |||||||||||
16 | rs = pstmt.executeQuery(); | 16 | rs = pstmt.executeQuery(); | |||||||||||
17 | while (rs.next()) | 17 | while (rs.next()) | |||||||||||
18 | IDatabaseObjectInfo si = new DatabaseObjectInfo(catalogName, schemaName, rs.getString(1), DatabaseObjectType.SEQUENCE, md); |
| 18 | IDatabaseObjectInfo si = new DatabaseObjectInfo(catalogName, schemaName, rs.getString(1), DatabaseObjectType.UDF, md); | ||||||||||
19 | if (filterMatcher.matches(si.getSimpleName())) | 19 | if (filterMatcher.matches(si.getSimpleName())) | |||||||||||
20 | childNodes.add(new ObjectTreeNode(session, si)); | 20 | childNodes.add(new ObjectTreeNode(session, si)); |
Row | Violation |
---|