cypress-postgresql

/* cypress.json or cypress.config.js equivalent */ { "db": { "user": "process.env.PG_USER ?? ''", "password": "process.env.PG_PASSWORD ?? ''", "host": "localhost", "port": 5432, "database": "test_db" } } /* cypress/plugins/index.js (Cypress < 10) or cypress.config.js setup */ const postgreSQL = require('cypress-postgresql'); const { Pool } = require('pg'); const dbConfig = require('../../cypress.json'); // Adjust path as needed module.exports = (on, config) => { const pool = new Pool(dbConfig.db); const tasks = postgreSQL.loadDBPlugin(pool); on('task', tasks); return config; }; /* cypress/support/commands.js */ import postgreSQL from 'cypress-postgresql'; postgreSQL.loadDBCommands(); /* cypress/e2e/db.cy.js */ describe('Database interactions', () => { beforeEach(() => { // Ensure the database is clean or seeded before each test cy.postgresql('TRUNCATE TABLE users RESTART IDENTITY;').then(() => { cy.log('Users table truncated.'); }); }); it('should insert and retrieve data from PostgreSQL', () => { cy.postgresql(`INSERT INTO users (name, email) VALUES ('John Doe', 'john@example.com');`) .then(() => { return cy.postgresql(`SELECT name FROM users WHERE email = 'john@example.com';`); }) .then((result) => { expect(result[0].name).to.eq('John Doe'); }); }); });