public void upgradeDatabase(SqlExecutor executor, int oldVersion, int newVersion)
throws Exception {
Upgrade[] upgrades = contentProviderAnnotation.upgrades();
for (Upgrade upgrade : upgrades) {
if (upgrade.version() <= oldVersion || upgrade.version() > newVersion) {
continue;
}
for (String sql : upgrade.SQLs()) {
try {
System.out.println("SORMA" + "\t" + "execute update " + sql);
executor.execute(sql);
} catch (Exception e) {
throw new SormaException(e);
}
}
}
}
