public class IndexSourceTab extends FormattedSourceTab { /** SQL that retrieves the source of an index. */ private static String SQL = "select " + "'create '||index_type_name||' '||index_name||' ON '||table_name||'('||column_name||')' " + "from INFORMATION_SCHEMA.INDEXES " + "where table_schema = ? " + "and index_name = ? "; /** Logger for this class. */ private final static ILogger s_log = LoggerController.createLogger(ViewSourceTab.class); public IndexSourceTab(String hint, String stmtSep) { super(hint); super.setCompressWhitespace(true); super.setupFormatter(stmtSep, null); } protected PreparedStatement createStatement() throws SQLException { final ISession session = getSession(); final IDatabaseObjectInfo doi = getDatabaseObjectInfo(); ISQLConnection conn = session.getSQLConnection(); if (s_log.isDebugEnabled()) { s_log.debug("Running SQL for index source tab: "+SQL); s_log.debug("schema name: "+doi.getSchemaName()); s_log.debug("index name: "+doi.getSimpleName()); } PreparedStatement pstmt = conn.prepareStatement(SQL); pstmt.setString(1, doi.getSchemaName()); pstmt.setString(2, doi.getSimpleName()); return pstmt
public class IndexSourceTab extends FormattedSourceTab { /** SQL that retrieves the source of an index. */ private static String SQL = "select indexdef " + "from pg_indexes " + "where schemaname = ? " + "and indexname = ? "; /** Logger for this class. */ private final static ILogger s_log = LoggerController.createLogger(ViewSourceTab.class); public IndexSourceTab(String hint, String stmtSep) { super(hint); super.setupFormatter(stmtSep, null); super.setCompressWhitespace(true); } protected PreparedStatement createStatement() throws SQLException { final ISession session = getSession(); final IDatabaseObjectInfo doi = getDatabaseObjectInfo(); ISQLConnection conn = session.getSQLConnection(); if (s_log.isDebugEnabled()) { s_log.debug("Running SQL for index source tab: "+SQL); s_log.debug("schema name: "+doi.getSchemaName()); s_log.debug("index name: "+doi.getSimpleName()); } PreparedStatement pstmt = conn.prepareStatement(SQL); pstmt.setString(1, doi.getSchemaName()); pstmt.setString(2, doi.getSimpleName()); return pstmt
Clone fragments detected by clone detection tool
File path: /sql12/plugins/h2/src/net/sourceforge/squirrel_sql/plugins/h2/tab/IndexSourceTab.java File path: /sql12/plugins/postgres/src/net/sourceforge/squirrel_sql/plugins/postgres/tab/IndexSourceTab.java
Method name: Method name:
Number of AST nodes: 0 Number of AST nodes: 0
1
public class IndexSourceTab extends FormattedSourceTab
1
public class IndexSourceTab extends FormattedSourceTab
2
{
2
{
3
	/** SQL that retrieves the source of an index. */
3
	/** SQL that retrieves the source of an index. */
4
	private static String SQL =
4
	private static String SQL =
5
        "select " +
5
        "select 
6
        "'create '||index_type_name||' '||index_name||' ON '||table_name||'('||column_name||')' " +
7
        "from INFORMATION_SCHEMA.INDEXES
6
indexdef " +
8
 " +
7
        "from pg_indexes " +
9
        "where table_schema = ? " +
8
        "where schemaname = ? " +
10
        "and index_name = ? ";
9
        "and indexname = ? ";
11
    
10
    
12
	/** Logger for this class. */
11
	/** Logger for this class. */
13
	private final static ILogger s_log =
12
	private final static ILogger s_log =
14
		LoggerController.createLogger(ViewSourceTab.class);
13
		LoggerController.createLogger(ViewSourceTab.class);
15
	public IndexSourceTab(String hint, String stmtSep)
14
	public IndexSourceTab(String hint, String stmtSep)
16
	{
15
	{
17
		super(hint);
16
		super(hint);
18
        super.setCompressWhitespace(true);
17
        super.set
19
        super.setupFormatter(stmtSep, null);        
18
upFormatter(stmtSep, null);
19
        super.setCompressWhitespace(true);
20
	}
20
	}
21
	protected PreparedStatement createStatement() throws SQLException
21
	protected PreparedStatement createStatement() throws SQLException
22
	{
22
	{
23
		final ISession session = getSession();
23
		final ISession session = getSession();
24
		final IDatabaseObjectInfo doi = getDatabaseObjectInfo();
24
		final IDatabaseObjectInfo doi = getDatabaseObjectInfo();
25
		ISQLConnection conn = session.getSQLConnection();
25
		ISQLConnection conn = session.getSQLConnection();
26
        if (s_log.isDebugEnabled()) {
26
        if (s_log.isDebugEnabled()) {
27
            s_log.debug("Running SQL for index source tab: "+SQL);
27
            s_log.debug("Running SQL for index source tab: "+SQL);
28
            s_log.debug("schema name: "+doi.getSchemaName());
28
            s_log.debug("schema name: "+doi.getSchemaName());
29
            s_log.debug("index name: "+doi.getSimpleName());
29
            s_log.debug("index name: "+doi.getSimpleName());
30
        }
30
        }
31
		PreparedStatement pstmt = conn.prepareStatement(SQL);
31
		PreparedStatement pstmt = conn.prepareStatement(SQL);
32
        
32
        
33
        pstmt.setString(1, doi.getSchemaName());
33
        pstmt.setString(1, doi.getSchemaName());
34
		pstmt.setString(2, doi.getSimpleName());
34
		pstmt.setString(2, doi.getSimpleName());
35
		return pstmt
35
		return pstmt
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