The SQL elements within the Agentry Test Script are provided to allow for the interrogation of the back end system processing built into the mobile application from within the test script. These elements do not affect the test client in any way. Rather, they are added to a test script to connect to and run queries against a database. Values returned by these queries can then be checked for expected values to validate the proper back end processing of the mobile application.
The primary use case for these elements is to check the proper processing of the mobile application’s transactions. Typically these statements would be added to the script after a transmit is performed within the script that includes sending transactions to the Agentry Server for processing.
However, the SQL elements can be added at any point within the script where it is desirable to check the data in the back end as it relates to the mobile applications synchronization processing. Updates or changes made to exchange information and similar data can certainly be verified using these elements if desired.
The SQL elements are not added to the test script by the script recorder, but rather should be manually added to the script once it has been created.
Note that these elements are intended only for connecting directly to a database server. However, they can be used in testing an application with other types of system connections, provided there is direct access available to the database that may be behind the Java or Web Service interface.