Package org.teiid.language

Examples of org.teiid.language.Literal

66
67
68
69
70
71
72
73
74
        helpTestMod(arg1, "Month", //$NON-NLS-1$
            "rtrim(TO_CHAR({ts '2004-01-21 10:05:00.01'}, 'Month'))"); //$NON-NLS-1$
    }

    public void test2() throws Exception {
        Literal arg1 = LANG_FACTORY.createLiteral(TimestampUtil.createDate(104, 0, 21), java.sql.Date.class);
        helpTestMod(arg1, "Month", //$NON-NLS-1$
            "rtrim(TO_CHAR({d '2004-01-21'}, 'Month'))"); //$NON-NLS-1$
    }
View Full Code Here
72
73
74
75
76
77
78
79
80
        helpTestMod(arg1, "Month", //$NON-NLS-1$
            "rtrim(TO_CHAR({d '2004-01-21'}, 'Month'))"); //$NON-NLS-1$
    }
   
    public void test3() throws Exception {
        Literal arg1 = LANG_FACTORY.createLiteral(TimestampUtil.createTimestamp(104, 0, 21, 10, 5, 0, 10000000), Timestamp.class);
        helpTestMod(arg1, "Day",  //$NON-NLS-1$
            "rtrim(TO_CHAR({ts '2004-01-21 10:05:00.01'}, 'Day'))"); //$NON-NLS-1$
    }
View Full Code Here
78
79
80
81
82
83
84
85
86
        helpTestMod(arg1, "Day",  //$NON-NLS-1$
            "rtrim(TO_CHAR({ts '2004-01-21 10:05:00.01'}, 'Day'))"); //$NON-NLS-1$
    }

    public void test4() throws Exception {
        Literal arg1 = LANG_FACTORY.createLiteral(TimestampUtil.createDate(104, 0, 21), java.sql.Date.class);
        helpTestMod(arg1, "Day", //$NON-NLS-1$
            "rtrim(TO_CHAR({d '2004-01-21'}, 'Day'))"); //$NON-NLS-1$
    }
View Full Code Here
164
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
109
110
111
112
113
114
115
116
117
118
119
        registerFunctionModifier(SourceSystemFunctions.RIGHT, new LeftOrRightFunctionModifier(getLanguageFactory(), this.convert));
        registerFunctionModifier(SourceSystemFunctions.COT, new FunctionModifier() {
      @Override
      public List<?> translate(Function function) {
        function.setName(SourceSystemFunctions.TAN);
        return Arrays.asList(getLanguageFactory().createFunction(SourceSystemFunctions.DIVIDE_OP, new Expression[] {new Literal(1, TypeFacility.RUNTIME_TYPES.INTEGER), function}, TypeFacility.RUNTIME_TYPES.DOUBLE));
      }
    });       
        registerFunctionModifier(SourceSystemFunctions.LTRIM, new FunctionModifier() {
      @Override
      public List<?> translate(Function function) {
View Full Code Here
121
122
123
124
125
126
127
128
129
130
131
        registerFunctionModifier(SourceSystemFunctions.ARRAY_LENGTH, new FunctionModifier() {
     
      @Override
      public List<?> translate(Function function) {
        if (function.getParameters().size() == 1) {
          function.getParameters().add(new Literal(1, TypeFacility.RUNTIME_TYPES.INTEGER));
        }
        return null;
      }
    });
               
View Full Code Here
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
        }
    }

  private Expression ensurePositiveStartIndex(Expression startIndex) {
    if (startIndex instanceof Literal) {
      Literal literal = (Literal)startIndex; 
      if (literal.getValue() instanceof Integer && ((Integer)literal.getValue() < 1)) {
        literal.setValue(1);
      }
    } else {
      Comparison whenExpr = langFactory.createCompareCriteria(
          Operator.LT,
          startIndex,
          langFactory.createLiteral(1, Integer.class)
        );
      Literal thenExpr = langFactory.createLiteral(1, Integer.class);
      startIndex = langFactory.createSearchedCaseExpression(Arrays.asList(langFactory.createSearchedWhenCondition(whenExpr, thenExpr)), startIndex, TypeFacility.RUNTIME_TYPES.INTEGER);
    }
    return startIndex;
  }
View Full Code Here
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
    protected void bindPreparedStatementValues(PreparedStatement stmt, TranslatedCommand tc, int rowCount) throws SQLException {
        List<?> params = tc.getPreparedValues();

        for (int row = 0; row < rowCount; row++) {
          for (int i = 0; i< params.size(); i++) {
              Literal paramValue = (Literal)params.get(i);
              Object value = paramValue.getValue();
              if (paramValue.isMultiValued()) {
                value = ((List<?>)value).get(row);
              }
              Class<?> paramType = paramValue.getType();
              this.executionFactory.bindValue(stmt, value, paramType, i+1);
          }
          if (rowCount > 1) {
              stmt.addBatch();
            }
View Full Code Here
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
public class TestJDBCUpdateExecution {

  @Test public void testBulkUpdate() throws Exception {
    Command command = TranslationHelper.helpTranslate(TranslationHelper.BQT_VDB, "insert into BQT1.SmallA (IntKey, IntNum) values (1, 2)"); //$NON-NLS-1$
    Literal value = ((Literal)((ExpressionValueSource)((Insert)command).getValueSource()).getValues().get(0));
    Literal value1 = ((Literal)((ExpressionValueSource)((Insert)command).getValueSource()).getValues().get(1));
    value.setMultiValued(true);
    value.setBindValue(true);
    value.setValue(Arrays.asList(1, 2));
    value1.setMultiValued(true);
    value1.setBindValue(true);
    value1.setValue(Arrays.asList(2, 3));
    Connection connection = Mockito.mock(Connection.class);
    PreparedStatement p = Mockito.mock(PreparedStatement.class);
    Mockito.stub(p.executeBatch()).toReturn(new int [] {1, 1});
    Mockito.stub(connection.prepareStatement("INSERT INTO SmallA (IntKey, IntNum) VALUES (?, ?)")).toReturn(p); //$NON-NLS-1$
   
View Full Code Here
47
48
49
50
51
52
53
        return new Constant(val);
    }
   
    public static Literal example(int val) {
        Constant c = helpExample(val);
        return new Literal(c.getValue(), c.getType());
    }
View Full Code Here
TOP

Related Classes of org.teiid.language.Literal

  • org.teiid.connector.visitor.util.TestSQLStringVisitor
  • org.teiid.dqp.internal.datamgr.LanguageBridgeFactory
  • org.teiid.dqp.internal.datamgr.TestLiteralImpl
  • org.teiid.dqp.internal.datamgr.TestSelectSymbolImpl
  • org.teiid.translator.file.TestFileExecutionFactory
  • org.teiid.translator.jdbc.db2.DB2ExecutionFactory
  • org.teiid.translator.jdbc.db2.SubstringFunctionModifier
  • org.teiid.translator.jdbc.hsql.AddDiffModifier
  • org.teiid.translator.jdbc.JDBCBaseExecution
  • org.teiid.translator.jdbc.JDBCUpdateExecution
    • 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.