@SuppressFBWarnings("SQL_NONCONSTANT_STRING_PASSED_TO_EXECUTE")
public static void execute(
Configuration jooqConf,
IndexStorage.CollectionSchema colSchema,
@Nonnull DatabaseInterface databaseInterface) {
ConnectionProvider provider = jooqConf.connectionProvider();
Connection connection = provider.acquire();
Statement st = null;
try {
st = connection.createStatement();
st.executeUpdate(databaseInterface.dropSchemaStatement(colSchema.getName()));
DSLContext dsl = DSL.using(jooqConf);
int deleted =
dsl.deleteFrom(CollectionsTable.COLLECTIONS)
.where(CollectionsTable.COLLECTIONS.NAME.eq(colSchema.getCollection()))
.execute();
assert deleted == 1;
} catch (SQLException ex) {
throw new ToroImplementationException(ex);
} finally {
AutoCloser.close(st);
}
}
