Oracle and PL/SQL Recipes: A Problem-Solution Approach

17-6. Building a utPLSQL Test Suite

Problem

You have created numerous unit test procedures that you must run every time you modify your code. Running each test individually is both time-consuming and error-prone, as you may forget to run a test or two. You need a simple method to run all of your tests at once.

Solution

Use the utsuite.add command of utPLSQL to build a test suite, use the utPackage.add command to add individual unit tests to it, and then run the result. For example, here's how to build a suite to run the unit tests you developed in Recipes 17-3 and 17-4.

Create the test suite.

exec utSuite.add ('My Test Suite', 'Test all my functions');

Add individual unit tests to the suite.

exec utPackage.add ('My Test Suite', 'calc_quarter_hour'); ...