Automation testing method and system based on test case data table

Abstract

The present application discloses an automation testing method and system based on a test case data table. The method comprises: firstly, determining a single table attribute of a corresponding test case data table according to a to-be-tested service logic; next, establishing a corresponding table template according to the determined single table attribute; then, adding specific data into the table template according to a specific testing demand, so as to obtain the corresponding test case data table; and finally, performing an automation test on each to-be-tested service according to the obtained test case data table. Compared with the prior art, the reusability of the table template in the method disclosed by the present invention is strong, and generation and maintenance of the test case data table are simpler and more efficient, so that testing efficiency and testing effects of the automation test can be improved.

Description

technical field [0001] The present application relates to the technical field of automated testing, in particular to an automated testing method and system based on a test case data table. Background technique [0002] With the increase in the scale and complexity of software development, the role of automated software testing has become increasingly prominent. Effective automated testing can greatly improve software development efficiency, save development and testing resources, and accelerate version iterations, thereby saving costs for the company. To realize software automation testing, it is first necessary to establish a test database to store data such as test cases required for testing. At present, the server-side automated test framework / tool ​​generally adopts the database data structure method as follows: each field of the table data involved in the test case is written one by one through SQL statements or xls, xml, etc., so as to directly generate the correspondi...

AI Technical Summary

Problems solved by technology

[0003] In practical applications, the above-mentioned data structure method has at least the following disadvantages: 1. In the process of writing data, it is necessary to ensure that each piece of data must meet both the requirements of business logic and the constraints of the database (ie, the constraints of the corresponding programming language), Resulting in low data construction efficiency; 2. The above-mentioned data construction method is directly written by specific test cases to obtain a test case data table for a certain business, which is difficult to reuse in similar businesses with different test cases; 3. In terms of data maintenance , based on the above data construction method, when the structure of the data table changes (such as adding fields, reducing fields, etc.), it is necessary to modify each test case data involving the table one by one, resulting in high data maintenance costs, and even further leading to no one. Maintenance, it is difficult to guarantee the effect of automated testing

Images