Guest User

Untitled

a guest
Dec 11th, 2017
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.96 KB | None | 0 0
  1. <pre><code>
  2. var dbConnect = require(../db/abc.js);
  3.  
  4. this.When(/^I query the Student table & compare result with student list page
  5. of UI $/, function () {
  6. var sqlStr = "select * from Student";
  7. var rs = dbConnect.getDBResult(sqlStr, function (err,recordset){
  8. console.log('Record Set ', recordset);
  9. /// Need the data for compare with UI page.
  10. });
  11. console.log('Data ', rs);
  12. }
  13.  
  14.  
  15. (../db/abc.js) file as below
  16.  
  17. var sql = require('mssql');
  18.  
  19. var setupMSQL= function () {
  20. var config = {
  21. user:xxx
  22. password: 'zzzz',
  23. server: 'xxx.xx.xx.xx',
  24. options: {encrypt: true, database: 'DBNAME'}
  25. };
  26.  
  27.  
  28. this.getDBResult = function (sqlQry, callback) {
  29. sql.connect(config, function (err) {
  30. var request = new sql.Request();
  31. return request.query(sqlQry, callback);
  32. });
  33. }
  34. module.exports = new setupMSQL();
  35.  
  36. </pre></code>
Add Comment
Please, Sign In to add comment