Automatic result inspection method for database service operation in Windows platform

Abstract

The invention relates to an automatic result inspection method for database service operation in a Windows platform. The method comprises the following steps that a tested object is connected to a Robot Framework testing framework; relevant test cases of database service operation are compiled; a database is searched for certain specific content, and the search result is stored in a txt file; a pscp command is operated, and the txt file is transmitted to a Linux machine from a Windows client side; the Robot Framework testing framework is connected to the Linux machine, the txt file is read, and read content is recorded into a temporary variable; the temporary variable is read, whether the result meeting testing requirements exists in the temporary variable or not is judged, if yes, the testing result is successful, and if not, the testing result is failing; the state of the tested object and the state of the Linux machine are restored so that subsequent cases can be operated. Compared with the prior art, the problem that an automatic testing framework cannot directly inspect database relevant parameters of the database operating in the Windows platform can be solved.

Description

technical field [0001] The invention belongs to the field of automated testing, and relates to an automated testing method for database business operations, in particular to an automatic result checking method for database business operations on a Windows platform. Background technique [0002] In the software industry, the increasingly large scale of products makes the workload of software functional testing more and more heavy, and there is an obvious disadvantage in this, that is, the cost of maintenance is getting higher and higher, and a large number of repetitive functional module tests, It consumes quite a lot of manpower and material resources, which restricts the subjective initiative and creativity of test engineers in their work. [0003] Automated testing is a method commonly chosen by software companies to solve high maintenance costs. At present, some companies have their own functional testing tools developed by themselves, and the test objects are targeted to...

AI Technical Summary

Problems solved by technology

These two methods can only operate on the database itself, but there is no return value. Even if it is a single-line command query operation, the query result is only reflected on the test target machine, but it cannot be used as a parameter value by the RF use case. Read, unable to verify the correctness of business operations

[0005] An existing method to check the results under RF is to use keywords encapsulated by the user. The advantage of this method is that it is easy to call in RF use cases. The disadvantage is that the implementation of keywords is very complicated, and the python programming ability of the test engineer is required. Very high, and keywords have almost no versatility, that is, different keywords need to be written for different types of databases

Images