Data testing method and device, electronic equipment and storage medium

Abstract

The invention provides a data test method and device, electronic equipment and a storage medium, and the method comprises the steps: obtaining data test tasks of a plurality of test batches, obtaining a to-be-tested data table corresponding to each data test batch, and storing the to-be-tested data table in the to-be-tested data table in the to-be-tested data table, the table structures in the to-be-tested data table and the test result table are the same, according to the sequence of the multiple test batches, the to-be-tested data table and the test result table of each test batch are loaded in sequence, and the to-be-tested data table and the test result table of each test batch are loaded according to the sequence of the multiple test batches; and generating a data test report according to the to-be-tested data table and the test result table of each test batch, so that batch processing can be performed on the data test tasks, and the data test efficiency can be effectively improved while the data test accuracy is ensured.

Description

Technical Field

[0001] The present disclosure relates to the field of data processing technology, and in particular to a data testing method, device, electronic equipment and storage medium. Background Art

[0002] Data testing refers to calculating the expected results from input data and comparing them with the actual processing results of the function. This requires a lot of manual verification work, which is not only time-consuming and labor-intensive, but also prone to errors. If traditional automated test scripts are used for data testing, automated test scripts must be written separately for different business scenarios. Data preparation, automated function operation, and assertion expectations must be performed independently according to specific business scenarios. In addition, data batch verification needs to ensure data accuracy and requires verification of each field of the relevant result data. The scripts are large and scattered, which is not conducive to the overall maintenance of test data and expected results. Summary of the invention

[0003] The present disclosure proposes a data testing method, device, electronic device, storage medium and computer program product, aiming to solve the technical problems in the related art at least to a certain extent.

[0004] A first aspect embodiment of the present disclosure proposes a data testing method, which is applied to a server, wherein a data testing tool is configured in the server, and the method comprises: obtaining data testing tasks for multiple test batches, wherein the data testing tasks for each test batch have corresponding task description information; obtaining a data table to be tested corresponding to each data test batch; obtaining a test result table corresponding to each data test batch, wherein the table structures in the data table to be tested and the test result table are the same; and sequentially loading the data table to be tested and the test result table of each test batch according to the order of the multiple test batches, so as to generate a data testing report according to the data table to be tested and the test result table of each test batch.

[0005] The second aspect of the present disclosure proposes a data testing device, an application and a server, wherein the server is configured with a data testing tool, and the device includes: a first acquisition module, used to acquire data testing tasks of multiple test batches, wherein the data testing tasks of each test batch have corresponding task description information; a second acquisition module, used to acquire a data table to be tested corresponding to each data test batch; a third acquisition module, used to acquire a test result table corresponding to each data test batch, wherein the table structures in the data table to be tested and the test result table are the same; a testing module, used to sequentially load the data table to be tested and the test result table of each test batch according to the order of multiple test batches, so as to generate a data testing report according to the data table to be tested and the test result table of each test batch.

[0006] An embodiment of the third aspect of the present disclosure proposes an electronic device, comprising: a processor; a memory for storing processor-executable instructions; wherein the processor is configured to execute instructions to implement a data testing method as described in the embodiment of the first aspect of the present disclosure.

[0007] The fourth aspect embodiment of the present disclosure proposes a computer-readable storage medium. When instructions in the computer-readable storage medium are executed by a processor of an electronic device, the electronic device can implement a data testing method as in the first aspect embodiment of the present disclosure.

[0008] The fifth aspect embodiment of the present disclosure proposes a computer program product, including a computer program, characterized in that the computer program is executed by a processor as the data testing method of the first aspect embodiment of the present disclosure.

[0009] The data testing method, device, electronic device, storage medium and computer program product proposed in this embodiment have at least the following beneficial effects: by obtaining data testing tasks for multiple test batches, wherein the data testing tasks of each test batch have corresponding task description information, obtaining the data table to be tested corresponding to each data test batch, obtaining the test result table corresponding to each data test batch, wherein the table structures in the data table to be tested and the test result table are the same, and sequentially loading the data table to be tested and the test result table of each test batch according to the order of the multiple test batches, so as to generate a data testing report according to the data table to be tested and the test result table of each test batch, thereby enabling batch processing of data testing tasks, and effectively improving data testing efficiency while ensuring data testing accuracy.

[0010] Additional aspects and advantages of the present disclosure will be given in part in the following description and in part will be obvious from the following description or learned through practice of the present disclosure. BRIEF DESCRIPTION OF THE DRAWINGS

[0011] The above and / or additional aspects and advantages of the present disclosure will become apparent and easily understood from the following description of the embodiments in conjunction with the accompanying drawings, in which:

[0012] Figure 1 is a flowchart of a data testing method according to the first embodiment of the present disclosure;

[0013] Figure 2 is a schematic diagram of a data testing process proposed in an embodiment of the present disclosure;

[0014] Figure 3 is a block diagram of a data testing device according to the present disclosure;

[0015] Figure 4 A block diagram of an exemplary electronic device suitable for implementing embodiments of the present disclosure is shown. DETAILED DESCRIPTION

[0016] Embodiments of the present disclosure are described in detail below, and examples of the embodiments are shown in the accompanying drawings, wherein the same or similar reference numerals throughout represent the same or similar elements or elements having the same or similar functions. The embodiments described below with reference to the accompanying drawings are exemplary and are only used to explain the present disclosure, and should not be construed as limitations on the present disclosure. On the contrary, the embodiments of the present disclosure include all changes, modifications, and equivalents that fall within the spirit and connotation of the appended claims.

[0017] It should be noted that the execution subject of the data testing method of this embodiment may be a first server, and the first server may be configured in an electronic device, and the electronic device may include but is not limited to a terminal, a server, and the like.

[0018] It should be noted that the process of obtaining, storing, using, and processing information in the disclosed technical solution complies with the relevant provisions of national laws and regulations and does not violate public order and good morals.

[0019] It should be noted that in the embodiments of the present application, there may be existing solutions in the industry such as certain software, components, models, etc., which should be regarded as exemplary. Their purpose is only to illustrate the feasibility of implementing the technical solution of the present application, but it does not mean that the applicant has or will necessarily use the relevant content of the solution.

[0020] Figure 1 is a flow chart of a data testing method according to the first embodiment of the present disclosure, such as Figure 1 As shown, an application and a server, wherein a data testing tool is configured in the server, the method includes:

[0021] S101: Acquire data test tasks of multiple test batches, wherein each data test task of each test batch has corresponding task description information.

[0022] In the disclosed embodiment, the data testing method may be executed by a data testing tool configured in the server, and the data testing tool may be used to implement two functions: testing database access and batch verification.

[0023] Among them, test database access, as a key link in connecting to the application database under test, supports conversion of multiple types of databases, completes zero-code environment cleaning and test data generation, and obtains result data in the database, providing a basis for data verification.

[0024] Among them, batch verification configuration and verification are based on Python, organized by test plan, test task, test round, and input test data and expected results of each round. Task information and environment configuration are used as global configuration and identified before running. The verification process is organized by configuration to ensure the smooth migration of testers' test process habits. Python configuration engineering is plug-and-play and does not require deployment.

[0025] In the embodiments of the present disclosure, see Figure 2 , Figure 2 It is a schematic diagram of the data testing process proposed in an embodiment of the present disclosure, that is, it can be a data testing plan for obtaining, which data testing plan can include multiple batches of data testing tasks, each batch of data testing tasks can be divided into multiple data testing rounds, and multiple testing rounds in each data testing task can be executed in batches.

[0026] The task description information may be used to describe the data test task. The task description information may be, for example, task identification information of the data test task, such as task number, task execution order, etc., without limitation.

[0027] That is to say, in the embodiments of the present disclosure, data testing tasks for multiple test batches can be obtained based on the data testing tool configured in the server, and then the data testing tasks can be executed based on the data testing method described in the embodiments of the present disclosure. For details, please refer to the subsequent embodiments and will not be repeated here.

[0028] S102: Obtain a to-be-tested data table corresponding to each data test batch.

[0029] The data to be tested of each data test batch may be sorted to obtain a data table to be tested, so that the data to be tested can be more clearly readable, thereby facilitating the execution of subsequent data testing methods.

[0030] In the embodiment of the present disclosure, the data testing tool configured in the server can obtain the data to be tested from multiple types of databases, including informix, mysql, pg, dws and other database types, and then summarize the data to be tested to determine the data table to be tested corresponding to each data test batch.

[0031] In some embodiments, obtaining the data table to be tested corresponding to each data test batch may be to obtain the data to be tested corresponding to each data batch, then determine the data to be tested corresponding to the data test task under each data test batch, then determine the data to be tested corresponding to the test round under each data test task, and based on a preset table structure, store the data to be tested corresponding to the test round under each data test task in a data table, and determine the table identifier corresponding to the data table as: data test batch identifier-data test task identifier-test round number, so that during the execution of the data testing method, the data table to be tested corresponding to the current test round can be determined from multiple data tables, without limitation.

[0032] Optionally, in some embodiments, obtaining a data table to be tested corresponding to each data test batch may be to obtain multiple initial data and multiple initial test cases, wherein each initial data has corresponding first description information, and each initial test case has corresponding second description information, determine candidate test data corresponding to each test batch from the multiple initial data, and determine candidate test cases corresponding to each test batch from the multiple initial test cases, and process the candidate test data of each test batch according to a preset table structure, the first description information of the candidate test data of each test batch, and the second description information of the candidate test cases to obtain a test data table.

[0033] The first description information may be used to describe the initial data. The first description information may be, for example, an initial data identifier, storage location information of the initial data in the original database, etc., and there is no limitation on this.

[0034] The second description information may be used to describe the initial test case. The second description information may be, for example, a test case identifier, a test function implemented by the test case, etc., and there is no limitation on this.

[0035] That is to say, in the embodiments of the present disclosure, multiple initial data and multiple initial test cases may be obtained, wherein each initial data has corresponding first description information and each initial test case has corresponding second description information, candidate test data corresponding to each test batch is determined from the multiple initial data, and candidate test cases corresponding to each test batch are determined from the multiple initial test cases, and the candidate test data of each test batch is processed according to a preset table structure, the first description information of the candidate test data of each test batch and the second description information of the candidate test cases to obtain a test data table.

[0036] For example, a test data table corresponds to a test round. A fixed form is used in the test data table to represent the basic initialization of the function. The remaining forms named after the tables are the test data of each table. The serial number indicates the order of data cleaning. The primary key configuration rule is that the first line is the library table field, marked with * as the primary key, and the second line and the following are the data to be tested. The test case association rules include: each line of data to be tested is marked with the test case ID, and key fields also have special markings.

[0037] S103: Obtain a test result table corresponding to each data test batch, wherein the table structure of the to-be-tested data table and the test result table is the same.

[0038] In the disclosed embodiment, after executing the data test task of each data test batch, a test result table corresponding to each data test batch can be obtained.

[0039] The table structures of the data table to be tested and the test result table are the same, and the test result table includes multiple test results.

[0040] That is to say, in the embodiments of the present disclosure, the data testing task can be executed in batches to obtain multiple data testing results corresponding to each data testing batch, and the multiple data testing results corresponding to each data testing batch can be sorted to obtain a test result table corresponding to each data testing batch. Then, the task execution status of the data testing task can be verified based on the test result table. For details, please refer to the subsequent embodiments.

[0041] Optionally, in some embodiments, obtaining a test result table corresponding to each data test batch may be to obtain a reference test result corresponding to each test batch, and then process the reference test result of each test batch according to a preset table structure, the first description information of the candidate test data of each test batch and the second description information of the candidate test cases to obtain a test result table.

[0042] That is, in the embodiment of the present disclosure, the data test results generated by the data test task may be sorted according to the preset table results, and the first description information of the candidate test data and the second description information of the candidate test case may be associated to obtain a test result table.

[0043] S104: sequentially loading the data table to be tested and the test result table of each test batch according to the order of the multiple test batches, so as to generate a data test report according to the data table to be tested and the test result table of each test batch.

[0044] Among them, the data test report can describe the test environment, an overview of the test results (such as the number of tests passed, the number of test rounds in which the tests failed), and the verification details of each task, including the verification details of all fields that passed and failed, so that testers can review the verification process.

[0045] In an embodiment of the present disclosure, after obtaining the test result table corresponding to each data test batch, the data table to be tested and the test result table of each test batch can be loaded sequentially according to the order of multiple test batches to generate a data test report based on the data table to be tested and the test result table of each test batch.

[0046] Optionally, in some embodiments, before generating a data test report based on the test data table and the test result table of each test batch, the test environment required to execute the corresponding data test task may be configured based on the data test task of the test batch having corresponding task description information.

[0047] In the embodiment of the present disclosure, before generating a data test report based on the test data table and the test result table of each test batch, one-key switching of the test environment can be supported, so that the data testing method described in the embodiment of the present disclosure can be applicable to a variety of test environments.

[0048] Optionally, in some embodiments, a data test report is generated based on the data table to be tested and the test result table of each test batch. The data table to be tested may be processed according to the candidate test cases corresponding to each test batch to obtain predicted test results, and then the predicted test results and the test result table are compared field by field to generate a data test report.

[0049] The expected test result refers to the expected test result obtained in advance, and the expected test result is also stored in the preset table result, so as to facilitate the comparison with the pre-test data table and improve the result verification efficiency.

[0050] That is to say, in the embodiments of the present disclosure, the expected result data may be loaded, and the test result identifier may be obtained. According to the expected result table, the primary key of the library table may be identified table by table, the result data may be queried, and all fields may be batch verified with the expected results. Each field may be checked according to the data and the results may be recorded until the test results of all test rounds are compared and a test report is generated.

[0051] In the disclosed embodiments, a low-configuration, deployment-free data batch verification tool is used to simplify the automated testing of data batch processing functions, realize data as scripts and data as use cases, and better facilitate testers to implement the verification process while improving data batch verification efficiency and data maintainability.

[0052] In an embodiment of the present disclosure, data testing tasks for multiple test batches are obtained, wherein the data testing tasks for each test batch have corresponding task description information, a data table to be tested corresponding to each data test batch is obtained, and a test result table corresponding to each data test batch is obtained, wherein the table structures in the data table to be tested and the test result table are the same, and according to the order of the multiple test batches, the data table to be tested and the test result table of each test batch are sequentially loaded to generate a data testing report based on the data table to be tested and the test result table of each test batch, thereby enabling batch processing of data testing tasks, and effectively improving data testing efficiency while ensuring data testing accuracy.

[0053] Figure 3 is a block diagram of a data testing device according to the present disclosure, such as Figure 3 As shown, the data testing device 30 is applied to a server, wherein the server is configured with a data testing tool, including:

[0054] A first acquisition module 301 is used to acquire data test tasks of multiple test batches, wherein each data test task of each test batch has corresponding task description information;

[0055] The second acquisition module 302 is used to acquire the to-be-tested data table corresponding to each data test batch;

[0056] The third acquisition module 303 is used to acquire a test result table corresponding to each data test batch, wherein the table structure of the test data table and the test result table is the same;

[0057] The testing module 304 is used to sequentially load the data table to be tested and the test result table of each test batch according to the order of the multiple test batches, so as to generate a data test report according to the data table to be tested and the test result table of each test batch.

[0058] In some embodiments of the present disclosure, the second acquisition module 302 is further configured to:

[0059] Acquire a plurality of initial data and a plurality of initial test cases, wherein each initial data has corresponding first description information, and each initial test case has corresponding second description information;

[0060] Determine candidate test data corresponding to each test batch from the plurality of initial data, and determine candidate test cases corresponding to each test batch from the plurality of initial test cases;

[0061] According to the preset table structure, the first description information of the candidate test data of each test batch and the second description information of the candidate test case, the candidate test data of each test batch is processed to obtain a test data table.

[0062] In some embodiments of the present disclosure, the third acquisition module 303 is further configured to:

[0063] Obtaining reference test results corresponding to each test batch;

[0064] According to the preset table structure, the first description information of the candidate test data of each test batch and the second description information of the candidate test cases, the reference test results of each test batch are processed to obtain a test result table.

[0065] In some embodiments of the present disclosure, the testing module 304 is further configured to:

[0066] Before generating a data test report according to the to-be-tested data table and the test result table of each test batch, a test environment required for executing the corresponding data test task is configured according to the task description information corresponding to the data test task of the test batch.

[0067] In some embodiments of the present disclosure, the testing module 304 is further configured to:

[0068] Processing the data table to be tested according to the candidate test cases corresponding to each test batch to obtain a predicted test result;

[0069] Compare the predicted test results and the test result table field by field to generate a data test report.

[0070] It should be noted that the aforementioned explanation of the data testing method is also applicable to the data testing device of this embodiment and will not be repeated here.

[0071] In an embodiment of the present disclosure, data testing tasks for multiple test batches are obtained, wherein the data testing tasks for each test batch have corresponding task description information, a data table to be tested corresponding to each data test batch is obtained, and a test result table corresponding to each data test batch is obtained, wherein the table structures in the data table to be tested and the test result table are the same, and according to the order of the multiple test batches, the data table to be tested and the test result table of each test batch are sequentially loaded to generate a data testing report based on the data table to be tested and the test result table of each test batch, thereby enabling batch processing of data testing tasks, and effectively improving data testing efficiency while ensuring data testing accuracy.

[0072] Figure 4 A block diagram of an exemplary electronic device suitable for implementing embodiments of the present disclosure is shown.

[0073] Figure 4 The electronic device 12 shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present disclosure.

[0074] like Figure 4As shown, the electronic device 12 is in the form of a general purpose computing device. The components of the electronic device 12 may include, but are not limited to: one or more processors or processing units 16, a memory 28, and a bus 18 that connects various system components (including the memory 28 and the processing unit 16).

[0075] The bus 18 represents one or more of several types of bus structures, including a memory bus or memory controller, a peripheral bus, a graphics acceleration port, a processor or a local bus using any of a variety of bus structures. For example, these architectures include but are not limited to Industry Standard Architecture (ISA) bus, Micro Channel Architecture (MAC) bus, Enhanced ISA bus, Video Electronics Standards Association (VESA) local bus and Peripheral Component Interconnection (PCI) bus.

[0076] The electronic device 12 typically includes a variety of computer system readable media. These media can be any available media that can be accessed by the electronic device 12, including volatile and non-volatile media, removable and non-removable media.

[0077] The memory 28 may include computer system readable media in the form of volatile memory, such as random access memory (RAM) 30 and / or cache memory 32. The electronic device 12 may further include other removable / non-removable, volatile / non-volatile computer system storage media. By way of example only, the storage system 34 may be used to read and write non-removable, non-volatile magnetic media ( Figure 4 Not shown, often called a "hard drive").

[0078] although Figure 4Not shown in the figure, a disk drive for reading and writing a removable non-volatile disk (e.g., a "floppy disk"), and an optical disk drive for reading and writing a removable non-volatile optical disk (e.g., a compact disc read only memory (hereinafter referred to as: CD-ROM), a digital versatile disc read only memory (hereinafter referred to as: DVD-ROM) or other optical media) may be provided. In these cases, each drive may be connected to the bus 18 via one or more data medium interfaces. The memory 28 may include at least one program product having a set (e.g., at least one) of program modules that are configured to perform the functions of the various embodiments of the present disclosure.

[0079] A program / utility 40 having a set (at least one) of program modules 42 may be stored, for example, in the memory 28, such program modules 42 including but not limited to an operating system, one or more application programs, other program modules, and program data, each of which or some combination may include an implementation of a network environment. The program modules 42 generally perform the functions and / or methods of the embodiments described in the present disclosure.

[0080] The electronic device 12 may also communicate with one or more external devices 14 (e.g., keyboard, pointing device, display 24, etc.), may also communicate with one or more devices that enable the human body to interact with the electronic device 12, and / or communicate with any device that enables the electronic device 12 to communicate with one or more other computing devices (e.g., network card, modem, etc.). Such communication may be performed through an input / output (I / O) interface 22. In addition, the electronic device 12 may also communicate with one or more networks (e.g., a local area network (LAN), a wide area network (WAN), and / or a public network, such as the Internet) through a network adapter 20. As shown, the network adapter 20 communicates with other modules of the electronic device 12 through a bus 18. It should be understood that, although not shown in the figure, other hardware and / or software modules may be used in conjunction with the electronic device 12, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems.

[0081] The processing unit 16 executes various functional applications and parameter information determination by running the program stored in the memory 28, such as implementing the business data storage method mentioned in the above embodiment, or implementing the business data acquisition method mentioned in the above embodiment.

[0082] It should be noted that, in the description of the present disclosure, the terms "first", "second", etc. are only used for descriptive purposes and cannot be understood as indicating or implying relative importance. In addition, in the description of the present disclosure, unless otherwise specified, the meaning of "plurality" is two or more.

[0083] Any process or method description in a flowchart or otherwise described herein may be understood to represent a module, segment or portion of code that includes one or more executable instructions for implementing the steps of a specific logical function or process, and the scope of the preferred embodiments of the present disclosure includes alternative implementations in which functions may not be performed in the order shown or discussed, including performing functions in a substantially simultaneous manner or in the reverse order depending on the functions involved, which should be understood by those skilled in the art to which the embodiments of the present disclosure belong.

[0084] It should be understood that the various parts of the present disclosure can be implemented in hardware, software, firmware or a combination thereof. In the above-mentioned embodiments, multiple steps or methods can be implemented in software or firmware stored in a memory and executed by a suitable instruction execution system. For example, if implemented in hardware, as in another embodiment, it can be implemented by any one of the following technologies known in the art or their combination: a discrete logic circuit having a logic gate circuit for implementing a logic function for a data signal, a dedicated integrated circuit having a suitable combination of logic gate circuits, a programmable gate array (PGA), a field programmable gate array (FPGA), etc.

[0085] A person of ordinary skill in the art may understand that all or part of the steps in the method for implementing the above-mentioned embodiment may be completed by instructing related hardware through a program, and the program may be stored in a computer-readable storage medium, which, when executed, includes one or a combination of the steps of the method embodiment.

[0086] In addition, each functional unit in each embodiment of the present disclosure may be integrated into a processing module, or each unit may exist physically separately, or two or more units may be integrated into one module. The above-mentioned integrated module may be implemented in the form of hardware or in the form of a software functional module. If the integrated module is implemented in the form of a software functional module and sold or used as an independent product, it may also be stored in a computer-readable storage medium.

[0087] The storage medium mentioned above can be a read-only memory, a magnetic disk or an optical disk, etc.

[0088] In the description of this specification, the description with reference to the terms "one embodiment", "some embodiments", "example", "specific example", or "some examples" means that the specific features, structures, materials or characteristics described in conjunction with the embodiment or example are included in at least one embodiment or example of the present disclosure. In this specification, the schematic representation of the above terms does not necessarily refer to the same embodiment or example. Moreover, the specific features, structures, materials or characteristics described may be combined in any one or more embodiments or examples in a suitable manner.

[0089] Although the embodiments of the present disclosure have been shown and described above, it is to be understood that the above embodiments are exemplary and are not to be construed as limitations of the present disclosure. A person skilled in the art may change, modify, replace and vary the above embodiments within the scope of the present disclosure.

Claims

1. A data testing method, characterized in that: Application and server, wherein the server is configured with a data testing tool, the method comprising: Acquire data test tasks of multiple test batches, wherein the data test tasks of each test batch have corresponding task description information; Obtaining a data table to be tested corresponding to each of the data test batches; Obtaining a test result table corresponding to each of the data test batches, wherein the table structure of the to-be-tested data table and the test result table is the same; According to the sequence of the plurality of test batches, the to-be-tested data table and the test result table of each test batch are sequentially loaded to generate a data test report according to the to-be-tested data table and the test result table of each test batch.

2. The method according to claim 1, characterized in that The step of obtaining a data table to be tested corresponding to each of the data test batches includes: Acquire a plurality of initial data and a plurality of initial test cases, wherein each of the initial data has corresponding first description information, and each of the initial test cases has corresponding second description information; Determine candidate test data corresponding to each of the test batches from a plurality of initial data, and determine candidate test cases corresponding to each of the test batches from a plurality of initial test cases; The candidate test data of each test batch is processed according to the preset table structure, the first description information of the candidate test data of each test batch and the second description information of the candidate test case to obtain the test data table.

3. The method according to claim 2, characterized in that The obtaining of a test result table corresponding to each of the data test batches includes: Obtaining reference test results corresponding to each of the test batches; According to the preset table structure, the first description information of the candidate test data of each test batch and the second description information of the candidate test case, the reference test result of each test batch is processed to obtain the test result table.

4. The method according to claim 1, characterized in that Before generating a data test report according to the to-be-tested data table and the test result table of each test batch, the method further includes: According to the data test tasks of the test batch having corresponding task description information, a test environment required for executing the corresponding data test tasks is configured.

5. The method according to claim 2, characterized in that The generating of a data test report according to the to-be-tested data table and the test result table of each test batch includes: Processing the test data table according to the candidate test cases corresponding to each of the test batches to obtain a predicted test result; The predicted test result and the test result table are compared field by field to generate the data test report.

6. A data testing device, characterized in that: Application and server, wherein the server is configured with a data testing tool, the device comprises: A first acquisition module is used to acquire data test tasks of multiple test batches, wherein the data test tasks of each test batch have corresponding task description information; A second acquisition module is used to acquire a data table to be tested corresponding to each of the data test batches; A third acquisition module is used to acquire a test result table corresponding to each of the data test batches, wherein the table structure of the data table to be tested and the test result table are the same; The test module is used to sequentially load the data table to be tested and the test result table of each test batch according to the order of the multiple test batches, so as to generate a data test report according to the data table to be tested and the test result table of each test batch.

7. The device according to claim 1, characterized in that The second acquisition module is further used for: Acquire a plurality of initial data and a plurality of initial test cases, wherein each of the initial data has corresponding first description information, and each of the initial test cases has corresponding second description information; Determine candidate test data corresponding to each of the test batches from a plurality of initial data, and determine candidate test cases corresponding to each of the test batches from a plurality of initial test cases; The candidate test data of each test batch is processed according to the preset table structure, the first description information of the candidate test data of each test batch and the second description information of the candidate test case to obtain the test data table.

8. An electronic device, characterized in that: include: processor; a memory for storing instructions executable by the processor; The processor is configured to execute the instructions to implement the method according to any one of claims 1 to 5.

9. A computer-readable storage medium, when instructions in the computer-readable storage medium are executed by a processor of an electronic device, the electronic device is enabled to execute the method according to any one of claims 1 to 5.

10. A computer program product, comprising a computer program, characterized in that When the computer program is executed by a processor, the method according to any one of claims 1 to 5 is implemented.

Images