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 442df47a03ca3b4f5aea08f2ef38f8d67bac05ef Author: Andrea Cosentino <anco...@gmail.com> AuthorDate: Fri Jun 11 18:28:17 2021 +0200 Added PostgreSQL Sink Kamelet --- .../assets/images/kamelets/postgresql-sink.svg | 1 + docs/modules/ROOT/pages/postgresql-sink.adoc | 70 ++++++++++++++++++++++ 2 files changed, 71 insertions(+) diff --git a/docs/modules/ROOT/assets/images/kamelets/postgresql-sink.svg b/docs/modules/ROOT/assets/images/kamelets/postgresql-sink.svg new file mode 100644 index 0000000..b102a0e --- /dev/null +++ b/docs/modules/ROOT/assets/images/kamelets/postgresql-sink.svg @@ -0,0 +1 @@ +<svg role="img" viewBox="0 0 24 24" xmlns="http://www.w3.org/2000/svg"><title>PostgreSQL icon</title><path d="M17.128 0a10.134 10.134 0 0 0-2.755.403l-.063.02A10.922 10.922 0 0 0 12.6.258C11.422.238 10.41.524 9.594 1 8.79.721 7.122.24 5.364.336 4.14.403 2.804.775 1.814 1.82.827 2.865.305 4.482.415 6.682c.03.607.203 1.597.49 2.879s.69 2.783 1.193 4.152c.503 1.37 1.054 2.6 1.915 3.436.43.419 1.022.771 1.72.742.49-.02.933-.235 1.315-.552.186.245.385.352.566.451.228.125.45.21.68.266.413.103 [...] \ No newline at end of file diff --git a/docs/modules/ROOT/pages/postgresql-sink.adoc b/docs/modules/ROOT/pages/postgresql-sink.adoc new file mode 100644 index 0000000..510d46f --- /dev/null +++ b/docs/modules/ROOT/pages/postgresql-sink.adoc @@ -0,0 +1,70 @@ +// THIS FILE IS AUTOMATICALLY GENERATED: DO NOT EDIT += image:kamelets/postgresql-sink.svg[] PostgreSQL Sink + +*Provided by: "Apache Software Foundation"* + +*Support Level for this Kamelet is: "Preview"* + +Send data to a PostgreSQL Database. + +== 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 +| *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| | +| *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`| +|=== + +NOTE: Fields marked with ({empty}*) are mandatory. + +== Usage + +This section summarizes how the `postgresql-sink` can be used in various contexts. + +=== Knative Sink + +The `postgresql-sink` Kamelet can be used as Knative sink by binding it to a Knative object. + +.postgresql-sink-binding.yaml +[source,yaml] +---- +apiVersion: camel.apache.org/v1alpha1 +kind: KameletBinding +metadata: + name: postgresql-sink-binding +spec: + source: + ref: + kind: InMemoryChannel + apiVersion: messaging.knative.dev/v1 + name: mychannel + sink: + ref: + kind: Kamelet + apiVersion: camel.apache.org/v1alpha1 + name: postgresql-sink + properties: + password: "The Password" + query: "The Query" + serverName: "localhost" + username: "The Username" + +---- + +Make sure you have xref:latest@camel-k::installation/installation.adoc[Camel K installed] into the Kubernetes cluster you're connected to. + +Save the `postgresql-sink-binding.yaml` file into your hard drive, then configure it according to your needs. + +You can run the sink using the following command: + +[source,shell] +---- +kubectl apply -f postgresql-sink-binding.yaml +---- +// THIS FILE IS AUTOMATICALLY GENERATED: DO NOT EDIT