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:55:02 UTC
[camel-kamelets] branch main updated (c129518 -> 39742ca)
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 c129518 SQL Server Sink Kamelet Fixed description and more information
new 4076bbd PostgreSQL Sink Kamelet Fixed description and more information
new 8261cfd PostgreSQL Sink Kamelet Fixed description and more information
new 39742ca PostgreSQL Sink Kamelet Fixed description and more information
The 3 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/postgresql-sink.adoc | 15 ++++++++++++---
.../main/resources/kamelets/postgresql-sink.kamelet.yaml | 14 +++++++++++++-
postgresql-sink.kamelet.yaml | 14 +++++++++++++-
3 files changed, 38 insertions(+), 5 deletions(-)
[camel-kamelets] 02/03: PostgreSQL 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 8261cfd9020c2ce82922dbe720e128b42faa508a
Author: Andrea Cosentino <an...@gmail.com>
AuthorDate: Mon Jun 14 14:34:07 2021 +0200
PostgreSQL Sink Kamelet Fixed description and more information
---
.../main/resources/kamelets/postgresql-sink.kamelet.yaml | 14 +++++++++++++-
1 file changed, 13 insertions(+), 1 deletion(-)
diff --git a/library/camel-kamelets-catalog/src/main/resources/kamelets/postgresql-sink.kamelet.yaml b/library/camel-kamelets-catalog/src/main/resources/kamelets/postgresql-sink.kamelet.yaml
index 14f30c1..7904da5 100644
--- a/library/camel-kamelets-catalog/src/main/resources/kamelets/postgresql-sink.kamelet.yaml
+++ b/library/camel-kamelets-catalog/src/main/resources/kamelets/postgresql-sink.kamelet.yaml
@@ -15,11 +15,20 @@ spec:
title: "PostgreSQL Sink"
description: |-
Send data to a PostgreSQL Database.
+
+ 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:
@@ -47,11 +56,14 @@ spec:
title: Query
description: The Query to execute against the PostgreSQL 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
- default: postgres
+ types:
+ out:
+ mediaType: application/json
dependencies:
- "camel:jackson"
- "camel:kamelet"
[camel-kamelets] 01/03: PostgreSQL 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 4076bbde880e6ef5a6a6c4a55f8ebcf151dfabdc
Author: Andrea Cosentino <an...@gmail.com>
AuthorDate: Mon Jun 14 14:32:42 2021 +0200
PostgreSQL Sink Kamelet Fixed description and more information
---
postgresql-sink.kamelet.yaml | 14 +++++++++++++-
1 file changed, 13 insertions(+), 1 deletion(-)
diff --git a/postgresql-sink.kamelet.yaml b/postgresql-sink.kamelet.yaml
index 14f30c1..7904da5 100644
--- a/postgresql-sink.kamelet.yaml
+++ b/postgresql-sink.kamelet.yaml
@@ -15,11 +15,20 @@ spec:
title: "PostgreSQL Sink"
description: |-
Send data to a PostgreSQL Database.
+
+ 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:
@@ -47,11 +56,14 @@ spec:
title: Query
description: The Query to execute against the PostgreSQL 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
- default: postgres
+ types:
+ out:
+ mediaType: application/json
dependencies:
- "camel:jackson"
- "camel:kamelet"
[camel-kamelets] 03/03: PostgreSQL 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 39742ca8c74606d8bef4b3632261e6cff0b96a83
Author: Andrea Cosentino <an...@gmail.com>
AuthorDate: Mon Jun 14 14:34:52 2021 +0200
PostgreSQL Sink Kamelet Fixed description and more information
---
docs/modules/ROOT/pages/postgresql-sink.adoc | 15 ++++++++++++---
1 file changed, 12 insertions(+), 3 deletions(-)
diff --git a/docs/modules/ROOT/pages/postgresql-sink.adoc b/docs/modules/ROOT/pages/postgresql-sink.adoc
index 510d46f..8633aec 100644
--- a/docs/modules/ROOT/pages/postgresql-sink.adoc
+++ b/docs/modules/ROOT/pages/postgresql-sink.adoc
@@ -7,17 +7,25 @@
Send data to a PostgreSQL Database.
+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
The following table summarizes the configuration options available for the `postgresql-sink` Kamelet:
[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 PostgreSQL Database| string| |
-| *query {empty}* *| Query| The Query to execute against the PostgreSQL Database| string| |
+| *query {empty}* *| Query| The Query to execute against the PostgreSQL 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 PostgreSQL Database| string| |
-| databaseName| Database Name| The Database Name we are pointing| string| `"postgres"`|
| port| Port| Server Port for the data source| string| `5432`|
|===
@@ -50,8 +58,9 @@ spec:
apiVersion: camel.apache.org/v1alpha1
name: postgresql-sink
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"