< Previous Section: utRecEq Package | Next Section: Custom Reporter Packages >

Defining Test Suites

If you define test suites and register packages within those suites, then utPLSQL will run an unlimited number of tests with a single command.

Note

All suite names are stored in upper case.
If you do not specify a directory (dir_in), you will need to call utConfig.setdir if you want automatic compilation of your packages to occur.
If you supply a value for seq_in, packages will be compiled and tested in ascending numeric sequence order.
When you call utSuite.rem, it will remove all packages for that suite by calling utPackage.rem.

utSuite - Define Test Suites

To create and remove test suites, call these programs:

PROCEDURE utSuite.add (
   name_in          IN VARCHAR2,
   desc_in          IN VARCHAR2 := NULL,
   rem_if_exists_in IN BOOLEAN  := TRUE
);

PROCEDURE utSuite.rem (name_in IN VARCHAR2);

These programs manipulate the contents of the ut_suite table. See the tables.sql file for the DDL creating this table.

utPackage - Define Test Packages for a Suite

To register a package in a suite, call the following:

PROCEDURE utPackage.add (
   suite_in          IN VARCHAR2,
   package_in        IN VARCHAR2,
   samepackage_in    IN BOOLEAN := FALSE,
   prefix_in         IN VARCHAR2 := NULL,
   dir_in            IN VARCHAR2 := NULL,
   seq_in            IN PLS_INTEGER := NULL,
   owner_in          IN VARCHAR2 := NULL,
   add_tests_in      IN BOOLEAN := FALSE,
   test_overloads_in IN BOOLEAN := FALSE
);

This manipulates the contents of the ut_package table. See the tables.sql file for the DDL creating this table.

Here is a sample script that defines a very small portion of the PL/Vision test suite:

BEGIN
   utSuite.add ('PLVision');

   utPackage.add('PLVision', 'PLVstr', dir_in => 'e:\utplsql\test');

   utPackage.add ('PLVision', 'PLVdate', dir_in => 'e:\utplsql\test'');

   utPLSQL.testsuite ('PLVision', recompile_in => TRUE);

END;
/

< Previous Section: utRecEq Package | Next Section: Custom Reporter Packages >