CN114721958A - A kind of interface automatic testing method and terminal of multi-database system - Google Patents

Abstract

The invention discloses an interface automatic testing method and terminal for a multi-database system, obtaining a database list, the database list including databases and configuration information corresponding to the database; traversing the database list, and marking the traversed database as a target database, after connecting the target database according to the target configuration information corresponding to the target database, test the target database according to the preset rules; the present invention realizes the automatic switching of the database connection in the testing process, and does not need to manually switch the database. Full automation of interface testing, thereby improving the efficiency of interface testing.

Description

A kind of interface automatic testing method and terminal of multi-database system

technical field

The invention relates to the technical field of network security, in particular to an interface automatic testing method and terminal of a multi-database system.

Background technique

Interface testing is a type of testing that tests the interface between system components. Interface testing is mainly used to detect the interaction points between the external system and the system and between the various subsystems within the system. The main function is to check whether the returned result is the desired result by requesting the corresponding interface of the server or other modules.

The basic syntax of each database will be slightly different, and the writing methods of specific functions and variables are even more different. In most cases, the background of a system only needs to support one type of data (such as one of the following databases: SqlServer, Oracle, MySQL, DM) , Kingbase, etc.). However, in some systems, in order to meet the development needs, it is necessary to support multiple databases at the same time to meet the needs of more projects for databases. For example, project A needs SqlServer database; project B needs Oracle database, and project C needs MySQL database, but these projects need SqlServer database. They all want to use the same framework for development, so if a module in the framework needs to test functions such as adding, modifying, deleting, and querying, all databases need to be tested again. If there are a total of n databases, the workload of the test is increased by n times. However, the traditional interface automation test cannot realize the test of n kinds of databases in the same test task.

SUMMARY OF THE INVENTION

The technical problem to be solved by the present invention is to provide an interface automatic testing method and terminal of a multi-database system, which can improve the efficiency of database interface testing.

In order to solve the above-mentioned technical problems, a kind of technical scheme adopted in the present invention is:

A method for automatic testing of interfaces of a multi-database system, comprising the steps of:

obtaining a database list, where the database list includes a database and configuration information corresponding to the database;

The database list is traversed, the traversed database is marked as a target database, and after connecting to the target database according to the target configuration information corresponding to the target database, the target database is tested according to a preset rule.

In order to solve the above-mentioned technical problems, another technical scheme adopted by the present invention is:

An interface automation test terminal of a multi-database system, comprising a memory, a processor and a computer program stored on the memory and running on the processor, the processor implements the following steps when executing the computer program:

obtaining a database list, where the database list includes a database and configuration information corresponding to the database;

The database list is traversed, the traversed database is marked as a target database, and after connecting to the target database according to the target configuration information corresponding to the target database, the target database is tested according to a preset rule.

The beneficial effect of the present invention is that: the identification of the database to be tested and the configuration information corresponding to each database to be tested are recorded through the database list, and in the process of testing, by traversing the database list, the configuration information and the to-be-tested database are passed through the database list. The database establishes a connection to ensure the automatic connection with the database without missing the database, without the need to manually switch the database, realize the automatic switching of the database during the interface test process, realize the full automation of the interface test, thereby improving the efficiency of the interface test.

Description of drawings

Fig. 1 is the step flow chart of the interface automatic testing method of a kind of multi-database system according to the embodiment of the present invention;

FIG. 2 is a flowchart of another step of an interface automatic testing method of a multi-database system according to an embodiment of the present invention;

3 is a schematic structural diagram of an interface automated testing terminal of a multi-database system according to an embodiment of the present invention;

Label description:

1. An interface automatic test terminal of a multi-database system; 2. A processor; 3. A memory.

Detailed ways

In order to describe in detail the technical content, achieved objects and effects of the present invention, the following descriptions are given with reference to the embodiments and the accompanying drawings.

Please refer to FIG. 1 and FIG. 2 , an embodiment of the present invention provides an interface automated testing method for a multi-database system, including the steps:

obtaining a database list, where the database list includes a database and configuration information corresponding to the database;

The database list is traversed, the traversed database is marked as a target database, and after connecting to the target database according to the target configuration information corresponding to the target database, the target database is tested according to a preset rule.

As can be seen from the above description, the beneficial effects of the present invention are: the identification of the database to be tested and the configuration information corresponding to each database to be tested are recorded through the database list, and in the process of testing, by traversing the database list, through the configuration The information establishes a connection with the database to be tested to ensure that the database is automatically connected to the database without omitting the database. There is no need to manually switch the database. The automatic switching of the database is realized during the interface test process, and the full automation of the interface test is realized, thereby improving the Efficiency of interface testing.

Further, the preset rules include preset test data;

The preset test data for testing each of the target databases are the same.

As can be seen from the above description, by controlling the test to have the same preset test data of each target database, the test result can be predicted, so that the test result of the database can be better judged, and the test item corresponding to a certain database will not be omitted.

Further, the testing of the target database according to a preset rule includes:

Traversing the interfaces to be tested of the target database, marking the traversed interfaces to be tested as target interfaces to be tested, and testing the target interfaces to be tested according to the preset rules.

As can be seen from the above description, after the target database is automatically connected, the interface to be tested corresponding to the target database is also automatically tested according to preset rules, which further reduces the workload of personnel and improves the efficiency of interface testing.

Further, the configuration information includes connection string information.

As can be seen from the above description, the connection string information can ensure that the connection with the target database can be established smoothly in the process of automatic testing.

Further, after traversing the database list, the method further includes:

Generate and output test reports.

As can be seen from the above description, after traversing the database list, a test report is generated and output, and the report result is substantiated, which is convenient for testers to view and check accordingly.

Please refer to FIG. 2 , an interface automation test terminal of a multi-database system, including a memory, a processor, and a computer program stored in the memory and running on the processor, which is implemented when the processor executes the computer program. The following steps:

obtaining a database list, where the database list includes a database and configuration information corresponding to the database;

The database list is traversed, the traversed database is marked as a target database, and after connecting to the target database according to the target configuration information corresponding to the target database, the target database is tested according to a preset rule.

As can be seen from the above description, the beneficial effects of the present invention are: the identification of the database to be tested and the configuration information corresponding to each database to be tested are recorded through the database list, and in the process of testing, by traversing the database list, through the configuration information therein The information establishes a connection with the database to be tested to ensure automatic connection with the database without missing the database, without the need to manually switch the database, and realize the full automation of the interface test, thereby improving the efficiency of the interface test.

Further, the preset rules include preset test data;

The preset test data for testing each of the target databases are the same.

As can be seen from the above description, by controlling the test to have the same preset test data of each target database, the test result can be predicted, so that the test result of the database can be better judged, and the test item corresponding to a certain database will not be omitted.

Further, the testing of the target database according to a preset rule includes:

Traversing the interfaces to be tested of the target database, marking the traversed interfaces to be tested as target interfaces to be tested, and testing the target interfaces to be tested according to the preset rules.

As can be seen from the above description, after the target database is automatically connected, the interface to be tested corresponding to the target database is also automatically tested according to preset rules, which further reduces the workload of personnel and improves the efficiency of interface testing.

Further, the configuration information includes connection string information.

As can be seen from the above description, the connection string information can ensure that the connection with the target database can be established smoothly in the process of automatic testing.

Further, after traversing the database list, the method further includes:

Generate and output test reports.

As can be seen from the above description, after traversing the database list, a test report is generated and output, and the report result is substantiated, which is convenient for testers to view and check accordingly.

The above-mentioned interface automatic testing method of a multi-database system of the present invention can be applied to the test of a system that needs to be connected to a plurality of databases, and is described below by specific embodiments:

Example 1

Please refer to FIG. 1 and FIG. 2 , a method for automatic testing of interfaces of a multi-database system, comprising:

S1. Obtain a database list, where the database list includes a database and configuration information corresponding to the database;

In an optional implementation manner, the configuration information includes connection string information, and a connection can be established with the database according to the connection string information;

In an optional embodiment, the database list is stored in a preset database, and the system reads the database list by establishing a connection with the preset database, which is convenient for searching, updating, and modifying. The connection string information is directly configured on the connection, and the commonly used configuration files need to be connected to the corresponding deployed server, and the configuration file can be modified only after finding the configuration file; easy migration, the configuration file method will change with the location of the automated environment deployment, but not using the database. It is changed by the change of the deployment environment; it is easy to manage, and the database is used to store the connection string information to facilitate the unified display and view of the connection string information in all projects. For example, there are ten project connection string information. If it is a configuration file, it needs to be stored in ten In different configuration files, if you want to view ten files at the same time, you only need to open a certain table in the database;

S2, traversing the database list, marking the traversed database as a target database, and after connecting the target database according to the target configuration information corresponding to the target database, and testing the target database according to a preset rule;

In an optional implementation manner, by using pytest main.py-s--count=(the number of databases is the number of execution cycles) in the pytest framework; test the database;

Wherein, the testing of the target database according to the preset rule includes:

Traversing the interface to be tested of the target database, marking the traversed interface to be tested as the target interface to be tested, and testing the target interface to be tested according to the preset rule;

In an optional embodiment, the preset rules include preset test data, and the preset test data of each target database are the same; it is convenient to compare whether the test results of different databases are consistent with the preset results. If the result is inconsistent with the preset result, the test is regarded as a failure, and the storage space of the preset rules can be saved;

Please refer to FIG. 2, in an optional implementation manner, S2 specifically includes S21-S26:

S21, connect to the preset database, and read the database list from the preset database;

S22, determine whether there is a currently connected target database, if so, execute S23, otherwise, execute S24;

S23, determine whether the currently connected target database is the last database in the database list, if so, execute step S3, otherwise, acquire the next database corresponding to the currently connected target database as a new target database, and execute S25;

S24, if there is no currently connected target database, then obtain the first database in the database list as the target database;

S25, establishing a connection with the target database according to the configuration information in the database list; restarting the system, judging whether the system starts normally, if so, execute the described S26, otherwise keep the waiting state until the system starts normally and execute S26; automatically perform the database switching process in the process. Restart judgment to avoid exceptions during database switching;

S26, after testing the target database according to the preset rule, jump to S21;

S3. Generate and output a test report, and end the test.

…

Please refer to Fig. 3, the second embodiment of the present invention is:

An interface automation test terminal 1 of a multi-database system, comprising a processor 2, a memory 3 and a computer program stored in the memory 3 and running on the processor 2, when the processor 2 executes the computer program Implement each step in Embodiment 1.

…

To sum up, the present invention provides an interface automatic testing method and terminal for a multi-database system, by saving the database and the configuration information corresponding to the database, such as connection string information, to realize the automatic switching of the database connected to the system during the test process. , avoids the tedious manual switching, reduces labor costs and improves the efficiency of automatic interface testing; and the switching of connection strings is automatically performed, and the process is smoother; the invention realizes multiple databases to be tested together, such as the original four The database needs to be tested 1+1+1+1 times and generate 4 independent test reports. The present invention realizes one test of 4 databases and generates only 1 test report, and the content of the report will be divided according to the database type to avoid The repeated display of redundant parts is more concise; multiple reports are changed into one, which is more convenient to view the test report; the original scattered content is gathered together, which is more convenient to compare the differences of each database; at the same time, the database is tested. In the process, the same preset test data is used to facilitate the comparison of the final test results and make the test results predictable; in the whole process of system operation and maintenance, all databases need to be tested multiple times, and this test method only needs one maintenance. Continuous use reduces the overall operation and maintenance cost and improves the operation and maintenance efficiency.

The above descriptions are only examples of the present invention, and are not intended to limit the scope of the present invention. Any equivalent transformations made by using the contents of the description and drawings of the present invention, or directly or indirectly applied in related technical fields, are similarly included in the within the scope of patent protection of the present invention.

Claims (10)

1. an interface automation testing method of multiple database systems, is characterized in that, comprises the steps: obtaining a database list, where the database list includes a database and configuration information corresponding to the database; The database list is traversed, the traversed database is marked as a target database, and after connecting to the target database according to the target configuration information corresponding to the target database, the target database is tested according to a preset rule. 2. The interface automated testing method of a multi-database system according to claim 1, wherein the preset rule comprises preset test data; The preset test data for testing each of the target databases are the same. 3. The interface automated testing method of a multi-database system according to claim 1, wherein the testing the target database according to a preset rule comprises: Traversing the interfaces to be tested of the target database, marking the traversed interfaces to be tested as target interfaces to be tested, and testing the target interfaces to be tested according to the preset rules. 4 . The method for automatic testing of interfaces of a multi-database system according to claim 1 , wherein the configuration information includes connection string information. 5 . 5. The interface automated testing method of a multi-database system according to claim 1, wherein after the traversing the database list, the method further comprises: Generate and output test reports. 6. an interface automation test terminal of a multi-database system, comprising a memory, a processor and a computer program that is stored on the memory and can run on the processor, it is characterized in that, when the processor executes the computer program Implement the following steps: obtaining a database list, where the database list includes a database and configuration information corresponding to the database; The database list is traversed, the traversed database is marked as a target database, and after connecting to the target database according to the target configuration information corresponding to the target database, the target database is tested according to a preset rule. 7. The interface automatic test terminal of a multi-database system according to claim 6, wherein the preset rule comprises preset test data; The preset test data for testing each of the target databases are the same. 8. The interface automated testing terminal of a multi-database system according to claim 6, wherein the testing the target database according to a preset rule comprises: Traversing the interfaces to be tested of the target database, marking the traversed interfaces to be tested as target interfaces to be tested, and testing the target interfaces to be tested according to the preset rules. 9 . The interface automated testing terminal of a multi-database system according to claim 6 , wherein the configuration information includes connection string information. 10 . 10. The interface automated testing terminal of a multi-database system according to claim 6, wherein after the traversing the database list, the method further comprises: Generate and output test reports.

Images