node-red-contrib-mysql-config

node-red-contrib-mysql-config

Node-RED node to read and write to a MySQL or a MariaDB database.

Foreword

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.

Use Case

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.

Configuration

In order to configure this node, set each of the inputs with it's environment variable name.

Usage

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 the payload variable to pass your arguments.