Examples of org.teiid.query.sql.symbol.Constant

org.teiid.query.sql.symbol.Constant
This class represents a literal value in a SQL string. The Constant object has a value and a type for that value. In many cases, the type can be derived from the type of the value, but that is not true if the value is null. In that case, the type is unknown and is set to the null type until the type is resolved at a later point.

    /**
     * Test ensures that '22.0' is a valid long via bigdecimal
     */
    @Test public void testRewriteBigDecimal() {
      String original = "convert(BQT1.SmallA.LongNum, bigdecimal) = '22.0'"; //$NON-NLS-1$
      CompareCriteria crit = new CompareCriteria(new ElementSymbol("BQT1.SmallA.LongNum"), CompareCriteria.EQ, new Constant(new Long(22))); //$NON-NLS-1$
      helpTestRewriteCriteria(original, crit, FakeMetadataFactory.exampleBQTCached()); 
    }

View Full Code Here

    
    public static List getWhenExpressions(int expressions, int nullIndex, boolean includeNull) {
        ArrayList list = new ArrayList();
        for (int i = 0; i < expressions; i++) {
            if(includeNull && i == nullIndex) {
                list.add(new Constant(null) );
            }else {
                list.add(new Constant(String.valueOf((char)('a' + i))));
            }
        }
        return list;
    }

View Full Code Here

    }
    
    public static List getThenExpressions(int expressions) {
        ArrayList list = new ArrayList();
        for (int i = 0; i < expressions; i++) {
            list.add(new Constant(new Integer(i)));
        }
        return list;
    }

View Full Code Here

    }


    public static CaseExpression example(int whens) {
        ElementSymbol x = new ElementSymbol("x"); //$NON-NLS-1$
        CaseExpression caseExpr = new CaseExpression(x, getWhenExpressions(whens), getThenExpressions(whens));
        caseExpr.setElseExpression(new Constant(new Integer(9999)));
        return caseExpr;
    }

View Full Code Here

    
    public static CaseExpression example(int whens, int nullIndex, boolean includeNull) {
        ArgCheck.isTrue(nullIndex < whens, "Null Index must be less than the number of When expressions"); //$NON-NLS-1$
        ElementSymbol x = new ElementSymbol("x"); //$NON-NLS-1$
        CaseExpression caseExpr = new CaseExpression(x, getWhenExpressions(whens, nullIndex, includeNull), getThenExpressions(whens));
        caseExpr.setElseExpression(new Constant(new Integer(9999)));
        return caseExpr;
    }

View Full Code Here

    }
    
    public static void helpTestWhenExpressions(CaseExpression caseExpr, int expectedWhens) {
        assertEquals(expectedWhens, caseExpr.getWhenCount());
        for (int i = 0; i < expectedWhens; i++) {
            assertEquals(new Constant(String.valueOf((char)('a' + i))), caseExpr.getWhenExpression(i));
        }
    }

View Full Code Here

    }


    public static void helpTestThenExpressions(AbstractCaseExpression caseExpr, int expectedThens) {
        assertEquals(expectedThens, caseExpr.getWhenCount());
        for (int i = 0; i < expectedThens; i++) {
            assertEquals(new Constant(new Integer(i)), caseExpr.getThenExpression(i));
        }
    }

View Full Code Here

    /*
     * Test for Object clone()
     */
    public void testClone() {
        ElementSymbol x = new ElementSymbol("x"); //$NON-NLS-1$
        Expression e1 = new Constant("abc"); //$NON-NLS-1$
        Expression e2 = new Constant("xyz"); //$NON-NLS-1$
        ArrayList whens = new ArrayList();
        whens.add(e1);
        whens.add(e2);
        Constant const1 = new Constant("a"); //$NON-NLS-1$
        Constant const2 = new Constant("b"); //$NON-NLS-1$
        ArrayList thens = new ArrayList();
        thens.add(const1);
        thens.add(const2);
        Expression elseExpression = new Constant("c"); //$NON-NLS-1$
        CaseExpression expr = new CaseExpression(x, whens, thens);
        expr.setElseExpression(elseExpression);
        expr.setType(DataTypeManager.DefaultDataClasses.STRING);
        
        CaseExpression clone = (CaseExpression)expr.clone();

View Full Code Here

            helpTestThenExpressions(caseExpr, 4);
        }
        caseExpr.setWhen(TestSearchedCaseExpression.getWhenCriteria(3), getThenExpressions(3));
        caseExpr.setWhen(getWhenExpressions(3), TestSearchedCaseExpression.getWhenCriteria(3));
        ArrayList whens = new ArrayList();
        whens.add(new Constant("abc")); //$NON-NLS-1$
        whens.add(new Constant("xyz")); //$NON-NLS-1$
        ArrayList thens = new ArrayList();
        thens.add(new Constant(new Integer(20000)));
        thens.add(new Constant(new Integer(30000)));
        caseExpr.setWhen(whens, thens);
        assertEquals(2, caseExpr.getWhenCount());
        assertEquals(new Constant("abc"), caseExpr.getWhenExpression(0)); //$NON-NLS-1$
        assertEquals(new Constant("xyz"), caseExpr.getWhenExpression(1)); //$NON-NLS-1$
        assertEquals(new Constant(new Integer(20000)), caseExpr.getThenExpression(0));
        assertEquals(new Constant(new Integer(30000)), caseExpr.getThenExpression(1));
    }

View Full Code Here

        helpTestThenExpressions(example(3), 3);
    }


    public void testGetElseExpression() {
        CaseExpression expr = example(3);
        assertEquals(new Constant(new Integer(9999)), expr.getElseExpression());
    }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.teiid.query.sql.symbol.Constant

org.teiid.dqp.internal.datamgr.TestAggregateImpl

org.teiid.dqp.internal.datamgr.TestCompareCriteriaImpl

org.teiid.dqp.internal.datamgr.TestConnectorWorkItem

org.teiid.dqp.internal.datamgr.TestFunctionImpl

org.teiid.dqp.internal.datamgr.TestLikeCriteriaImpl

org.teiid.dqp.internal.datamgr.TestLiteralImpl

org.teiid.dqp.internal.datamgr.TestSearchedCaseExpressionImpl

org.teiid.dqp.internal.datamgr.TestUpdateImpl

org.teiid.dqp.internal.process.DataTierManagerImpl

org.teiid.dqp.internal.process.multisource.MultiSourceElementReplacementVisitor

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.