js

export default function serverResources() {
  return {
    selector: 'body ',
    elements: {
      body: {selector: 'body'}
    },
    commands: [{
      checkDataResources(){
        var express = require('express');
        var application = express();
        application.get('/', function (req, res) {
          var sql = require("mssql");

          var config = {
            user: 'bisrvuser',
            password: 'Forrester1!',
            server: 'forrepam2.c5jjhjko1svs.us-east-1.rds.amazonaws.com',
            database: 'CXINDEXData'
          };

          sql.connect(config, function (err) {
            var request = new sql.Request();
            request.query("Use CXINDEXWeb exec CXINDEXWeb.[cx_content].[getResources] @CXUserName = 'cxdemo', @CXCountryId = -1, @CXIndustryId = 1;", function (err, recordset) {
              res.send(recordset);
              var values = recordset;
              var map1 = values.map(value => value.ResourceURL);
              console.log(map1);

            });

            setTimeout(function () {
              server.close();
            }, 1000)
          });
        });
        var server = application.listen('5000');
      },

      checkHrefResources(){
        var arr=[];
        this.api.elements('css selector', '.resource--title > a[href^="https"]', (result) => {
          var values = result.value.length;
          for (var i = 1; i < values; i++) {
            this.api.getAttribute(`.resource-list > div:nth-child(${i}) > .resource--info > div.resource--title > a`, "href", function (results) {
              arr = results.value;
              console.log(arr);
            });
          }
        });  return arr;
      }
    }]
  };
}