Ruby-plsql-spec is a modern PL/SQL unit testing framework, based on the Ruby testing (or behaviour driven development) framework.[1]

Ruby-plsql-spec
Original author(s)Raimonds Simanovskis
Preview release
0.5.0 / May 13, 2016; 8 years ago (2016-05-13)
Repositorygithub.com/rsim/ruby-plsql-spec
Written inRuby
TypeSQL test automation framework
LicenseMIT

It was originally developed to give PL/SQL developers an alternative to the utPLSQL framework. The goal was to make it faster to write Unit testing easier and less verbose.[2]

Features

edit

The key features of Ruby-plsql-spec include:

  • Provides a Ruby API for calling PL/SQL procedures and functions, supporting various PL/SQL data types as input and output parameters.[3]
  • Allows writing unit tests for PL/SQL code in Ruby using the RSpec syntax, which is more compact and readable compared to traditional PL/SQL testing frameworks.[4]
  • Includes helper methods and utilities for creating test data and verifying results.[1]
  • Supports running tests against an Oracle database connection specified in a configuration file.[1]

References

edit
  1. ^ a b c "rsim/ruby-plsql-spec". GitHub. Retrieved 2016-03-14.
  2. ^ Simanovskis, Raimonds. "Oracle PL/SQL unit testing with Ruby". blog.rayapps.com. Retrieved 2016-03-14.
  3. ^ Simanovskis, Raimonds (2023-07-25), rsim/ruby-plsql, retrieved 2024-07-03
  4. ^ "PL/SQL unit testing with Ruby". SlideShare. 2010-05-20. Retrieved 2024-07-03.