(DV-2402) Query Execution & Backend

Owned by SNP
Last updated: Mar 07, 2024 by Marian Vidra
5 min read

Query Test Case Execution

When added to a Test Plan a new backend Test Run is automatically created. The Test Run has a generated Run ID, while the description holds the technical name of the Test Plan and Test Case. 
All Query Variants that were selected during the creation of a Query Test Case are automatically added into the Query Variant selection for the generated Test Run. You can execute the Query Test Cases from the Test Management by clicking on the image-20240307-113002.png Execute button and the screen for a standard Query Testing scenario will be displayed.

Query Based Testing

The Query-based testing uses the query output as the test data and the before image of the query output is then compared with the output of an after image of the query output. 
The actions that lead to the creation of both these images can vary based on the purpose of each scenario. SNP Validate currently supports one testing scenario with this type of testing. When the queries are executed using SNP Validate the cache is not used, the reason for this is to get as precise as possible, the runtime values for both the before and after image. 
Recommendations:

  • A maximum of 1,000 Query Variants should be used in each created run of the Query Testing scenario.

  • Processing time for each step depends on the queries that are processed. E.g. if there are lots of queries resulting in a huge output (more than 100 000 rows) the processing time may take longer than that of the query with a smaller output.

Test Scenario EQS (Query Testing)

image-20240307-112444.png

Query Testing scenario steps

 

The Query Testing Scenario contains the following steps:

  1. Select Query Variants

  2. Create the Before Image

  3. Performing some specific tasks in the system outside SNP Validate (like archiving, migration, etc.)

  4. Create the After Image

  5. Compare Before and After Image

  6. Display of results

You can navigate and execute all steps by double-clicking on them.

Select Query Variants

You can choose which Queries/Bookmarks are to be used for testing, the definition and selection of query/bookmarks variants are necessary and can be done in the main window of this step.

image-20240307-112616.png

Selection of Query Variants

 

All of the Query Variants that are added to this list are then used in the subsequent steps of the Query Testing scenario. There are multiple ways to add/create Query Variants into the list:

 

Create New Query Variant: Refer to Create new Query Variant section for a detailed description of Query Variant's creation. The only difference is in the variant creation the confirmation button is not the Continue button (Enter) but the Save button (Enter). 
By double-clicking on the created Query Variant, you can reenter and edit the Variant properties. Remember, it is not possible to edit variant properties if the same variant is already in use for another Test Run.
Create New Bookmark Variant: Refer to Create new Bookmark Variant section for a more detailed description as the screen for defining Bookmark Variant directly in the run. The only difference is in the variant creation confirmation button, which in this case is not the Continue button (Enter) but the Save button (Enter). 
Add existing Query Variant: List of all the existing Query Variants in a system is displayed and you can select a set of variants to be added by using the Copy button (Enter). Note that each Query Variant can only be used once in each Test Run. 
Add Query Variant from Test Run ID: By clicking the Add Query Variant from Test Run ID button, a list of all the existing Query Testing Runs is displayed. You can a Test Run and add all variants used in one run to the current Test Run.
Copy Query Variant of Run: By clicking the Copy Query Variant of Run button, a list of all the existing Query Testing Runs is displayed. You can select a Test Run and add all variants used in another run to the current Test Run as copies.
Generate Query Variants from HM (Optional): You can automatically generate new Query Variants, to use this option you must have the HeatMap tool present in the system. 
Add Variants of Test Case: By clicking the Add Variants of Test Case button, a list of all the existing Query Test Cases is displayed. You can select a Test Case and add all variants used in it to the current Test Run.
Copy Variants of Test Case: By clicking the Copy Variants of Test Case button, a list of all the existing Query Test Cases is displayed. You can select a Test Case and add all variants used in it to the current Test Run as copies.
Create Based on Web Template: Click on the Create Based on Web Template button (Shift + F7). Refer to Create Variants of Web Templates section.
Copy Variants: Refer to the Copy Query Variants section for function details.

Generate tasks for before image

This step is executed automatically by double-clicking on it. Afterward the executable tasks for each defined Query/Bookmark Variant in the Select Query Variants step are generated and visible in the following step Create before image.

Create before image

By double-clicking on this step, you first define the number of background jobs to be used for the execution of tasks. After each task is completed a before image of the corresponding query output is created and saved for later comparison.

Generate task for after image

This step is executed automatically by double-clicking on it. After the generation of the tasks for each of the defined Query/Bookmark Variants from the Select Query Variants step. These are to be executed in the following step Create after image.

Create after Image

By double-clicking on this step, you first define the number of background jobs to be used for the execution of tasks. After each task is completed an after image of the corresponding query output is created and saved for later comparison.

Generate tasks for comparison

This step is executed by double-clicking on it. The tasks for each of the defined Query/Bookmark Variants in the Select Query Variants step are generated and can be found under the following step Compare before and after image.

Compare before and after image

By double-clicking on this step, you define several background jobs to be used for the execution of tasks. Each task compares the before image data with the after image data for one Query Variant.

Display results

To view the Query Variants execution outputs and their comparison results. For more information refer to the Results overview section.