@torpadev/orpa-node-database
v0.2.4
Published
Database Read/Write nodes for OPAL
Downloads
6
Readme
orpa-node-database
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