Method for quickly generating database operation codes in automatic testing

Abstract

The invention discloses a method for quickly generating database operation codes in automatic testing, belongs to the technical field of computer program development, and aims to solve the problems of high code development cost and difficulty in later maintenance in bank interface automatic testing. The method comprises the following steps of: configuring an operation configuration mapping file code, a data access object file code and a data object file code of a data operation object and a database operation based on a MyBatis framework to generate a configuration file; in the configuration file, generating a code annotation of a data access object file code and a code annotation of a data object file code, and storing the operation configuration mapping file code, the data access object file code and the data object file code in different directories; according to the configuration file, database operation codes are generated, and the database operation codes comprise operation configuration mapping file codes, data access object file codes and data object file codes.

Description

technical field [0001] The invention relates to the technical field of computer program development, in particular to a method for rapidly generating database operation codes in automated testing. Background technique [0002] In the interface automation testing of traditional banks, for database access operations, testers mainly rely on testers to manually write functional codes, and then refer to the codes written by testers in specific interface test codes. Since the SQL statements used for database operations in this way are mainly embedded in the function code, the SQL statements for specific database operations will be coupled with the exposed database access, and the modification may be due to the modification of an SQL statement. The logic of the methods that lead to database access should also be modified. That is to say, the SQL statement and the operation object are not separated, which increases the difficulty of later maintenance of the interface automation tes...

AI Technical Summary

Problems solved by technology

Since the SQL statements used for database operations in this way are mainly embedded in the function code, the SQL statements for specific database operations will be coupled with the exposed database access, and the modification may be due to the modification of an SQL statement. The logic of the method that leads to database access should also be modified together

That is to say, the SQL statement and the operation object are not separated, which increases the difficulty of later maintenance of the interface automation test code and increases the maintenance cost

In addition, if the interface automation test code involves many interfaces, the test business project not only needs to operate a large number of database tables, but also requires the tester to write the database access and operation code, which increases the code development cost of the tester and leads to Automated test coding and management efficiency is greatly reduced

Images