postgresql-component v1.0.0-DEV

postgresql-component

This component is based on Open Integration Hub framework, allowing this to connect with other components in order to have different flow exchanging data in a specific goal of transformation for the information.

This component uses the postgres server to send either single or batch queries.

Features

• Execute queries using the postgres database.
• Query can be a single operation or batch operations.

Libraries

• errorhandler-nxg-cg
• utils-nxg-cg
• logging-n3xgen-cg-lib
• md5-node-cg-lib
• postgresql-cg-lib
• pg-pool
• pg
• express

For more detail of the functionality review postgresql-cg-lib documentation

Installation

Docker image: cloudgenuser/postgresql-component:1.0.0

Functions

• trigger:
  • process_source
• action:
  • process

Fields:

• database: Property to specify the name of the database to connect to.
• host: Property to specify the host or IP to connect to.
• password: Property to specify the password of the user that has grants to the database.
• query: Property to specify the SELECT, INSERT, UPDATE, DELETE query to be executed (single or in bulk).
• user: Property to specify the database username.
• limit: Property to specify the number of records to process in bulk on INSERT, DELETE or UPDATE.
• port: Property to specify the connection port to the database.