CN112612695A

CN112612695A - Functional test environment verification method, device, equipment and medium based on RPA

Info

Publication number: CN112612695A
Application number: CN202011496955.2A
Authority: CN
Inventors: 蒋善东
Original assignee: Ping An Puhui Enterprise Management Co Ltd
Current assignee: Guangdong Shuyuan Technology Co ltd; Shenzhen Lian Intellectual Property Service Center
Priority date: 2020-12-17
Filing date: 2020-12-17
Publication date: 2021-04-06
Anticipated expiration: 2040-12-17
Also published as: CN112612695B

Abstract

The application relates to the technical field of artificial intelligence, and discloses a functional test environment verification method, a device, equipment and a medium based on RPA, wherein the method comprises the following steps: calling the RPA to perform a circulation flow test according to the circulation flow test configuration data to obtain a circulation flow test result; calling the RPA to carry out calling the Rest interface verification test according to the calling Rest interface test configuration data to obtain a calling Rest interface verification test result; calling the RPA to perform an abnormal verification test on the SQL script execution log according to the SQL script execution log test configuration data to obtain an abnormal verification test result of the SQL script execution log; and reporting and generating a target function test environment verification test report according to the circulation flow test result, the call Rest interface verification test result and the SQL script execution log exception verification test result. The software environment verification test for automatically performing the function test is realized, and the time for the function test is shortened.

Description

Functional test environment verification method, device, equipment and medium based on RPA

Technical Field

The present application relates to the field of artificial intelligence technologies, and in particular, to a method, an apparatus, a device, and a medium for verifying a functional test environment based on an RPA.

Background

The developers in the prior art mainly pay attention to writing of codes, and due to the fact that the versions and the environments are numerous, verification of the software environment before functional testing is easily ignored. Particularly, when the mobile terminal is produced, on one hand, functions which are held with lucky psychology and are not modified generally have no problem, on the other hand, verification is mostly performed through complicated and repeated work, so that developers are unwilling to use time in a software environment for verifying function testing, the time for function testing is prolonged, problems can occur after products are brought online, and user experience is reduced.

Disclosure of Invention

The application mainly aims to provide a functional test environment verification method based on RPA, and aims to solve the technical problems that the software environment verification before functional test is neglected, the functional test time is prolonged, and the product is possibly on-line and has problems in the prior art.

In order to achieve the above object, the present application provides a functional test environment verification method based on RPA, where the method includes:

acquiring a verification test request of a functional test environment;

responding to the verification test request of the functional test environment, acquiring circulation flow test configuration data from a configuration database, and calling an RPA (resilient packet adapter) to perform circulation flow test according to the circulation flow test configuration data to obtain a circulation flow test result;

responding to the verification test request of the function test environment, acquiring Rest interface calling test configuration data from the configuration database, and calling the RPA to perform Rest interface calling verification test according to the Rest interface calling test configuration data to obtain a Rest interface calling verification test result;

responding to the verification test request of the functional test environment, acquiring SQL script execution log test configuration data from the configuration database, and calling the RPA to perform an abnormal verification test on the SQL script execution log according to the SQL script execution log test configuration data to obtain an abnormal verification test result of the SQL script execution log;

and generating reports according to the circulation flow test result, the call Rest interface verification test result and the SQL script execution log abnormal verification test result to obtain a target function test environment verification test report.

Further, before the step of obtaining the circulation flow test configuration data from the configuration database, the method further includes:

acquiring a circulation flow test recording request, wherein the circulation flow test recording request carries a circulation flow identification to be recorded;

responding to the circulation flow test recording request, calling the RPA to perform flow circulation simulation operation according to the circulation flow identification to be recorded, and obtaining a flow circulation simulation operation ending signal, an event configuration result of the circulation flow to be stored and parameter information required to be used by the circulation flow to be stored;

responding to the flow circulation simulation operation ending signal, and associating the flow circulation identification to be recorded, the event configuration result of the flow circulation to be stored and the parameter information required to be used by the flow circulation to be stored to obtain flow circulation test configuration data to be stored;

and updating the configuration database according to the circulation flow test configuration data to be stored.

Further, the step of calling the RPA to perform flow circulation simulation operation according to the circulation flow identification to be recorded to obtain a flow circulation simulation operation end signal, an event configuration result of the circulation flow to be stored, and parameter information required to be used by the circulation flow to be stored includes:

acquiring a flow circulation flow exception handling strategy to be stored;

and calling the RPA to perform flow circulation simulation operation according to the flow circulation identification to be recorded and the flow circulation exception handling strategy to be stored, and obtaining a flow circulation simulation operation ending signal, an event configuration result of the flow circulation to be stored and parameter information required to be used by the flow circulation to be stored.

Further, the step of calling the RPA to perform a call Rest interface verification test according to the call Rest interface test configuration data to obtain a call Rest interface verification test result includes:

calling the RPA to start a Postman tool according to the test configuration data of the calling Rest interface;

calling the RPA to fill request parameters in the Postman tool according to the test configuration data of the called Rest interface to obtain a target Postman tool;

calling the RPA to perform request submission operation on the target Postman tool according to the calling Rest interface test configuration data, wherein the request submission operation is used for calling a target Rest interface corresponding to a Rest interface identifier of the calling Rest interface test configuration data;

obtaining a return value of Http sent by the target Rest interface to obtain a return value of Http to be judged;

and when the return code of the return value of the Http to be judged is a preset correct value, determining that the test result of calling the validation test result of the reset interface is normal, otherwise, determining that the test result of calling the validation test result of the reset interface is abnormal, calling the RPA to perform screenshot on the return code of the return value of the Http to be judged, and obtaining error data of the validation test result of the reset interface.

Further, before the step of obtaining the test configuration data of the call Rest interface from the configuration database, the method further includes:

acquiring a Rest interface test recording request, wherein the Rest interface test recording request carries a Rest interface identifier to be recorded;

responding to the Rest interface test recording request, calling the RPA to perform simulation operation of calling the Rest interface according to the Rest interface identifier to be recorded, and obtaining a Rest interface calling end signal, an event configuration result of the Rest interface to be stored and parameter information required by calling the Rest interface to be stored;

responding to the Rest interface calling end signal, and associating the Rest interface identification to be recorded, the event configuration result of the Rest interface to be stored and the parameter information required by the Rest interface to be stored to obtain Rest interface calling test configuration data to be stored;

and updating the configuration database according to the calling Rest interface test configuration data to be stored.

Further, the step of calling the RPA to perform the abnormal verification test of the SQL script execution log according to the SQL script execution log test configuration data to obtain the abnormal verification test result of the SQL script execution log includes:

calling the RPA to log in a target server according to the SQL script execution log test configuration data and enter an SQL execution log directory of the target server;

calling the RPA to perform error search in a log file under the SQL execution log directory of the target server according to the SQL script execution log test configuration data to obtain an error search result;

and when the error search result is empty, determining that the test result of the abnormal verification test result of the SQL script execution log is normal, otherwise, determining that the test result of the abnormal verification test result of the SQL script execution log is abnormal, and calling the RPA to capture the error search result to obtain error data of the abnormal verification test result of the SQL script execution log.

Further, before the step of obtaining the SQL script execution log test configuration data from the configuration database, the method further includes:

acquiring an SQL script execution log test recording request, wherein the SQL script execution log test recording request carries an SQL script execution log identifier to be recorded;

responding to the SQL script execution log test recording request, calling the RPA to perform an abnormal verification test on the SQL script execution log according to the to-be-recorded SQL script execution log identifier, and obtaining an abnormal verification test ending signal of the SQL script execution log, an event configuration result of the abnormal verification test on the to-be-stored SQL script execution log, and parameter information required by the abnormal verification test on the to-be-stored SQL script execution log;

responding to an abnormal verification test ending signal of the SQL script execution log, and associating the SQL script execution log identifier to be recorded, the event configuration result of the abnormal verification test of the SQL script execution log to be stored and the parameter information required by the abnormal verification test of the SQL script execution log to be stored to obtain SQL script execution log test configuration data to be stored;

and updating the configuration database according to the SQL script execution log test configuration data to be stored.

The application also provides a functional test environment verifying device based on RPA, the device includes:

the request acquisition module is used for acquiring a verification test request of the functional test environment;

the circulation flow test module is used for responding to the verification test request of the function test environment, acquiring circulation flow test configuration data from a configuration database, and calling the RPA to carry out circulation flow test according to the circulation flow test configuration data to obtain a circulation flow test result;

a calling Rest interface verification test module, configured to respond to the verification test request of the functional test environment, obtain calling Rest interface test configuration data from the configuration database, and call the RPA to perform calling Rest interface verification test according to the calling Rest interface test configuration data to obtain a calling Rest interface verification test result;

the abnormal verification test module of the SQL script execution log is used for responding to the verification test request of the function test environment, acquiring SQL script execution log test configuration data from the configuration database, and calling the RPA to perform the abnormal verification test of the SQL script execution log according to the SQL script execution log test configuration data to obtain an abnormal verification test result of the SQL script execution log;

and the report generation module is used for generating reports according to the circulation flow test result, the call Rest interface verification test result and the SQL script execution log exception verification test result to obtain a target function test environment verification test report.

The present application further proposes a computer device comprising a memory and a processor, the memory storing a computer program, the processor implementing the steps of any of the above methods when executing the computer program.

The present application also proposes a computer-readable storage medium having stored thereon a computer program which, when being executed by a processor, carries out the steps of the method of any of the above.

The RPA-based functional test environment verification method, device, equipment and medium of the application, a flow process test is carried out according to flow process test configuration data by calling the RPA to obtain a flow process test result, the RPA is called to carry out a Rest interface verification test according to the Rest interface test configuration data to obtain a Rest interface verification test result, the RPA is called to carry out an abnormal verification test of an SQL script execution log according to the SQL script execution log test configuration data to obtain an SQL script execution log abnormal verification test result, reports are generated according to the flow process test result, the Rest interface verification test result and the SQL script execution log abnormal verification test result to obtain a target functional test environment verification test report, thereby realizing the verification test of a software environment for automatically carrying out the functional test, the time of function test is shortened, and the probability of problems after products are on line is reduced.

Drawings

Fig. 1 is a schematic flowchart illustrating a functional test environment verification method based on RPA according to an embodiment of the present application;

FIG. 2 is a block diagram illustrating a functional test environment verification apparatus based on RPA according to an embodiment of the present disclosure;

fig. 3 is a block diagram illustrating a structure of a computer device according to an embodiment of the present application.

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

Detailed Description

In order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.

In order to solve the technical problems that the prior art neglects the verification of a software environment before the function test, the time of the function test is prolonged, and the problem can occur after a product is on line, the application provides a function test environment verification method based on RPA, and the method is applied to the technical field of artificial intelligence. The functional test environment verification method based on the RPA calls the RPA to perform circulation flow test, calls the Rest interface to perform verification test and executes the abnormal verification test of the log by the SQL script, thereby realizing the software environment verification test for automatically performing the functional test, shortening the time of the functional test and reducing the probability of problems after the product is on line.

Referring to fig. 1, an embodiment of the present application provides a functional test environment verification method based on RPA, where the method includes:

s1: acquiring a verification test request of a functional test environment;

s2: responding to the verification test request of the functional test environment, acquiring circulation flow test configuration data from a configuration database, and calling an RPA (resilient packet adapter) to perform circulation flow test according to the circulation flow test configuration data to obtain a circulation flow test result;

s3: responding to the verification test request of the function test environment, acquiring Rest interface calling test configuration data from the configuration database, and calling the RPA to perform Rest interface calling verification test according to the Rest interface calling test configuration data to obtain a Rest interface calling verification test result;

s4: responding to the verification test request of the functional test environment, acquiring SQL script execution log test configuration data from the configuration database, and calling the RPA to perform an abnormal verification test on the SQL script execution log according to the SQL script execution log test configuration data to obtain an abnormal verification test result of the SQL script execution log;

s5: and generating reports according to the circulation flow test result, the call Rest interface verification test result and the SQL script execution log abnormal verification test result to obtain a target function test environment verification test report.

In this embodiment, a RPA is called to perform a flow process test according to the flow process test configuration data to obtain a flow process test result, the RPA is called to perform a call Rest interface verification test according to the call Rest interface test configuration data to obtain a call Rest interface verification test result, the RPA is called to perform an exception verification test on an SQL script execution log according to the SQL script execution log test configuration data to obtain an SQL script execution log exception verification test result, generating reports according to the circulation flow test result, the calling Rest interface verification test result and the SQL script execution log abnormal verification test result to obtain a target function test environment verification test report, therefore, the verification test of the software environment for automatically performing the function test is realized, the time for the function test is shortened, and the probability of problems after the product is on line is reduced.

For S1, the verification test request of the functional test environment may be sent by the user, or may be actively triggered by the application program file after the deployment of the software to be tested is completed.

The verification test request of the functional test environment is a request for performing verification test on the software test environment for the functional test of the software to be tested.

The software to be tested, i.e. the software that needs to be functionally tested.

Optionally, the step of obtaining the verification test request of the functional test environment includes:

s11: acquiring a deployment completion signal of software to be tested;

s12: generating the verification test request of the functional test environment based on the deployment completion signal.

And for S2, responding to the verification test request of the functional test environment, acquiring the circulation flow test configuration data from the configuration database of the database, calling the RPA to simulate a human to call third-party software to perform the operation of circulation flow according to the circulation flow test configuration data, and obtaining a circulation flow test result after the circulation flow is finished.

RPA (robot Process Automation) RPA uses a robot as a virtual labor force, interacts with an existing user system according to a preset program, and completes an expected task. From current technical practice, the existing RPA is also only suitable for highly repetitive, logical determination and relatively low stability requirement procedures. For example, the RPA provides a component for simulating human operation by a mouse click event and a keyboard input event, and the user clicks and operates the component after arranging and combining the components, thereby achieving the effect of automatic operation.

The circulation flow test result comprises: the flow process testing system comprises flow process identification, flow nodes and flow process testing values, wherein each flow process identification corresponds to one or more flow nodes, and each flow node corresponds to one flow process testing value.

The flow process identifier may be an identifier that uniquely identifies one flow process, such as a flow process ID and a flow process name. It is to be understood that the number of approval procedures is not specifically limited herein.

The circulation flow test configuration data comprises: the method comprises the steps of flow process identification, flow node identification, event configuration results of the flow process and parameter information needed to be used by the flow process.

And the circulation flow test is used for simulating the flow circulation condition of the third-party software operated by a human to test the response of the third-party software to the call request of the software to be tested.

The event configuration result of the flow process is the configuration result of the event which needs to be executed by the RPA in the flow process.

For example, the flow process L1 includes three common nodes (i.e., initiate-review), the general process is a customer manager (initiate-review process, fill in process information, select review handler, click on submit review task), review handler (fill in username and password login system, enter into the pending list of review module select review task, select review opinion as "agree", fill in other necessary input, select review handler, finally click on review result of submit review task), review handler (input username and password login system, select review opinion as "agree", click on submit review task, flow process status is finished), RPA simulates customer manager, review handler, the approval handler performs related operations, and the flow node identifier in the flow test configuration data includes: the event configuration result of the flow process test configuration data includes an initiating node identifier of the flow process L1, a rechecking node identifier of the flow process L1, and an approval node identifier of the flow process L1: the method comprises the following steps of (1) event configuration results of a customer manager (initiating an approval process, filling process information, selecting a rechecking processor, clicking to submit), event configuration results of the rechecking processor (filling a user name and a password, entering a to-be-processed list of an approval module, selecting an approval task, selecting a rechecking opinion, filling other necessary input items, selecting the approval processor to click to submit), event configuration results of the approval processor (filling a user name and a password, selecting an approval opinion, selecting an approval task, selecting a rechecking opinion, filling other necessary input items, selecting an approval processor, clicking to submit), and parameter information required by a circulation flow of circulation flow test configuration data comprises the following steps: the customer manager (filled process information), the review handler (filled username and password, selected review comment, other necessary input items), and the approval handler (entered username and password, selected review comment), which are not specifically limited herein.

Optionally, after the step of calling the RPA to perform the flow process test according to the flow process test configuration data to obtain the flow process test result, the method further includes: acquiring a mail sending rule of a preset circulation flow result; and sending the mail to the circulation flow test result according to the preset circulation flow result sending rule. Therefore, the automatic reminding of the flow test result is realized, and the communication time is reduced.

And for S3, responding to the verification test request of the functional test environment, acquiring the test configuration data of the calling Rest interface from the configuration database of the database, calling the RPA to simulate the operation of calling the Rest interface of the software to be tested by third-party software according to the test configuration data of the calling Rest interface, and calling the Rest interface to finish to obtain the verification test result of the calling Rest interface.

Invoking the Rest interface test configuration data comprises: the identification of the Rest interface, the event configuration result of the Rest interface and the parameter information required for calling the Rest interface. The Rest interface identifier may be a Rest interface name, a Rest interface ID, or the like, that uniquely identifies a Rest interface of the software to be tested.

Rest, which is a URL location resource, describes operations with HTTP verbs (GET, POST, DELETE, PUT).

The Rest interface is an interface conforming to the Rest specification.

The event configuration result of the Rest interface is the configuration result of the event which needs to be executed by the RPA in the calling Rest interface.

Invoking the Rest interface to verify the test result comprises: the test result comprises normal and abnormal data, the error data has no data when the test result is normal, and the error data has data when the test result is abnormal.

Optionally, after the step of calling the RPA to perform the reset interface verification test according to the reset interface test configuration data, and obtain a result of the reset interface verification test, the method further includes: acquiring a preset calling Rest interface verification mail sending rule; and sending a mail to the result of the verification test of the calling Rest interface according to the preset rule for sending the verification mail of the calling Rest interface. Therefore, the prompt of calling the result interface to verify the test result is automatically carried out, and the communication time is reduced.

And S4, responding to the verification test request of the functional test environment, acquiring SQL (structured query language) script execution log test configuration data from a configuration database of the database, calling the RPA to simulate operation and maintenance personnel to execute the log of the SQL script and carry out error search according to the SQL script execution log test configuration data, and obtaining an SQL script execution log abnormal verification test result after the abnormal verification test of the SQL script execution log is finished.

The SQL script execution log test configuration data comprises: the SQL script execution log identification, the event configuration result of the abnormal verification test of the SQL script execution log and the parameter information needed by the abnormal verification test of the SQL script execution log.

The event configuration result of the abnormal verification test of the SQL script execution log is the configuration result of the event which needs to be executed by the RPA when the abnormal verification test of the SQL script execution log is carried out.

The SQL script execution log exception verification test result comprises the following steps: the test result comprises normal and abnormal data, the error data has no data when the test result is normal, and the error data has data when the test result is abnormal.

It is understood that steps S2 to S4 may be executed asynchronously in other orders or synchronously, and are not limited in detail herein.

Optionally, after the step of calling the RPA to perform the abnormal verification test on the SQL script execution log according to the SQL script execution log test configuration data to obtain the abnormal verification test result on the SQL script execution log, the method further includes: acquiring a preset SQL script execution log to verify a mail sending rule; and E, according to the preset SQL script execution log verification mail sending rule, sending a mail to the SQL script execution log abnormal verification test result. Therefore, the prompt of the abnormal verification test result of the SQL script execution log is automatically carried out, and the communication time is reduced.

And S5, putting the circulation flow test result, the call Rest interface verification test result and the SQL script execution log abnormal verification test result into a document according to a preset sequence to obtain a target function test environment verification test report.

Optionally, after the step of generating a report according to the circulation flow test result, the call Rest interface verification test result, and the SQL script execution log exception verification test result, and obtaining a target function test environment verification test report, the method further includes: acquiring a preset report sending rule; and sending the target function testing environment verification testing report by adopting the preset report sending rule. Therefore, the target function testing environment verification testing report can be automatically issued, and the communication time is reduced.

In an embodiment, before the step of obtaining the circulation flow test configuration data from the configuration database, the method further includes:

s021: acquiring a circulation flow test recording request, wherein the circulation flow test recording request carries a circulation flow identification to be recorded;

s022: responding to the circulation flow test recording request, calling the RPA to perform flow circulation simulation operation according to the circulation flow identification to be recorded, and obtaining a flow circulation simulation operation ending signal, an event configuration result of the circulation flow to be stored and parameter information required to be used by the circulation flow to be stored;

s023: responding to the flow circulation simulation operation ending signal, and associating the flow circulation identification to be recorded, the event configuration result of the flow circulation to be stored and the parameter information required to be used by the flow circulation to be stored to obtain flow circulation test configuration data to be stored;

s024: and updating the configuration database according to the circulation flow test configuration data to be stored.

According to the embodiment, the RPA is called to perform the flow process test recording before the step of acquiring the flow process test configuration data from the configuration database, and a basis is provided for the follow-up automatic flow process test.

And S021, acquiring a flow process test recording request sent by the user.

The flow process test recording request is a request for calling the RPA to record the flow process test.

The circulation flow identifier to be recorded refers to a recorded circulation flow identifier for which a circulation flow test is required to be performed in a circulation flow test recording request.

For S022, responding to the circulation flow test recording request, calling the RPA simulator to carry out flow circulation operation of calling third-party software on a circulation flow corresponding to the circulation flow identification to be recorded, wherein the third-party software sends a recording flow circulation result when the flow circulation operation is finished; generating a flow circulation simulation operation ending signal according to the recording flow circulation result, taking an event in the flow circulation operation of calling third-party software to the circulation flow corresponding to the flow circulation identification to be recorded by a simulator as an event configuration result of the flow circulation to be stored, and taking the parameter information used in the flow circulation operation of calling the third-party software to the flow circulation corresponding to the flow circulation identification to be recorded by the simulator as the parameter information needed to be used by the flow circulation to be stored.

And S023, responding to the flow circulation simulation operation end signal, associating the flow circulation identification to be recorded, the event configuration result of the flow circulation to be stored and the parameter information needed to be used by the flow circulation to be stored into a data record, and taking the data record as the flow circulation test configuration data to be stored.

The circulation flow test configuration data to be stored is circulation flow test configuration data which needs to be stored in the configuration database.

In an embodiment, the step of invoking the RPA to perform the flow circulation simulation operation according to the flow circulation identification to be recorded to obtain a flow circulation simulation operation end signal, an event configuration result of the flow circulation to be stored, and parameter information required to be used by the flow circulation to be stored includes:

s0221: acquiring a flow circulation flow exception handling strategy to be stored;

s0222: and calling the RPA to perform flow circulation simulation operation according to the flow circulation identification to be recorded and the flow circulation exception handling strategy to be stored, and obtaining a flow circulation simulation operation ending signal, an event configuration result of the flow circulation to be stored and parameter information required to be used by the flow circulation to be stored.

According to the method and the device, the flow test recording is carried out based on the flow exception handling strategy to be stored, so that the RPA can be called to carry out automatic handling when the flow exception occurs, manual handling by a person is avoided, the automation degree of the method and the device is improved, and the accuracy of the target function testing environment verification testing report is improved.

For S0221, a to-be-stored flow circulation exception handling policy input by the user may be acquired, and may also be a to-be-stored flow circulation exception handling policy sent by the third-party software.

And the to-be-stored flow exception handling strategy is the flow exception handling strategy of the flow corresponding to the to-be-recorded flow identification. The flow exception handling policy includes but is not limited to: flow process identification, flow node identification, flow process exception handling event configuration result and exception handling mode. The event configuration result of the flow process exception processing is the configuration result of the event which needs to be executed by the RPA when the flow process exception occurs. The exception handling mode includes but is not limited to: ignoring, screenshot, and retrying according to a preset retrying rule. Retrying according to the preset retry rule includes but is not limited to: and after waiting for a preset time length, retrying, and retrying for a preset number of times, and if the normal execution cannot be performed, ignoring and prompting according to preset information.

For S0222, responding to the circulation flow test recording request, calling the RPA simulator to carry out flow circulation simulation operation of calling third-party software on the circulation flow corresponding to the circulation flow identification to be recorded, adopting the to-be-stored flow circulation abnormity processing strategy to process when the flow circulation is abnormal, and sending a flow circulation result by the third-party software when the flow circulation simulation operation is finished; generating a flow circulation simulation operation ending signal according to the flow circulation result, taking an event in the flow circulation simulation operation of calling third-party software to the circulation flow corresponding to the flow circulation identification to be recorded by a simulator as an event configuration result of the flow circulation to be stored, and taking parameter information used in the flow circulation simulation operation of calling the third-party software to the flow circulation corresponding to the flow circulation identification to be recorded by the simulator as parameter information needed to be used by the flow circulation to be stored.

In the process of invoking the RPA to perform the flow circulation simulation operation, unexpected situations may occur, for example, abnormal situations such as timeout of website opening time, expiration of user password, etc., and at this time, invoking the RPA requires performing an operation according to the flow circulation exception handling policy to be stored.

In an embodiment, the step of invoking the RPA to perform the reset interface verification test according to the reset interface test configuration data to obtain the result of the reset interface verification test includes:

s311: calling the RPA to start a Postman tool according to the test configuration data of the calling Rest interface;

s312: calling the RPA to fill request parameters in the Postman tool according to the test configuration data of the called Rest interface to obtain a target Postman tool;

s313: calling the RPA to perform request submission operation on the target Postman tool according to the calling Rest interface test configuration data, wherein the request submission operation is used for calling a target Rest interface corresponding to a Rest interface identifier of the calling Rest interface test configuration data;

s314: obtaining a return value of Http sent by the target Rest interface to obtain a return value of Http to be judged;

s315: and when the return code of the return value of the Http to be judged is a preset correct value, determining that the test result of calling the validation test result of the reset interface is normal, otherwise, determining that the test result of calling the validation test result of the reset interface is abnormal, calling the RPA to perform screenshot on the return code of the return value of the Http to be judged, and obtaining error data of the validation test result of the reset interface.

The embodiment realizes automation, realizes the operation of simulating the third-party software to call the Rest interface of the software to be tested, and improves the testing efficiency.

And S311, calling the RPA to simulate third-party software to start a Postman tool according to the calling Rest interface test configuration data.

And S312, calling the RPA to select a request type as a get request, filling in a user name and a password, filling in an interface calling address in the Postman tool according to the called Rest interface test configuration data, and completing filling to obtain the target Postman tool.

And S313, the RPA is called to click a submit button on the target Postman tool according to the called Rest interface test configuration data to perform request submission operation (a simulator clicks the submit button on third-party software), so that the target Postman tool logs in to-be-tested software according to request parameters.

For step S314, a return value of Http sent by the target Rest interface of the software to be tested is obtained, and the obtained return value of Http is used as the return value of Http to be determined.

For S315, for example, the interface call address is www.student.com/getStudent and the parameter StuNo is 20, the request submitting operation introduces a student number StuNo to the target Rest interface corresponding to the Rest interface identifier of the call Rest interface test configuration data, when the target Rest interface is expected to return student basic information, when the return code of the return value of Http to be determined is 200, it indicates that the target Rest interface is normal, the target Rest interface can normally provide service, and JSON format text content is displayed in the body part of the return value of Http to be determined, which is not limited in this example.

In an embodiment, before the step of obtaining the test configuration data of the call Rest interface from the configuration database, the method further includes:

s031: acquiring a Rest interface test recording request, wherein the Rest interface test recording request carries a Rest interface identifier to be recorded;

s032: responding to the Rest interface test recording request, calling the RPA to perform simulation operation of calling the Rest interface according to the Rest interface identifier to be recorded, and obtaining a Rest interface calling end signal, an event configuration result of the Rest interface to be stored and parameter information required by calling the Rest interface to be stored;

s033: responding to the Rest interface calling end signal, and associating the Rest interface identification to be recorded, the event configuration result of the Rest interface to be stored and the parameter information required by the Rest interface to be stored to obtain Rest interface calling test configuration data to be stored;

s034: and updating the configuration database according to the calling Rest interface test configuration data to be stored.

According to the embodiment, the RPA is called to record the simulation operation of calling the Rest interface before the step of obtaining the test configuration data of the calling Rest interface from the configuration database, and a foundation is provided for the follow-up automatic verification test of the calling Rest interface.

And for S031, a Rest interface test recording request sent by the user is obtained.

The Rest interface test recording request is a request for calling the RPA to call the recording of the Rest interface test.

The Rest interface identifier to be recorded refers to a Rest interface identifier for recording, which is required to call the Rest interface test, in the Rest interface test recording request.

For S032, responding to the Rest interface test recording request, calling the RPA simulation third-party software to call the Rest interface corresponding to the Rest interface identifier to be recorded, and sending a result of recording the Rest interface to be called by the software to be tested when the calling is finished; generating a Rest interface calling end signal according to the result of recording and calling the Rest interface, simulating an event in the calling of the Rest interface corresponding to the Rest interface identifier to be recorded by a third party software as an event configuration result of the Rest interface to be stored, and simulating parameter information used in the calling of the Rest interface corresponding to the Rest interface identifier to be recorded by the third party software as parameter information required by the calling of the Rest interface to be stored.

And for S033, responding to the calling Rest interface end signal, associating the Rest interface identifier to be recorded, the event configuration result of the Rest interface to be stored and the parameter information required by the calling Rest interface to be stored into a data record, and using the data record as the calling Rest interface test configuration data to be stored.

The test configuration data of the calling Rest interface to be stored is the test configuration data of the calling Rest interface which needs to be stored in the configuration database.

In an embodiment, the step of invoking the RPA to perform the abnormal verification test on the SQL script execution log according to the SQL script execution log test configuration data to obtain the abnormal verification test result of the SQL script execution log includes:

s41: calling the RPA to log in a target server according to the SQL script execution log test configuration data and enter an SQL execution log directory of the target server;

s42: calling the RPA to perform error search in a log file under the SQL execution log directory of the target server according to the SQL script execution log test configuration data to obtain an error search result;

s43: and when the error search result is empty, determining that the test result of the abnormal verification test result of the SQL script execution log is normal, otherwise, determining that the test result of the abnormal verification test result of the SQL script execution log is abnormal, and calling the RPA to capture the error search result to obtain error data of the abnormal verification test result of the SQL script execution log.

The embodiment realizes the automatic abnormal verification test of the SQL script execution log by the RPA, realizes the automatic operation of simulating the operation and maintenance personnel to execute the SQL script execution log and carry out error search, and improves the test efficiency; by automatically carrying out the abnormal verification test on the SQL script execution log, the time for carrying out error search on the SQL script execution log is saved for operation and maintenance personnel, and the working efficiency of the operation and maintenance personnel is improved.

And S41, calling the RPA to acquire a server for log storage from the SQL script execution log test configuration data, taking the server for log storage as a target server, and simulating operation and maintenance personnel to log in the target server and enter an SQL execution log directory of the target server.

And S42, calling the RPA to acquire an error search command from the SQL script execution log test configuration data, executing the error search command to search in a log file under an SQL execution log directory of the target server, and taking the searched data as an error search result.

For S43, when the error search result is empty, it means that no error is found in the log file in the SQL execution log directory of the target server, and at this time, it may be determined that the test result of the SQL script execution log abnormal verification test result is normal; when the error search result is not empty, the error is searched in the log file under the SQL execution log directory of the target server, at this time, the test result of the SQL script execution log abnormal verification test result needs to be determined to be abnormal, the RPA is called to capture the error search result, and the picture obtained by capturing the image is used as the error data of the SQL script execution log abnormal verification test result.

In an embodiment, before the step of obtaining the SQL script execution log test configuration data from the configuration database, the method further includes:

s041: acquiring an SQL script execution log test recording request, wherein the SQL script execution log test recording request carries an SQL script execution log identifier to be recorded;

s042: responding to the SQL script execution log test recording request, calling the RPA to perform an abnormal verification test on the SQL script execution log according to the to-be-recorded SQL script execution log identifier, and obtaining an abnormal verification test ending signal of the SQL script execution log, an event configuration result of the abnormal verification test on the to-be-stored SQL script execution log, and parameter information required by the abnormal verification test on the to-be-stored SQL script execution log;

s043: responding to an abnormal verification test ending signal of the SQL script execution log, and associating the SQL script execution log identifier to be recorded, the event configuration result of the abnormal verification test of the SQL script execution log to be stored and the parameter information required by the abnormal verification test of the SQL script execution log to be stored to obtain SQL script execution log test configuration data to be stored;

s044: and updating the configuration database according to the SQL script execution log test configuration data to be stored.

The embodiment realizes that the RPA is called to record the abnormal verification test of the SQL script execution log before the step of acquiring the SQL script execution log test configuration data from the configuration database, and provides a basis for automatically performing the abnormal verification test of the SQL script execution log subsequently.

And for the S041, acquiring an SQL script execution log test recording request sent by a user.

The SQL script execution log test recording request is a request for calling the RPA to record the abnormal verification test of the SQL script execution log.

The SQL script execution log mark to be recorded refers to the SQL script execution log mark recorded when the SQL script execution log test recording request needs to perform the abnormal verification test of the SQL script execution log.

For S042, responding to the SQL script execution log test recording request, calling the RPA simulation operation and maintenance personnel to perform error search on the SQL script execution log corresponding to the to-be-recorded SQL script execution log identifier, and obtaining a recording error search result when the search is finished; and generating an abnormal verification test ending signal of the SQL script execution log according to the recording error searching result, simulating an event in which an operation and maintenance person performs error searching on the SQL script execution log corresponding to the to-be-recorded SQL script execution log identifier as an event configuration result of the abnormal verification test of the to-be-stored SQL script execution log, and simulating parameter information used in the operation and maintenance person performs error searching on the SQL script execution log corresponding to the to-be-recorded SQL script execution log identifier as parameter information required by the abnormal verification test of the to-be-stored SQL script execution log.

And for S043, responding to an abnormal verification test ending signal of the SQL script execution log, associating the SQL script execution log identifier to be recorded, the event configuration result of the abnormal verification test of the SQL script execution log to be stored and the parameter information required by the abnormal verification test of the SQL script execution log to be stored into a data record, and taking the data record as the SQL script execution log test configuration data to be stored.

The SQL script execution log test configuration data to be stored is the SQL script execution log test configuration data which needs to be stored in the configuration database.

Referring to fig. 2, the present application proposes an RPA-based functional test environment verification apparatus, the apparatus including:

a request obtaining module 100, configured to obtain a verification test request of a functional test environment;

a flow process test module 200, configured to respond to the verification test request of the functional test environment, obtain flow process test configuration data from a configuration database, and invoke an RPA to perform a flow process test according to the flow process test configuration data to obtain a flow process test result;

a call Rest interface verification test module 300, configured to respond to the verification test request of the functional test environment, obtain call Rest interface test configuration data from the configuration database, and call the RPA to perform a call Rest interface verification test according to the call Rest interface test configuration data, so as to obtain a call Rest interface verification test result;

the abnormal verification test module 400 of the SQL script execution log is configured to respond to the verification test request of the functional test environment, obtain SQL script execution log test configuration data from the configuration database, and call the RPA to perform an abnormal verification test on the SQL script execution log according to the SQL script execution log test configuration data, so as to obtain an abnormal verification test result of the SQL script execution log;

and a report generation module 500, configured to generate a report according to the circulation flow test result, the call Rest interface verification test result, and the SQL script execution log exception verification test result, so as to obtain a target function test environment verification test report.

Referring to fig. 3, a computer device, which may be a server and whose internal structure may be as shown in fig. 3, is also provided in the embodiment of the present application. The computer device includes a processor, a memory, a network interface, and a database connected by a system bus. Wherein the computer designed processor is used to provide computational and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The database of the computer device is used for storing data such as a functional test environment verification method based on the RPA. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a method of RPA-based functional test environment validation. The functional test environment verification method based on the RPA comprises the following steps: acquiring a verification test request of a functional test environment; responding to the verification test request of the functional test environment, acquiring circulation flow test configuration data from a configuration database, and calling an RPA (resilient packet adapter) to perform circulation flow test according to the circulation flow test configuration data to obtain a circulation flow test result; responding to the verification test request of the function test environment, acquiring Rest interface calling test configuration data from the configuration database, and calling the RPA to perform Rest interface calling verification test according to the Rest interface calling test configuration data to obtain a Rest interface calling verification test result; responding to the verification test request of the functional test environment, acquiring SQL script execution log test configuration data from the configuration database, and calling the RPA to perform an abnormal verification test on the SQL script execution log according to the SQL script execution log test configuration data to obtain an abnormal verification test result of the SQL script execution log; and generating reports according to the circulation flow test result, the call Rest interface verification test result and the SQL script execution log abnormal verification test result to obtain a target function test environment verification test report.

An embodiment of the present application further provides a computer-readable storage medium, on which a computer program is stored, and the computer program, when executed by a processor, implements a method for verifying a functional test environment based on RPA, including the steps of: acquiring a verification test request of a functional test environment; responding to the verification test request of the functional test environment, acquiring circulation flow test configuration data from a configuration database, and calling an RPA (resilient packet adapter) to perform circulation flow test according to the circulation flow test configuration data to obtain a circulation flow test result; responding to the verification test request of the function test environment, acquiring Rest interface calling test configuration data from the configuration database, and calling the RPA to perform Rest interface calling verification test according to the Rest interface calling test configuration data to obtain a Rest interface calling verification test result; responding to the verification test request of the functional test environment, acquiring SQL script execution log test configuration data from the configuration database, and calling the RPA to perform an abnormal verification test on the SQL script execution log according to the SQL script execution log test configuration data to obtain an abnormal verification test result of the SQL script execution log; and generating reports according to the circulation flow test result, the call Rest interface verification test result and the SQL script execution log abnormal verification test result to obtain a target function test environment verification test report.

The executed RPA-based functional test environment verification method comprises the steps of calling the RPA to perform a flow process test according to flow process test configuration data to obtain a flow process test result, calling the RPA to perform a Rest interface verification test according to the Rest interface test configuration data to obtain a called Rest interface verification test result, calling the RPA to perform an SQL script execution log exception verification test according to the SQL script execution log test configuration data to obtain an SQL script execution log exception verification test result, performing report generation according to the flow process test result, the called Rest interface verification test result and the SQL script execution log exception verification test result to obtain a target functional test environment verification test report, thereby realizing the software environment verification test for automatically performing the functional test and shortening the time of the functional test, the probability of problems after the product is on line is reduced.

It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium provided herein and used in the examples may include non-volatile and/or volatile memory. Non-volatile memory can include read-only memory (ROM), Programmable ROM (PROM), Electrically Programmable ROM (EPROM), Electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), Dynamic RAM (DRAM), Synchronous DRAM (SDRAM), double-rate SDRAM (SSRSDRAM), Enhanced SDRAM (ESDRAM), synchronous link (Synchlink) DRAM (SLDRAM), Rambus Direct RAM (RDRAM), direct bus dynamic RAM (DRDRAM), and bus dynamic RAM (RDRAM).

It should be noted that, in this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, apparatus, article, or method that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, apparatus, article, or method. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, apparatus, article, or method that includes the element.

The above description is only a preferred embodiment of the present application, and not intended to limit the scope of the present application, and all modifications of equivalent structures and equivalent processes, which are made by the contents of the specification and the drawings of the present application, or which are directly or indirectly applied to other related technical fields, are also included in the scope of the present application.

Claims

1. A functional test environment verification method based on RPA is characterized by comprising the following steps:

acquiring a verification test request of a functional test environment;

2. The RPA-based functional test environment verification method according to claim 1, wherein before the step of obtaining the flow-through test configuration data from the configuration database, the method further comprises:

3. The RPA-based functional test environment verification method according to claim 2, wherein the step of invoking the RPA to perform a flow transfer simulation operation according to the flow transfer flow identifier to be recorded to obtain a flow transfer simulation operation end signal, an event configuration result of the flow transfer flow to be stored, and parameter information required to be used by the flow transfer flow to be stored includes:

acquiring a flow circulation flow exception handling strategy to be stored;

4. The RPA-based functional test environment verification method of claim 1, wherein said step of calling said RPA to perform a Rest interface verification test according to said Rest interface test configuration data to obtain a result of the Rest interface verification test comprises:

5. The RPA-based functional test environment verification method according to claim 1, wherein said step of obtaining the test configuration data calling the Rest interface from the configuration database further comprises:

6. The RPA-based functional test environment verification method of claim 1, wherein said step of invoking said RPA to perform an abnormal verification test of the SQL script execution log according to the SQL script execution log test configuration data to obtain an SQL script execution log abnormal verification test result includes:

7. The RPA-based functional test environment verification method according to claim 1, wherein said step of obtaining SQL script execution log test configuration data from said configuration database is preceded by the step of:

8. An RPA-based functional test environment verification apparatus, the apparatus comprising:

9. A computer device comprising a memory and a processor, the memory storing a computer program, wherein the processor implements the steps of the method of any one of claims 1 to 7 when executing the computer program.

10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 7.