I’m now relatively well versed in using Selenium when it comes to UI testing, but there is one area which I’m not too confident on which I haven’t seen covered much in the courses I have taken, and that’s interaction with the database; the things that spring to mind are below:
- when data is written to the db, how we can check it is correct? For example if I am on Amazon and I buy a product for a certain amount, I’d then want to check that this amount has been written to the db
- extracting data out of the db to use for testing. Again, using the Amazon example, how would I interact with the db and be able to pull out products to use for testing.
I’ve used SQL for a few years now so I’m comfortable with the syntax, but when it comes to integrating this with automation this is where my knowledge falls down. Any useful pointers/links to tutorials etc would be appreciated to help me overcome this!