UTPLSQL vs. ruby-plsql/ruby-plsql-spec – implicit datatype conversion traps … continued 2015-08-11 | Leave a comment I’ve finished my previous post a bit too soon and was not precise on the ruby-plsql unite test results analysis. I’ve decided to dig a bit deeper to validate that ruby-plsql (RSpec) actually support datatype mismatch exceptions where utPLSQL unit testing fails due to oracle implicit datatype conversion. Retrospective Lets have a look once more… Read More
UTPLSQL vs. ruby-plsql/ruby-plsql-spec – implicit datatype conversion traps 2015-08-11 | Leave a comment This post is a continuation of the utPLSQL vs. ruby-plsql series, you might want to have a look at my previous post for introduction and some basics. Foreword Recently I’ve spent quite a lot of time investigating utPLSQL and ruby-plsql. Working on my previous articles made me think about very foundations of PL/SQL language. Sadly,… Read More
ruby-plsql cheatsheet 2015-07-18 | Leave a comment In my previous posts I did some writngs on UTPLSQL and ruby-plsql. For long time, while developing Oracle code I was using ruby-plsql to do test driven development for SQL and PL/SQL. I used to frequently forget how to use some of the functionalities of ruby-plsql, specially after having a longer break and so each… Read More
UTPLSQL vs. ruby-plsql – Running Oracle unit tests on Jenkins CI 2015-07-11 | 4 Comments 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 2015-06-28 | 4 Comments 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