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

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

48
49
50
51
52
53
54
55
56
57
58
    {
        DbConnectionFactory dbConnectionFactory = mock(DbConnectionFactory.class);

        for (QueryType type : QueryType.values())
        {
            QueryTemplate queryTemplate = new QueryTemplate("UNUSED SQL TEXT", type, Collections.<QueryParam>emptyList());

            if (type != QueryType.SELECT && type != QueryType.STORE_PROCEDURE_CALL)
            {
                try
                {
View Full Code Here
48
49
50
51
52
53
54
55
56
57
58
    {
        DbConnectionFactory dbConnectionFactory = mock(DbConnectionFactory.class);

        for (QueryType type : QueryType.values())
        {
            QueryTemplate queryTemplate = new QueryTemplate("UNUSED SQL TEXT", type, Collections.<QueryParam>emptyList());

            if (type != QueryType.UPDATE && type != QueryType.STORE_PROCEDURE_CALL)
            {
                try
                {
View Full Code Here
29
30
31
32
33
34
35
36
37
    @Test
    public void configuresSimpleQuery() throws Exception
    {
        Object queryTemplateBean = muleContext.getRegistry().get("simple");
        assertTrue(queryTemplateBean instanceof QueryTemplate);
        QueryTemplate queryTemplate = (QueryTemplate) queryTemplateBean;
        assertEquals(QueryType.SELECT, queryTemplate.getType());
        assertEquals(0, queryTemplate.getInputParams().size());
    }
View Full Code Here
39
40
41
42
43
44
45
46
47
48
49
50
    @Test
    public void configuresParameterizedQuery() throws Exception
    {
        Object queryTemplateBean = muleContext.getRegistry().get("parameterized");
        assertTrue(queryTemplateBean instanceof QueryTemplate);
        QueryTemplate queryTemplate = (QueryTemplate) queryTemplateBean;
        assertEquals(QueryType.SELECT, queryTemplate.getType());
        assertEquals(1, queryTemplate.getInputParams().size());

        InputQueryParam inputSqlParam = queryTemplate.getInputParams().get(0);
        assertEquals(UnknownDbType.getInstance(), inputSqlParam.getType());
    }
View Full Code Here
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
    public static final String OVERRIDDEN_PARAM_VALUE = "10";

    @Test
    public void createsQueryWithNoParams() throws Exception
    {
        QueryTemplate queryTemplate = new QueryTemplate(QUERY, QueryType.SELECT, Collections.<QueryParam>emptyList());

        QueryTemplateParser queryParser = mock(QueryTemplateParser.class);
        when(queryParser.parse(QUERY)).thenReturn(queryTemplate);

        ParameterizedQueryTemplateFactoryBean factoryBean = new ParameterizedQueryTemplateFactoryBean(QUERY, Collections.EMPTY_LIST, queryParser);

        QueryTemplate createdQueryTemplate = factoryBean.getObject();

        assertThat(createdQueryTemplate.getSqlText(), equalTo(QUERY));
        assertThat(createdQueryTemplate.getType(), equalTo(QueryType.SELECT));
        assertThat(createdQueryTemplate.getParams(), is(empty()));
    }
View Full Code Here
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
    @Test
    public void createsQueryWithDefaultParams() throws Exception
    {
        List<QueryParam> defaultParams = Collections.<QueryParam>singletonList(new DefaultInputQueryParam(1, JdbcTypes.INTEGER_DB_TYPE, TEMPLATE_PARAM_VALUE, POSITION_PARAM_NAME));
        QueryTemplate queryTemplate = new QueryTemplate(PARSED_PARAMETERIZED_QUERY, QueryType.SELECT, defaultParams);

        QueryTemplateParser queryParser = mock(QueryTemplateParser.class);
        when(queryParser.parse(PARAMETERIZED_QUERY)).thenReturn(queryTemplate);

        ParameterizedQueryTemplateFactoryBean factoryBean = new ParameterizedQueryTemplateFactoryBean(PARAMETERIZED_QUERY, Collections.EMPTY_LIST, queryParser);

        QueryTemplate createdQueryTemplate = factoryBean.getObject();

        assertThat(createdQueryTemplate.getSqlText(), equalTo(PARSED_PARAMETERIZED_QUERY));
        assertThat(createdQueryTemplate.getType(), equalTo(QueryType.SELECT));
        assertThat(createdQueryTemplate.getParams().size(), equalTo(1));
        InputQueryParam inputQueryParam = createdQueryTemplate.getInputParams().get(0);
        assertThat(inputQueryParam.getValue(), IsEqual.<Object>equalTo(TEMPLATE_PARAM_VALUE));
    }
View Full Code Here
84
85
86
87
88
89
90
91
92
93
94
95
96
    }

    @Test
    public void createsQueryWithOverriddenParams() throws Exception
    {
        QueryTemplate createdQueryTemplate = doOverriddenParamTest(JdbcTypes.INTEGER_DB_TYPE, new DefaultInputQueryParam(1, JdbcTypes.INTEGER_DB_TYPE, OVERRIDDEN_PARAM_VALUE, POSITION_PARAM_NAME));

        assertThat(createdQueryTemplate.getSqlText(), equalTo(PARSED_PARAMETERIZED_QUERY));
        assertThat(createdQueryTemplate.getType(), equalTo(QueryType.SELECT));
        assertThat(createdQueryTemplate.getParams().size(), equalTo(1));
        InputQueryParam inputQueryParam = createdQueryTemplate.getInputParams().get(0);
        assertThat(inputQueryParam.getValue(), IsEqual.<Object>equalTo(OVERRIDDEN_PARAM_VALUE));
    }
View Full Code Here
133
134
135
136
137
138
139
140
141
142
143
144
145
146
    private void doInputParamOverrideTest(DbType templateParamType, DbType overriddenParamType, DbType expectedParamType) throws Exception
    {
        QueryParam overriddenParam = new DefaultInputQueryParam(2, overriddenParamType, OVERRIDDEN_PARAM_VALUE, POSITION_PARAM_NAME);

        QueryTemplate createdQueryTemplate = doOverriddenParamTest(templateParamType, overriddenParam);

        assertThat(createdQueryTemplate.getParams().size(), equalTo(1));
        InputQueryParam inputQueryParam = createdQueryTemplate.getInputParams().get(0);
        assertThat(inputQueryParam.getIndex(), equalTo(1));
        assertThat(inputQueryParam.getType(), equalTo(expectedParamType));
        assertThat(inputQueryParam.getName(), equalTo(POSITION_PARAM_NAME));
        assertThat(inputQueryParam.getValue(), IsEqual.<Object>equalTo(OVERRIDDEN_PARAM_VALUE));
    }
View Full Code Here
147
148
149
150
151
152
153
154
155
156
157
158
159
160
    private void doInOutParamOverrideTest(DbType templateParamType, DbType overriddenParamType, DbType expectedParamType) throws Exception
    {
        QueryParam overriddenParam = new DefaultInOutQueryParam(2, overriddenParamType, POSITION_PARAM_NAME, OVERRIDDEN_PARAM_VALUE);

        QueryTemplate createdQueryTemplate = doOverriddenParamTest(templateParamType, overriddenParam);

        assertThat(createdQueryTemplate.getParams().size(), equalTo(1));
        InOutQueryParam queryParam = (InOutQueryParam) createdQueryTemplate.getParams().get(0);
        assertThat(queryParam.getIndex(), equalTo(1));
        assertThat(queryParam.getType(), equalTo(expectedParamType));
        assertThat(queryParam.getName(), equalTo(POSITION_PARAM_NAME));
        assertThat(queryParam.getValue(), IsEqual.<Object>equalTo(OVERRIDDEN_PARAM_VALUE));
    }
View Full Code Here
41
42
43
44
45
46
47
48
49
50
    }

    @Test
    public void usesCustomType() throws Exception
    {
        QueryTemplate parameterizedQueryTemplate = muleContext.getRegistry().lookupObject("parameterizedQuery");
        QueryParam queryParam = parameterizedQueryTemplate.getParams().get(0);

        assertThat(queryParam.getType().getName(), equalTo("CUSTOM_TYPE1"));
    }
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.