public class InformixTableIndexExtractorImpl implements ITableIndexExtractor { /** Logger for this class */ private final static ILogger s_log = LoggerController.createLogger(InformixTableIndexExtractorImpl.class); /** The query that finds the indexes for a given table */ private static final String query = "SELECT T1.idxname " + "FROM informix.sysindices AS T1, informix.systables AS T2 " + "WHERE T1.tabid = T2.tabid " + "and t1.owner = ? "+ "and T2.tabname = ? "; /** * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.ITableIndexExtractor#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.ITableIndexExtractor#getTableIndexQuery() */ public String getTableIndexQuery() { return query
public class PostgresTableIndexExtractorImpl implements ITableIndexExtractor { /** Logger for this class */ private final static ILogger s_log = LoggerController.createLogger(PostgresTableIndexExtractorImpl.class); /** The query that finds the indexes for a given table */ private static final String query = "select indexname " + "from pg_catalog.pg_indexes " + "where schemaname = ? " + "and tablename = ? "; /** * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.ITableIndexExtractor#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.ITableIndexExtractor#getTableIndexQuery() */ public String getTableIndexQuery() { return query
Clone fragments detected by clone detection tool
File path: /sql12/plugins/informix/src/net/sourceforge/squirrel_sql/plugins/informix/exp/InformixTableIndexExtractorImpl.java File path: /sql12/plugins/postgres/src/net/sourceforge/squirrel_sql/plugins/postgres/exp/PostgresTableIndexExtractorImpl.java
Method name: Method name:
Number of AST nodes: 0 Number of AST nodes: 0
1
public class InformixTableIndexExtractorImpl implements ITableIndexExtractor {
1
public class PostgresTableIndexExtractorImpl implements ITableIndexExtractor {
2
    
2
    
3
    /** Logger for this class */
3
    /** Logger for this class */
4
    private final static ILogger s_log = 
4
    private final static ILogger s_log = 
5
        LoggerController.createLogger(InformixTableIndexExtractorImpl.class);
5
        LoggerController.createLogger(PostgresTableIndexExtractorImpl.class);
6
                
6
                
7
    /** The query that finds the indexes for a given table */
7
    /** The query that finds the indexes for a given table */
8
    private static final String query = 
8
    private static final String query = 
9
        "SELECT  T1.idxname " +
9
        "select indexname " +
10
        "FROM informix.sysindices AS T1, informix.systables AS T2 " +
10
        "
11
        "WHERE T1.tabid = T2.tabid " +
12
        "and t1.owner
11
from pg_catalog.pg_indexes " +
13
 = ? "+
12
        "where schemaname = ? " +
14
        "and T2.tabname = ? ";
13
        "and tablename = ? ";
15
    
14
    
16
    /**
15
    /**
17
     * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.ITableIndexExtractor#bindParamters(java.sql.PreparedStatement, net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo)
16
     * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.ITableIndexExtractor#bindParamters(java.sql.PreparedStatement, net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo)
18
     */
17
     */
19
    public void bindParamters(PreparedStatement pstmt, IDatabaseObjectInfo dbo)
18
    public void bindParamters(PreparedStatement pstmt, IDatabaseObjectInfo dbo)
20
        throws SQLException 
19
        throws SQLException 
21
    {
20
    {
22
        if (s_log.isDebugEnabled()) {
21
        if (s_log.isDebugEnabled()) {
23
            s_log.debug("Binding schema name "+dbo.getSchemaName()+
22
            s_log.debug("Binding schema name "+dbo.getSchemaName()+
24
                        " as first bind value");
23
                        " as first bind value");
25
            s_log.debug("Binding table name "+dbo.getSimpleName()+
24
            s_log.debug("Binding table name "+dbo.getSimpleName()+
26
                        " as second bind value");            
25
                        " as second bind value");            
27
        }                        
26
        }                        
28
        pstmt.setString(1, dbo.getSchemaName());
27
        pstmt.setString(1, dbo.getSchemaName());
29
        pstmt.setString(2, dbo.getSimpleName());
28
        pstmt.setString(2, dbo.getSimpleName());
30
    }
29
    }
31
    /**
30
    /**
32
     * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.ITableIndexExtractor#getTableIndexQuery()
31
     * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.ITableIndexExtractor#getTableIndexQuery()
33
     */
32
     */
34
    public String getTableIndexQuery() {
33
    public String getTableIndexQuery() {
35
        return query
34
        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