Skip to content

How to use Unitils for data-driven regression testing

Description

The page Test strategy for Oracle PL_SQL describes how we can write tests based on Unitils to test pl_sql code. For many data-driven applications the same approach can be used for regression tests on the Application tier / business logic.

See Testaco and what is testaco for more thorough descriptions of this kind of testing.

Howto

This approach is nearly identical to Test strategy for Oracle PL_SQL. The only differences are:

  • Tests call functionality on the Application tier instead of on the Data tier.

  • The application is "simple enough" to make it feasible to write input data and expected test results at the application tier. If not, this setup still makes sense, but the scope should then be selective smoke tests instead of full permutation coverage.