How to connect MSSQL database using JavaScript

Read to know How to connect mssql database using Javascript with the help of an example. SQL Database validations using Tedious, MSSQL are very important for database connection and validation. We have created some connection methods to connect to database and execute a query using Tedious and mssql packages. Read further

This  returns data from database. That can be used further for any assertion in database testing automation.  This is just a sample database connection and validation. You can change it to suite your requirement. 

These code blocks are tested with real database connections . You can copy and reuse them after making some changes at identified places for javascript mssql database connection example.

connect mssql Database using Javascript – Example 1

var sql = require('mssql');
//2.
var config = {
    server: 'server.address.net',//change server address here
    database: 'dbname',//change db name here
    user: 'adminbot',//change user here
    password: 'bot@1234',//change password here
    port: 1433,//change port here
    encrypt: true
};
//3.

function getResult() {
    loadEmployees();
}
function loadEmployees() {
    //4.
    var dbConn = new sql.ConnectionPool(config);
    //5.
    dbConn.connect().then(function () {
        //6.
        var request = new sql.Request(dbConn);
        //7.
        request.query("select * from employees").then(function (recordSet) {
            // console.log(recordSet);
            console.log(recordSet.Fields('Name').value);

            return recordSet;
            dbConn.close();
        }).catch(function (err) {
            //8.
            console.log(err);
            dbConn.close();
        });
    }).catch(function (err) {
        //9.
        console.log(err);
    });
}
//10.
getResult();

Database using Javascript – Example 2

var sql = require('mssql');

var config = {
	server: 'db.server.net',//change server address here
	database: 'db',//change db name here
	user: 'adminbot@db',//change username here
	password: 'bot@1234',//change password here
	port: 1433,//change port here
	options: {

		encrypt: true
	}
};

function getQueryResults(myquery) {

	var conn = new sql.ConnectionPool(config);
	var req = new sql.Request(conn);

	await conn.connect(function (err) {
		console.log('in connect');
		if (err) {
			console.log(err);
			return;

		}
		req.query(myquery, function (err, recordset) {
			console.log('in query');
			if (err) {
				console.log(err);
			}
			else {
				console.log('in recordset');
				console.log(recordset);
				//return recordset;
			}
			conn.close();
		});

	});

};