CN113392024A

CN113392024A - Method, device, equipment and medium for testing storage process

Info

Publication number: CN113392024A
Application number: CN202110759332.8A
Authority: CN
Inventors: 万茂江; 陈灿; 张楠; 李冬宝
Original assignee: Industrial and Commercial Bank of China Ltd ICBC
Current assignee: Industrial and Commercial Bank of China Ltd ICBC
Priority date: 2021-07-02
Filing date: 2021-07-02
Publication date: 2021-09-14
Anticipated expiration: 2041-07-02
Also published as: CN113392024B

Abstract

The present disclosure provides a method for testing a stored procedure, which can be used in the financial field or other fields. The method comprises the following steps: acquiring a parameter sequence of a tested target storage process, wherein the parameter sequence comprises an input parameter sequence; inputting M test cases based on first user operation, wherein each parameter value of the input parameter sequence is specified in each test case based on the first user operation, and M is an integer greater than 1; reading the M test cases into a memory at one time; and carrying out automatic test on the target storage process by using the M test cases. The present disclosure also provides a test apparatus, an electronic device, a computer-readable storage medium, and a computer program storing a process.

Description

Method, device, equipment and medium for testing storage process

Technical Field

The present disclosure relates to the field of computer technology, and more particularly, to a method, an apparatus, a device, and a medium for testing a storage process.

Background

The storage process is a group of SQL statement sets for completing specific functions in the database system, and is stored in the database, and one-time compiling is permanently effective. The user can execute the stored procedure by specifying the stored name of the stored procedure and giving parameters. In the related art, when testing a stored procedure, a user usually writes a test script by himself or performs a test using a unit test tool in the business software PL/SQL Developer.

In the course of implementing the disclosed concept, the inventors found that there are at least the following problems in the prior art: in the related art, only one test case can be tested each time when the storage process is tested. When the test cases are very many, the test cases are required to be tested one by one, which is very troublesome and inefficient.

Disclosure of Invention

In view of this, the embodiments of the present disclosure provide a method, an apparatus, a device, a medium, and a computer program for testing a storage process that can perform automatic testing using batch test cases.

In a first aspect of the embodiments of the present disclosure, a method for testing a storage process is provided. The test method comprises the following steps: acquiring a parameter sequence of a tested target storage process, wherein the parameter sequence comprises an input parameter sequence; inputting M test cases based on first user operation, wherein each parameter value of the input parameter sequence is specified in each test case based on the first user operation, and M is an integer greater than 1; reading the M test cases into a memory at one time; and carrying out automatic test on the target storage process by using the M test cases.

According to an embodiment of the present disclosure, the entering of M test cases based on the first user operation includes: providing a test case list interface to display the parameter sequence; and inputting M test cases in the test case list interface based on the first user operation.

According to the embodiment of the disclosure, the test case list interface is a list interface based on VBA; the step of reading the M test cases into the memory at one time includes: and reading the whole data in the test case list interface containing M test cases into a memory by using a Range object of the VBA.

According to an embodiment of the present disclosure, the entering of M test cases based on the first user operation includes: and marking the test cases for testing from the M test cases based on the second user operation. The automatic testing of the target storage process by using the M test cases comprises the following steps: and automatically testing the target storage process by using the marked test case.

According to an embodiment of the present disclosure, the obtaining a parameter sequence of a target storage process to be tested includes: providing a test program selection interface; receiving a third user operation of a user in the test program selection interface, wherein the third user operation is used for specifying a program name of a tested target storage process and inputting login parameter information for connecting and logging in a database system, and the target storage process is a storage process in the database system; responding to a fourth user operation for connecting a database, and transmitting the program name of the target storage process and the login parameter information into the database system; after logging in the database system based on the login parameter information, querying the parameter sequence from the database system based on the program name of the target stored process.

According to an embodiment of the present disclosure, the querying the parameter sequence from the database system based on the program name of the target stored procedure includes: querying the parameter sequence of the target stored procedure from a dictionary table for storing various types of stored procedures; and generating a test case list interface based on the inquired parameter sequence.

According to an embodiment of the present disclosure, the performing an automated test on the target storage process by using the M test cases includes: obtaining a parameter string based on the combination of parameter values of all parameters in the parameter sequence in the test case; transmitting the parameter string to a database system, wherein the target storage process is a storage process in the database system; matching and assigning parameter values of each input parameter in the parameter string to each input parameter in the input parameter sequence of the target storage process in the database system to obtain a dynamic assembly SQL statement; and executing the dynamic assembly SQL statement in the database system to obtain a test result.

According to an embodiment of the present disclosure, the parameter sequence further includes an output parameter sequence, and obtaining a parameter string based on a combination of parameter values of all parameters in the parameter sequence in the test case includes: combining all parameter values of the input parameter sequence into a character string according to a predefined format to obtain a parameter string; combining all parameter values of the output parameter sequence into a character string according to a predefined format to obtain a parameter string; and splicing the parameter input string and the parameter output string into the parameter string through a predefined separator.

According to an embodiment of the present disclosure, the performing an automated test on the target storage process by using the M test cases further includes: matching parameter values of all parameters in the test result to all parameters of the parameter string; after parameter values of all the parameters of the parameter strings are matched, the parameter strings are transmitted to a user interaction interface through the database system; and displaying parameter values of each parameter in the output parameter sequence in the test result in the user interaction interface.

According to an embodiment of the present disclosure, the target storage process is a storage process in an Oracle database system, wherein the Oracle database system receives and transmits the parameter string using a common storage process.

According to an embodiment of the present disclosure, the obtaining of the dynamic assembly SQL statement includes: detecting the target storage process and the parameter sequence thereof in the database system by utilizing the detection storage process of the Oracle database system; after the target storage process and the parameter sequence thereof are detected, decomposing the parameter input string and the parameter output string in the parameter string; and matching the decomposed parameter input strings to each parameter input of the target storage process according to the input parameter sequence.

In a second aspect of the disclosed embodiments, a device for testing a stored procedure is provided. The testing device comprises an acquisition module, a recording module, a reading module and a testing module. The acquisition module is used for acquiring a parameter sequence of a tested target storage process, wherein the parameter sequence comprises an input parameter sequence. The entry module is used for entering M test cases based on first user operation, wherein each entered parameter value in the input parameter sequence is specified in each test case based on the first user operation, and M is an integer greater than 1. The reading module is used for reading the M test cases into the memory at one time. And the test module is used for carrying out automatic test on the target storage process by utilizing the M test cases.

According to the embodiment of the disclosure, the entry module is used for providing a test case list interface to display the parameter sequence; and inputting M test cases in the test case list interface based on the first user operation.

According to the embodiment of the disclosure, the test case list interface is a list interface based on VBA. The reading module is used for reading the whole block of data in the test case list interface containing M test cases into a memory by using a Range object of the VBA.

According to an embodiment of the present disclosure, the obtaining module is further configured to: providing a test program selection interface; receiving a third user operation of a user in the test program selection interface, wherein the third user operation is used for specifying a program name of a tested target storage process and inputting login parameter information for connecting and logging in a database system, and the target storage process is a storage process in the database system; responding to a fourth user operation for connecting a database, and transmitting the program name of the target storage process and the login parameter information into the database system; after logging in the database system based on the login parameter information, querying the parameter sequence from the database system based on the program name of the target stored process.

According to an embodiment of the present disclosure, the test module includes a parameter combination sub-module, a parameter transmission sub-module, a parameter matching sub-module, and a statement execution sub-module. The parameter combination submodule is used for obtaining a parameter string based on the combination of the parameter values of all the parameters in the parameter sequence in the test case. The parameter transmission submodule is used for transmitting the parameter string to a database system, wherein the target storage process is a storage process in the database system. And the parameter matching sub-module is used for matching and assigning the parameter values of all the entries in the parameter string to all the entries in the input parameter sequence of the target storage process in the database system to obtain the dynamic assembly SQL statement. The statement execution submodule is used for executing the dynamic assembly SQL statement in the database system to obtain a test result.

According to an embodiment of the present disclosure, the parameter sequence further comprises an output parameter sequence. The parameter combination sub-module is used for: combining all parameter values of the input parameter sequence into a character string according to a predefined format to obtain a parameter string; combining all parameter values of the output parameter sequence into a character string according to a predefined format to obtain a parameter string; and splicing the parameter input string and the parameter output string into the parameter string through a predefined separator.

According to an embodiment of the present disclosure, the test module further includes a result output sub-module. The result output submodule is used for: matching parameter values of all parameters in the test result to all parameters of the parameter string; after parameter values of all the parameters of the parameter strings are matched, the parameter strings are transmitted to a user interaction interface through the database system; and displaying parameter values of each parameter in the output parameter sequence in the test result in the user interaction interface.

In a third aspect of the disclosed embodiments, an electronic device is provided. The electronic device includes one or more memories, and one or more processors. The memory stores executable instructions. The processor executes the executable instructions to implement the method as described above.

In a fourth aspect of the embodiments of the present disclosure, a computer-readable storage medium is provided, storing computer-executable instructions, which when executed, implement the method as described above.

In a fifth aspect of embodiments of the present disclosure, there is provided a computer program comprising computer executable instructions for implementing the method as described above when executed.

One or more of the above-described embodiments may provide the following advantages or benefits: the problem that the testing efficiency of the storage process in the related technology is low can be at least partially solved, and the storage process is automatically tested through batch test cases, so that the workload of testers is greatly reduced and the testing efficiency is improved under the condition of a large number of test cases.

Drawings

The above and other objects, features and advantages of the present disclosure will become more apparent from the following description of embodiments of the present disclosure with reference to the accompanying drawings, in which:

FIG. 1 schematically illustrates a system architecture of a method, apparatus, device, medium, and program product for testing a stored procedure according to embodiments of the disclosure;

FIG. 2 schematically shows a connection schematic between a front user interaction interface and a back-end database in a testing method of a stored procedure according to an embodiment of the present disclosure;

FIG. 3 schematically illustrates a flow chart of a method of testing a stored procedure according to an embodiment of the present disclosure;

FIG. 4 schematically illustrates a test program selection interface according to an embodiment of the present disclosure;

FIG. 5 schematically illustrates a test case list interface according to an embodiment of the present disclosure;

FIG. 6 schematically illustrates a flow diagram of automated testing in a method of testing a stored procedure according to an embodiment of the present disclosure;

FIG. 7 schematically illustrates a schematic diagram of automated testing in a testing method of a stored procedure according to an embodiment of the present disclosure;

FIG. 8 schematically illustrates a flow chart of a method of testing a stored procedure according to another embodiment of the present disclosure;

FIG. 9 schematically illustrates a block diagram of a test apparatus storing a process according to an embodiment of the disclosure;

FIG. 10 schematically illustrates a block diagram of a test module in a test apparatus storing a process according to an embodiment of the present disclosure; and

FIG. 11 schematically illustrates a block diagram of an electronic device suitable for implementing a testing method of a stored procedure in accordance with an embodiment of the disclosure.

Detailed Description

Hereinafter, embodiments of the present disclosure will be described with reference to the accompanying drawings. It should be understood that the description is illustrative only and is not intended to limit the scope of the present disclosure. In the following detailed description, for purposes of explanation, numerous specific details are set forth in order to provide a thorough understanding of the embodiments of the disclosure. It may be evident, however, that one or more embodiments may be practiced without these specific details. Moreover, in the following description, descriptions of well-known structures and techniques are omitted so as to not unnecessarily obscure the concepts of the present disclosure.

In this document, it is to be understood that any number of elements in the specification and drawings is to be considered exemplary rather than limiting, and that any nomenclature (e.g., first, second) is used for distinction only, and not in any limiting sense.

Embodiments of the present disclosure provide a method, apparatus, device, medium, and computer program for testing a storage process. The method comprises the steps of firstly, acquiring a parameter sequence of a tested target storage process, wherein the parameter sequence comprises an input parameter sequence; then inputting M test cases based on first user operation, wherein each parameter value of the input parameter sequence is specified in each test case based on the first user operation, and M is an integer larger than 1; next, reading the M test cases into the memory at one time; and then, carrying out automatic test on the target storage process by using the M test cases. In this way, the storage process can be automatically tested by using the batch test cases, and the test efficiency of the storage process is improved.

It should be noted that the method, apparatus, device, medium, and computer program for testing a storage process determined in the embodiments of the present disclosure may be used in the financial field, and may also be used in any field other than the financial field.

In the technical scheme of the disclosure, the acquisition, storage, application and the like of the personal information of the related user all accord with the regulations of related laws and regulations, necessary security measures are taken, and the customs of the public order is not violated.

Fig. 1 schematically illustrates a system architecture 100 of a method, apparatus, device, medium, and program product for testing a stored procedure according to embodiments of the disclosure. It should be noted that fig. 1 is only an example of a system architecture to which the embodiments of the present disclosure may be applied to help those skilled in the art understand the technical content of the present disclosure, and does not mean that the embodiments of the present disclosure may not be applied to other devices, systems, environments or scenarios.

As shown in fig. 1, a system architecture 100 according to this embodiment may include a terminal device 101, a network 102, and a database server 103. Network 102 is used to provide a communication link between terminal device 101 and database server 103. Network 102 may include various connection types, such as wired, wireless communication links, or fiber optic cables, to name a few.

A user may use terminal device 101 to interact with database server 103 over network 102 to receive or send messages and the like. The terminal device 101 may be various electronic devices having a display screen including, but not limited to, a smart phone, a tablet computer, a laptop portable computer, a desktop computer, and the like.

Database server 103 may be any type of database server, such as an oracle database server, a MySQL database server, a DB2 database server, and the like.

The terminal device 101 may provide a user interaction interface. The user can specify a process name of a target stored procedure to be tested, enter one or more test cases, and send a test instruction to the database server 103 by an operation in the user interaction interface in the terminal apparatus 101. After receiving the test instruction, the database server 103 may perform a batch test operation on the test cases, feed back the test result to the terminal device 101, and display the test result to the user through the user interface.

The user interaction interface may be any program interface for user interaction. For example, in one embodiment, the user interaction interface may be a Java interface. Still alternatively, in one embodiment, the user interaction interface may be an Excel interface written in VBA (Visual Basic for Applications). Since the use of Excel is common, the user interaction interface displayed in the form of Excel is very convenient to use.

Fig. 2 schematically shows a connection schematic between a front user interaction interface and a back-end database in a testing method of a stored procedure according to an embodiment of the present disclosure. In the embodiment, the user interaction interface is an interface displayed in an Excel form.

With reference to fig. 1 and fig. 2, the front-end Excel interface is shown in the terminal device 101, and the database of the back end is managed by the database server 103. The Excel interface can be connected to a database through JDBC (Java database connectivity). Therefore, a user can test the stored procedures in the database through the operation in the Excel interface.

It should be understood that the number and types of terminal devices, networks, and servers in fig. 1 are merely illustrative. There may be any number of terminal devices, networks, and servers, as desired for implementation.

The system architecture described below in conjunction with fig. 1 and 2 will be described in detail with reference to fig. 3-6 for a method of testing a stored procedure of the disclosed embodiments.

FIG. 3 schematically shows a flow chart of a method of testing a stored procedure according to an embodiment of the disclosure.

As shown in fig. 3, the method includes operations S310 to S340.

First, in operation S310, a parameter sequence of a target storage process to be tested is obtained, where the parameter sequence includes an input parameter sequence. In one embodiment, the parameter sequence of each stored procedure to be tested may be preset in the database server 103 or in the user side of the terminal device 101, and when a target stored procedure is selected, the parameter sequence of the target stored procedure is called out. In another embodiment, the parameter sequence of the target stored procedure may be queried from a database by the program name of the target stored procedure.

Because a user is usually required to specify input parameters in the process of writing the test case, and then output parameters are obtained according to the test result, in some embodiments, the parameter sequence may only include the input parameter sequence, so that writing of the test case can be realized. In other embodiments, the parameter sequence may further include an output parameter sequence, and the output parameter sequence may define a format, an order, and the like of parameters output by the test result, so as to facilitate uniform processing of the test result.

Then, in operation S320, M test cases are entered based on the first user operation, where in each test case, a parameter value of each entry parameter in the input parameter sequence is specified based on the first user operation, where M is an integer greater than 1. For example, the user may form a test case by specifying the value of each entry parameter in the user interaction interface of the terminal device 101 according to the input parameter sequence. Wherein, different test cases can be recorded by making at least one parameter value in the input parameter sequence different. In some embodiments, the M test cases may also be imported from other files into the user interaction interface of the terminal device.

Next, in operation S330, the M test cases are read into the memory at a time. In this way, a plurality of test cases can be read in a batch manner, and the database server 103 at the back end can process a plurality of test cases in a batch manner.

Thereafter, in operation S340, the target storage process is automatically tested using the M test cases.

In some embodiments, each of the M test cases may be tested in turn, and the test result may be returned to the terminal device 101.

In some embodiments, only a portion of the M test cases may be utilized for testing. For example, an upper limit of the number of test cases for each batch test may be preset, and when the number of M test cases is greater than the upper limit, only some test cases within the upper limit may be tested.

For another example, when M test cases are entered, the test cases that need to be tested may be marked according to the requirement of the user, so that the target storage process may be automatically tested only by using the marked test cases in operation S340. Therefore, for example, after a user locally modifies some test cases in the M test cases, the test can be performed only on the locally modified part by marking the locally modified test cases without performing other modifications.

According to the embodiment of the disclosure, a plurality of test cases can be utilized to automatically test the target test process, so that the workload of testers is greatly reduced and the test efficiency is improved under the condition of a large number of test cases.

FIG. 4 schematically illustrates a test program selection interface 401 according to an embodiment of the present disclosure.

In conjunction with fig. 3 and 4, according to this embodiment, the user may query the parameter sequence of the target stored procedure from the database through the program name of the target stored procedure in operation S310.

Specifically, as in the example of fig. 4, a test program selection interface 401 may be first provided to a user in the terminal device 101, where the test program selection interface 401 is a page in a user interaction interface presented in the terminal device 101. Then, a third user operation of the user in the test program selection interface 401 is received, the third user operation being used for specifying the program name of the target stored procedure to be tested and entering login parameter information for connecting and logging in the database system. For example, the user may fill in or select the program name of the target stored procedure in entry box 402 and fill in form 403 the user name, password, IP address and port of the backend database to connect to, instance name information to test.

Next, in response to a fourth user operation for connecting the database, the program name and login parameter information of the target stored procedure are transferred to the database system. For example, the user may operate the generate button 404 in the test program selection interface 401 to transfer the program name and login parameter information of the target stored procedure into the database in the backend.

Then, after the program name and the login parameter information of the target storage process are transmitted to a database at the back end, the program name and the login parameter information can be logged in the database system based on the login parameter information, and then the parameter sequence is inquired from the database system based on the program name of the target storage process. When the parameter sequence is specifically queried, the parameter sequence of the target storage process can be queried from a dictionary table for storing various types of storage processes. For example, taking an oracle database as an example, the background implementation logic after the user triggers the instruction of the generate button 404 may be: firstly, reading login parameter information of an oracle database in a table 403 on a test program selection interface 401, then connecting the login parameter information to the database through JDBC, then searching a dictionary table DBA _ ARGUMENTS through a program name of a target storage process recorded in a recording frame 402 to obtain a reference name, a parameter serial number and a parameter type of the target storage process, feeding back the reference name, the parameter serial number and the parameter type to the terminal device 101, and displaying the reference name, the parameter serial number and the parameter type to a user through a test case list interface 501 shown in FIG. 5.

FIG. 5 schematically illustrates a test case list interface 501 according to an embodiment of the disclosure.

With reference to fig. 3 and 5, according to the embodiment of the present disclosure, a parameter sequence may be formed by information, such as a reference name, a parameter serial number, and a parameter type, of a target storage process acquired from a backend database, and displayed in a final test sample list interface 501. The test case list interface 501 is a page of the front-end user interaction interface, and is displayed in the terminal device 101. After the parameter sequence is presented, the user may enter information of each test case in the test case list interface 501. For example, in fig. 5, the user enters values of respective input parameters into respective columns of a case1, a case2, a case3, and the like of the test case list interface 501, where each case corresponds to a test case. In this way, multiple test cases may be obtained. Furthermore, the test cases needing to be tested and the test cases not needing to be tested can be marked through symbols. For example, in fig. 5, a test case requiring a test is indicated by "o", and a test case not requiring a test is indicated by "x".

Under the condition that the test case list interface 501 is an Excel interface based on VBA, after a plurality of test cases shown in fig. 5 are obtained, and after the user clicks the test button 502, the whole block of data in the test case list interface including M test cases entered by the user can be read into the memory by using the Range object of the VBA. For example, the cells [ a 5: i27 ] reading the whole block data into the memory through the Range object. Therefore, the plurality of test cases can be read at one time, so that the back-end database can perform batch processing operation on the plurality of test cases.

The cells E5, F5, G5. on the test case list interface 501 are check items of test cases, a circle represents a test case to be tested, and a circle represents a test case not to be tested, so that a user can write any number of or any kind of test cases at will to store the test cases, and flexibly select the test cases during testing.

Fig. 6 schematically shows a flowchart of the automated testing of operation S340 in the testing method of the stored procedure according to an embodiment of the present disclosure.

As shown in fig. 6, the automated test procedure in operation S340 may include operations S601-S604 according to some embodiments of the present disclosure. According to other embodiments of the present disclosure, after operation S604, operations S605 to S607 may be further included.

First, in operation S601, a parameter string is obtained based on a combination of parameter values of all parameters in the parameter sequence in each test case.

In some embodiments, as in the example of fig. 5, the parameter sequence includes an input parameter sequence and an output parameter sequence, so that the parameter string obtaining process in operation S601 may be: combining all parameter values of input parameters of the input parameter sequence into a character string according to a predefined format to obtain an input parameter string, combining all parameter values of output parameters of the output parameter sequence into a character string according to a predefined format to obtain an output parameter string, and splicing the input parameter string and the output parameter string into a parameter string through predefined separators.

Specifically, taking the case1 in fig. 5 as an example, the parameter values of all the input parameters in the case1 may be combined, for example, one parameter value is used as a field, different fields are separated by a single quotation mark, and then the parameter values are sequentially combined together according to the sequence of the parameter numbers to form the input parameter string. Accordingly, the parameter values of all the output parameters in case1 can be combined in a similar manner to form a parameter string (in this case, the parameter is two null values). The in-and out-parameter strings may then be concatenated together to form a parameter string using a predefined separator between the in-and out-parameter strings (e.g., $ | $, just an example).

The parameter string is then transmitted to the database system in operation S602. For example, for an Oracle system, the common storage process PKG _ Test of the Oracle system may be invoked to receive the parameter string. When the common storage process PKG _ Test of Oracle is triggered, the parameter string and the program name of the target Test process incoming from the front end can be received.

Next, in operation S603, parameter values of each entry parameter in the parameter string are matched and assigned to each entry parameter in the input parameter sequence of the target storage process in the database system, so as to obtain a dynamically assembled SQL statement.

In one embodiment, for example, in an Oracle database, when a dynamic assembly SQL statement is obtained, a detection storage process of the Oracle database system (i.e., an Oracle Java program OraJavaTest) may be first used to detect a target storage process and a parameter sequence thereof in the database system, so as to check whether the target storage process exists, whether the target storage process is real and valid, and whether a parameter sequence of a transmitted parameter string is consistent with the parameter sequence in the database system (e.g., whether the number of parameters and the type of parameters are consistent). And then after the OraJavaTest detects the target storage process and the parameter sequence thereof, decomposing the parameter input strings and the parameter output strings in the parameter strings, and matching the decomposed parameter input strings with the parameters in the target storage process according to the input parameter sequence to obtain the dynamic assembly SQL statement. The dynamic assembly SQL statement is the SQL statement after the parameter value of the parameter of the test case is given to the target storage process.

Then, in operation S604, the dynamic assembly SQL statement is executed in the database system to obtain a test result.

The test results may be fed back to the user interaction interface on the terminal device 101 in any manner known in the art. In some embodiments, the parameter values of the parameters in the test result may be output to the test case list interface 501 shown in fig. 5 through operations S601 to S605.

Specifically, in operation S605, after the dynamic assembly SQL statement runs to obtain the test result, the parameter values of the respective arguments in the test result may be matched to the respective arguments of the argument string.

Then, in operation S606, after matching the parameter values of the respective parameters of the parameter string, the parameter string is transmitted to the user interface through the database system. For example, in an Oracle database system, the parameter string can be transmitted to the VBA program in the front end using the common storage process PKG _ Test.

Next, in operation S607, the parameter values of each parameter in the output parameter sequence in the test result are displayed in the user interaction interface. For example, the VBA program writes the parameter value of each parameter in the output parameter sequence in the parameter string into the cell of the output parameter of each test case in the test case list interface 501.

Fig. 7 schematically shows a schematic diagram of an automated test in operation S340 in a test method of a stored procedure according to an embodiment of the present disclosure. In the illustration of fig. 7, the front-end user interaction interface is an Excel interface written based on VBA, and the back-end is an oracle database.

After a plurality of test cases are read into the memory at one time, the input parameter string and the output parameter string (at this time, the output parameter is two null values) can be obtained by processing in operation S601, and the two are spliced into the parameter string by using "$ | $" for separation.

Then, using the adobd.command object in the VBA, the parameter CommandType is set to adcmdsturedproc (storage procedure), to call the written Oracle common storage procedure PKG _ Test (operation S1), and to wait for the execution result of the subsequent program. After the Oracle storage process PKG _ Test is triggered and receives the import and export strings, the export string, and the program name imported by the VBA, the Oracle Java program OraJavaTest is called, and the import and export strings, the export string, and the program name are imported (operation S2). After receiving the parameters, the OraJavaTest program queries the Oracle dictionary table DBA _ ARGUMENTS again according to the program name, acquires the access name, the parameter serial number and the parameter type of the program, and verifies the target storage process and the parameter information provided by the user. After the check is passed, the received parameter entering string and parameter exiting string are firstly split according to a separator (for example, $ | $), and the parameter sequences found by the dictionary table and the parameter values in the parameter entering string are sequentially matched to a target storage process one by one (operation S3), so that the dynamic assembly SQL statement is obtained and executed. The execution result is next returned to the common storage process PKG _ Test (operation S4). The PKG _ Test receives the execution result and returns it to the Excel VBA program (operation S5). The VBA program then eventually writes the results back into the front-end user interaction interface (e.g., test case list interface 501 shown in FIG. 5).

FIG. 8 schematically shows a flow chart of a method of testing a stored procedure according to another embodiment of the present disclosure. The embodiment provides a specific implementation mode of a batch test case test storage process aiming at the situation that the front end is an Excel interface written based on VBA and the rear end is an oracle database. It is understood that the example of fig. 8 is only an illustrative embodiment and does not constitute any limitation on the disclosed aspects.

As shown in fig. 8, the test method of the storage procedure according to the embodiment may include steps S100 to S104.

First, in step S100, the entered Oracle stores the process name (as shown in FIG. 4). The correctness of the name of the tested program can be checked by reading a dictionary parameter table recording information of the storage process in Oracle through VBA, and the parameter sequence such as the number of parameters, the name of the parameters, the type of the parameters and the like corresponding to the program can be obtained.

Then, in step S101, a corresponding test case list interface (e.g., 501 in fig. 5) is generated according to step S100. The tester adds columns according to the actual situation of the test case, and can click a test button 502 in a test case list interface 501 after inputting related case input parameter data to generate a test instruction, wherein each case is a test instruction. The user selects several test cases, and then several test instructions are generated correspondingly.

Next, in step S102, the test instruction passed in step S101 is received and passed to the Java core handler. For example, each Test instruction is received using the written common storage procedure PKG _ Test, and the parameters in the Test instruction are transferred to the OraJavaTest program.

Next, in step S103, the Java core processing program (e.g., OraJavaTest program) decomposes the passed parameters to extract the program name and the input parameter data, and calls the target storage process according to the program name and the input parameter data, and monitors the calling time of the target storage process and whether the target storage process is available, and reports an error when the target storage process is overtime or unavailable. Then, an execution result is output, and according to the type judgment of the parameter field, an Excel file or a doc file is generated for parameter of a large field (such as CLOB and BLOB) and a cursor type and returned to a field value in a hyperlink form, and the parameter fields of the other types are returned to the test case list interface 501 according to an actual result.

Finally, in step S104, the execution results are written back to the test case list interface 501 in a unified manner.

According to the embodiment of the disclosure, the automatic test of the Oracle storage process can be realized based on VBA and Java programming, and developers can conveniently test the Oracle storage process and save test entry and test results without writing any test script. And can be displayed in an Excel form, and is very convenient to use. Compared with the one-by-one test case in the related technology, the method disclosed by the embodiment of the invention can be used for carrying out batch test on the test cases without writing any test script by developers. And the recorded test cases can be reused. For example, when the internal logic of the target storage process is changed but the parameter sequence is not changed, the test case can be reused, namely, the test case and the relevant parameter data are retested without being changed, and the test efficiency is high.

Based on the test method of the storage process, the embodiment of the disclosure also provides a test device of the storage process. A test device according to various embodiments of the present disclosure will be described in detail below with reference to fig. 9 and 10.

FIG. 9 schematically shows a block diagram of a test apparatus 900 storing a procedure according to an embodiment of the disclosure.

As shown in fig. 9, the test apparatus 900 storing a process according to an embodiment of the present disclosure may include an acquisition module 910, a logging module 920, a reading module 930, and a test module 940. The test apparatus 900 may be used to implement the test methods described with reference to fig. 2-8.

The obtaining module 910 is configured to obtain a parameter sequence of a target storage process to be tested, where the parameter sequence includes an input parameter sequence. In an embodiment, the obtaining module 910 may be configured to perform the operation S310 described above, which is not described herein again.

The entry module 920 is configured to enter M test cases based on the first user operation, where in each test case, a parameter value of each entry parameter in the input parameter sequence is specified based on the first user operation, where M is an integer greater than 1. In an embodiment, the logging module 920 may be configured to perform the operation S320 described above, which is not described herein again.

The reading module 930 is configured to read the M test cases into the memory at one time. In an embodiment, the reading module 930 may be configured to perform the operation S330 described above, which is not described herein again.

The test module 940 is configured to perform an automated test on the target storage process using the M test cases. In an embodiment, the test module 940 may be configured to perform the operation S340 described above, which is not described herein again.

Fig. 10 schematically illustrates a block diagram of a test module 940 in a test apparatus storing a procedure according to an embodiment of the present disclosure.

As shown in fig. 10, the test module 940 may include a parameter combination sub-module 941, a parameter transmission sub-module 942, a parameter matching sub-module 943, and a statement execution sub-module 944 according to an embodiment of the present disclosure. According to other embodiments of the present disclosure, the test module 940 may further include a result output sub-module 945. The test module 940 may be used to implement the test flow described with reference to fig. 6.

The parameter combination submodule 941 is configured to obtain a parameter string based on a combination of parameter values of all parameters in the parameter sequence in the test case. In an embodiment, the parameter combination sub-module 941 may be configured to perform the operation S601 described above, and is not described herein again.

The parameter transmission sub-module 942 is configured to transmit the parameter string to a database system, where the target storage procedure is a storage procedure in the database system. In an embodiment, the parameter transmission sub-module 942 may be configured to perform the operation S602 described above, which is not described herein again.

The parameter matching sub-module 943 is configured to match and assign parameter values of each entry parameter in the parameter string to each entry parameter in the input parameter sequence of the target storage process in the database system, so as to obtain a dynamically assembled SQL statement. In an embodiment, the parameter matching sub-module 943 may be configured to perform the operation S603 described above, and is not described herein again.

The statement execution sub-module 944 is configured to execute the dynamically assembled SQL statement in the database system to obtain a test result. In an embodiment, the statement execution submodule 944 may be configured to execute the operation S604 described above, and details are not described herein again.

The result output sub-module 945 is configured to match parameter values of each parameter in the test result with each parameter in the parameter string, transmit the parameter string to a user interaction interface through the database system after the parameter values of each parameter in the parameter string are matched, and then display the parameter values of each parameter in the output parameter sequence in the test result in the user interaction interface. In an embodiment, the result output sub-module 945 may be configured to perform operations S605 to S607 described above, which are not described herein again.

According to the embodiment of the present disclosure, any multiple modules of the obtaining module 910, the logging module 920, the reading module 930, the testing module 940, the parameter combining sub-module 941, the parameter transmitting sub-module 942, the parameter matching sub-module 943, the statement executing sub-module 944, and the result outputting sub-module 945 may be combined to be implemented in one module, or any one of them may be split into multiple modules. Alternatively, at least part of the functionality of one or more of these modules may be combined with at least part of the functionality of the other modules and implemented in one module. According to an embodiment of the present disclosure, at least one of the obtaining module 910, the logging module 920, the reading module 930, the testing module 940, the parameter combining sub-module 941, the parameter transmitting sub-module 942, the parameter matching sub-module 943, the statement executing sub-module 944, and the result outputting sub-module 945 may be implemented at least partially as a hardware circuit, such as a Field Programmable Gate Array (FPGA), a Programmable Logic Array (PLA), a system on a chip, a system on a substrate, a system on a package, an Application Specific Integrated Circuit (ASIC), or may be implemented by hardware or firmware in any other reasonable manner of integrating or packaging a circuit, or implemented by any one of or a suitable combination of software, hardware, and firmware implementations. Alternatively, at least one of the obtaining module 910, the logging module 920, the reading module 930, the testing module 940, the parameter combining sub-module 941, the parameter transmitting sub-module 942, the parameter matching sub-module 943, the sentence executing sub-module 944, and the result outputting sub-module 945 may be at least partially implemented as a computer program module, which may perform a corresponding function when executed.

FIG. 11 schematically illustrates a block diagram of an electronic device 1100 adapted to implement a testing method of a stored procedure in accordance with an embodiment of the disclosure. The electronic device 1100 shown in fig. 11 is only an example and should not bring any limitations to the function and scope of use of the embodiments of the present disclosure.

As shown in fig. 11, an electronic device 1100 according to an embodiment of the present disclosure includes a processor 1101, which can perform various appropriate actions and processes according to a program stored in a Read Only Memory (ROM)1102 or a program loaded from a storage section 1108 into a Random Access Memory (RAM) 1103. The processor 1101 may comprise, for example, a general purpose microprocessor (e.g., a CPU), an instruction set processor and/or associated chipset, and/or a special purpose microprocessor (e.g., an Application Specific Integrated Circuit (ASIC)), among others. The processor 1101 may also include on-board memory for caching purposes. The processor 1101 may comprise a single processing unit or a plurality of processing units for performing the different actions of the method flows according to the embodiments of the present disclosure.

In the RAM 1103, various programs and data necessary for the operation of the electronic device 1100 are stored. The processor 1101, the ROM 1102, and the RAM 1103 are connected to each other by a bus 1104. The processor 1101 performs various operations of the method flow according to the embodiments of the present disclosure by executing programs in the ROM 1102 and/or the RAM 1103. It is noted that the programs may also be stored in one or more memories other than the ROM 1102 and RAM 1103. The processor 1101 may also perform various operations of the method flows according to the embodiments of the present disclosure by executing programs stored in the one or more memories.

Electronic device 1100 may also include input/output (I/O) interface 1105, input/output (I/O) interface 1105 also connected to bus 1104, according to an embodiment of the disclosure. Electronic device 1100 may also include one or more of the following components connected to I/O interface 1105: an input portion 1106 including a keyboard, mouse, and the like; an output portion 1107 including a signal output unit such as a Cathode Ray Tube (CRT), a Liquid Crystal Display (LCD), and a speaker; a storage section 1108 including a hard disk and the like; and a communication section 1109 including a network interface card such as a LAN card, a modem, or the like. The communication section 1109 performs communication processing via a network such as the internet. A driver 1110 is also connected to the I/O interface 1105 as necessary. A removable medium 1111 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is mounted on the drive 1110 as necessary, so that a computer program read out therefrom is mounted into the storage section 1108 as necessary.

According to embodiments of the present disclosure, method flows according to embodiments of the present disclosure may be implemented as computer software programs. For example, embodiments of the present disclosure include a computer program product comprising a computer program embodied on a computer readable storage medium, the computer program containing program code for performing the method illustrated by the flow chart. In such an embodiment, the computer program may be downloaded and installed from a network through the communication portion 1109 and/or installed from the removable medium 1111. The computer program, when executed by the processor 1101, performs the above-described functions defined in the system of the embodiment of the present disclosure. The systems, devices, apparatuses, modules, units, etc. described above may be implemented by computer program modules according to embodiments of the present disclosure.

The present disclosure also provides a computer-readable storage medium, which may be contained in the apparatus/device/system described in the above embodiments; or may exist separately and not be assembled into the device/apparatus/system. The computer-readable storage medium carries one or more programs which, when executed, implement the method according to an embodiment of the disclosure.

According to embodiments of the present disclosure, the computer-readable storage medium may be a non-volatile computer-readable storage medium, which may include, for example but is not limited to: a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the present disclosure, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. For example, according to embodiments of the present disclosure, a computer-readable storage medium may include the ROM 1102 and/or the RAM 1103 and/or one or more memories other than the ROM 1102 and the RAM 1103 described above.

Embodiments of the present disclosure also include a computer program product comprising a computer program containing program code for performing the method provided by the embodiments of the present disclosure, when the computer program product is run on an electronic device, the program code being adapted to cause the electronic device to carry out the method provided by the embodiments of the present disclosure.

The computer program, when executed by the processor 1101, performs the above-described functions defined in the system/apparatus of the embodiments of the present disclosure. The systems, apparatuses, modules, units, etc. described above may be implemented by computer program modules according to embodiments of the present disclosure.

In one embodiment, the computer program may be hosted on a tangible storage medium such as an optical storage device, a magnetic storage device, or the like. In another embodiment, the computer program may also be transmitted in the form of a signal on a network medium, distributed, downloaded and installed via the communication part 1109, and/or installed from the removable medium 1111. The computer program containing program code may be transmitted using any suitable network medium, including but not limited to: wireless, wired, etc., or any suitable combination of the foregoing.

In accordance with embodiments of the present disclosure, program code for executing computer programs provided by embodiments of the present disclosure may be written in any combination of one or more programming languages, and in particular, these computer programs may be implemented using high level procedural and/or object oriented programming languages, and/or assembly/machine languages. The programming language includes, but is not limited to, programming languages such as Java, C + +, python, the "C" language, or the like. The program code may execute entirely on the user computing device, partly on the user device, partly on a remote computing device, or entirely on the remote computing device or server. In the case of a remote computing device, the remote computing device may be connected to the user computing device through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computing device (e.g., through the internet using an internet service provider).

The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present disclosure. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams or flowchart illustration, and combinations of blocks in the block diagrams or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.

The embodiments of the present disclosure have been described above. However, these examples are for illustrative purposes only and are not intended to limit the scope of the present disclosure. Although the embodiments are described separately above, this does not mean that the measures in the embodiments cannot be used in advantageous combination. The scope of the disclosure is defined by the appended claims and equivalents thereof. Various alternatives and modifications can be devised by those skilled in the art without departing from the scope of the present disclosure, and such alternatives and modifications are intended to be within the scope of the present disclosure.

Claims

1. A method of testing a stored procedure, comprising:

acquiring a parameter sequence of a tested target storage process, wherein the parameter sequence comprises an input parameter sequence;

inputting M test cases based on first user operation, wherein each parameter value of the input parameter sequence is specified in each test case based on the first user operation, and M is an integer greater than 1;

reading the M test cases into a memory at one time; and

and carrying out automatic test on the target storage process by using the M test cases.

2. The method of claim 1, wherein the entering M test cases based on the first user operation comprises:

providing a test case list interface to display the parameter sequence; and

and inputting M test cases in the test case list interface based on the first user operation.

3. The method of claim 2, wherein the test case list interface is a VBA-based list interface; the step of reading the M test cases into the memory at one time includes:

and reading the whole data in the test case list interface containing M test cases into a memory by using a Range object of the VBA.

4. The method of claim 2, wherein,

the entering of the M test cases based on the first user operation comprises: marking a test case for testing from the M test cases based on a second user operation;

the automatic testing of the target storage process by using the M test cases comprises the following steps: and automatically testing the target storage process by using the marked test case.

5. The method of claim 1, wherein the obtaining a sequence of parameters of a target stored procedure under test comprises:

providing a test program selection interface;

receiving a third user operation of a user in the test program selection interface, wherein the third user operation is used for specifying a program name of a tested target storage process and inputting login parameter information for connecting and logging in a database system, and the target storage process is a storage process in the database system;

responding to a fourth user operation for connecting a database, and transmitting the program name of the target storage process and the login parameter information into the database system;

after logging in the database system based on the login parameter information, querying the parameter sequence from the database system based on the program name of the target stored process.

6. The method of claim 5, wherein said querying the sequence of parameters from the database system based on the program name of the target stored procedure comprises:

querying the parameter sequence of the target stored procedure from a dictionary table for storing various types of stored procedures; and

and generating a test case list interface based on the inquired parameter sequence.

7. The method according to any one of claims 1 to 6, wherein the automatically testing the target storage process by using the M test cases comprises:

obtaining a parameter string based on the combination of parameter values of all parameters in the parameter sequence in the test case;

transmitting the parameter string to a database system, wherein the target storage process is a storage process in the database system;

matching and assigning parameter values of each input parameter in the parameter string to each input parameter in the input parameter sequence of the target storage process in the database system to obtain a dynamic assembly SQL statement; and

and executing the dynamic assembly SQL statement in the database system to obtain a test result.

8. The method of claim 7, wherein the parameter sequence further comprises an output parameter sequence, and the deriving a parameter string based on a combination of parameter values of all parameters in the parameter sequence in the test case comprises:

combining all parameter values of the input parameter sequence into a character string according to a predefined format to obtain a parameter string;

combining all parameter values of the output parameter sequence into a character string according to a predefined format to obtain a parameter string; and

and splicing the parameter input string and the parameter output string into the parameter string through a predefined separator.

9. The method of claim 8, wherein the automated testing of the target stored procedure with the M test cases further comprises:

matching parameter values of all parameters in the test result to all parameters of the parameter string;

after parameter values of all the parameters of the parameter strings are matched, the parameter strings are transmitted to a user interaction interface through the database system; and

and displaying parameter values of each parameter in the output parameter sequence in the test result in the user interaction interface.

10. The method of claim 9, wherein the target stored procedure is a stored procedure in an Oracle database system, wherein the Oracle database system receives and transmits the parameter string using a common stored procedure.

11. The method of claim 10, wherein said obtaining a dynamically assembled SQL statement comprises:

detecting the target storage process and the parameter sequence thereof in the database system by utilizing the detection storage process of the Oracle database system;

after the target storage process and the parameter sequence thereof are detected, decomposing the parameter input string and the parameter output string in the parameter string; and

and matching the decomposed parameter input strings to each parameter input of the target storage process according to the input parameter sequence.

12. A test apparatus storing a process, comprising:

the acquisition module is used for acquiring a parameter sequence of a tested target storage process, wherein the parameter sequence comprises an input parameter sequence;

the input module is used for inputting M test cases based on first user operation, wherein each parameter value of the input parameter sequence is specified in each test case based on the first user operation, and M is an integer greater than 1;

the reading module is used for reading the M test cases into the memory at one time; and

and the test module is used for carrying out automatic test on the target storage process by utilizing the M test cases.

13. An electronic device, comprising:

one or more memories storing executable instructions; and

one or more processors executing the executable instructions to implement the method of any one of claims 1-11.

14. A computer readable storage medium having stored thereon executable instructions which, when executed by a processor, cause the processor to perform the method of any one of claims 1 to 11.