Resources

Do you know about videos, articles, blogs or code examples that are missing here? Please let us know!

Framework¶

Latest documentation

Overview¶

UKOUG Testing PLSQL APIs with utPLSQL v3 Webinar (by Jacek Gebal)
Comprehensive webinar about utPLSQL by Jacek Gebal. The definitive guide to why and how to test PL/SQL with utPLSQL
utPLSQL 3.0 - How to have your cake and eat it (by Mike Smithers)
Complete introduction to utPLSQL 3.0, covering installation, comprehensive example application, transaction challenges and even code coverage
Strongholds of Confidence: Self-Testing your Database (by Samuel Nitsche)
Plea to start creating meaningful, automated self-tests and why. Finishes with a concrete utPLSQL example
Test Driven Development in PLSQL with utPLSQL v3 – intro (by Jacek Gebal)
Addresses some major struggles of developers who start with unit-testing and also gives a brief intro into Test-Driven-Development
Testing PL/SQL in your Ci/Cd pipeline with utPLSQL (by Blaine Carter) Blaine demonstrates running utPLSQL unit tests in Oracle Developer Cloud and publishing test results.
Extending Oracle Database DevOps with Automated PL/SQL Unit Testing (by Shay Shmeltzer) Overview of running utPLSQL unit tests within Oracle Developer Cloud
DevOps Around Autonomous Data Warehouse (Oracle) A short overview of an architecture proposed for Database Software Delivery LifeCycle with automated testing and static code analysis
Oracle Developers Office Hours - Real World Testing of PL/SQL Code (hosted by Steven Feuerstein) Panel webinar with: Jasmin Fluri, Deepthi Bandari, Swathi Ambati & Maik Becker, Patrick Barel & Samuel Nitsche
Oracle Groundbreakers - Testing with utPLSQL (by Philipp Salvisberg) Presentation on 28th October 2020 at Oracle Groundbreakers APAC Virtual Tour
Oracle Developers Office Hours - Testing with utPLSQL (hosted by Connor McDonald) Live coding and testing session with Samuel Nitsche and Jacek Gebal
Testing in the Imperial Database (by Samuel Nitsche) Talk from SAST Q4 Digital Testing conference
Testing With utPLSQL – Made Easy With SQL Developer (by Philipp Salvisberg)
Database Development Champions - Programming With utPLSQL – This Is the Way (by Philipp Salvisberg)

Structuring Tests¶

utPLSQL’s Suite Hierarchy in action (by Samuel Nitsche)
Example of the %suitepath annotation and utPLSQL hierarchies
Narrate Star Wars Movies with utPLSQL annotations (by Samuel Nitsche)
Example how to use the different annotations that allow to structure tests (%before, %after, %context)
Testing the Deathstar security with utPLSQL contexts (by Samuel Nitsche)
Example how to use the %context annotation

Cursor Comparison¶

What is the equivalent of utassert eqtable / eqquery in utPLSQL v3 (by Jacek Gebal)
Comparison between utPLSQL v2's utassert.eqtable and v3's ut.expect(sys_refcursor).to_equal(sys_refcursor) approach.
Unit-Tests for Primary/Secondary Lookup with Cursor Comparison (by Samuel Nitsche)
Example how to use cursor comparison with select from dual expectations
utPLSQL Cursor Comparison with user-defined Types (by Samuel Nitsche)
Example how to use cursor comparison with expectations created via user-defined types
Test updatable views with utPLSQL Cursors (by Samuel Nitsche)
Example how to easily test the updatability of a view with cursor comparison

Code Talks¶

Tools¶

utPLSQL - SQLDeveloper extension¶

Running utPLSQL Tests in SQL Developer (by Philipp Salvisberg)
Detailed explanation how to install and use the utPLSQL-Plugin for SQLDeveloper
utPLSQL for SQL Developer 1.2 – What’s New? (by Philipp Salvisberg)
Documentation
Downloads

utPLSQL Command-line interface¶

utPLSQL PLSQL-Developer plugin¶

Maven-Plugin¶

Documentation