File path: /sql12/plugins/refactoring/src/net/sourceforge/squirrel_sql/plugins/refactoring/gui/MergeTableDialog.java | File path: /sql12/plugins/refactoring/src/net/sourceforge/squirrel_sql/plugins/refactoring/commands/DropViewCommand.java | |||
Method name: void setReferencesTable(String[])
|
Method name: String[] generateSQLStatements()
|
|||
Number of AST nodes: 2 | Number of AST nodes: 2 | |||
1 | for (String table : tableList) {↵ | 1 | for (↵ | |
2 | _referencesField.addItem(table);↵ | |||
3 | ↵ | 2 | IDatabaseObjectInfo dbo : _info)↵ | |
3 | {↵ | |||
4 | result.add(_dialect.getDropViewSQL(dbo.getSimpleName(),↵ | |||
5 | customDialog.isCascadeSelected(),↵ | |||
6 | new DatabaseObjectQualifier(dbo.getCatalogName(), dbo.getSchemaName()),↵ | |||
7 | _sqlPrefs)↵ | |||
8 | + "\n");↵ | |||
4 | } | 9 | } | |
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.1 |
Clones location | Clones are in different classes |
Number of node comparisons | 4 |
Number of mapped statements | 1 |
Number of unmapped statements in the first code fragment | 1 |
Number of unmapped statements in the second code fragment | 1 |
Time elapsed for statement mapping (ms) | 22.4 |
Clone type | Type 2 |
ID | Statement | ID | Statement | |||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | for (String table : tableList) |
| 3 | for (IDatabaseObjectInfo dbo : _info) | ||||||||||||||||||
2 | _referencesField.addItem(table); |
| | |||||||||||||||||||
|
| 4 | result.add(_dialect.getDropViewSQL(dbo.getSimpleName(), customDialog.isCascadeSelected(), new DatabaseObjectQualifier(dbo.getCatalogName(), dbo.getSchemaName()), _sqlPrefs) + "\n"); |
Row | Violation |
---|---|
1 | Type java.lang.String does not match with type net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo |
2 | Type java.lang.String[] of variable tableList does not match with type net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo[] of variable _info |
3 | Unmatched statement _referencesField.addItem(table); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted |
4 | Unmatched statement result.add(_dialect.getDropViewSQL(dbo.getSimpleName(),customDialog.isCascadeSelected(),new DatabaseObjectQualifier(dbo.getCatalogName(),dbo.getSchemaName()),_sqlPrefs) + "\n"); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted |
5 | Unmatched statement result.add(_dialect.getDropViewSQL(dbo.getSimpleName(),customDialog.isCascadeSelected(),new DatabaseObjectQualifier(dbo.getCatalogName(),dbo.getSchemaName()),_sqlPrefs) + "\n"); cannot be moved before or after the extracted code, because it throws exception(s) that should be caught by a try block that will be extracted |
6 | Clone fragment #1 returns variable table with type java.lang.String , while Clone fragment #2 returns variable dbo with type net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo |
7 | The refactoring of the clones is infeasible, because the number of macthed statements is equal to zero |