Package org.teiid.language

Examples of org.teiid.language.Function

63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
    if (supportedTypes.contains(type)) {
      modify(function);
      return null;
    }
    //x % y => x - sign(x) * floor(abs(x / y)) * y
    Function divide = langFactory.createFunction(SourceSystemFunctions.DIVIDE_OP, new ArrayList<Expression>(expressions), type);

    Function abs = langFactory.createFunction(SourceSystemFunctions.ABS, Arrays.asList(divide), type);
   
    Function floor = langFactory.createFunction(SourceSystemFunctions.FLOOR, Arrays.asList(abs), type);
   
    Function sign = langFactory.createFunction(SourceSystemFunctions.SIGN, Arrays.asList(expressions.get(0)), type);
   
    List<? extends Expression> multArgs = Arrays.asList(sign, floor, langFactory.createFunction(SourceSystemFunctions.ABS, Arrays.asList(expressions.get(1)), type));
    Function mult = langFactory.createFunction(SourceSystemFunctions.MULTIPLY_OP, multArgs, type);

    List<Expression> minusArgs = Arrays.asList(expressions.get(0), mult);
   
    return Arrays.asList(langFactory.createFunction(SourceSystemFunctions.SUBTRACT_OP, minusArgs, type));
  }
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
    public LanguageObject example1() {
        NamedTable g = new NamedTable("g1", null, null); //$NON-NLS-1$
        List symbols = new ArrayList();       
        symbols.add(new ColumnReference(g, "e1", null, String.class)); //$NON-NLS-1$
        Function function = new Function("length", Arrays.asList(new ColumnReference(g, "e2", null, String.class)), Integer.class); //$NON-NLS-1$ //$NON-NLS-2$
        symbols.add(function);
        List groups = new ArrayList();
        groups.add(g);
        Select q = new Select(symbols, false, groups, null, null, null, null);
            
View Full Code Here
47
48
49
50
51
52
53
54
55
56
57
    public TestMonthOrDayNameFunctionModifier(String name) {
        super(name);
    }

    public void helpTestMod(Literal c, String format, String expectedStr) throws Exception {
        Function func = LANG_FACTORY.createFunction(format.toLowerCase()+"name",  // "monthname" //$NON-NLS-1$
            Arrays.asList( c ),
            String.class);
       
        OracleExecutionFactory trans = new OracleExecutionFactory();
        trans.start();
View Full Code Here
165
166
167
168
169
170
171
172
173
   
    @Test public void testVisitConvertFunctionOracleStyle() throws Exception {
        String expected = "convert(columnA, integer)"; //$NON-NLS-1$
       
        List<? extends Expression> params = Arrays.asList(new ColumnReference(null, "columnA", null, String.class), new Literal("integer", String.class));
        Function test = new Function("convert", params, Integer.class); //$NON-NLS-1$
       
        assertEquals(expected, getString(test));
    }
View Full Code Here
102
103
104
105
106
107
108
109
110
111
112
        registerFunctionModifier(SourceSystemFunctions.DIVIDE_OP, new FunctionModifier() {
     
      @Override
      public List<?> translate(Function function) {
        if (function.getType() == TypeFacility.RUNTIME_TYPES.INTEGER || function.getType() == TypeFacility.RUNTIME_TYPES.LONG) {
          Function result = ConvertModifier.createConvertFunction(getLanguageFactory(), function, TypeFacility.getDataTypeName(function.getType()));
          function.setType(TypeFacility.RUNTIME_TYPES.BIG_DECIMAL);
          return Arrays.asList(result);
        }
        return null;
      }
View Full Code Here
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
    if (tgtType.equals(String.class) && (expr instanceof Literal)) {
      return Arrays.asList(expr); 
    }
    else if (tgtType.equals(String.class) && (expr instanceof Function)) {
     
      Function func = (Function)expr;
      if (func.getParameters().get(0) instanceof ColumnReference) {
        ColumnReference ref = (ColumnReference)func.getParameters().get(0);
        if(Number.class.isAssignableFrom(ref.getType())) {
          ArrayList target = new ArrayList();
          target.add("cast("); //$NON-NLS-1$
          target.add(func.getParameters().get(0));
          target.add(" AS varchar(100))"); //$NON-NLS-1$
        }
        else {
          return modifier.translate(func);
        }
View Full Code Here
59
60
61
62
63
64
65
66
67
68
69
       
        return sqlVisitor.toString();       
    }

    public void helpTest(Expression srcExpression, String tgtType, String expectedExpression) throws Exception {
        Function func = LANG_FACTORY.createFunction("convert",  //$NON-NLS-1$
            Arrays.asList(
                srcExpression,
                LANG_FACTORY.createLiteral(tgtType, String.class)),
            TypeFacility.getDataTypeClass(tgtType));
       
View Full Code Here
50
51
52
53
54
55
56
57
58
59
60
       
        return sqlVisitor.toString();       
    }

    public void helpTest(Expression srcExpression, String tgtType, String expectedExpression) throws Exception {
        Function func = LANG_FACTORY.createFunction("convert",  //$NON-NLS-1$
            Arrays.asList(
                srcExpression,
                LANG_FACTORY.createLiteral(tgtType, String.class)),
            TypeFacility.getDataTypeClass(tgtType));
       
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
       
        return sqlVisitor.toString();       
    }

    public void helpTest(Expression srcExpression, String tgtType, String expectedExpression) throws Exception {
        Function func = LANG_FACTORY.createFunction("convert",  //$NON-NLS-1$
            Arrays.asList(
                srcExpression,
                LANG_FACTORY.createLiteral(tgtType, String.class)),
            TypeFacility.getDataTypeClass(tgtType));
       
View Full Code Here
507
508
509
510
511
512
513
514
515
516
517
518
519
     * @return list of translated parts
     */
    public List<?> translate(LanguageObject obj, ExecutionContext context) {
    List<?> parts = null;
      if (obj instanceof Function) {
        Function function = (Function)obj;
        if (functionModifiers != null) {
          FunctionModifier modifier = functionModifiers.get(function.getName().toLowerCase());
          if (modifier != null) {
            parts = modifier.translate(function);
          }
        }
      } else if (obj instanceof Command) {
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.