siddharth23/cypress-postgres

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

cypress-postgres's Issues

Support for multiple database tables

I have an SQL query which needs a INNER JOIN between two database tables.
Is this something that can be supported?

I understand there is a connection parameter to support different tables but putting two connection in a single parameter, how is that possible?

cy.task("dbQuery", {"query":"your sql query","connection":connection}) with something like cy.task("dbQuery", {"query":"your sql query","connection":connection1 and connection2})

Creating a duplicate database object for the same connection

After repeatedly running a test with a call to cy.task("dbQuery"... I get warnings:

WARNING: Creating a duplicate database object for the same connection.
    at module.exports (e2e-tests/node_modules/cypress-postgres/cypress/plugins/index.js:21:14)
    at dbQuery (/e2e-tests/cypress/plugins/index.js:24:29)
    at invoke (/Cypress.app/Contents/Resources/app/packages/server/lib/plugins/child/task.js:41:14)

Is it to do with the way dbQuery task is added in plugins? Any advice?

Typescript definition

There is no typescript definition in this repository.
Either adding it to https://github.com/DefinitelyTyped/DefinitelyTyped or to a declaration file in this projects should be done to use typescript with cypress-postgres

pass multiple dburi

Hi ,
is there any way , i can pass the databaseUri to connect and query.
with this setup i can connect a single database instance only

New Cypress (v10.x.x) configuration does not work with this file setup (cypress.json)

In Cypress > plugins > index.js the path is set to cypress.json, which was the default config for Cypress up until they released major version 10 in June 2022.

Now they have a new file setup where cypress.json is not supported, and cypress.json is renamed to cypress.config.js. This results in the module / task for cypress-postgres not being found as it looks in the wrong path. It may be temporarily resolved with local changes, but in pipelines doing npm install every time to run the script, it will need to be changed in the plugin itself.

Docs are here for more information:
https://docs.cypress.io/guides/references/configuration#Configuration-File

Task can't find configuration file when it is in a different folder

I'm using cypress-postgres together with Quasar.
I want to have different configuration files in different folders but, when I try to run the tests, it says:

cy.task('dbQuery') failed with the following error:

Cannot find module '/../cypress.json'
Require stack:
- /.../node_modules/cypress-postgres/cypress/plugins/index.js
- /.../test/cypress/plugins/index.ts 

This is what I have inside my plugins/index.ts

const pluginConfig: Cypress.PluginConfig = (on, config) => {
    on('task', {
        dbQuery: (query) => {
            require('cypress-postgres')(query.query, query.connection)
        }
    })
}

Latest version published to NPM

Hi,

Can we get the latest version with the recently added PR that has support for cy10+ published to npm for use?