public void testInvalidField() throws Exception { try { new QueryField(qc, "employees"); fail("An IllegalArgumentException should have been thrown"); } catch (IllegalArgumentException e) { } }
public void testStringModulo() { try { QueryField field = new QueryField(new QueryClass(Company.class), "name"); QueryValue two = new QueryValue(new Integer(2)); new QueryExpression(field, QueryExpression.MODULO, two); } catch (ClassCastException e) { // Expected behaviour. } }
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 whereSimpleNotEquals() throws Exception { QueryClass c1 = new QueryClass(Company.class); QueryValue v1 = new QueryValue(new Integer(1234)); QueryField f1 = new QueryField(c1, "vatNumber"); QueryField f2 = new QueryField(c1, "name"); SimpleConstraint sc1 = new SimpleConstraint(f1, ConstraintOp.NOT_EQUALS, v1); Query q1 = new Query(); q1.addFrom(c1); q1.addToSelect(f2); q1.setConstraint(sc1); return q1; }
private Results getFieldSummary(ClassDescriptor cld, String fieldName, ObjectStore os) { Query q = new Query(); q.setDistinct(true); QueryClass qc = new QueryClass(cld.getType()); q.addToSelect(new QueryField(qc, fieldName)); q.addFrom(qc); Results results = os.execute(q); return results; }
public void testNumericModulo() { QueryField field = new QueryField(new QueryClass(CEO.class), "age"); QueryValue two = new QueryValue(new Integer(2)); expression = new QueryExpression(field, QueryExpression.MODULO, two); assertTrue(Number.class.isAssignableFrom(expression.getType())); }
public static Query simpleConstraintNull() throws Exception { Query q1 = new Query(); QueryClass qc = new QueryClass(Manager.class); q1.addFrom(qc); q1.addToSelect(qc); SimpleConstraint c = new SimpleConstraint(new QueryField(qc, "title"), ConstraintOp.IS_NULL); q1.setConstraint(c); return q1; }
public static Query selectFunctionNoGroup() throws Exception { Query q = new Query(); QueryClass qc = new QueryClass(Employee.class); q.addFrom(qc); q.addToSelect(new QueryFunction(new QueryField(qc, "id"), QueryFunction.MIN)); q.setDistinct(false); return q; }
public static Query orderByAnomaly() throws Exception { QueryClass c = new QueryClass(Company.class); Query q = new Query(); q.addFrom(c); q.addToSelect(new QueryValue(new Integer(5))); q.addToSelect(new QueryField(c, "name")); return q; }
public static Query substring2() throws Exception { Query q = new Query(); q.setDistinct(false); QueryClass qc = new QueryClass(Employee.class); q.addFrom(qc); QueryField f = new QueryField(qc, "name"); QueryExpression e = new QueryExpression(f, QueryExpression.SUBSTRING, new QueryValue(new Integer(2))); q.addToSelect(e); return q; }
public static Query substring2() throws Exception { Query q = new Query(); q.setDistinct(false); QueryClass qc = new QueryClass(Employee.class); q.addFrom(qc); QueryField f = new QueryField(qc, "name"); QueryExpression e = new QueryExpression(f, QueryExpression.SUBSTRING, new QueryValue(new Integer(2))); q.addToSelect(e); 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 selectClassAndSubClasses() throws Exception { QueryClass qc1 = new QueryClass(Employee.class); Query q1 = new Query(); q1.addToSelect(qc1); q1.addFrom(qc1); QueryField f1 = new QueryField(qc1, "name"); q1.addToOrderBy(f1); return q1; }
public static Query constrainClass2() throws Exception { Query q = new Query(); QueryClass qc1 = new QueryClass(InterMineObject.class); q.addFrom(qc1); q.addToSelect(qc1); QueryField qf = new QueryField(qc1, "class"); q.setConstraint(new BagConstraint(qf, ConstraintOp.IN, Arrays.asList(Employee.class, Company.class))); q.setDistinct(false); return q; }
public static Query queryClassBagNot() throws Exception { Query q = new Query(); QueryClassBag qcb = new QueryClassBag(Department.class, Arrays.asList(new Object[] {data.get("DepartmentA1"), data.get("DepartmentB1")})); QueryClass qc = new QueryClass(Employee.class); q.addFrom(qcb); q.addFrom(qc); q.addToSelect(new QueryField(qcb)); q.addToSelect(qc); q.setConstraint(new ContainsConstraint(new QueryCollectionReference(qcb, "employees"), ConstraintOp.DOES_NOT_CONTAIN, qc)); q.setDistinct(false); return q; }
public static Query queryClassBag() throws Exception { Query q = new Query(); QueryClassBag qcb = new QueryClassBag(Department.class, Arrays.asList(new Object[]{data.get("DepartmentA1"), data.get("DepartmentB1")})); QueryClass qc = new QueryClass(Employee.class); q.addFrom(qcb); q.addFrom(qc); q.addToSelect(new QueryField(qcb)); q.addToSelect(qc); q.setConstraint(new ContainsConstraint(new QueryCollectionReference(qcb, "employees"), ConstraintOp.CONTAINS, qc)); q.setDistinct(false); return q; }
public static Query indexOf() throws Exception { Query q = new Query(); q.setDistinct(false); QueryClass qc = new QueryClass(Employee.class); q.addFrom(qc); QueryField f = new QueryField(qc, "name"); QueryExpression e = new QueryExpression(f, QueryExpression.INDEX_OF, new QueryValue("oy")); q.addToSelect(e); return q; }
public static Query selectClassFromBrokeEmployable() throws Exception { Query q = new Query(); QueryClass qc = new QueryClass(Broke.class, Employable.class); q.addFrom(qc); QueryField qf = new QueryField(qc, "class"); q.addToSelect(qf); q.addToSelect(new QueryFunction()); q.addToGroupBy(qf); q.setDistinct(false); return q; }
public static Query fieldPathExpression() throws Exception { Query q = new Query(); QueryClass qc = new QueryClass(Company.class); q.addFrom(qc); q.addToSelect(qc); QueryObjectPathExpression qope1 = new QueryObjectPathExpression(qc, "CEO"); qope1.addToSelect(new QueryField(qope1.getDefaultClass(), "name")); q.addToSelect(qope1); q.setDistinct(false); return q; }