utPLSQL

Ultimate Testing framework for Oracle PL/SQL

[utPLSQL @utPLSQL]

utPLSQL is now stewarded by utPLSQL Development Labs Ltd. utPLSQL remains free and open source under the Apache License 2.0. The company holds the name and brand, and manages sponsorships and funded development.

https://t.co/Z1j6UXFnxO

[utPLSQL @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 @utPLSQL]

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.

https://t.co/dXC3rSxiW1
#utPLSQL #PLSQL

[utPLSQL @utPLSQL]

Rules worth knowing:
* case-insensitive Oracle regex (regexp_like)
* object expressions match the name without the schema
* an include expression makes --coverage-schemes and -include irrelevant
* an exclude expression makes the -exclude list irrelevant

[utPLSQL @utPLSQL]

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.

https://t.co/dXC3rSxiW1
#utPLSQL #PLSQL

[utPLSQL @utPLSQL]

utPLSQL is now stewarded by utPLSQL Development Labs Ltd.

utPLSQL remains free and open source under the Apache License 2.0. The company holds the name and brand, and manages sponsorships and funded development.

https://t.co/KUtYuWqsZQ...

#utPLSQL #PLSQL #OpenSource

[Jacek Gebal @GebalJacek]

@utPLSQL now has a legal home: utPLSQL Development Labs Ltd.

After years of maintaining it in my spare time, I decided it needs a sustainable structure. It stays free and open source (Apache 2.0).

Why, and what's next:
https://t.co/Ny8qwta0e5

#utPLSQL #PLSQL #OracleDatabase

[Jacek Gebal @GebalJacek]

@utPLSQL now has a legal home: utPLSQL Development Labs Ltd.

After years of maintaining it in my spare time, I decided it needs a sustainable structure. It stays free and open source (Apache 2.0).

Why, and what's next:
https://t.co/Ny8qwta0e5

#utPLSQL #PLSQL #OracleDatabase

[utPLSQL @utPLSQL]

utPLSQL is now stewarded by utPLSQL Development Labs Ltd.

utPLSQL remains free and open source under the Apache License 2.0. The company holds the name and brand, and manages sponsorships and funded development.

https://t.co/Z1j6UXFnxO

#utPLSQL #PLSQL #OpenSource

[Jacek Gebal @GebalJacek]

@utPLSQL now has a legal home: utPLSQL Development Labs Ltd.

After years of maintaining it in my spare time, I decided it needs a sustainable structure. It stays free and open source (Apache 2.0).

Why, and what's next:
https://t.co/Ny8qwta0e5

#utPLSQL #PLSQL #OracleDatabase

[utPLSQL @utPLSQL]

Busy weekend for utPLSQL.
utPLSQL-cli and maven-plugin have new releases.

[Jacek Gebal @GebalJacek]

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: https://t.co/fD2IQUlbkl
Maven plugin: on Maven Central - update your pom. #utPLSQL #PLSQL #OracleDB
@utPLSQL

[utPLSQL @utPLSQL]

utPLSQL is designed to allow for various reporting formats.
Check out this post to get familiar with what is available out of the box.

[Jacek Gebal @GebalJacek]

When designing utPLSQL we've focused on providing multiple test output reports.
In this post I go briefly through various reporting formats of @utPLSQL
https://t.co/0kyaJfvtYn

[utPLSQL @utPLSQL]

Financial and regulated companies can't rely on unmaintained software. We are bringing @utPLSQL back to active development and soon will open it up for sponsorship via GitHub Sponsors soon. https://t.co/Fz0JDLUs3L

[Jacek Gebal @GebalJacek]

Correct exception handling is one of essential elements of software engineering. It is no different with Oracle PL/SQL.

@utplsql is designed to support developers when testing exception handling.

My latest post focuses on that https://t.co/FxsaUUiOgr

#utPLQL #oracle #testing

[Jacek Gebal @GebalJacek]

When testing the PL/SQL code one of essential elements to test is the dataset that is manipulated or returned.
@utPLSQL make it the job easy with build-in result set comparison using cursors.

Read more in my starter tips part four:

https://t.co/UrEOOJVGMQ

[Jacek Gebal @GebalJacek]

I just publish next of the mini-blog series on @utPLSQL
This time giving a quick look at the expectations syntax.

If you enjoy the read or use the framework, drop a comment or repost.
https://t.co/vRzuy4fPkT

[utPLSQL @utPLSQL]

We have a fresh release of utPLSQL framework for you.

[Jacek Gebal @GebalJacek]

Another release of @utPLSQL is here.
This release adds support for uninitialised exception variables in
the --%throws
It also supports installation in EBR enabled schema
Addresses some minor issues.
https://t.co/0GdfGk8jRj

[utPLSQL @utPLSQL]

In case you have missed this info,

SQL Developer extension version 2.0.1 was released on 17th of June.
This is a maintenance release. It takes care of updating all dependencies, java version and SQL Developer compatibility.

Thank you @phsalvisberg 🙏
https://t.co/sTbTMsFfpc

[Jacek Gebal @GebalJacek]

@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.
https://t.co/8hBVeBfpqF — feedback welcome GitHub Discussions.
#utPLSQL #Oracle #testing #database

[utPLSQL @utPLSQL]

A fresh release of the utPLSQL framework is out.
It includes fixes for new and old issues.

[Jacek Gebal @GebalJacek]

A new version of @utPLSQL is here
Few important bug fixes included in this release.
https://t.co/PxTaIkEKTb

[Jacek Gebal @GebalJacek]

A new version of @utPLSQL is here
Few important bug fixes included in this release.
https://t.co/PxTaIkEKTb

[utPLSQL @utPLSQL]

New version 3.2.0 of utPLSQL-maven-plugin is now released.

This release is a technical update mostly.

The update brings changes from newest java-api release 3.2.4

See release info for details.
https://t.co/Dhx16memrR
https://t.co/oKhpH5ACi9

[utPLSQL @utPLSQL]

New version 3.2.0 of utPLSQL-cli is now released.

This release is a technical update mostly.

The update brings changes from newest java-api release 3.2.4

See release info for details.
https://t.co/1VJukbQIv0
https://t.co/oKhpH5ACi9