public static Query dynamicClassInterface() throws Exception { Set classes = new HashSet(); classes.add(Broke.class); classes.add(Employable.class); QueryClass qc1 = new QueryClass(classes); Query q1 = new Query(); q1.addFrom(qc1); q1.addToSelect(qc1); return q1; }
public static Query selectInterfaceAndSubClasses3() throws Exception { QueryClass qc1 = new QueryClass(ImportantPerson.class); Query q1 = new Query(); q1.addToSelect(qc1); q1.addFrom(qc1); return q1; }
public static Query whereClassClass() throws Exception { QueryClass qc1 = new QueryClass(Company.class); QueryClass qc2 = new QueryClass(Company.class); ClassConstraint cc1 = new ClassConstraint(qc1, ConstraintOp.EQUALS, qc2); Query q1 = new Query(); q1.addFrom(qc1); q1.addFrom(qc2); q1.addToSelect(qc1); q1.addToSelect(qc2); q1.setConstraint(cc1); return q1; }
public static Query whereNotClassClass() throws Exception { QueryClass qc1 = new QueryClass(Company.class); QueryClass qc2 = new QueryClass(Company.class); ClassConstraint cc1 = new ClassConstraint(qc1, ConstraintOp.NOT_EQUALS, qc2); Query q1 = new Query(); q1.addFrom(qc1); q1.addFrom(qc2); q1.addToSelect(qc1); q1.addToSelect(qc2); q1.setConstraint(cc1); return q1; }
public static Query whereSimpleEquals() 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.EQUALS, v1); Query q1 = new Query(); q1.addFrom(c1); q1.addToSelect(f2); q1.setConstraint(sc1); return q1; }
public static Query emptyAndConstraintSet() throws Exception { Query q = new Query(); QueryClass qc = new QueryClass(Company.class); q.addFrom(qc); q.addToSelect(qc); q.setConstraint(new ConstraintSet(ConstraintOp.AND)); return q; }
public static Query emptyOrConstraintSet() throws Exception { Query q = new Query(); QueryClass qc = new QueryClass(Company.class); q.addFrom(qc); q.addToSelect(qc); q.setConstraint(new ConstraintSet(ConstraintOp.OR)); return q; }
public static Query orderByReference() throws Exception { Query q = new Query(); QueryClass qc = new QueryClass(Employee.class); q.addFrom(qc); q.addToSelect(qc); q.addToOrderBy(new QueryObjectReference(qc, "department")); 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 subclassCollection2() throws Exception { Query q = new Query(); QueryClass qc = new QueryClass(Department.class); q.addFrom(qc); q.addToSelect(qc); q.addToSelect(new QueryCollectionPathExpression(qc, "employees", Broke.class, Employee.class)); q.setDistinct(false); return q; }
public static Query orderDescending() throws Exception { Query q = new Query(); q.setDistinct(false); QueryClass qc = new QueryClass(Employee.class); q.addFrom(qc); q.addToSelect(qc); q.addToOrderBy(new OrderDescending(qc)); 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 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 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 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 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 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 objectPathExpression3() throws Exception { Query q = new Query(); QueryClass qc = new QueryClass(Employee.class); q.addFrom(qc); q.addToSelect(qc); QueryObjectPathExpression qope1 = new QueryObjectPathExpression(qc, "department"); qope1.addToSelect(new QueryObjectPathExpression(qope1.getDefaultClass(), "company")); q.addToSelect(qope1); q.setDistinct(false); 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 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; }