@torpadev/orpa-node-database 0.2.1

Database Read/Write nodes for OPAL

npm install @torpadev/orpa-node-database

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

Node Info

Version: 0.2.1
Updated 5 days ago
License: GPL-3.0

Downloads

76 in the last day
654 in the last week
973 in the last month

Nodes

  • querydb-read

Keywords

  • node-red
  • database

Maintainers

  • opaldev
  • balaraman.kunduvara
  • msivadas
  • shivamadhavan