DataGrip 2023.3 Help

Run utPLSQL tests

utPLSQL is a testing framework for Oracle databases. You can use utPLSQL to test packages, functions, procedures, triggers, views, and other objects that can be used in PL/SQL.

To use utPLSQL, install the framework into your Oracle database. See the installation instructions in the official utPLSQL documentation.

To get a quick overview of utPLSQL and examples, see Getting started with TDD and utPLSQL at utplsql.org.

Step 1. Enable the utPLSQL schema

To use utPLSQL objects in your tests, enable the utPLSQL schema in DataGrip.

  1. Click the N of N link near the data source name. In the schema selection window, select the utPLSQL schema (for example, UT3).

  2. Press Enter.

    Enable the utPLSQL schema

Step 2. Create a function to be tested

  1. In the Database Explorer ( View | Tool Windows | Database Explorer) , right-click the Oracle data source and select Open Query Console.

  2. Write the code of a function that you want to test. Consider the following example:

    create or replace function sub_str( received_string varchar2, start_pos integer, end_pos integer ) return varchar2 is begin if start_pos = 0 then return substr( received_string, start_pos, end_pos - start_pos ); else return substr( received_string, start_pos, end_pos - start_pos + 1); end if; end; /
  3. Click the Execute button (the Execute button) or press Control+Enter.

    Create a function to be tested

Step 3. Create a testing package

  1. In the Database Explorer ( View | Tool Windows | Database Explorer) , right-click the Oracle data source and select Open Query Console.

  2. In the editor, type code of a package that lists all your tests. Consider the following example:

    create or replace package example_package as --%suite(Checks a substring in a string) --%test(Returns a substring when the start position is not zero) --%tags(basic) procedure start_not_zero; --%test(Returns a substring when the start position is zero) --%tags(with_zero) procedure start_zero; end; /
  3. Click the Execute button (the Execute button) or press Control+Enter.

    Create a testing package

Step 4. Create test procedures in the testing package

  1. In the Database Explorer ( View | Tool Windows | Database Explorer) , right-click the Oracle data source and select Open Query Console.

  2. In the editor, type code of test procedures. Consider the following example:

    create or replace package body example_package as procedure start_not_zero is begin ut.expect( sub_str( '1234567', 2, 5 ) ).to_equal('2345'); end; procedure start_zero is begin ut.expect( sub_str( '1234567', 0, 5 ) ).to_equal('12345'); end; end; /
  3. Click the Execute button (the Execute button) or press Control+Enter.

    Create test procedures in the testing package

Step 5. Run utPLSQL tests by using a run configuration

  1. Open the Run/Debug Configuration dialog in one of the following ways:

    • Select Run | Edit Configurations from the main menu.

    • With the Navigation bar visible (View | Appearance | Navigation Bar), choose Edit Configurations from the run/debug configuration selector.

    • Press Alt+Shift+F10 and then press 0.

  2. In the Run/Debug Configurations dialog, click the Add New Configuration icon (the Add New Configuration icon) and select utPLSQL Test.

    • Data source: a name of a data source. utPLSQL supports Oracle.

    • Paths: a qualified path to the testing package (for example, GUEST.EXAMPLE_PACKAGE).

    • Tags: tags of tests that you want to run. Use semicolon (;) as separator (for example, basic;with_zero).

    For more information about settings of the utPLSQL Test configuration type, refer to utPLSQL Test.

  3. You can either run the configuration right away, or save the configuration to run it later.

    • Click OK to save the run configuration for later and close the dialog.

    • To run the configuration right away, click Run.

Run files by using run/debug configurations

Productivity tips

Run tests from the editor

  1. In the Database Explorer ( View | Tool Windows | Database Explorer) , double-click the test.

  2. In the editor, click the Run icon the Run icon in the gutter and select Run <procedure_name>.

    Run tests from the editor

Rerun failed tests

  • In the Run tool window, click the Rerun failed tests button

Last modified: 04 May 2023