ruby-plsql¶

August 19, 2015
in ruby-plsql, testing
3 min read

utPLSQL v2 vs. ruby-plsql – Oracle unit testing frameworks for developers comparison

Last two months I was blogging quite a lot about UTPLSQL vs ruby-plsql. There are lots of aspects that I did not manage to cover so far. I've had a ambitious plan to go through all of the details and dig into the darkest corners to show all the differences. Time is however one thing I'm really short on recently, so instead of going into all the details as planned I've decided to give a high level overview of main differences between UTPLSQL and ruby-plsql. This will be a summary of the series for now, as I feel like moving into other topics. I might get back to it later if I find good reasons for doing so.

August 17, 2015
in PLSQL, ruby-plsql, testing
9 min read

utPLSQL v2 vs. ruby-plsql - exception handling

I recently use utPLSQL in my daily work as a testing framework and I've noticed that the framework is doing quite bad job on exception handling on the tested code. I'll try to demonstrate it with a simple/yet realistic scenario.

August 11, 2015
in PLSQL, ruby-plsql, testing
4 min read

utPLSQL v2 vs. ruby-plsql/ruby-plsql-spec – implicit datatype conversion traps ... continued

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.

August 11, 2015
in PLSQL, ruby-plsql, testing
9 min read

utPLSQL v2 vs. ruby-plsql/ruby-plsql-spec – implicit datatype conversion traps

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.

July 18, 2015
in ruby-plsql, testing
8 min read

ruby-plsql cheatsheet

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 time I was referring the Unit Tests supplied for the ruby-plsql library as a reference. They are really nicely documenting how things work and how can they be used. It usually took me few minutes to find the thing I needed.