Calling multi-parameterized Azure SQL stored procedure from Nodejs

Question

I am looking forward to know how can I run an Azure SQL stored procedure with multiple input parameters from Nodejs.

For example, if I have a stored procedure FIND_USERS(activity_status, color, gender) which runs a query

select * from users where isActive = activity_status and bay_color = color and userGender = gender;

I should be able to call this stored procedure from nodejs with the input parameters. The thing to understand here is that I want have a SQL transaction service that can take any CALL PROCEDURE type command along with the set of input parameters and call the procedure using those input parameters irrespective of the number of input parameters.

What I know is that for MySQL, there is a mysql library which lets me run procedures with multiple parameters. I have encapsulated it in MySQLConnector.js service as

var mysql   = require('mysql');

exports.query = function(sql, values, next) {

    if (arguments.length === 2) {
        next = values;
        values = null;
    }
    var connection = mysql.createConnection({
        host:host,
        user:user,
        password:password,
        database:database
    });
    connection.connect(function(err) {
        if (err !== null) {
            console.log("[MYSQL] Error connecting to mysql:" + err+'\n');
            console.log(err == 'Error: ER_CON_COUNT_ERROR: Too many connections')
            if(err == 'Error: ER_CON_COUNT_ERROR: Too many connections'){
              connection.end();
            }
        }
    });
    connection.query(sql, values, function(err) {
        connection.end();
        if (err) {
            throw err;
        }
        next.apply(this, arguments);
    });
}

With this, I can call a stored procedure from nodejs with a function like

MySQLConnector.query('CALL FIND_USERS (?, ?, ?)', [1, 'blue', 'female'], function(err, userData) {
  //do something with userData
});

How is it possible to do this for Azure MS SQL?

Suraiya Hameed · Accepted Answer · 2017-10-05 06:00:53Z

1

You can use tedious driver to connect to SQL Server. It supports both input+output parameter for statements and SPs, you can find the example in http://tediousjs.github.io/tedious/parameters.html

Feels free to raise an issue in GitHub if you need more assistance.

answered Oct 5, 2017 at 6:00

Suraiya Hameed

212 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Cody Gray · Accepted Answer · 2017-10-08 11:55:13Z

0

Make use of Edje.js and you should create a function and send the parameters when you call the function.

getHorarioFarmacia({pSede:'Sucursal Parrita'}, function (error, result){....

}

For more details, read the comments made by Luis Diego Pizarro here.

edited Oct 8, 2017 at 11:55

Cody Gray♦

246k53 gold badges512 silver badges591 bronze badges

answered Oct 5, 2017 at 3:59

Alberto Morillo

15.8k3 gold badges29 silver badges32 bronze badges

Collectives™ on Stack Overflow

Calling multi-parameterized Azure SQL stored procedure from Nodejs

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related