WO2020233330A1

WO2020233330A1 - Batch testing method, apparatus, and computer-readable storage medium

Info

Publication number: WO2020233330A1
Application number: PCT/CN2020/086272
Authority: WO
Inventors: 赵芹
Original assignee: 深圳壹账通智能科技有限公司
Priority date: 2019-05-20
Filing date: 2020-04-23
Publication date: 2020-11-26
Also published as: CN110287097A

Abstract

The present application relates to the technical field of big data, and discloses a batch testing method, apparatus, and computer-readable storage medium, comprising: automatically generating a batch request page, summarizing entered parameters, and screening settlement information; obtaining the current user permission scope and check item name, obtaining the tree node structure of standard interface data of each core system, and obtaining a batch test data acquisition path; according to said path, extracting test data in batches, writing test data to a report designer, generating reports for various test scenarios, and inputting the reports of the various scenarios into corresponding forms; according to service requirements under various test scenarios, performing batch test operations and saving the test operation results in a database. The present application also provides a computer device and a computer-readable storage medium. The present application can perform batch testing on banks and other systems.

Description

Batch testing method, device and computer readable storage medium

This application claims the priority of the Chinese patent application filed with the Chinese Patent Office on May 20, 2019, the application number is 201910420667.X, and the invention title is "batch test method, device and computer readable storage medium". The reference is incorporated in this application.

Technical field

This application relates to the field of big data technology, and in particular to a batch test method, device and computer-readable storage medium.

Background technique

Under the dual influence of financial factors and the rapid development of network applications, various advanced systems have been born. At present, the core systems of all banks need to be tested in batches, and most of them still use human experience for batch plan execution and management. Even if the platform is used, most of them are simple and simple operations such as managing batch time and planning; and batch planning requires settlement. All corresponding testers are managed by themselves, and there are defects of their own governance and lack of unified planning; at the same time, the batch plan is checked manually by each tester according to their own scenarios at each stage of the check point, and the inspections involved in the batch are not enough. Comprehensive, especially when the core system batch plan involves too many personnel and covers a variety of scenarios, it will consume a lot of time to plan the batch plan.

The inventor realized that in the current banking industry, the once simple manual management mode without the help of any tools is no longer applicable. The batch testing work with manual planning as the main body is due to extremely low decision-making efficiency, high error rate and The inability to flexibly respond to the defects required by various scenarios will inevitably hinder the efficient and orderly progress of batch testing.

Summary of the invention

This application provides a batch test method, device and computer-readable storage medium, the main purpose of which is to provide a solution that can perform batch test on each bank and each system.

In order to achieve the above objectives, a batch test method provided by this application includes:

S1. According to the batch plan, automatically generate a batch application page, summarize the parameters entered by each tester in the batch application page, and filter out the settlement information in it through keyword and quantity range search;

S2. Convert the data of the standard interface of the non-core system into the data of the standard interface of the core system, and divide all data into two categories: basic data check items and specific scene check items according to different aspects of the business reflected by the data;

S3. Obtain the scope of authority and the name of the inspection item owned by the user currently performing data operations, and automatically obtain the tree node structure of the data of each of the core system standard interfaces, and display it in an object control to obtain correct batch testing Data acquisition path;

S4. Using structured query language commands to extract test data in batches according to the batch test data acquisition path;

S5. Write the extracted test data into the Excel report designer added with the report design control plug-in, generate reports of various test scenarios according to the report flow design, and input the reports of the various test scenarios into the corresponding In the form, and for the reports of various scenarios in the above-generated form, perform batch test operations according to the business needs of various test scenarios, save the test operation results in the database, and call the preset check function Check the result of the test operation.

In a second aspect, the present application also provides a computer device that includes a memory, a processor, and a computer program stored in the memory and capable of running on the processor, and the processor implements a Batch testing method, the method includes:

S3. Obtain the scope of authority and the name of the inspection item owned by the user currently performing data operations, and automatically obtain the tree node structure of the data of each of the core system standard interfaces, and display it in an object control to obtain the correct batch test Data acquisition path;

S5. Write the extracted test data into the Excel report designer added with the report design control plug-in, generate reports of various test scenarios according to the report flow design, and input the reports of the various test scenarios into the corresponding In the form, and for the reports of various scenarios in the above-generated form, perform batch test operations according to the business needs of various test scenarios, save the test operation results in the database, and call the preset check function Check the operation result.

In a third aspect, the present application also provides a computer-readable storage medium having a computer program stored on the computer-readable storage medium, and when the computer program is executed by a processor, a batch test method is implemented, the method including:

The batch test method, device and computer-readable storage medium described in this application use batch test methods to minimize the repetitive use of labor costs. Through platform processing, various testing and calculation links can be closely connected, and batch processing mode , Improve inspection efficiency.

Description of the drawings

FIG. 1 is a schematic flowchart of a batch test method provided by an embodiment of the application;

2 is a schematic diagram of the internal structure of a computer device provided by an embodiment of the application;

FIG. 3 is a schematic diagram of modules of a batch test program in a computer device provided by an embodiment of the application.

Detailed ways

It should be understood that the specific embodiments described here are only used to explain the application, and are not used to limit the application.

This application provides a batch test method. Referring to FIG. 1, it is a schematic flowchart of a batch test method provided by an embodiment of this application. The method can be executed by a device, and the device can be implemented by software and/or hardware.

In this embodiment, the batch test method includes:

S1. According to the batch plan, automatically generate a batch application page, summarize the parameters entered by each tester in the batch application page, and filter out the settlement information in the batch application page through keyword and quantity range search.

In a preferred embodiment of the present application, the entered parameters include test scenarios, batch requirements, batch completion time, etc. The test scenarios can be, for example, deposit-to-private, deposit-to-business, deposit-to-bank, loan, etc.

First, the tester enters three basic preset index parameters such as test scenarios, batch requirements, and batch completion time on the generated batch application page, and searches for the results by keywords and quantity ranges according to the requirements of the three preset index parameters. Ways to screen out the settlement information and display the settlement information at the same time.

S2. For settlement information with different data formats entered in different test scenarios, different business models are integrated through data preprocessing and a unified interface to realize the conversion of data from non-core system standard interfaces to core system standard interface data. And according to the different aspects of the business reflected in the data, all data is divided into two categories: basic data check items and specific scene check items.

S3. Obtain the scope of authority and the name of the inspection item owned by the user currently performing the data operation, and automatically obtain the tree node structure of the data of the standard interface of the core system, and display it in an object control to obtain the correct batch test Data acquisition path to connect to the correct basic data check item data.

This application takes advantage of the high security, error catching mechanism, and easy access to object attributes of the Quality Center Application Programming Interface (Quality Center Application Programming Interface), and uses the asp.net technology to obtain the scope and inspection of the current user's permissions Project name, and get the node collection (Folder) under the specific testlab path through the getnode function of the TestSetTreeManager object in the quality control interface, and load the QC testlab Folder tree node structure through the collection, and display it in a TreeList that extends the checkbox In the object control, add it to the data table of the list object to get the correct path for obtaining the batch test data.

S4. According to the path of obtaining the batch test data, a structured query language (Structured Query Language, SQL) command (Command) is used to extract test data in batches.

This application uses SQL Command to extract test data in batches through the data path of the data table structure written in the list object.

First, this application obtains the cycle information under a specific path by associating the list object with the cycle (CYCLE) table, and then associates the cycle table with the test cycle and the test table to obtain all test case information, and then traverses it. Get the characteristic attribute value of each row of data.

S5. Write the extracted test data into the Excel report designer with the Report Design Control plug-in, generate reports of various test scenarios according to the report flow design, and combine the various test scenarios The report is entered into the corresponding form.

This application uses batch write commands to write the test data extracted in the above steps into the report designer. In this application, the function of the report designer is divided into four major parts: the first part is a file operation module, which is used to create, modify, and save report files according to standards; the second part is a format definition module, which is used to Define the format settings of each cell of the report template; the third part is the database connection module, which is used to define the database connection string, supporting various data sources; the fourth part is the module, which defines the data source query string in the table data area And field binding information. This application uses the database link module to perform corresponding data operations for different test scenarios, deposit-to-private, deposit-to-public, deposit-to-bank, loan, etc., and save the operation result in the database, complete the update, and place the result in the corresponding In the form sheet.

S6. For the reports of various test scenarios in the above-generated form, perform batch test operations according to the business requirements of various test scenarios, save the test operation results in the database, complete the update, and call the preset The check function checks the result of the test operation to ensure the correctness of the data processing.

The preset check function described in this application is a function built into Excel and determined according to the needs of different test scenarios. The business data in each test scenario is checked through the preset check function. After confirming that it is correct, each check item is displayed and accurate business data is announced.

This application also provides a computer device. Referring to FIG. 2, it is a schematic diagram of the internal structure of a computer device provided by an embodiment of this application.

In this embodiment, the computer device 1 may be a PC (Personal Computer, personal computer), or a terminal device such as a smart phone, a tablet computer, or a portable computer. The computer device 1 at least includes a memory 11, a processor 12, a communication bus 13, and a network interface 14.

Wherein, the memory 11 includes at least one type of readable storage medium, and the readable storage medium includes flash memory, hard disk, multimedia card, card-type memory (for example, SD or DX memory, etc.), magnetic memory, magnetic disk, optical disk, etc. The memory 11 may be an internal storage unit of the computer device 1 in some embodiments, such as a hard disk of the computer device 1. In other embodiments, the memory 11 may also be an external storage device of the computer device 1, such as a plug-in hard disk equipped on the computer device 1, a smart memory card (Smart Media Card, SMC), and a Secure Digital (SD) Card, Flash Card, etc. Further, the memory 11 may also include both an internal storage unit of the computer device 1 and an external storage device. The memory 11 can be used not only to store application software and various data installed in the computer device 1, such as codes of the batch test program 01, etc., but also to temporarily store data that has been output or will be output.

The processor 12 may be a central processing unit (CPU), controller, microcontroller, microprocessor or other data processing chip in some embodiments, and is used to run the program code or processing stored in the memory 11 Data, for example, execute batch test program 01, etc.

The communication bus 13 is used to realize the connection and communication between these components.

The network interface 14 may optionally include a standard wired interface and a wireless interface (such as a WI-FI interface), and is usually used to establish a communication connection between the device 1 and other electronic devices.

Optionally, the device 1 may also include a user interface. The user interface may include a display (Display) and an input unit such as a keyboard (Keyboard). The optional user interface may also include a standard wired interface and a wireless interface. Optionally, in some embodiments, the display may be an LED display, a liquid crystal display, a touch-sensitive liquid crystal display, an OLED (Organic Light-Emitting Diode, organic light emitting diode) touch device, etc. Among them, the display can also be appropriately called a display screen or a display unit, which is used to display the information processed in the computer device 1 and to display a visualized user interface.

Figure 2 only shows the computer device 1 with the components 11-14 and the batch test program 01. Those skilled in the art can understand that the structure shown in Figure 1 does not constitute a limitation on the computer device 1, and may include a comparison chart. Show fewer or more components, or combine certain components, or different component arrangements.

In the embodiment of the device 1 shown in FIG. 2, the batch test program 01 is stored in the memory 11; when the processor 12 executes the batch test program 01 stored in the memory 11, the following steps are implemented:

Step 1. According to the batch plan, automatically generate a batch application page, summarize the parameters entered by each tester in the batch application page, and filter out the settlement information in it through keyword and quantity range search.

Step 2: For settlement information with different data formats entered under different test scenarios, different business models are integrated through data preprocessing and a unified interface to realize the conversion of data from non-core system standard interfaces to core system standard interface data , And according to the different aspects of the business reflected in the data, all data is divided into two categories: basic data check items and specific scene check items.

Step 3: Obtain the scope of authority and check item name of the user currently performing data operations, and automatically obtain the tree node structure of the data of the core system standard interface, and display it in an object control to obtain the correct batch The test data acquisition path is connected to the correct basic data check item data.

Step 4: According to the path of the batch test data acquisition, a structured query language (Structured Query Language, SQL) command (Command) is used to extract test data in batches.

Step 5. Write the extracted test data into the Excel report designer with the Report Design Control plug-in, generate reports of various test scenarios according to the report flow design, and combine the various test scenarios Enter the report into the corresponding form.

This application writes the test data extracted in the above steps into the report designer through batch write commands. In this application, the function of the report designer is divided into four major parts: the first part is a file operation module, which is used to create, modify, and save report files according to standards; the second part is a format definition module, which is used to Define the format settings of each cell of the report template; the third part is the database connection module, which is used to define the database connection string, supporting various data sources; the fourth part is the module, which defines the data source query string in the table data area And field binding information. This application uses the database link module to perform corresponding data operations for different test scenarios, deposit-to-private, deposit-to-public, deposit-to-bank, loan, etc., and save the operation result in the database, complete the update, and place the result in the corresponding In the form sheet.

Step 6. For the reports of various test scenarios in the above-generated form, perform batch test operations according to the business requirements under various test scenarios, save the test operation results in the database, and call the preset check function Check the test operation results to ensure the correctness of data processing.

Optionally, in other embodiments, the batch test program can also be divided into one or more modules, and the one or more modules are stored in the memory 11 and are executed by one or more processors (in this embodiment, the processing The device 12) is executed to complete this application. The module referred to in this application refers to a series of computer program instruction segments that can complete specific functions, and is used to describe the execution process of batch test programs in computer equipment.

For example, referring to FIG. 3, which is a schematic diagram of program modules of a batch test program in an embodiment of the computer equipment of this application, in this embodiment, the batch test program can be divided into a data screening module 10, a data conversion module 20, and a data acquisition module. The module 30, the data extraction module 40 and the data operation module 50 are exemplary:

The data screening module 10 is used to automatically generate a batch application page according to the batch plan, summarize the parameters entered by each tester in the batch application page, and filter the settlement information therein by searching through keywords and quantity ranges.

The data conversion module 20 is used for: according to the settlement information with different data formats entered in different test scenarios, it integrates different business models through data preprocessing and a unified interface, and realizes the conversion of the data of the non-core system standard interface into the core system Standard interface data, and according to the different aspects of the business reflected in the data, all data is divided into two categories: basic data check items and specific scene check items.

The data acquisition module 30 is used to: acquire the scope of authority and the name of the inspection item owned by the user currently performing data operations, and automatically acquire the tree node structure of the data of each of the core system standard interfaces, and display it in an object control, Get the correct batch test data acquisition path to connect to the correct basic data check item data.

The data extraction module 40 is configured to extract test data in batches by using a structured query language (Structured Query Language, SQL) command (Command) according to the path for obtaining the batch test data.

The data operation module 50 is used to: write the extracted test data into the Excel report designer with the report design control (Report Design Control) plug-in added, generate reports of various test scenarios according to the report flow design, and combine the The reports of various test scenarios are input into the corresponding forms, and the reports of various test scenarios in the above-generated form are subjected to batch test operations according to the business requirements under various test scenarios, and the results of the test operations Save it in the database, and call a preset check function to check the test operation result.

The functions or operation steps implemented by the program modules such as the data screening module 10, the data conversion module 20, the data acquisition module 30, the data extraction module 40, and the data operation module 50 when executed are substantially the same as those in the foregoing embodiment, and will not be repeated here. .

In addition, an embodiment of the present application also proposes a computer-readable storage medium with a batch test program stored on the computer-readable storage medium, and the batch test program can be executed by one or more processors to implement the following operations:

S5. Write the extracted test data into the Excel report designer added with the report design control plug-in, generate reports of various test scenarios according to the report flow design, and input the reports of the various test scenarios into the corresponding In the form

S6. For the reports of various test scenarios in the above-generated form, perform batch test operations according to the business requirements under various test scenarios, save the test operation results in the database, and call the preset check function to The results of the test operation are checked.

The specific implementation manners of the computer-readable storage medium of the present application are basically the same as the foregoing embodiments of the computer device and method, and will not be repeated here.

Through the description of the above embodiments, those skilled in the art can clearly understand that the method of the above embodiments can be implemented by means of software plus the necessary general hardware platform. Of course, it can also be implemented by hardware, but in many cases the former is better.的实施方式。 Based on this understanding, the technical solution of this application essentially or the part that contributes to the existing technology can be embodied in the form of a software product, and the computer software product is stored in a storage medium (such as ROM/RAM) as described above. , Magnetic disks, optical disks), the computer-readable storage medium can be non-volatile or volatile, and includes several instructions to enable a terminal device (can be a mobile phone, computer, server, or network device, etc.) Perform the method described in each embodiment of this application.

The above are only preferred embodiments of this application, and do not limit the scope of this application. Any equivalent structure or equivalent process transformation made using the content of the description and drawings of this application, or directly or indirectly used in other related technical fields , The same reason is included in the scope of patent protection of this application.

Claims

A batch test method, the method includes:

S1. According to the batch plan, automatically generate a batch application page, summarize the parameters entered by each tester in the batch application page, and filter out the settlement information in it through keyword and quantity range search;

S2. Convert the data of the standard interface of the non-core system into the data of the standard interface of the core system, and divide all data into two categories: basic data check items and specific scene check items according to different aspects of the business reflected by the data;

S3. Obtain the scope of authority and the name of the inspection item owned by the user currently performing data operations, and automatically obtain the tree node structure of the data of each of the core system standard interfaces, and display it in an object control to obtain correct batch testing Data acquisition path;

S4. Using structured query language commands to extract test data in batches according to the batch test data acquisition path;

S5. Write the extracted test data into the Excel report designer added with the report design control plug-in, generate reports of various test scenarios according to the report flow design, and input the reports of the various test scenarios into the corresponding In the form

S6. For the reports of various test scenarios in the above-generated form, perform batch test operations according to the business requirements under various test scenarios, save the test operation results in the database, and call the preset check function to The results of the test operation are checked.
The batch test method according to claim 1, wherein the entered parameters include test scenarios, batch requirements, and batch completion time, wherein the test scenarios include deposit-to-private, deposit-to-business, deposit-to-bank, and loan.
The batch test method according to claim 1, wherein the conversion of data of a standard interface of a non-core system into data of a standard interface of a core system in said S2 includes:

For settlement information with different data formats entered under different test scenarios, different business models are integrated through data preprocessing and a unified interface to realize the conversion of data from non-core system standard interfaces to core system standard interface data.
The batch test method according to any one of claims 1 to 3, wherein the S3 includes:

Using the quality control interface, using asp.net technology, obtain the scope of the current user's authority and the name of the inspection item, and obtain the node set under the specific testlab path through the getnode function of the TestSetTreeManager object in the quality control interface, and pass the The node collection loads the QC testlab Folder tree node structure, displays it in a TreeList object control that expands out of the checkbox, and adds it to the data table of the list object to get the correct batch test data acquisition path.
The batch test method as claimed in claim 4, wherein the S4 includes:

Associate the data table of the list object with the periodic table to obtain the period information under a specific path, and then associate the periodic table to the test period and test table to obtain all the test case information, and obtain the characteristic attribute value of each row of data by traversal .
A computer device includes a memory, a processor, and a computer program stored in the memory and capable of running on the processor. The processor implements a batch test method when the program is executed. The method includes :

S1. According to the batch plan, automatically generate a batch application page, summarize the parameters entered by each tester in the batch application page, and filter out the settlement information in it through keyword and quantity range search;

S2. Convert the data of the standard interface of the non-core system into the data of the standard interface of the core system, and divide all data into two categories: basic data check items and specific scene check items according to different aspects of the business reflected by the data;

S3. Obtain the scope of authority and the name of the inspection item owned by the user currently performing data operations, and automatically obtain the tree node structure of the data of each of the core system standard interfaces, and display it in an object control to obtain correct batch testing Data acquisition path;

S4. Use structured query language commands to extract test data in batches according to the batch test data acquisition path;

S5. Write the extracted test data into the Excel report designer added with the report design control plug-in, generate reports of various test scenarios according to the report flow design, and input the reports of the various test scenarios into the corresponding In the form, and for the reports of various scenarios in the above-generated form, perform batch test operations according to the business needs of various test scenarios, save the test operation results in the database, and call the preset check function Check the operation result.
8. The computer device of claim 6, wherein the entered parameters include test scenarios, batch requirements, and batch completion time, wherein the test scenarios include deposit-to-private, deposit-to-business, deposit-to-bank, and loan.
8. The computer device according to claim 6, wherein said S2 converting data of a standard interface of a non-core system into data of a standard interface of a core system includes:

For settlement information with different data formats entered under different test scenarios, different business models are integrated through data preprocessing and a unified interface to realize the conversion of data from non-core system standard interfaces to core system standard interface data.
8. The computer device according to any one of claims 6 to 8, said S3 comprising:

Using the quality control interface, using asp.net technology, obtain the scope of the current user's authority and the name of the inspection item, and obtain the node set under the specific testlab path through the getnode function of the TestSetTreeManager object in the quality control interface, and pass the The node collection loads the QC testlab Folder tree node structure, displays it in a TreeList object control that expands from the checkbox, and adds it to the data table structure of the list object to get the correct path for obtaining the batch test data.
The computer device according to claim 9, wherein the S4 comprises:

Associate the data table of the list object with the periodic table to obtain the period information under a specific path, and then associate the periodic table to the test period and test table to obtain all the test case information, and obtain the characteristic attribute value of each row of data by traversal .
A computer-readable storage medium having a computer program stored on the computer-readable storage medium, and when the computer program is executed by a processor, a batch test method is realized, the method includes: S1, automatic batch generation according to a batch plan The application page summarizes the parameters entered by the testers in the batch application page, and selects the settlement information in the search by keyword and quantity range;

S2. Convert the data of the standard interface of the non-core system into the data of the standard interface of the core system, and divide all data into two categories: basic data check items and specific scene check items according to different aspects of the business reflected by the data;

S3. Obtain the scope of authority and the name of the inspection item owned by the user currently performing data operations, and automatically obtain the tree node structure of the data of each of the core system standard interfaces, and display it in an object control to obtain correct batch testing Data acquisition path;

S4. Using structured query language commands to extract test data in batches according to the batch test data acquisition path;

S5. Write the extracted test data into the Excel report designer added with the report design control plug-in, generate reports of various test scenarios according to the report flow design, and input the reports of the various test scenarios into the corresponding In the form, and for the reports of various scenarios in the above-generated form, perform batch test operations according to the business needs of various test scenarios, save the test operation results in the database, and call the preset check function Check the operation result.
11. The computer-readable storage medium of claim 11, wherein the entered parameters include test scenarios, batch requirements, and batch completion time, wherein the test scenarios include deposit-to-private, deposit-to-business, deposit-to-bank, and loan.
11. The computer-readable storage medium according to claim 11, wherein said S2 converting data of a standard interface of a non-core system into data of a standard interface of a core system includes:

For settlement information with different data formats entered under different test scenarios, different business models are integrated through data preprocessing and a unified interface to realize the conversion of data from non-core system standard interfaces to core system standard interface data.
The computer-readable storage medium according to any one of claims 11 to 13, wherein the S3 comprises:

Using the quality control interface, using asp.net technology, obtain the scope of the current user's authority and the name of the inspection item, and obtain the node set under the specific testlab path through the getnode function of the TestSetTreeManager object in the quality control interface, and pass the The node collection loads the QC testlab Folder tree node structure, displays it in a TreeList object control that expands from the checkbox, and adds it to the data table structure of the list object to get the correct path for obtaining the batch test data.
The computer-readable storage medium of claim 14, wherein the S4 comprises:

Associate the data table of the list object with the periodic table to obtain the period information under a specific path, and then associate the periodic table to the test period and test table to obtain all the test case information, and obtain the characteristic attribute value of each row of data by traversal .