diff options
| -rw-r--r-- | sonar-core/src/test/java/org/sonar/core/persistence/DatabaseCommands.java | 11 |
1 files changed, 10 insertions, 1 deletions
diff --git a/sonar-core/src/test/java/org/sonar/core/persistence/DatabaseCommands.java b/sonar-core/src/test/java/org/sonar/core/persistence/DatabaseCommands.java index 03b0237a59d..52db5b3a811 100644 --- a/sonar-core/src/test/java/org/sonar/core/persistence/DatabaseCommands.java +++ b/sonar-core/src/test/java/org/sonar/core/persistence/DatabaseCommands.java @@ -63,6 +63,10 @@ public abstract class DatabaseCommands { abstract List<String> resetPrimaryKey(String table, int minSequenceValue); + String getTruncateCommand(String table) { + return "TRUNCATE TABLE " + table; + } + public static DatabaseCommands forDialect(Dialect dialect) { DatabaseCommands command = ImmutableMap.of( org.sonar.core.persistence.dialect.H2.ID, H2, @@ -96,6 +100,11 @@ public abstract class DatabaseCommands { "DROP SEQUENCE " + sequence, "CREATE SEQUENCE " + sequence + " INCREMENT BY 1 MINVALUE 1 START WITH " + minSequenceValue); } + + @Override + String getTruncateCommand(String table) { + return "TRUNCATE TABLE " + table + " REUSE STORAGE"; + } }; private static final DatabaseCommands MSSQL = new DatabaseCommands(new MsSqlDataTypeFactory()) { @@ -128,7 +137,7 @@ public abstract class DatabaseCommands { statement = connection.createStatement(); for (String table : DatabaseVersion.TABLES) { try { - statement.executeUpdate("TRUNCATE TABLE " + table); + statement.executeUpdate(getTruncateCommand(table)); connection.commit(); } catch (Exception e) { // ignore |