@Test
public void testList() throws Exception {
log.info("testList");
ArrayList<Person> persons = null;
daoUtils.truncateTable("persons");
Person p = personDAO.createPerson(testPerson);
Person p2 = personDAO.createPerson(testPerson2);
persons = personDAO.listPersons();
log.info("persons count : " + persons.size());
Assert.assertTrue(persons.size() > 0);
personDAO.deletePerson(p.getPersonID());
personDAO.deletePerson(p2.getPersonID());
}
@Test
public void testCreateReadDelete() throws Exception {
log.info("testCreate");
Person p = personDAO.createPerson(testPerson);
log.info("p : " + p.toString());
Assert.assertNotNull(p);
Person p2 = personDAO.readPerson(p.getPersonID());
log.info("p2 : " + p2.toString());
Assert.assertNotNull(p2);
Assert.assertEquals(testPerson.getFirstName(), p2.getFirstName());
Assert.assertEquals(testPerson.getLastName(), p2.getLastName());
Assert.assertEquals(testPerson.getAddress(), p2.getAddress());
personDAO.deletePerson(p.getPersonID());
Person p3 = personDAO.readPerson(p.getPersonID());
Assert.assertEquals(0, p3.getPersonID());
Assert.assertNull(p3.getFirstName());
Assert.assertNull(p3.getLastName());
}
@Test
public void testUpdate() throws Exception {
log.info("testUpdate");
String oldLastname = "Windsor";
String newLastname = "Cambridge";
Person p = personDAO.createPerson(testPerson);
Assert.assertNotNull(p);
Person p1 = personDAO.readPerson(p.getPersonID());
Assert.assertNotNull(p1);
Assert.assertEquals(testPerson.getFirstName(), p1.getFirstName());
Assert.assertEquals(oldLastname, p1.getLastName());
p.setLastName(newLastname);
Person p2 = personDAO.updatePerson(p);
Assert.assertNotNull(p2);
Assert.assertEquals(testPerson.getFirstName(), p2.getFirstName());
Assert.assertEquals(newLastname, p2.getLastName());
personDAO.deletePerson(p.getPersonID());
}
