You’ll be relieved to hear that I’m not going to talk about Brexit any more. It’s done and finished and it’s time everyone moved on.
Besides, from my current vantage point ( a small island off the coast of Europe), other people have their own problems.
In the USA for example, the nation is currently engrossed in what appears to be an exercise to find the second most unpopular person in the country…and make them President.
If the subject of this post were a Presidential Candidate, it would probably be nicknamed “The Comeback Kid”.
No, Bill Clinton hasn’t released a PL/SQL testing framework, but Steven Feuerstein has and – contrary to what you may have heard – utPLSQL is very much alive and kicking.
As the first Test framework written specifically for PL/SQL, utPLSQL is the perfect subject for my continuing testing odyssey.
Update : If you’ve stumbled across this post hoping to find out about the all new utPLSQL version 3, then I’d suggest that you have a look here.
To date, this has included
- a brief look at hand-crafting Unit Tests for PL/SQL
- a dive into the nooks and crannies of SQLDeveloper Unit Testing
The political analogy is rather apposite when you consider that using utPLSQL largely revolves around making a number of assertions…which may or may not be true.
What we’ll be looking at is :
- Installing the utPLSQL framework
- Your first Test and how to run it
- A quick recap of the Footie Application we’re testing with
- The utPLSQL Assert API
- Building and executing Test Suites
- Retrieving utPLSQL test execution results programmatically
But first…. Continue reading