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

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

148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
    @Test
    public void detectsStoredProcedureAssignment() throws Exception
    {
        String sql = "{ :out = call getTestRecords() } ";

        QueryTemplate queryTemplate = parser.parse(sql);

        assertThat(queryTemplate.getType(), equalTo(QueryType.STORE_PROCEDURE_CALL));
        assertThat(queryTemplate.getSqlText(), equalTo("{ ? = call getTestRecords() }"));
        assertThat(queryTemplate.getParams().size(), equalTo(1));

        QueryParam param1 = queryTemplate.getParams().get(0);
        assertThat(param1.getName(), equalTo("out"));
        assertThat(param1.getType(), equalTo(UnknownDbType.getInstance()));
    }
View Full Code Here
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
    @Test
    public void definesUpdate() throws Exception
    {
        Object queryTemplateBean = muleContext.getRegistry().get("testUpdate");
        assertTrue(queryTemplateBean instanceof QueryTemplate);
        QueryTemplate queryTemplate = (QueryTemplate) queryTemplateBean;
        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());
        assertEquals("id", param1.getName());
        assertEquals("0", param1.getValue());
        assertEquals(1, param1.getIndex());
    }
View Full Code Here
180
181
182
183
184
185
186
187
        doIncompleteStoredProcedureAssingmentTest("{ a = call getTestRecords() } ");
    }

    private void doIncompleteStoredProcedureAssingmentTest(String sql)
    {
        QueryTemplate queryTemplate = parser.parse(sql);
        assertThat(queryTemplate.getType(), equalTo(QueryType.DDL));
    }
View Full Code Here
192
193
194
195
196
197
198
199
200
201
        doStoredProcedureParsingTest("{call getTestRecords() } ");
    }

    private void doStoredProcedureParsingTest(String sql)
    {
        QueryTemplate queryTemplate = parser.parse(sql);
        assertEquals(QueryType.STORE_PROCEDURE_CALL, queryTemplate.getType());
        assertEquals(sql.trim(), queryTemplate.getSqlText());
        assertEquals(0, queryTemplate.getInputParams().size());
    }
View Full Code Here
112
113
114
115
116
117
118
119
120
121
    @Test
    public void usesDynamicQuery() throws Exception
    {
        Object queryTemplateBean = muleContext.getRegistry().get("testDynamicQuery");
        assertTrue(queryTemplateBean instanceof QueryTemplate);
        QueryTemplate queryTemplate = (QueryTemplate) queryTemplateBean;
        assertTrue(queryTemplate.isDynamic());
        assertEquals("SELECT * FROM PLANET WHERE POSITION = #[position]", queryTemplate.getSqlText());
        assertEquals(0, queryTemplate.getInputParams().size());
    }
View Full Code Here
202
203
204
205
206
207
208
209
210
211
212
213
    @Test
    public void parsesQuestionMarkParam() throws Exception
    {
        String sql = "SELECT * FROM PLANET WHERE POSITION = ?";
        QueryTemplate queryTemplate = parser.parse(sql);
        assertEquals(QueryType.SELECT, queryTemplate.getType());
        assertEquals(sql, queryTemplate.getSqlText());
        assertEquals(1, queryTemplate.getInputParams().size());
        InputQueryParam param1 = queryTemplate.getInputParams().get(0);
        assertEquals(UnknownDbType.getInstance(), param1.getType());
    }
View Full Code Here
123
124
125
126
127
128
129
130
131
132
    @Test
    public void usesDynamicQueryWithPlaceholder() throws Exception
    {
        Object queryTemplateBean = muleContext.getRegistry().get("testDynamicPlaceholderQuery");
        assertTrue(queryTemplateBean instanceof QueryTemplate);
        QueryTemplate queryTemplate = (QueryTemplate) queryTemplateBean;
        assertTrue(queryTemplate.isDynamic());
        assertEquals("SELECT * FROM PLANET WHERE POSITION = #[position]", queryTemplate.getSqlText());
        assertEquals(0, queryTemplate.getInputParams().size());
    }
View Full Code Here
213
214
215
216
217
218
219
220
221
222
223
224
225
226
    }

    @Test
    public void parsesNamedParam() 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());
        assertEquals("planetId", param1.getName());
        assertNull(param1.getValue());
    }
View Full Code Here
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
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
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.