firebird-db-role.html

<script type="text/x-red" data-template-name="firebird-database-role">
    <div class="form-row">
        <label for="node-config-input-host"><i class="fa fa-globe"></i> <span data-i18n="firebird-db-role.label.host"></span></label>
        <input type="text" id="node-config-input-host">
    </div>
    <div class="form-row">
        <label for="node-config-input-port"><i class="fa fa-random"></i> <span data-i18n="firebird-db-role.label.port"></span></label>
        <input type="text" id="node-config-input-port">
    </div>
    <div class="form-row">
        <label for="node-config-input-user"><i class="fa fa-user"></i> <span data-i18n="firebird-db-role.label.user"></span></label>
        <input type="text" id="node-config-input-user">
    </div>
    <div class="form-row">
        <label for="node-config-input-pass"><i class="fa fa-lock"></i> <span data-i18n="firebird-db-role.label.password"></span></label>
        <input type="password" id="node-config-input-password">
    </div>
    <div class="form-row">
        <label for="node-config-input-db"><i class="fa fa-database"></i> <span data-i18n="firebird-db-role.label.database"></span></label>
        <input type="text" id="node-config-input-db">
    </div>
    <div class="form-row">
        <label for="node-config-input-role"><i class="fa fa-database"></i> <span data-i18n="firebird-db-role.label.role"></span></label>
        <input type="text" id="node-config-input-role">
    </div>
</script>

<script type="text/javascript">
    RED.nodes.registerType('firebird-database-role',{
        category: 'config',
        defaults: {
            host: {value:"127.0.0.1",required:true},
            port: {value:"3050",required:true},
            db: {value:"",required:true},
            role: {value:"",required:false}
        },
        credentials: {
            user: {type: "text"},
            password: {type: "password"}
        },
        label: function() {
            return (this.host+":"+this.db);
        }
    });
</script>


<script type="text/x-red" data-template-name="firebird-db-role">
    <div class="form-row">
        <label for="node-input-firebirddb"><i class="fa fa-database-role"></i> <span data-i18n="firebird-db-role.label.database"></span></label>
        <input type="text" id="node-input-firebirddb">
    </div>
    <div class="form-row">
        <label for="node-input-requesttype"><i class="fa fa-quote-left"></i> <span data-i18n="firebird-db-role.label.requesttype"></span></label>
        <select id="node-input-requesttype" style="width:70%;">
            <option value="query" data-i18n="firebird-db-role.requesttype.query"></option>
            <option value="transaction" data-i18n="firebird-db-role.requesttype.transaction"></option>
        </select>
    </div>
    <div class="form-row">
        <label for="node-input-name"><i class="fa fa-tag"></i> <span data-i18n="firebird-db-role.label.name"></span></label>
        <input type="text" id="node-input-name" placeholder="Name">
    </div>
</script>

<script type="text/x-red" data-help-name="firebird-db-role">
    <p>Allows basic access to a Firebird database with the usage of roles.</p>
    <p>This node uses the <b>query</b> operation against the configured database. This does allow both INSERTS and DELETES.
    By its very nature it allows SQL injection... so <i>be careful out there...</i></p>
    <p>For <b>Query type</b> = <b>Simple query</b>: The <code>msg.topic</code> must hold the <i>query</i> for the database, and the result is returned in <code>msg.payload</code>.</p>
    <p>For <b>Query type</b> = <b>Transaction</b>: The <code>msg.topic</code> may hold the <i>array of queries</i> in one string, divided by ";" or the <i>simple query</i>. The result for the <b>last querry</b> is returned in <code>msg.payload</code>.</p>
    <p>Typically the returned payload will be an array of the result rows.</p>
    <p>If nothing is found for the key then <i>null</i> is returned.</p>
</script>

<script type="text/javascript">
    RED.nodes.registerType('firebird-db-role',{
        category: 'storage-input',
        color:"#D98943",
        defaults: {
            firebirddb: {type:"firebird-database-role",required:true},
            requesttype: {value:"query",required:true},
            name: {value:""}
        },
        inputs:1,
        outputs:1,
        icon: "db.png",
        label: function() {
            var levelNode = RED.nodes.node(this.firebirddb);
            return this.name||(levelNode?levelNode.label():"firebird-db-role");
        },
            labelStyle: function() {
            return this.name?"node_label_italic":"";
        }
    });
</script>