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/14 13:10:48 UTC
[camel-kamelets] branch main updated (39742ca -> 6eec084)
This is an automated email from the ASF dual-hosted git repository.
acosentino pushed a change to branch main
in repository https://gitbox.apache.org/repos/asf/camel-kamelets.git.
from 39742ca PostgreSQL Sink Kamelet Fixed description and more information
new 34104e4 MySQL Sink Kamelet Fixed description and more information
new c828234 MySQL Sink Kamelet Fixed description and more information
new fec6c4c MySQL Sink Kamelet Fixed description and more information
new 6eec084 MySQL Sink Kamelet Fixed description and more information
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.
Summary of changes:
docs/modules/ROOT/pages/mysql-sink.adoc | 18 +++++++++++++-----
.../main/resources/kamelets/mysql-sink.kamelet.yaml | 20 +++++++++++++++-----
mysql-sink.kamelet.yaml | 20 +++++++++++++++-----
3 files changed, 43 insertions(+), 15 deletions(-)
[camel-kamelets] 01/04: MySQL Sink Kamelet Fixed description and
more information
Posted by ac...@apache.org.
This is an automated email from the ASF dual-hosted git repository.
acosentino pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/camel-kamelets.git
commit 34104e4496e0b046f39e20a17f5791aa9c6356f4
Author: Andrea Cosentino <an...@gmail.com>
AuthorDate: Mon Jun 14 14:59:56 2021 +0200
MySQL Sink Kamelet Fixed description and more information
---
mysql-sink.kamelet.yaml | 17 ++++++++++++-----
1 file changed, 12 insertions(+), 5 deletions(-)
diff --git a/mysql-sink.kamelet.yaml b/mysql-sink.kamelet.yaml
index 0818d05..30f2962 100644
--- a/mysql-sink.kamelet.yaml
+++ b/mysql-sink.kamelet.yaml
@@ -18,15 +18,23 @@ spec:
In you KameletBinding file you'll need to explicitly declare the mysql driver dependency, like in the following YAML snippet
- spec:
- integration:
- dependencies:
- - "mvn:mysql:mysql-connector-java:<version>"
+ In you KameletBinding file you'll need to explicitly declare the SQL Server driver dependency in spec->integration->dependencies
+
+ - "mvn:mysql:mysql-connector-java:<version>"
+
+ This Kamelet expects a JSON as body. The mapping between the JSON fields and parameters is done by key, so if you have the following query:
+
+ 'INSERT INTO accounts (username,city) VALUES (:#username,:#city)'
+
+ The Kamelet needs to receive as input something like:
+
+ '{ "username":"oscerd", "city":"Rome"}'
required:
- serverName
- username
- password
- query
+ - databaseName
type: object
properties:
serverName:
@@ -58,7 +66,6 @@ spec:
title: Database Name
description: The Database Name we are pointing
type: string
- default: mysql
dependencies:
- "camel:jackson"
- "camel:kamelet"
[camel-kamelets] 02/04: MySQL Sink Kamelet Fixed description and
more information
Posted by ac...@apache.org.
This is an automated email from the ASF dual-hosted git repository.
acosentino pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/camel-kamelets.git
commit c8282349b870da184980975a08edc541594468a2
Author: Andrea Cosentino <an...@gmail.com>
AuthorDate: Mon Jun 14 15:01:39 2021 +0200
MySQL Sink Kamelet Fixed description and more information
---
mysql-sink.kamelet.yaml | 3 +++
1 file changed, 3 insertions(+)
diff --git a/mysql-sink.kamelet.yaml b/mysql-sink.kamelet.yaml
index 30f2962..eece4d0 100644
--- a/mysql-sink.kamelet.yaml
+++ b/mysql-sink.kamelet.yaml
@@ -66,6 +66,9 @@ spec:
title: Database Name
description: The Database Name we are pointing
type: string
+ types:
+ in:
+ mediaType: application/json
dependencies:
- "camel:jackson"
- "camel:kamelet"
[camel-kamelets] 03/04: MySQL Sink Kamelet Fixed description and
more information
Posted by ac...@apache.org.
This is an automated email from the ASF dual-hosted git repository.
acosentino pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/camel-kamelets.git
commit fec6c4c0a6f60874ff0484b83505de7221db931a
Author: Andrea Cosentino <an...@gmail.com>
AuthorDate: Mon Jun 14 15:03:17 2021 +0200
MySQL Sink Kamelet Fixed description and more information
---
.../main/resources/kamelets/mysql-sink.kamelet.yaml | 20 +++++++++++++++-----
1 file changed, 15 insertions(+), 5 deletions(-)
diff --git a/library/camel-kamelets-catalog/src/main/resources/kamelets/mysql-sink.kamelet.yaml b/library/camel-kamelets-catalog/src/main/resources/kamelets/mysql-sink.kamelet.yaml
index 0818d05..eece4d0 100644
--- a/library/camel-kamelets-catalog/src/main/resources/kamelets/mysql-sink.kamelet.yaml
+++ b/library/camel-kamelets-catalog/src/main/resources/kamelets/mysql-sink.kamelet.yaml
@@ -18,15 +18,23 @@ spec:
In you KameletBinding file you'll need to explicitly declare the mysql driver dependency, like in the following YAML snippet
- spec:
- integration:
- dependencies:
- - "mvn:mysql:mysql-connector-java:<version>"
+ In you KameletBinding file you'll need to explicitly declare the SQL Server driver dependency in spec->integration->dependencies
+
+ - "mvn:mysql:mysql-connector-java:<version>"
+
+ This Kamelet expects a JSON as body. The mapping between the JSON fields and parameters is done by key, so if you have the following query:
+
+ 'INSERT INTO accounts (username,city) VALUES (:#username,:#city)'
+
+ The Kamelet needs to receive as input something like:
+
+ '{ "username":"oscerd", "city":"Rome"}'
required:
- serverName
- username
- password
- query
+ - databaseName
type: object
properties:
serverName:
@@ -58,7 +66,9 @@ spec:
title: Database Name
description: The Database Name we are pointing
type: string
- default: mysql
+ types:
+ in:
+ mediaType: application/json
dependencies:
- "camel:jackson"
- "camel:kamelet"
[camel-kamelets] 04/04: MySQL Sink Kamelet Fixed description and
more information
Posted by ac...@apache.org.
This is an automated email from the ASF dual-hosted git repository.
acosentino pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/camel-kamelets.git
commit 6eec0842a0cc5c2693da1f1ef67fffad5e6bfd79
Author: Andrea Cosentino <an...@gmail.com>
AuthorDate: Mon Jun 14 15:03:29 2021 +0200
MySQL Sink Kamelet Fixed description and more information
---
docs/modules/ROOT/pages/mysql-sink.adoc | 18 +++++++++++++-----
1 file changed, 13 insertions(+), 5 deletions(-)
diff --git a/docs/modules/ROOT/pages/mysql-sink.adoc b/docs/modules/ROOT/pages/mysql-sink.adoc
index f9e5552..c5af862 100644
--- a/docs/modules/ROOT/pages/mysql-sink.adoc
+++ b/docs/modules/ROOT/pages/mysql-sink.adoc
@@ -9,10 +9,17 @@ Send data to a MySQL Database.
In you KameletBinding file you'll need to explicitly declare the mysql driver dependency, like in the following YAML snippet
-spec:
- integration:
- dependencies:
- - "mvn:mysql:mysql-connector-java:<version>"
+In you KameletBinding file you'll need to explicitly declare the SQL Server driver dependency in spec->integration->dependencies
+
+- "mvn:mysql:mysql-connector-java:<version>"
+
+This Kamelet expects a JSON as body. The mapping between the JSON fields and parameters is done by key, so if you have the following query:
+
+'INSERT INTO accounts (username,city) VALUES (:#username,:#city)'
+
+The Kamelet needs to receive as input something like:
+
+'{ "username":"oscerd", "city":"Rome"}'
== Configuration Options
@@ -20,11 +27,11 @@ The following table summarizes the configuration options available for the `mysq
[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 MySQL Database| string| |
| *query {empty}* *| Query| The Query to execute against the MySQL Database| string| |
| *serverName {empty}* *| Server Name| Server Name for the data source| string| | `"localhost"`
| *username {empty}* *| Username| The username to use for accessing a secured MySQL Database| string| |
-| databaseName| Database Name| The Database Name we are pointing| string| `"mysql"`|
| port| Port| Server Port for the data source| string| `3306`|
|===
@@ -57,6 +64,7 @@ spec:
apiVersion: camel.apache.org/v1alpha1
name: mysql-sink
properties:
+ databaseName: "The Database Name"
password: "The Password"
query: "The Query"
serverName: "localhost"