utPLSQL / utPLSQL-SQLDeveloper

New

• #87 - Debug utPLSQL tests

  • New context menu item Debug utPLSQL test... in
    • Connections window
    • PL/SQL editor
    • Worksheet
    • Realtime Reporter
  • New "Debug" button on the toolbar of Realtime Reporter
  • Change default initialization timeout from 60 seconds to 60 minutes when running tests in the debugger
  • New "Stop" button on the toolbar of Realtime Reporter, aborts any test run

• #102 - Run utPLSQL tests with code coverage

  • Run code coverage together with realtime reporter
  • New context menu item Code coverage... in Realtime Reporter
  • New "Code coverage" button on the toolbar of the Realtime Reporter

Improved

• #101 - Replace Xtend with Java

Fixed

• #99 - Code coverage is not working with access to dba_objects but no access to dba_dependencies
• #107 - Crash of Realtime Report when server output contains CDATA sections

• #86 - Missing checkmark in popup menu on Windows with Windows Look & Feel
• #89 - Cannot navigate to failed test with throws annotation
• #93 - Coverage Report may throw ORA-20000: ORU-10027: buffer overflow, limit of 1000000 bytes

New

• #60 - Snippets for utPLSQL annotations and expectations
  • New groups in Snippet view
    • utPLSQL Annotations
    • utPLSQL Expectations
  • Import snippets from preference dialog
    • Merge into UserSnippets.xml
    • Existing user snippets (with different group names) are preserved
  • Add to test code by drag and drop (SQL Developer feature)
• #66 - Show overall elapsed time during test run
  • Shown at the upper right corner
  • Updated every 100 milliseconds
  • At the end of the test the runtime provided by utPLSQL is shown, this time is lower, since the initialization time is not accounted for
• #67 - Use smart times
  • Change units to avoid leading zeros, e.g. 4 ms instead of 0.004 s
  • Configurable within the utPLSQL preference dialog
• #73 - Filter tests in overview table according result status
  • Defaults defined in utPLSQL preference dialog
    • Show successful tests?
    • Show disabled tests?
  • Checkbox menu items in popup menu of the overview table
    • Show successful tests
    • Show disabled tests

Improved

• #63 - Simplify code coverage when running tests in other schemas
  • Reduce need to define Schema under test
  • Default dependencies shown in Include objects are qualified with schema names
• #64 - Show error message when utPLSQL is not installed when running Realtime Reporter
• #70 - Hint that Realtime Reporter requires utPLSQL v3.1.4 or higher
  • Add hint in the Preference dialog for Use Realtime Reporter?
  • Opens a worksheet when an older utPLSQL version is used
• #74 - Reduce flickering when running tests with a scrollbar in the overview table
• #76 - Faster enable/disable of Run utPLSQL test menu option
  • Relevant when preference Check availablity of menu option is set for Run utPLSQL test
  • Requires utPLSQL v3.1.8 or higher

Fixed

• #80 - Realtime reporter produces no output
  • No tests found after a timeout of 60 seconds
  • Fixed by starting the producer thread after the consumer thread

New

• #6 - Run utPLSQL tests in a dedicated utPLSQL view
  • Realtime reporter as dockable window
  • Green progress bar while all tests succeed
  • Red progress bar when one or more tests failed or errored
  • Asynchronous test execution
  • Continuously updated test results (in near realtime)
  • Browse through test overview (keys Up, Down, PgUp, PgDn, Home, End or scroll wheel)
  • Open test package in the PL/SQL editor on double-click
  • Sort tests by status, indicators, suitepath/description, execution time
  • Reset sort order (by test execution)
  • Show common suitepath prefix in column header
  • Hyperlinks for code references in test details tabs (failures, errors, warnings and info)
  • Report warning and info messages on suite level in last test of a suite
  • Synchronize test details tab based on selected test and its status
  • Enable/disable counters per run (disabled, warnings, info)
  • Enable/disable indicators per test (warnings, info)
  • Enable/disable test description in overview
  • Run tests in parallel (is useful for independent tests only)
  • Rerun all tests (in same window or in a new worksheet)
  • Rerun selected tests (in same window or in a new worksheet)
  • History of last test runs
  • Clear history of last test runs (except currently selected run)
  • Requires utPLSQL v3.1.4 or higher (otherwise tests run in a worksheet)
• Preferences
  • Use realtime reporter?
  • Realtime reporter preferences
    • Number of runs in history
    • Show disabled counter?
    • Show warnings counter?
    • Show info counter?
    • Show warning indicator?
    • Show info indicator?
    • Show description (if present)?
    • Synchronize detail tab based on test status?

Improved

• Updated utPLSQL logo in context menu
• Preferences grouped in tabs
  • Run utPLSQL test
  • Realtime Reporter
  • Generate utPLSQL test
  • oddgen

Fixed

• #59 - Always use the utPLSQL annotation API to identify a test based on the cursor position within a PL/SQL editor

• #54 oddgen "Run test" view under "All Suitepaths": show package icon only for parents of test procedures
• #55 oddgen "Run test" view under "All Suites": Include suites without tests
• #56 "Run utPLSQL test" is disabled for suites without test

New

• #46 Manage utPLSQL core compatiblity explicitely
  If utPLSQL v3.1.3 or later is installed, then the new annotation API is used.
  Descriptions will be shown in the oddgen navigator window, when defined for a test, context or suite.

Improved

• #51 oddgen "Run test" generator is slow

Fixed

• #49 Wrong indentation in SQL Developer package body code template

• #47 Connections of unshared worksheet are not closed

• #44 utPLSQL suitepath is case-insensitive

• #42 ut3 schema hardcoded in oddgen report