Test sql query to your postgres database in cypress tests

Use this plugin to query postgres database and use response in cypress tests

• Run below command in terminal to install the cypress postgres

npm i -D cypress-postgres 

• Open your cypress/plugins/index.js file and register a new task

module.exports = on => { on("task", { dbQuery:(query)=> require("cypress-postgres")(query.query,query.connection) }); }; 

To query postgres database follow below steps-

• Add postgres database connection details in cypress.json file. Details like-

"db": {"user": "postgres", "host": "localhost", "database": "postgres", "password": "*****", "port":5432 } 

• Use dbQuery task in your tests to query postgres database like below-

cy.task("dbQuery", {"query":"your sql query"}).then(queryResponse => { expect(queryResponse).to.equal("[{Your expected query result}]") }); 

• If you need to query multiple database you can also pass the connection from scripts like below-
• Create connection in your scripts-

let connection={"user": "postgres", "host": "localhost", "database": "postgres", "password": "*****", "port":5432 } 

• And use this in your test scripts like below-

 cy.task("dbQuery", {"query":"your sql query","connection":connection}).then(queryResponse => { expect(queryResponse).to.equal("[{Your expected query result}]") }); 

Siddharth Kala 💻 ⚠️

This project follows the all-contributors specification. Contributions of any kind welcome!