Test method and device for message iterative verification, equipment, medium and program product

Abstract

The invention discloses a test method and device for message iterative verification, equipment, a medium and a program product. The test method comprises the following steps: determining nodes to be compared in message data in a Json data format; configuring connection component information, comparison function information and comparison rule information; according to the connection component information, the comparison function information and the comparison rule information, field verification operation of the to-be-compared node and the target database is automatically executed; and performing iterative task verification on the field verification operation to generate a verification test report. According to the method, the automatic test framework comprising the connection component information, the comparison function information and the comparison rule information is constructed, so that the automatic comparison between the Json node and the database field is realized, and the comparison efficiency and accuracy are remarkably enhanced.

Description

TECHNICAL FIELD

[0001] The present application relates to the field of automation testing, and in particular to a message iteration verification test method, device, equipment, medium and program product. BACKGROUND

[0002] In the current software development and data processing process, the comparison between Json format data and database fields is a common and important task. Json is the preferred format for data exchange and transmission due to its easy-to-read and easy-to-write characteristics. Database, as the core of data storage, carries the key data for stable operation of the system. However, in practical applications, due to the diversity of data sources, the complexity of data formats and the real-time requirements of data processing, the comparison between Json nodes and database fields becomes particularly difficult.

[0003] The traditional comparison method mainly relies on manual operation, which is low in efficiency and prone to errors. Therefore, how to realize the automatic comparison between Json nodes and database fields has become a problem to be solved in the field of automated testing. SUMMARY

[0004] The technical problem to be solved by the present application is to overcome the defects of manual comparison of message data in Json data format in the prior art, low efficiency and easy to make mistakes, and to provide a message iteration verification test method, device, equipment, medium and program product.

[0005] The present application solves the above technical problems by the following technical solutions:

[0006] In a first aspect, the present application provides a message iteration verification test method, which comprises:

[0007] determining a node to be compared in message data in Json data format;

[0008] configuring connection component information, comparison function information and comparison rule information; the connection component information is used to establish a connection between the node to be compared and a target database;

[0009] automatically performing a field verification operation of the node to be compared and the target database according to the connection component information, the comparison function information and the comparison rule information;

[0010] iterative task verification is performed on the field verification operation to generate a verification test report.

[0011] Preferably, the comparison function information includes first parameter information and second parameter information; the step of automatically performing the field verification operation of the node to be compared and the target database according to the connection component information, the comparison function information and the comparison rule information comprises:

[0012] According to the first parameter information and the to-be-compared node, a first value is obtained from the message data;

[0013] According to the second parameter information, a second value is obtained from the target database;

[0014] Based on the first value, the second value, and the comparison rule information, the field verification operation is performed.

[0015] Preferably, the test method further comprises:

[0016] A visual rendering operation is performed on the data results of the verification test report; the data results are stored in the form of cells;

[0017] A cell background storing verification equal information in the data results is set to first color information;

[0018] A cell background storing verification unequal information in the data results is set to second color information, and the verification unequal information corresponds to a difference field with a unique identifier and a prompt icon.

[0019] Preferably, the step of performing an iterative task check on the field verification operation to generate a verification test report comprises:

[0020] It is determined whether the current node is the last node of the to-be-compared node;

[0021] If not, the step of automatically performing the field verification operation of the to-be-compared node and the target database according to the connection component information, the comparison function information, and the comparison rule information is repeatedly executed.

[0022] Preferably, the connection component information comprises at least one of database address information, database port information, database instance information, and comparison target table information in the database.

[0023] Preferably, the verification unequal information comprises at least one of value inequality, field type inequality, array length inequality, and target field absence.

[0024] In a second aspect, the present application provides a test device for message iterative verification, which comprises:

[0025] A determination module is configured to determine a to-be-compared node in message data in a Json data format;

[0026] A configuration module is configured to configure connection component information, comparison function information, and comparison rule information; the connection component information is used to establish a connection between the to-be-compared node and a target database.

[0027] an execution module, configured to automatically perform a field verification operation of the to-be-verified node and the target database according to the connection component information, the comparison function information, and the comparison rule information;

[0028] a verification module, configured to perform iterative task verification on the field verification operation, and generate a verification test report.

[0029] Preferably, the comparison function information comprises first parameter information and second parameter information; and the execution module comprises:

[0030] a first acquisition unit, configured to acquire a first value from the message data according to the first parameter information and the to-be-verified node;

[0031] a second acquisition unit, configured to acquire a second value from the target database according to the second parameter information;

[0032] a verification unit, configured to perform the field verification operation based on the first value, the second value, and the comparison rule information.

[0033] Preferably, the test device further comprises:

[0034] a visual rendering module, configured to perform a visual rendering operation on data results of the verification test report; the data results are stored in a form of cells.

[0035] a first setting module, configured to set a background of a cell in which verification equal information is stored in the data results to first color information;

[0036] a second setting module, configured to set a background of a cell in which verification unequal information is stored in the data results to second color information, and the verification unequal information corresponds to a difference field with a unique identifier and a prompt icon.

[0037] Preferably, the verification module comprises:

[0038] a judgment unit, configured to judge whether a current node is the last node of the to-be-verified node; if not, a loop unit is invoked;

[0039] the loop unit, configured to cyclically execute the step of automatically performing the field verification operation of the to-be-verified node and the target database according to the connection component information, the comparison function information, and the comparison rule information.

[0040] Preferably, the connection component information comprises at least one of database address information, database port information, database instance information, and comparison target table information in the database.

[0041] Preferably, the verification inequality information includes at least one of a numerical inequality, a field type inequality, an array length inequality, and a target field absence.

[0042] In a third aspect, the present application provides an electronic device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the computer program to implement the message iteration verification test method according to the first aspect.

[0043] In a fourth aspect, the present application provides a computer readable storage medium, wherein the computer readable storage medium stores a computer program, and the computer program is executable on a processor to implement the message iteration verification test method according to the first aspect.

[0044] In a fifth aspect, the present application provides a computer program product, comprising a computer program, and the computer program is executable on a processor to implement the message iteration verification test method according to the first aspect.

[0045] The positive progress effect of the present application is that a message iteration verification test method, device, equipment, medium and program product are provided, a node to be compared in message data in a Json data format is determined, connection component information, comparison function information and comparison rule information are configured, a field verification operation of the node to be compared and a target database is automatically executed according to the connection component information, the comparison function information and the comparison rule information, and iteration task verification is performed on the field verification operation to generate a verification test report. The present application realizes automatic comparison of Json nodes and database fields by constructing an automatic test framework including connection component information, comparison function information and comparison rule information, and significantly enhances comparison efficiency and accuracy. BRIEF DESCRIPTION OF DRAWINGS

[0046] Figure 1 The first flowchart of the message iteration verification test method of the embodiment 1 of the present application.

[0047] Figure 2 The second flowchart of the message iteration verification test method of the embodiment 1 of the present application.

[0048] Figure 3 The third flowchart of the message iteration verification test method of the embodiment 1 of the present application.

[0049] Figure 4 The first module schematic diagram of the message iteration verification test device of the embodiment 2 of the present application.

[0050] Figure 5 The second module schematic diagram of the message iteration verification test device of the embodiment 2 of the present application.

[0051] Figure 6 Fig. 1 is a schematic diagram of a hardware structure of an electronic device according to an embodiment of the present application. DETAILED DESCRIPTION

[0052] The present application will be further described by way of examples but is not limited to the examples described.

[0053] Embodiment 1

[0054] This embodiment provides a test method for message iteration verification, as shown in the figure, the test method comprises: Figure 1 S11, determining a node to be compared in message data in a Json data format;

[0055] S11, determining a node to be compared in message data in a Json data format;

[0056] S12, configuring connection component information, comparison function information and comparison rule information; the connection component information is used to establish a connection between the node to be compared and a target database;

[0057] S13, automatically performing a field verification operation of the node to be compared and the target database according to the connection component information, the comparison function information and the comparison rule information;

[0058] S14, performing iteration task verification on the field verification operation, and generating a verification test report.

[0059] The connection component information comprises at least one of database address information, database port information, database instance information and comparison target table information in the database.

[0060] For steps S11-S12, the message data in the Json data format is analyzed, the entire Json tree structure is traversed, each leaf node and important intermediate nodes are determined, and the node to be compared is screened out. The node value in the message data is obtained, and the node value is parameterized by using a parameterization component. A connection component is set for each node to be compared, and the connection component information is configured for the connection component. The database address information, the database port information, the database instance information and other information for establishing a connection with the node to be compared are configured. After the configuration is completed, the fields to be compared are extracted by a field extraction component, the fields to be compared are analyzed, and each field is used as a parameter.

[0061] For steps S13-S14, the target field extracted from the node to be compared and the target field extracted from the target database are taken as two parameters of the comparison function information, the comparison function information is executed, and the field verification operation is performed according to the set comparison rule information. In the process of the field verification operation, the iteration task verification is continuously performed until the nodes to be compared are all compared, and a verification test report is generated. The comparison rule information can include but is not limited to dynamic matching rules and special matching rules. The dynamic matching rules include basic type comparison, complex type comparison and special type comparison. For example, the comparison of strings, numerical values and Boolean values is basic type comparison; the comparison of key fields, array lengths and array elements is complex type comparison; the comparison of date formats after conversion, enumeration value mapping comparison and other custom comparison logic based on node path or field name registration are special type comparison. The comparison rule information is executed, and the field data in the node to be compared and the field data in the database are respectively called by the comparison function information for deep comparison, and a result set of the field verification operation is output. The result set includes detailed comparison results at each field level, which is stored in the form of a cell according to the record row and the field name. Through the test method, the developer can quickly find the inconsistency of the message data in the Json data format with the database, and timely repair, thereby ensuring the stable operation of the system.

[0062] In an embodiment, the comparison function information includes first parameter information and second parameter information; as Figure 2 The step S13 specifically includes:

[0063] S131, obtaining a first numerical value from the message data according to the first parameter information and the node to be compared;

[0064] S132, obtaining a second numerical value from the target database according to the second parameter information;

[0065] S133, performing a field verification operation based on the first numerical value, the second numerical value and the comparison rule information.

[0066] In this embodiment, the first parameter information includes jsonNode function information, which represents a specific data node collected and sorted from a source JSON structure (such as an API response or a configuration file). The second parameter information includes dbField function information, which represents a corresponding field value extracted from a specified target table query in a configured target database connection. The first numerical value is obtained from the message data according to the jsonNode function information and the node to be compared, the second numerical value is obtained from the target database according to the dbField function information, and the field verification operation is performed according to the jsonNode function information, the dbField function information and the comparison rule information. This way, the first parameter information and the second parameter information are defined to realize automatic field verification operation, which improves the verification operation efficiency.

[0067] In an embodiment, step S14 specifically comprises:

[0068] determining whether the current node is the last node of the nodes to be compared; if not, step S13 is executed in a loop.

[0069] In this embodiment, in the process of performing the iteration task verification, it is determined whether the current node is the last row data group of the nodes to be compared. If yes, it indicates that all the nodes to be compared have been compared in turn, and the verification test report is directly output. If not, it indicates that all the nodes to be compared have not been compared, and the iteration is automatically performed in a loop until the current node is the last node of the nodes to be compared. This mode guarantees the continuity, integrity and timeliness of the verification of the nodes to be compared.

[0070] In an embodiment, as shown in Figure 3 the test method further comprises:

[0071] S151, performing a visual rendering operation on the data results of the verification test report; the data results are stored in the form of cells;

[0072] S152, setting the background of the cell storing the verification equal information in the data results to first color information;

[0073] S153, setting the background of the cell storing the verification unequal information in the data results to second color information, and the difference field corresponding to the verification unequal information has a unique identifier and a prompt icon.

[0074] The verification unequal information includes at least one of numerical inequality, field type inequality, array length inequality and target field absence.

[0075] In this embodiment, the background colors of the cells corresponding to the verification equal information and the verification unequal information in the data results are distinguished to highlight the differences. For example, the first color is white, indicating that the field value is matched successfully in the JSON source data and the target database; the second color is red, indicating that the field value is not matched successfully in the JSON source data and the target database. In addition, a prompt icon "value inequality", expected to be "ABC", actual "XYZ" is added in the cell of the inconsistent field. This mode can quickly and accurately distinguish the verification equal information and the verification unequal information of the verification test report, and for the data items that fail to match, it is convenient to intuitively determine the reason, for example, there may be differences in the name, data type or value range of the JSON source data content and the database field.

[0076] In the embodiment, a test method for message iteration verification is provided. By constructing an automatic test framework including connection component information, comparison function information and comparison rule information, automatic comparison of Json nodes and database fields is realized, and comparison efficiency and accuracy are significantly enhanced.

[0077] Embodiment 2

[0078] The embodiment provides a test device for message iteration verification, as shown in the figure, the test device comprises: Figure 4

[0079] A determination module 210 is configured to determine a node to be compared in message data in a Json data format.

[0080] A configuration module 220 is configured to configure connection component information, comparison function information and comparison rule information. The connection component information is used to establish a connection between the node to be compared and a target database.

[0081] An execution module 230 is configured to automatically perform a field verification operation of the node to be compared and the target database according to the connection component information, the comparison function information and the comparison rule information.

[0082] A verification module 240 is configured to perform iteration task verification on the field verification operation, and generate a verification test report.

[0083] The connection component information includes at least one of database address information, database port information, database instance information and comparison target table information in the database.

[0084] The message data in the Json data format is analyzed, the entire Json tree structure is traversed, the determination module 210 determines each leaf node and important intermediate nodes, and the node to be compared is screened out. The node value in the message data is obtained, and the node value is parameterized by using a parameterization component. The configuration module 220 sets a connection component for each node to be compared, configures connection component information for the connection component, and configures information such as database address information, database port information and database instance information for establishing a connection with the node to be compared. After the configuration is completed, the fields to be compared are extracted by a field extraction component, the fields to be compared are analyzed, and each field is used as a parameter.

[0085] ​The execution module 230 executes the comparison function information by taking the target field extracted from the node to be compared and the target field extracted from the target database as two parameters of the comparison function information, and performs the field verification operation according to the set comparison rule information. During the field verification operation, the verification module 240 continuously performs iteration task verification until the nodes to be compared are all compared, and generates a verification test report. The comparison rule information can include but is not limited to dynamic matching rules and special matching rules. The dynamic matching rules include basic type comparison, complex type comparison and special type comparison. For example, the comparison of strings, numerical values and Boolean values is a basic type comparison; the comparison of key fields, array lengths and array elements is a complex type comparison; the comparison of date formats after conversion, enumeration value mapping comparison and other custom comparison logic based on node path or field name registration are special type comparisons. The comparison rule information is executed, and the field data in the node to be compared and the field data in the database are respectively called by the comparison function information for deep comparison, and the result set of the field verification operation is output. The result set includes detailed comparison results at each field level, which is stored in the form of a cell according to the record row and the field name. Through this test method, the developer can quickly find the inconsistency of the message data in the Json data format with the database, and timely repair, so as to ensure the stable operation of the system.

[0086] In an embodiment, the comparison function information includes first parameter information and second parameter information; the execution module 230 includes:

[0087] The first acquisition unit 231 is configured to acquire a first numerical value from the message data according to the first parameter information and the node to be compared;

[0088] The second acquisition unit 232 is configured to acquire a second numerical value from the target database according to the second parameter information;

[0089] The verification unit 233 is configured to perform a field verification operation based on the first numerical value, the second numerical value and the comparison rule information.

[0090] In this embodiment, the first parameter information includes jsonNode function information, indicating a specific data node collected and sorted from a source JSON structure (such as an API response, a configuration file). The second parameter information includes dbField function information, indicating a corresponding field value extracted from a specified target table query in a configured target database connection. The first obtaining unit 231 obtains the first value from the message data according to the jsonNode function information and the to-be-compared node, the second obtaining unit 232 obtains the second value from the target database according to the dbField function information, and the verification unit 233 performs the field verification operation according to the jsonNode function information, the dbField function information, and the comparison rule information. In this way, the field verification operation is realized automatically by defining the first parameter information and the second parameter information, and the verification operation efficiency is improved.

[0091] In an embodiment, the verification module 240 is specifically configured to:

[0092] determine whether the current node is the last node of the to-be-compared nodes; if not, the execution module 230 is called in a loop.

[0093] In this embodiment, in the process of performing the iteration task verification, it is determined whether the current node is the last row data group of the to-be-compared nodes. If yes, it is indicated that all the to-be-compared nodes are sequentially compared, and the verification test report is directly output. If not, it is indicated that all the to-be-compared nodes are not all compared, and the iteration is automatically performed in a loop until the current node is the last node of the to-be-compared nodes. In this way, the continuity, integrity, and timeliness of the to-be-compared node verification are ensured.

[0094] In an embodiment, as shown in Figure 5 the test device further includes:

[0095] The visual rendering module 251 is configured to perform a visual rendering operation on the data results of the verification test report. The data results are stored in the form of cells.

[0096] The first setting module 252 is configured to set the cell background in which the verification equal information is stored in the data results to first color information.

[0097] The second setting module 252 is configured to set the cell background in which the verification unequal information is stored in the data results to second color information, and the difference field corresponding to the verification unequal information has a unique identifier and a prompt icon.

[0098] The verification unequal information includes at least one of a numerical inequality, a field type inequality, an array length inequality, and a target field absence.

[0099] In this embodiment, the background colors of the cells corresponding to the verified equal information and the verified unequal information in the data results are distinguished to highlight the differences. For example, the first color is white, indicating that the field value is successfully matched in the JSON source data and the target database; the second color is red, indicating that the field value is not successfully matched in the JSON source data and the target database. In addition, a prompt icon "value not equal", expected to be "ABC", actual "XYZ" is added in the cell of the inconsistent field. In this way, the verified equal information and the verified unequal information of the verification test report can be quickly and accurately distinguished, and for the compared failed data items, the reasons can be determined intuitively, for example, the JSON source data content and the database field may differ in name, data type or value range.

[0100] In this embodiment, a test device for message iteration verification is provided. The execution module constructs an automatic test framework including connection component information, comparison function information and comparison rule information, realizes automatic comparison of the Json node and the database field, and significantly enhances the comparison efficiency and accuracy.

[0101] Embodiment 3

[0102] Figure 6 A hardware structure schematic diagram of an electronic device is provided for this embodiment. The electronic device includes a memory, a processor, and a computer program stored in the memory and executable on the processor, and the processor executes the program to realize the message iteration verification test method of embodiment 1, Figure 6 The electronic device 60 shown is only an example and should not limit the functions and use range of the embodiments of the present application.

[0103] The electronic device 60 can be in the form of a general computing device, for example, it can be a server device. The components of the electronic device 60 can include but are not limited to the above-mentioned at least one processor 61, the above-mentioned at least one memory 62, a bus 63 connecting different system components including the memory 62 and the processor 61.

[0104] The bus 63 includes a data bus, an address bus and a control bus.

[0105] The memory 62 can include volatile memory, such as random access memory (RAM) 621 and / or cache memory 622, and can further include read-only memory (ROM) 623.

[0106] The memory 62 can also include the programs / utilities 625 having a set (at least one) of program modules 624, including but not limited to: an operating system, one or more applications, other program modules, and program data, and each of such examples, or some combination thereof, can include implementation of a network environment.

[0107] The processor 61 performs various function applications and data processing by running the computer programs stored in the memory 62, such as the message iteration verification test method of embodiment 1 of the present application.

[0108] The electronic device 60 can also communicate with one or more external devices 64 (such as a keyboard, a pointing device, etc.) via an input / output (I / O) interface 65. Furthermore, the model generation electronic device 60 can communicate with one or more networks (such as a local area network (LAN), a wide area network (WAN), and / or a public network, such as the Internet) via a network adapter 66. As depicted, the network adapter 66 communicates with the other modules of the model generation electronic device 60 via the bus 63. It should be appreciated that although not shown, other hardware and / or software modules could be used in conjunction with the model generation electronic device 60, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID (Redundant Array of Independent Disks) systems, tape drives, and data archival storage systems, etc.

[0109] It should be noted that although several units / modules or sub-units / modules of the electronic device are mentioned in the foregoing detailed description, such a division is merely exemplary and not mandatory. Indeed, according to embodiments of the application, the features and functions of two or more units / modules described above can be embodied in one unit / module. Conversely, the features and functions of one unit / module described above can be further divided into units / modules embodied by several units / modules.

[0110] Embodiment 4

[0111] The present embodiment provides a computer readable storage medium, having stored thereon a computer program, the program being executed by a processor to implement the steps of the message iteration verification test method of embodiment 1.

[0112] More specifically, the readable storage medium can include, but is not limited to, a portable disc, a hard disk, a random access memory, a read-only memory, an erasable programmable read-only memory, an optical storage device, a magnetic storage device, or any suitable combination of the above.

[0113] In a possible implementation, the present application can also be implemented in the form of a program product, which comprises program code for causing the terminal device to perform the steps of the message iteration verification test method of embodiment 1 when the program product is run on the terminal device.

[0114] The program code for performing the present application can be written in any combination of one or more programming languages, and can be entirely executed on the user device, partially executed on the user device, executed as a stand-alone software package, partially executed on the user device and partially on a remote device, or entirely executed on a remote device.

[0115] Embodiment 5

[0116] The present embodiment also provides a computer program product comprising a computer program which, when executed by a processor, implements the message iteration verification test method of any one of the above.

[0117] The program code for performing the computer program product of the present disclosure can be written in any combination of one or more programming languages, and can be entirely executed on the user device, partially executed on the user device, executed as a stand-alone software package, partially executed on the user device and partially on a remote device, or entirely executed on a remote device.

[0118] Although the specific embodiments of the present application are described above, those skilled in the art should understand that this is only an illustration, and the protection scope of the present application is defined by the appended claims. Those skilled in the art can make various changes or modifications to these embodiments without departing from the principles and essence of the present application, and these changes and modifications all fall within the protection scope of the present application.

Claims

1. A test method for message iteration verification, characterized in that, The testing method includes: Identify the nodes to be compared in the message data in JSON format; Configure connection component information, comparison function information, and comparison rule information; the connection component information is used to establish a connection between the node to be compared and the target database; Based on the connection component information, the comparison function information, and the comparison rule information, the field verification operation between the node to be compared and the target database is automatically executed. The field validation operation is iteratively validated to generate a validation test report.

2. The test method for message iteration verification as described in claim 1, characterized in that, The comparison function information includes first parameter information and second parameter information; the step of automatically performing field verification operations between the node to be compared and the target database based on the connection component information, the comparison function information, and the comparison rule information includes: The first value is obtained from the message data based on the first parameter information and the node to be compared; The second value is obtained from the target database based on the second parameter information; The field verification operation is performed based on the first value, the second value, and the comparison rule information.

3. The test method for message iteration verification as described in claim 1, characterized in that, The testing method also includes: The data results of the verification test report are subjected to visual rendering; the data results are stored in cell format. Set the background of the cell storing the verification equality information in the data results to the first color information; The background of the cell storing the verification inequality information in the data results is set to the second color information, and the difference field corresponding to the verification inequality information has a unique identifier and a prompt icon.

4. The test method for message iteration verification as described in claim 1, characterized in that, The step of iteratively verifying the field validation operation and generating a validation test report includes: Determine whether the current node is the last node of the nodes to be compared; If not, then the step of automatically performing the field verification operation between the node to be compared and the target database based on the connection component information, the comparison function information and the comparison rule information is executed repeatedly.

5. The test method for message iteration verification as described in claim 1, characterized in that, The connection component information includes at least one of the following: database address information, database port information, database instance information, and comparison target table information in the database.

6. The test method for message iteration verification as described in claim 3, characterized in that, The verification of inequality information includes at least one of the following: unequal numerical values, unequal field types, unequal array lengths, and missing target field.

7. A test apparatus for message iteration verification, characterized in that, The testing apparatus includes: The determination module is used to identify the nodes to be compared in the message data in JSON format. The configuration module is used to configure connection component information, comparison function information, and comparison rule information; the connection component information is used to establish a connection between the node to be compared and the target database. The execution module is used to automatically perform field verification operations between the node to be compared and the target database based on the connection component information, the comparison function information, and the comparison rule information. The verification module is used to perform iterative task verification on the field verification operation and generate a verification test report.

8. An electronic device, characterized in that, It includes a processor, a memory, and a computer program stored in the memory and executable on the processor, wherein the computer program, when executed by the processor, implements the test method for message iterative verification as described in any one of claims 1-6.

9. A computer-readable storage medium, characterized in that, A computer program is stored on the computer-readable storage medium, which, when executed by a processor, implements the test method for message iterative verification as described in any one of claims 1-6.

10. A computer program product, comprising a computer program, characterized in that, When the computer program is executed by the processor, it implements the test method for message iterative verification as described in any one of claims 1-6.

Images