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 <[email protected]> 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
