public void test() {
ExpressionBuilder eb = new ExpressionBuilder();
ReportQuery rq = new ReportQuery(Employee.class, eb);
rq.addAttribute("firstName");
rq.addAttribute("lastName");
Expression exp = eb.getFunction("dbms_random.value");
exp.setSelectIfOrderedBy(false);
rq.addOrdering(exp.ascending());
rq.setSelectionCriteria(eb.anyOf("projects").get("teamLeader").isNull());
results = (Vector) getSession().executeQuery(rq);
}
/** Read employee and clear the cache, test database read. */
public void test() throws Exception {
ReadObjectQuery query = new ReadObjectQuery(Employee.class);
ExpressionBuilder employee = new ExpressionBuilder();
query.setSelectionCriteria(
employee
.get("firstName")
.equal("Brendan")
.and(employee.get("salary").equal(100000))
.and(employee.get("address").get("city").like("%pean%"))
.and(employee.anyOf("phoneNumbers").get("type").equal("Home")));
query.checkCacheOnly();
Employee result = (Employee) getSession().executeQuery(query);
}
public void setup() {
setReferenceClass(Employee.class);
ExpressionBuilder builder = new ExpressionBuilder();
Expression whereClause =
builder.anyOf("managedEmployees").get("address").get("city").equal("Ottawa");
Vector employees = getSession().readAllObjects(Employee.class, whereClause);
setOriginalOject(employees);
getSession().getIdentityMapAccessor().initializeAllIdentityMaps();
String ejbqlString;
ejbqlString =
"SELECT OBJECT(emp) FROM Employee emp, IN(emp.managedEmployees) managedEmployees "
+ "WHERE managedEmployees.address.city = 'Ottawa'";
setEjbqlString(ejbqlString);
super.setup();
}
public void setup() {
Employee emp = (Employee) getSomeEmployees().firstElement();
PhoneNumber phone = (PhoneNumber) emp.getPhoneNumbers().firstElement();
String areaCode = phone.getAreaCode();
String firstName = emp.getFirstName();
setReferenceClass(Employee.class);
ExpressionBuilder employeeBuilder = new ExpressionBuilder();
Expression phones = employeeBuilder.anyOf("phoneNumbers");
Expression whereClause =
phones
.get("owner")
.get("firstName")
.equal(firstName)
.and(phones.get("areaCode").equal(areaCode));
ReportQuery rq = new ReportQuery();
rq.setSelectionCriteria(whereClause);
rq.addAttribute("number", phones.get("number"));
rq.setReferenceClass(Employee.class);
setOriginalOject(getAttributeFromAll("number", (Vector) getSession().executeQuery(rq)));
getSession().getIdentityMapAccessor().initializeAllIdentityMaps();
String ejbqlString;
ejbqlString =
"SELECT phone.number FROM Employee employee, IN(employee.phoneNumbers) phone "
+ "WHERE phone.owner.firstName = \""
+ firstName
+ "\" AND phone.areaCode = \""
+ areaCode
+ "\"";
useReportQuery();
setEjbqlString(ejbqlString);
super.setup();
}
