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 f0a5b78888046c9e7444384858868536003297b2 Author: Andrea Cosentino <[email protected]> AuthorDate: Mon Jun 14 15:13:13 2021 +0200 MariaDB Sink Kamelet Fixed description and more information --- docs/modules/ROOT/pages/mariadb-sink.adoc | 19 ++++++++++++------- 1 file changed, 12 insertions(+), 7 deletions(-) diff --git a/docs/modules/ROOT/pages/mariadb-sink.adoc b/docs/modules/ROOT/pages/mariadb-sink.adoc index b140a2b..6731e8b 100644 --- a/docs/modules/ROOT/pages/mariadb-sink.adoc +++ b/docs/modules/ROOT/pages/mariadb-sink.adoc @@ -7,12 +7,17 @@ Send data to a MariaDB Database. -In you KameletBinding file you'll need to explicitly declare the MariaDB driver dependency, like in the following YAML snippet +In you KameletBinding file you'll need to explicitly declare the SQL Server driver dependency in spec->integration->dependencies -spec: - integration: - dependencies: - - "mvn:org.mariadb.jdbc:mariadb-java-client:<version>" +- "mvn:org.mariadb.jdbc:mariadb-java-client:<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 @@ -22,7 +27,7 @@ The following table summarizes the configuration options available for the `mari | 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| | +| *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| | | port| Port| Server Port for the data source| string| `3306`| @@ -59,7 +64,7 @@ spec: properties: databaseName: "The Database Name" password: "The Password" - query: "The Query" + query: "INSERT INTO accounts (username,city) VALUES (:#username,:#city)" serverName: "localhost" username: "The Username"
