public class DerbyTableTriggerExtractorImpl implements ITableTriggerExtractor { /** Logger for this class */ private final static ILogger s_log = LoggerController.createLogger(DerbyTableTriggerExtractorImpl.class); /** The query that finds the triggers for a given table */ private static String SQL = "select tr.TRIGGERNAME " + "from SYS.SYSTRIGGERS tr, SYS.SYSTABLES t, SYS.SYSSCHEMAS s " + "where tr.TABLEID = t.TABLEID " + "and s.SCHEMAID = t.SCHEMAID " + "and t.TABLENAME = ? " + "and s.SCHEMANAME = ? "; /** * @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"); s_log.debug("Binding schema name "+dbo.getSchemaName()+ " as second bind value"); } pstmt.setString(1, dbo.getSimpleName()); pstmt.setString(2, dbo.getSchemaName()); } /** * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.ITableTriggerExtractor#getTableTriggerQuery() */ public String getTableTriggerQuery() { return SQL
public class PostgresTableTriggerExtractorImpl implements ITableTriggerExtractor { /** Logger for this class */ private final static ILogger s_log = LoggerController.createLogger(PostgresTableTriggerExtractorImpl.class); /** the query that extracts the trigger names for a given table */ private static final String triggerQuery = "select tr.tgname " + "from pg_catalog.pg_trigger tr, pg_catalog.pg_proc p, " + " pg_class c, pg_namespace n " + "where tr.tgfoid = p.oid " + "and tr.tgrelid = c.oid " + "and c.relnamespace = n.oid " + "and n.nspname = ? " + "and c.relname = ? "; /** * @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 schema name "+dbo.getSchemaName()+ " as first bind value"); s_log.debug("Binding table name "+dbo.getSimpleName()+ " as second bind value"); } pstmt.setString(1, dbo.getSchemaName()); pstmt.setString(2, dbo.getSimpleName()); } /** * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.ITableTriggerExtractor#getTableTriggerQuery() */ public String getTableTriggerQuery() { return triggerQuery
Clone fragments detected by clone detection tool
File path: /sql12/plugins/derby/src/net/sourceforge/squirrel_sql/plugins/derby/exp/DerbyTableTriggerExtractorImpl.java File path: /sql12/plugins/postgres/src/net/sourceforge/squirrel_sql/plugins/postgres/exp/PostgresTableTriggerExtractorImpl.java
Method name: Method name:
Number of AST nodes: 0 Number of AST nodes: 0
1
public class DerbyTableTriggerExtractorImpl implements ITableTriggerExtractor {
1
public class PostgresTableTriggerExtractorImpl 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(DerbyTableTriggerExtractorImpl.class);
4
        LoggerController.createLogger(PostgresTableTriggerExtractorImpl.class);
5
                
5
                
6
    /** The query that finds the triggers for a given table */
6
    /** the query that extracts the trigger names for a given table */
7
    private static String SQL = 
7
    private static final String triggerQuery = 
8
        "select tr.TRIGGERNAME " +
8
        "select tr.tgname " +
9
        "from SYS.SYSTRIGGERS tr, SYS.SYSTABLES t, SYS.SYSSCHEMAS s " +
9
        "from 
10
        "where tr.TABLEID = t.TABLEID
10
pg_catalog.pg_trigger tr, pg_catalog.pg_proc p, " +
11
        "     pg_class c, pg_namespace n " +
12
        "where tr.tgfoid  =  p.oid " +
11
 " +
13
        "and tr.tgrelid = c.oid " +
12
        "and s.SCHEMAID = t.SCHEMAID " +
14
        "and c.relnamespace = n.oid " +
13
        "and t.TABLENAME = ? " +
15
        "and n.nspname = ? " +
14
        "and s.SCHEMANAME = ? ";
16
        "and c.relname = ? ";
15
    
17
    
18
    
16
    /**
19
    /**
17
     * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.ITableTriggerExtractor#bindParamters(java.sql.PreparedStatement, net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo)
20
     * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.ITableTriggerExtractor#bindParamters(java.sql.PreparedStatement, net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo)
18
     */
21
     */
19
    public void bindParamters(PreparedStatement pstmt, IDatabaseObjectInfo dbo) 
22
    public void bindParamters(PreparedStatement pstmt, IDatabaseObjectInfo dbo)
20
        throws SQLException 
23
        throws SQLException 
21
    {
24
    {
22
        if (s_log.isDebugEnabled()) {
25
        if (s_log.isDebugEnabled()) {
23
            s_log.debug("Binding table name "+dbo.getSimpleName()+
26
            s_log.debug("Binding schema name "+dbo.getSchemaName()+
24
                        " as first bind value");            
27
                        " as first bind value");
25
            s_log.debug("Binding schema name "+dbo.getSchemaName()+
28
            s_log.debug("Binding table name "+dbo.getSimpleName()+
26
                        " as second bind value");
29
                        " as second bind value");            
27
        }        
30
        }                
28
        pstmt.setString(1, dbo.getSimpleName());
31
        pstmt.setString(1, dbo.getSchemaName());
29
        pstmt.setString(2, dbo.getSchemaName());        
32
        pstmt.setString(2, dbo.getSimpleName());
30
    }
33
    }
31
    /**
34
    /**
32
     * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.ITableTriggerExtractor#getTableTriggerQuery()
35
     * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.ITableTriggerExtractor#getTableTriggerQuery()
33
     */
36
     */
34
    public String getTableTriggerQuery() {
37
    public String getTableTriggerQuery() {
35
        return SQL
38
        return triggerQuery
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