public static BetweenCriteria example(String element, int lower, int upper, boolean negated) { BetweenCriteria criteria = new BetweenCriteria(new ElementSymbol(element), new Constant(new Integer(lower)), new Constant(new Integer(upper))); criteria.setNegated(negated); return criteria; }
public void testVisitBetweenCriteria() { BetweenCriteria bc = new BetweenCriteria(exampleElement(true, 0), new Constant(new Integer(1000)), new Constant(new Integer(2000))); helpTest(bc, getSymbolMap()); }
final public BetweenCriteria betweenCrit(ParseInfo info, Expression expression) throws ParseException { Expression lowerExpression = null, upperExpression = null; boolean negated = false; switch ((jj_ntk==-1)?jj_ntk():jj_ntk) { case NOT: jj_consume_token(NOT); negated=true; break; default: jj_la1[215] = jj_gen; ; } jj_consume_token(BETWEEN); lowerExpression = commonValueExpression(info); jj_consume_token(AND); upperExpression = commonValueExpression(info); BetweenCriteria criteria = new BetweenCriteria(expression, lowerExpression, upperExpression); criteria.setNegated(negated); {if (true) return criteria;} throw new Error("Missing return statement in function"); }
@Test public void testBetweenCriteria1() { BetweenCriteria bc = new BetweenCriteria( new ElementSymbol("m.g.c1"), //$NON-NLS-1$ new Constant(new Integer(1000)), new Constant(new Integer(2000)) ); helpTest(bc, "m.g.c1 BETWEEN 1000 AND 2000"); //$NON-NLS-1$ }
final public BetweenCriteria betweenCrit(ParseInfo info, Expression expression) throws ParseException { Expression lowerExpression = null, upperExpression = null; boolean negated = false; switch ((jj_ntk==-1)?jj_ntk():jj_ntk) { case NOT: jj_consume_token(NOT); negated=true; break; default: jj_la1[215] = jj_gen; ; } jj_consume_token(BETWEEN); lowerExpression = commonValueExpression(info); jj_consume_token(AND); upperExpression = commonValueExpression(info); BetweenCriteria criteria = new BetweenCriteria(expression, lowerExpression, upperExpression); criteria.setNegated(negated); {if (true) return criteria;} throw new Error("Missing return statement in function"); }
final public BetweenCriteria betweenCrit(ParseInfo info, Expression expression) throws ParseException { Expression lowerExpression = null, upperExpression = null; boolean negated = false; switch ((jj_ntk==-1)?jj_ntk():jj_ntk) { case NOT: jj_consume_token(NOT); negated=true; break; default: jj_la1[214] = jj_gen; ; } jj_consume_token(BETWEEN); lowerExpression = commonValueExpression(info); jj_consume_token(AND); upperExpression = commonValueExpression(info); BetweenCriteria criteria = new BetweenCriteria(expression, lowerExpression, upperExpression); criteria.setNegated(negated); {if (true) return criteria;} throw new Error("Missing return statement in function"); }
@Test public void testBetweenCriteria2() { BetweenCriteria bc = new BetweenCriteria( new ElementSymbol("m.g.c1"), //$NON-NLS-1$ new Constant(new Integer(1000)), new Constant(new Integer(2000)) ); bc.setNegated(true); helpTest(bc, "m.g.c1 NOT BETWEEN 1000 AND 2000"); //$NON-NLS-1$ }
/** * Deep copy of object * @return Deep copy of object */ public Object clone() { Expression copy = null; Expression lowerCopy = null; Expression upperCopy = null; if(getExpression() != null) { copy = (Expression) getExpression().clone(); } if(getLowerExpression() != null) { lowerCopy = (Expression) getLowerExpression().clone(); } if(getUpperExpression() != null) { upperCopy = (Expression) getUpperExpression().clone(); } BetweenCriteria criteriaCopy = new BetweenCriteria(copy, lowerCopy, upperCopy); criteriaCopy.setNegated(isNegated()); return criteriaCopy; }
/** SELECT a from db.g where a BETWEEN 1000 AND 2000 */ @Test public void testBetween1(){ GroupSymbol g = new GroupSymbol("db.g"); //$NON-NLS-1$ From from = new From(); from.addGroup(g); Select select = new Select(); ElementSymbol a = new ElementSymbol("a"); //$NON-NLS-1$ select.addSymbol(a); Expression constant1 = new Constant(new Integer(1000)); Expression constant2 = new Constant(new Integer(2000)); Criteria crit = new BetweenCriteria(a, constant1, constant2); Query query = new Query(); query.setSelect(select); query.setFrom(from); query.setCriteria(crit); helpTest("SELECT a from db.g where a BETWEEN 1000 AND 2000", //$NON-NLS-1$ "SELECT a FROM db.g WHERE a BETWEEN 1000 AND 2000", //$NON-NLS-1$ query); }
/** * Deep copy of object * @return Deep copy of object */ public Object clone() { Expression copy = null; Expression lowerCopy = null; Expression upperCopy = null; if(getExpression() != null) { copy = (Expression) getExpression().clone(); } if(getLowerExpression() != null) { lowerCopy = (Expression) getLowerExpression().clone(); } if(getUpperExpression() != null) { upperCopy = (Expression) getUpperExpression().clone(); } BetweenCriteria criteriaCopy = new BetweenCriteria(copy, lowerCopy, upperCopy); criteriaCopy.setNegated(isNegated()); return criteriaCopy; }
/** * Deep copy of object * @return Deep copy of object */ public Object clone() { Expression copy = null; Expression lowerCopy = null; Expression upperCopy = null; if(getExpression() != null) { copy = (Expression) getExpression().clone(); } if(getLowerExpression() != null) { lowerCopy = (Expression) getLowerExpression().clone(); } if(getUpperExpression() != null) { upperCopy = (Expression) getUpperExpression().clone(); } BetweenCriteria criteriaCopy = new BetweenCriteria(copy, lowerCopy, upperCopy); criteriaCopy.setNegated(isNegated()); return criteriaCopy; }
/** SELECT a from db.g where a NOT BETWEEN 1000 AND 2000 */ @Test public void testBetween2(){ GroupSymbol g = new GroupSymbol("db.g"); //$NON-NLS-1$ From from = new From(); from.addGroup(g); Select select = new Select(); ElementSymbol a = new ElementSymbol("a"); //$NON-NLS-1$ select.addSymbol(a); Expression constant1 = new Constant(new Integer(1000)); Expression constant2 = new Constant(new Integer(2000)); BetweenCriteria crit = new BetweenCriteria(a, constant1, constant2); crit.setNegated(true); Query query = new Query(); query.setSelect(select); query.setFrom(from); query.setCriteria(crit); helpTest("SELECT a from db.g where a NOT BETWEEN 1000 AND 2000", //$NON-NLS-1$ "SELECT a FROM db.g WHERE a NOT BETWEEN 1000 AND 2000", //$NON-NLS-1$ query); }