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:
1) 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
2) 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!