From 06c62ab84a0bb330e84d3feef066df8181577a9c Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Date: Fri, 22 Sep 2023 11:16:21 +0200
Subject: [PATCH] Bug 36177: Cypress tests - cypress-mysql config

Signed-off-by: David Nind <david@davidnind.com>
Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
Signed-off-by: Katrin Fischer <katrin.fischer@bsz-bw.de>
---
 cypress.config.ts          | 10 +++++++++-
 t/cypress/plugins/index.js |  6 ++++++
 t/cypress/support/e2e.js   |  3 +++
 3 files changed, 18 insertions(+), 1 deletion(-)

diff --git a/cypress.config.ts b/cypress.config.ts
index d6814be6e2..95d03d37e8 100644
--- a/cypress.config.ts
+++ b/cypress.config.ts
@@ -8,9 +8,17 @@ export default defineConfig({
 
     e2e: {
         experimentalStudio: true,
-        baseUrl: "http://localhost:8081",
+        baseUrl: "http://kohadev-intra.mydnsname.org:8081",
         specPattern: "t/cypress/integration/**/*.*",
         supportFile: "t/cypress/support/e2e.js",
+        env: {
+            db: {
+                host: "db",
+                user: "koha_kohadev",
+                password: "password",
+                database: "koha_kohadev",
+            },
+        },
     },
 
     component: {
diff --git a/t/cypress/plugins/index.js b/t/cypress/plugins/index.js
index cf6b72f611..e35c437a8b 100644
--- a/t/cypress/plugins/index.js
+++ b/t/cypress/plugins/index.js
@@ -11,3 +11,9 @@ module.exports = (on, config) => {
 
   return config
 }
+
+const mysql = require('cypress-mysql');
+
+module.exports = (on, config) => {
+  mysql.configurePlugin(on);
+}
diff --git a/t/cypress/support/e2e.js b/t/cypress/support/e2e.js
index c0f4ef5cb8..afbb2ccea9 100644
--- a/t/cypress/support/e2e.js
+++ b/t/cypress/support/e2e.js
@@ -671,3 +671,6 @@ cy.getSushiService = () => {
         "url": "https:\/\/onlinelibrary.wiley.com\/reports\/"
     }
 }
+
+const mysql = require('cypress-mysql');
+mysql.addCommands();
-- 
2.39.5