bestlong / node-red-contrib-mssql-plus

A Node-RED node to read and write to Microsoft MS SQL Databases
MIT License
32 stars 18 forks source link

Support Connect / Disconnect commands via msg #107

Open Steve-Mcl opened 2 months ago

Steve-Mcl commented 2 months ago

Supports user "connect" and "disconnect" via msg - to permit runtime recovery in the event of error.

This is ground work for supporting runtime settable connection parameters at a later time.

Features:

Unit tests expanded - now has:

    ✔ should be loaded (876ms)
    ✔ should connect to database when topic and payload are set (49ms)
    ✔ should disconnect from database when topic and payload are set (1528ms)
    ✔ should perform a simple query (44ms)
    ✔ should return data to specified property
    ✔ should perform a simple using ui configured query with mustache (52ms)
    ✔ should can create table and insert/select data