Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <pre><code>
- var dbConnect = require(../db/abc.js);
- this.When(/^I query the Student table & compare result with student list page
- of UI $/, function () {
- var sqlStr = "select * from Student";
- var rs = dbConnect.getDBResult(sqlStr, function (err,recordset){
- console.log('Record Set ', recordset);
- /// Need the data for compare with UI page.
- });
- console.log('Data ', rs);
- }
- (../db/abc.js) file as below
- var sql = require('mssql');
- var setupMSQL= function () {
- var config = {
- user:xxx
- password: 'zzzz',
- server: 'xxx.xx.xx.xx',
- options: {encrypt: true, database: 'DBNAME'}
- };
- this.getDBResult = function (sqlQry, callback) {
- sql.connect(config, function (err) {
- var request = new sql.Request();
- return request.query(sqlQry, callback);
- });
- }
- module.exports = new setupMSQL();
- </pre></code>
Add Comment
Please, Sign In to add comment