search

bestlong / node-red-contrib-mssql-plus

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

add mustache transformation to connection object #4

Closed alexgv99 closed 5 years ago

alexgv99 commented 5 years ago

Hi... it's a way to change connection strings between environments... for instance, in my case, we have databases for tests and production... each one in a different server. Using a mustache template we can replace parts of the connection strings with environment variables, pointing to the correct server in each of them.

bestlong commented 5 years ago

Okay, i get it.

please also update src/mssql.html add help text before data-template-name="MSSQL-CN". like:

<script type="text/x-red" data-help-name="MSSQL-CN">
    <p>Config node for Node-RED to MS SQL</p>
    <h4>Connection setup</h4>
    <p>You can uses the <i><a href="http://mustache.github.io/mustache.5.html" target="_new">mustache</a></i> format.</br>
    Example: <i>{{{environment variable name}}}</i></p>
</script>
alexgv99 commented 5 years ago

Done, as you asked for. I hope it's OK.