File path: /sql12/plugins/firebird/src/org/firebirdsql/squirrel/tab/TriggerDetailsTab.java | File path: /sql12/plugins/postgres/src/net/sourceforge/squirrel_sql/plugins/postgres/tab/SequenceDetailsTab.java | |||
Method name: PreparedStatement createStatement()
|
Method name: PreparedStatement createStatement()
|
|||
Number of AST nodes: 9 | Number of AST nodes: 9 | |||
1 | ISession session = getSession();↵ | 1 | ISession session = getSession();↵ | |
2 | IDatabaseObjectInfo doi = getDatabaseObjectInfo();↵ | |||
3 | String sql = getSQL();↵ | |||
2 | if (s_log.isDebugEnabled()) {↵ | 4 | if (s_log.isDebugEnabled()) {↵ | |
3 | s_log.debug("Preparing SQL: "+SQL);↵ | 5 | s_log.debug("Sequence details SQL: "+sql);↵ | |
4 | } ↵ | 6 | ↵ | |
5 | PreparedStatement pstmt = session.getSQLConnection().prepareStatement(SQL);↵ | |||
6 | IDatabaseObjectInfo doi = getDatabaseObjectInfo();↵ | |||
7 | if (s_log.isDebugEnabled()) {↵ | 7 | s_log.debug("Sequence schema: "+doi.getSchemaName());↵ | |
8 | s_log.debug("setString param: "+doi.getSimpleName());↵ | 8 | s_log.debug("Sequence name: "+doi.getSimpleName());↵ | |
9 | } ↵ | 9 | }↵ | |
10 | pstmt.setString(1, doi.getSimpleName()↵ | |||
11 | );↵ | 10 | PreparedStatement pstmt = session.getSQLConnection().prepareStatement(sql);↵ | |
12 | return pstmt; | 11 |
| |
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.1 |
Clones location | Clones are in different classes having the same super class |
Number of node comparisons | 34 |
Number of mapped statements | 6 |
Number of unmapped statements in the first code fragment | 1 |
Number of unmapped statements in the second code fragment | 3 |
Time elapsed for statement mapping (ms) | 3.8 |
Clone type | Type 3 |
ID | Statement | ID | Statement | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ISession session = getSession(); | 1 | ISession session = getSession(); | ||||||||||||||
| 3 | String sql = getSQL(); | |||||||||||||||
2 | if (s_log.isDebugEnabled()) | 4 | if (s_log.isDebugEnabled()) | ||||||||||||||
3 | s_log.debug("Preparing SQL: " + SQL); |
| 5 | s_log.debug("Sequence details SQL: " + sql); | |||||||||||||
|
| 6 | s_log.debug("Sequence schema: " + doi.getSchemaName()); | ||||||||||||||
|
| 7 | s_log.debug("Sequence name: " + doi.getSimpleName()); | ||||||||||||||
4 | PreparedStatement pstmt = session.getSQLConnection().prepareStatement(SQL); |
| 8 | PreparedStatement pstmt = session.getSQLConnection().prepareStatement(sql); | |||||||||||||
5 | IDatabaseObjectInfo doi = getDatabaseObjectInfo(); | 2 | IDatabaseObjectInfo doi = getDatabaseObjectInfo(); | ||||||||||||||
8 | pstmt.setString(1, doi.getSimpleName()); |
| | ||||||||||||||
9 | return pstmt; | 9 | return pstmt; |
Row | Violation |
---|---|
1 | Unmatched statement s_log.debug("Sequence schema: " + doi.getSchemaName()); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted |
2 | Unmatched statement s_log.debug("Sequence name: " + doi.getSimpleName()); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted |
3 | Unmatched statement pstmt.setString(1,doi.getSimpleName()); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted |
4 | Clone fragment #1 returns variables doi , while Clone fragment #2 returns variables |