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