What are different activities in Testing Process

Testing Process includes following activities that should be followed sincerely for proper testing.

1. Test Planning

Before beginning with testing, we need to define test plan based on which we perform testing for the rest of testing life cycle. We should develop a test plan based on following key points to be considered in testing life cycle.

• Test Objectives should be measurable, prioritized, and should be signed off between stakeholders before moving forward with test planning. Acceptance Criteria should also be defined during objective settings to validate if the test objective has been accompanied.

• Test Matrix should be defined on how to test the test objectives and to validate all the requirements are covered in testing.

• Test Schedule should be defined, how milestones in testing will be covered and timeframe in which milestones will be delivered

• Budgeting and resources planing should be defined.

• Testing material including environment ans software/availability should be defined.

• Training required for testing should be defined.

2. Test Control Activities

Once Test plan is created and signed off by stakeholder, Activities in test plan should be compared with actual and any deviation from the projected plan should be reported to stakeholders as risk.

3. Test Analysis

In this phase, test objectives defined in test planning are converted into test scenarios and test cases.Below are the main task in this phase:

• Reviewing the test artifacts like business requirements, design, and test objectives.

• Identifying and prioritizing test scenarios and test cases based on business requirements.

• Identification of test data for execution of test conditions

• Test environment availability

4. Test implementation

Below are activities in test implementation

• Developing and prioritizing test cases with test steps

• Preparation of test data for execution of test scripts.

• Environment set up for testing.

• Development of automation test harness.

• Preparation of test suites for regression, smoke testing, and execution of similar tests in batch.

5. Test Execution and Reporting

• Execution of test scripts either manual or automated.

• Reporting defects found during test script execution.

• Regression testing and retesting of fixed defects. 

• Reporting of test execution status to stakeholders.

6.  Exit criteria

• Evaluating Testing status against the exit criteria specified in test planning.
• Test Status should validate that all acceptance criteria are verified.

7. Test Closure Activities

• Delivering all the planned test artifacts to the client. For e.g : Automated Test Scripts,test scripts, test data for further reuse.

• Handover of artifacts and knowledge transfer to maintenance team

• Analysis of lesson learnt during testing process.

How to create a database checkpoint in QTP

A database checkpoint compares the values returned by SQL query during checkpoint execution. Below are the steps to create a database checkpoint in QTP

• Navigate to Insert>Checkpoint>Database Checkpoint.

• Define whether to define SQL statement manually or using Microsoft Query

• Select the database or query if previously defined as shown below.We select QT_Flight_32 database.Click on OK.

• Select the required columns/tables to be selected in SQL and click on next button.

• Define conditions for selected columns in the above step and define sorting criteria. Click Next>Next

• Click on finish

• Change the properties of database checkpoint and select whether to insert the checkpoint before or after current step and clcik on OK. A database checkpoint is created and inserted in the test.

How to add result as HTML table format in QTP test results

We can use reporter.logevent method as explained in code/functions below to add results in  tabular format in QTP test results. Below is an example on how to use reporter.logevent

Public Function func_createHTMLTableFromExcel(strDataFile,strWorksheetName)

Set objXlHandle = Createobject("Excel.Application")

 objXlHandle.visible = false

Set objExcelWB = objXlHandle.Workbooks.Open(strDataFile)

Set objExcelWS = objExcelWB.Worksheets(strWorksheetName)

'Getting column and row count 

 strColumnCount = objExcelWS.UsedRange.Columns.Count

 strTotRows = objExcelWS.UsedRange.Rows.Count

strTable = "<table border=""""2"""">"

'Creating a html table based on content of the excel file

For j=1 to strTotRows

strTable = strTable & "<tr>"

For i=1 to strColumnCount

 strData = Trim(objExcelWS.Cells(j,i))

 strTable= strTable & "<td>"& strData &"</td>"

Next

strTable =strTable & "</tr>"

Next

strTable = strTable & "</table>"

Call reportinQTPhtmlContent(strTable)

'Closing the workbook

 objExcelWB.Close

End Function

Public Function reportinQTPhtmlContent(strTable)

Set objdict = CreateObject("Scripting.dictionary")

objdict.Add "Status", micdone

objdict.Add "NodeName", "Table Data"

objdict.Add ("StepHtmlInfo"), strTable

Reporter.LogEvent "User", objdict, Reporter.GetContext

End function