@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

/@torpadev/orpa-node-database/

    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