private void specifyOrganism(ConstraintSet cs, String taxonId) { QueryValue taxon = new QueryValue(taxonId); QueryObjectReference orgref = new QueryObjectReference(chromosome, "organism"); addFrom(q, organism); cs.addConstraint(new ContainsConstraint(orgref, ConstraintOp.CONTAINS, organism)); cs.addConstraint(new SimpleConstraint(taxonIdField, ConstraintOp.EQUALS, taxon)); } }
public void testAddConstrint() { ConstraintSet set = new ConstraintSet(ConstraintOp.AND); set.addConstraint(sc1); set.addConstraint(sc2); LinkedHashSet test = new LinkedHashSet(); test.add(sc1); test.add(sc2); assertEquals(test, set.getConstraints()); }
public void testRemoveConstrint() { ConstraintSet set = new ConstraintSet(ConstraintOp.AND); set.addConstraint(sc1); set.addConstraint(sc2); set.removeConstraint(sc1); LinkedHashSet test = new LinkedHashSet(); test.add(sc2); assertEquals(test, set.getConstraints()); }
public void testRemoveNotExists() throws Exception { try { ConstraintSet set = new ConstraintSet(ConstraintOp.OR); set.addConstraint(sc1); set.removeConstraint(sc2); fail("Expected IllegalArgumentExcepion"); } catch (IllegalArgumentException e) { } }
public static Query queryClassBagContainsObjectDouble() throws Exception { Query q = new Query(); QueryClassBag qcb = new QueryClassBag(Department.class, Arrays.asList(new Object[]{data.get("DepartmentA1"), data.get("DepartmentB1")})); q.addFrom(qcb); q.addToSelect(new QueryField(qcb)); ConstraintSet cs = new ConstraintSet(ConstraintOp.AND); cs.addConstraint(new ContainsConstraint(new QueryCollectionReference(qcb, "employees"), ConstraintOp.CONTAINS, (Employee) data.get("EmployeeA1"))); cs.addConstraint(new ContainsConstraint(new QueryCollectionReference(qcb, "employees"), ConstraintOp.CONTAINS, (Employee) data.get("EmployeeA2"))); q.setConstraint(cs); q.setDistinct(false); return q; }
public static Query queryClassBagContainsObjectDouble() throws Exception { Query q = new Query(); QueryClassBag qcb = new QueryClassBag(Department.class, Arrays.asList(new Object[] {data.get("DepartmentA1"), data.get("DepartmentB1")})); q.addFrom(qcb); q.addToSelect(new QueryField(qcb)); ConstraintSet cs = new ConstraintSet(ConstraintOp.AND); cs.addConstraint(new ContainsConstraint(new QueryCollectionReference(qcb, "employees"), ConstraintOp.CONTAINS, (Employee) data.get("EmployeeA1"))); cs.addConstraint(new ContainsConstraint(new QueryCollectionReference(qcb, "employees"), ConstraintOp.CONTAINS, (Employee) data.get("EmployeeA2"))); q.setConstraint(cs); q.setDistinct(false); return q; }
public static Query scientificNumber() throws Exception { Query q = new Query(); QueryClass qc = new QueryClass(Types.class); q.addFrom(qc); q.addToSelect(qc); q.setDistinct(false); ConstraintSet cs = new ConstraintSet(ConstraintOp.AND); q.setConstraint(cs); cs.addConstraint(new SimpleConstraint(new QueryField(qc, "doubleType"), ConstraintOp.LESS_THAN, new QueryValue(new Double(1.3432E+24)))); cs.addConstraint(new SimpleConstraint(new QueryField(qc, "floatType"), ConstraintOp.GREATER_THAN, new QueryValue(new Float(-8.56E-32)))); return q; }
public static Query scientificNumber() throws Exception { Query q = new Query(); QueryClass qc = new QueryClass(Types.class); q.addFrom(qc); q.addToSelect(qc); q.setDistinct(false); ConstraintSet cs = new ConstraintSet(ConstraintOp.AND); q.setConstraint(cs); cs.addConstraint(new SimpleConstraint(new QueryField(qc, "doubleType"), ConstraintOp.LESS_THAN, new QueryValue(new Double(1.3432E+24)))); cs.addConstraint(new SimpleConstraint(new QueryField(qc, "floatType"), ConstraintOp.GREATER_THAN, new QueryValue(new Float(-8.56E-32)))); return q; }
public static Query mergeTrue() throws Exception { Query q = new Query(); QueryClass qc = new QueryClass(Employee.class); q.addFrom(qc); q.addToSelect(qc); ConstraintSet cs1 = new ConstraintSet(ConstraintOp.AND); cs1.addConstraint(new SimpleConstraint(new QueryField(qc, "age"), ConstraintOp.GREATER_THAN, new QueryValue(new Integer(3)))); cs1.addConstraint(new ConstraintSet(ConstraintOp.AND)); q.setConstraint(cs1); q.setDistinct(false); return q; }
public static Query totallyFalse() throws Exception { Query q = new Query(); QueryClass qc = new QueryClass(Employee.class); q.addFrom(qc); q.addToSelect(qc); ConstraintSet cs1 = new ConstraintSet(ConstraintOp.AND); cs1.addConstraint(new SimpleConstraint(new QueryField(qc, "age"), ConstraintOp.GREATER_THAN, new QueryValue(new Integer(3)))); cs1.addConstraint(new ConstraintSet(ConstraintOp.OR)); q.setConstraint(cs1); q.setDistinct(false); return q; }
public static Query mergeTrue() throws Exception { Query q = new Query(); QueryClass qc = new QueryClass(Employee.class); q.addFrom(qc); q.addToSelect(qc); ConstraintSet cs1 = new ConstraintSet(ConstraintOp.AND); cs1.addConstraint(new SimpleConstraint(new QueryField(qc, "age"), ConstraintOp.GREATER_THAN, new QueryValue(new Integer(3)))); cs1.addConstraint(new ConstraintSet(ConstraintOp.AND)); q.setConstraint(cs1); q.setDistinct(false); return q; }
public static Query mergeFalse() throws Exception { Query q = new Query(); QueryClass qc = new QueryClass(Employee.class); q.addFrom(qc); q.addToSelect(qc); ConstraintSet cs1 = new ConstraintSet(ConstraintOp.OR); cs1.addConstraint(new SimpleConstraint(new QueryField(qc, "age"), ConstraintOp.GREATER_THAN, new QueryValue(new Integer(3)))); cs1.addConstraint(new ConstraintSet(ConstraintOp.OR)); q.setConstraint(cs1); q.setDistinct(false); return q; }
public static Query totallyFalse() throws Exception { Query q = new Query(); QueryClass qc = new QueryClass(Employee.class); q.addFrom(qc); q.addToSelect(qc); ConstraintSet cs1 = new ConstraintSet(ConstraintOp.AND); cs1.addConstraint(new SimpleConstraint(new QueryField(qc, "age"), ConstraintOp.GREATER_THAN, new QueryValue(new Integer(3)))); cs1.addConstraint(new ConstraintSet(ConstraintOp.OR)); q.setConstraint(cs1); q.setDistinct(false); return q; }
public static Query mergeFalse() throws Exception { Query q = new Query(); QueryClass qc = new QueryClass(Employee.class); q.addFrom(qc); q.addToSelect(qc); ConstraintSet cs1 = new ConstraintSet(ConstraintOp.OR); cs1.addConstraint(new SimpleConstraint(new QueryField(qc, "age"), ConstraintOp.GREATER_THAN, new QueryValue(new Integer(3)))); cs1.addConstraint(new ConstraintSet(ConstraintOp.OR)); q.setConstraint(cs1); q.setDistinct(false); return q; }
public static Query totallyTrue() throws Exception { Query q = new Query(); QueryClass qc = new QueryClass(Employee.class); q.addFrom(qc); q.addToSelect(qc); ConstraintSet cs1 = new ConstraintSet(ConstraintOp.OR); cs1.addConstraint(new SimpleConstraint(new QueryField(qc, "age"), ConstraintOp.GREATER_THAN, new QueryValue(new Integer(3)))); cs1.addConstraint(new ConstraintSet(ConstraintOp.AND)); q.setConstraint(cs1); q.setDistinct(false); return q; }
public static Query totallyTrue() throws Exception { Query q = new Query(); QueryClass qc = new QueryClass(Employee.class); q.addFrom(qc); q.addToSelect(qc); ConstraintSet cs1 = new ConstraintSet(ConstraintOp.OR); cs1.addConstraint(new SimpleConstraint(new QueryField(qc, "age"), ConstraintOp.GREATER_THAN, new QueryValue(new Integer(3)))); cs1.addConstraint(new ConstraintSet(ConstraintOp.AND)); q.setConstraint(cs1); q.setDistinct(false); return q; }
public static Query interfaceReference() throws Exception { QueryClass qc1 = new QueryClass(HasAddress.class); QueryClass qc2 = new QueryClass(Address.class); Query q1 = new Query(); q1.addToSelect(qc1); q1.addFrom(qc1); q1.addFrom(qc2); ConstraintSet cs = new ConstraintSet(ConstraintOp.AND); cs.addConstraint(new ContainsConstraint(new QueryObjectReference(qc1, "address"), ConstraintOp.CONTAINS, qc2)); cs.addConstraint(new ClassConstraint(qc2, ConstraintOp.EQUALS, (Address) data.get("Employee Street, AVille"))); q1.setConstraint(cs); return q1; }
@Test public void nullRefs() { Query q = new Query(); QueryClass cls = new QueryClass(Department.class); q.addFrom(cls); q.addToSelect(cls); ConstraintSet cons = new ConstraintSet(ConstraintOp.AND); cons.addConstraint(new SimpleConstraint(new QueryField(cls, "name"), ConstraintOp.MATCHES, new QueryValue("temp-%"))); cons.addConstraint(new ContainsConstraint(new QueryObjectReference(cls, "company"), ConstraintOp.IS_NULL)); q.setConstraint(cons); doNullRefTests(q); }
@Test public void nonNullRefs() { Query q = new Query(); QueryClass cls = new QueryClass(Department.class); q.addFrom(cls); q.addToSelect(cls); ConstraintSet cons = new ConstraintSet(ConstraintOp.AND); cons.addConstraint(new SimpleConstraint(new QueryField(cls, "name"), ConstraintOp.MATCHES, new QueryValue("temp-%"))); cons.addConstraint(new ContainsConstraint(new QueryObjectReference(cls, "company"), ConstraintOp.IS_NOT_NULL)); q.setConstraint(cons); doNonNullRefTests(q); }
public void testAddConstraintToNull() throws Exception { Query q = new Query(); QueryClass qc = new QueryClass(Employee.class); Constraint sc = new SimpleConstraint(new QueryField(qc, "name"), ConstraintOp.EQUALS, new QueryValue("Bob")); ConstraintSet cs = new ConstraintSet(ConstraintOp.AND); cs.addConstraint(sc); QueryHelper.addAndConstraint(q, cs); assertEquals(cs, q.getConstraint()); }