public void testAwfulTableUpdateByExample() {
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(new Integer(1));
record.setId2(new Integer(2));
record.setId5(new Integer(5));
record.setId6(new Integer(6));
record.setId7(new Integer(7));
record.setSecondFirstName("fred2");
record.setThirdFirstName("fred3");
dao.insert(record);
record = new AwfulTable();
record.seteMail("fred2@fred.com");
record.setEmailaddress("alsofred2@fred.com");
record.setFirstFirstName("fred11");
record.setFrom("from from field");
record.setId1(new Integer(11));
record.setId2(new Integer(22));
record.setId5(new Integer(55));
record.setId6(new Integer(66));
record.setId7(new Integer(77));
record.setSecondFirstName("fred22");
record.setThirdFirstName("fred33");
dao.insert(record);
AwfulTable newRecord = new AwfulTable();
newRecord.setFirstFirstName("Alonzo");
newRecord.setCustomerId(new Integer(58));
newRecord.setId1(new Integer(111));
newRecord.setId2(new Integer(222));
newRecord.setId5(new Integer(555));
newRecord.setId6(new Integer(666));
newRecord.setId7(new Integer(777));
AwfulTableExample example = new AwfulTableExample();
example.createCriteria().andEMailLike("fred2@%");
int rows = dao.updateByExample(newRecord, example);
assertEquals(1, rows);
example.clear();
example.createCriteria().andCustomerIdEqualTo(new Integer(58));
List answer = dao.selectByExample(example);
assertEquals(1, answer.size());
AwfulTable returnedRecord = (AwfulTable) answer.get(0);
assertEquals(newRecord.getCustomerId(), returnedRecord.getCustomerId());
assertNull(returnedRecord.geteMail());
assertNull(returnedRecord.getEmailaddress());
assertEquals(newRecord.getFirstFirstName(), returnedRecord.getFirstFirstName());
assertNull(returnedRecord.getFrom());
assertEquals(newRecord.getId1(), returnedRecord.getId1());
assertEquals(newRecord.getId2(), returnedRecord.getId2());
assertEquals(newRecord.getId5(), returnedRecord.getId5());
assertEquals(newRecord.getId6(), returnedRecord.getId6());
assertEquals(newRecord.getId7(), returnedRecord.getId7());
assertNull(returnedRecord.getSecondFirstName());
assertNull(returnedRecord.getThirdFirstName());
} catch (Exception e) {
fail(e.getMessage());
}
}