System and method for automating testing without scripting

Patent metadata

Field	Value
Publication number	US-10013339-B2
Application number	US-201615094667-A
Country	US
Kind code	B2
Filing date	Apr 8, 2016
Priority date	Dec 30, 2015
Publication date	Jul 3, 2018
Grant date	Jul 3, 2018

Abstract

A system and computer-implemented method for automating end-to end testing is provided. The system comprises a connection settings module to receive information for connecting with one or more external systems. The system further comprises a test setup module to create test workflows, wherein creating the test workflows comprise selecting one or more pre-stored source files and corresponding one or more pre-stored target files and mapping input and output of each of the one or more selected pre-stored source files with the corresponding one or more selected pre-stored target files for testing additional source files associated with the one or more external systems. Furthermore, the system comprises a workflow execution module to connect with the one or more external systems using the received information to retrieve the additional source files and execute the created test workflows corresponding to the retrieved one or more additional source files.

First claim

I claim:

1. A system for automating end-to-end testing, the system comprising:
a memory storing program instructions;
a processor for executing program instructions stored in the memory and configured to:
receive information for connecting with one or more external systems;
create one or more test workflows, wherein creating the one or more test workflows comprise:
selecting one or more pre-stored source files and corresponding one or more pre-stored target files; and
mapping input and output of each of the one or more selected pre-stored source files with the corresponding one or more selected pre-stored target files for creating one or more mapped target files;

connect with the one or more external systems using the received information to:
retrieve the one or more additional source files;
compare records in the one or more additional source files with records in a first segment of the one or more mapped target files, wherein each of the mapped target files are split into multiple segments and loaded into a hash table one at a time; and
determine unmatched records if the record or values of the records is not matched with records of each of the multiple segments of the one or more target files loaded into the hash table one at a time until a last segment of the multiple segments.

2. The system of claim 1 , wherein the one or more external systems comprise one or more databases, one or more test management tools, one or more servers and components of the one or more external systems.

3. The system of claim 2 , wherein the components of the one or more external systems comprise one or more flat files, Extensible Markup Language (XML) data, spreadsheets, web services, one or more Transmission Control Protocol (TCP)/Internet Protocol (IP) sockets requests, X12 files, Hypertext Transfer Protocol (HTTP) post messages and database Application Program Interfaces (APIs).

4. The system of claim 1 , wherein the information for connecting with the one or more external systems comprise authentication details and connection settings.

5. The system of claim 1 , wherein the information for connecting with the one or more external systems is received from one or more users.

6. The system of claim 1 , wherein creating the one or more test workflows further comprise selecting a location for saving the test execution results.

7. The system of claim 1 wherein the processor is configured to automatically send the test execution results on one or more electronic communication devices via one or more communication channels.

8. The system of claim 7 , wherein the one or more communication channels comprise electronic mail, Short Messaging Service (SMS), instant messaging application and web service.

9. The system of claim 1 , wherein the test execution results are in the form of reports and graphical forms comprising charts, diagrams and graphs.

10. The system as claimed in claim 1 , wherein the processor is configured to:
store unmatched records in relation to the first segment of the additional source files in a pending records file;
compare the unmatched records of the additional source files with records in the other multiple segments of the one or more mapped target files;
store unmatched records in relation to each of the multiple segments of the additional source files in the pending records file;
compare values of source file records with matched records of the first segment;
store records of additional source files with unmatched values in a mismatch file;
compare values of source file records with matched records of each of the multiple segments;
store records of additional source files with unmatched values in the mismatch file;
compare matched records, of the additional source files, having unmatched values with records in the other multiple segments of the one or more mapped target files; and store unmatched records in a missing record file if the record or values of the records of the additional source files is not matched
with records of each of the multiple segments of the one or more target files loaded into the hash table one at a time until a last segment of the multiple segments.

11. A computer-implemented method for automating end-to-end testing, via program instructions stored in a memory and executed by a processor, the computer-implemented method comprising:
receiving information for connecting with one or more external systems;
creating one or more test workflows, wherein creating the one or more test workflows comprise:
selecting one or more pre-stored source files and corresponding one or more pre-stored target files; and mapping input and output of each of the one or more selected pre-stored source files with the corresponding one or more selected pre-stored target files for creating one or more mapped target files;
connecting with the one or more external systems using the received information to retrieve the one or more additional source files; and
comparing records in the one or more additional source files with records in a first segment of the one or more mapped target files, wherein each of the mapped target files are split into multiple segments and loaded into a hash table one at a time; and
determining unmatched records if the record or values of the records is not matched with records of each of the multiple segments of the one or more target files loaded into the hash table one at a time until a last segment of the multiple segments.

12. The computer-implemented method of claim 11 , wherein the one or more external systems comprise one or more databases, one or more test management tools, one or more servers and components of the one or more external systems.

13. The computer-implemented method of claim 12 , wherein the components of the one or more external systems comprise one or more flat files, Extensible Markup Language (XML) data, spreadsheets, web services, one or more Transmission Control Protocol (TCP)/Internet Protocol (IP) sockets requests, X12 files, Hypertext Transfer Protocol (HTTP) post messages and database Application Program Interfaces (APIs).

14. The computer-implemented method of claim 11 , wherein the information for connecting with the one or more external systems comprise authentication details and connection settings.

15. The computer-implemented method of claim 11 , wherein the information for connecting with the one or more external systems is received from one or more users.

16. The computer-implemented method of claim 11 , wherein the step of creating the one or more test workflows further comprise selecting a location for saving the test execution results.

17. The computer-implemented method of claim 11 further comprising automatically sending the test execution results on one or more electronic communication devices via one or more communication channels.

18. The computer-implemented method of claim 17 , wherein the one or more communication channels comprise electronic mail, Short Messaging Service (SMS), instant messaging application and web service.

19. The computer-implemented method of claim 11 , wherein the test execution results are in the form of reports and graphical forms comprising charts, diagrams and graphs.

20. A computer program product for automating end-to-end testing, the computer program product comprising: a non-transitory computer-readable medium having computer-readable program code stored thereon, the computer-readable program code comprising instructions that when executed by a processor, cause the processor to:
receive

Assignees

• Cognizant Tech Solutions India Pvt Ltd

Inventors

• Athinathan Suganthakumar

Classifications

• H04L67/02

  based on web technology, e.g. hypertext transfer protocol [HTTP] · CPC title

• H04L51/046

  Interoperability with other network applications or services · CPC title

• G06F11/3414

  Workload generation, e.g. scripts, playback · CPC title

• G06F11/3668 Primary

  Testing of software · CPC title

• H04L43/50

  Testing arrangements · CPC title