File path: /sql12/fw/src/net/sourceforge/squirrel_sql/fw/sql/SQLUtilities.java | File path: /sql12/fw/src/net/sourceforge/squirrel_sql/fw/sql/SQLUtilities.java | |||
Method name: List
|
Method name: List
|
|||
Number of AST nodes: 12 | Number of AST nodes: 12 | |||
1 | List<String> result = new ArrayList<String>();↵ | 1 | List<String> result = new ArrayList<String>();↵ | |
2 | HashSet<String> tableNames = new HashSet<String>();↵ | 2 | HashSet<String> tableNames = new HashSet<String>();↵ | |
3 | for (ITableInfo table : tables)↵ | 3 | for (ITableInfo table : tables)↵ | |
4 | {↵ | 4 | {↵ | |
5 | tableNames.add(table.getSimpleName());↵ | 5 | tableNames.add(table.getSimpleName());↵ | |
6 | }↵ | 6 | }↵ | |
7 | for (ITableInfo table : tables)↵ | 7 | for (ITableInfo table : tables)↵ | |
8 | {↵ | 8 | {↵ | |
9 | ForeignKeyInfo[] exportedKeys = md.getExportedKeysInfo(table);↵ | 9 | ForeignKeyInfo[] importedKeys = md.getImportedKeysInfo(table);↵ | |
10 | for (int i = 0; i < exportedKeys.length; i++)↵ | 10 | for (int i = 0; i < importedKeys.length; i++)↵ | |
11 | {↵ | 11 | {↵ | |
12 | ForeignKeyInfo info = exportedKeys[i];↵ | 12 | ForeignKeyInfo info = importedKeys[i];↵ | |
13 | String fkTable = info.getForeignKeyTableName();↵ | 13 | String pkTable = info.getPrimaryKeyTableName();↵ | |
14 | if (!tableNames.contains(fkTable))↵ | 14 | if (!tableNames.contains(pkTable))↵ | |
15 | {↵ | 15 | {↵ | |
16 | result.add(fkTable);↵ | 16 | result.add(pkTable);↵ | |
17 | }↵ | 17 | }↵ | |
18 | }↵ | 18 | }↵ | |
19 | }↵ | 19 | }↵ | |
20 | return result; | 20 |
| |
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) | 1.0 |
Clones location | Clones are declared in the same class |
Number of node comparisons | 26 |
Number of mapped statements | 12 |
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) | 47.0 |
Clone type | Type 2 |
ID | Statement | ID | Statement | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | List<String> result = new ArrayList<String>(); | 1 | List<String> result = new ArrayList<String>(); | ||||||||||||||||
2 | HashSet<String> tableNames = new HashSet<String>(); | 2 | HashSet<String> tableNames = new HashSet<String>(); | ||||||||||||||||
3 | for (ITableInfo table : tables) | 3 | for (ITableInfo table : tables) | ||||||||||||||||
4 | tableNames.add(table.getSimpleName()); | 4 | tableNames.add(table.getSimpleName()); | ||||||||||||||||
5 | for (ITableInfo table : tables) | 5 | for (ITableInfo table : tables) | ||||||||||||||||
6 | ForeignKeyInfo[] exportedKeys = md.getExportedKeysInfo(table); |
| 6 | ForeignKeyInfo[] importedKeys = md.getImportedKeysInfo(table); | |||||||||||||||
7 | for (int i = 0; i < exportedKeys.length; i++) |
| 7 | for (int i = 0; i < importedKeys.length; i++) | |||||||||||||||
8 | ForeignKeyInfo info = exportedKeys[i]; |
| 8 | ForeignKeyInfo info = importedKeys[i]; | |||||||||||||||
9 | String fkTable = info.getForeignKeyTableName(); |
| 9 | String pkTable = info.getPrimaryKeyTableName(); | |||||||||||||||
10 | if (!tableNames.contains(fkTable)) |
| 10 | if (!tableNames.contains(pkTable)) | |||||||||||||||
11 | result.add(fkTable); |
| 11 | result.add(pkTable); | |||||||||||||||
12 | return result; | 12 | return result; |
Row | Violation |
---|---|
1 | Expression md.getExportedKeysInfo(table) cannot be parameterized, because it has dependencies to/from statements that will be extracted |
2 | Expression md.getImportedKeysInfo(table) cannot be parameterized, because it has dependencies to/from statements that will be extracted |
3 | Expression info.getForeignKeyTableName() cannot be parameterized, because it has dependencies to/from statements that will be extracted |
4 | Expression info.getPrimaryKeyTableName() cannot be parameterized, because it has dependencies to/from statements that will be extracted |