@Override
public void setUpTest() {
indicatorService = (IndicatorService) getBean(IndicatorService.ID);
batchHandler = batchHandlerFactory.createBatchHandler(IndicatorGroupSetBatchHandler.class);
batchHandler.init();
groupSetA = createIndicatorGroupSet('A');
groupSetB = createIndicatorGroupSet('B');
groupSetC = createIndicatorGroupSet('C');
}
@Ignore
@Test
public void testImportDataValueImportAll() {
importObjectService.addImportObject(ImportObjectStatus.NEW, dataElementAModified, null);
importObjectService.addImportObject(ImportObjectStatus.NEW, dataElementBModified, null);
importObjectService.addImportObject(ImportObjectStatus.NEW, dataElementCModified, null);
importObjectService.addImportObject(ImportObjectStatus.NEW, periodADuplicate, null);
importObjectService.addImportObject(ImportObjectStatus.NEW, organisationUnitAModified, null);
importObjectService.addImportObject(ImportObjectStatus.NEW, organisationUnitBModified, null);
importObjectService.addImportObject(ImportObjectStatus.NEW, organisationUnitCModified, null);
BatchHandler<ImportDataValue> batchHandler =
batchHandlerFactory.createBatchHandler(ImportDataValueBatchHandler.class);
batchHandler.init();
batchHandler.addObject(new ImportDataValue(dataValueADuplicate, ImportObjectStatus.NEW));
batchHandler.addObject(new ImportDataValue(dataValueBDuplicate, ImportObjectStatus.NEW));
batchHandler.addObject(new ImportDataValue(dataValueCDuplicate, ImportObjectStatus.NEW));
batchHandler.addObject(new ImportDataValue(dataValueDDuplicate, ImportObjectStatus.NEW));
batchHandler.addObject(new ImportDataValue(dataValueEDuplicate, ImportObjectStatus.NEW));
batchHandler.addObject(new ImportDataValue(dataValueFDuplicate, ImportObjectStatus.NEW));
batchHandler.addObject(new ImportDataValue(dataValueGDuplicate, ImportObjectStatus.NEW));
batchHandler.addObject(new ImportDataValue(dataValueHDuplicate, ImportObjectStatus.NEW));
batchHandler.addObject(new ImportDataValue(dataValueIDuplicate, ImportObjectStatus.NEW));
batchHandler.flush();
dbmsManager.clearSession();
importObjectService.importAll();
assertEquals(dataElementService.getAllDataElements().size(), 3);
assertEquals(periodService.getPeriodsByPeriodType(periodTypeA).size(), 1);
assertEquals(organisationUnitService.getAllOrganisationUnits().size(), 3);
assertEquals(dataValueService.getAllDataValues().size(), 9);
assertEquals(importObjectService.getImportObjects(DataElement.class).size(), 0);
assertEquals(importObjectService.getImportObjects(Period.class).size(), 0);
assertEquals(importObjectService.getImportObjects(OrganisationUnit.class).size(), 0);
}
@Override
public void execute() {
executeSql("update mapview set valuetype=mapvaluetype where valuetype is null");
executeSql("update mapview set legendtype=maplegendtype where legendtype is null");
executeSql("update mapview set legendsetid=maplegendsetid where legendsetid is null");
executeSql("alter table mapview drop column mapvaluetype");
executeSql("alter table mapview drop column maplegendtype");
executeSql("alter table mapview drop column maplegendsetid");
executeSql("alter table mapview drop column bounds");
executeSql("alter table mapview drop column code");
executeSql("alter table mapview drop column periodtypeid");
executeSql("update mapview set layer='thematic1' where layer is null");
executeSql("update mapview set valuetype='dataElement' where valuetype='dataelement'");
executeSql("alter table mapview alter column opacity type double precision");
String sql =
"select mapviewid, name, userid, longitude, latitude, zoom from mapview where mapviewid not in ("
+ "select mapviewid from mapmapviews)";
BatchHandler<Map> batchHandler =
batchHandlerFactory.createBatchHandler(MapBatchHandler.class).init();
try {
ResultSet rs = statementManager.getHolder().getStatement().executeQuery(sql);
while (rs.next()) {
log.info("Upgrading map view...");
User user = null;
int userId = rs.getInt("userid");
int mapViewId = rs.getInt("mapviewid");
if (userId != 0) {
user = new User();
user.setId(userId);
}
String uid = CodeGenerator.generateCode();
Map map =
new Map(
rs.getString("name"),
user,
rs.getDouble("longitude"),
rs.getDouble("latitude"),
rs.getInt("zoom"));
map.setUid(uid);
int mapId = batchHandler.insertObject(map, true);
statementManager
.getHolder()
.executeUpdate(
"insert into mapmapviews (mapid,mapviewid,sort_order) values("
+ mapId
+ ","
+ mapViewId
+ ",0);");
log.info("Upgraded map view: " + map);
}
} catch (Exception ex) {
log.debug("Error", ex);
return;
} finally {
batchHandler.flush();
}
executeSql("alter table mapview drop column name");
executeSql("alter table mapview drop column userid");
executeSql("alter table mapview drop column longitude");
executeSql("alter table mapview drop column latitude");
executeSql("alter table mapview drop column zoom");
}