CloneSet97


Previous CloneSetNext CloneSetBack to Main Report
Clone
Mass
Clones in
CloneSet
Parameter
Count
Clone
Similarity
Syntax Category
[Sequence Length]
47210.998class_body_declarations[3]
Clone AbstractionParameter Bindings
Clone Instance
(Click to see clone)
Line CountSource Line
Source File
1471582
E:/TSE/Projects-CloneDR/sql12/plugins/dbcopy/src/net/sourceforge/squirrel_sql/plugins/dbcopy/util/DBUtil.java
264513
E:/TSE/Projects-CloneDR/sql12/plugins/dbdiff/src/net/sourceforge/squirrel_sql/plugins/dbdiff/util/DBUtil.java
Next
Last
Clone Instance
1
Line Count
47
Source Line
1582
Source File
E:/TSE/Projects-CloneDR/sql12/plugins/dbcopy/src/net/sourceforge/squirrel_sql/plugins/dbcopy/util/DBUtil.java

/**
 * 
 * @param sourceConn
 * @param ti
 * @param column
 * @return
 * @throws SQLException
 */
public static String getColumnName(ISQLConnection sourceConn, ITableInfo ti, int column) throws SQLException {
  TableColumnInfo[] infoArr = sourceConn.getSQLMetaData().getColumnInfo(ti);
  TableColumnInfo colInfo = infoArr[column];
  return colInfo.getColumnName();
}

/**
 * 
 * @param sourceConn
 * @param ti
 * @return
 * @throws SQLException
 */
public static String[] getColumnNames(ISQLConnection sourceConn, ITableInfo ti) throws SQLException {
  TableColumnInfo[] infoArr = sourceConn.getSQLMetaData().getColumnInfo(ti);
  String[] result = new String[infoArr.length];
  for (int i = 0; i < result.length; i++) {
    TableColumnInfo colInfo = infoArr[i];
    result[i] = colInfo.getColumnName();
  }
  return result;
}

/**
 * 
 * @param columnList
 * @param ti
 * @return
 * @throws SQLException
 */
public static String getSelectQuery(SessionInfoProvider prov, String columnList, ITableInfo ti) throws SQLException, UserCancelledOperationException {
  StringBuilder result = new StringBuilder("select ");
  result.append(columnList);
  result.append(" from ");
  ISession sourceSession = prov.getCopySourceSession();
  String tableName = getQualifiedObjectName(sourceSession, ti.getCatalogName(), ti.getSchemaName(), ti.getSimpleName(), DialectFactory.SOURCE_TYPE);
  result.append(tableName);
  return result.toString();
}


First
Previous
Clone Instance
2
Line Count
64
Source Line
513
Source File
E:/TSE/Projects-CloneDR/sql12/plugins/dbdiff/src/net/sourceforge/squirrel_sql/plugins/dbdiff/util/DBUtil.java

/**
 * @param sourceConn
 * @param ti
 * @param column
 * @return
 * @throws SQLException
 */
public static String getColumnName(ISQLConnection sourceConn, ITableInfo ti, int column) throws SQLException {
  TableColumnInfo[] infoArr = sourceConn.getSQLMetaData().getColumnInfo(ti);
  TableColumnInfo colInfo = infoArr[column];
  return colInfo.getColumnName();
}

/**
 * @param sourceConn
 * @param ti
 * @return
 * @throws SQLException
 */
public static String[] getColumnNames(ISQLConnection sourceConn, ITableInfo ti) throws SQLException {
  TableColumnInfo[] infoArr = sourceConn.getSQLMetaData().getColumnInfo(ti);
  String[] result = new String[infoArr.length];
  for (int i = 0; i < result.length; i++) {
    TableColumnInfo colInfo = infoArr[i];
    result[i] = colInfo.getColumnName();
  }
  return result;
}

/**
 * @param columnList
 * @param ti
 * @return
 * @throws SQLException
 */
public static String getSelectQuery(SessionInfoProvider prov, String columnList, ITableInfo ti) throws SQLException, UserCancelledOperationException {
  StringBuilder result = new StringBuilder("select ");
  result.append(columnList);
  result.append(" from ");
  ISession sourceSession = prov.getDiffSourceSession();
  // String sourceSchema = null;
  // MySQL uses catalogs instead of schemas
  /*
  if (DialectFactory.isMySQLSession(sourceSession)) {
      if (log.isDebugEnabled()) {
          String catalog = 
              prov.getSourceSelectedDatabaseObjects()[0].getCatalogName();
          String schema =
              prov.getSourceSelectedDatabaseObjects()[0].getSchemaName();
          log.debug("Detected MySQL, using catalog ("+catalog+") " +
                    "instead of schema ("+schema+")");
      }
      sourceSchema = 
          prov.getSourceSelectedDatabaseObjects()[0].getCatalogName();
  } else {
      sourceSchema = 
          prov.getSourceSelectedDatabaseObjects()[0].getSchemaName();
  }
  */
  String tableName = getQualifiedObjectName(sourceSession, ti.getCatalogName(), ti.getSchemaName(), ti.getSimpleName(), DialectFactory.SOURCE_TYPE);
  result.append(tableName);
  return result.toString();
}


Clone AbstractionParameter Count: 1Parameter Bindings

/**
         * 
         * @param sourceConn
         * @param ti
         * @param column
         * @return
         * @throws SQLException
         */
/**
         * @param sourceConn
         * @param ti
         * @param column
         * @return
         * @throws SQLException
         */
public static String getColumnName(ISQLConnection sourceConn, ITableInfo ti, int column) throws SQLException {
  TableColumnInfo[] infoArr = sourceConn.getSQLMetaData().getColumnInfo(ti);
  TableColumnInfo colInfo = infoArr[column];
  return colInfo.getColumnName();
}

/**
         * 
         * @param sourceConn
         * @param ti
         * @return
         * @throws SQLException
         */
/**
         * @param sourceConn
         * @param ti
         * @return
         * @throws SQLException
         */
public static String[] getColumnNames(ISQLConnection sourceConn, ITableInfo ti) throws SQLException {
  TableColumnInfo[] infoArr = sourceConn.getSQLMetaData().getColumnInfo(ti);
  String[] result = new String[infoArr.length];
  for (int i = 0; i < result.length; i++) {
    TableColumnInfo colInfo = infoArr[i];
    result[i] = colInfo.getColumnName();
  }
  return result;
}

/**
         * 
         * @param columnList
         * @param ti
         * @return
         * @throws SQLException
         */
/**
         * @param columnList
         * @param ti
         * @return
         * @throws SQLException
         */
public static String getSelectQuery(SessionInfoProvider prov, String columnList, ITableInfo ti) throws SQLException, UserCancelledOperationException {
  StringBuilder result = new StringBuilder("select ");
  result.append(columnList);
  result.append(" from ");
  ISession sourceSession = prov. [[#variable1af26740]]();
  // String sourceSchema = null;
  // MySQL uses catalogs instead of schemas
  /*
                  if (DialectFactory.isMySQLSession(sourceSession)) {
                      if (log.isDebugEnabled()) {
                          String catalog = 
                              prov.getSourceSelectedDatabaseObjects()[0].getCatalogName();
                          String schema =
                              prov.getSourceSelectedDatabaseObjects()[0].getSchemaName();
                          log.debug("Detected MySQL, using catalog ("+catalog+") " +
                                    "instead of schema ("+schema+")");
                      }
                      sourceSchema = 
                          prov.getSourceSelectedDatabaseObjects()[0].getCatalogName();
                  } else {
                      sourceSchema = 
                          prov.getSourceSelectedDatabaseObjects()[0].getSchemaName();
                  }
                  */
  String tableName = getQualifiedObjectName(sourceSession, ti.getCatalogName(), ti.getSchemaName(), ti.getSimpleName(), DialectFactory.SOURCE_TYPE);
  result.append(tableName);
  return result.toString();
}
 

CloneAbstraction
Parameter Bindings
Parameter
Index
Clone
Instance
Parameter
Name
Value
11[[#1af26740]]
getCopySourceSession 
12[[#1af26740]]
getDiffSourceSession