File path: /sql12/plugins/refactoring/src/net/sourceforge/squirrel_sql/plugins/refactoring/commands/DropSequenceCommand.java | File path: /sql12/plugins/refactoring/src/net/sourceforge/squirrel_sql/plugins/refactoring/commands/DropIndexTableCommand.java | |||
Method name: String[] generateSQLStatements()
|
Method name: String[] generateSQLStatements()
|
|||
Number of AST nodes: 3 | Number of AST nodes: 3 | |||
1 | for (IDatabaseObjectInfo dbo : _info)↵ | 1 | for (IndexInfo iInfo : _↵ | |
2 | {↵ | |||
3 | ↵ | 2 | dropIndexInfo) {↵ | |
4 | DatabaseObjectQualifier qualifier =↵ | 3 | DatabaseObjectQualifier qualifier =↵ | |
5 | new DatabaseObjectQualifier(dbo.getCatalogName(), dbo.getSchemaName());↵ | 4 | new DatabaseObjectQualifier(iInfo.getCatalogName(), iInfo.getSchemaName());↵ | |
6 | result.add(_dialect.getDropSequenceSQL(dbo.getSimpleName(),↵ | 5 | result.add(_dialect.getDrop↵ | |
7 | ↵ | 6 | IndexSQL(_tableName, iInfo.getSimpleName(),↵ | |
8 | customDialog.isCascadeSelected(),↵ | 7 | customDialog.isCascadeSelected(),↵ | |
9 | qualifier,↵ | 8 | qualifier,↵ | |
10 | _sqlPrefs));↵ | 9 | _sqlPrefs));↵ | |
11 | } | 10 | } | |
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 having the same super class |
Number of node comparisons | 10 |
Number of mapped statements | 3 |
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) | 48.4 |
Clone type | Type 2 |
ID | Statement | ID | Statement | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3 | for (IDatabaseObjectInfo dbo : _info) |
| 3 | for (IndexInfo iInfo : _dropIndexInfo) | |||||||||||||||||||||||
4 | DatabaseObjectQualifier qualifier = new DatabaseObjectQualifier(dbo.getCatalogName(), dbo.getSchemaName()); |
| 4 | DatabaseObjectQualifier qualifier = new DatabaseObjectQualifier(iInfo.getCatalogName(), iInfo.getSchemaName()); | |||||||||||||||||||||||
5 | result.add(_dialect.getDropSequenceSQL(dbo.getSimpleName(), customDialog.isCascadeSelected(), qualifier, _sqlPrefs)); |
| 5 | result.add(_dialect.getDropIndexSQL(_tableName, iInfo.getSimpleName(), customDialog.isCascadeSelected(), qualifier, _sqlPrefs)); |
Row | Violation |
---|---|
1 | Type net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo[] of variable _info does not match with type net.sourceforge.squirrel_sql.fw.sql.IndexInfo[] of variable _dropIndexInfo |
2 | Expression _dialect.getDropSequenceSQL(dbo.getSimpleName(),customDialog.isCascadeSelected(),qualifier,_sqlPrefs) cannot be parameterized, because it has dependencies to/from statements that will be extracted |
3 | Expression _dialect.getDropIndexSQL(_tableName,iInfo.getSimpleName(),customDialog.isCascadeSelected(),qualifier,_sqlPrefs) cannot be parameterized, because it has dependencies to/from statements that will be extracted |
4 | Expression _dialect.getDropSequenceSQL(dbo.getSimpleName(),customDialog.isCascadeSelected(),qualifier,_sqlPrefs) cannot be parameterized, because it has dependencies to/from statements that will be extracted |
5 | Expression _dialect.getDropIndexSQL(_tableName,iInfo.getSimpleName(),customDialog.isCascadeSelected(),qualifier,_sqlPrefs) cannot be parameterized, because it has dependencies to/from statements that will be extracted |