Run utPLSQL tests

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.

   

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 () or press Ctrl+Enter.

   

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 () or press Ctrl+Enter.

   

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 () or press Ctrl+Enter.

   

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.

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

   The fields that appear in the right-hand pane display the default settings for the selected configuration type.

   • 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).

3. Apply the changes and close the dialog.

4. Click the Run <configuration_name> button .