File path: /sql12/plugins/db2/src/net/sourceforge/squirrel_sql/plugins/db2/exp/UDFParentExpander.java | File path: /sql12/plugins/db2/src/net/sourceforge/squirrel_sql/plugins/db2/exp/SequenceParentExpander.java | |||
Method name: List
|
Method name: List
|
|||
Number of AST nodes: 21 | Number of AST nodes: 21 | |||
1 | final List<ObjectTreeNode> childNodes = new ArrayList<ObjectTreeNode>();↵ | 1 | final List<ObjectTreeNode> childNodes = new ArrayList<ObjectTreeNode>();↵ | |
2 | final IDatabaseObjectInfo parentDbinfo = parentNode.getDatabaseObjectInfo();↵ | 2 | final IDatabaseObjectInfo parentDbinfo = parentNode.getDatabaseObjectInfo();↵ | |
3 | final ISQLConnection conn = session.getSQLConnection();↵ | 3 | final ISQLConnection conn = session.getSQLConnection();↵ | |
4 | final SQLDatabaseMetaData md = session.getSQLConnection().getSQLMetaData();↵ | 4 | final SQLDatabaseMetaData md = session.getSQLConnection().getSQLMetaData();↵ | |
5 | final String catalogName = parentDbinfo.getCatalogName();↵ | 5 | final String catalogName = parentDbinfo.getCatalogName();↵ | |
6 | final String schemaName = parentDbinfo.getSchemaName();↵ | 6 | final String schemaName = parentDbinfo.getSchemaName();↵ | |
7 | final ObjFilterMatcher filterMatcher = new ObjFilterMatcher(session.getProperties());↵ | 7 | final ObjFilterMatcher filterMatcher = new ObjFilterMatcher(session.getProperties());↵ | |
8 | String sql = SQL;↵ | 8 | String sql = SQL;↵ | |
9 | if (isOS400) {↵ | 9 | if (isOS400) {↵ | |
10 | sql = OS_400_SQL;↵ | 10 | sql = OS_400_SQL;↵ | |
11 | }↵ | 11 | }↵ | |
12 | final PreparedStatement pstmt = conn.prepareStatement(sql);↵ | 12 | final PreparedStatement pstmt = conn.prepareStatement(sql);↵ | |
13 | ResultSet rs = null;↵ | 13 | ResultSet rs = null;↵ | |
14 | try↵ | 14 | try↵ | |
15 | {↵ | 15 | {↵ | |
16 | pstmt.setString(1, schemaName);↵ | 16 | pstmt.setString(1, schemaName);↵ | |
17 | pstmt.setString(2, filterMatcher.getSqlLikeMatchString());↵ | 17 | pstmt.setString(2, filterMatcher.getSqlLikeMatchString());↵ | |
18 | rs = pstmt.executeQuery();↵ | 18 | rs = pstmt.executeQuery();↵ | |
19 | while (rs.next())↵ | 19 | while (rs.next())↵ | |
20 | {↵ | |||
21 | ↵ | 20 | {↵ | |
22 | IDatabaseObjectInfo si = new DatabaseObjectInfo(catalogName,↵ | 21 | IDatabaseObjectInfo si = new DatabaseObjectInfo(catalogName,↵ | |
23 | schemaName, rs.getString(1),↵ | |||
24 | ↵ | 22 | schemaName, rs.getString(1),↵ | |
25 | DatabaseObjectType.UDF, md);↵ | 23 | DatabaseObjectType.SEQUENCE, md);↵ | |
26 | if(filterMatcher.matches(si.getSimpleName()))↵ | 24 | if(filterMatcher.matches(si.getSimpleName()))↵ | |
27 | {↵ | 25 | {↵ | |
28 | childNodes.add(new ObjectTreeNode(session, si));↵ | 26 | childNodes.add(new ObjectTreeNode(session, si));↵ | |
29 | }↵ | 27 | }↵ | |
30 | }↵ | 28 | }↵ | |
31 | }↵ | 29 | }↵ | |
32 | finally↵ | 30 | finally↵ | |
33 | {↵ | 31 | {↵ | |
34 | SQLUtilities.closeResultSet(rs);↵ | 32 | SQLUtilities.closeResultSet(rs);↵ | |
35 | SQLUtilities.closeStatement(pstmt);↵ | 33 | SQLUtilities.closeStatement(pstmt);↵ | |
36 | }↵ | 34 | }↵ | |
37 | return childNodes; | 35 |
| |
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.6 |
Clones location | Clones are in different classes |
Number of node comparisons | 112 |
Number of mapped statements | 21 |
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) | 15.2 |
Clone type | Type 2 |
ID | Statement | ID | Statement | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | final List<ObjectTreeNode> childNodes = new ArrayList<ObjectTreeNode>(); | 1 | final List<ObjectTreeNode> childNodes = new ArrayList<ObjectTreeNode>(); | |||||||||||
2 | final IDatabaseObjectInfo parentDbinfo = parentNode.getDatabaseObjectInfo(); | 2 | final IDatabaseObjectInfo parentDbinfo = parentNode.getDatabaseObjectInfo(); | |||||||||||
3 | final ISQLConnection conn = session.getSQLConnection(); | 3 | final ISQLConnection conn = session.getSQLConnection(); | |||||||||||
4 | final SQLDatabaseMetaData md = session.getSQLConnection().getSQLMetaData(); | 4 | final SQLDatabaseMetaData md = session.getSQLConnection().getSQLMetaData(); | |||||||||||
5 | final String catalogName = parentDbinfo.getCatalogName(); | 5 | final String catalogName = parentDbinfo.getCatalogName(); | |||||||||||
6 | final String schemaName = parentDbinfo.getSchemaName(); | 6 | final String schemaName = parentDbinfo.getSchemaName(); | |||||||||||
7 | final ObjFilterMatcher filterMatcher = new ObjFilterMatcher(session.getProperties()); | 7 | final ObjFilterMatcher filterMatcher = new ObjFilterMatcher(session.getProperties()); | |||||||||||
8 | String sql = SQL; | 8 | String sql = SQL; | |||||||||||
9 | if (isOS400) | 9 | if (isOS400) | |||||||||||
10 | sql = OS_400_SQL; | 10 | sql = OS_400_SQL; | |||||||||||
11 | final PreparedStatement pstmt = conn.prepareStatement(sql); | 11 | final PreparedStatement pstmt = conn.prepareStatement(sql); | |||||||||||
12 | ResultSet rs = null; | 12 | ResultSet rs = null; | |||||||||||
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.UDF, md); |
| 18 | IDatabaseObjectInfo si = new DatabaseObjectInfo(catalogName, schemaName, rs.getString(1), DatabaseObjectType.SEQUENCE, 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)); | |||||||||||
21 | return childNodes; | 21 | return childNodes; |
Row | Violation |
---|