This is an automated email from the ASF dual-hosted git repository. ppalaga pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/camel-quarkus.git
commit 1e405cb2a6cbe0b50ec6a298347113e7eedce52c Author: Peter Palaga <ppal...@redhat.com> AuthorDate: Mon Sep 7 18:05:00 2020 +0200 MyBatis JVM support --- catalog/pom.xml | 13 ++ docs/modules/ROOT/nav.adoc | 1 + docs/modules/ROOT/pages/reference/components.adoc | 6 + .../ROOT/pages/reference/extensions/mybatis.adoc | 30 +++++ docs/modules/ROOT/pages/reference/index.adoc | 3 + extensions-jvm/mybatis/deployment/pom.xml | 63 ++++++++++ .../mybatis/deployment/MybatisProcessor.java | 46 +++++++ extensions-jvm/mybatis/integration-test/pom.xml | 104 ++++++++++++++++ .../component/mybatis/it/MybatisResource.java | 64 ++++++++++ .../component/mybatis/it/bean/AccountService.java | 41 ++++++ .../component/mybatis/it/entity/Account.java | 61 +++++++++ .../src/main/resources/SqlMapConfig.xml | 55 ++++++++ .../component/mybatis/it/entity/Account.xml | 138 +++++++++++++++++++++ .../quarkus/component/mybatis/it/MybatisTest.java | 42 +++++++ extensions-jvm/mybatis/pom.xml | 40 ++++++ extensions-jvm/mybatis/runtime/pom.xml | 94 ++++++++++++++ .../main/resources/META-INF/quarkus-extension.yaml | 32 +++++ extensions-jvm/pom.xml | 1 + poms/bom/pom.xml | 15 +++ 19 files changed, 849 insertions(+) diff --git a/catalog/pom.xml b/catalog/pom.xml index 4ab86bb..1139f9a 100644 --- a/catalog/pom.xml +++ b/catalog/pom.xml @@ -2181,6 +2181,19 @@ </dependency> <dependency> <groupId>org.apache.camel.quarkus</groupId> + <artifactId>camel-quarkus-mybatis</artifactId> + <version>${project.version}</version> + <type>pom</type> + <scope>test</scope> + <exclusions> + <exclusion> + <groupId>*</groupId> + <artifactId>*</artifactId> + </exclusion> + </exclusions> + </dependency> + <dependency> + <groupId>org.apache.camel.quarkus</groupId> <artifactId>camel-quarkus-nagios</artifactId> <version>${project.version}</version> <type>pom</type> diff --git a/docs/modules/ROOT/nav.adoc b/docs/modules/ROOT/nav.adoc index 0f491d5..bff048e 100644 --- a/docs/modules/ROOT/nav.adoc +++ b/docs/modules/ROOT/nav.adoc @@ -178,6 +178,7 @@ *** xref:reference/extensions/mongodb.adoc[MongoDB] *** xref:reference/extensions/mongodb-gridfs.adoc[MongoDB GridFS] *** xref:reference/extensions/mustache.adoc[Mustache] +*** xref:reference/extensions/mybatis.adoc[MyBatis] *** xref:reference/extensions/nagios.adoc[Nagios] *** xref:reference/extensions/nats.adoc[Nats] *** xref:reference/extensions/netty.adoc[Netty] diff --git a/docs/modules/ROOT/pages/reference/components.adoc b/docs/modules/ROOT/pages/reference/components.adoc index b7df960..daf9463 100644 --- a/docs/modules/ROOT/pages/reference/components.adoc +++ b/docs/modules/ROOT/pages/reference/components.adoc @@ -565,6 +565,12 @@ Stable | 1.0.0 | Interact with MongoDB GridFS. | xref:reference/extensions/mustache.adoc[Mustache] | [.camel-element-artifact]##camel-quarkus-mustache## | [.camel-element-Native]##Native## + Stable | 1.0.0 | Transform messages using a Mustache template. +| xref:reference/extensions/mybatis.adoc[MyBatis] | [.camel-element-artifact]##camel-quarkus-mybatis## | [.camel-element-JVM]##JVM## + +Preview | 1.1.0 | Performs a query, poll, insert, update or delete in a relational database using MyBatis. + +| xref:reference/extensions/mybatis.adoc[MyBatis Bean] | [.camel-element-artifact]##camel-quarkus-mybatis## | [.camel-element-JVM]##JVM## + +Preview | 1.1.0 | Perform queries, inserts, updates or deletes in a relational database using MyBatis. + | xref:reference/extensions/nagios.adoc[Nagios] | [.camel-element-artifact]##camel-quarkus-nagios## | [.camel-element-JVM]##JVM## + Preview | 1.1.0 | Send passive checks to Nagios using JSendNSCA. diff --git a/docs/modules/ROOT/pages/reference/extensions/mybatis.adoc b/docs/modules/ROOT/pages/reference/extensions/mybatis.adoc new file mode 100644 index 0000000..006042b --- /dev/null +++ b/docs/modules/ROOT/pages/reference/extensions/mybatis.adoc @@ -0,0 +1,30 @@ +// Do not edit directly! +// This file was generated by camel-quarkus-maven-plugin:update-extension-doc-page + +[[mybatis]] += MyBatis +:page-aliases: extensions/mybatis.adoc + +[.badges] +[.badge-key]##Since Camel Quarkus##[.badge-version]##1.1.0## [.badge-key]##JVM##[.badge-supported]##supported## [.badge-key]##Native##[.badge-unsupported]##unsupported## + +Performs a query, poll, insert, update or delete in a relational database using MyBatis. + +== What's inside + +* https://camel.apache.org/components/latest/mybatis-component.html[MyBatis component], URI syntax: `mybatis:statement` +* https://camel.apache.org/components/latest/mybatis-bean-component.html[MyBatis Bean component], URI syntax: `mybatis-bean:beanName:methodName` + +Please refer to the above links for usage and configuration details. + +== Maven coordinates + +[source,xml] +---- +<dependency> + <groupId>org.apache.camel.quarkus</groupId> + <artifactId>camel-quarkus-mybatis</artifactId> +</dependency> +---- + +Check the xref:user-guide/index.adoc[User guide] for more information about writing Camel Quarkus applications. diff --git a/docs/modules/ROOT/pages/reference/index.adoc b/docs/modules/ROOT/pages/reference/index.adoc index b193cf2..680e641 100644 --- a/docs/modules/ROOT/pages/reference/index.adoc +++ b/docs/modules/ROOT/pages/reference/index.adoc @@ -512,6 +512,9 @@ Stable | 1.0.0 | Interact with MongoDB GridFS. | xref:reference/extensions/mustache.adoc[Mustache] | camel-quarkus-mustache | [.camel-element-Native]##Native## + Stable | 1.0.0 | Transform messages using a Mustache template. +| xref:reference/extensions/mybatis.adoc[MyBatis] | camel-quarkus-mybatis | [.camel-element-JVM]##JVM## + +Preview | 1.1.0 | Performs a query, poll, insert, update or delete in a relational database using MyBatis. + | xref:reference/extensions/nagios.adoc[Nagios] | camel-quarkus-nagios | [.camel-element-JVM]##JVM## + Preview | 1.1.0 | Send passive checks to Nagios using JSendNSCA. diff --git a/extensions-jvm/mybatis/deployment/pom.xml b/extensions-jvm/mybatis/deployment/pom.xml new file mode 100644 index 0000000..c4567e6 --- /dev/null +++ b/extensions-jvm/mybatis/deployment/pom.xml @@ -0,0 +1,63 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!-- + + 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. + +--> +<project xmlns="http://maven.apache.org/POM/4.0.0" + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" + xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> + <modelVersion>4.0.0</modelVersion> + <parent> + <groupId>org.apache.camel.quarkus</groupId> + <artifactId>camel-quarkus-mybatis-parent</artifactId> + <version>1.1.0-SNAPSHOT</version> + <relativePath>../pom.xml</relativePath> + </parent> + + <artifactId>camel-quarkus-mybatis-deployment</artifactId> + <name>Camel Quarkus :: MyBatis :: Deployment</name> + + <dependencies> + <dependency> + <groupId>org.apache.camel.quarkus</groupId> + <artifactId>camel-quarkus-core-deployment</artifactId> + </dependency> + <dependency> + <groupId>org.apache.camel.quarkus</groupId> + <artifactId>camel-quarkus-mybatis</artifactId> + </dependency> + </dependencies> + + <build> + <plugins> + <plugin> + <groupId>org.apache.maven.plugins</groupId> + <artifactId>maven-compiler-plugin</artifactId> + <configuration> + <annotationProcessorPaths> + <path> + <groupId>io.quarkus</groupId> + <artifactId>quarkus-extension-processor</artifactId> + <version>${quarkus.version}</version> + </path> + </annotationProcessorPaths> + </configuration> + </plugin> + </plugins> + </build> + +</project> diff --git a/extensions-jvm/mybatis/deployment/src/main/java/org/apache/camel/quarkus/component/mybatis/deployment/MybatisProcessor.java b/extensions-jvm/mybatis/deployment/src/main/java/org/apache/camel/quarkus/component/mybatis/deployment/MybatisProcessor.java new file mode 100644 index 0000000..9a9bbd6 --- /dev/null +++ b/extensions-jvm/mybatis/deployment/src/main/java/org/apache/camel/quarkus/component/mybatis/deployment/MybatisProcessor.java @@ -0,0 +1,46 @@ +/* + * 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.quarkus.component.mybatis.deployment; + +import io.quarkus.deployment.annotations.BuildStep; +import io.quarkus.deployment.annotations.ExecutionTime; +import io.quarkus.deployment.annotations.Record; +import io.quarkus.deployment.builditem.FeatureBuildItem; +import io.quarkus.deployment.pkg.steps.NativeBuild; +import org.apache.camel.quarkus.core.JvmOnlyRecorder; +import org.jboss.logging.Logger; + +class MybatisProcessor { + + private static final Logger LOG = Logger.getLogger(MybatisProcessor.class); + private static final String FEATURE = "camel-mybatis"; + + @BuildStep + FeatureBuildItem feature() { + return new FeatureBuildItem(FEATURE); + } + + /** + * Remove this once this extension starts supporting the native mode. + */ + @BuildStep(onlyIf = NativeBuild.class) + @Record(value = ExecutionTime.RUNTIME_INIT) + void warnJvmInNative(JvmOnlyRecorder recorder) { + JvmOnlyRecorder.warnJvmInNative(LOG, FEATURE); // warn at build time + recorder.warnJvmInNative(FEATURE); // warn at runtime + } +} diff --git a/extensions-jvm/mybatis/integration-test/pom.xml b/extensions-jvm/mybatis/integration-test/pom.xml new file mode 100644 index 0000000..05c805a --- /dev/null +++ b/extensions-jvm/mybatis/integration-test/pom.xml @@ -0,0 +1,104 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!-- + + 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. + +--> +<project xmlns="http://maven.apache.org/POM/4.0.0" + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" + xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> + <modelVersion>4.0.0</modelVersion> + <parent> + <groupId>org.apache.camel.quarkus</groupId> + <artifactId>camel-quarkus-build-parent-it</artifactId> + <version>1.1.0-SNAPSHOT</version> + <relativePath>../../../poms/build-parent-it/pom.xml</relativePath> + </parent> + + <artifactId>camel-quarkus-mybatis-integration-test</artifactId> + <name>Camel Quarkus :: MyBatis :: Integration Test</name> + <description>Integration tests for Camel Quarkus MyBatis extension</description> + + <dependencyManagement> + <dependencies> + <dependency> + <groupId>org.apache.camel.quarkus</groupId> + <artifactId>camel-quarkus-bom-test</artifactId> + <version>${project.version}</version> + <type>pom</type> + <scope>import</scope> + </dependency> + </dependencies> + </dependencyManagement> + + <dependencies> + <dependency> + <groupId>org.apache.camel.quarkus</groupId> + <artifactId>camel-quarkus-mybatis</artifactId> + </dependency> + <dependency> + <groupId>io.quarkus</groupId> + <artifactId>quarkus-resteasy</artifactId> + </dependency> + <dependency> + <groupId>io.quarkus</groupId> + <artifactId>quarkus-jdbc-h2</artifactId> + </dependency> + + <!-- test dependencies --> + <dependency> + <groupId>io.quarkus</groupId> + <artifactId>quarkus-junit5</artifactId> + <scope>test</scope> + </dependency> + <dependency> + <groupId>io.rest-assured</groupId> + <artifactId>rest-assured</artifactId> + <scope>test</scope> + </dependency> + + <!-- The following dependencies guarantee that this module is built after them. You can update them by running `mvn process-resources -Pformat -N` from the source tree root directory --> + <dependency> + <groupId>org.apache.camel.quarkus</groupId> + <artifactId>camel-quarkus-mybatis-deployment</artifactId> + <version>${project.version}</version> + <type>pom</type> + <scope>test</scope> + <exclusions> + <exclusion> + <groupId>*</groupId> + <artifactId>*</artifactId> + </exclusion> + </exclusions> + </dependency> + </dependencies> + + <build> + <plugins> + <plugin> + <groupId>io.quarkus</groupId> + <artifactId>quarkus-maven-plugin</artifactId> + <executions> + <execution> + <goals> + <goal>build</goal> + </goals> + </execution> + </executions> + </plugin> + </plugins> + </build> +</project> diff --git a/extensions-jvm/mybatis/integration-test/src/main/java/org/apache/camel/quarkus/component/mybatis/it/MybatisResource.java b/extensions-jvm/mybatis/integration-test/src/main/java/org/apache/camel/quarkus/component/mybatis/it/MybatisResource.java new file mode 100644 index 0000000..0a22a20 --- /dev/null +++ b/extensions-jvm/mybatis/integration-test/src/main/java/org/apache/camel/quarkus/component/mybatis/it/MybatisResource.java @@ -0,0 +1,64 @@ +/* + * 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.quarkus.component.mybatis.it; + +import javax.enterprise.context.ApplicationScoped; +import javax.inject.Inject; +import javax.ws.rs.GET; +import javax.ws.rs.Path; +import javax.ws.rs.Produces; +import javax.ws.rs.core.MediaType; +import javax.ws.rs.core.Response; + +import org.apache.camel.CamelContext; +import org.jboss.logging.Logger; + +@Path("/mybatis") +@ApplicationScoped +public class MybatisResource { + + private static final Logger LOG = Logger.getLogger(MybatisResource.class); + + private static final String COMPONENT_MYBATIS = "mybatis"; + private static final String COMPONENT_MYBATIS_BEAN = "mybatis-bean"; + @Inject + CamelContext context; + + @Path("/load/component/mybatis") + @GET + @Produces(MediaType.TEXT_PLAIN) + public Response loadComponentMybatis() throws Exception { + /* This is an autogenerated test */ + if (context.getComponent(COMPONENT_MYBATIS) != null) { + return Response.ok().build(); + } + LOG.warnf("Could not load [%s] from the Camel context", COMPONENT_MYBATIS); + return Response.status(500, COMPONENT_MYBATIS + " could not be loaded from the Camel context").build(); + } + + @Path("/load/component/mybatis-bean") + @GET + @Produces(MediaType.TEXT_PLAIN) + public Response loadComponentMybatisBean() throws Exception { + /* This is an autogenerated test */ + if (context.getComponent(COMPONENT_MYBATIS_BEAN) != null) { + return Response.ok().build(); + } + LOG.warnf("Could not load [%s] from the Camel context", COMPONENT_MYBATIS_BEAN); + return Response.status(500, COMPONENT_MYBATIS_BEAN + " could not be loaded from the Camel context").build(); + } +} diff --git a/extensions-jvm/mybatis/integration-test/src/main/java/org/apache/camel/quarkus/component/mybatis/it/bean/AccountService.java b/extensions-jvm/mybatis/integration-test/src/main/java/org/apache/camel/quarkus/component/mybatis/it/bean/AccountService.java new file mode 100644 index 0000000..1f5c905 --- /dev/null +++ b/extensions-jvm/mybatis/integration-test/src/main/java/org/apache/camel/quarkus/component/mybatis/it/bean/AccountService.java @@ -0,0 +1,41 @@ +/* + * 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.quarkus.component.mybatis.it.bean; + +import java.util.List; + +import org.apache.camel.quarkus.component.mybatis.it.entity.Account; +import org.apache.ibatis.annotations.Insert; +import org.apache.ibatis.annotations.Param; +import org.apache.ibatis.annotations.ResultMap; +import org.apache.ibatis.annotations.Select; + +public interface AccountService { + + @Select("select ACC_ID as id, ACC_FIRST_NAME as firstName, ACC_LAST_NAME as lastName" + + ", ACC_EMAIL as emailAddress from ACCOUNT where ACC_ID = #{id}") + Account selectBeanAccountById(@Param("id") int no); + + @Select("select * from ACCOUNT order by ACC_ID") + @ResultMap("Account.AccountResult") + List<Account> selectBeanAllAccounts(); + + @Insert("insert into ACCOUNT (ACC_ID,ACC_FIRST_NAME,ACC_LAST_NAME,ACC_EMAIL)" + + " values (#{id}, #{firstName}, #{lastName}, #{emailAddress})") + void insertBeanAccount(Account account); + +} diff --git a/extensions-jvm/mybatis/integration-test/src/main/java/org/apache/camel/quarkus/component/mybatis/it/entity/Account.java b/extensions-jvm/mybatis/integration-test/src/main/java/org/apache/camel/quarkus/component/mybatis/it/entity/Account.java new file mode 100644 index 0000000..f086fd3 --- /dev/null +++ b/extensions-jvm/mybatis/integration-test/src/main/java/org/apache/camel/quarkus/component/mybatis/it/entity/Account.java @@ -0,0 +1,61 @@ +/* + * 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.quarkus.component.mybatis.it.entity; + +public class Account { + private int id; + private String firstName; + private String lastName; + private String emailAddress; + + @Override + public String toString() { + return "Account[id: " + id + " name: " + firstName + " " + lastName + " email: " + emailAddress + "]"; + } + + public int getId() { + return id; + } + + public void setId(int id) { + this.id = id; + } + + public String getFirstName() { + return firstName; + } + + public void setFirstName(String firstName) { + this.firstName = firstName; + } + + public String getLastName() { + return lastName; + } + + public void setLastName(String lastName) { + this.lastName = lastName; + } + + public String getEmailAddress() { + return emailAddress; + } + + public void setEmailAddress(String emailAddress) { + this.emailAddress = emailAddress; + } +} diff --git a/extensions-jvm/mybatis/integration-test/src/main/resources/SqlMapConfig.xml b/extensions-jvm/mybatis/integration-test/src/main/resources/SqlMapConfig.xml new file mode 100644 index 0000000..3ea2992 --- /dev/null +++ b/extensions-jvm/mybatis/integration-test/src/main/resources/SqlMapConfig.xml @@ -0,0 +1,55 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!-- + + 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. + +--> +<!DOCTYPE configuration + PUBLIC "-//mybatis.org//DTD Config 3.0//EN" + "http://mybatis.org/dtd/mybatis-3-config.dtd"> + +<configuration> + + <settings> + <setting name="useGeneratedKeys" value="false"/> + </settings> + + <!-- Use type aliases to avoid typing the full classname every time. --> + <typeAliases> + <typeAlias alias="Account" type="org.apache.camel.quarkus.component.mybatis.it.entity.Account"/> + <typeAlias alias="AccountService" type="org.apache.camel.quarkus.component.mybatis.it.bean.AccountService"/> + </typeAliases> + + <!-- setup environment with JDBC data source --> + <environments default="development"> + <environment id="development"> + <transactionManager type="JDBC"/> + <dataSource type="POOLED"> + <property name="driver" value="org.h2.Driver" /> + <property name="url" value="jdbc:h2:database/h2db" /> + <property name="username" value="root" /> + <property name="password" value="" /> + </dataSource> + </environment> + </environments> + + <!-- mapping files --> + <mappers> + <mapper resource="org/apache/camel/quarkus/component/mybatis/it/entity/Account.xml"/> + <package name="org.apache.camel.quarkus.component.mybatis.it.bean"/> + </mappers> + +</configuration> \ No newline at end of file diff --git a/extensions-jvm/mybatis/integration-test/src/main/resources/org/apache/camel/quarkus/component/mybatis/it/entity/Account.xml b/extensions-jvm/mybatis/integration-test/src/main/resources/org/apache/camel/quarkus/component/mybatis/it/entity/Account.xml new file mode 100644 index 0000000..207064d --- /dev/null +++ b/extensions-jvm/mybatis/integration-test/src/main/resources/org/apache/camel/quarkus/component/mybatis/it/entity/Account.xml @@ -0,0 +1,138 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!-- + + 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. + +--> +<!DOCTYPE mapper + PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" + "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> + +<mapper namespace="Account"> + + <!-- Result maps describe the mapping between the columns returned + from a query, and the class properties. A result map isn't + necessary if the columns (or aliases) match to the properties + exactly. --> + <resultMap id="AccountResult" type="Account"> + <result property="id" column="ACC_ID"/> + <result property="firstName" column="ACC_FIRST_NAME"/> + <result property="lastName" column="ACC_LAST_NAME"/> + <result property="emailAddress" column="ACC_EMAIL"/> + </resultMap> + + <!-- Select with no parameters using the result map for Account class. --> + <select id="selectAllAccounts" resultMap="AccountResult"> + select * from ACCOUNT order by ACC_ID + </select> + + <!-- A simpler select example without the result map. Note the +aliases to match the properties of the target result class. --> + <select id="selectAccountById" parameterType="int" resultType="Account"> + select + ACC_ID as id, + ACC_FIRST_NAME as firstName, + ACC_LAST_NAME as lastName, + ACC_EMAIL as emailAddress + from ACCOUNT + where ACC_ID = #{id} + </select> + + <!-- Insert example, using the Account parameter class --> + <insert id="insertAccount" parameterType="Account"> + insert into ACCOUNT ( + ACC_ID, + ACC_FIRST_NAME, + ACC_LAST_NAME, + ACC_EMAIL + ) + values ( + #{id}, #{firstName}, #{lastName}, #{emailAddress} + ) + </insert> + + <!-- START SNIPPET: insertList --> + <!-- Batch Insert example, using the Account parameter class --> + <insert id="batchInsertAccount" parameterType="java.util.List"> + insert into ACCOUNT ( + ACC_ID, + ACC_FIRST_NAME, + ACC_LAST_NAME, + ACC_EMAIL + ) + values ( + <foreach item="Account" collection="list" open="" close="" separator="),("> + #{Account.id}, #{Account.firstName}, #{Account.lastName}, #{Account.emailAddress} + </foreach> + ) + </insert> + <!-- END SNIPPET: insertList --> + + <!-- Update example, using the Account parameter class --> + <update id="updateAccount" parameterType="Account"> + update ACCOUNT set + ACC_FIRST_NAME = #{firstName}, + ACC_LAST_NAME = #{lastName}, + ACC_EMAIL = #{emailAddress} + where + ACC_ID = #{id} + </update> + + <update id="batchUpdateAccount" parameterType="java.util.Map"> + update ACCOUNT set + ACC_EMAIL = #{emailAddress} + where + ACC_ID in + <foreach item="Account" collection="list" open="(" close=")" separator=","> + #{Account.id} + </foreach> + </update> + + <!-- Delete example, using an integer as the parameter class --> + <delete id="deleteAccountById" parameterType="int"> + delete from ACCOUNT where ACC_ID = #{id} + </delete> + + <delete id="batchDeleteAccountById" parameterType="java.util.List"> + delete from ACCOUNT + where + ACC_ID in + <foreach item="AccountID" collection="list" open="(" close=")" separator=","> + #{AccountID} + </foreach> + </delete> + + <!-- START SNIPPET: e1 --> + <select id="selectUnprocessedAccounts" resultMap="AccountResult"> + select * from ACCOUNT where PROCESSED = false + </select> + <!-- END SNIPPET: e1 --> + + <select id="selectProcessedAccounts" resultMap="AccountResult"> + select * from ACCOUNT where PROCESSED = true + </select> + + <!-- START SNIPPET: e2 --> + <update id="consumeAccount" parameterType="Account"> + update ACCOUNT set PROCESSED = true where ACC_ID = #{id} + </update> + <!-- END SNIPPET: e2 --> + + <select id="count" resultType="int"> + select count(*) from ACCOUNT + </select> + +</mapper> diff --git a/extensions-jvm/mybatis/integration-test/src/test/java/org/apache/camel/quarkus/component/mybatis/it/MybatisTest.java b/extensions-jvm/mybatis/integration-test/src/test/java/org/apache/camel/quarkus/component/mybatis/it/MybatisTest.java new file mode 100644 index 0000000..6dda833 --- /dev/null +++ b/extensions-jvm/mybatis/integration-test/src/test/java/org/apache/camel/quarkus/component/mybatis/it/MybatisTest.java @@ -0,0 +1,42 @@ +/* + * 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.quarkus.component.mybatis.it; + +import io.quarkus.test.junit.QuarkusTest; +import io.restassured.RestAssured; +import org.junit.jupiter.api.Test; + +@QuarkusTest +class MybatisTest { + + @Test + public void loadComponentMybatis() { + /* A simple autogenerated test */ + RestAssured.get("/mybatis/load/component/mybatis") + .then() + .statusCode(200); + } + + @Test + public void loadComponentMybatisBean() { + /* A simple autogenerated test */ + RestAssured.get("/mybatis/load/component/mybatis-bean") + .then() + .statusCode(200); + } + +} diff --git a/extensions-jvm/mybatis/pom.xml b/extensions-jvm/mybatis/pom.xml new file mode 100644 index 0000000..3825318 --- /dev/null +++ b/extensions-jvm/mybatis/pom.xml @@ -0,0 +1,40 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!-- + + 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. + +--> +<project xmlns="http://maven.apache.org/POM/4.0.0" + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" + xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> + <modelVersion>4.0.0</modelVersion> + <parent> + <groupId>org.apache.camel.quarkus</groupId> + <artifactId>camel-quarkus-build-parent</artifactId> + <version>1.1.0-SNAPSHOT</version> + <relativePath>../../poms/build-parent/pom.xml</relativePath> + </parent> + + <artifactId>camel-quarkus-mybatis-parent</artifactId> + <name>Camel Quarkus :: MyBatis</name> + <packaging>pom</packaging> + + <modules> + <module>deployment</module> + <module>runtime</module> + <module>integration-test</module> + </modules> +</project> diff --git a/extensions-jvm/mybatis/runtime/pom.xml b/extensions-jvm/mybatis/runtime/pom.xml new file mode 100644 index 0000000..4d0a945 --- /dev/null +++ b/extensions-jvm/mybatis/runtime/pom.xml @@ -0,0 +1,94 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!-- + + 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. + +--> +<project xmlns="http://maven.apache.org/POM/4.0.0" + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" + xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> + <modelVersion>4.0.0</modelVersion> + <parent> + <groupId>org.apache.camel.quarkus</groupId> + <artifactId>camel-quarkus-mybatis-parent</artifactId> + <version>1.1.0-SNAPSHOT</version> + <relativePath>../pom.xml</relativePath> + </parent> + + <artifactId>camel-quarkus-mybatis</artifactId> + <name>Camel Quarkus :: MyBatis :: Runtime</name> + <description>Performs a query, poll, insert, update or delete in a relational database using MyBatis.</description> + + <properties> + <firstVersion>1.1.0</firstVersion> + </properties> + + <dependencyManagement> + <dependencies> + <dependency> + <groupId>org.apache.camel.quarkus</groupId> + <artifactId>camel-quarkus-bom</artifactId> + <version>${project.version}</version> + <type>pom</type> + <scope>import</scope> + </dependency> + </dependencies> + </dependencyManagement> + + <dependencies> + <dependency> + <groupId>org.apache.camel.quarkus</groupId> + <artifactId>camel-quarkus-core</artifactId> + </dependency> + <dependency> + <groupId>org.apache.camel</groupId> + <artifactId>camel-mybatis</artifactId> + </dependency> + </dependencies> + + <build> + <plugins> + <plugin> + <groupId>org.apache.camel.quarkus</groupId> + <artifactId>camel-quarkus-maven-plugin</artifactId> + <executions> + <execution> + <id>update-extension-doc-page</id> + <goals><goal>update-extension-doc-page</goal></goals> + <phase>process-classes</phase> + </execution> + </executions> + </plugin> + <plugin> + <groupId>io.quarkus</groupId> + <artifactId>quarkus-bootstrap-maven-plugin</artifactId> + </plugin> + <plugin> + <groupId>org.apache.maven.plugins</groupId> + <artifactId>maven-compiler-plugin</artifactId> + <configuration> + <annotationProcessorPaths> + <path> + <groupId>io.quarkus</groupId> + <artifactId>quarkus-extension-processor</artifactId> + <version>${quarkus.version}</version> + </path> + </annotationProcessorPaths> + </configuration> + </plugin> + </plugins> + </build> +</project> diff --git a/extensions-jvm/mybatis/runtime/src/main/resources/META-INF/quarkus-extension.yaml b/extensions-jvm/mybatis/runtime/src/main/resources/META-INF/quarkus-extension.yaml new file mode 100644 index 0000000..bfefcd0 --- /dev/null +++ b/extensions-jvm/mybatis/runtime/src/main/resources/META-INF/quarkus-extension.yaml @@ -0,0 +1,32 @@ +# +# 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. +# + +# This is a generated file. Do not edit directly! +# To re-generate, run the following command from the top level directory: +# +# mvn -N cq:update-quarkus-metadata +# +--- +name: "Camel MyBatis" +description: "Performs a query, poll, insert, update or delete in a relational database using MyBatis" +metadata: + unlisted: true + guide: "https://camel.apache.org/camel-quarkus/latest/reference/extensions/mybatis.html" + categories: + - "integration" + status: + - "preview" diff --git a/extensions-jvm/pom.xml b/extensions-jvm/pom.xml index 33bce27..58bcb9c 100644 --- a/extensions-jvm/pom.xml +++ b/extensions-jvm/pom.xml @@ -88,6 +88,7 @@ <module>jbpm</module> <module>jooq</module> <module>jsch</module> + <module>mybatis</module> <module>nagios</module> <module>nitrite</module> <module>nsq</module> diff --git a/poms/bom/pom.xml b/poms/bom/pom.xml index ea2708a..384c6bb 100644 --- a/poms/bom/pom.xml +++ b/poms/bom/pom.xml @@ -1219,6 +1219,11 @@ </dependency> <dependency> <groupId>org.apache.camel</groupId> + <artifactId>camel-mybatis</artifactId> + <version>${camel.version}</version> + </dependency> + <dependency> + <groupId>org.apache.camel</groupId> <artifactId>camel-nagios</artifactId> <version>${camel.version}</version> </dependency> @@ -3406,6 +3411,16 @@ </dependency> <dependency> <groupId>org.apache.camel.quarkus</groupId> + <artifactId>camel-quarkus-mybatis</artifactId> + <version>${camel-quarkus.version}</version> + </dependency> + <dependency> + <groupId>org.apache.camel.quarkus</groupId> + <artifactId>camel-quarkus-mybatis-deployment</artifactId> + <version>${camel-quarkus.version}</version> + </dependency> + <dependency> + <groupId>org.apache.camel.quarkus</groupId> <artifactId>camel-quarkus-nagios</artifactId> <version>${camel-quarkus.version}</version> </dependency>