protected Results runQuery(String path, ConstraintOp op, Collection<String> ranges) throws ObjectStoreException { PathQuery pq = new PathQuery(osw.getModel()); pq.addViews("Employee.name"); pq.addConstraint(Constraints.eq("Employee.name", "temp*")); pq.addConstraint(new PathConstraintRange(path, op, ranges)); Query q = MainHelper.makeQuery(pq, new HashMap(), new HashMap(), null, new HashMap()); Results res = osw.execute(q, 50000, true, false, true); return res; }
private PathQuery getQuery1(Model model) { PathQuery q = new PathQuery(model); q.addView("Employee.name"); q.addConstraint(new PathConstraintAttribute("Employee.age", ConstraintOp.LESS_THAN, "50")); return q; }
@Override protected void setUp() throws Exception { super.setUp(); expectedGoodQuery = new PathQuery(model); expectedGoodQuery.addViews("Employee.age", "Employee.name"); expectedGoodQuery.addConstraint(Constraints.eq("Employee.name", "Tim Canterbury")); pqb = new PathQueryBuilder(); }
private void addHistory(int n) { Model m = im.getModel(); PathQuery q = new PathQuery(m); q.addViews("Employee.name", "Employee.department.name"); q.addConstraint(Constraints.eq("Employee.age", String.valueOf(n))); Date d = new Date(1000 * n); String name = "query_" + n; bobProfile.saveHistory(new SavedQuery(name, d, q)); }
@Test public void nonNullPathQueryCollections() { PathQuery pq = new PathQuery(osw.getModel()); pq.addView("Department.name"); pq.addConstraint(Constraints.eq("Department.name", "temp-*")); pq.addConstraint(Constraints.isNotNull("Department.employees")); Query q = makeQuery(pq); System.out.println(q.toString()); doNonNullCollectionTests(q); }
@Test public void nullPathQueryCollections() { PathQuery pq = new PathQuery(osw.getModel()); pq.addView("Department.name"); pq.addConstraint(Constraints.eq("Department.name", "temp-*")); pq.addConstraint(Constraints.isNull("Department.employees")); Query q = makeQuery(pq); System.out.println(q.toString()); doNullCollectionTests(q); }
@Test public void nullPathQueryCollectionsSynonyms() { PathQuery pq = new PathQuery(osw.getModel()); pq.addView("Department.name"); pq.addConstraint(Constraints.eq("Department.name", "temp-*")); pq.addConstraint(new PathConstraintNull("Department.employees", ConstraintOp.IS_EMPTY)); Query q = makeQuery(pq); System.out.println(q.toString()); doNullCollectionTests(q); }
@Test public void pathQueryNonNullRefs() { PathQuery pq = new PathQuery(osw.getModel()); pq.addView("Department.name"); pq.addConstraint(Constraints.eq("Department.name", "temp-*")); pq.addConstraint(Constraints.isNotNull("Department.company")); Query q = makeQuery(pq); doNonNullRefTests(q); }
public void testMultiTypeQuery() throws Exception { PathQuery pq = new PathQuery(Model.getInstanceByName("testmodel")); pq.addViews("Employable.name"); pq.addConstraint(new PathConstraintMultitype("Employable", ConstraintOp.ISA, Arrays.asList("Contractor", "Manager"))); assertEquals(pq.toString(), savedQueries.get("multitype").toString()); }
public void testGetPathQuery() { PathQuery q = new PathQuery(os.getModel()); q.addView("Employee.name"); q.addView("Employee.age"); q.addView("Employee.fullTime"); q.addView("Employee.department.name"); // bag constraint q.addConstraint(Constraints.in(config.getStartClass(), bag.getName())); q.addConstraint(Constraints.eq("Employee.age", "%category")); q.addConstraint(Constraints.neq("Employee.age", "40")); PathQuery widgetPathQuery = widget.getPathQuery(); assertEquals(q, widgetPathQuery); }
public void testIdBags() throws Exception { PathQuery pq = new PathQuery(Model.getInstanceByName("testmodel")); pq.addViews("Company.name"); pq.addViews("Company.vatNumber"); List ids = Arrays.asList("1","5","7"); pq.addConstraint(new PathConstraintIds("Company", ConstraintOp.IN, ids)); assertEquals(pq.toString(), savedQueries.get("idBagConstraints").toString()); }
public void testNeq() { PathQuery q = new PathQuery(Model.getInstanceByName("testmodel")); q.addConstraint(Constraints.neq("Employee.name", "monkey")); assertEquals("<query name=\"query\" model=\"testmodel\" view=\"\" longDescription=\"\"><constraint path=\"Employee.name\" op=\"!=\" value=\"monkey\"/></query>", q.toXml(1)); }
public void testNotIn() { PathQuery q = new PathQuery(Model.getInstanceByName("testmodel")); q.addConstraint(Constraints.notIn("Employee", "1")); assertEquals("<query name=\"query\" model=\"testmodel\" view=\"\" longDescription=\"\"><constraint path=\"Employee\" op=\"NOT IN\" value=\"1\"/></query>", q.toXml(1)); }
public void testEq() { PathQuery q = new PathQuery(Model.getInstanceByName("testmodel")); q.addConstraint(Constraints.eq("Employee.name", "monkey")); assertEquals("<query name=\"query\" model=\"testmodel\" view=\"\" longDescription=\"\"><constraint path=\"Employee.name\" op=\"=\" value=\"monkey\"/></query>", q.toXml(1)); }
public void testLike() { PathQuery q = new PathQuery(Model.getInstanceByName("testmodel")); q.addConstraint(Constraints.like("Employee.name", "monkey")); assertEquals("<query name=\"query\" model=\"testmodel\" view=\"\" longDescription=\"\"><constraint path=\"Employee.name\" op=\"LIKE\" value=\"monkey\"/></query>", q.toXml(1)); }
public void testIn() { PathQuery q = new PathQuery(Model.getInstanceByName("testmodel")); q.addConstraint(Constraints.in("Employee", " ")); assertEquals("<query name=\"query\" model=\"testmodel\" view=\"\" longDescription=\"\"><constraint path=\"Employee\" op=\"IN\" value=\" \"/></query>", q.toXml(1)); }
public void testLessThanEquals() { PathQuery q = new PathQuery(Model.getInstanceByName("testmodel")); q.addConstraint(Constraints.lessThanEqualTo("Employee.length", "-1")); assertEquals("<query name=\"query\" model=\"testmodel\" view=\"\" longDescription=\"\"><constraint path=\"Employee.length\" op=\"<=\" value=\"-1\"/></query>", q.toXml(1)); }
public void testNullConstraints() throws Exception { PathQuery pq = new PathQuery(Model.getInstanceByName("testmodel")); pq.addViews("Department.name"); pq.addConstraint(new PathConstraintNull("Department.manager", ConstraintOp.IS_NULL)); pq.addOrderBy("Department.name", OrderDirection.ASC); assertEquals(pq.toString(), savedQueries.get("nullConstraint").toString()); }
@Test public void testPQSanity() { PathQuery pq = new PathQuery(osw.getModel()); pq.addView("Department.name"); pq.addConstraint(Constraints.eq("Department.name", "temp-*")); Query q = makeQuery(pq); doSanityTest(q); }
public void testGetPathQuery() { PathQuery q = new PathQuery(os.getModel()); q.addView("Employee.name"); q.addView("Employee.age"); q.addView("Employee.department.name"); // bag constraint q.addConstraint(Constraints.in(config.getStartClass(), bag.getName())); assertEquals(q, widget.getPathQuery()); }