public void testGeneral() throws PersistenceException, SQLException {
stream.println("Running testGeneral...");
_db.begin();
Complex fullname = new Complex("First", "Person");
TestLazyEmployee loadPerson = (TestLazyEmployee) _db.load(TestLazyEmployee.class, fullname);
if (loadPerson.getBirthday().equals(new Date(1922, 2, 2))
&& loadPerson.getFirstName().equals("First")
&& loadPerson.getLastName().equals("Person")) {
stream.println("OK: Employee is valid");
Collection address = loadPerson.getAddress();
Iterator itor = address.iterator();
TestLazyAddress[] addresses = {null, null, null};
TestLazyAddress addr;
while (itor.hasNext()) {
addr = (TestLazyAddress) itor.next();
if (addr.getId() < 1 || addr.getId() > 3) {
_db.rollback();
stream.println("Error: Address id is incorrect");
fail("address id is incorrect");
}
addresses[addr.getId() - 1] = addr;
}
if (addresses[0] == null
|| !addresses[0].getStreet().equals("#1 Address Street")
|| !addresses[0].getCity().equals("First City")
|| !addresses[0].getState().equals("AB")
|| !addresses[0].getZip().equals("10000")
|| addresses[0].getPerson() != loadPerson) {
stream.println("Error: Address 1 is incorrect: " + addresses[0]);
_db.rollback();
fail("address 1 is incorrect");
}
stream.println("OK: Address 1 are valid");
if (addresses[1] == null
|| !addresses[1].getStreet().equals("2nd Ave")
|| !addresses[1].getCity().equals("Second City")
|| !addresses[1].getState().equals("BC")
|| !addresses[1].getZip().equals("22222")
|| addresses[1].getPerson() != loadPerson) {
stream.println("Error: Address 2 is incorrect");
_db.rollback();
fail("address 2 is incorrect");
}
stream.println("OK: Address 2 are valid");
TestLazyPayRoll payroll = loadPerson.getPayRoll();
if (payroll == null
|| payroll.getId() != 1
|| payroll.getHoliday() != 15
|| payroll.getEmployee() != loadPerson
|| payroll.getHourlyRate() != 25) {
stream.println("Error: PayRoll loaded incorrect");
_db.rollback();
fail("payroll is incorrect");
}
stream.println("OK: PayRoll is valid");
TestLazyContract cont = loadPerson.getContract();
if (cont == null
|| cont.getPolicyNo() != 1001
|| cont.getEmployee() != loadPerson
|| cont.getContractNo() != 78) {
stream.println("Error: Contract is not what expected!");
stream.println(
"employe==null? "
+ cont.getEmployee()
+ "/"
+ cont.getEmployee().getFirstName()
+ "/"
+ cont.getEmployee().getLastName());
stream.println(
"loadPerson? "
+ loadPerson
+ "/"
+ loadPerson.getFirstName()
+ "/"
+ loadPerson.getLastName());
_db.rollback();
fail("contract is incorrect");
}
stream.println("OK: Contract is valid");
Collection catelist = cont.getCategory();
itor = catelist.iterator();
TestLazyContractCategory cate;
while (itor.hasNext()) {
cate = (TestLazyContractCategory) itor.next();
if (cate.getId() == 101 && cate.getName().equals("Full-time slave")) {
} else if (cate.getId() == 102 && cate.getName().equals("Full-time employee")) {
} else {
stream.println("Error: Category is incorrect");
_db.rollback();
fail("category is incorrect");
}
}
stream.println("OK: Categories are valid");
// now modified the object and store it
address.remove(addresses[0]);
addresses[1].setStreet("New Second Street");
} else {
_db.rollback();
stream.println("Error: FirstName, LastName or Birthday is incorrect!");
fail("FirstName, LastName or Birthday is incorrect!");
}
_db.commit();
// test and see if changes made succeed
_db.begin();
loadPerson = (TestLazyEmployee) _db.load(TestLazyEmployee.class, fullname);
if (loadPerson.getBirthday().equals(new Date(1922, 2, 2))
&& loadPerson.getFirstName().equals("First")
&& loadPerson.getLastName().equals("Person")) {
stream.println("OK: Employee is valid");
Collection address = loadPerson.getAddress();
Iterator itor = address.iterator();
TestLazyAddress[] addresses = {null, null, null};
TestLazyAddress addr;
while (itor.hasNext()) {
addr = (TestLazyAddress) itor.next();
if (addr.getId() < 1 || addr.getId() > 3) {
_db.rollback();
stream.println("Error: Address id is incorrect");
fail("address id is incorrect");
}
addresses[addr.getId() - 1] = addr;
}
if (addresses[0] != null) {
stream.println("Error: Address 1 is not deleted: " + addresses[0]);
fail("address 1 is not deleted");
}
stream.println("OK: Address 1 is deleted");
if (addresses[1] == null
|| !addresses[1].getStreet().equals("New Second Street")
|| !addresses[1].getCity().equals("Second City")
|| !addresses[1].getState().equals("BC")
|| !addresses[1].getZip().equals("22222")
|| addresses[1].getPerson() != loadPerson) {
stream.println("Error: Address 2 is incorrect");
_db.rollback();
fail("address 2 is incorrect");
}
stream.println("OK: Address 2 are valid: " + addresses[1]);
TestLazyPayRoll payroll = loadPerson.getPayRoll();
if (payroll == null
|| payroll.getId() != 1
|| payroll.getHoliday() != 15
|| payroll.getEmployee() != loadPerson
|| payroll.getHourlyRate() != 25) {
stream.println("Error: PayRoll loaded incorrect");
_db.rollback();
fail("payroll is incorrect");
}
stream.println("OK: PayRoll is valid");
TestLazyContract cont = loadPerson.getContract();
if (cont == null
|| cont.getPolicyNo() != 1001
|| cont.getEmployee() != loadPerson
|| cont.getContractNo() != 78) {
stream.println("Error: Contract is not what expected!");
stream.println(
"employe==null? "
+ cont.getEmployee()
+ "/"
+ cont.getEmployee().getFirstName()
+ "/"
+ cont.getEmployee().getLastName());
stream.println(
"loadPerson? "
+ loadPerson
+ "/"
+ loadPerson.getFirstName()
+ "/"
+ loadPerson.getLastName());
_db.rollback();
fail("contract is incorrect");
}
stream.println("OK: Contract is valid");
Collection catelist = cont.getCategory();
itor = catelist.iterator();
TestLazyContractCategory cate;
while (itor.hasNext()) {
cate = (TestLazyContractCategory) itor.next();
if (cate.getId() == 101 && cate.getName().equals("Full-time slave")) {
} else if (cate.getId() == 102 && cate.getName().equals("Full-time employee")) {
} else {
stream.println("Error: Category is incorrect");
_db.rollback();
fail("category is incorrect");
}
}
stream.println("OK: Categories are valid");
} else {
_db.rollback();
stream.println("Error: FirstName, LastName or Birthday is incorrect!");
fail("FirstName, LastName or Birthday is incorrect!");
}
_db.commit();
}
public void createDataObjects() throws PersistenceException, SQLException {
_db.begin();
// create person 1
TestLazyEmployee person = new TestLazyEmployee();
person.setFirstName("First");
person.setLastName("Person");
person.setBirthday(new Date(1922, 2, 2));
person.setStartDate(new Date(2000, 2, 2));
TestLazyAddress address1 = new TestLazyAddress();
address1.setId(1);
address1.setStreet("#1 Address Street");
address1.setCity("First City");
address1.setState("AB");
address1.setZip("10000");
address1.setPerson(person);
TestLazyAddress address2 = new TestLazyAddress();
address2.setId(2);
address2.setStreet("2nd Ave");
address2.setCity("Second City");
address2.setState("BC");
address2.setZip("22222");
address2.setPerson(person);
TestLazyAddress address3 = new TestLazyAddress();
address3.setId(3);
address3.setStreet("3rd Court");
address3.setCity("Third Ave");
address3.setState("AB");
address3.setZip("30003");
address3.setPerson(person);
ArrayList addresslist = new ArrayList();
addresslist.add(address1);
addresslist.add(address2);
addresslist.add(address3);
person.setAddress(addresslist);
TestLazyPayRoll pr1 = new TestLazyPayRoll();
pr1.setId(1);
pr1.setHoliday(15);
pr1.setHourlyRate(25);
pr1.setEmployee(person);
person.setPayRoll(pr1);
TestLazyContractCategory cc = new TestLazyContractCategory();
cc.setId(101);
cc.setName("Full-time slave");
_db.create(cc);
TestLazyContractCategory cc2 = new TestLazyContractCategory();
cc2.setId(102);
cc2.setName("Full-time employee");
_db.create(cc2);
ArrayList category = new ArrayList();
category.add(cc);
category.add(cc2);
TestLazyContract con = new TestLazyContract();
con.setPolicyNo(1001);
con.setComment(
"80 hours a week, no pay hoilday, no sick leave, arrive office at 7:30am everyday");
con.setContractNo(78);
con.setEmployee(person);
con.setCategory(category);
person.setContract(con);
_db.create(person);
_db.commit();
}
