Package org.mule.module.db.internal.domain.query

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
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
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
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
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
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
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
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
69
70
71
72
73
74
75
76
77
78
79
        DefaultInputQueryParam param2 = new DefaultInputQueryParam(2, UnknownDbType.getInstance(), "A", "param2");
        List<QueryParam> params = new ArrayList<QueryParam>();
        params.add(param1);
        params.add(param2);

        QueryTemplate queryTemplate = new QueryTemplate(SQL_TEXT, QueryType.SELECT, params);

        Map<Integer, DbType> paramTypes = new HashMap<Integer, DbType>();
        paramTypes.put(1, JdbcTypes.INTEGER_DB_TYPE);
        paramTypes.put(2, JdbcTypes.INTEGER_DB_TYPE);
View Full Code Here
85
86
87
88
89
90
91
92
93
94
95
    }

    @Test
    public void usesUnknownTypesWhenNoMetadataAvailable() 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)).thenThrow(new SQLException("Error"));

        Map<Integer, DbType> parameterTypes = paramTypeResolver.getParameterTypes(connection, queryTemplate);
View Full Code Here
TOP

Related Classes of org.mule.module.db.internal.domain.query.QueryTemplate

  • org.mule.module.db.integration.config.CustomParamTypeTestCase
  • org.mule.module.db.integration.select.SelectTemplateSqlTestCase
  • org.mule.module.db.integration.storedprocedure.StoredProcedureTemplateSqlTestCase
  • org.mule.module.db.integration.template.CdataParameterizedQueryTemplateTestCase
  • org.mule.module.db.integration.template.TemplateQueryConfigTestCase
  • org.mule.module.db.integration.update.UpdateTemplateSqlTestCase
  • org.mule.module.db.internal.config.domain.query.DynamicQueryTemplateFactoryBean
  • org.mule.module.db.internal.config.domain.query.DynamicQueryTemplateFactoryBeanTestCase
  • org.mule.module.db.internal.config.domain.query.ParameterizedQueryTemplateFactoryBean
  • org.mule.module.db.internal.config.domain.query.ParameterizedQueryTemplateFactoryBeanTestCase
    • 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.