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(); }