What is the equivalent of utassert eqtable / eqquery in utPLSQL v3 In utPLSQL v2 you had to use ‘quoted text to compare tables / queries. utPLSQL v3 allows you to compare table data using native refcursors without usage of dynamic SQL. In v2 with you would use syntax or syntax: In v3 you will use syntax: Additionally v3 allows you to filter columns of cursors so… Read More
How I got into utPLSQL v3 development Winter is coming and the 7th season of Game of Thrones now just a memory. While I do love watching TV series it was not them that dragged me away from my blog. For last 18 months or so, I was heavily involved in design and development of new version of utPLSQL v3. After… Read More
UTPLSQL vs. ruby-plsql – Running Oracle unit tests on Jenkins CI I my previous posts I have described some differences between UTPLSQL and ruby-plsql. This time I want to focus on automating the test execution with each of those frameworks using Jenkins Continuous Integration. The reasons for continuous testing Some of the problems that I often see in projects is that developers don’t fully acknowledge the… Read More
UTPLSQL vs. ruby-plsql/ruby-plsql-spec – part three – (not) reporting failures I have finished my previous post with comparison of basic reporting capabilities build into UTPLSQL and ruby-plsql frameworks for Oracle unit testing. Additional reporting options for ruby-plsql So far I have been using the ruby-plsql-spec wrapper around RSpec to run unit tests, however ruby-plsql was created in a way, that developer is not limited to… Read More
UTPLSQL vs. ruby-plsql/ruby-plsql-spec – part two (setup and basic reporting) In my previous post I have described the conceptual differences between UTPLSQL and ruby-plsql frameworks for unit testing of Oracle database code. I have used a message_api package and unit tests for that API using both frameworks as an example. In this post I will focus on getting the tests to run and the feedback… Read More