package eu.etaxonomy.cdm.database;
+
/**
* based on from http://code.google.com/p/java-tester/source/browse/trunk/src/main/java/org/jtester/unitils/database/H2DbSupport.java
*/
@Override
public void incrementSequenceToValue(String sequenceName, long newSequenceValue) {
- getSQLHandler()
- .executeUpdate("alter sequence " + qualified(sequenceName) + " restart with " + newSequenceValue);
+ getSQLHandler().executeUpdate(
+ "alter sequence " + qualified(sequenceName) + " restart with " + newSequenceValue);
}
@Override
public void incrementIdentityColumnToValue(String tableName, String identityColumnName, long identityValue) {
getSQLHandler().executeUpdate(
- "alter table " + qualified(tableName) + " alter column " + quoted(identityColumnName)
- + " RESTART WITH " + identityValue);
+ "alter table " + qualified(tableName) + " alter column " + quoted(identityColumnName)
+ + " RESTART WITH " + identityValue);
}
@Override
public void disableReferentialConstraints() {
Set<String> tableNames = getTableNames();
for (String tableName : tableNames) {
- disableReferentialConstraints(tableName);
+ disableReferentialConstraints(tableName);
}
}
private void disableReferentialConstraints(String tableName) {
Set<String> constraintNames = this.getForeignKeyConstraintNames(tableName);
for (String constraintName : constraintNames) {
- this.removeForeignKeyConstraint(tableName, constraintName);
+ this.removeForeignKeyConstraint(tableName, constraintName);
}
}
Set<String> notNullColumnNames = this.getNotNullColummnNames(tableName);
for (String notNullColumnName : notNullColumnNames) {
- if (primaryKeyColumnNames.contains(notNullColumnName)) {
- continue;
- }
- this.removeNotNullConstraint(tableName, notNullColumnName);
+ if (primaryKeyColumnNames.contains(notNullColumnName)) {
+ continue;
+ }
+ this.removeNotNullConstraint(tableName, notNullColumnName);
}
}