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 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()); }
public static Query selectWhereBackslash() throws Exception { Query q = new Query(); QueryClass qc = new QueryClass(Employee.class); q.addFrom(qc); q.addToSelect(qc); q.setConstraint(new SimpleConstraint(new QueryField(qc, "name"), ConstraintOp.EQUALS, new QueryValue("Fred\\Blog's"))); q.setDistinct(false); return q; }
public static Query rangeOverlapsValues() throws Exception { Query q = new Query(); QueryClass qc1 = new QueryClass(Range.class); q.addFrom(qc1); q.addToSelect(new QueryField(qc1, "id")); OverlapRange r1 = new OverlapRange(new QueryField(qc1, "rangeStart"), new QueryField(qc1, "rangeEnd"), new QueryObjectReference(qc1, "parent")); OverlapRange r2 = new OverlapRange(new QueryValue(35), new QueryValue(45), new QueryObjectReference(qc1, "parent")); q.setConstraint(new OverlapConstraint(r1, ConstraintOp.OVERLAPS, r2)); 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 collectionPathExpression5() throws Exception { Query q = new Query(); QueryClass qc = new QueryClass(Company.class); q.addFrom(qc); q.addToSelect(qc); QueryCollectionPathExpression qcpe = new QueryCollectionPathExpression(qc, "departments"); qcpe.setConstraint(new SimpleConstraint(new QueryField(qcpe.getDefaultClass(), "name"), ConstraintOp.MATCHES, new QueryValue("%1"))); q.addToSelect(qcpe); q.setDistinct(false); return q; }
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 containsConstraintNullCollection1N() throws Exception { Query q1 = new Query(); QueryClass qc = new QueryClass(Department.class); q1.addFrom(qc); q1.addToSelect(qc); ContainsConstraint c = new ContainsConstraint( new QueryCollectionReference(qc, "employees"), ConstraintOp.IS_NULL); q1.setConstraint(c); return q1; }
public static Query objectStoreBag() throws Exception { ObjectStoreBag osb = new ObjectStoreBag(5); Query q = new Query(); QueryClass qc = new QueryClass(Employee.class); q.addFrom(qc); q.addToSelect(qc); q.setDistinct(false); q.setConstraint(new BagConstraint(qc, ConstraintOp.IN, osb)); return q; }
public static Query typeCast() throws Exception { Query q = new Query(); QueryClass qc = new QueryClass(Employee.class); q.addFrom(qc); QueryField f = new QueryField(qc, "age"); QueryCast c = new QueryCast(f, String.class); q.addToSelect(c); return q; }
public static Query constrainClass1() 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 SimpleConstraint(qf, ConstraintOp.EQUALS, new QueryValue(Employee.class))); q.setDistinct(false); return q; }
public static Query rangeOverlapsValues() throws Exception { Query q = new Query(); QueryClass qc1 = new QueryClass(Range.class); q.addFrom(qc1); q.addToSelect(new QueryField(qc1, "id")); OverlapRange r1 = new OverlapRange(new QueryField(qc1, "rangeStart"), new QueryField(qc1, "rangeEnd"), new QueryObjectReference(qc1, "parent")); OverlapRange r2 = new OverlapRange(new QueryValue(35), new QueryValue(45), new QueryObjectReference(qc1, "parent")); q.setConstraint(new OverlapConstraint(r1, ConstraintOp.OVERLAPS, r2)); q.setDistinct(false); return q; }
public static Query lower() 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(QueryExpression.LOWER, f); q.addToSelect(e); return q; }
public static Query collectionPathExpression5() throws Exception { Query q = new Query(); QueryClass qc = new QueryClass(Company.class); q.addFrom(qc); q.addToSelect(qc); QueryCollectionPathExpression qcpe = new QueryCollectionPathExpression(qc, "departments"); qcpe.setConstraint(new SimpleConstraint(new QueryField(qcpe.getDefaultClass(), "name"), ConstraintOp.MATCHES, new QueryValue("%1"))); q.addToSelect(qcpe); q.setDistinct(false); return q; }
public static Query selectClassFromInterMineObject() throws Exception { Query q = new Query(); QueryClass qc = new QueryClass(InterMineObject.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 containsConstraintNullCollectionMN() throws Exception { Query q1 = new Query(); QueryClass qc = new QueryClass(Company.class); q1.addFrom(qc); q1.addToSelect(qc); ContainsConstraint c = new ContainsConstraint( new QueryCollectionReference(qc, "contractors"), ConstraintOp.IS_NULL); q1.setConstraint(c); return q1; }
public static Query whereEqualString() throws Exception { QueryClass c1 = new QueryClass(Company.class); QueryValue v1 = new QueryValue("CompanyA"); QueryField f1 = new QueryField(c1, "name"); SimpleConstraint sc1 = new SimpleConstraint(f1, ConstraintOp.EQUALS, v1); Query q1 = new Query(); q1.addFrom(c1); q1.addToSelect(f1); q1.setConstraint(sc1); return q1; }
public static Query upper() 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(QueryExpression.UPPER, f); q.addToSelect(e); return q; }
public static Query selectClassFromEmployee() throws Exception { Query q = new Query(); QueryClass qc = new QueryClass(Employee.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 simpleConstraintNotNull() 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_NOT_NULL); q1.setConstraint(c); return q1; }