Useful Tips

Description

You can define variables as per your choice whose value can be substituted in the test case definition.

Availability

Web Functional Testing

Solution

Choose the Data Configuration option from the script editor toolbar options to select the Variables option and configure the variables as per requirement.

Refer Configuring Environment Variables for details.

Description

I want to define my own functions using the def statement and call the same from webscript.

Availability

Web Functional Testing

Solution

1. Create a python script <fileName>.py and save it under <QEngine Home>/jars/ directory, and define your functions in that file. Instead of saving the .py file under <QEngine_Home>/jars directory, you can also edit the file setcommonenv.bat/sh file and provide path to the ".py" file for the variable PY_PATH.

2. In your script, you can import the .py file using

from "<filename>" import *

This must be done in the first line of the script.

3. Now, you can use the functions defined in the .py file.

Description

I want to check the values of html table column (color) with the database table column(color).

Availability

Web Functional Testing

Solution

Can be achieved using the sample code given below:

result=getAllHTMLTableCells("Table1")

initDB("1.1")

result1=getDBValues("select color from diamonds")

rowcnt=len(result1)

check=""

for i in range(0,rowcnt):

dbVal=str(result1[i][0])

tableVal=str(result[i+1][1])

if dbVal!=tableVal:

check="false"

break;

if check=="false":

reportStatus("dbcheck",1,"DB and Table Values Check")

else:

reportStatus("dbcheck",0,"DB and Table Values Check")

In the above example, result is the array values retrieved from html

table and result1 is the array values retrieved from database by executing a

query. In the for loop, the value at a specified index of the array is

checked and the variable is initialized to "false", if the check fails. The report status is reported using the reportStatus() to view the status of the test in the reports.

Description

Can I use any database such as MS SQL Server or Sybase to check or get the db values using Database Checkpoint option or Data Configuration->Database option.

Availability

Web Functional Testing

Solution

Yes, QEngine supports any JDBC compliant database. But, you need to set the appropriate classpath for the database driver by editing the DB_CLASSPATH variable in setcommonenv.bat/.sh file in <QEngine_Home> directory. Also, you need to add the new database by clicking the "Configure" button next to the Database field in "Insert Testcase->Database Checkpoint" screen or in "Control->Data Configuration->Database" screen.

Description

Want to use python modules in webscript.

Availability

Web Functional Testing

Solution

To use python modules in webscript, download the zip file from the following url:

http://forums.adventnet.com/download.php?id=386

Extract the downloaded file under <QEngine_Home> directory. Edit the file setcommonenv.bat/sh file and provide path to "<Python_installation directory>/lib folder (where the python modules are placed) for the variable PY_PATH. Then, use the import statement to import the required python modules as import "<python_module_name>" which should be the first line in the script.  Now, you can include your python modules.