Package org.teiid.language

Examples of org.teiid.language.Function

668
669
670
671
672
673
674
675
676
677
678
       
        helpGetString1(func,  "cast('123' AS real)");  //$NON-NLS-1$
    }
   
    @Test public void testBooleanToFloata() throws Exception {
        Function func = LANG_FACTORY.createFunction("convert", //$NON-NLS-1$
            new Expression[] { LANG_FACTORY.createLiteral(Boolean.TRUE, Boolean.class),
                LANG_FACTORY.createLiteral("float", Float.class)}, //$NON-NLS-1$
            Float.class);

        helpGetString1(func, "cast(1 AS real)"); //$NON-NLS-1$
View Full Code Here
677
678
679
680
681
682
683
684
685
686
687
        helpGetString1(func, "cast(1 AS real)"); //$NON-NLS-1$
    }

    @Test public void testBooleanToFloatb() throws Exception {
        Function func = LANG_FACTORY.createFunction("convert", //$NON-NLS-1$
            new Expression[] { LANG_FACTORY.createLiteral(Boolean.FALSE, Boolean.class),
                LANG_FACTORY.createLiteral("float", Float.class)}, //$NON-NLS-1$
            Float.class);

        helpGetString1(func, "cast(0 AS real)"); //$NON-NLS-1$
View Full Code Here
689
690
691
692
693
694
695
696
697
698
699
   
    /***************** End of cast(float AS input)******************/
   
    /***************** Beginning of cast(double AS input) ************/
    @Test public void testStringToDouble() throws Exception {
        Function func = LANG_FACTORY.createFunction("convert",  //$NON-NLS-1$
            new Expression[] {
                LANG_FACTORY.createLiteral("123", String.class),  //$NON-NLS-1$
                LANG_FACTORY.createLiteral("double", Double.class)}, //$NON-NLS-1$
            Double.class);
       
View Full Code Here
699
700
701
702
703
704
705
706
707
708
709
       
        helpGetString1(func,  "cast('123' AS double precision)");  //$NON-NLS-1$
    }
   
    @Test public void testBooleanToDoublea() throws Exception {
        Function func = LANG_FACTORY.createFunction("convert", //$NON-NLS-1$
            new Expression[] { LANG_FACTORY.createLiteral(Boolean.TRUE, Boolean.class),
                LANG_FACTORY.createLiteral("double", Double.class)}, //$NON-NLS-1$
            Double.class);

        helpGetString1(func, "cast(1 AS double precision)"); //$NON-NLS-1$
View Full Code Here
708
709
710
711
712
713
714
715
716
717
718
        helpGetString1(func, "cast(1 AS double precision)"); //$NON-NLS-1$
    }

    @Test public void testBooleanToDoubleb() throws Exception {
        Function func = LANG_FACTORY.createFunction("convert", //$NON-NLS-1$
            new Expression[] { LANG_FACTORY.createLiteral(Boolean.FALSE, Boolean.class),
                LANG_FACTORY.createLiteral("double", Double.class)}, //$NON-NLS-1$
            Double.class);

        helpGetString1(func, "cast(0 AS double precision)"); //$NON-NLS-1$
View Full Code Here
720
721
722
723
724
725
726
727
728
729
730
   
    /***************** End of cast(double AS input)******************/
   
    /***************** Beginning of cast(bigdecimal AS input) ************/
    @Test public void testStringToBigDecimal() throws Exception {
        Function func = LANG_FACTORY.createFunction("convert",  //$NON-NLS-1$
            new Expression[] {
                LANG_FACTORY.createLiteral("123", String.class),  //$NON-NLS-1$
                LANG_FACTORY.createLiteral("bigdecimal", java.math.BigDecimal.class)}, //$NON-NLS-1$
            java.math.BigDecimal.class);
       
View Full Code Here
730
731
732
733
734
735
736
737
738
739
740
       
        helpGetString1(func,  "cast('123' AS numeric(38, 19))");  //$NON-NLS-1$
    }

    @Test public void testBooleanToBigDecimala() throws Exception {
        Function func = LANG_FACTORY.createFunction("convert", //$NON-NLS-1$
            new Expression[] { LANG_FACTORY.createLiteral(Boolean.TRUE, Boolean.class),
                LANG_FACTORY.createLiteral("bigdecimal", java.math.BigDecimal.class)}, //$NON-NLS-1$
            java.math.BigDecimal.class);

        helpGetString1(func, "cast(1 AS numeric(38, 19))"); //$NON-NLS-1$
View Full Code Here
44
45
46
47
48
49
50
51
52
53
54
    public TestLeftOrRightFunctionModifier(String name) {
        super(name);
    }

    public void helpTestMod(Literal c, Literal d, String target, String expectedStr) throws Exception {
        Function func = LANG_FACTORY.createFunction(target,
            Arrays.asList( c, d ),
            String.class);
       
        OracleExecutionFactory trans = new OracleExecutionFactory();
        trans.start();
View Full Code Here
182
183
184
185
186
187
188
189
190
191
192
193
194
    this.addConvert(FunctionModifier.BOOLEAN, FunctionModifier.STRING, new FunctionModifier() {
      @Override
      public List<?> translate(Function function) {
        Expression booleanValue = function.getParameters().get(0);
        if (booleanValue instanceof Function) {
          Function nested = (Function)booleanValue;
          if (nested.getName().equalsIgnoreCase("convert") && Number.class.isAssignableFrom(nested.getParameters().get(0).getType())) { //$NON-NLS-1$
            booleanValue = nested.getParameters().get(0);
          }
        }
        if (!booleanNullable) {
          return Arrays.asList("CASE WHEN ", booleanValue, " = 0 THEN 'false' ELSE 'true' END"); //$NON-NLS-1$ //$NON-NLS-2$         
        }
View Full Code Here
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
        super(name);
    }

    public void testModifier() {
        Literal arg = LANG_FACTORY.createLiteral(new Double(5.2), Double.class);
        Function func = LANG_FACTORY.createFunction("log10", Arrays.asList(arg), Double.class); //$NON-NLS-1$
       
        Log10FunctionModifier modifier = new Log10FunctionModifier(LANG_FACTORY);
        modifier.translate(func);
       
        assertEquals("log", func.getName()); //$NON-NLS-1$
        assertEquals(Double.class, func.getType());
       
        List<Expression> outArgs = func.getParameters();
        assertEquals(2, outArgs.size());
        assertEquals(arg, outArgs.get(1));
       
        assertTrue(outArgs.get(1) instanceof Literal);
        Literal newArg = (Literal) outArgs.get(0);
View Full Code Here
TOP

Related Classes of org.teiid.language.Function

  • org.teiid.connector.visitor.util.TestCollectorVisitor
  • org.teiid.connector.visitor.util.TestSQLStringVisitor
  • org.teiid.translator.jdbc.ConvertModifier
  • org.teiid.translator.jdbc.db2.SubstringFunctionModifier
  • org.teiid.translator.jdbc.db2.TestDB2ConvertModifier
  • org.teiid.translator.jdbc.ingres.TestIngresConvertModifier
  • org.teiid.translator.jdbc.intersyscache.InterSystemsCacheExecutionFactory
  • org.teiid.translator.jdbc.intersystemscache.TestInterSystemsCacheTranslation
  • org.teiid.translator.jdbc.JDBCExecutionFactory
  • org.teiid.translator.jdbc.modeshape.TestPathFunctionModifier
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.