@Test
public void testAwfulTableSelectByExampleIn() {
AwfulTableDAO dao = getAwfulTableDAO();
try {
AwfulTable record = new AwfulTable();
record.seteMail("fred@fred.com");
record.setEmailaddress("alsofred@fred.com");
record.setFirstFirstName("fred1");
record.setFrom("from field");
record.setId1(1);
record.setId2(2);
record.setId5(5);
record.setId6(6);
record.setId7(7);
record.setSecondFirstName("fred2");
record.setThirdFirstName("fred3");
dao.insert(record);
record = new AwfulTable();
record.seteMail("wilma@wilma.com");
record.setEmailaddress("alsoWilma@wilma.com");
record.setFirstFirstName("wilma1");
record.setFrom("from field");
record.setId1(11);
record.setId2(22);
record.setId5(55);
record.setId6(66);
record.setId7(77);
record.setSecondFirstName("wilma2");
record.setThirdFirstName("wilma3");
dao.insert(record);
record = new AwfulTable();
record.seteMail("pebbles@pebbles.com");
record.setEmailaddress("alsoPebbles@pebbles.com");
record.setFirstFirstName("pebbles1");
record.setFrom("from field");
record.setId1(111);
record.setId2(222);
record.setId5(555);
record.setId6(666);
record.setId7(777);
record.setSecondFirstName("pebbles2");
record.setThirdFirstName("pebbles3");
dao.insert(record);
record = new AwfulTable();
record.seteMail("barney@barney.com");
record.setEmailaddress("alsoBarney@barney.com");
record.setFirstFirstName("barney1");
record.setFrom("from field");
record.setId1(1111);
record.setId2(2222);
record.setId5(5555);
record.setId6(6666);
record.setId7(7777);
record.setSecondFirstName("barney2");
record.setThirdFirstName("barney3");
dao.insert(record);
record = new AwfulTable();
record.seteMail("betty@betty.com");
record.setEmailaddress("alsoBetty@betty.com");
record.setFirstFirstName("betty1");
record.setFrom("from field");
record.setId1(11111);
record.setId2(22222);
record.setId5(55555);
record.setId6(66666);
record.setId7(77777);
record.setSecondFirstName("betty2");
record.setThirdFirstName("betty3");
dao.insert(record);
record = new AwfulTable();
record.seteMail("bammbamm@bammbamm.com");
record.setEmailaddress("alsoBammbamm@bammbamm.com");
record.setFirstFirstName("bammbamm1");
record.setFrom("from field");
record.setId1(111111);
record.setId2(222222);
record.setId5(555555);
record.setId6(666666);
record.setId7(777777);
record.setSecondFirstName("bammbamm2");
record.setThirdFirstName("bammbamm3");
dao.insert(record);
List<Integer> ids = new ArrayList<Integer>();
ids.add(1);
ids.add(11);
AwfulTableExample example = new AwfulTableExample();
example.createCriteria().andId1In(ids);
example.setOrderByClause("\"A_CuStOmEr iD\"");
List<AwfulTable> answer = dao.selectByExample(example);
assertEquals(2, answer.size());
AwfulTable returnedRecord = answer.get(0);
assertEquals(1, returnedRecord.getId1().intValue());
assertEquals(2, returnedRecord.getId2().intValue());
returnedRecord = answer.get(1);
assertEquals(11, returnedRecord.getId1().intValue());
assertEquals(22, returnedRecord.getId2().intValue());
} catch (SQLException e) {
fail(e.getMessage());
}
}