use of org.jpox.samples.one_many.unidir_2.UserGroup in project tests by datanucleus.
the class JDOQLEvaluatorTest method testFilterCollectionContains.
/**
* Test of filter with collectionField.contains(element).
*/
public void testFilterCollectionContains() {
PersistenceManager pm = pmf.getPersistenceManager();
Transaction tx = pm.currentTransaction();
try {
tx.begin();
// Create some instances to query over
List<UserGroup> instances = new ArrayList<>();
UserGroup grp1 = new UserGroup(101, "First Group");
UserGroup grp2 = new UserGroup(102, "Second Group");
UserGroup grp3 = new UserGroup(103, "Third Group");
GroupMember mem1 = new GroupMember(201, "Donald Duck");
GroupMember mem2 = new GroupMember(202, "Mickey Mouse");
GroupMember mem3 = new GroupMember(203, "Minnie Mouse");
grp1.getMembers().add(mem1);
grp2.getMembers().add(mem1);
grp2.getMembers().add(mem2);
grp3.getMembers().add(mem2);
grp3.getMembers().add(mem3);
instances.add(grp1);
instances.add(grp2);
instances.add(grp3);
// Compile the query
JDOQuery q = (JDOQuery) pm.newQuery(UserGroup.class, "members.contains(el) && el.name == 'Minnie Mouse'");
q.declareVariables(GroupMember.class.getName() + " el");
Query query = q.getInternalQuery();
ClassLoaderResolver clr = query.getExecutionContext().getClassLoaderResolver();
JavaQueryCompiler compiler = new JDOQLCompiler(query.getExecutionContext().getNucleusContext(), clr, null, query.getCandidateClass(), null, query.getFilter(), query.getParsedImports(), query.getOrdering(), query.getResult(), query.getGrouping(), query.getHaving(), query.getExplicitParametersDeclaration(), query.getExplicitVariablesDeclaration(), null);
QueryCompilation compilation = compiler.compile(new HashMap(), null);
// Execute the query
JavaQueryInMemoryEvaluator eval = new JDOQLInMemoryEvaluator(query, instances, compilation, null, clr);
List results = (List) eval.execute(true, true, true, true, true);
assertEquals("Number of result instances was wrong", 1, results.size());
UserGroup grp = (UserGroup) results.get(0);
assertEquals("Result instance has wrong name", "Third Group", grp.getName());
tx.commit();
} catch (Exception e) {
LOG.info(">> Unexpected exception thrown during test", e);
fail("Exception thrown during query execution " + e.getMessage());
} finally {
if (tx.isActive()) {
tx.rollback();
}
pm.close();
}
}
use of org.jpox.samples.one_many.unidir_2.UserGroup in project tests by datanucleus.
the class JDOQLBasicTest method testQueryUnboundVariablesInheritanceRightHandDeclared2.
public void testQueryUnboundVariablesInheritanceRightHandDeclared2() {
try {
ModeratedUserGroup grp1 = new ModeratedUserGroup(1, "JDO Expert Group");
ModeratedUserGroup grp2 = new ModeratedUserGroup(1, "JPA Expert Group");
ModeratedUserGroup grp3 = new ModeratedUserGroup(1, "J2EE Expert Group");
ExpertGroupMember mem1 = new ExpertGroupMember(1, "Craig Russell");
ExpertGroupMember mem2 = new ExpertGroupMember(1, "Linda De Michiel");
ExpertGroupMember mem3 = new ExpertGroupMember(1, "Bill Shannon");
grp1.getMembers().add(mem1);
grp2.getMembers().add(mem2);
grp3.getMembers().add(mem2);
grp3.getMembers().add(mem3);
PersistenceManager pm = pmf.getPersistenceManager();
Transaction tx = pm.currentTransaction();
try {
tx.begin();
pm.makePersistent(grp1);
pm.makePersistent(grp2);
pm.makePersistent(grp3);
tx.commit();
tx.begin();
Query q = pm.newQuery(pm.getExtent(UserGroup.class, true));
Collection c = q.filter("(mem.name == \"Craig Russell\") && this.members.contains(mem)").variables("ExpertGroupMember mem").imports("import org.jpox.samples.one_many.unidir_2.ExpertGroupMember").executeList();
assertEquals(1, c.size());
assertEquals(((UserGroup) c.iterator().next()).getName(), "JDO Expert Group");
tx.commit();
} finally {
if (tx.isActive()) {
tx.rollback();
}
pm.close();
}
} finally {
// Clean out our data
clean(ModeratedUserGroup.class);
clean(ExpertGroupMember.class);
}
}
Aggregations