07 March 2013
Continuing on my track of creating Ruby Gems to help with database interactions, I created PLSQL Unit Test. As the name suggests, it is designed to test PLSQL code.
It is a very simple gem, probably about 100 lines of code. It a nutshell it does three things:
As I write this, I have probably written about 400+ test cases using this framework, and it works well. It is certainly not an all singing and dancing test framework, as I only added features to cover scenarios I encountered as I was writing tests. The key for me when writing tests was to have a clean interface to communicate with the database (Simple Oracle JDBC) and a way to easily stage data (Data Factory) - after that Test::Unit provided almost everything I required.