CloneSet63


Previous CloneSetNext CloneSetBack to Main Report
Clone
Mass
Clones in
CloneSet
Parameter
Count
Clone
Similarity
Syntax Category
[Sequence Length]
32510.989block
Clone AbstractionParameter Bindings
Clone Instance
(Click to see clone)
Line CountSource Line
Source File
132524
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/FirebirdDialectExt.java
230492
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/H2DialectExt.java
337476
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/HSQLDialectExt.java
436464
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/IngresDialectExt.java
531551
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/MAXDBDialectExt.java
Next
Last
Clone Instance
1
Line Count
32
Source Line
524
Source File
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/FirebirdDialectExt.java

{
  // "ALTER TABLE $childTableName$ " +
  // "ADD $constraint$ $constraintName$ FOREIGN KEY ( $childColumn; separator=\",\"$ ) " +
  // "REFERENCES $parentTableName$ ( $parentColumn; separator=\",\"$ )";
  StringTemplate fkST = new StringTemplate(ST_ADD_FOREIGN_KEY_CONSTRAINT_STYLE_ONE);
  HashMap<String, String> fkValuesMap = DialectUtils.getValuesMap(ST_CHILD_TABLE_KEY, localTableName);
  fkValuesMap.put(ST_CONSTRAINT_KEY, "CONSTRAINT");
  fkValuesMap.put(ST_CONSTRAINT_NAME_KEY, constraintName);
  fkValuesMap.put(ST_PARENT_TABLE_KEY, refTableName);
  StringTemplate childIndexST = null;
  HashMap<String, String> ckIndexValuesMap = null;
  if (autoFKIndex) {
    // "CREATE $unique$ $storageOption$ INDEX $indexName$ " +
    // "ON $tableName$ ( $columnName; separator=\",\"$ )";
    childIndexST = new StringTemplate(ST_CREATE_INDEX_STYLE_TWO);
    ckIndexValuesMap = new HashMap<String, String>();
    ckIndexValuesMap.put(ST_INDEX_NAME_KEY, "fk_child_idx");
  }
  return DialectUtils.getAddForeignKeyConstraintSQL(fkST, fkValuesMap, childIndexST, ckIndexValuesMap, localRefColumns, qualifier, prefs, this );
}


Next
Previous
Clone Instance
2
Line Count
30
Source Line
492
Source File
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/H2DialectExt.java

{
  // FOREIGN KEY (columnName [,...])
  // REFERENCES [refTableName] [(refColumnName[,...])]
  // [ON DELETE {CASCADE | RESTRICT | NO ACTION | SET DEFAULT | SET NULL}]
  // [ON UPDATE {CASCADE | SET DEFAULT | SET NULL}]
  // "ALTER TABLE $childTableName$ " +
  // "ADD $constraint$ $constraintName$ FOREIGN KEY ( $childColumn; separator=\",\"$ ) " +
  // "REFERENCES $parentTableName$ ( $parentColumn; separator=\",\"$ )";
  StringTemplate fkST = new StringTemplate(ST_ADD_FOREIGN_KEY_CONSTRAINT_STYLE_ONE);
  HashMap<String, String> fkValuesMap = DialectUtils.getValuesMap(ST_CHILD_TABLE_KEY, localTableName);
  fkValuesMap.put(ST_CONSTRAINT_KEY, "CONSTRAINT");
  fkValuesMap.put(ST_CONSTRAINT_NAME_KEY, constraintName);
  fkValuesMap.put(ST_PARENT_TABLE_KEY, refTableName);
  StringTemplate childIndexST = null;
  HashMap<String, String> ckIndexValuesMap = null;
  if (autoFKIndex) {
    // "CREATE $unique$ $storageOption$ INDEX $indexName$ " +
    // "ON $tableName$ ( $columnName; separator=\",\"$ )";
    childIndexST = new StringTemplate(ST_CREATE_INDEX_STYLE_TWO);
    ckIndexValuesMap = new HashMap<String, String>();
    ckIndexValuesMap.put(ST_INDEX_NAME_KEY, "fk_child_idx");
  }
  return DialectUtils.getAddForeignKeyConstraintSQL(fkST, fkValuesMap, childIndexST, ckIndexValuesMap, localRefColumns, qualifier, prefs, this );
}


Next
Previous
Clone Instance
3
Line Count
37
Source Line
476
Source File
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/HSQLDialectExt.java

{
  // ALTER TABLE <tablename>
  // ADD [CONSTRAINT <constraintname>] FOREIGN KEY (<column list>)
  // REFERENCES <exptablename> (<column list>)
  // [ON {DELETE | UPDATE} {CASCADE | SET DEFAULT | SET NULL}];
  // "ALTER TABLE $childTableName$ " +
  // "ADD $constraint$ $constraintName$ FOREIGN KEY ( $childColumn; separator=\",\"$ ) " +
  // "REFERENCES $parentTableName$ ( $parentColumn; separator=\",\"$ )";
  StringTemplate fkST = new StringTemplate(ST_ADD_FOREIGN_KEY_CONSTRAINT_STYLE_ONE);
  HashMap<String, String> fkValuesMap = DialectUtils.getValuesMap(ST_CHILD_TABLE_KEY, localTableName);
  fkValuesMap.put(ST_CONSTRAINT_KEY, "CONSTRAINT");
  fkValuesMap.put(ST_CONSTRAINT_NAME_KEY, constraintName);
  fkValuesMap.put(ST_PARENT_TABLE_KEY, refTableName);
  StringTemplate childIndexST = null;
  HashMap<String, String> ckIndexValuesMap = null;
  if (autoFKIndex) {
    // "CREATE $unique$ $storageOption$ INDEX $indexName$ " +
    // "ON $tableName$ ( $columnName; separator=\",\"$ )";
    childIndexST = new StringTemplate(ST_CREATE_INDEX_STYLE_TWO);
    ckIndexValuesMap = new HashMap<String, String>();
    ckIndexValuesMap.put(ST_INDEX_NAME_KEY, "fk_child_idx");
  }
  return DialectUtils.getAddForeignKeyConstraintSQL(fkST, fkValuesMap, childIndexST, ckIndexValuesMap, localRefColumns, qualifier, prefs, this );
}


Next
Previous
Clone Instance
4
Line Count
36
Source Line
464
Source File
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/IngresDialectExt.java

{
  // Alter table <table> add constraint <constraint>
  // foreign key(<column>) references <table>(<column>)
  // on delete set null
  // "ALTER TABLE $childTableName$ " +
  // "ADD $constraint$ $constraintName$ FOREIGN KEY ( $childColumn; separator=\",\"$ ) " +
  // "REFERENCES $parentTableName$ ( $parentColumn; separator=\",\"$ )";
  StringTemplate fkST = new StringTemplate(ST_ADD_FOREIGN_KEY_CONSTRAINT_STYLE_ONE);
  HashMap<String, String> fkValuesMap = DialectUtils.getValuesMap(ST_CHILD_TABLE_KEY, localTableName);
  fkValuesMap.put(ST_CONSTRAINT_KEY, "CONSTRAINT");
  fkValuesMap.put(ST_CONSTRAINT_NAME_KEY, constraintName);
  fkValuesMap.put(ST_PARENT_TABLE_KEY, refTableName);
  StringTemplate childIndexST = null;
  HashMap<String, String> ckIndexValuesMap = null;
  if (autoFKIndex) {
    // "CREATE $unique$ $storageOption$ INDEX $indexName$ " +
    // "ON $tableName$ ( $columnName; separator=\",\"$ )";
    childIndexST = new StringTemplate(ST_CREATE_INDEX_STYLE_TWO);
    ckIndexValuesMap = new HashMap<String, String>();
    ckIndexValuesMap.put(ST_INDEX_NAME_KEY, "fk_child_idx");
  }
  return DialectUtils.getAddForeignKeyConstraintSQL(fkST, fkValuesMap, childIndexST, ckIndexValuesMap, localRefColumns, qualifier, prefs, this );
}


First
Previous
Clone Instance
5
Line Count
31
Source Line
551
Source File
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/MAXDBDialectExt.java

{
  // ALTER TABLE <table_name> ADD
  // FOREIGN KEY [<referential_constraint_name>] (<referencing_column>,...)
  // REFERENCES <referenced_table> [(<referenced_column>,...)] [<delete_rule>]
  // "ALTER TABLE $childTableName$ " +
  // "ADD $constraint$ $constraintName$ FOREIGN KEY ( $childColumn; separator=\",\"$ ) " +
  // "REFERENCES $parentTableName$ ( $parentColumn; separator=\",\"$ )";
  final StringTemplate fkST = new StringTemplate(ST_ADD_FOREIGN_KEY_CONSTRAINT_STYLE_ONE);
  final HashMap<String, String> fkValuesMap = DialectUtils.getValuesMap(ST_CHILD_TABLE_KEY, localTableName);
  fkValuesMap.put(ST_CONSTRAINT_KEY, "CONSTRAINT");
  fkValuesMap.put(ST_CONSTRAINT_NAME_KEY, constraintName);
  fkValuesMap.put(ST_PARENT_TABLE_KEY, refTableName);
  StringTemplate childIndexST = null;
  HashMap<String, String> ckIndexValuesMap = null;
  if (autoFKIndex) {
    // "CREATE $unique$ $storageOption$ INDEX $indexName$ " +
    // "ON $tableName$ ( $columnName; separator=\",\"$ )";
    childIndexST = new StringTemplate(ST_CREATE_INDEX_STYLE_TWO);
    ckIndexValuesMap = new HashMap<String, String>();
    ckIndexValuesMap.put(ST_INDEX_NAME_KEY, "fk_child_idx");
  }
  return DialectUtils.getAddForeignKeyConstraintSQL(fkST, fkValuesMap, childIndexST, ckIndexValuesMap, localRefColumns, qualifier, prefs, this );
}


Clone AbstractionParameter Count: 1Parameter Bindings

{
   [[#variable1af2d900]]
  // Alter table <table> add constraint <constraint>
  // foreign key(<column>) references <table>(<column>)
  // on delete set null
  // ALTER TABLE <tablename>
  // ADD [CONSTRAINT <constraintname>] FOREIGN KEY (<column list>)
  // REFERENCES <exptablename> (<column list>)
  // [ON {DELETE | UPDATE} {CASCADE | SET DEFAULT | SET NULL}];
  // FOREIGN KEY (columnName [,...])
  // REFERENCES [refTableName] [(refColumnName[,...])]
  // [ON DELETE {CASCADE | RESTRICT | NO ACTION | SET DEFAULT | SET NULL}]
  // [ON UPDATE {CASCADE | SET DEFAULT | SET NULL}]
  // "ALTER TABLE $childTableName$ " +
  // "ADD $constraint$ $constraintName$ FOREIGN KEY ( $childColumn; separator=\",\"$ ) " +
  // "REFERENCES $parentTableName$ ( $parentColumn; separator=\",\"$ )";
  StringTemplate fkST = new StringTemplate(ST_ADD_FOREIGN_KEY_CONSTRAINT_STYLE_ONE);
   [[#variable1af2d900]]HashMap<String, String> fkValuesMap = DialectUtils.getValuesMap(ST_CHILD_TABLE_KEY, localTableName);
  fkValuesMap.put(ST_CONSTRAINT_KEY, "CONSTRAINT");
  fkValuesMap.put(ST_CONSTRAINT_NAME_KEY, constraintName);
  fkValuesMap.put(ST_PARENT_TABLE_KEY, refTableName);
  StringTemplate childIndexST = null;
  HashMap<String, String> ckIndexValuesMap = null;
  if (autoFKIndex) {
    // "CREATE $unique$ $storageOption$ INDEX $indexName$ " +
    // "ON $tableName$ ( $columnName; separator=\",\"$ )";
    childIndexST = new StringTemplate(ST_CREATE_INDEX_STYLE_TWO);
    ckIndexValuesMap = new HashMap<String, String>();
    ckIndexValuesMap.put(ST_INDEX_NAME_KEY, "fk_child_idx");
  }
  return DialectUtils.getAddForeignKeyConstraintSQL(fkST, fkValuesMap, childIndexST, ckIndexValuesMap, localRefColumns, qualifier, prefs, this );
}
 

CloneAbstraction
Parameter Bindings
Parameter
Index
Clone
Instance
Parameter
Name
Value
11[[#1af2d900]]
12[[#1af2d900]]
13[[#1af2d900]]
14[[#1af2d900]]
15[[#1af2d900]]
// ALTER TABLE <table_name> ADD
// FOREIGN KEY [<referential_constraint_name>] (<referencing_column>,...)
// REFERENCES <referenced_table> [(<referenced_column>,...)] [<delete_rule>]
// "ALTER TABLE $childTableName$ " +
// "ADD $constraint$ $constraintName$ FOREIGN KEY ( $childColumn; separator=\",\"$ ) " +
// "REFERENCES $parentTableName$ ( $parentColumn; separator=\",\"$ )";
final