File path: /sql12/plugins/refactoring/src/net/sourceforge/squirrel_sql/plugins/refactoring/commands/AddSequenceCommand.java | File path: /sql12/plugins/refactoring/src/net/sourceforge/squirrel_sql/plugins/refactoring/commands/AddViewCommand.java | |||
Method name: String[] generateSQLStatements()
|
Method name: String[] generateSQLStatements()
|
|||
Number of AST nodes: 3 | Number of AST nodes: 3 | |||
1 | DatabaseObjectQualifier qualifier =↵ | 1 | DatabaseObjectQualifier qualifier =↵ | |
2 | new DatabaseObjectQualifier(_info[0].getCatalogName(), _info[0].getSchemaName());↵ | 2 | new DatabaseObjectQualifier(_info[0].getCatalogName(), _info[0].getSchemaName());↵ | |
3 | String result =↵ | 3 | String result =↵ | |
4 | _dialect.getCreateSequenceSQL(customDialog.getSequenceName(),↵ | 4 | _dialect.getCreateViewSQL(customDialog.getViewName(),↵ | |
5 | customDialog.getIncrement(),↵ | 5 | customDialog.get↵ | |
6 | customDialog.getMinimum(),↵ | |||
7 | customDialog.getMaximum(),↵ | |||
8 | customDialog.getStart(),↵ | |||
9 | customDialog.getCache(),↵ | |||
10 | customDialog.isCycled↵ | 6 | ViewDefinition(),↵ | |
11 | (),↵ | 7 | customDialog.getCheckOption(),↵ | |
12 | qualifier,↵ | 8 | qualifier,↵ | |
13 | _sqlPrefs);↵ | 9 | _sqlPrefs);↵ | |
14 | return new String[] { result }; | 10 |
| |
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) | 0.0 |
Clones location | Clones are in different classes having the same super class |
Number of node comparisons | 5 |
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) | 0.0 |
Clone type | Type 2 |
ID | Statement | ID | Statement | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | DatabaseObjectQualifier qualifier = new DatabaseObjectQualifier(_info[0].getCatalogName(), _info[0].getSchemaName()); | 1 | DatabaseObjectQualifier qualifier = new DatabaseObjectQualifier(_info[0].getCatalogName(), _info[0].getSchemaName()); | ||||||||||||||||||
2 | String result = _dialect.getCreateSequenceSQL(customDialog.getSequenceName(), customDialog.getIncrement(), customDialog.getMinimum(), customDialog.getMaximum(), customDialog.getStart(), customDialog.getCache(), customDialog.isCycled(), qualifier, _sqlPrefs); |
| 2 | String result = _dialect.getCreateViewSQL(customDialog.getViewName(), customDialog.getViewDefinition(), customDialog.getCheckOption(), qualifier, _sqlPrefs); | |||||||||||||||||
3 | return new String[] {result}; | 3 | return new String[] {result}; |
Row | Violation |
---|---|
1 | Expression _dialect.getCreateSequenceSQL(customDialog.getSequenceName(),customDialog.getIncrement(),customDialog.getMinimum(),customDialog.getMaximum(),customDialog.getStart(),customDialog.getCache(),customDialog.isCycled(),qualifier,_sqlPrefs) cannot be parameterized, because it has dependencies to/from statements that will be extracted |
2 | Expression _dialect.getCreateViewSQL(customDialog.getViewName(),customDialog.getViewDefinition(),customDialog.getCheckOption(),qualifier,_sqlPrefs) cannot be parameterized, because it has dependencies to/from statements that will be extracted |
3 | Expression _dialect.getCreateSequenceSQL(customDialog.getSequenceName(),customDialog.getIncrement(),customDialog.getMinimum(),customDialog.getMaximum(),customDialog.getStart(),customDialog.getCache(),customDialog.isCycled(),qualifier,_sqlPrefs) cannot be parameterized, because it has dependencies to/from statements that will be extracted |
4 | Expression _dialect.getCreateViewSQL(customDialog.getViewName(),customDialog.getViewDefinition(),customDialog.getCheckOption(),qualifier,_sqlPrefs) cannot be parameterized, because it has dependencies to/from statements that will be extracted |