public String toString() {
StringBuffer sb = new StringBuffer();
sb.append("<");
sb.append(_id);
sb.append(": ");
sb.append(_name);
sb.append(" of ");
if (_owner != null) {
sb.append(_owner.getLastName());
sb.append(", ");
sb.append(_owner.getFirstName());
} else {
sb.append("--nobody--");
}
sb.append(">");
return sb.toString();
}
public void testLazyCollectionRollback() throws PersistenceException, SQLException {
stream.println("Running testLazyCollectionRollback...");
Complex fullname = new Complex("First", "Person");
// set up the data object
_db.begin();
TestLazyEmployee loadPerson = (TestLazyEmployee) _db.load(TestLazyEmployee.class, fullname);
Collection projects = loadPerson.getProjects();
TestLazyProject project = new TestLazyProject();
project = new TestLazyProject();
project.setId(1002);
project.setName("Project Two");
project.setOwner(loadPerson);
projects.add(project);
_db.create(project);
_db.commit();
_db.begin();
loadPerson = (TestLazyEmployee) _db.load(TestLazyEmployee.class, fullname);
projects = loadPerson.getProjects();
// is the collection populated?
assertTrue("The projects collection is not valid!.", projects != null && projects.size() > 0);
// is the collection instanceof Lazy?
assertTrue(
"Collection has to be lazy! It is " + loadPerson.getProjects().getClass(),
loadPerson.getProjects() instanceof org.exolab.castor.persist.Lazy);
// OK, the collection of projects is there, let's test a rollback for bug #1046
stream.println("Rolling back transaction");
_db.rollback();
// test it again since the rollback - is the collection instanceof Lazy?
assertTrue(
"Collection has to be lazy! It is " + loadPerson.getProjects().getClass(),
loadPerson.getProjects() instanceof org.exolab.castor.persist.Lazy);
}
public void testComplex() throws PersistenceException, SQLException {
stream.println("Running testComplex...");
Complex fullname = new Complex("First", "Person");
// set up the data object
_db.begin();
TestLazyEmployee loadPerson = (TestLazyEmployee) _db.load(TestLazyEmployee.class, fullname);
Collection projects = loadPerson.getProjects();
TestLazyProject project = new TestLazyProject();
project.setId(1001);
project.setName("Project One");
project.setOwner(loadPerson);
projects.add(project);
_db.create(project);
project = new TestLazyProject();
project.setId(1002);
project.setName("Project Two");
project.setOwner(loadPerson);
projects.add(project);
_db.create(project);
project = new TestLazyProject();
project.setId(1003);
project.setName("Project Three");
project.setOwner(loadPerson);
projects.add(project);
_db.create(project);
_db.commit();
// reload and test bug 823
_db.begin();
project = (TestLazyProject) _db.load(TestLazyProject.class, new Integer(1002));
_db.remove(project);
loadPerson = (TestLazyEmployee) _db.load(TestLazyEmployee.class, fullname);
projects = loadPerson.getProjects();
Iterator itor = projects.iterator();
while (itor.hasNext()) {
project = (TestLazyProject) itor.next();
if (project.getId() == 1002) {
itor.remove();
break;
}
}
itor = projects.iterator();
while (itor.hasNext()) {
project = (TestLazyProject) itor.next();
if (project.getId() == 1002) {
itor.remove();
break;
}
}
_db.commit();
// reload and make sure the cache is consistent
_db.begin();
loadPerson = (TestLazyEmployee) _db.load(TestLazyEmployee.class, fullname);
projects = loadPerson.getProjects();
itor = projects.iterator();
int id1 = 0;
if (itor.hasNext()) {
project = (TestLazyProject) itor.next();
id1 = project.getId();
if (project.getId() != 1001 && project.getId() != 1003) {
stream.println("Error: found project1 with unexpected id " + project.getId());
fail("Error: found project1 with unexpected id " + project.getId());
}
} else {
stream.println("Error: expected project is not found");
fail("Error: expected project is not found");
}
if (itor.hasNext()) {
project = (TestLazyProject) itor.next();
if (project.getId() == id1 || (project.getId() != 1001 && project.getId() != 1003)) {
stream.println("Error: found project2 with unexpected id " + project.getId());
fail("Error: found project2 with unexpected id " + project.getId());
}
} else {
stream.println("Error: expected project is not found");
fail("Error: expected project is not found");
}
if (itor.hasNext()) {
project = (TestLazyProject) itor.next();
stream.println("Error: unexpected project is found: " + project.getId());
fail("Error: unexpected project is found: " + project.getId());
}
_db.commit();
}
public void testIterWithDelete() throws PersistenceException, SQLException {
stream.println("Running testIterWithDelete...");
// Tests iterating over a lazy-loaded Collection that has
// had data deleted
Complex fullname = new Complex("First", "Person");
// First add a record, then commit
_db.begin();
TestLazyEmployee loadPerson = (TestLazyEmployee) _db.load(TestLazyEmployee.class, fullname);
Collection addresses = loadPerson.getAddress();
TestLazyAddress la = new TestLazyAddress();
la.setId(999);
la.setStreet("Rogue Street");
la.setCity("Rogue City");
la.setState("RS");
la.setZip("10666");
la.setPerson(loadPerson);
addresses.add(la);
_db.commit();
// New transaction
_db.begin();
ArrayList masterData = new ArrayList();
// test java.util.Collection.clear() for lazy loading (bug 801)
loadPerson = (TestLazyEmployee) _db.load(TestLazyEmployee.class, fullname);
addresses = loadPerson.getAddress();
// Store the list in the database at the start of the transaction,
// for comparison purposes. Select a victim for deletion.
Iterator it = addresses.iterator();
// victim is last element to test bug 1022
int victim = addresses.size() - 1;
int recNo = 0;
TestLazyAddress victimAddr = null;
while (it.hasNext()) {
TestLazyAddress addr = (TestLazyAddress) it.next();
if (recNo++ == victim) {
victimAddr = addr;
} else {
masterData.add(addr);
}
}
// The expected number of items to iterate over
int collSize = addresses.size();
_db.rollback();
// Now start over, and add something to the collection. Then try
// iterating and clearing the collection
_db.begin();
loadPerson = (TestLazyEmployee) _db.load(TestLazyEmployee.class, fullname);
addresses = loadPerson.getAddress();
addresses.remove(victimAddr);
Iterator it2 = addresses.iterator();
while (it2.hasNext()) {
TestLazyAddress addr = (TestLazyAddress) it2.next();
if (addr.equals(victimAddr)) {
stream.println("Error: Deleted record should not show up in iteration");
fail("Error: Deleted record should not show up in iteration");
} else {
if (!masterData.remove(addr)) {
stream.println("Error: unrecognized element from list in testIterWithDelete");
fail("Error: unrecognized element from list in testIterWithDelete");
}
}
}
_db.rollback();
if (!masterData.isEmpty()) {
stream.println("Error: iteration/deletion failed in testIterWithDelete");
fail("Error: iteration/deletion failed in testIterWithDelete");
}
}
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();
}