main.html

<script type="text/html" data-template-name="Stackhero-MySQL-Server">
  <div class="form-row">
    <label for="node-config-input-host"><i class="fa fa-globe"></i> Host</label>
    <input type="text" id="node-config-input-host" placeholder="xxxxxx.stackhero-network.com">
  </div>
  <div class="form-row">
    <label for="node-config-input-port"><i class="fa fa-random"></i> Port</label>
    <input type="text" id="node-config-input-port">
  </div>
  <div class="form-row">
    <label for="node-config-input-tls"><i class="fa fa-shield"></i> TLS</label>
    <input type="checkbox" id="node-config-input-tls" style="display:inline-block; width:auto; vertical-align:top;">
    <label for="node-config-input-tls" style="width:auto !important;"> Encrypt connection to database</label>
  </div>
  <div class="form-row">
    <label for="node-config-input-user"><i class="fa fa-user"></i> User</label>
    <input type="text" id="node-config-input-user">
  </div>
  <div class="form-row">
    <label for="node-config-input-password"><i class="fa fa-lock"></i> Password</label>
    <input type="password" id="node-config-input-password">
  </div>
  <div class="form-row">
    <label for="node-config-input-database"><i class="fa fa-database"></i> Database</label>
    <input type="text" id="node-config-input-database">
  </div>
  <div class="form-row">
    <label for="node-config-input-name"><i class="fa fa-tag"></i> Name</label>
    <input type="text" id="node-config-input-name" placeholder="Name">
  </div>
</script>

<script type="text/javascript">
  RED.nodes.registerType('Stackhero-MySQL-Server', {
    category: 'config',
    defaults: {
      name: {
        value: ""
      },
      host: {
        value: "xxxxxx.stackhero-network.com",
        required: true
      },
      port: {
        value: "3306",
        required: true
      },
      tls: {
        value: true,
        required: true
      },
      database: {
        value: "",
        required: true
      }
    },
    credentials: {
      user: {
        type: "text"
      },
      password: {
        type: "password"
      }
    },
    // Note: label (and probably labelStyle) have to be a classical function (not an arrow function)
    label: function () {
      return this.name || this.database
    }
  });
</script>

<!-- See https://nodered.org/docs/creating-nodes/help-style-guide -->
<script type="text/html" data-help-name="Stackhero-MySQL-Server">
  <p>
    Add the credentials for accessing your database here.<br />
    You can find your credentials on Stackhero by choosing your MySQL service and then clicking on the "Configure" button.
  </p>
</script>





<script type="text/html" data-template-name="Stackhero-MySQL">
  <div class="form-row">
    <label for="node-input-server"><i class="fa fa-database"></i> Database</label>
    <input type="text" id="node-input-server">
  </div>
  <div class="form-row">
    <label for="node-input-name"><i class="fa fa-tag"></i> Name</label>
    <input type="text" id="node-input-name" placeholder="Name">
  </div>
</script>

<!-- See https://nodered.org/docs/creating-nodes/help-style-guide -->
<script type="text/html" data-help-name="Stackhero-MySQL">
  <p>Connects to a MySQL database.</p>


  <h3>Inputs</h3>
  <dl class="message-properties">
    <dt>
      topic <span class="property-type">string</span>
    </dt>
    <dd> the SQL query.</dd>

    <dt class="optional">
      payload <span class="property-type">object</span>
    </dt>
    <dd> the arguments passed to the query.</dd>
  </dl>


  <h3>Outputs</h3>
  <dl class="message-properties">
    <dt>payload <span class="property-type">array</span></dt>
    <dd>the results of the SQL query.</dd>
  </dl>


  <h3>Example</h3>

  <p>
    The query:
    <pre>msg.topic = 'SELECT * FROM `users` WHERE `name` = :name AND `age` > :age;'</pre>

    The arguments:
    <pre>msg.payload = { name: 'Adrien', age: 30 };</pre>
  </p>

  <h3>References</h3>
  <ul>
    <li><a href="https://github.com/stackhero-io/node-red-contrib-stackhero-mysql">Repository</a> - the node repository</li>
    <li><a href="https://www.stackhero.io/services/MySQL">MySQL</a> - Managed MySQL database</li>
    <li><a href="https://www.stackhero.io/services/MariaDB">MariaDB</a> - Managed MariaDB database</li>
    <li><a href="https://www.stackhero.io/services/Node-RED">Node-RED</a> - Managed Node-RED service</li>
  </ul>
</script>

<script type="text/javascript">
  RED.nodes.registerType('Stackhero-MySQL', {
    category: 'storage-input',
    color: '#C0DEED', // See https://nodered.org/docs/creating-nodes/appearance#background-colour
    defaults: {
      server: {
        type: 'Stackhero-MySQL-Server',
        required: true
      },
      name: {
        value: ''
      }
    },
    inputs: 1, // Number of input
    outputs: 1, // Number of outputs
    icon: 'db.png', // See https://nodered.org/docs/creating-nodes/appearance#icon
    // Note: label (and probably labelStyle) have to be a classical function (not an arrow function)
    label: function () {
      const levelNode = RED.nodes.node(this.server);
      return this.name || (levelNode ? levelNode.label() : 'Stackhero MySQL');
    },
    labelStyle: function () {
      return this.name ? 'node_label_italic' : ''
    }
  });
</script>