DPL Usage with Appvance Designer Script

How to work with DPL in Appvance Designer scripts?

1. Navigate to Appvance Designer

2. Click File > New

3. Click Record and provide a valid URL and start recording the desired use case where there are setValues involved in the script

4. Once the recording of the script is complete something looks like the below

   

5. Assuming the user has to data enable Row 5, 6 and 7

6. Create a data CSV sheet with 3 columns and have data for all those 3 columns, Example screenshot below

   

7. Now come back to Appvance Designer, click Options > DPL Options > and browse the CSV sheet that was created and Click OK

8. Go to the Data tab at the bottom, Drag the first value from column 1 and drop the same in the value filed of Row 3, the value should get changed to “$CompanyName”

   Note: The column name can be anything specific

9. Similarly, drag and drop the same for Row 5 and 6

   Below is the screenshot of how this should look

   

10. Click File > Save and save the Appvance Designer Script

11. Now go to Build and navigate to Scenario builder to create the data enabled scenario

12. Click File > New

13. Info Tab: Select a functional test or performance test based on the requirements

14. With the example below I am selecting functional test with Repeat this use case options set to 2 in the test management section, in the case of performance test user can provide the number of users and other completion criteria that can be used as per the requirements

15. Navigate to the Resource panel: Select “HashDPL-Reads CSV” as the type and provide some valid DPL name, Browse and select the CSV file that we created while creating the Appvance Designer Script

    

16. Come back to the test case panel: Click ‘Add a test case execution’, Select ‘Appvance Designer script’ from the test type drop-down, Browse the Appvance Designer script that was created which was data-enabled, Leave other options to default

17. Click Add DPL, Provide any valid name, select the DPL that was created in the resource panel in the available drop-downs and select Action to be ‘Get Next row of Data’

    

18. Click Save

19. As this is a functional test with a repeat use case set to 2, the scenario will run the test case for a couple of iterations and pick 2 different values from the CSV sheet

20. Logs in the Options panel can be set to 100%

21. Click File > Save and save the scenario and click play Scenario

22. The test controller will open and run the test scenario that was set up, as mentioned this test will run for 2 iterations picking 2 different values from the CSV sheet

23. Once the test is complete, click test case execution on the test controller, you should notice 2 successful executions

24. Click each execution and notice the values that were picked as seen in the below screenshot

    

How to use RDBMSMapDPL in the Appvance Designer Script?

1. Navigate to Appvance Designer

2. Click File > New

3. Click Record and provide a valid URL and start recording the desired use case where there are setValues involved in the script.

4. Assuming the user has to data enable Row 7

   

5. Now Data Enable value field, i.e Provide the column name of the table from which data will be retrieved

   

6. Click File > Save and save the Appvance Designer Script

7. Now go to Build and navigate to Scenario builder to create the data enabled scenario

8. Click File > New

9. Info Tab: Select a functional test or performance test based on the requirements

10. Navigate to the Resources panel and click Add Data source

    • Select RDBMSMapDPL from DPL drop-down

    • Enter valid inputs in SQL Server, Database URL, User, Password, and query fields

    Example:

    SQL Server- com.mysql.jdbc.Driver

    Database URL- jdbc:mysql://localhost:3306/utp?useSSL

    User- utp

    Password- utp

    Query- select ResultOnTimeID from utp.ResultOnTime

11. Come back to test case and select the DPL added from the drop-down

12. Save and play scenario

13. The test controller will open and run the test scenario that was set-up

14. Once the test is complete, click test case execution on the test controller, Click each execution and notice the values that were picked