File path: /sql12/plugins/graph/src/net/sourceforge/squirrel_sql/plugins/graph/GraphController.java | File path: /sql12/plugins/refactoring/src/net/sourceforge/squirrel_sql/plugins/refactoring/commands/DropViewCommand.java | |||
Method name: void allTablesPkConstOrder()
|
Method name: String[] generateSQLStatements()
|
|||
Number of AST nodes: 2 | Number of AST nodes: 2 | |||
1 | for (TableFrameController openTableFrameCtrl : _openTableFrameCtrls)↵ | 1 | for (↵ | |
2 | {↵ | |||
3 | openTableFrameCtrl.pkConstraintOrder();↵ | |||
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 | 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.0 |
Clone type | Type 2 |
ID | Statement | ID | Statement | |||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | for (TableFrameController openTableFrameCtrl : _openTableFrameCtrls) |
| 3 | for (IDatabaseObjectInfo dbo : _info) | ||||||||||||||||||
2 | openTableFrameCtrl.pkConstraintOrder(); |
| | |||||||||||||||||||
|
| 4 | result.add(_dialect.getDropViewSQL(dbo.getSimpleName(), customDialog.isCascadeSelected(), new DatabaseObjectQualifier(dbo.getCatalogName(), dbo.getSchemaName()), _sqlPrefs) + "\n"); |
Row | Violation |
---|---|
1 | Type net.sourceforge.squirrel_sql.plugins.graph.TableFrameController does not match with type net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo |
2 | Type java.util.Vector<net.sourceforge.squirrel_sql.plugins.graph.TableFrameController> of variable _openTableFrameCtrls does not match with type net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo[] of variable _info |
3 | Unmatched statement openTableFrameCtrl.pkConstraintOrder(); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted |
4 | Unmatched statement openTableFrameCtrl.pkConstraintOrder(); 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 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 |
6 | 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 |
7 | Clone fragment #1 returns variable openTableFrameCtrl with type net.sourceforge.squirrel_sql.plugins.graph.TableFrameController , while Clone fragment #2 returns variable dbo with type net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo |
8 | The refactoring of the clones is infeasible, because the number of macthed statements is equal to zero |