/** * Sets the operands and operator. The clause is of the form: <variable> <operator> <value>. * * @param leftExpression The left expression * @param operator The operator representing how the expressions are compared * @param rightExpression The right expression */ public void set( Expression leftExpression, int operator, Expression rightExpression ) { setLeftExpression(leftExpression); setOperator(operator); setRightExpression(rightExpression); }
public ImmutableCompareCriteria(Expression leftExpression, int operator, Expression rightExpression) { super.setLeftExpression(leftExpression); super.setOperator(operator); super.setRightExpression(rightExpression); }
/** * Sets the operands and operator. The clause is of the form: <variable> <operator> <value>. * * @param leftExpression The left expression * @param operator The operator representing how the expressions are compared * @param rightExpression The right expression */ public void set( Expression leftExpression, int operator, Expression rightExpression ) { setLeftExpression(leftExpression); setOperator(operator); setRightExpression(rightExpression); }
public ImmutableCompareCriteria(Expression leftExpression, int operator, Expression rightExpression) { super.setLeftExpression(leftExpression); super.setOperator(operator); super.setRightExpression(rightExpression); }
public ImmutableCompareCriteria(Expression leftExpression, int operator, Expression rightExpression) { super.setLeftExpression(leftExpression); super.setOperator(operator); super.setRightExpression(rightExpression); }
/** * Sets the operands and operator. The clause is of the form: <variable> <operator> <value>. * * @param leftExpression The left expression * @param operator The operator representing how the expressions are compared * @param rightExpression The right expression */ public void set( Expression leftExpression, int operator, Expression rightExpression ) { setLeftExpression(leftExpression); setOperator(operator); setRightExpression(rightExpression); }
final public CompareCriteria compareCrit(ParseInfo info, Expression expression) throws ParseException { Expression value = null; Token operator = null; operator = operator(); value = commonValueExpression(info); CompareCriteria compareCriteria = new CompareCriteria(); // Set left expression compareCriteria.setLeftExpression(expression); compareCriteria.setOperator(getOperator(operator.image)); // Set value compareCriteria.setRightExpression(value); {if (true) return compareCriteria;} throw new Error("Missing return statement in function"); }
/** * @see org.teiid.query.sql.LanguageVisitor#visit(CompareCriteria) */ public void visit(CompareCriteria obj) { obj.setLeftExpression( replaceExpression(obj.getLeftExpression()) ); obj.setRightExpression( replaceExpression(obj.getRightExpression()) ); }
final public CompareCriteria compareCrit(ParseInfo info, Expression expression) throws ParseException { Expression value = null; Token operator = null; operator = operator(); value = commonValueExpression(info); CompareCriteria compareCriteria = new CompareCriteria(); // Set left expression compareCriteria.setLeftExpression(expression); compareCriteria.setOperator(getOperator(operator.image)); // Set value compareCriteria.setRightExpression(value); {if (true) return compareCriteria;} throw new Error("Missing return statement in function"); }
/** * @see org.teiid.query.sql.LanguageVisitor#visit(CompareCriteria) */ public void visit(CompareCriteria obj) { obj.setLeftExpression( replaceExpression(obj.getLeftExpression()) ); obj.setRightExpression( replaceExpression(obj.getRightExpression()) ); }
final public CompareCriteria compareCrit(ParseInfo info, Expression expression) throws ParseException { Expression value = null; Token operator = null; operator = operator(); value = commonValueExpression(info); CompareCriteria compareCriteria = new CompareCriteria(); // Set left expression compareCriteria.setLeftExpression(expression); compareCriteria.setOperator(getOperator(operator.image)); // Set value compareCriteria.setRightExpression(value); {if (true) return compareCriteria;} throw new Error("Missing return statement in function"); }
/** * @see org.teiid.query.sql.LanguageVisitor#visit(CompareCriteria) */ public void visit(CompareCriteria obj) { obj.setLeftExpression( replaceExpression(obj.getLeftExpression()) ); obj.setRightExpression( replaceExpression(obj.getRightExpression()) ); }
@Test public void testRewriteCase1954b() throws Exception{ QueryMetadataInterface metadata = RealMetadataFactory.example1Cached(); CompareCriteria expected = new CompareCriteria(); ElementSymbol leftElement = new ElementSymbol("pm1.g1.e4"); //$NON-NLS-1$ Constant constant = new Constant(new Double(3.0), DataTypeManager.DefaultDataClasses.DOUBLE); expected.setLeftExpression(leftElement); expected.setRightExpression(constant); // resolve against metadata QueryResolver.resolveCriteria(expected, metadata); helpTestRewriteCriteria("convert(pm1.g1.e4, string) = '3.0'", expected, metadata); //$NON-NLS-1$ }
@Test public void testCriteria1() { CompareCriteria expected = new CompareCriteria(); ElementSymbol es = new ElementSymbol("pm1.g1.e1"); //$NON-NLS-1$ GroupSymbol gs = new GroupSymbol("pm1.g1"); //$NON-NLS-1$ es.setGroupSymbol(gs); expected.setLeftExpression(es); expected.setOperator(CompareCriteria.EQ); expected.setRightExpression(new Constant("abc")); //$NON-NLS-1$ Criteria actual = helpResolveCriteria("pm1.g1.e1 = 'abc'"); //$NON-NLS-1$ assertEquals("Did not match expected criteria", expected, actual); //$NON-NLS-1$ }
public static SubqueryFromClause example2() { Query query = new Query(); Select select = new Select(); select.addSymbol(new ElementSymbol("c")); //$NON-NLS-1$ select.addSymbol(new ElementSymbol("d")); //$NON-NLS-1$ query.setSelect(select); From from = new From(); from.addGroup(new GroupSymbol("m.g2")); //$NON-NLS-1$ query.setFrom(from); CompareCriteria crit = new CompareCriteria(); crit.setLeftExpression(new ElementSymbol("c")); //$NON-NLS-1$ crit.setRightExpression(new Constant(new Integer(10))); crit.setOperator(CompareCriteria.EQ); query.setCriteria(crit); return new SubqueryFromClause("temp", query); //$NON-NLS-1$ }
public static SubqueryFromClause example3() { Query query = new Query(); Select select = new Select(); select.addSymbol(new ElementSymbol("a")); //$NON-NLS-1$ select.addSymbol(new ElementSymbol("b")); //$NON-NLS-1$ query.setSelect(select); From from = new From(); from.addGroup(new GroupSymbol("m.g")); //$NON-NLS-1$ query.setFrom(from); CompareCriteria crit = new CompareCriteria(); crit.setLeftExpression(new ElementSymbol("a")); //$NON-NLS-1$ crit.setRightExpression(new Constant(new Integer(5))); crit.setOperator(CompareCriteria.EQ); query.setCriteria(crit); return new SubqueryFromClause("temp2", query); //$NON-NLS-1$ }
public static SubqueryFromClause example1() { Query query = new Query(); Select select = new Select(); select.addSymbol(new ElementSymbol("a")); //$NON-NLS-1$ select.addSymbol(new ElementSymbol("b")); //$NON-NLS-1$ query.setSelect(select); From from = new From(); from.addGroup(new GroupSymbol("m.g")); //$NON-NLS-1$ query.setFrom(from); CompareCriteria crit = new CompareCriteria(); crit.setLeftExpression(new ElementSymbol("a")); //$NON-NLS-1$ crit.setRightExpression(new Constant(new Integer(5))); crit.setOperator(CompareCriteria.EQ); query.setCriteria(crit); return new SubqueryFromClause("temp", query); //$NON-NLS-1$ }
public static SubquerySetCriteria example1() { Query query = new Query(); Select select = new Select(); select.addSymbol(new ElementSymbol("a")); //$NON-NLS-1$ select.addSymbol(new ElementSymbol("b")); //$NON-NLS-1$ query.setSelect(select); From from = new From(); from.addGroup(new GroupSymbol("m.g")); //$NON-NLS-1$ query.setFrom(from); CompareCriteria crit = new CompareCriteria(); crit.setLeftExpression(new ElementSymbol("a")); //$NON-NLS-1$ crit.setRightExpression(new Constant(new Integer(5))); crit.setOperator(CompareCriteria.EQ); query.setCriteria(crit); return new SubquerySetCriteria(new ElementSymbol("temp"), query); //$NON-NLS-1$ }
public static SubquerySetCriteria example3() { Query query = new Query(); Select select = new Select(); select.addSymbol(new ElementSymbol("a")); //$NON-NLS-1$ select.addSymbol(new ElementSymbol("b")); //$NON-NLS-1$ query.setSelect(select); From from = new From(); from.addGroup(new GroupSymbol("m.g")); //$NON-NLS-1$ query.setFrom(from); CompareCriteria crit = new CompareCriteria(); crit.setLeftExpression(new ElementSymbol("a")); //$NON-NLS-1$ crit.setRightExpression(new Constant(new Integer(5))); crit.setOperator(CompareCriteria.EQ); query.setCriteria(crit); return new SubquerySetCriteria(new ElementSymbol("temp2"), query); //$NON-NLS-1$ }
@Test public void testNestedComparison() { CompareCriteria cc = new CompareCriteria( new ElementSymbol("m.g.c1"), //$NON-NLS-1$ CompareCriteria.EQ, new Constant("abc") ); //$NON-NLS-1$ CompareCriteria cc1 = new CompareCriteria( cc, //$NON-NLS-1$ CompareCriteria.EQ, new Constant(false) ); //$NON-NLS-1$ helpTest(cc1, "(m.g.c1 = 'abc') = FALSE"); //$NON-NLS-1$ cc1.setLeftExpression(new CompoundCriteria(Arrays.asList(cc, new CompareCriteria( new ElementSymbol("m.g.c2"), //$NON-NLS-1$ CompareCriteria.GT, new Constant(1))))); helpTest(cc1, "((m.g.c1 = 'abc') AND (m.g.c2 > 1)) = FALSE"); //$NON-NLS-1$ }