20 Days Of Web Testing > Automate the tedious


Sometime the testing of websites/applications can be fairly tedious if you have to constantly navigate to certain points in a form, or create certain sets of data to get to specific pages or configurations to start testing.

In these instances I always find it incredibly useful to create a Selenium IDE (record and playback) UI test or simple SQL scripts to populate the database.

It makes getting to your actual test “point” much easier and quicker.


For Selenium UI tests add Selenium as an extension to Firefox and check out the online documentation on how to get started.

Simply record your navigation through the application and play back as necessary to get to where you need to be.

For example, I was once testing multiple users and cookie management and needed to log out and log in as different users with alarming regularity.

As such I created a simple automated script that would log one user out and then log the other in. This took away a huge amount of tedious button clicking. I wasn’t using Selenium to test the application, but I was using it to automate setup and tedious clicking.


Useful Hint(s)

Learning how to debug test scripts in Selenium IDE will make your script generation and playback more effective and quicker.

Apply caution though. If you find yourself building up an automated suite of tests and relying on them for regression then ask if this is really the right approach. Most of the time it won’t be.

You can often use SQL scripts to populate data ready for testing also.


Useful Links

SQLYog Tool – http://www.webyog.com/en/downloads.php

SQL Learning at W3 Schools – http://www.w3schools.com/sql/default.asp

Selenium Debugging – http://seleniumhq.org/docs/02_selenium_ide.html#debugging

Selenium – http://seleniumhq.org/


If you want to talk Testing – catch me later this year at EuroSTAR conference.