cypress.config.js

const { defineConfig } = require("cypress");

// This is for db data testing/checking (CANNOT GET DATA AND CHECK VIA CYPRESS)
//For connecting to SQL Server
const mysql = require("mysql2");
function queryTestDb(query, config) {
  // creates a new mysql connection using credentials from cypress.json env's
  const connection = mysql.createConnection(config.env.db);
  // start connection to db
  connection.connect();
  // exec query + disconnect to db as a Promise
  return new Promise((resolve, reject) => {
    connection.query(query, (error, results) => {
      if (error) reject(error);
      else {
        connection.end();
        return resolve(results);
      }
    });
  });
}

module.exports = defineConfig({
  numTestsKeptInMemory: 20,
  defaultCommandTimeout: 30000,
  e2e: {
    setupNodeEvents(on, config) {
      on("before:browser:launch", (browser = {}, launchOptions) => {
        if (browser.name === "chrome") {
          launchOptions.args.push("--mute-audio");
        }

        return launchOptions;
      });
      on("task", {
        queryDb: (query) => {
          return queryTestDb(query, config);
        },
      }); //For running sql query
    },

    baseUrl: "http://localhost:8080",
  },
  env: {
    db: {
      host: "localhost",
      user: "root",
      password: "helloworld",
      database: "doenet_local",
    },
  },
});