🔗 Connect CYPRESS to a DATABASE [STEP BY STEP] | Cypress Tutorial
Вставка
- Опубліковано 5 лют 2025
- ✅ How do I run a SQL query in Cypress? Here you have the answer!
If you want to connect to a PostgreSQL?: kushalbhalaik....
#cypress #testing #automation #automationtesting #software #softwareengineer #softwaretesting #softwaredeveloper #javascript #typescript
🤖DISCORD: discord.gg/2F9E2fRGaU
⭐PREMIUM Cypress + Typescript course: shorturl.at/dcnPn
📣FREE Cypress videos: shorturl.at/h6iEX
It worked! Thank you so much.
Note: For Cypress 13+ the configurations have to be made in the "cypress.config.js" file instead of "Plugins->Index".
CRUD in full action. Loved it
Is there any video to connect Cypress (V10) with aws rds (Oracle)? Any guidelines will be really appreciated.
I'm having trouble trying to connect Cypress with SQL Server, I've read some NPM packages but can't make it work, mind if you help me a little bit? Thanks a lot for your videos, it has been pretty helpful for me.
Thank you so much for the amazing video tutorial, short and the main is fully useful. Saved my year i think =D
Thanks for the comment Irana! Happy to hear it saved the year
@@joanmedia Thank you for the help! Now i will use this option for fullstack automation, exciting🥳
very nice and informative video
Thanks for the comment!
Thanks! Keep making Cypress content. Subscribed.
Thanks! in case you are interested, today I published a course with more info, in case you want to take a look!
Great video!
Do you have an example on how you connect to the database IF the database requires a ssh tunnel?
Great instruction! Thank you. Can you make a video for Oracle db remote host connection?
As always on top👍
Thank you!
Fantastic video! I'd love to see more videos like that and an ability to replicate what you are doing. Is the repo available?
Great video👏👏 I have 1 question, how to keep credentials secured/ avoiding it being added to repository?
Please create one video for postgres db and where I am reading data from CSV and asserting into db
hello Joan I am success connect mysql and use 'select *' method by cypress but How can i do get the sql value change the type with Srting or INT
I have a question, in your opinion what is the best option to interact with SQL ORACLE, is using Cypress or Robot Framework, to compare values on the web page and SQL?
Thanks for the video. I have almost used the same but I had included a tedious package as well when I was trying a long time ago. But my question is I'm trying to retrieve around 500 rows from DB which takes around 2 minutes from the test to retrieve but directly from DB it is a fraction of a second. Any idea why cypress is taking time, please?
Great ❤
Hi Joan,
how do we add the DB credentials in cypress.config.js file. It has complete different structure
Thanks
Great!
Thanks Christina!
Really like your videos.. Keep going ❤❤
I have few question about test automation process
1. Do you write testing scripts before the task is complete by devs or after ?
2. If you do before, how do you get necessary elements like json objects/ UI elements?
And a quick thought, switching between windows quickly is bit hard to catup. :D LOL
Hello Janith. Thanks for your feedback!
In mi experience, I usually write test scripts after the task is complete by developers.
Also, if I am doing UI Tests, I map my elements as page objects or custom commands. You can find the page objects video or the new Udemy course, where I explain how to change espagueti code to a pattern :D
If I am doing API Testing, I get the json object from the official documentation. Schema, data, and so on.
Thanks for the feedback, promise I will fix that haha
@@joanmedia Much Appreciate your response
Hi, I need some help to create the connection with postgre database. Anyone????
Thank you very much for the video. Could you show how to integrate cypress with an Oracle Database? Thank you! :)
I need to connect Oracle database in my cypress framework version >10. Can you pls guide me?
Hello Joan, Can you pls let me know your input to connect Cypress 10 with Oracle database.
Do you have an update for this for cypress 10?
Hello BergerBear. I don't yet, need to migrate. However, the implementation still works, just have to bind the plugins file in the cypress.config.js/ts:
e2e: {
// We've imported your old cypress plugins here.
// You may want to clean this up later by importing these.
setupNodeEvents(on, config) {
return require('./cypress/plugins/index.js')(on, config)
},
specPattern: 'cypress/e2e/**/*.{js,jsx,ts,tsx}',
},
github.com/JoanEsquivel/cypress-demo-framework/blob/main/cypress.config.ts
It will work, asap I have time I'll try to explain how to do it directly in the "setupNodeEvents".
@@joanmedia thank you so much for the quick response. I will try this out soon. I was using a cypress postgres npm package that stopped working after upgrading to cypress 10. I will try to grab the postgres only npm package and give it a shot
@@mbergerman23 Let me know the result :D
I see that you're hardcoding the password. How can you pass it as an environment variable?