Skip to content

releases

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

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

Changes in release 3.1.10

Enhancements

  • utPLSQL test runner is now validating arguments of --%throws annotations at runtime #721 #1033
  • Documented limitations of insignificant spaces comparison in compound data #880
  • utPLSQL will now detect empty annotation cache for schema even with DLL trigger enabled #975
  • Order of procedures and annotation now determines default order of tests in suite #1036

Bug fixes

  • Nested contexts are now properly identified #1034
  • TeamCity test reporter is now including error message #1045

Internal improvements

  • All self-tests for utPLSQL framework can now be executed using test-owner schema #969
  • Misleading rollback warning is no longer showing when running self-tests for utPLSQL #982

Downloads

Download v3.1.10 release version here