File path: /sql12/plugins/syntax/src/net/sourceforge/squirrel_sql/plugins/syntax/netbeans/SyntaxFactory.java | File path: /sql12/plugins/refactoring/src/net/sourceforge/squirrel_sql/plugins/refactoring/commands/DropViewCommand.java | |||
Method name: void sessionEnding(ISession)
|
Method name: String[] generateSQLStatements()
|
|||
Number of AST nodes: 2 | Number of AST nodes: 2 | |||
1 | for (Document doc : docs)↵ | 1 | for (↵ | |
2 | {↵ | |||
3 | _documentAssignedObjectsByDocument.remove(doc);↵ | |||
4 | ↵ | 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");↵ | |||
5 | } | 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.2 |
Clones location | Clones are in different classes |
Number of node comparisons | 5 |
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.7 |
Clone type | Type 2 |
ID | Statement | ID | Statement | |||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3 | for (Document doc : docs) |
| 3 | for (IDatabaseObjectInfo dbo : _info) | ||||||||||||||||||
|
| 4 | result.add(_dialect.getDropViewSQL(dbo.getSimpleName(), customDialog.isCascadeSelected(), new DatabaseObjectQualifier(dbo.getCatalogName(), dbo.getSchemaName()), _sqlPrefs) + "\n"); | |||||||||||||||||||
4 | _documentAssignedObjectsByDocument.remove(doc); |
| |
Row | Violation |
---|---|
1 | Type javax.swing.text.Document does not match with type net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo |
2 | Type java.util.ArrayList<javax.swing.text.Document> of variable docs does not match with type net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo[] of variable _info |
3 | 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 |
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 throws exception(s) that should be caught by a try block that will be extracted |
5 | Unmatched statement _documentAssignedObjectsByDocument.remove(doc); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted |
6 | Clone fragment #1 returns variable doc with type javax.swing.text.Document , 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 |