@SuppressWarnings("unchecked")
@Test
public void insert_indexRecordsIntoTable() throws Exception {

    List<IndexRecord> records = getRecords();
    service.insert(table, records);
    List<Map<String, Object>> rows = jdbc.queryForList("SELECT * FROM `TEST`");
    Map<String, Object> row;
    row = rows.get(0);
    assertEquals(1L, row.get("ID"));
    assertEquals("Arthur", row.get("NAME"));
    assertEquals(42, row.get("AGE"));
    row = rows.get(1);
    assertEquals(2L, row.get("ID"));
    assertEquals("Ford", row.get("NAME"));
    assertNull(row.get("AGE"));
}