public class FirebirdTableTriggerExtractorImpl implements ITableTriggerExtractor { /** Logger for this class */ private final static ILogger s_log = LoggerController.createLogger(FirebirdTableTriggerExtractorImpl.class); /** The query that finds the triggers for a given table */ private static String SQL = "select " + "cast(rdb$trigger_name as varchar(31)) as rdb$trigger_name " + "from rdb$triggers " + "where rdb$relation_name = ? "; /** * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.ITableTriggerExtractor#bindParamters(java.sql.PreparedStatement, net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo) */ public void bindParamters(PreparedStatement pstmt, IDatabaseObjectInfo dbo) throws SQLException { if (s_log.isDebugEnabled()) { s_log.debug("Binding table name "+dbo.getSimpleName()+ " as first bind value"); } pstmt.setString(1, dbo.getSimpleName()); } /** * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.ITableTriggerExtractor#getTableTriggerQuery() */ public String getTableTriggerQuery() { return SQL
public class InformixTableTriggerExtractorImpl implements ITableTriggerExtractor { /** Logger for this class */ private final static ILogger s_log = LoggerController.createLogger(InformixTableTriggerExtractorImpl.class); /** The query that finds the triggers for a given table */ private static String query = "select T1.trigname " + "from informix.systriggers AS T1, informix.systables AS T2 " + "where T2.tabid = T1.tabid " + "and T2.tabname = ? "; /** * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.ITableTriggerExtractor#bindParamters(java.sql.PreparedStatement, net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo) */ public void bindParamters(PreparedStatement pstmt, IDatabaseObjectInfo dbo) throws SQLException { if (s_log.isDebugEnabled()) { s_log.debug("Binding table name "+dbo.getSchemaName()+ " as first bind value"); } pstmt.setString(1, dbo.getSimpleName()); } /** * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.ITableTriggerExtractor#getTableTriggerQuery() */ public String getTableTriggerQuery() { return query
Clone fragments detected by clone detection tool
File path: /sql12/plugins/firebird/src/org/firebirdsql/squirrel/exp/FirebirdTableTriggerExtractorImpl.java File path: /sql12/plugins/informix/src/net/sourceforge/squirrel_sql/plugins/informix/exp/InformixTableTriggerExtractorImpl.java
Method name: Method name:
Number of AST nodes: 0 Number of AST nodes: 0
1
public class FirebirdTableTriggerExtractorImpl implements ITableTriggerExtractor {
1
public class InformixTableTriggerExtractorImpl implements ITableTriggerExtractor {
2
    /** Logger for this class */
2
    /** Logger for this class */
3
    private final static ILogger s_log = 
3
    private final static ILogger s_log = 
4
        LoggerController.createLogger(FirebirdTableTriggerExtractorImpl.class);
4
        LoggerController.createLogger(InformixTableTriggerExtractorImpl.class);
5
                
5
                
6
    /** The query that finds the triggers for a given table */
6
    /** The query that finds the triggers for a given table */
7
    private static String SQL = 
7
    private static String query = 
8
        "select " +
8
        "select T1.trigname " +
9
        "cast(rdb$trigger_name as varchar(31)) as rdb$trigger_name " +
9
        "
10
        "from rdb$triggers " +
11
        "where rdb$relation_name = ? ";
10
from informix.systriggers AS T1, informix.systables AS T2 " +
11
        "where T2.tabid = T1.tabid " +
12
        "and T2.tabname = ? ";
13
        
12
    
14
            
13
    /**
15
    /**
14
     * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.ITableTriggerExtractor#bindParamters(java.sql.PreparedStatement, net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo)
16
     * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.ITableTriggerExtractor#bindParamters(java.sql.PreparedStatement, net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo)
15
     */
17
     */
16
    public void bindParamters(PreparedStatement pstmt, IDatabaseObjectInfo dbo) 
18
    public void bindParamters(PreparedStatement pstmt, IDatabaseObjectInfo dbo) 
17
        throws SQLException 
19
        throws SQLException 
18
    {
20
    {
19
        if (s_log.isDebugEnabled()) {
21
        if (s_log.isDebugEnabled()) {
20
            s_log.debug("Binding table name "+dbo.getSimpleName()+
22
            s_log.debug("Binding table name "+dbo.getSchemaName()+
21
                        " as first bind value");            
23
                        " as first bind value");            
22
        }        
24
        }        
23
        pstmt.setString(1, dbo.getSimpleName());        
25
        pstmt.setString(1, dbo.getSimpleName());
24
    }
26
    }
25
    /**
27
    /**
26
     * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.ITableTriggerExtractor#getTableTriggerQuery()
28
     * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.ITableTriggerExtractor#getTableTriggerQuery()
27
     */
29
     */
28
    public String getTableTriggerQuery() {
30
    public String getTableTriggerQuery() {
29
        return SQL
31
        return query
Summary
Number of common nesting structure subtrees0
Number of refactorable cases0
Number of non-refactorable cases0
Time elapsed for finding largest common nesting structure subtrees (ms)0.0
Clones location
Number of node comparisons0