Database Testing

Database testing has been recognized as an essential tool for delivering quality applications which rely on a backend database for their data. While database testing is acknowledged as beneficial and even critical, there are very few tools available to support database testing. DbTest is a Perl module built on the JCL module that provided a comprehensive toolset for database testing.

The philosophy of DbTest is that you should be able to test business rules implemented in your database without having to write gui test code. This will allow you to run automated tests during build processes, or on a scheduled basis. The results of these tests can be verified and reported automatically.

The DbTest module does this and more.

One of the missing components of most database testing tools is the ability to create test fixtures (data) for the specific requirements of the test being performed. Most database testing tools require that the database under test be in a specific state prior to the start of testing. This means that data for testing must be handled outsided of the test system, using other tools. DbTest solves this problem by giving the test analyste complete freedom to create test fixtures (data) as part of the testing process, and restore the database to it’s pre-test state upon completion of the test process. It can even be used simply as a test fixture engine to support other testing tools if desired. This makes DbTest a unique tool in database testing arena.

DbTest is currently in development and test, and will be available for distribution soon. Please check back here or contact the author for additional information.