Repository: camel Updated Branches: refs/heads/camel-2.16.x 618f8f7fb -> 54f1ea076 refs/heads/master 2f3b75bb4 -> c2c2cdd4e
Added test based on user forum issue Project: http://git-wip-us.apache.org/repos/asf/camel/repo Commit: http://git-wip-us.apache.org/repos/asf/camel/commit/c2c2cdd4 Tree: http://git-wip-us.apache.org/repos/asf/camel/tree/c2c2cdd4 Diff: http://git-wip-us.apache.org/repos/asf/camel/diff/c2c2cdd4 Branch: refs/heads/master Commit: c2c2cdd4ec12ad0ca22bc2ac5317d866b74e7e44 Parents: 2f3b75b Author: Claus Ibsen <davscl...@apache.org> Authored: Mon Dec 14 10:19:24 2015 +0100 Committer: Claus Ibsen <davscl...@apache.org> Committed: Mon Dec 14 10:19:24 2015 +0100 ---------------------------------------------------------------------- .../sql/SqlProducerWhereIssueTest.java | 84 ++++++++++++++++++++ 1 file changed, 84 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/camel/blob/c2c2cdd4/components/camel-sql/src/test/java/org/apache/camel/component/sql/SqlProducerWhereIssueTest.java ---------------------------------------------------------------------- diff --git a/components/camel-sql/src/test/java/org/apache/camel/component/sql/SqlProducerWhereIssueTest.java b/components/camel-sql/src/test/java/org/apache/camel/component/sql/SqlProducerWhereIssueTest.java new file mode 100644 index 0000000..bd41bb3 --- /dev/null +++ b/components/camel-sql/src/test/java/org/apache/camel/component/sql/SqlProducerWhereIssueTest.java @@ -0,0 +1,84 @@ +/** + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed with + * this work for additional information regarding copyright ownership. + * The ASF licenses this file to You under the Apache License, Version 2.0 + * (the "License"); you may not use this file except in compliance with + * the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + */ +package org.apache.camel.component.sql; + +import java.util.List; +import java.util.Map; + +import org.apache.camel.builder.RouteBuilder; +import org.apache.camel.component.mock.MockEndpoint; +import org.apache.camel.test.junit4.CamelTestSupport; +import org.junit.After; +import org.junit.Before; +import org.junit.Test; +import org.springframework.jdbc.datasource.embedded.EmbeddedDatabase; +import org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseBuilder; +import org.springframework.jdbc.datasource.embedded.EmbeddedDatabaseType; + +public class SqlProducerWhereIssueTest extends CamelTestSupport { + + private EmbeddedDatabase db; + + @Before + public void setUp() throws Exception { + db = new EmbeddedDatabaseBuilder() + .setType(EmbeddedDatabaseType.DERBY).addScript("sql/createAndPopulateDatabase.sql").build(); + + super.setUp(); + } + + @After + public void tearDown() throws Exception { + super.tearDown(); + + db.shutdown(); + } + + @Test + public void testQueryWhereIssue() throws InterruptedException { + MockEndpoint mock = getMockEndpoint("mock:query"); + mock.expectedMessageCount(1); + + template.requestBodyAndHeader("direct:query", "Hi there!", "lowId", "1"); + + assertMockEndpointsSatisfied(); + + List list = mock.getReceivedExchanges().get(0).getIn().getBody(List.class); + Map row = (Map) list.get(0); + assertEquals("ASF", row.get("LICENSE")); + assertEquals(2, row.get("ROWCOUNT")); + row = (Map) list.get(1); + assertEquals("XXX", row.get("LICENSE")); + assertEquals(1, row.get("ROWCOUNT")); + } + + @Override + protected RouteBuilder createRouteBuilder() throws Exception { + return new RouteBuilder() { + @Override + public void configure() throws Exception { + // required for the sql component + getContext().getComponent("sql", SqlComponent.class).setDataSource(db); + + from("direct:query") + .to("sql:select count(*) rowcount, license from projects where id=:#lowId or id=2 or id=3 group by license") + .to("log:query") + .to("mock:query"); + } + }; + } +}
