Interface testing method, system, device and storage medium based on database comparison

Abstract

The invention discloses an interface test method, a system, a computer device and a storage medium based on database comparison. The method comprises the following steps: a test interface is created in a user interaction interface, and request parameters of the interface are configured; the content that needs to be parameterized are parameterized in the user interaction interface; the test interface is called to add assertions; the test tool performs test operations, configure database statements and inputs for asserting framework invocations in the configuration file; accurate assertion is accomplished by comparing the return message with the result of database statement query configured in the configuration file. The corresponding test cases are generated one by one by substituting parameter values. Obtain the result and judge the test result one by one, and store the test data, test result and judgment result into the list. The method achieves accurate assertion from business logic,realizes automatic judgment of business logic, reduces manual input of regression test, and improves test efficiency.

Description

technical field

[0001] The invention relates to the technical field of testing, in particular to an interface testing method, system, computer equipment and storage medium based on database comparison. Background technique

[0002] Interface test is a test between components of the test system, mainly used to detect the interaction points between external systems and internal subsystems. The focus of the test is to check the exchange of data.

[0003] The Jmeter test tool can simulate HTTP, FTP and other requests, and perform functional and performance tests on open API interfaces. The principle is to build a thread pool, and run the sampler with multiple threads to generate a lot of load. The correctness of the results is verified through assertions during the running process, and the test results are recorded through the listener. The processing work before the request is sent is done through the pre-processor. The response message is processed through the post-processo...

Images