@torpadev/orpa-node-database

0.2.4 • Public • Published

orpa-node-database orpa-node-database build status

This module is part of the OPAL framework

Nodes:

  • querydb-read

Querydb Read

Connects to mysql database based on the connections details provided and executes the specified query. Query results are returned as the output of the node.

Inputs:

  • DB Type: Specify the type of database to connect (e.g. mysql, oracle, db2, etc.)
  • Server: Specify the database server details (IP address or hostname)
  • Database: Specify the database instance name
  • Port: Specify the port number to be used for connection
  • Connection String: Specify the connection string for the database.
  • Username: Specify the username for connecting to the database.
  • Password: Specify the password for connecting to the database
  • Query: Specify the query to be executed on the database
  • Timeout: specify the timeout during lookup for the title operation

Outputs:

msg.error When an error happens contains the error message from underlying database connection msg.payload contains the data read from database query

Readme

Keywords

Package Sidebar

Install

npm i @torpadev/orpa-node-database

Weekly Downloads

0

Version

0.2.4

License

GPL-3.0

Unpacked Size

61.3 kB

Total Files

8

Last publish

Collaborators

  • shivamadhavan
  • msivadas