CloneSet79


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

/**
 * Returns a string that looks like:
 * 
 * (PK_COL1, PK_COL2, PK_COL3, ...)
 * 
 * or null if there is no primary key for the specified table.
 * 
 * @param sourceConn
 * @param ti
 * @return
 * @throws SQLException
 */
public static String getPKColumnString(ISQLConnection sourceConn, ITableInfo ti) throws SQLException {
  List<String> pkColumns = getPKColumnList(sourceConn, ti);
  if (pkColumns == null || pkColumns.size() == 0) {
    return null;
  }
  StringBuilder sb = new StringBuilder("(");
  Iterator<String> i = pkColumns.iterator();
  while (i.hasNext()) {
    String columnName = i.next();
    sb.append(columnName);
    if (i.hasNext()) {
      sb.append(", ");
    }
  }
  sb.append(")");
  return sb.toString();
}

/**
 * Returns a list of primary keys or null if there are no primary keys for the specified table.
 * 
 * @param sourceConn
 * @param ti
 * @return
 * @throws SQLException
 */
private static List<String> getPKColumnList(ISQLConnection sourceConn, ITableInfo ti) throws SQLException {
  ArrayList<String> pkColumns = new ArrayList<String>();
  DatabaseMetaData md = sourceConn.getConnection().getMetaData();
  ResultSet rs = null;
  if (md.supportsCatalogsInTableDefinitions()) {
    rs = md.getPrimaryKeys(ti.getCatalogName(), null, ti.getSimpleName());
  }
  else
    if (md.supportsSchemasInTableDefinitions()) {
      rs = md.getPrimaryKeys(null, ti.getSchemaName(), ti.getSimpleName());
    }
    else {
      rs = md.getPrimaryKeys(null, null, ti.getSimpleName());
    }
  while (rs.next()) {
    String keyColumn = rs.getString(4);
    if (keyColumn != null) {
      pkColumns.add(keyColumn);
    }
  }
  if (pkColumns.size() == 0) {
    return null;
  }
  return pkColumns;
}


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

/**
 * Returns a string that looks like: (PK_COL1, PK_COL2, PK_COL3, ...) or null if there is no primary key
 * for the specified table.
 * 
 * @param sourceConn
 * @param ti
 * @return
 * @throws SQLException
 */
public static String getPKColumnString(ISQLConnection sourceConn, ITableInfo ti) throws SQLException {
  List<String> pkColumns = getPKColumnList(sourceConn, ti);
  if (pkColumns == null || pkColumns.size() == 0) {
    return null;
  }
  StringBuilder sb = new StringBuilder("(");
  Iterator<String> i = pkColumns.iterator();
  while (i.hasNext()) {
    String columnName = i.next();
    sb.append(columnName);
    if (i.hasNext()) {
      sb.append(", ");
    }
  }
  sb.append(")");
  return sb.toString();
}

/**
 * Returns a list of primary keys or null if there are no primary keys for the specified table.
 * 
 * @param sourceConn
 * @param ti
 * @return
 * @throws SQLException
 */
private static List<String> getPKColumnList(ISQLConnection sourceConn, ITableInfo ti) throws SQLException {
  ArrayList<String> pkColumns = new ArrayList<String>();
  DatabaseMetaData md = sourceConn.getConnection().getMetaData();
  ResultSet rs = null;
  if (md.supportsCatalogsInTableDefinitions()) {
    rs = md.getPrimaryKeys(ti.getCatalogName(), null, ti.getSimpleName());
  }
  else
    if (md.supportsSchemasInTableDefinitions()) {
      rs = md.getPrimaryKeys(null, ti.getSchemaName(), ti.getSimpleName());
    }
    else {
      rs = md.getPrimaryKeys(null, null, ti.getSimpleName());
    }
  while (rs.next()) {
    String keyColumn = rs.getString(4);
    if (keyColumn != null) {
      pkColumns.add(keyColumn);
    }
  }
  if (pkColumns.size() == 0) {
    return null;
  }
  return pkColumns;
}


Clone AbstractionParameter Count: 0Parameter Bindings

/**
         * Returns a string that looks like:
         * 
         * (PK_COL1, PK_COL2, PK_COL3, ...)
         * 
         * or null if there is no primary key for the specified table.
         * 
         * @param sourceConn
         * @param ti
         * @return
         * @throws SQLException
         */
/**
         * Returns a string that looks like: (PK_COL1, PK_COL2, PK_COL3, ...) or null if there is no primary key
         * for the specified table.
         * 
         * @param sourceConn
         * @param ti
         * @return
         * @throws SQLException
         */
public static String getPKColumnString(ISQLConnection sourceConn, ITableInfo ti) throws SQLException {
  List<String> pkColumns = getPKColumnList(sourceConn, ti);
  if (pkColumns == null || pkColumns.size() == 0) {
    return null;
  }
  StringBuilder sb = new StringBuilder("(");
  Iterator<String> i = pkColumns.iterator();
  while (i.hasNext()) {
    String columnName = i.next();
    sb.append(columnName);
    if (i.hasNext()) {
      sb.append(", ");
    }
  }
  sb.append(")");
  return sb.toString();
}

/**
         * Returns a list of primary keys or null if there are no primary keys for the specified table.
         * 
         * @param sourceConn
         * @param ti
         * @return
         * @throws SQLException
         */
private static List<String> getPKColumnList(ISQLConnection sourceConn, ITableInfo ti) throws SQLException {
  ArrayList<String> pkColumns = new ArrayList<String>();
  DatabaseMetaData md = sourceConn.getConnection().getMetaData();
  ResultSet rs = null;
  if (md.supportsCatalogsInTableDefinitions()) {
    rs = md.getPrimaryKeys(ti.getCatalogName(), null, ti.getSimpleName());
  }
  else
    if (md.supportsSchemasInTableDefinitions()) {
      rs = md.getPrimaryKeys(null, ti.getSchemaName(), ti.getSimpleName());
    }
    else {
      rs = md.getPrimaryKeys(null, null, ti.getSimpleName());
    }
  while (rs.next()) {
    String keyColumn = rs.getString(4);
    if (keyColumn != null) {
      pkColumns.add(keyColumn);
    }
  }
  if (pkColumns.size() == 0) {
    return null;
  }
  return pkColumns;
}
 

CloneAbstraction
Parameter Bindings
Parameter
Index
Clone
Instance
Parameter
Name
Value
None