Ruby-plsql-spec is a modern PL/SQL unit testing framework, based on the Ruby testing (or behaviour driven development) framework.[1]
| Original author(s) | Raimonds Simanovskis |
|---|---|
| Preview release | 0.5.0
/ May 13, 2016 |
| Repository | github |
| Written in | Ruby |
| Type | SQL test automation framework |
| License | MIT |
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
editThe 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- ^ a b c "rsim/ruby-plsql-spec". GitHub. Retrieved 2016-03-14.
- ^ Simanovskis, Raimonds. "Oracle PL/SQL unit testing with Ruby". blog.rayapps.com. Retrieved 2016-03-14.
- ^ Simanovskis, Raimonds (2023-07-25), rsim/ruby-plsql, retrieved 2024-07-03
- ^ "PL/SQL unit testing with Ruby". SlideShare. 2010-05-20. Retrieved 2024-07-03.