cypress-commands-db.js

module.exports = function() {
  Cypress.Commands.add('sqlServer', (query) => {
    if(!query) {
      throw new Error('Query must be set');
    }

    cy.task('sqlServer:execute', query).then(response => {
      let result = [];

      const flatten = r => Array.isArray(r) && r.length === 1 ? flatten(r[0]) : r;

      if(response) {
        for (let i in response) {
          result[i] = [];
          for (let c in response[i]) {
            result[i][c] = response[i][c].value;
          }
        }
        result = flatten(result);
      } else {
        result = response;
      }

      return result;
    });
  });
}

cypress-plugins-db.js

const Tedious = require('tedious');

module.exports = (dbConfig) => {
    return {
      'sqlServer:execute': (sql) => {
        const connection = new Tedious.Connection(dbConfig);
        return new Promise((res, rej) => {
          connection.on('connect', err => {
            if (err) {
              rej(err);
            }

            const request = new Tedious.Request(sql, function(err, rowCount, rows) {
              return err ? rej(err) : res(rows);
            });

            connection.execSql(request);
          });
        });
      }
    }
  };

@ jennifer-shehane Could you please provide mysql code with cypress example with verification db.

can you please post sample from spec file as well

How is your plugin/index.js configured in order to make "sqlServer:execute" of cypress-plugins-db.js called?

Would it be possible to do the same with a DB2 connection? This is working:

    var ibmdb = require('ibm_db');

    ibmdb.open(dbConfig, function (err, conn) {
        if (err) return console.log(err);
        conn.query(query, function (err, data) {
            if (err) console.log(err);
            else console.log(data);
            conn.close(function () {
                console.log('done');
            });
        });
    });

but I would like to do as task/command in order to call it when I need it.

I use Cypress with Typescript. Will it be possible to call cy.sqlserver in a typescript class file. Could you provide the guidance?