Description
In Lisa, there is a JDBC step to execute SQL query or a Stored Procedure which in results will fetch a Result Set. This LISA SDK (Filter) helps in saving the Result Set of a JDBC Step to an Excel file in your file system which further can be compared with the expected results.
Set-Up Instructions
1. Navigate to {LISA_HOME}/hotDeploy directory and place the “savetoExcelFilter.jar”
2. Navigate to {LISA_HOME} and open the file “typemap.properties” with notepad. Navigate to Filters section of the file and insert below text as shown
“,com.itko.excel.filter.FilterSaveResultSettoExcelFile\”
3. Restart LISA, if it is in running state.
Steps for Implementation:
1. Create a Project in LISA workstation.
2. Create a Test Case.
3. Add a Test Step -> JDBC Step
4. Open the step and provide either a SQL query or Stored Procedure call Statement.
5. On the right side, under Step Information, Click on button under Filters Section and select filter “Save ResultSet to an Excel File” under Custom.
6. Open the Filter and provide values for Location and Sheet Name.
If current step is JDBC Step then above step is fine. Otherwise provide property name which holds the name of JDBC step in “Filter in:” section.
- 7. Click Start a new ITR and execute the Test Case.
- 8. Open the excel file in the provided Location.
Note: This Filter will work only with workbook having “.xls” as an extension.
Benefits:
- Generic Utility, Plug and Play.
- Save Manual and Coding Efforts
- Time Saving as Java Step consumes more time to execute.