@Test
public void should_iterate_row_with_metadata() throws IOException {
// given
String[] columnNames =
new String[] {
"id",
"firstname",
"lastname",
"state",
"registration",
"city",
"birth",
"nbCommands",
"avgAmount"
};
final InputStream input = this.getClass().getResourceAsStream("dataSetRowMetadata.json");
final ObjectMapper mapper = builder.build();
try (JsonParser parser = mapper.getFactory().createParser(input)) {
final DataSet dataSet = mapper.readerFor(DataSet.class).readValue(parser);
final Iterator<DataSetRow> iterator = dataSet.getRecords().iterator();
List<ColumnMetadata> actualColumns = new ArrayList<>();
int recordCount = 0;
while (iterator.hasNext()) {
final DataSetRow next = iterator.next();
actualColumns = next.getRowMetadata().getColumns();
assertThat(actualColumns, not(empty()));
recordCount++;
}
// then
assertEquals(10, recordCount);
for (int i = 0; i < actualColumns.size(); i++) {
final ColumnMetadata column = actualColumns.get(i);
assertEquals(columnNames[i], column.getId());
}
} catch (Exception e) {
throw new TDPException(CommonErrorCodes.UNABLE_TO_PARSE_JSON, e);
}
}
@Test
public void testRead1() throws Exception {
DataSet dataSet = from(this.getClass().getResourceAsStream("test1.json"));
assertNotNull(dataSet);
final DataSetMetadata metadata = dataSet.getMetadata();
assertEquals("410d2196-8f90-478f-a817-7e8b6694ac91", metadata.getId());
assertEquals("test", metadata.getName());
assertEquals("anonymousUser", metadata.getAuthor());
assertEquals(2, metadata.getContent().getNbRecords());
assertEquals(1, metadata.getContent().getNbLinesInHeader());
assertEquals(0, metadata.getContent().getNbLinesInFooter());
final SimpleDateFormat dateFormat = new SimpleDateFormat("MM-dd-yyyy HH:mm");
dateFormat.setTimeZone(TimeZone.getTimeZone("UTC"));
Date expectedDate = dateFormat.parse("02-17-2015 09:02");
assertEquals(expectedDate, new Date(metadata.getCreationDate()));
List<ColumnMetadata> columns = dataSet.getMetadata().getRowMetadata().getColumns();
assertEquals(6, columns.size());
ColumnMetadata firstColumn = columns.get(0);
assertEquals("0001", firstColumn.getId());
assertEquals("id", firstColumn.getName());
assertEquals("integer", firstColumn.getType());
assertEquals(20, firstColumn.getQuality().getEmpty());
assertEquals(26, firstColumn.getQuality().getInvalid());
assertEquals(54, firstColumn.getQuality().getValid());
ColumnMetadata lastColumn = columns.get(5);
assertEquals("0007", lastColumn.getId());
assertEquals("string", lastColumn.getType());
assertEquals(8, lastColumn.getQuality().getEmpty());
assertEquals(25, lastColumn.getQuality().getInvalid());
assertEquals(67, lastColumn.getQuality().getValid());
}