WO2018202173A1

WO2018202173A1 - Method and system for database testing

Info

Publication number: WO2018202173A1
Application number: PCT/CN2018/085725
Authority: WO
Inventors: 李国文
Original assignee: 平安科技（深圳）有限公司
Priority date: 2017-05-05
Filing date: 2018-05-04
Publication date: 2018-11-08
Also published as: CN107885654A

Abstract

Disclosed are a method and system for database testing. The method comprises: creating a test architecture for a storage process or a function in a package of a database; setting an automated test script, calling the storage process or the function in the package of the database to perform a database package test; and running the automated test script to produce a test result. Thus implemented is automated testing of the package of the database.

Description

Database testing method and system

The present application claims priority to Chinese Patent Application No. JP-A No. No. No. No. No. No. No. No. No. No. Publication No.

Technical field

The present application relates to the field of database technologies, and in particular, to a database testing method and system.

Background technique

Most of the business logic of the traditional life insurance system is in the back-end Oracle database package, which uses stored procedures to handle the complex business logic of the system. The front page (web) is only for data display or downloading reports. In the background Oracle database package stored procedures, some can not be called in the foreground page or no interface display after the call, can not visually verify the results. Moreover, manually calling a stored procedure or function in an Oracle database can cost a lot of manpower and seriously affect the progress of the test.

Therefore, an automated Oracle database package test method is needed, and the test results can be seen quickly and intuitively.

Summary of the invention

In view of this, the purpose of the present application is to provide a database testing method and system to solve the problem of how to automatically perform package testing of an Oracle database.

To achieve the above objective, the present application provides a database testing method, the method comprising the steps of:

Establish a test architecture for stored procedures or functions in the package of the database;

Set up an automated test script, call the stored procedure or function in the package of the database for database package testing; and

Run the automated test script to get the test results.

To achieve the above object, the present application also provides a database testing system, the system comprising:

Establishing a module for establishing a test architecture for a stored procedure or function in a package of a database;

Setting a module for setting up an automated test script, calling a stored procedure or function in a package of the database for database package testing;

An execution module is configured to run the automated test script to obtain test results.

Preferably, the system further comprises:

Creating a module for creating a task on the Jenkins platform and setting relevant parameters of the task, wherein the task is used to execute the automated test script to perform the database package test;

The execution module is further configured to perform the task according to the set parameter to obtain the test result.

In addition, in order to achieve the above object, the present application further provides a computer readable storage medium, where the database readable storage medium stores a database testing system, and the database testing system includes:

The database testing method, system and computer readable storage medium proposed by the present application can build an underlying database testing architecture, use the prepareCall method of ISQLServerConnection to call the package of the background database, set the package automation test script, and then run the job through the job of the Jenkins platform. Automate test scripts and get database package test results to automate the testing of database packages and quickly and intuitively see test results.

DRAWINGS

1 is a flowchart of a database testing method according to a first embodiment of the present application;

2 is a flowchart of a database testing method according to a second embodiment of the present application;

3 is a flowchart of a database testing method according to a third embodiment of the present application;

4 is a schematic block diagram of a database testing system according to a fourth embodiment of the present application;

The object of the present application, the features and advantages of the present application will be further described with reference to the accompanying drawings.

detailed description

In order to make the technical problems, technical solutions and beneficial effects to be solved by the present application clearer and clearer, the present application will be further described in detail below with reference to the accompanying drawings and embodiments. It is understood that the specific embodiments described herein are merely illustrative of the application and are not intended to be limiting.

First embodiment

As shown in FIG. 1, the first embodiment of the present application provides a database testing method, which includes the following steps:

S100: Establish a test structure of a stored procedure or a function in a package of an Oracle database.

Oracle Database System is a set of software products based on distributed database provided by Oracle Corporation (Oracle). Specifically, the Oracle database application environment is set up, and the test architecture of the stored procedure or function in the package of the Oracle database is established according to the system architecture of the specific application environment. The specific topology is as close as possible to the actual application.

S102, setting an automated test script, calling a stored procedure or function in the package of the backstage Oracle database for database testing.

Specifically, an automated test script is set up, and the stored procedure or function in the package of the back-end Oracle database is invoked by using the prepareCall method of ISQLServerConnection in Java. The prepareCall method invokes a database stored procedure by creating a CallableStatement object. The CallableStatement object provides methods for setting its IN and OUT parameters, as well as methods for executing the stored procedure.

S104. Run the automated test script to obtain test results.

Specifically, the automated test script may be directly run after the automatic test script is set to obtain the test result; or the running time of the automated test script and the running test environment address may be set first, and then set according to the set The runtime runs the automated test script in the set test environment address to obtain the test results.

The database testing method proposed in this embodiment can build an underlying database testing architecture, use the prepareCall method of ISQLServerConnection to call the package of the background database, set the package automation test script, and then run the automated test script to obtain the database package test result. This enables automated testing of database packages and quick and intuitive viewing of test results.

Second embodiment

As shown in FIG. 2, the second embodiment of the present application provides a database testing method. In the second embodiment, the steps of the database testing method are similar to those of the first embodiment, the main difference being that step S204 is added to the first embodiment. The method specifically includes the following steps:

S200: Establish a test structure of a stored procedure or a function in a package of an Oracle database.

Specifically, the Oracle database application environment is set up, and the test architecture of the stored procedure or function in the package of the Oracle database is established according to the system architecture of the specific application environment. The specific topology is as close as possible to the actual application.

S202, setting an automated test script, calling a stored procedure or function in the package of the backstage Oracle database for database testing.

S204. Create a job on the Jenkins platform to run the automated test script and set related parameters of the job.

Jenkins is an open source software project, a continuous integration tool developed in Java to monitor continuous repetitive work. Specifically, the Jenkins platform is used to monitor ongoing software test projects and external call execution. The job is used to execute the automated test script and perform a database package test. Creating the job on the Jenkins platform and executing the job can automatically monitor the ongoing database package test and automatically obtain the database package test results.

The parameters may include: (1) setting an execution time of the job and a running time of the automated test script; and (2) setting a test environment address at which the automated test script runs.

S206. Execute the job according to the set parameter, and obtain a test result.

Specifically, executing the job according to the set execution time, acquiring the automated test script, and running the automated test script in the set test environment address according to the set running time, thereby obtaining the test result.

The database testing method proposed in this embodiment can build an underlying database testing architecture, use the prepareCall method of ISQLServerConnection to call the package of the background database, set the package automation test script, and then run the automated test script through the job of the Jenkins platform to automatically monitor Continuous database package testing, get database package test results, to achieve automated testing of the database package, and can quickly and intuitively see the test results.

Third embodiment

As shown in FIG. 3, the third embodiment of the present application provides a database testing method. In the third embodiment, the steps of the database testing method are similar to those of the second embodiment, the main difference being that step S303 and step S308 are added on the basis of the second embodiment. The method specifically includes the following steps:

S300: Establish a test structure of a stored procedure or function in a package of an Oracle database.

S302, setting an automated test script, calling a stored procedure or function in the package of the backstage Oracle database for database testing.

S303. Submit the automated test script to the SVN version management tool.

SVN is short for Subversion and is an open source version control system. Specifically, the SVN version management tool is configured to perform version management on the automated test script to modify and update the automated test script at any time.

S304. Create a job on the Jenkins platform to run the automated test script and set related parameters of the job.

Specifically, the Jenkins platform is used to monitor ongoing software test projects and external call execution. The job is used to execute the automated test script and perform a database package test. Creating the job on the Jenkins platform and executing the job can automatically monitor the ongoing database package test and automatically obtain the database package test results.

The parameters may include: (1) downloading an SVN version management tool address of the automated test script; (2) setting an execution time of the job and a running time of the automated test script; and (3) setting an automated test script to run Test environment address.

S306. Execute the job according to the set parameter, and obtain a test result.

Specifically, the job is executed according to the set execution time, the automated test script is downloaded from the SVN version management tool address, and the automated test script is run in the set test environment address according to the set running time. Thereby the test result is obtained.

S308, the test result is sent to the tester.

Specifically, after the execution of the job is completed, an automated database package test result can be directly obtained, a result report is formed according to the test result, and the result report is sent to the tester by mail.

The database testing method proposed in this embodiment can build an underlying database testing architecture, use the prepareCall method of ISQLServerConnection to call the package of the background database, set the package automation test script, and then run the automated test script through the job of the Jenkins platform to obtain the database. Package test results, thus automated testing of the database package, and can quickly and intuitively see the test results. In addition, the automated test script is submitted to the SVN version management tool, and the automated test script can be version-managed to modify and update the automated test script at any time.

Fourth embodiment

As shown in FIG. 4, a fourth embodiment of the present application provides a database testing system 40.

In the present embodiment, the database testing system 40 includes an establishing module 400, a setting module 402, and an executing module 406.

The establishing module 400 is configured to establish a test structure of a stored procedure or a function in a package of an Oracle database.

Specifically, the establishing module 400 constructs an Oracle database application environment, and establishes a test architecture of a stored procedure or a function in a package of the corresponding Oracle database for the system architecture of the specific application environment. The specific topology is as close as possible to the actual application.

The setting module 402 is configured to set an automated test script, and invoke a stored procedure or function in a package of the backstage Oracle database to perform database testing.

The execution module 406 is configured to run the automated test script to obtain test results.

Specifically, the execution module 406 can directly run the automated test script after setting the automated test script to obtain the test result. The execution module 406 may also first set the running time of the automated test script and the running test environment address, and then run the automated test script in the set test environment address according to the set running time, thereby obtaining the test result.

Further, the database testing system 40 may further include:

A creation module 404 is configured to create a job on the Jenkins platform to run the automated test script and set relevant parameters of the job.

In this case, the execution module 406 is further configured to execute the job according to the set parameters to obtain a test result.

Further, the database testing system 40 may further include:

The submitting module 403 is configured to submit the automated test script to the SVN version management tool.

Specifically, the SVN version management tool is configured to perform version management on the automated test script to modify and update the automated test script at any time. In this case, when the creating module 404 sets the related parameters of the job, it is also required to set an SVN version management tool address for downloading the automated test script. When the execution module 406 executes the job according to the set execution time, the automatic test script needs to be downloaded from the SVN version management tool address.

The sending module 408 is configured to send the obtained test result to the tester.

The serial numbers of the embodiments of the present application are merely for the description, and do not represent the advantages and disadvantages of the embodiments.

It is to be understood that the term "comprises", "comprising", or any other variants thereof, is intended to encompass a non-exclusive inclusion, such that a process, method, article, or device comprising a series of elements includes those elements. It also includes other elements that are not explicitly listed, or elements that are inherent to such a process, method, article, or device. An element that is defined by the phrase "comprising a ..." does not exclude the presence of additional equivalent elements in the process, method, item, or device that comprises the element.

Through the description of the above embodiments, those skilled in the art can clearly understand that the foregoing embodiment method can be implemented by means of software plus a necessary general hardware platform, and can also be implemented by hardware, but in many cases, the former is A better implementation. Based on such understanding, the technical solution of the present application, which is essential or contributes to the prior art, may be embodied in the form of a software product stored in a storage medium (such as ROM/RAM, disk, The optical disc includes a number of instructions for causing a terminal device (which may be a mobile phone, a computer, a server, an air conditioner, or a network device, etc.) to perform the methods described in various embodiments of the present application.

The preferred embodiments of the present application have been described above with reference to the drawings, and are not intended to limit the scope of the application. The serial numbers of the embodiments of the present application are merely for the description, and do not represent the advantages and disadvantages of the embodiments. Additionally, although logical sequences are shown in the flowcharts, in some cases the steps shown or described may be performed in a different order than the ones described herein.

A person skilled in the art can implement the present application in various variants without departing from the scope and spirit of the present application. For example, the features as one embodiment can be used in another embodiment to obtain another embodiment. Any modifications, equivalent substitutions and improvements made within the technical concept of the application should be within the scope of the application.

Claims

A database testing method, characterized in that the method comprises the steps of:

Establish a test architecture for stored procedures or functions in the package of the database;

Set up an automated test script, call the stored procedure or function in the package of the database for database package testing; and

Run the automated test script to get the test results.
The database testing method according to claim 1, further comprising the steps of:

Creating a task on the Jenkins platform and setting relevant parameters of the task, wherein the task is used to execute the automated test script to perform the database package test;

The task is performed according to the set parameters, and the test result is obtained.
The database testing method according to claim 2, wherein the method further comprises the steps of:

Submit the automated test script to the SVN version management tool.
The database testing method according to claim 3, wherein the parameter comprises: an SVN version management tool address for downloading the automated test script; an execution time of the task and a running time of the automated test script; The test environment address where the automated test script runs.
The database testing method according to claim 4, wherein the step of performing the task according to the set parameter, and the step of obtaining the test result specifically includes:

Performing the task according to the set execution time;

Downloading the automated test script from the SVN version management tool address; and

The automated test script is run in the set test environment address according to the set running time to obtain the test result.
The database testing method according to claim 1, wherein the stored procedure or function in the package of the database is invoked by using the prepareCall method of ISQLServerConnection in Java.
The database testing method according to any one of claims 2 to 5, characterized in that the stored procedure or function in the package of the database is called by using the prepareCall method of ISQLServerConnection in Java.
A database testing system, characterized in that the system comprises:

Establishing a module for establishing a test architecture for a stored procedure or function in a package of a database;

Setting a module for setting up an automated test script, calling a stored procedure or function in a package of the database for database package testing;

An execution module is configured to run the automated test script to obtain test results.
The database testing system according to claim 8, wherein the system further comprises:

Creating a module for creating a task on the Jenkins platform and setting relevant parameters of the task, wherein the task is used to execute the automated test script to perform the database package test;

The execution module is further configured to perform the task according to the set parameter to obtain the test result.
The database testing system according to claim 9, wherein the system further comprises:

A submission module for submitting the automated test script to the SVN version management tool.
The database testing system according to claim 10, wherein the parameter comprises: an SVN version management tool address for downloading the automated test script; an execution time of the task and a running time of the automated test script; The test environment address where the automated test script runs.
The database testing system according to claim 11, wherein the execution module executes the task according to the set execution time; downloads the automated test script from the SVN version management tool address; and according to the setting The running time runs the automated test script in the set test environment address to obtain the test result.
The database testing system according to claim 8, wherein the setting module uses a prepareCall method of ISQLServerConnection in Java to call a stored procedure or function in a package of the database.
The database testing system according to any one of claims 9 to 12, wherein the setting module uses a prepareCall method of ISQLServerConnection in Java to call a stored procedure or function in a package of the database.
A computer readable storage medium, wherein the computer readable storage medium stores a database testing system, wherein the database testing system comprises:

Establishing a module for establishing a test architecture for a stored procedure or function in a package of a database;

Setting a module for setting up an automated test script, calling a stored procedure or function in a package of the database for database package testing;

An execution module is configured to run the automated test script to obtain test results.
The computer readable storage medium according to claim 15, wherein the database test system further comprises:

Creating a module for creating a task on the Jenkins platform and setting relevant parameters of the task, wherein the task is used to execute the automated test script to perform the database package test;

The execution module is further configured to perform the task according to the set parameter to obtain the test result.
The computer readable storage medium according to claim 16, wherein the database testing system further comprises:

A submission module for submitting the automated test script to the SVN version management tool.
The computer readable storage medium according to claim 17, wherein the parameter comprises: an SVN version management tool address for downloading the automated test script; an execution time of the task and a run time of the automated test script The test environment address at which the automated test script runs.
The computer readable storage medium according to claim 16, wherein said execution module executes said task according to said set execution time; downloads said automated test script from said SVN version management tool address; The set running time runs the automated test script in the set test environment address to obtain the test result.
The computer readable storage medium according to any one of claims 15 to 18, wherein the setting module uses a prepareCall method of ISQLServerConnection in Java to call a stored procedure or function in a package of the database.