File path: /sql12/plugins/refactoring/src/net/sourceforge/squirrel_sql/plugins/refactoring/commands/ModifySequenceCommand.java | File path: /sql12/plugins/refactoring/src/net/sourceforge/squirrel_sql/plugins/refactoring/commands/AddForeignKeyCommand.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.getAlterSequenceSQL(↵ | 4 | _dialect.getAddForeignKeyConstraintSQL(_info[0].getSimpleName(),↵ | |
5 | customDialog.getSequenceName(),↵ | 5 | customDialog.getReferencedTable(),↵ | |
6 | customDialog.getIncrement(),↵ | 6 | customDialog.getConstraintName(),↵ | |
7 | customDialog.getMinimum↵ | 7 | customDialog.isDeferrable(),↵ | |
8 | customDialog.isDeferred(),↵ | |||
9 | customDialog.isMatchFull(),↵ | |||
8 | (),↵ | 10 | customDialog.isAutoFKIndex(),↵ | |
9 | customDialog.getMaximum(),↵ | 11 | customDialog.getFKIndexName(),↵ | |
10 | customDialog.getStart(),↵ | 12 | customDialog.getReferencedColumns(),↵ | |
11 | customDialog.getCache(),↵ | 13 | customDialog.getOnUpdateAction(),↵ | |
12 | customDialog.isCycled(),↵ | 14 | customDialog.getOnDeleteAction(),↵ | |
13 | qualifier,↵ | 15 | qualifier,↵ | |
14 | _sqlPrefs);↵ | 16 | _sqlPrefs);↵ | |
15 | return result; | 17 |
| |
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.getAlterSequenceSQL(customDialog.getSequenceName(), customDialog.getIncrement(), customDialog.getMinimum(), customDialog.getMaximum(), customDialog.getStart(), customDialog.getCache(), customDialog.isCycled(), qualifier, _sqlPrefs); |
| 2 | String[] result = _dialect.getAddForeignKeyConstraintSQL(_info[0].getSimpleName(), customDialog.getReferencedTable(), customDialog.getConstraintName(), customDialog.isDeferrable(), customDialog.isDeferred(), customDialog.isMatchFull(), customDialog.isAutoFKIndex(), customDialog.getFKIndexName(), customDialog.getReferencedColumns(), customDialog.getOnUpdateAction(), customDialog.getOnDeleteAction(), qualifier, _sqlPrefs); | |||||||||||||||||
3 | return result; | 3 | return result; |
Row | Violation |
---|---|
1 | Expression _dialect.getAlterSequenceSQL(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.getAddForeignKeyConstraintSQL(_info[0].getSimpleName(),customDialog.getReferencedTable(),customDialog.getConstraintName(),customDialog.isDeferrable(),customDialog.isDeferred(),customDialog.isMatchFull(),customDialog.isAutoFKIndex(),customDialog.getFKIndexName(),customDialog.getReferencedColumns(),customDialog.getOnUpdateAction(),customDialog.getOnDeleteAction(),qualifier,_sqlPrefs) cannot be parameterized, because it has dependencies to/from statements that will be extracted |
3 | Expression _dialect.getAlterSequenceSQL(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.getAddForeignKeyConstraintSQL(_info[0].getSimpleName(),customDialog.getReferencedTable(),customDialog.getConstraintName(),customDialog.isDeferrable(),customDialog.isDeferred(),customDialog.isMatchFull(),customDialog.isAutoFKIndex(),customDialog.getFKIndexName(),customDialog.getReferencedColumns(),customDialog.getOnUpdateAction(),customDialog.getOnDeleteAction(),qualifier,_sqlPrefs) cannot be parameterized, because it has dependencies to/from statements that will be extracted |