Introduction

Plugin that allows simple interactions with MySQL database using Cypress commands.

Installation

run npm install cypress-mysql
configure (see below)
profit

Usage

const sql = 'select * from some_table';
cy.query(sql).then((res) => {
  cy.log(res); // outputs json array of selected rows
});

const sql = 'insert into some_table (column_1, column_2) values ?';
const values = [
  [
    [1, 'a'],
    [2, 'b'],
    [3, 'c'],
  ],
]; // yes, it's three square brackets, don't ask
cy.query(sql, values).then((res) => {
  cy.log(res.affectedRows); // outputs 3
});

Supported commands:

• create database
• create/drop table
• any kind of select/join/insert/delete statetments

Environment setup

Add the following env properties in your cypress.confing.js file:

  env: {
    db: {
      host: 'localhost',
      user: 'user',
      password: 'password',
      database: 'database'
    }
  }

Plugin configuration - JavaScript

In your cypress.config.js add the following:

const mysql = require('cypress-mysql');

module.exports = defineConfig({
  e2e: {
    env: {
      db: {
        host: 'localhost',
        user: 'cypress',
        password: 'cypress',
        database: 'cypress',
      },
    },
    async setupNodeEvents(on, config) {
      mysql.configurePlugin(on);
    },
  },
});

In your cypress/support/e2e.js add the following:

const mysql = require('cypress-mysql');
mysql.addCommands();

Plugin configuration - TypeScript

In your cypress.config.ts add the following:

import * as mysql from 'cypress-mysql';

const defineConfig({
    e2e: {
        env: {
            db: {
                host: 'localhost',
                user: 'cypress',
                password: 'cypress',
                database: 'cypress'
            },
        },
        setupNodeEvents(on, config) {
            mysql.configurePlugin(on);
        },
    },
)}

In your cypress/support/e2e.ts add the following:

import * as mysql from 'cypress-mysql';
mysql.addCommands();

Future development & support

Please create feature requests for things you'd like to see.
Please raise issues for any problems you encounter.**