Introduction to utPLSQL

utPLSQL is a Unit Testing framework for Oracle PL/SQL. The framework follows industry standards and best patterns of modern Unit Testing frameworks like JUnit and RSpec

• User Guide
  • Installation
  • Getting Started
  • Annotations
  • Expectations
  • Running unit tests
  • Using the ut_run script
  • Testing best pracitces
  • Upgrade utPLSQL
• Reporting
  • Using reporters
  • Reporting errors
  • Code coverage
• About
  • Project Details
  • License
  • Support
  • Authors
  • Contributing

Three steps

With just three simple steps you can define and run your unit tests for PLSQL code.

1. Install the utPLSQL framework
2. Create Unit Tests to for the code
3. Run the tests

Here is how you can simply create tested code, unit tests and execute the tests using SQL Developer

Check out the sections on annotations and expectations to see how to define your tests.

Command line

The ut_run.sql script is a powerful thing - it can provide output from the tests on the fly. You can also use it to have coloured output from the test, and if you try to test code that was dropper, all of unit tests related to that code will fail.

Look into ut_run.sql script options to see more.

Coverage

If you want to have code coverage gathered on your code , it's best to use ut_run.sql to execute your tests with multiple reporters and have both test execution report as well as coverage report saved to a file. Check out the coverage documentation for options of coverage reporting

---

Last update: March 20, 2017 23:09:43
Created: October 23, 2016 20:53:00