var sql = require('mssql');

describe('test db connection', function () {

  it('tests db connection', function () {

    ConnectDB()

  })

  function ConnectDB() {

    var config = {
      user: 'user',
      password: 'password',
      server: 'xyz.database.windows.net',
      database: 'dbdev',

      options: {
        encrypt: true
      }
    }

    var connection = new sql.Connection(config)
    connection.connect(function (err) {
      console.log(err)
    })

    var request = new sql.Request(connection);
    request.query('select * from Config where [Key] like 'HidePreop%'', function (err, recordeset) {
      var res = recordeset;
      console.log(res)
    });

describe('test db connection', function () {
    it('tests db connection', function (done) {
        // Any method that returns a promise. Similary if your method returns a callback you can handle accordingly
        ConnectDB().then(function _onSuccess(){
            done();
        }).catch(function _onFailure(err){
            done.fail(err);
        })
    })
});

function ConnectDB() {
    return new Promise(function (fulfill, reject) {
        var config = {
            user: 'user',
            .............
        };
        var connection = new sql.Connection(config);
        connection.connect(function (err) {
            reject(err);
        });

        var request = new sql.Request(connection);
        request.query('select * from Config where [Key] like 'HidePreop%'', function (err, recordeset) {
            if (err) reject(err);
            else fulfill(recordeset);
        });
    });
}

//db.js
const sql = require('mssql');

require('dotenv').config();

var config = {
  user: process.env.MSSQL_USERNAME,
  password: process.env.MSSQL_PASSWORD,
  server: process.env.MSSQL_SERVER,
  database: 'YOURDB',
  options: {
   encrypt: true
  }
};

module.exports = {

/** Define sql queries here  */
  deleteEmployeeByLastName(lastName) {
    let my_query = `DELETE FROM dbo.Employee WHERE LastName='${lastName}'`;
    sql.connect(config).then(function () {
      new sql.Request()
        .query(my_query).then(function (recordset) {}).catch(function (err) {
          console.log(err);
        });
    });
  }
}

//test.js
var db = require('db.js');

describe('Employee Management', function () {

    it('Deleting an employee', function (done) {
       db.deleteEmployeeByLastName('Pmurt');
       //REST OF CODE HERE
       //...
       //...
       done();
    })
});

var sql = require('mssql');

describe('test db connection', function () {
it('tests db connection', function (done) {
    ConnectDB().then(function _onSuccess(_returned){
        console.log(_returned.recordset[0].FirstPSPOrderId)

        done();
    }).catch(function _onFailure(err){
        done.fail(err);
    })
})

function ConnectDB() {
    return new Promise(function (fulfill, reject) {
    var config = {
        user: 'xxx',
        password: 'xxx',
        server: 'xxx',
        port: 'xxx',
        database: 'ammado_persistence_payment',

        options: {
            encrypt: true
        }
};
    var connection = new sql.ConnectionPool(config);
    connection.connect((err) => {
        if (err) reject(err);

    //});

    let query = "select [FirstPSPOrderId] from XYZ"
    connection.request()
    .query(query, (err, recordeset) => {

        console.dir('Record set: ' + recordeset)
        console.dir('Err: ' + err)

        if (err) reject(err);
        else fulfill(recordeset);
    });
});

});