Package org.teiid.language

Examples of org.teiid.language.Function

61
62
63
64
65
66
67
68
69
70
71
    private void helpGetString1(Function func, String expectedStr) throws Exception {
        assertEquals(expectedStr, helpGetString(func));
    }
   
    public void helpTest(Expression srcExpression, String tgtType, String expectedExpression) throws Exception {
        Function func = LANG_FACTORY.createFunction("convert",  //$NON-NLS-1$
            new Expression[] {
                srcExpression,
                LANG_FACTORY.createLiteral(tgtType, String.class)},
            DataTypeManager.getDataTypeClass(tgtType));
       
View Full Code Here
73
74
75
76
77
78
79
80
81
82
83
            expectedExpression, helpGetString(func));
    }
   
    // original test -- this is not a drop one anymore
    @Test public void testModDrop() throws Exception {
        Function func = LANG_FACTORY.createFunction("convert",  //$NON-NLS-1$
            new Expression[] {
                LANG_FACTORY.createLiteral("5", String.class), //$NON-NLS-1$
                LANG_FACTORY.createLiteral("integer", String.class)     //$NON-NLS-1$
            },
            Integer.class);
View Full Code Here
86
87
88
89
90
91
92
93
94
95
96
    }

    /********************Beginning of cast(date AS INPUT) ******************/
    @Test public void testStringToDate() throws Exception {
        String dateStr = "2003-12-31"; //$NON-NLS-1$
        Function func = LANG_FACTORY.createFunction("convert",  //$NON-NLS-1$
            new Expression[] {
                LANG_FACTORY.createLiteral(dateStr, String.class),
                LANG_FACTORY.createLiteral("date", String.class)}, //$NON-NLS-1$
            java.sql.Date.class);
       
View Full Code Here
97
98
99
100
101
102
103
104
105
106
107
        assertEquals("cast('2003-12-31' AS datetime)", helpGetString(func)); //$NON-NLS-1$
    }
   
    @Test public void testTimestampToDate() throws Exception {
        Literal c = LANG_FACTORY.createLiteral(TimestampUtil.createTimestamp(89, 2, 3, 7, 8, 12, 99999), Timestamp.class);
        Function func = LANG_FACTORY.createFunction("convert",  //$NON-NLS-1$
            new Expression[] {
                c,
                LANG_FACTORY.createLiteral("date", String.class)}, //$NON-NLS-1$
            java.sql.Date.class);
       
View Full Code Here
110
111
112
113
114
115
116
117
118
119
120
   
    /********************END of cast(date AS INPUT) ******************/
    /********************Beginning of cast(time AS INPUT) ******************/
    @Test public void testStringToTime() throws Exception {
        String timeStr = "12:08:07"; //$NON-NLS-1$
        Function func = LANG_FACTORY.createFunction("convert",  //$NON-NLS-1$
            new Expression[] {
                LANG_FACTORY.createLiteral(timeStr, String.class),
                LANG_FACTORY.createLiteral("time", String.class)}, //$NON-NLS-1$
            java.sql.Time.class);
       
View Full Code Here
121
122
123
124
125
126
127
128
129
130
131
        helpGetString1(func,  "cast('12:08:07' AS datetime)");  //$NON-NLS-1$
    }
   
    @Test public void testTimestampToTime() throws Exception {
        Literal c = LANG_FACTORY.createLiteral(TimestampUtil.createTimestamp(89, 2, 3, 7, 8, 12, 99999), Timestamp.class);
        Function func = LANG_FACTORY.createFunction("convert",  //$NON-NLS-1$
            new Expression[] {
                c,
                LANG_FACTORY.createLiteral("time", String.class)}, //$NON-NLS-1$
            java.sql.Time.class);
       
View Full Code Here
134
135
136
137
138
139
140
141
142
143
144
    /********************END of cast(time AS INPUT) ******************/
   
    /********************Beginning of cast(timestamp AS INPUT) ******************/
    @Test public void testStringToTimestamp() throws Exception {
        String timestampStr = "1989-07-09 12:08:07"; //$NON-NLS-1$
        Function func = LANG_FACTORY.createFunction("convert",  //$NON-NLS-1$
            new Expression[] {
                LANG_FACTORY.createLiteral(timestampStr, String.class),
                LANG_FACTORY.createLiteral("timestamp", String.class)}, //$NON-NLS-1$
            java.sql.Timestamp.class);
       
View Full Code Here
144
145
146
147
148
149
150
151
152
153
154
       
        helpGetString1(func,  "cast('1989-07-09 12:08:07' AS datetime)");  //$NON-NLS-1$
    }
   
    @Test public void testTimeToTimestamp() throws Exception {
        Function func = LANG_FACTORY.createFunction("convert",  //$NON-NLS-1$
            new Expression[] {
                LANG_FACTORY.createLiteral(TimestampUtil.createTime(12, 2, 3), java.sql.Time.class),
                LANG_FACTORY.createLiteral("timestamp", String.class)}, //$NON-NLS-1$
            java.sql.Timestamp.class);
       
View Full Code Here
154
155
156
157
158
159
160
161
162
163
164
       
        helpGetString1(func,  "CAST('1970-01-01 12:02:03.0' AS DATETIME)");  //$NON-NLS-1$
    }
       
    @Test public void testDateToTimestamp() throws Exception {
        Function func = LANG_FACTORY.createFunction("convert",  //$NON-NLS-1$
            new Expression[] {
                LANG_FACTORY.createLiteral(TimestampUtil.createDate(89, 2, 3), java.sql.Date.class),
                LANG_FACTORY.createLiteral("timestamp", String.class)}, //$NON-NLS-1$
            java.sql.Timestamp.class);
       
View Full Code Here
166
167
168
169
170
171
172
173
174
175
176
    }
    /********************END of cast(timestamp AS INPUT) ******************/

    /*****************Beginning of cast(string AS input)******************/
    @Test public void testBooleanToStringa() throws Exception {
        Function func = LANG_FACTORY.createFunction("convert",  //$NON-NLS-1$
            new Expression[] {
                LANG_FACTORY.createLiteral(Boolean.TRUE, Boolean.class),
                LANG_FACTORY.createLiteral("string", String.class)}, //$NON-NLS-1$
            String.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.