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 12:02:03 UTC

[camel-kamelets] branch main updated (f950955 -> c129518)

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 f950955  Added SQL Server Sink Kamelet
     new 19c38c2  SQL Server Sink Kamelet Fixed description and more information
     new 546509e  SQL Server Sink Kamelet Fixed description and more information
     new d91e1b4  SQL Server Sink Kamelet Fixed description and more information
     new 5a86bff  SQL Server Sink Kamelet Fixed description and more information
     new 4761a6b  SQL Server Sink Kamelet Fixed description and more information
     new c129518  SQL Server Sink Kamelet Fixed description and more information

The 6 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/sqlserver-sink.adoc         | 19 ++++++++++++-------
 .../resources/kamelets/sqlserver-sink.kamelet.yaml  | 21 +++++++++++++++------
 sqlserver-sink.kamelet.yaml                         | 21 +++++++++++++++------
 3 files changed, 42 insertions(+), 19 deletions(-)

[camel-kamelets] 03/06: SQL Server 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 d91e1b43c0844403f12d84ebdfb278be1b33334f
Author: Andrea Cosentino <an...@gmail.com>
AuthorDate: Mon Jun 14 13:33:37 2021 +0200

    SQL Server Sink Kamelet Fixed description and more information
---
 docs/modules/ROOT/pages/sqlserver-sink.adoc | 19 ++++++++++++-------
 1 file changed, 12 insertions(+), 7 deletions(-)

diff --git a/docs/modules/ROOT/pages/sqlserver-sink.adoc b/docs/modules/ROOT/pages/sqlserver-sink.adoc
index 018dd9c..7739e4f 100644
--- a/docs/modules/ROOT/pages/sqlserver-sink.adoc
+++ b/docs/modules/ROOT/pages/sqlserver-sink.adoc
@@ -7,12 +7,17 @@
 
 Send data to a Microsoft SQL Server Database.
 
-In you KameletBinding file you'll need to explicitly declare the SQL Server 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:com.microsoft.sqlserver:mssql-jdbc:<version>"
+- "mvn:com.microsoft.sqlserver:mssql-jdbc:<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 need 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 `sqls
 | 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 SQL Server Database| string| | 
-| *query {empty}* *| Query| The Query to execute against the SQL Server Database| string| | 
+| *query {empty}* *| Query| The Query to execute against the SQL Server 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 SQL Server Database| string| | 
 | port| Port| Server Port for the data source| string| `1433`| 
@@ -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"
 

[camel-kamelets] 02/06: SQL Server 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 546509e3474920049a9c5181e0d8fb586a94c8f2
Author: Andrea Cosentino <an...@gmail.com>
AuthorDate: Mon Jun 14 13:33:23 2021 +0200

    SQL Server Sink Kamelet Fixed description and more information
---
 .../resources/kamelets/sqlserver-sink.kamelet.yaml  | 21 +++++++++++++++------
 1 file changed, 15 insertions(+), 6 deletions(-)

diff --git a/library/camel-kamelets-catalog/src/main/resources/kamelets/sqlserver-sink.kamelet.yaml b/library/camel-kamelets-catalog/src/main/resources/kamelets/sqlserver-sink.kamelet.yaml
index e8952f6..d784b7c 100644
--- a/library/camel-kamelets-catalog/src/main/resources/kamelets/sqlserver-sink.kamelet.yaml
+++ b/library/camel-kamelets-catalog/src/main/resources/kamelets/sqlserver-sink.kamelet.yaml
@@ -16,12 +16,17 @@ spec:
     description: |-
       Send data to a Microsoft SQL Server Database.
 
-      In you KameletBinding file you'll need to explicitly declare the SQL Server driver dependency, like in the following YAML snippet
-      
-      spec:
-        integration:
-          dependencies:
-          - "mvn:com.microsoft.sqlserver:mssql-jdbc:<version>"
+      In you KameletBinding file you'll need to explicitly declare the SQL Server driver dependency in spec->integration->dependencies
+
+      - "mvn:com.microsoft.sqlserver:mssql-jdbc:<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 need to receive as input something like:
+
+      '{ "username":"oscerd", "city":"Rome"}'
     required:
       - serverName
       - username
@@ -55,10 +60,14 @@ spec:
         title: Query
         description: The Query to execute against the SQL Server Database
         type: string
+        example: 'INSERT INTO accounts (username,city) VALUES (:#username,:#city)'
       databaseName:
         title: Database Name
         description: The Database Name we are pointing
         type: string
+  types:
+    out:
+      mediaType: application/json
   dependencies:
   - "camel:jackson"
   - "camel:kamelet"

[camel-kamelets] 04/06: SQL Server 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 5a86bff6ab6c73ce8f3ecdde6ecc9fa71bfd70d7
Author: Andrea Cosentino <an...@gmail.com>
AuthorDate: Mon Jun 14 13:41:06 2021 +0200

    SQL Server Sink Kamelet Fixed description and more information
---
 sqlserver-sink.kamelet.yaml | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/sqlserver-sink.kamelet.yaml b/sqlserver-sink.kamelet.yaml
index d784b7c..ba7c005 100644
--- a/sqlserver-sink.kamelet.yaml
+++ b/sqlserver-sink.kamelet.yaml
@@ -24,7 +24,7 @@ spec:
 
       'INSERT INTO accounts (username,city) VALUES (:#username,:#city)'
 
-      The Kamelet need to receive as input something like:
+      The Kamelet needs to receive as input something like:
 
       '{ "username":"oscerd", "city":"Rome"}'
     required:

[camel-kamelets] 01/06: SQL Server 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 19c38c2453327da20e1a734a9c9d58acdfcb0d0d
Author: Andrea Cosentino <an...@gmail.com>
AuthorDate: Mon Jun 14 13:30:49 2021 +0200

    SQL Server Sink Kamelet Fixed description and more information
---
 sqlserver-sink.kamelet.yaml | 21 +++++++++++++++------
 1 file changed, 15 insertions(+), 6 deletions(-)

diff --git a/sqlserver-sink.kamelet.yaml b/sqlserver-sink.kamelet.yaml
index e8952f6..d784b7c 100644
--- a/sqlserver-sink.kamelet.yaml
+++ b/sqlserver-sink.kamelet.yaml
@@ -16,12 +16,17 @@ spec:
     description: |-
       Send data to a Microsoft SQL Server Database.
 
-      In you KameletBinding file you'll need to explicitly declare the SQL Server driver dependency, like in the following YAML snippet
-      
-      spec:
-        integration:
-          dependencies:
-          - "mvn:com.microsoft.sqlserver:mssql-jdbc:<version>"
+      In you KameletBinding file you'll need to explicitly declare the SQL Server driver dependency in spec->integration->dependencies
+
+      - "mvn:com.microsoft.sqlserver:mssql-jdbc:<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 need to receive as input something like:
+
+      '{ "username":"oscerd", "city":"Rome"}'
     required:
       - serverName
       - username
@@ -55,10 +60,14 @@ spec:
         title: Query
         description: The Query to execute against the SQL Server Database
         type: string
+        example: 'INSERT INTO accounts (username,city) VALUES (:#username,:#city)'
       databaseName:
         title: Database Name
         description: The Database Name we are pointing
         type: string
+  types:
+    out:
+      mediaType: application/json
   dependencies:
   - "camel:jackson"
   - "camel:kamelet"

[camel-kamelets] 05/06: SQL Server 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 4761a6bce2bb919770b89a3e22f2fb0bb372f1a4
Author: Andrea Cosentino <an...@gmail.com>
AuthorDate: Mon Jun 14 13:41:29 2021 +0200

    SQL Server Sink Kamelet Fixed description and more information
---
 .../src/main/resources/kamelets/sqlserver-sink.kamelet.yaml             | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/library/camel-kamelets-catalog/src/main/resources/kamelets/sqlserver-sink.kamelet.yaml b/library/camel-kamelets-catalog/src/main/resources/kamelets/sqlserver-sink.kamelet.yaml
index d784b7c..ba7c005 100644
--- a/library/camel-kamelets-catalog/src/main/resources/kamelets/sqlserver-sink.kamelet.yaml
+++ b/library/camel-kamelets-catalog/src/main/resources/kamelets/sqlserver-sink.kamelet.yaml
@@ -24,7 +24,7 @@ spec:
 
       'INSERT INTO accounts (username,city) VALUES (:#username,:#city)'
 
-      The Kamelet need to receive as input something like:
+      The Kamelet needs to receive as input something like:
 
       '{ "username":"oscerd", "city":"Rome"}'
     required:

[camel-kamelets] 06/06: SQL Server 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 c129518e5aa2ecdda737f47651a0980fea643415
Author: Andrea Cosentino <an...@gmail.com>
AuthorDate: Mon Jun 14 13:42:01 2021 +0200

    SQL Server Sink Kamelet Fixed description and more information
---
 docs/modules/ROOT/pages/sqlserver-sink.adoc | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/docs/modules/ROOT/pages/sqlserver-sink.adoc b/docs/modules/ROOT/pages/sqlserver-sink.adoc
index 7739e4f..042d1f0 100644
--- a/docs/modules/ROOT/pages/sqlserver-sink.adoc
+++ b/docs/modules/ROOT/pages/sqlserver-sink.adoc
@@ -15,7 +15,7 @@ This Kamelet expects a JSON as body. The mapping between the JSON fields and par
 
 'INSERT INTO accounts (username,city) VALUES (:#username,:#city)'
 
-The Kamelet need to receive as input something like:
+The Kamelet needs to receive as input something like:
 
 '{ "username":"oscerd", "city":"Rome"}'