ruby-plsql-spec

{{Infobox Software

| name = Ruby-plsql-spec

| author = Raimonds Simanovskis

| latest release version =

| latest release date =

| latest preview version = 0.5.0

| latest preview date = {{Start date and age|2016|05|13}}

| programming language = Ruby

| genre = SQL test automation framework

| license = MIT

| repo = {{URL|https://github.com/rsim/ruby-plsql-spec}}

}}

Ruby-plsql-spec is a modern PL/SQL unit testing framework, based on the Ruby testing (or behaviour driven development) framework.{{Cite web|url=https://github.com/rsim/ruby-plsql-spec|title=rsim/ruby-plsql-spec|website=GitHub|access-date=2016-03-14}}

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.{{Cite web|url=http://blog.rayapps.com/2009/11/27/oracle-plsql-unit-testing-with-ruby/|title=Oracle PL/SQL unit testing with Ruby|last=Simanovskis|first=Raimonds|website=blog.rayapps.com|access-date=2016-03-14}}

Features

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.{{Citation |last=Simanovskis |first=Raimonds |title=rsim/ruby-plsql |date=2023-07-25 |url=https://github.com/rsim/ruby-plsql |access-date=2024-07-03}}
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.{{Cite web |date=2010-05-20 |title=PL/SQL unit testing with Ruby |url=https://www.slideshare.net/slideshow/plsql-unit-testing-with-ruby/4177998 |access-date=2024-07-03 |website=SlideShare |language=en}}
Includes helper methods and utilities for creating test data and verifying results.
Supports running tests against an Oracle database connection specified in a configuration file.

References

Category:Unit testing frameworks