Node-RED node to read and write to a MySQL or a MariaDB database.
Note: All credit for this work goes to the original creator(s): https://github.com/stackhero-io/node-red-contrib-stackhero-mysql
This is a fork for the purpose of configuring a connection using environment variables.
The primary use case for using this version is in instances where NodeRED changes are being deployed using CI/CD pipelines across multiple environments and credentials need to be configured using environment variables as opposed to manually setting them in the NodeRED UI.
In order to configure this node, set each of the inputs with it's environment variable name.
This node is really simple.
Put your query in the topic
variable and, if you have arguments, put them in an object in the payload
variable.
You will get the result in the payload
output variable.
Example:
msg.topic = 'SELECT * FROM `users` WHERE `name` = :name AND `age` > :age;';
msg.payload = { name: 'Adrien', age: 30 };
return msg;
Avoid SQL injections!!
Do not NEVER EVER put variables content in
topic
directly! Always use thepayload
variable to pass your arguments.