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