Systems and methods for testing a software application
First Claim
1. A computer-implemented method, performed by a processor connected to a network interface and a networked database, for testing a software application, the method comprising:
- extracting, using the processor through the network interface from the networked database, a first expected result of a software application, the first expected result being identified by a control file indicating an expected result verification point of a test case for testing the software application and being generated by SQL query including logic for emulating the expected functionality of the software application to generate known good results;
extracting, using the processor through the network interface from the networked database, a first actual result output by the software application, the first actual result being identified by the control file indicating an actual result verification point of the test case for testing the software application;
comparing, using the processor, the first expected result with the first actual result and the expected result verification point with the actual result verification point to determine whether the first actual result matches the first expected result and whether the expected result verification point matches the actual result verification point;
generating, using the processor, a result file indicating whether the test case passed or failed, the test case having passed when the first actual result matches the first expected result and the expected result verification point matches the actual result verification point;
determining, using the processor, if the generated result file indicates that the test case passed, whether the first expected result and the first actual result contains the same amount of data;
determining, using the processor, if the generated result file indicates that the test case passed, whether the test case ID of the expected result verification point matches the test case ID of the actual result verification point;
updating, using the processor through the network interface, the result file to indicate that the test case failed if the first expected result and the first actual result do not contain the same amount of data; and
updating, using the processor through the network interface, the result file to indicate that the test case passed if the test case ID of the expected result verification point matches the test case ID of the actual result verification point.
0 Assignments
0 Petitions
Accused Products
Abstract
Systems, methods, and computer-readable media are disclosed for testing a software application. An exemplary method includes storing a control file identifying a test case for testing a software application. A first expected result may be extracted from a device storing expected results of the software application, the first expected result being identified by the control file. A first actual result may be extracted from a device storing actual results output by the software application, the first actual result being identified by the control file. The first expected result may be compared with the first actual result to determine whether the first actual result matches the first expected result. A result file indicating whether the test case passed or failed is generated, and the test case has passed when the first actual result matches the first expected result. The result file may be stored in a storage device.
-
Citations
21 Claims
-
1. A computer-implemented method, performed by a processor connected to a network interface and a networked database, for testing a software application, the method comprising:
-
extracting, using the processor through the network interface from the networked database, a first expected result of a software application, the first expected result being identified by a control file indicating an expected result verification point of a test case for testing the software application and being generated by SQL query including logic for emulating the expected functionality of the software application to generate known good results; extracting, using the processor through the network interface from the networked database, a first actual result output by the software application, the first actual result being identified by the control file indicating an actual result verification point of the test case for testing the software application; comparing, using the processor, the first expected result with the first actual result and the expected result verification point with the actual result verification point to determine whether the first actual result matches the first expected result and whether the expected result verification point matches the actual result verification point; generating, using the processor, a result file indicating whether the test case passed or failed, the test case having passed when the first actual result matches the first expected result and the expected result verification point matches the actual result verification point; determining, using the processor, if the generated result file indicates that the test case passed, whether the first expected result and the first actual result contains the same amount of data; determining, using the processor, if the generated result file indicates that the test case passed, whether the test case ID of the expected result verification point matches the test case ID of the actual result verification point; updating, using the processor through the network interface, the result file to indicate that the test case failed if the first expected result and the first actual result do not contain the same amount of data; and updating, using the processor through the network interface, the result file to indicate that the test case passed if the test case ID of the expected result verification point matches the test case ID of the actual result verification point. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. A non-transitory computer-readable medium comprising instructions for causing a processor connected to a network interface and a networked database to execute a method for testing a software application, the method comprising:
-
extracting, using the processor through the network interface from the networked database, a first expected result of a software application, the first expected result being identified by a control file indicating an expected result verification point of a test case for testing the software application and being generated by SQL query including logic for emulating the expected functionality of the software application to generate known good results; extracting, using the processor through the network interface from the networked database, a first actual result output by the software application, the first actual result being identified by the control file indicating an actual result verification point of the test case for testing the software application; comparing, using the processor, the first expected result with the first actual result and the expected result verification point with the actual result verification point to determine whether the first actual result matches the first expected result and whether the expected result verification point matches the actual result verification point; generating, using the processor, a result file indicating whether the test case passed or failed, the test case having passed when the first actual result matches the first expected result and the expected result verification point matches the actual result verification point; determining, using the processor, if the generated result file indicates that the test case passed, whether the first expected result and the first actual result contains the same amount of data; determining, using the processor, if the generated result file indicates that the test case passed, whether the test case ID of the expected result verification point matches the test case ID of the actual result verification point; updating, using the processor through the network interface, the result file to indicate that the test case failed if the first expected result and the first actual result do not contain the same amount of data; and updating, using the processor through the network interface, the result file to indicate that the test case passed if the test case ID of the expected result verification point matches the test case ID of the actual result verification point. - View Dependent Claims (9, 10, 11, 12, 13, 14)
-
-
15. A system for testing a software application, the system comprising:
-
a processor having access to a networked database; a network interface in communication with the processor; and a memory device in communication with the processor and configured to store instructions, wherein, when the processor executes the instructions, the processor; extracts, through the network interface from the networked database, a first expected result of a software application, the first expected result being identified by a control file indicating an expected result verification point of a test case for testing the software application and being generated by SQL query including logic for emulating the expected functionality of the software application to generate known good results; extracts, through the network interface from the networked database, a first actual result output by the software application, the first actual result being identified by the control file indicating an actual result verification point of the test case for testing the software application; compares the first expected result with the first actual result and the expected result verification point with the actual result verification point to determine whether the first actual result matches the first expected result and whether the expected result verification point matches the actual result verification point; generates a result file indicating whether the test case passed or failed, the test case having passed when the first actual result matches the first expected result and the expected result verification point matches the actual result verification point; determines, if the generated result file indicates that the test case passed, whether the first expected result and the first actual result contains the same amount of data; determines, if the generated result file indicates that the test case passed, whether the test case ID of the expected result verification point matches the test case ID of the actual result verification point; updating, using the processor through the network interface, the result file to indicate that the test case failed if the first expected result and the first actual result do not contain the same amount of data; and updating, using the processor through the network interface, the result file to indicate that the test case passed if the test case ID of the expected result verification point matches the test case ID of the actual result verification point. - View Dependent Claims (16, 17, 18, 19, 20, 21)
-
Specification