Method and device for verifying data of electronic data table, and storage medium

Abstract

The invention provides a method and a device for verifying data of an electronic data table, and a storage medium, and the method comprises the steps: a judgment step: judging whether a main key column name, obtained from a database, of the electronic data table is fixed, and if not, carrying out the traversal of the electronic data table, and determining n main key columns of the electronic datatable; and a verification step: matching the data in the electronic data table based on the n main key columns and the expected data, if the matching is consistent, the verification is passed, and n is an integer greater than 1. The invention provides a data verification method for solving the problem of data table main key column name change, which can automatically verify the data content in anelectronic data table with multiple main key columns, unfixed number and dynamically changed column names, avoids reading out all data in the data table for verification. The data verification efficiency is improved, the processing resources of the processor are saved, and the user experience is improved.

Description

technical field [0001] The invention relates to the technical field of computer data processing, in particular to a method, device and storage medium for verifying data in an electronic data form. Background technique [0002] UI automation is a common regression verification test regression method, and the verification result is an indispensable part of the test. Due to the characteristics of table data, that is, there may be multiple primary key columns, the number is not fixed, and the column names may be It is a situation of dynamic changes. In the prior art, the verification of each row of numbers in the table depends on the fixed column name of the primary key column. If the primary key is not fixed, it is difficult to find a way to verify through the interface automation method At this time, the accuracy of the data is difficult to verify, or through manual verification, or through continuous modification of the program code for verification, which is time-consuming a...

AI Technical Summary

Problems solved by technology

[0002] UI automation is a common regression verification test regression method, and the verification result is an indispensable part of the test. Due to the characteristics of table data, that is, there may be multiple primary key columns, the number is not fixed, and the column names may be It is a situation of dynamic changes. In the prior art, the verification of each row of numbers in the table depends on the fixed column name of the primary key column. If the primary key is not fixed, it is difficult to find a way to verify through the interface automation method , the accuracy of the data is difficult to verify at this time, or through manual verification, or through continuous modification of the program code to verify, time-consuming and laborious, and the verification effect is poor

[0003] In the prior art, for the above defects, the method of reading all the data in the data table is generally used for verification, which is inefficient in verification, wastes the processing resources of the processor, occupies bandwidth, and affects user experience

Images