File path: /sql12/plugins/refactoring/src/net/sourceforge/squirrel_sql/plugins/refactoring/commands/AddIndexCommand.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.getCreateIndexSQL(customDialog.getIndexName(),↵ | 4 | _dialect.getCreateViewSQL(customDialog.get↵ | |
5 | _info[0].getSimpleName(),↵ | |||
6 | customDialog.getAccessMethod(),↵ | |||
7 | customDialog.getIndexColumns(),↵ | |||
8 | customDialog.isUniqueSet(),↵ | |||
9 | customDialog.getTablespaceText(),↵ | |||
10 | customDialog.getConstraints↵ | 5 | ViewName(),↵ | |
6 | customDialog.getViewDefinition(),↵ | |||
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.getCreateIndexSQL(customDialog.getIndexName(), _info[0].getSimpleName(), customDialog.getAccessMethod(), customDialog.getIndexColumns(), customDialog.isUniqueSet(), customDialog.getTablespaceText(), customDialog.getConstraints(), 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.getCreateIndexSQL(customDialog.getIndexName(),_info[0].getSimpleName(),customDialog.getAccessMethod(),customDialog.getIndexColumns(),customDialog.isUniqueSet(),customDialog.getTablespaceText(),customDialog.getConstraints(),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.getCreateIndexSQL(customDialog.getIndexName(),_info[0].getSimpleName(),customDialog.getAccessMethod(),customDialog.getIndexColumns(),customDialog.isUniqueSet(),customDialog.getTablespaceText(),customDialog.getConstraints(),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 |