public void testDualWrongTypeNumber() throws Exception { try { constraint = new SimpleConstraint(qeNum1, ConstraintOp.MATCHES, qeNum1); fail ("Expected: IllegalArgumentException"); } catch (IllegalArgumentException e) { } try { constraint = new SimpleConstraint(qeNum1, ConstraintOp.DOES_NOT_MATCH, qeNum1); fail ("Expected: IllegalArgumentException"); } catch (IllegalArgumentException e) { } }
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)); } }
@Override public Constraint createConstraint(Queryable q, QueryNode node, PathConstraintRange con) { return new SimpleConstraint(new QueryValue("Foo"), ConstraintOp.EQUALS, new QueryValue("Bar")); } }
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; }
/** Expect Underscores to not be escaped in LIKE queries **/ public void testQueryValueUnderscoreInMatch() throws Exception { QueryValue right = new QueryValue("%Hello_World"); QueryValue left = new QueryValue("Hello-World"); SimpleConstraint con = new SimpleConstraint(left, ConstraintOp.MATCHES, right); SqlGenerator.State state = new SqlGenerator.State(); StringBuffer buffer = state.getWhereBuffer(); SqlGenerator.simpleConstraintToString(state, buffer, con, null); assertEquals("'Hello-World' LIKE '%Hello_World'", buffer.toString()); }
/** Expect Underscores to not be escaped in LIKE queries **/ public void testQueryValueEscapedOpsInMatch() throws Exception { QueryValue right = new QueryValue("\\%Hello_Under\\_Score%"); QueryValue left = new QueryValue("%Hello-Under_Score!"); SimpleConstraint con = new SimpleConstraint(left, ConstraintOp.MATCHES, right); SqlGenerator.State state = new SqlGenerator.State(); StringBuffer buffer = state.getWhereBuffer(); SqlGenerator.simpleConstraintToString(state, buffer, con, null); String expected = "'%Hello-Under_Score!' LIKE E'\\\\%Hello_Under\\\\_Score%'"; assertEquals(expected, buffer.toString()); }
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; }
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 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 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 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 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; }
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; }
@Test public void testSanity() { Query q = new Query(); QueryClass cls = new QueryClass(Department.class); q.addFrom(cls); q.addToSelect(cls); q.setConstraint(new SimpleConstraint(new QueryField(cls, "name"), ConstraintOp.MATCHES, new QueryValue("temp-%"))); doSanityTest(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()); }
@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); }