#utplsql

utPLSQL-cli 3.2.1 and utPLSQL-maven-plugin 3.2.1 are out. Both add Oracle Wallet connections. The cli also has fixes to keep credentials out of logs. cli: Maven plugin: on Maven Central - update your pom. #utPLSQL #PLSQL #OracleDB @utPLSQL

utPLSQL for SQL Developer 1.4.0 is now available. All known bugs are fixed. Updated code templates. Showing the reason for disabled tests. #utplsql #plsql #sqldev #oracledatabase

@utPLSQL website got some nice updates this week. Redesigned site nav bar, a Light/Dark/Auto theme toggle that follows OS, a better announcements navigation with categories. — feedback welcome GitHub Discussions. #utPLSQL #Oracle #testing #database

Unit Test failures with date/timestamp logic #utPLSQL

utPLSQL tip! The coverage regex matching options are not anchored. -include-object-expr='ORD' also matches RECORD_PKG and BORDER. Use anchors to describe what you mean: '^ORD' - match all objects starting with `ORD` 'ORD$' - match all objects ending with `ORD` #utPLSQL #PLSQL

utPLSQL-cli 3.2.2: define code coverage scope with regular expressions -include-schema-expr='^APP_' -exclude-object-expr='_TMP$' For code that can't be mapped to project files: include/exclude by pattern, no long lists. #utPLSQL #PLSQL

Excellent presentation at #apexconn23 by @Matt_Mulvaney about the APEX Application Development Lifecycle Paper by @stevemuench

And the summary. Use #utPLSQL 👍

The QA framework “Quasto” by @OliverLemm at #DOAG2000

You find the Git repo here:

Can be used to generate #utPLSQL tests. The idea is to reuse its reporter functionality.

Next at #POUG2023: #utPLSQL 🥰 by Mariusz Masewicz

Useful links #utPLSQL: #POUG2023

you're testing your code? good! :) maybe you are using #utPLSQL for your database objects and data, but for #orclapex you can also always use the packaged app "Application Standards Tracker" to execute dictionary driven tests!

Playing with Unit Testing for PL/SQL using #utPLSQL and #Oralce Developer Cloud Service #DevCS - blog coming soon

The newest version of dbFlux is out and now supports utPLSQL Code Coverage! #dbFlux #utPLSQL #orclAPEX

1/5 Finally the slide deck for my talk "Simplify Database Code with utPLSQL" at #apexconn22 is ready. 04-May-2022 09:00 in room Quantum 2. Let's play Wordle game #0 together.

4/5 I love this slide. I guess I have to explain one or two things before we start refactoring.

5/5 A live demo of #utPLSQL in #SQLDev is mandatory. Interested? Then I hope to meet you #apexconn22 in @Phantasialand.

#utPLSQL 3.1.8 is released! Highlights: - UT-Information in SYS_CONTEXT during test-run - Standalone ut.expect() assertions without running the framework - Several improvements and fixes

My favourite slide from yesterdays Office Hours. Could it be any easier to compare two data sets? ⭐️⭐️⭐️⭐️⭐️ You can watch the full video about 'Real World Testing of PL/SQL Code' on YT: #utPLSQL #unitTesting #database #oracle #plsql #SQLDev

#utplsql #maven plugin is now released. It supports all the functionality of @utPLSQL v3 API. Integrating #Oracle #PLSQL Unit Tests with #maven build is now really easy. Thanks to all the people involved. Special thanks to @mrvmoreira for working on the last miles of release.

Now @Der_Pesse and an introduction to #utPLSQL #UnitTesting #TestAutomation

Automate PL/SQL testing with #utPLSQL in #Oracle #Database Cloud Service with Oracle Developer Cloud Service

A hot weekend is ahead and I plan to work on the enhancement of the Java API, CLI, and Maven plugin of @utPLSQL to support expressions to run tests. OSS will cool me down ;-) #utPLSQL #OSS

Hey #utPLSQL gurus, what is the best way of setting up a test with quite a few rows in a dozen different tables? With only five tables I did a multi table insert from one JSON string, but this time the input exceeds the character limit. Are there any recommended practices?

Note to self: When #utPLSQL cache is incomplete and refuses to be updated via trigger, use exec ut_runner.rebuild_annotation_cache('MY_SCHEMA');