Package org.teiid.language

Examples of org.teiid.language.Function

177
178
179
180
181
182
183
184
185
186
187
        helpGetString1(func,  "CASE WHEN 1 = 0 THEN 'false' ELSE 'true' END");  //$NON-NLS-1$
    }
   
    @Test public void testTimestampToString() throws Exception {
        Timestamp ts = TimestampUtil.createTimestamp(103, 10, 1, 12, 5, 2, 0);
        Function func = LANG_FACTORY.createFunction("convert",  //$NON-NLS-1$
            new Expression[] {
                LANG_FACTORY.createLiteral(ts, Timestamp.class),
                LANG_FACTORY.createLiteral("string", String.class)}, //$NON-NLS-1$
            String.class);
View Full Code Here
188
189
190
191
192
193
194
195
196
197
198
        helpGetString1(func,  "stuff(stuff(convert(varchar, CAST('2003-11-01 12:05:02.0' AS DATETIME), 102), 5, 1, '-'), 8, 1, '-')+convert(varchar, CAST('2003-11-01 12:05:02.0' AS DATETIME), 8)");  //$NON-NLS-1$
    }
   
    @Test public void testDateToString() throws Exception {
        java.sql.Date d = TimestampUtil.createDate(103, 10, 1);
        Function func = LANG_FACTORY.createFunction("convert",  //$NON-NLS-1$
            new Expression[] {
                LANG_FACTORY.createLiteral(d, java.sql.Date.class),
                LANG_FACTORY.createLiteral("string", String.class)}, //$NON-NLS-1$
            String.class);
       
View Full Code Here
199
200
201
202
203
204
205
206
207
208
209
        helpGetString1(func,  "stuff(stuff(convert(varchar, CAST('2003-11-01' AS DATE), 102), 5, 1, '-'), 8, 1, '-')");  //$NON-NLS-1$
    }
   
    @Test public void testTimeToString() throws Exception {
        java.sql.Time t = TimestampUtil.createTime(3, 10, 1);
        Function func = LANG_FACTORY.createFunction("convert",  //$NON-NLS-1$
            new Expression[] {
                LANG_FACTORY.createLiteral(t, java.sql.Time.class),
                LANG_FACTORY.createLiteral("string", String.class)}, //$NON-NLS-1$
            String.class);
       
View Full Code Here
210
211
212
213
214
215
216
217
218
219
220
        helpGetString1(func,  "convert(varchar, CAST('1970-01-01 03:10:01.0' AS DATETIME), 8)");  //$NON-NLS-1$
    }   
   
    @Test public void testBigDecimalToString() throws Exception {
        java.math.BigDecimal m = new java.math.BigDecimal("-123124534.3"); //$NON-NLS-1$
        Function func = LANG_FACTORY.createFunction("convert",  //$NON-NLS-1$
            new Expression[] {
                LANG_FACTORY.createLiteral(m, java.math.BigDecimal.class),
                LANG_FACTORY.createLiteral("string", String.class)}, //$NON-NLS-1$
            String.class);
       
View Full Code Here
222
223
224
225
226
227
228
229
230
231
232
    }
    /***************** End of cast(string AS input)******************/
   
    /***************** Beginning of cast(char AS input) ************/
    @Test public void testStringToChar() throws Exception {
        Function func = LANG_FACTORY.createFunction("convert",  //$NON-NLS-1$
            new Expression[] {
                LANG_FACTORY.createLiteral("12", String.class), //$NON-NLS-1$
                LANG_FACTORY.createLiteral("char", Character.class)}, //$NON-NLS-1$
        Character.class);
       
View Full Code Here
234
235
236
237
238
239
240
241
242
243
244
    }    
    /***************** End of cast(char AS input)******************/
    
    /***************** Beginning of cast(boolean AS input) ************/
    @Test public void testStringToBoolean() throws Exception {
        Function func = LANG_FACTORY.createFunction("convert",  //$NON-NLS-1$
            new Expression[] {
                LANG_FACTORY.createLiteral("true", String.class),  //$NON-NLS-1$
                LANG_FACTORY.createLiteral("boolean", Boolean.class)}, //$NON-NLS-1$
            Boolean.class);
       
View Full Code Here
244
245
246
247
248
249
250
251
252
253
254
       
        helpGetString1(func,  "CASE WHEN 'true' IN ('false', '0') THEN 0 WHEN 'true' IS NOT NULL THEN 1 END");  //$NON-NLS-1$
    }
   
    @Test public void testByteToBoolean() throws Exception {
        Function func = LANG_FACTORY.createFunction("convert",  //$NON-NLS-1$
            new Expression[] {
                LANG_FACTORY.createLiteral(new Byte((byte)1), Byte.class), 
                LANG_FACTORY.createLiteral("boolean", Boolean.class)}, //$NON-NLS-1$
            Boolean.class);
       
View Full Code Here
254
255
256
257
258
259
260
261
262
263
264
       
        helpGetString1(func,  "CASE WHEN 1 = 0 THEN 0 WHEN 1 IS NOT NULL THEN 1 END");  //$NON-NLS-1$
    }
   
    @Test public void testShortToBoolean() throws Exception {
        Function func = LANG_FACTORY.createFunction("convert",  //$NON-NLS-1$
            new Expression[] {
                LANG_FACTORY.createLiteral(new Short((short) 0), Short.class), 
                LANG_FACTORY.createLiteral("boolean", Boolean.class)}, //$NON-NLS-1$
            Boolean.class);
       
View Full Code Here
264
265
266
267
268
269
270
271
272
273
274
       
        helpGetString1(func,  "CASE WHEN 0 = 0 THEN 0 WHEN 0 IS NOT NULL THEN 1 END");  //$NON-NLS-1$
    }
   
    @Test public void testIntegerToBoolean() throws Exception {
        Function func = LANG_FACTORY.createFunction("convert",  //$NON-NLS-1$
            new Expression[] {
                LANG_FACTORY.createLiteral(new Integer(1), Integer.class), 
                LANG_FACTORY.createLiteral("boolean", Boolean.class)}, //$NON-NLS-1$
            Boolean.class);
       
View Full Code Here
274
275
276
277
278
279
280
281
282
283
284
       
        helpGetString1(func,  "CASE WHEN 1 = 0 THEN 0 WHEN 1 IS NOT NULL THEN 1 END");  //$NON-NLS-1$
    }
   
    @Test public void testLongToBoolean() throws Exception {
        Function func = LANG_FACTORY.createFunction("convert",  //$NON-NLS-1$
            new Expression[] {
                LANG_FACTORY.createLiteral(new Long(1), Long.class), 
                LANG_FACTORY.createLiteral("boolean", Boolean.class)}, //$NON-NLS-1$
            Boolean.class);
       
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.