You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@camel.apache.org by ac...@apache.org on 2021/06/18 12:43:28 UTC
[camel-kamelets] branch mariadb-source created (now da9232f)
This is an automated email from the ASF dual-hosted git repository.
acosentino pushed a change to branch mariadb-source
in repository https://gitbox.apache.org/repos/asf/camel-kamelets.git.
at da9232f Added MariaDB Source Kamelet
This branch includes the following new commits:
new cee62e1 Added MariaDB Source Kamelet
new fb7b0c0 Added MariaDB Source Kamelet
new e4d43a3 Added MariaDB Source Kamelet
new da9232f Added MariaDB Source Kamelet
The 4 revisions listed above as "new" are entirely new to this
repository and will be described in separate emails. The revisions
listed as "add" were already present in the repository and have only
been added to this reference.
[camel-kamelets] 01/04: Added MariaDB Source Kamelet
Posted by ac...@apache.org.
This is an automated email from the ASF dual-hosted git repository.
acosentino pushed a commit to branch mariadb-source
in repository https://gitbox.apache.org/repos/asf/camel-kamelets.git
commit cee62e17b86154bcace2c735e6d94c3cc9c1eda8
Author: Andrea Cosentino <an...@gmail.com>
AuthorDate: Fri Jun 18 14:36:22 2021 +0200
Added MariaDB Source Kamelet
---
mariadb-source.kamelet.yaml | 95 +++++++++++++++++++++++++++++++++++++++++++++
1 file changed, 95 insertions(+)
diff --git a/mariadb-source.kamelet.yaml b/mariadb-source.kamelet.yaml
new file mode 100644
index 0000000..25f667f
--- /dev/null
+++ b/mariadb-source.kamelet.yaml
@@ -0,0 +1,95 @@
+apiVersion: camel.apache.org/v1alpha1
+kind: Kamelet
+metadata:
+ name: mariadb-source
+ annotations:
+ camel.apache.org/kamelet.support.level: "Preview"
+ camel.apache.org/catalog.version: "main-SNAPSHOT"
+ camel.apache.org/kamelet.icon: "data:image/svg+xml;base64,PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4KPHN2ZyBoZWlnaHQ9IjExOC4xIiB2aWV3Qm94PSIwLDAsNDE2LjQsMTE4LjEiIHdpZHRoPSI0MTYuNCIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIj4KIDxtZXRhZGF0YS8+CiA8c3dpdGNoIHRyYW5zZm9ybT0idHJhbnNsYXRlKC0yMy45MSAtMjMuOTUpIj4KICA8Zm9yZWlnbk9iamVjdCBoZWlnaHQ9IjEiIHJlcXVpcmVkRXh0ZW5zaW9ucz0iaHR0cDovL25zLmFkb2JlLmNvbS9BZG9iZUlsbHVzdHJhdG9yLzEwLjAvIiB3aWR0aD0iMSIvPgogIDxnPgogICA8ZyB0cmFuc2Zvcm09In [...]
+ camel.apache.org/provider: "Apache Software Foundation"
+ camel.apache.org/kamelet.group: "SQL"
+ labels:
+ camel.apache.org/kamelet.type: "source"
+spec:
+ definition:
+ title: "MariaDB Source"
+ description: |-
+ Query data from a MariaDB Database.
+
+ In you KameletBinding file you'll need to explicitly declare the SQL Server driver dependency in spec->integration->dependencies
+
+ - "mvn:org.mariadb.jdbc:mariadb-java-client:<version>"
+ required:
+ - serverName
+ - username
+ - password
+ - query
+ - databaseName
+ type: object
+ properties:
+ serverName:
+ title: Server Name
+ description: Server Name for the data source
+ type: string
+ example: localhost
+ port:
+ title: Port
+ description: Server Port for the data source
+ type: string
+ default: 3306
+ username:
+ title: Username
+ description: The username to use for accessing a secured MariaDB Database
+ type: string
+ password:
+ title: Password
+ description: The password to use for accessing a secured MariaDB Database
+ type: string
+ format: password
+ x-descriptors:
+ - urn:alm:descriptor:com.tectonic.ui:password
+ query:
+ title: Query
+ description: The Query to execute against the MariaDB Database
+ type: string
+ example: 'INSERT INTO accounts (username,city) VALUES (:#username,:#city)'
+ databaseName:
+ title: Database Name
+ description: The Database Name we are pointing
+ type: string
+ consumedQuery:
+ title: Consumed Query
+ description: A query to run on a tuple consumed
+ type: string
+ example: 'DELETE FROM accounts where user_id = :#user_id'
+ types:
+ in:
+ mediaType: application/json
+ dependencies:
+ - "camel:jackson"
+ - "camel:kamelet"
+ - "camel:sql"
+ - "mvn:org.apache.commons:commons-dbcp2:2.8.0"
+ flow:
+ beans:
+ - name: dsBean
+ type: "#class:org.apache.commons.dbcp2.BasicDataSource"
+ property:
+ - key: username
+ value: '{{username}}'
+ - key: password
+ value: '{{password}}'
+ - key: url
+ value: 'jdbc:mariadb://{{serverName}}:{{port}}/{{databaseName}}'
+ - key: driverClassName
+ value: 'org.mariadb.jdbc.Driver'
+ from:
+ uri: "sql:{{query}}"
+ parameters:
+ dataSource: "#bean:{{dsBean}}"
+ onConsume: "{{?consumedQuery}}"
+ steps:
+ - marshal:
+ json:
+ library: Jackson
+ - to: "kamelet:sink"
[camel-kamelets] 03/04: Added MariaDB Source Kamelet
Posted by ac...@apache.org.
This is an automated email from the ASF dual-hosted git repository.
acosentino pushed a commit to branch mariadb-source
in repository https://gitbox.apache.org/repos/asf/camel-kamelets.git
commit e4d43a344b7484379aa286f6f59bca873966d0eb
Author: Andrea Cosentino <an...@gmail.com>
AuthorDate: Fri Jun 18 14:39:08 2021 +0200
Added MariaDB Source Kamelet
---
docs/modules/ROOT/nav.adoc | 1 +
1 file changed, 1 insertion(+)
diff --git a/docs/modules/ROOT/nav.adoc b/docs/modules/ROOT/nav.adoc
index c5666e0..6e7c245 100644
--- a/docs/modules/ROOT/nav.adoc
+++ b/docs/modules/ROOT/nav.adoc
@@ -74,6 +74,7 @@
* xref:ROOT:kafka-source.adoc[image:kamelets/kafka-source.svg[] Kafka Source]
* xref:ROOT:mail-imap-source.adoc[image:kamelets/mail-imap-source.svg[] Mail IMAP Source]
* xref:ROOT:mariadb-sink.adoc[image:kamelets/mariadb-sink.svg[] MariaDB Sink]
+* xref:ROOT:mariadb-source.adoc[image:kamelets/mariadb-source.svg[] MariaDB Source]
* xref:ROOT:mask-field-action.adoc[image:kamelets/mask-field-action.svg[] Mask Fields Action]
* xref:ROOT:message-timestamp-router-action.adoc[image:kamelets/message-timestamp-router-action.svg[] Message Timestamp Router Action]
* xref:ROOT:minio-sink.adoc[image:kamelets/minio-sink.svg[] Minio Sink]
[camel-kamelets] 04/04: Added MariaDB Source Kamelet
Posted by ac...@apache.org.
This is an automated email from the ASF dual-hosted git repository.
acosentino pushed a commit to branch mariadb-source
in repository https://gitbox.apache.org/repos/asf/camel-kamelets.git
commit da9232f2cb6c68307a9d8f7a8a17914879e64d64
Author: Andrea Cosentino <an...@gmail.com>
AuthorDate: Fri Jun 18 14:39:20 2021 +0200
Added MariaDB Source Kamelet
---
.../ROOT/assets/images/kamelets/mariadb-source.svg | 25 +++++++
docs/modules/ROOT/pages/mariadb-source.adoc | 76 ++++++++++++++++++++++
2 files changed, 101 insertions(+)
diff --git a/docs/modules/ROOT/assets/images/kamelets/mariadb-source.svg b/docs/modules/ROOT/assets/images/kamelets/mariadb-source.svg
new file mode 100644
index 0000000..eefbeae
--- /dev/null
+++ b/docs/modules/ROOT/assets/images/kamelets/mariadb-source.svg
@@ -0,0 +1,25 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<svg height="118.1" viewBox="0,0,416.4,118.1" width="416.4" xmlns="http://www.w3.org/2000/svg">
+ <metadata/>
+ <switch transform="translate(-23.91 -23.95)">
+ <foreignObject height="1" requiredExtensions="http://ns.adobe.com/AdobeIllustrator/10.0/" width="1"/>
+ <g>
+ <g transform="translate(-1614 -14.18)">
+ <path clip-rule="evenodd" d="m1812 38.13c-2.73.09-1.94 1.32-7.85 2.78-5.97 1.47-13.19.57-19.61 3.27-16.8 7.04-19.52 34.26-39.53 44.79-13.12 7.41-26.5 9.11-38.46 12.86-9.6 3.85-15.57 6.4-22.61 12.47-5.46 4.71-6.79 9.28-12.5 15.19-5.79 7.87-27.74.88-33.39 10.75 2.98 1.93 4.7 2.46 9.93 1.77-1.08 2.05-7.96 4.75-6.71 7.77 0 0 16.63 3.03 30.65-5.43 6.54-2.66 12.67-8.29 22.83-9.64 13.16-1.75 27.99 2.76 43.9 4.03-3.29 6.5-6.68 10.34-10.31 15.7-1.12 1.21.96 2.28 4.82 1.55 6.94-1.72 11.97-3.58 [...]
+ <path d="m1643 148.4c10.31.31 13.11.04 21.26-3.5 6.93-3.01 16.2-11.12 24.39-13.74 12.02-3.86 24.91-3.28 37.7-1.77 4.28.51 8.58 1.22 11.65.89 4.79-2.94 5.02-10.92 7.99-11.56-.81 15.44-7.43 25.32-14.05 34.28 13.95-2.46 23.27-11.17 28.91-21.95 1.71-3.27 4.55-8.62 5.85-12.3 1.03 2.44-1.34 3.99-.23 6.65 8.98-7.41 13.22-15.85 16.86-28.21 4.22-14.3 8.55-26.59 11.27-30.82 2.65-4.13 6.78-6.68 10.55-9.32 4.28-3.01 8.11-6.14 8.77-11.87-4.52-.42-5.56-1.46-6.23-3.74-2.26 1.27-4.34 1.55-6.69 1.62- [...]
+ <path clip-rule="evenodd" d="m1787 52.65c3.2 2.78 9.92.55 8.72-4.98-4.98-.42-7.86 1.27-8.72 4.98z" fill="#1f305f" fill-rule="evenodd"/>
+ <path d="m1809 46.18c-.85 1.79-2.48 4.09-2.48 8.64-.01.78-.59 1.32-.6.11.04-4.45 1.22-6.37 2.47-8.89.57-1.03.92-.61.61.14z" fill="#1f305f"/>
+ <path d="m1808 45.51c-1.01 1.7-3.43 4.81-3.82 9.35-.07.78-.71 1.26-.61.06.44-4.42 2.37-7.19 3.84-9.6.66-.98.97-.53.59.19z" fill="#1f305f"/>
+ <path d="m1807 44.62c-1.15 1.61-4.87 5.35-5.65 9.83-.14.77-.81 1.19-.61.01.81-4.37 4.02-7.81 5.68-10.08.74-.93 1.02-.45.58.24z" fill="#1f305f"/>
+ <path d="m1807 43.62c-1.36 1.44-5.8 6.2-7.2 10.53-.25.74-.97 1.07-.61-.08 1.41-4.22 5.3-8.76 7.27-10.77.87-.81 1.07-.29.54.32z" fill="#1f305f"/>
+ </g>
+ <path d="m449.7-19.44v31.22h-3.94v-5.35c-3.57 4.27-7.64 6.41-12.23 6.41s-8.47-1.63-11.64-4.88c-3.14-3.29-4.7-7.19-4.7-11.7 0-4.55 1.59-8.43 4.76-11.64 3.17-3.25 6.98-4.88 11.41-4.88 5.1 0 9.23 2.18 12.41 6.53v-5.7h3.93m-3.7 15.74c0-3.57-1.2-6.57-3.59-9-2.39-2.47-5.33-3.7-8.82-3.7-3.45 0-6.37 1.27-8.76 3.82-2.39 2.51-3.59 5.49-3.59 8.94s1.22 6.45 3.65 9c2.43 2.51 5.33 3.76 8.7 3.76 3.41 0 6.33-1.22 8.76-3.65 2.44-2.42 3.65-5.48 3.65-9.17" fill="#1f305f" transform="translate(-83.07 92.55)"/>
+ <path d="m458.4 11.78v-42.21h8.76c6 0 10.39.45 13.17 1.35 2.82.86 5.25 2.25 7.29 4.17 2.04 1.88 3.61 4.19 4.7 6.94 1.1 2.74 1.65 5.96 1.65 9.64 0 3.65-.86 7.09-2.59 10.35-1.69 3.21-4 5.64-6.94 7.29-2.9 1.65-7.09 2.47-12.58 2.47zm4.06-4h4.88c5.1 0 8.78-.25 11.05-.76 2.31-.51 4.33-1.51 6.06-3 1.72-1.53 3.04-3.37 3.94-5.53s1.35-4.62 1.35-7.41c0-2.78-.53-5.35-1.59-7.7-1.02-2.35-2.49-4.29-4.41-5.82s-4.19-2.55-6.82-3.06c-2.59-.55-6.41-.82-11.46-.82h-3z" fill="#1f305f" transform="translate(- [...]
+ <path d="m406-28.14c0-.9.31-1.69.94-2.35.67-.67 1.45-1 2.35-1 .94 0 1.72.33 2.35 1 .67.63 1 1.41 1 2.35 0 .9-.33 1.69-1 2.35-.63.63-1.41.94-2.35.94-.9 0-1.69-.33-2.35-1-.63-.67-.94-1.43-.94-2.29m1.29 8.7h4.06v31.22h-4.06z" fill="#1f305f" transform="translate(-83.82 92.55)"/>
+ <path d="m296.7 11.78 6-42.21h.65l17.16 34.62 17.05-34.63h.65l6.06 42.21h-4.17l-4.12-30.22-14.93 30.22h-1.06l-15.11-30.45-4.12 30.45h-4.06" fill="#1f305f" transform="translate(-84.33 92.55)"/>
+ <path d="m381.1-19.44v31.22h-3.94v-5.35c-3.57 4.27-7.64 6.41-12.23 6.41s-8.47-1.63-11.64-4.88c-3.14-3.29-4.7-7.19-4.7-11.7 0-4.55 1.59-8.43 4.76-11.64 3.17-3.25 6.98-4.88 11.41-4.88 5.1 0 9.23 2.18 12.41 6.53v-5.7h3.93m-3.7 15.74c0-3.57-1.2-6.57-3.59-9-2.39-2.47-5.33-3.7-8.82-3.7-3.45 0-6.37 1.27-8.76 3.82-2.39 2.51-3.59 5.49-3.59 8.94s1.21 6.45 3.65 9c2.43 2.51 5.33 3.76 8.7 3.76 3.41 0 6.33-1.22 8.76-3.65 2.43-2.42 3.65-5.48 3.65-9.17" fill="#1f305f" transform="translate(-84.58 92.55)"/>
+ <path d="m388.7-19.44h4.12v4.53c1.1-1.84 2.16-3.19 3.17-4.06 1.06-.86 2.21-1.29 3.47-1.29 1.29 0 2.59.35 3.88 1.06l-2.12 3.41c-.59-.35-1.2-.53-1.82-.53-1.21 0-2.37.63-3.47 1.88-1.06 1.25-1.84 2.88-2.35 4.88-.51 1.96-.76 5.55-.76 10.76v10.58h-4.12z" fill="#1f305f" transform="translate(-85.34 92.55)"/>
+ <path d="m498.3-30.44h8.35c4.43 0 7.78.9 10.05 2.7 2.31 1.76 3.47 4.31 3.47 7.64 0 1.84-.47 3.55-1.41 5.11-.9 1.53-2.23 2.76-4 3.7 2.9.94 5.1 2.35 6.58 4.23 1.53 1.88 2.29 4.12 2.29 6.7 0 3.49-1.27 6.39-3.82 8.7-2.55 2.27-5.84 3.41-9.88 3.41h-11.63zm4.17 4.12v13.52h2.41c3.68 0 6.43-.59 8.23-1.76 1.8-1.18 2.7-3.02 2.7-5.53 0-4.15-2.82-6.23-8.47-6.23zm0 17.76v16.22h5.23c3.02 0 5.23-.29 6.64-.88 1.45-.63 2.63-1.57 3.53-2.82.9-1.29 1.35-2.61 1.35-3.94s-.25-2.51-.76-3.53-1.27-1.92-2.29-2.7 [...]
+ </g>
+ </switch>
+</svg>
diff --git a/docs/modules/ROOT/pages/mariadb-source.adoc b/docs/modules/ROOT/pages/mariadb-source.adoc
new file mode 100644
index 0000000..14e34f9
--- /dev/null
+++ b/docs/modules/ROOT/pages/mariadb-source.adoc
@@ -0,0 +1,76 @@
+// THIS FILE IS AUTOMATICALLY GENERATED: DO NOT EDIT
+= image:kamelets/mariadb-source.svg[] MariaDB Source
+
+*Provided by: "Apache Software Foundation"*
+
+*Support Level for this Kamelet is: "Preview"*
+
+Query data from a MariaDB Database.
+
+In you KameletBinding file you'll need to explicitly declare the SQL Server driver dependency in spec->integration->dependencies
+
+- "mvn:org.mariadb.jdbc:mariadb-java-client:<version>"
+
+== Configuration Options
+
+The following table summarizes the configuration options available for the `mariadb-source` Kamelet:
+[width="100%",cols="2,^2,3,^2,^2,^3",options="header"]
+|===
+| Property| Name| Description| Type| Default| Example
+| *databaseName {empty}* *| Database Name| The Database Name we are pointing| string| |
+| *password {empty}* *| Password| The password to use for accessing a secured MariaDB Database| string| |
+| *query {empty}* *| Query| The Query to execute against the MariaDB Database| string| | `"INSERT INTO accounts (username,city) VALUES (:#username,:#city)"`
+| *serverName {empty}* *| Server Name| Server Name for the data source| string| | `"localhost"`
+| *username {empty}* *| Username| The username to use for accessing a secured MariaDB Database| string| |
+| consumedQuery| Consumed Query| A query to run on a tuple consumed| string| | `"DELETE FROM accounts where user_id = :#user_id"`
+| port| Port| Server Port for the data source| string| `3306`|
+|===
+
+NOTE: Fields marked with ({empty}*) are mandatory.
+
+== Usage
+
+This section summarizes how the `mariadb-source` can be used in various contexts.
+
+=== Knative Source
+
+The `mariadb-source` Kamelet can be used as Knative source by binding it to a Knative object.
+
+.mariadb-source-binding.yaml
+[source,yaml]
+----
+apiVersion: camel.apache.org/v1alpha1
+kind: KameletBinding
+metadata:
+ name: mariadb-source-binding
+spec:
+ source:
+ ref:
+ kind: Kamelet
+ apiVersion: camel.apache.org/v1alpha1
+ name: mariadb-source
+ properties:
+ databaseName: "The Database Name"
+ password: "The Password"
+ query: "INSERT INTO accounts (username,city) VALUES (:#username,:#city)"
+ serverName: "localhost"
+ username: "The Username"
+ sink:
+ ref:
+ kind: InMemoryChannel
+ apiVersion: messaging.knative.dev/v1
+ name: mychannel
+
+----
+
+Make sure you have xref:latest@camel-k::installation/installation.adoc[Camel K installed] into the Kubernetes cluster you're connected to.
+
+Save the `mariadb-source-binding.yaml` file into your hard drive, then configure it according to your needs.
+
+You can run the source using the following command:
+
+[source,shell]
+----
+kubectl apply -f mariadb-source-binding.yaml
+----
+// THIS FILE IS AUTOMATICALLY GENERATED: DO NOT EDIT
[camel-kamelets] 02/04: Added MariaDB Source Kamelet
Posted by ac...@apache.org.
This is an automated email from the ASF dual-hosted git repository.
acosentino pushed a commit to branch mariadb-source
in repository https://gitbox.apache.org/repos/asf/camel-kamelets.git
commit fb7b0c0c174bb0a3de0d026c3c223d2ed9c3ca3a
Author: Andrea Cosentino <an...@gmail.com>
AuthorDate: Fri Jun 18 14:37:34 2021 +0200
Added MariaDB Source Kamelet
---
.../resources/kamelets/mariadb-source.kamelet.yaml | 95 ++++++++++++++++++++++
1 file changed, 95 insertions(+)
diff --git a/library/camel-kamelets-catalog/src/main/resources/kamelets/mariadb-source.kamelet.yaml b/library/camel-kamelets-catalog/src/main/resources/kamelets/mariadb-source.kamelet.yaml
new file mode 100644
index 0000000..25f667f
--- /dev/null
+++ b/library/camel-kamelets-catalog/src/main/resources/kamelets/mariadb-source.kamelet.yaml
@@ -0,0 +1,95 @@
+apiVersion: camel.apache.org/v1alpha1
+kind: Kamelet
+metadata:
+ name: mariadb-source
+ annotations:
+ camel.apache.org/kamelet.support.level: "Preview"
+ camel.apache.org/catalog.version: "main-SNAPSHOT"
+ camel.apache.org/kamelet.icon: "data:image/svg+xml;base64,PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4KPHN2ZyBoZWlnaHQ9IjExOC4xIiB2aWV3Qm94PSIwLDAsNDE2LjQsMTE4LjEiIHdpZHRoPSI0MTYuNCIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIj4KIDxtZXRhZGF0YS8+CiA8c3dpdGNoIHRyYW5zZm9ybT0idHJhbnNsYXRlKC0yMy45MSAtMjMuOTUpIj4KICA8Zm9yZWlnbk9iamVjdCBoZWlnaHQ9IjEiIHJlcXVpcmVkRXh0ZW5zaW9ucz0iaHR0cDovL25zLmFkb2JlLmNvbS9BZG9iZUlsbHVzdHJhdG9yLzEwLjAvIiB3aWR0aD0iMSIvPgogIDxnPgogICA8ZyB0cmFuc2Zvcm09In [...]
+ camel.apache.org/provider: "Apache Software Foundation"
+ camel.apache.org/kamelet.group: "SQL"
+ labels:
+ camel.apache.org/kamelet.type: "source"
+spec:
+ definition:
+ title: "MariaDB Source"
+ description: |-
+ Query data from a MariaDB Database.
+
+ In you KameletBinding file you'll need to explicitly declare the SQL Server driver dependency in spec->integration->dependencies
+
+ - "mvn:org.mariadb.jdbc:mariadb-java-client:<version>"
+ required:
+ - serverName
+ - username
+ - password
+ - query
+ - databaseName
+ type: object
+ properties:
+ serverName:
+ title: Server Name
+ description: Server Name for the data source
+ type: string
+ example: localhost
+ port:
+ title: Port
+ description: Server Port for the data source
+ type: string
+ default: 3306
+ username:
+ title: Username
+ description: The username to use for accessing a secured MariaDB Database
+ type: string
+ password:
+ title: Password
+ description: The password to use for accessing a secured MariaDB Database
+ type: string
+ format: password
+ x-descriptors:
+ - urn:alm:descriptor:com.tectonic.ui:password
+ query:
+ title: Query
+ description: The Query to execute against the MariaDB Database
+ type: string
+ example: 'INSERT INTO accounts (username,city) VALUES (:#username,:#city)'
+ databaseName:
+ title: Database Name
+ description: The Database Name we are pointing
+ type: string
+ consumedQuery:
+ title: Consumed Query
+ description: A query to run on a tuple consumed
+ type: string
+ example: 'DELETE FROM accounts where user_id = :#user_id'
+ types:
+ in:
+ mediaType: application/json
+ dependencies:
+ - "camel:jackson"
+ - "camel:kamelet"
+ - "camel:sql"
+ - "mvn:org.apache.commons:commons-dbcp2:2.8.0"
+ flow:
+ beans:
+ - name: dsBean
+ type: "#class:org.apache.commons.dbcp2.BasicDataSource"
+ property:
+ - key: username
+ value: '{{username}}'
+ - key: password
+ value: '{{password}}'
+ - key: url
+ value: 'jdbc:mariadb://{{serverName}}:{{port}}/{{databaseName}}'
+ - key: driverClassName
+ value: 'org.mariadb.jdbc.Driver'
+ from:
+ uri: "sql:{{query}}"
+ parameters:
+ dataSource: "#bean:{{dsBean}}"
+ onConsume: "{{?consumedQuery}}"
+ steps:
+ - marshal:
+ json:
+ library: Jackson
+ - to: "kamelet:sink"