public class MysqlViewSourceTab extends FormattedSourceTab { /** SQL that retrieves the source of a view. */ private static String SQL = "SELECT VIEW_DEFINITION " + "FROM INFORMATION_SCHEMA.VIEWS " + "WHERE TABLE_SCHEMA = ? " + "AND TABLE_NAME = ? "; /** Logger for this class. */ private final static ILogger s_log = LoggerController.createLogger(MysqlViewSourceTab.class); public MysqlViewSourceTab(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 View source tab: "+SQL); s_log.debug("Binding catalog name "+doi.getCatalogName()+ " as first bind value"); s_log.debug("Binding table name "+doi.getSimpleName()+ " as second bind value"); } PreparedStatement pstmt = conn.prepareStatement(SQL); pstmt.setString(1, doi.getCatalogName()); pstmt.setString(2, doi.getSimpleName()); return pstmt
public class ViewSourceTab extends FormattedSourceTab { /** SQL that retrieves the source of a stored procedure. */ private static String SQL = "select text " + "from sysobjects " + "inner join syscomments on syscomments.id = sysobjects.id " + "where loginame = ? " + "and name = ? "; /** Logger for this class. */ private final static ILogger s_log = LoggerController.createLogger(ViewSourceTab.class); public ViewSourceTab(String hint, String stmtSep) { super(hint); super.setCompressWhitespace(false); 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 View source tab: "+SQL); s_log.debug("Binding for param 1: "+doi.getCatalogName()); s_log.debug("Binding for param 2: "+doi.getSimpleName()); } PreparedStatement pstmt = conn.prepareStatement(SQL); pstmt.setString(1, doi.getCatalogName()); pstmt.setString(2, doi.getSimpleName()); return pstmt
Clone fragments detected by clone detection tool
File path: /sql12/plugins/mysql/src/net/sourceforge/squirrel_sql/plugins/mysql/tab/MysqlViewSourceTab.java File path: /sql12/plugins/sybase/src/net/sourceforge/squirrel_sql/plugins/SybaseASE/tab/ViewSourceTab.java
Method name: Method name:
Number of AST nodes: 0 Number of AST nodes: 0
1
public class MysqlViewSourceTab extends FormattedSourceTab
1
public class ViewSourceTab extends FormattedSourceTab
2
{
2
{
3
	/** SQL that retrieves the source of a view. */
3
	/** SQL that retrieves the source of a stored procedure. */
4
	private static String SQL =
4
	private static String SQL =
5
        "SELECT VIEW_DEFINITION " +
5
        "
6
        "FROM INFORMATION_SCHEMA.VIEWS " +
7
        "WHERE TABLE_SCHEMA
6
select text " +
7
        "from sysobjects " +
8
        "inner join syscomments on syscomments.id = sysobjects.id " +
8
 = ? " +
9
        "where loginame = ? " +
9
        "AND TABLE_NAME = ? ";
10
        "and name = ? ";
10
    
11
    
11
	/** Logger for this class. */
12
	/** Logger for this class. */
12
	private final static ILogger s_log =
13
	private final static ILogger s_log =
13
		LoggerController.createLogger(MysqlViewSourceTab.class);
14
		LoggerController.createLogger(ViewSourceTab.class);
14
	public MysqlViewSourceTab(String hint, String stmtSep)
15
	public ViewSourceTab(String hint, String stmtSep)
15
	{
16
	{
16
		super(hint);
17
		super(hint);
17
        super.setupFormatter(stmtSep, null);
18
        super.set
18
        super.setCompressWhitespace(true);
19
CompressWhitespace(false);
20
        super.setupFormatter(stmtSep, null);        
19
	}
21
	}
20
	protected PreparedStatement createStatement() throws SQLException
22
	protected PreparedStatement createStatement() throws SQLException
21
	{
23
	{
22
		final ISession session = getSession();
24
		final ISession session = getSession();
23
		final IDatabaseObjectInfo doi = getDatabaseObjectInfo();
25
		final IDatabaseObjectInfo doi = getDatabaseObjectInfo();
24
		ISQLConnection conn = session.getSQLConnection();
26
		ISQLConnection conn = session.getSQLConnection();
25
        if (s_log.isDebugEnabled()) {
27
        if (s_log.isDebugEnabled()) {
26
            s_log.debug("Running SQL for View source tab: "+SQL);
28
            s_log.debug("Running SQL for View source tab: "+SQL);
27
            s_log.debug("Binding catalog name "+doi.getCatalogName()+
29
            s_log.debug("Binding for param 1: "+doi.getCatalogName()
28
                        " as first bind value");
30
);
29
            s_log.debug("Binding table name "+doi.getSimpleName()+
31
            s_log.debug("Binding for param 2: "+doi.getSimpleName()
30
                        " as second bind value");                        
31
            
32
);
32
        }
33
        }
33
		PreparedStatement pstmt = conn.prepareStatement(SQL);
34
		PreparedStatement pstmt = conn.prepareStatement(SQL);
34
        
35
        
35
        pstmt.setString(1, doi.getCatalogName());
36
        pstmt.setString(1, doi.getCatalogName());
36
		pstmt.setString(2, doi.getSimpleName());
37
		pstmt.setString(2, doi.getSimpleName());
37
		return pstmt
38
		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