father.setFirstname(null);
tx.begin();
// make sure all objects are retrieved freshly in subsequent transactions
((TransactionImpl) tx).getBroker().clearCache();
OQLQuery qry = odmg.newOQLQuery();
qry.create("select a from " + PersonImpl.class.getName() + " where firstname=$1");
qry.bind(firstnameFather);
Collection result = (Collection) qry.execute();
assertEquals("Exactly one element in result set", 1, result.size());
Person returnedFather = (Person) result.iterator().next();
// should retrieve new instance
assertTrue("not same", returnedFather != father);
Person[] returnedChildren = returnedFather.getChildren();
assertNotNull(returnedChildren);
assertEquals(2, returnedChildren.length);
Person child = returnedChildren[0];
Person lookupFather = child.getFather();
assertNotNull(lookupFather);
assertEquals(returnedFather.getFirstname(), lookupFather.getFirstname());
// unfortunately, PersonImpl does not have a suitable equals method.
assertEquals(
"children's names are equal",
Arrays.asList(getFirstNames(returnedChildren)),
Arrays.asList(getFirstNames(children)));
// System.out.println(Arrays.asList(getFirstNames(returnedChildren)));
tx.commit();
/*
delete father then children
fk-constraints?
*/
tx.begin();
database.deletePersistent(returnedFather);
database.deletePersistent(returnedFather.getChildren()[0]);
database.deletePersistent(returnedFather.getChildren()[1]);
tx.commit();
qry = odmg.newOQLQuery();
qry.create("select a from " + PersonImpl.class.getName() + " where firstname=$1");
qry.bind(firstnameFather);
result = (Collection) qry.execute();
assertEquals("Exactly one element in result set", 0, result.size());
qry = odmg.newOQLQuery();
qry.create("select a from " + PersonImpl.class.getName() + " where firstname=$1");
qry.bind(firstnameChild_1);
result = (Collection) qry.execute();
// System.out.println("child: "+result.iterator().next());
assertEquals("Exactly one element in result set", 0, result.size());
}