Examples of QueryTemplate

Examples of org.mule.module.db.internal.domain.query.QueryTemplate

134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
    @Test
    public void usesNullDefaultParamValue() throws Exception
    {
        Object queryTemplateBean = muleContext.getRegistry().get("testNullParamsQuery");

        QueryTemplate queryTemplate = (QueryTemplate) queryTemplateBean;

        assertFalse(queryTemplate.isDynamic());
        assertEquals("SELECT * FROM PLANET WHERE POSITION = ?", queryTemplate.getSqlText());
        assertEquals(1, queryTemplate.getInputParams().size());
        InputQueryParam param1 = queryTemplate.getInputParams().get(0);
        assertEquals(UnknownDbType.getInstance(), param1.getType());
        assertEquals("position", param1.getName());
        assertEquals(null, param1.getValue());
        assertEquals(1, param1.getIndex());
    }
View Full Code Here

Examples of org.mule.module.db.internal.domain.query.QueryTemplate

151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
    @Test
    public void overridesDisorderedParams() throws Exception
    {
        Object queryTemplateBean = muleContext.getRegistry().get("disorderedParams");
        assertTrue(queryTemplateBean instanceof QueryTemplate);
        QueryTemplate queryTemplate = (QueryTemplate) queryTemplateBean;
        assertEquals(QueryType.SELECT, queryTemplate.getType());
        assertEquals("SELECT * FROM PLANET WHERE POSITION = ? AND NAME = ?", queryTemplate.getSqlText());
        assertEquals(2, queryTemplate.getInputParams().size());

        InputQueryParam param1 = queryTemplate.getInputParams().get(0);
        assertEquals(UnknownDbType.getInstance(), param1.getType());
        assertEquals("position", param1.getName());
        assertEquals("0", param1.getValue());
        assertEquals(1, param1.getIndex());

        InputQueryParam param2 = queryTemplate.getInputParams().get(1);
        assertEquals(UnknownDbType.getInstance(), param2.getType());
        assertEquals("name", param2.getName());
        assertEquals("mars", param2.getValue());
        assertEquals(2, param2.getIndex());
    }
View Full Code Here

Examples of org.mule.module.db.internal.domain.query.QueryTemplate

226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
    }

    @Test
    public void definesTemplateWithExpressionParam() throws Exception
    {
        QueryTemplate queryTemplate = parser.parse("update PLANET set NAME='Mercury' where ID= #[planetId]");

        assertEquals(QueryType.UPDATE, queryTemplate.getType());
        assertEquals("update PLANET set NAME='Mercury' where ID= ?", queryTemplate.getSqlText());
        assertEquals(1, queryTemplate.getInputParams().size());
        InputQueryParam param1 = queryTemplate.getInputParams().get(0);
        assertEquals(UnknownDbType.getInstance(), param1.getType());
        assertNull(param1.getName());
        assertEquals("#[planetId]", param1.getValue());
    }
View Full Code Here

Examples of org.mule.module.db.internal.domain.query.QueryTemplate

240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
    }

    @Test
    public void definesTemplateWithComplexExpressionParam() throws Exception
    {
        QueryTemplate queryTemplate = parser.parse("SELECT * FROM PLANET WHERE POSITION = #[message.inboundProperties['position']] AND NAME= #[planetName]");

        assertEquals(QueryType.SELECT, queryTemplate.getType());
        assertEquals("SELECT * FROM PLANET WHERE POSITION = ? AND NAME= ?", queryTemplate.getSqlText());
        assertEquals(2, queryTemplate.getInputParams().size());
        InputQueryParam param1 = queryTemplate.getInputParams().get(0);
        assertEquals(UnknownDbType.getInstance(), param1.getType());
        assertNull(param1.getName());
        assertEquals("#[message.inboundProperties['position']]", param1.getValue());

        InputQueryParam param2 = queryTemplate.getInputParams().get(1);
        assertEquals(UnknownDbType.getInstance(), param2.getType());
        assertNull(param2.getName());
        assertEquals("#[planetName]", param2.getValue());
    }
View Full Code Here

Examples of org.mule.module.db.internal.domain.query.QueryTemplate

172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
    }

    private void doQueryFromFileTest(Object queryTemplateBean, String paramValue)
    {
        assertTrue(queryTemplateBean instanceof QueryTemplate);
        QueryTemplate queryTemplate = (QueryTemplate) queryTemplateBean;
        assertEquals(QueryType.SELECT, queryTemplate.getType());
        assertEquals("SELECT * FROM PLANET WHERE POSITION = ?", queryTemplate.getSqlText());
        assertEquals(1, queryTemplate.getInputParams().size());
        InputQueryParam param1 = queryTemplate.getInputParams().get(0);
        assertEquals(UnknownDbType.getInstance(), param1.getType());
        assertEquals("position", param1.getName());
        assertEquals(paramValue, param1.getValue());
        assertEquals(1, param1.getIndex());
    }
View Full Code Here

Examples of org.mule.module.db.internal.domain.query.QueryTemplate

24
25
26
27
28
29
30
31
    }

    @Test
    public void parsesParameterizedQuery() throws Exception
    {
        QueryTemplate queryTemplate = muleContext.getRegistry().lookupObject("parameterizedQuery");
        assertThat(queryTemplate.getSqlText(), equalTo("select * from PLANET"));
    }
View Full Code Here

Examples of org.mule.module.db.internal.domain.query.QueryTemplate

69
70
71
72
73
74
75
            InputQueryParam inputQueryParam = new DefaultInputQueryParam(index, paramType, "param" + index);
            queryParams.add(inputQueryParam);
            index++;
        }

        return new QueryTemplate(staticSqlText, QueryType.SELECT, queryParams);
    }
View Full Code Here

Examples of org.mule.module.db.internal.domain.query.QueryTemplate

31
32
33
34
35
36
37
38
39
40
    protected final MuleEvent muleEvent = mock(MuleEvent.class);

    protected QueryTemplateParser createQueryTemplateParser()
    {
        QueryTemplateParser queryTemplateParser = mock(QueryTemplateParser.class);
        when(queryTemplateParser.parse(STATIC_SQL_1)).thenReturn(new QueryTemplate(STATIC_SQL_1, QueryType.DELETE, Collections.<QueryParam>emptyList()));
        when(queryTemplateParser.parse(STATIC_SQL_2)).thenReturn(new QueryTemplate(STATIC_SQL_2, QueryType.DELETE, Collections.<QueryParam>emptyList()));

        return queryTemplateParser;
    }
View Full Code Here

Examples of org.mule.module.db.internal.domain.query.QueryTemplate

33
34
35
36
37
38
39
40
41
42
43
    {
        ExpressionManager expressionManager = mock(ExpressionManager.class);
        String staticSqlText = STATIC_SQL_TEXT;
        when(expressionManager.parse(DYNAMIC_SQL_TEXT, muleEvent)).thenReturn(staticSqlText);

        QueryTemplate expectedQueryTemplate = createQueryTemplate(staticSqlText);
        QueryTemplateParser queryTemplateParser = mock(QueryTemplateParser.class);
        when(queryTemplateParser.parse(staticSqlText)).thenReturn(expectedQueryTemplate);

        DynamicQueryResolver queryResolver = new DynamicQueryResolver(query, queryTemplateParser, expressionManager);
View Full Code Here

Examples of org.mule.module.db.internal.domain.query.QueryTemplate

50
51
52
53
54
55
56
57
58
59
60
    private final DbConnection connection = mock(DbConnection.class);

    @Test
    public void resolvesUnknownTypeUsingMetadata() throws Exception
    {
        QueryTemplate queryTemplate = new QueryTemplate(SQL_TEXT, QueryType.SELECT, Collections.<org.mule.module.db.internal.domain.param.QueryParam>singletonList(new DefaultInputQueryParam(1, UnknownDbType.getInstance(), "7", "param1")));

        when(metadataParamTypeResolver.getParameterTypes(connection, queryTemplate)).thenReturn(Collections.singletonMap(1, JdbcTypes.INTEGER_DB_TYPE));

        Map<Integer, DbType> parameterTypes = paramTypeResolver.getParameterTypes(connection, queryTemplate);
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.