public void testInvalidOp() { QueryValue arg1 = new QueryValue(new Integer(3)); QueryValue arg2 = new QueryValue(new Integer(4)); try { expression = new QueryExpression(arg1, QueryExpression.SUBSTRING, arg2); fail("A ClassCastException should have been thrown"); } catch (ClassCastException e) { } }
public void testSelectQueryExpressionGreatestLeast() throws Exception { QueryValue v1 = new QueryValue(new Integer(5)); QueryValue v2 = new QueryValue(new Integer(7)); QueryExpression e1 = new QueryExpression(v1, QueryExpression.GREATEST, v2); QueryExpression e2 = new QueryExpression(v1, QueryExpression.LEAST, v2); StringBuffer buffer = new StringBuffer(); SqlGenerator.State state = new SqlGenerator.State(); SqlGenerator.queryEvaluableToString(buffer, e1, null, state); buffer.append(", "); SqlGenerator.queryEvaluableToString(buffer, e2, null, state); assertEquals("GREATEST(5,7), LEAST(5,7)", buffer.toString()); }
public void testValidOp() { QueryValue arg1 = new QueryValue(new Integer(3)); QueryValue arg2 = new QueryValue(new Integer(4)); expression = new QueryExpression(arg1, QueryExpression.ADD, arg2); assertTrue(Number.class.isAssignableFrom(expression.getType())); } }
public void testAddString() { QueryValue arg1 = new QueryValue(new Integer(3)); QueryValue arg2 = new QueryValue("string"); try { expression = new QueryExpression(arg1, QueryExpression.ADD, arg2); fail("An ClassCastException should have been thrown"); } catch (ClassCastException e) { } }
public void testSelectQuerySubstringExpression() throws Exception { QueryValue v1 = new QueryValue("Hello"); QueryValue v2 = new QueryValue(new Integer(3)); QueryValue v3 = new QueryValue(new Integer(5)); QueryExpression e1 = new QueryExpression(v1, v2, v3); StringBuffer buffer = new StringBuffer(); SqlGenerator.State state = new SqlGenerator.State(); SqlGenerator.queryEvaluableToString(buffer, e1, null, state); assertEquals("SUBSTR('Hello', 3, 5)", buffer.toString()); }
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 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 substring() 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, new QueryValue(new Integer(2)), new QueryValue(new Integer(2))); q.addToSelect(e); return q; }
public static Query substring() 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, new QueryValue(new Integer(2)), 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 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 lowerBag() throws Exception { Query q = new Query(); QueryClass qc = new QueryClass(Employee.class); q.addFrom(qc); q.addToSelect(qc); q.setDistinct(false); q.setConstraint(new BagConstraint(new QueryExpression(QueryExpression.LOWER, new QueryField(qc, "name")), ConstraintOp.IN, Arrays.asList(new String[]{"employeea1", "employeea2", "employeeb1"}))); 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 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 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 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 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 greatest() throws Exception { Query q = new Query(); q.setDistinct(false); QueryClass qc = new QueryClass(Company.class); q.addFrom(qc); QueryField f = new QueryField(qc, "vatNumber"); QueryExpression e = new QueryExpression(new QueryValue(2000), QueryExpression.GREATEST, f); q.addToSelect(e); return q; }
public static Query least() throws Exception { Query q = new Query(); q.setDistinct(false); QueryClass qc = new QueryClass(Company.class); q.addFrom(qc); QueryField f = new QueryField(qc, "vatNumber"); QueryExpression e = new QueryExpression(new QueryValue(2000), QueryExpression.LEAST, f); q.addToSelect(e); return q; }
public static Query greatest() throws Exception { Query q = new Query(); q.setDistinct(false); QueryClass qc = new QueryClass(Company.class); q.addFrom(qc); QueryField f = new QueryField(qc, "vatNumber"); QueryExpression e = new QueryExpression(new QueryValue(2000), QueryExpression.GREATEST, f); q.addToSelect(e); return q; }