Skip to content

Announcements

utPLSQL v3.2.01 released

Important

  • Dropped support for Oracle Database versions older than 19c

New features

  • Add TAP reporter by @WayneNani in #1305

Enhancements and bug fixes

  • Added duplicate detection on cursor comparison using join_by by @lwasylow in #1295
  • Fix code causing the object duration Oracle exception on oracle 23.26 by @lwasylow in #1310
  • Packages with annotation-like comments are not test suites by @jgebal in #1313
  • Performance improvements to annotation parsing by @lwasylow in #1312
  • Updated documentation and copyright banners across source files @jgebal in #1319

Download utPLSQL release v3.2.01 here

utPLSQL v3.1.14 released

What's Changed

  • Added support for and and or operators when running tests by tags by @lwasylow in #1250
  • Allow for test runs over 4 hours by @jgebal in #1243
  • Framework performance improvements by @jgebal in #1249
  • Support multiple expectation failures with teamcity reporter by @jgebal in #1251
  • Address issue where the not_to(contain) not run correctly by @lwasylow in #1246
  • Fix regex to be NLS_SORT independent by @jgebal in #1253
  • Fix output length error and output buffer. by @jgebal in #1255
  • (docs): Update running-unit-tests.md - remove example by @gassenmj in #1261
  • The line-rate is not recorded for packages and classes in cobertura coverage reporter by @lwasylow in #1269
  • (docs): Fix nested list issue by @iamrachid in #1274
  • Update TFS reporter to correct format by @lwasylow in #1270

New Contributors

Full Changelog: v3.1.13...v3.1.14

Download utPLSQL release v3.1.14 here

Changes in release 3.1.13

New features

  • Add ability to run tests by part of a name. Fixed in #1203, resolves #470

Enhancements

  • Added documentation section on creating a custom reporter. Fixed in #1225, resolves #710
  • Add ability to specify code coverage objects include/exclude masks as regular expressions. Fixed in #1186, resolves #1053

Bug fixes

  • Comparing collection that have long type names. Fixed in #1238, resolves #1235.
  • Code coverage reporting on code with long lines. Fixed in #1240, resolves #1232, #1087.
  • Code coverage reporting does not exclude tests. Fixed in #1226, resolves #1222.
  • Uninstall script buffer overflow. Fixed in #1221, resolves #1220.

Internal improvements

  • Improved process of generating utPLSQL documentation. Implemented in 689bbd0, resolves #1237.
  • Removed username env variables for internal development. Implemented in #1201, resolves #1200.
  • Test execution data of utPLSQL project not showing on SonarCloud. Implemented in #1199, resolves #1198.

Downloads

Download v3.1.13 release version here

  • in website
  • 1 min read

New website design

Today is #JoelKallmanDay.

As memorial of Joel Kallman, on this day utPLSQL launched its new website using different engine.

We have moved away from using Jekyll with GitHub Pages to host project and organization sites. Jekyll was simply too much hussle and we used MkDocs to generate offline documentation for utPLSQL that was packaged into the release zip file.

So instead of using two different methods, wei will now use only one. MkDocs is now used for both utPSLQL offline and for online organization and project pages.

Thanks to wonderful material theme and mike(versioning plugin) for MkDocs you may now enjoy the following new features:

  • dark & light theme
  • better navigation and menu in utPLSQL documentation
  • documentation version dropdown
  • powerful and fast search within documentation

Hopefully, you will like the changes and enhancements. All the permanent links to old site should still be working.

Changes in release 3.1.12

New features

  • Added support for description in the --%disabled annotation. See documentation. Implemented in: #1183, resolves #610.
  • Added support for native JSON datatype on Oracle 21c. Implemented in #1181, resolves #1114.
  • Added new mather to_be_within( distance|pct ).of_(expoected). See documentation. Implemented in #1076, resolves #77.

Enhancements

  • Improved performance of SQL used to retrieve Coverage sources. Implemented in #1187, resolves #1169.
  • Added ability for utPLSQL to gather coverage on code invoking DBMS_STATS package. Implemented in #1184, resolves #1097, #1094.
  • Fixed typos and improved documentation. Implemented in #1173, #1171

Bug fixes

  • Actual and Expected are now correctly reported when comparing JSON data. Implemented in #1181, resolves #1113.
  • Packages with removed annotations are now correctly recognized as non-utPLSQL packages. Implemented in #1180, resolves #1177.
  • Fixed issues with comparison of nested object structures. Implemented in #1179, resolves #1082, #1083, #1098.

Internal improvements

  • Moved build and test process for utPLSQL from Travis to GithubActions. Implemented in #1175

Downloads

Download v3.1.12 release version here

Changes in release 3.1.11

Enhancements

  • utPLSQL can now be used to generate coverage reports for external tools. See documentation Implemented in: #1079, resolves #1025
  • Enhanced UT_COVERAGE_COBERTURA_REPORTER to better support TFS and GitLab. Implemented in #1137 and #1140, resolves #1107
  • Added support for installation on Oracle 21c - removed dependency on DBMS_OBFUSCATION_TOOLKIT. Implemented in #1112, resolves #1111 and #1127
  • Added support for running utPLSQL framework in parallel-enabled database. Implemented in #1160, resolves #1134

Bug fixes

  • Suite structure is built properly even with other than English TNS settings. Implemented in #1061, resolves #1060
  • Fixed XML content reporting (CDATA) in UT_REALTIME_REPORTER used by SQLDeveloper plugin. Implemented in #1075, resolves #1073
  • Fixed XML content reporting (CDATA) in JUnit reporter - regression. Implemented in #1085, resolves #1084
  • Fixed issue with utPLSQL failing to run coverage reporting when trigger has overlapping name with procedure/function/package/type. Implemented in #1091, resolves #1086
  • Fixed issue with parsing utPLSQL suites with DDL trigger when usign AUTHID clause. Implemented in #1093, resolves #1088

Internal improvements

  • Improved how privilege checks are handled by framework installation. Implemented in #1056, resolves #1050
  • Restructured installation instructions to make it more readable. Implemented in #1063, resolves #1062
  • Updated database requirements in documentation. Implemented in #1065, resolves #1064
  • Removed duplicated call to install profiler tables. Implemented in #1164, resolves #1149
  • Fixed failing internal framework tests on Oracle 21c. Implemented in #1158, resolves #1151
  • Fixed confusing typo in documentation. Resolves #1154
  • Moved build process from travis-ci.org to travis-ci.com. Implemented in #1152
  • Added an example of reporter reporting all expectations, not only the failing ones. Implemented in #1092

Downloads

Download v3.1.11 release version here

PL/SQL Developer plugin released!

Happy new year! Thanks to Simon Martinelli utPLSQL v3+ is now integrated with PL/SQL Developer IDE

Features

  • The Plugin enables PL/SQL Developer to run tests and code coverage with utPLSQL
  • Tests and code coverage can be run for the current user from the tool ribbon or from the context menu on a package or a user
  • Test results shown in a test runner window and the code coverage report will be opened in the default browser

Documentation

See details of plugin usage in readme file

Downloads

  • Download the plugin release from releases page
  • Copy PlsqlDeveloperUtPlsqlPlugin.dll or PlsqlDeveloperUtPlsqlPlugin_x86.dll to the PlugIns directory of your PL/SQL Developer installation