CN112612695B - RPA-based functional test environment verification method, device, equipment and medium - Google Patents

RPA-based functional test environment verification method, device, equipment and medium Download PDF

Info

Publication number
CN112612695B
CN112612695B CN202011496955.2A CN202011496955A CN112612695B CN 112612695 B CN112612695 B CN 112612695B CN 202011496955 A CN202011496955 A CN 202011496955A CN 112612695 B CN112612695 B CN 112612695B
Authority
CN
China
Prior art keywords
test
rest interface
execution log
script execution
sql script
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN202011496955.2A
Other languages
Chinese (zh)
Other versions
CN112612695A (en
Inventor
蒋善东
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Guangdong Shuyuan Technology Co ltd
Shenzhen Lian Intellectual Property Service Center
Original Assignee
Guangdong Shuyuan Technology Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Guangdong Shuyuan Technology Co ltd filed Critical Guangdong Shuyuan Technology Co ltd
Priority to CN202011496955.2A priority Critical patent/CN112612695B/en
Publication of CN112612695A publication Critical patent/CN112612695A/en
Application granted granted Critical
Publication of CN112612695B publication Critical patent/CN112612695B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/36—Preventing errors by testing or debugging software
    • G06F11/3664—Environments for testing or debugging software
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/36—Preventing errors by testing or debugging software
    • G06F11/3668—Software testing
    • G06F11/3672—Test management
    • G06F11/3688—Test management for test execution, e.g. scheduling of test suites
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/36—Preventing errors by testing or debugging software
    • G06F11/3668—Software testing
    • G06F11/3672—Test management
    • G06F11/3692—Test management for test results analysis
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/10—File systems; File servers
    • G06F16/17—Details of further file system functions
    • G06F16/1734—Details of monitoring file system events, e.g. by the use of hooks, filter drivers, logs
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/242—Query formulation
    • G06F16/2433—Query languages

Abstract

The application relates to the technical field of artificial intelligence, and discloses a functional test environment verification method, device, equipment and medium based on RPA, wherein the method comprises the following steps: the RPA is called to carry out the circulation flow test according to the circulation flow test configuration data to obtain a circulation flow test result; the RPA is called to carry out the test for verifying the call Rest interface according to the test configuration data of the call Rest interface to obtain a test result for verifying the call Rest interface; the RPA is called to perform 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; and reporting according to the circulation flow test result, the Rest interface verification test result and the SQL script execution log exception verification test result to generate a target function test environment verification test report. The verification test of the software environment for automatically carrying out the function test is realized, and the time for the function test is shortened.

Description

RPA-based functional test environment verification method, device, equipment and medium
Technical Field
The application relates to the technical field of artificial intelligence, in particular to a functional test environment verification method, device, equipment and medium based on RPA.
Background
The development personnel in the prior art mainly have the efforts of writing codes, adding versions and environments, and easily neglecting the verification of the software environment before the functional test. Particularly, during production, on one hand, the function which is known to be unmodified by the lucky mind is generally free of problems, and on the other hand, the verification is mostly complicated and repeated, so that a developer is reluctant to use time in a software environment for verifying the function test, the time of the function test is prolonged, the problem can be caused after the product is on line, and the user experience is reduced.
Disclosure of Invention
The application mainly aims to provide a functional test environment verification method based on RPA, which aims to solve the technical problems that the prior art neglects to verify the software environment before functional test, so that the time of functional test is prolonged, and the problem after product on-line is possibly caused.
In order to achieve the above object, the present application provides a functional test environment verification method based on RPA, the method comprising:
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 (remote procedure access) 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 functional test environment, acquiring call Rest interface test configuration data from the configuration database, and calling the RPA to carry out call Rest interface verification test according to the call Rest interface test configuration data to obtain a call Rest interface 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 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;
and 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 to obtain a target function test environment verification test report.
Further, before the step of obtaining the configuration data of the flow process test 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 identifier to be recorded;
responding to the flow test recording request, calling the RPA to perform flow simulation operation according to the flow identifier to be recorded, and obtaining a flow simulation operation ending signal, an event configuration result of the flow to be stored and parameter information required to be used by the flow to be stored;
Responding to the flow circulation simulation operation ending signal, and associating the circulation flow identifier to be recorded, the event configuration result of the circulation flow to be stored and the parameter information required by the circulation flow to be stored to obtain circulation flow test configuration data to be stored;
and updating the configuration database according to the to-be-stored circulation flow test configuration data.
Further, the step of calling the RPA to perform a flow-to-flow simulation operation according to the to-be-recorded flow identifier to obtain a flow-to-flow simulation operation end signal, an event configuration result of a to-be-stored flow, and parameter information required by the to-be-stored flow, includes:
acquiring a circulation flow exception handling strategy to be stored;
and calling the RPA to perform flow simulation operation according to the flow identifier to be recorded and the flow exception handling strategy to be stored to obtain a flow simulation operation ending signal, an event configuration result of the flow to be stored and parameter information required by the flow 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:
Invoking the RPA to start a Postman tool according to the invoked Rest interface test configuration data;
the RPA is called to fill in request parameters in the Postman tool according to the call Rest interface test configuration data to obtain a target Postman tool;
the RPA is called to carry out request submitting operation on the target Postman tool according to the call Rest interface test configuration data, and the request submitting operation is used for calling a target Rest interface corresponding to a Rest interface identifier of the call Rest interface test configuration data;
acquiring a return value of the Http sent by the target Rest interface, and obtaining a return value of the 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 the call Rest interface verification test result is normal, otherwise, determining that the test result of the call Rest interface verification test result 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 call Rest interface verification test result.
Further, before the step of acquiring the call Rest interface test configuration data 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 for calling the Rest interface according to the Rest interface identifier to be recorded, and obtaining a Rest interface calling ending signal, an event configuration result of the Rest interface to be stored and parameter information required to be used by the Rest interface to be stored;
responding to the call Rest interface ending signal, and associating the Rest interface identifier to be recorded, the event configuration result of the Rest interface to be stored and the parameter information required to be used by the call Rest interface to be stored to obtain call Rest interface test configuration data to be stored;
and updating the configuration database according to the call Rest interface test configuration data to be stored.
Further, the step of calling the RPA to perform an exception 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 exception verification test result includes:
calling the RPA to log in a target server according to the SQL script execution log test configuration data and entering an SQL execution log catalog of the target server;
Calling the RPA to perform error searching 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 searching result;
and when the error searching result is empty, determining that the test result of the SQL script execution log exception verification test result is normal, otherwise, determining that the test result of the SQL script execution log exception verification test result is abnormal, and calling the RPA to perform screenshot on the error searching result to obtain error data of the SQL script execution log exception verification test result.
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 record request, calling the RPA to perform the exception verification test of the SQL script execution log according to the SQL script execution log mark to be recorded to obtain an exception verification test end signal of the SQL script execution log, an event configuration result of the exception verification test of the SQL script execution log to be stored and parameter information required by the exception verification test of the SQL script execution log to be stored;
Responding to an abnormal verification test ending signal of the SQL script execution log, and associating the SQL script execution log identification to be recorded, an event configuration result of the abnormal verification test of the SQL script execution log to be stored and 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 verification device based on RPA, which comprises:
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 functional test environment, acquiring circulation flow test configuration data from a configuration database, and calling an RPA (remote procedure access) to perform circulation flow test according to the circulation flow test configuration data to obtain a circulation flow test result;
the call Rest interface verification test module is used for responding to the verification test request of the functional test environment, acquiring call Rest interface test configuration data from the configuration database, and calling the RPA to carry out call Rest interface verification test according to the call Rest interface test configuration data to obtain a call 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 functional test environment, acquiring SQL script execution log test configuration data from the configuration database, and calling the RPA to perform 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;
and the report generating module is used for generating a report 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 application also proposes a computer device comprising a memory storing a computer program and a processor implementing the steps of any of the methods described above when the processor executes the computer program.
The application also proposes a computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, implements the steps of the method of any of the above.
According to the RPA-based function test environment verification method, device, equipment and medium, the RPA is called to conduct the circulation flow test according to the circulation flow test configuration data to obtain the circulation flow test result, the RPA is called to conduct the Rest interface verification test according to the Rest interface test configuration data to obtain the Rest interface verification test result, the RPA is called to conduct the abnormal verification test of the SQL script execution log according to the SQL script execution log test configuration data to obtain the SQL script execution log abnormal verification test result, and the report is generated according to the circulation flow test result, the Rest interface verification test result and the SQL script execution log abnormal verification test result to obtain the target function test environment verification test report, so that the verification test of the software environment for automatically conducting the function test is achieved, the time of the function test is shortened, and the probability of problems after the product is on line is reduced.
Drawings
FIG. 1 is a flow chart of an RPA-based functional test environment verification method according to an embodiment of the application;
FIG. 2 is a schematic block diagram of an RPA-based functional test environment verification device according to an embodiment of the present application;
fig. 3 is a schematic block diagram of a computer device according to an embodiment of the present application.
The achievement of the objects, functional features and advantages of the present application will be further described with reference to the accompanying drawings, in conjunction with the embodiments.
Detailed Description
The present application will be described in further detail with reference to the drawings and examples, in order to make the objects, technical solutions and advantages of the present application more apparent. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the application.
In order to solve the technical problems that the prior art ignores verification of a software environment before functional testing, which leads to prolonging the time of functional testing and possibly causing problems after products are on line, the application provides an RPA-based functional testing environment verification method, which is applied to the technical field of artificial intelligence. According to the RPA-based functional test environment verification method, the RPA is called to perform a circulation flow test, the Rest interface verification test and the abnormal verification test of the SQL script execution log, so that the verification test of the software environment for automatically performing the functional test is realized, the time of the functional test is shortened, and the probability of problems after the product is on line is reduced.
Referring to fig. 1, in an embodiment of the present application, there is provided a functional test environment verification method based on RPA, including:
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 (remote procedure access) 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 functional test environment, acquiring call Rest interface test configuration data from the configuration database, and calling the RPA to carry out call Rest interface verification test according to the call Rest interface test configuration data to obtain a call Rest interface 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 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;
s5: and 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 to obtain a target function test environment verification test report.
According to the method, the device and the system, the circulation flow test is conducted according to the circulation flow test configuration data by calling the RPA, the circulation flow test result is obtained, the Rest interface verification test is called by calling the RPA according to the Rest interface test configuration data, the Rest interface verification test result is obtained, the abnormal verification test of the SQL script execution log is conducted by calling the RPA according to the SQL script execution log test configuration data, the SQL script execution log abnormal verification test result is obtained, and report generation is conducted according to the circulation flow test result, the Rest interface verification test result and the SQL script execution log abnormal verification test result, and a target function test environment verification test report is obtained.
For S1, the verification test request of the functional test environment can be sent by a user, or can be actively triggered by the 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 of 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: and generating the verification test request of the functional test environment based on the deployment completion signal.
And S2, responding to the verification test request of the functional test environment, acquiring the circulation flow test configuration data from a configuration database of the database, calling the RPA to simulate the operation of calling the third party software to carry out the circulation flow according to the circulation flow test configuration data, and ending the circulation flow to obtain a circulation flow test result.
RPA (Robotic Process Automation, 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 a desired task. From current technical practices, existing RPAs are also only applicable to processes with high repeatability, logic determination, and relatively low stability requirements. For example, the RPA provides components for simulating human operations by using a mouse click event and a keyboard input event, and after the user composes the component layout, clicking operation is performed to achieve the effect of automatic operation.
The circulation flow test result comprises: the system comprises flow identifiers, flow nodes and flow test values, wherein each flow identifier corresponds to one or more flow nodes, and each flow node corresponds to one flow test value.
The flow identifier may be an identifier that uniquely identifies a flow, such as a flow ID, a flow name, etc. It will be appreciated that the number of approval processes is not particularly limited herein.
The circulation flow test configuration data includes: the method comprises the steps of circulation flow identification, flow node identification, event configuration results of the circulation flow and parameter information needed by the circulation flow.
And the flow process test is used for simulating the condition that the human operation third party software is used for testing the flow process of the third party software responding to the call request of the software to be tested.
The event configuration result of the circulation flow is the configuration result of the event which needs to be executed by the RPA in the circulation flow.
For example, the circulation flow L1 includes three common nodes (i.e. initiate-recheck-approval), the general flow is a client manager (initiate-approval flow, fill in flow information, select recheck processor, click to submit approval task), recheck processor (fill in user name password login system, enter the pending list of approval module to select approval task, select recheck opinion to be "agreeing", fill in other necessary input items, select approval processor, finally click to submit approval task to recheck result), the approval processor (input user name password login system, select approval opinion to be "agreeing", click to submit approval task, circulation flow state to be finished), RPA simulates related operations of client manager, recheck processor, approval processor, circulation flow test configuration data, flow node identification includes: the event configuration result of the circulation flow test configuration data comprises: event configuration results of a client manager (initiating an approval process, filling process information, selecting an approval handler, clicking and submitting), event configuration results of the approval handler (filling a user name password, entering a to-be-processed list of an approval module, selecting an approval task, selecting an approval opinion, filling other necessary items, selecting an approval handler to click and submit), event configuration results of the approval handler (filling a user name password, selecting an approval opinion, selecting an approval task, selecting an approval opinion, filling other necessary items, selecting an approval handler, clicking and submitting), parameter information required for a circulation process of the circulation process test configuration data includes: the customer manager (filled-in flow information), the review handler (filled-in user name and password, selected review opinion, filled-in other necessary entry), and the approval handler (entered user name and password, selected approval opinion), are not specifically limited herein by way of example.
Optionally, after the step of calling the RPA to perform the flow test according to the flow test configuration data to obtain the flow test result, the method further includes: acquiring mail sending rules of preset circulation flow results; 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 test result of the circulation flow is realized, and the communication time is reduced.
And S3, responding to the verification test request of the functional test environment, acquiring test configuration data of a call Rest interface from a configuration database of the database, and calling the RPA to simulate the operation of calling the Rest interface of the software to be tested by the third party software according to the test configuration data of the call Rest interface, and ending the call Rest interface to obtain a verification test result of the call Rest interface.
Invoking the Rest interface test configuration data includes: the Rest interface identification, the event configuration result of the Rest interface and the parameter information needed to call the Rest interface. The Rest interface identifier may be an identifier of a Rest interface that uniquely identifies the software to be tested, such as a Rest interface name, a Rest interface ID, or the like.
Rest, 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 calling the event which needs to be executed by the RPA in the Rest interface.
Invoking the Rest interface to verify the test result comprises: the test result comprises normal and abnormal data, wherein 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 Rest interface verification test by the RPA according to the Rest interface test configuration data to obtain a Rest interface verification test result, the method further includes: acquiring a preset call Rest interface verification mail sending rule; and sending the mail to the verification test result of the call Rest interface according to the preset verification mail sending rule of the call Rest interface. Therefore, the reminding of calling the Rest interface verification test result is automatically realized, 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 a database, calling an RPA to simulate operation and maintenance personnel to execute logs on the SQL script according to the SQL script execution log test configuration data and perform error searching operation, 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 method comprises the steps of marking an SQL script execution log, configuring an event result of an abnormality verification test of the SQL script execution log and using parameter information required by the abnormality 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 event configuration result 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 test result comprises normal and abnormal data, wherein 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 will be appreciated that steps S2 to S4 may be performed asynchronously in other orders, or may be performed synchronously, which is not particularly limited herein.
Optionally, after 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, the method further includes: acquiring a preset SQL script execution log verification mail sending rule; and sending the mail to the SQL script execution log abnormality verification test result according to the preset SQL script execution log verification mail sending rule. Therefore, the method and the device realize automatic reminding of the SQL script execution log abnormal verification test result, and reduce communication time.
And S5, placing the flow process test result, the call Rest interface verification test result and the SQL script execution log exception 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 the report according to the flow process test result, the call Rest interface verification test result and the SQL script execution log exception verification test result to obtain the target function test environment verification test report, the method further includes: acquiring a preset report sending rule; and transmitting the verification test report of the target function test environment by adopting the preset report transmitting rule. Therefore, the release of verification test reports of the target function test environment is automatically realized, and the communication time is reduced.
In one embodiment, before the step of obtaining the configuration data of the flow process test 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 identifier to be recorded;
s022: responding to the flow test recording request, calling the RPA to perform flow simulation operation according to the flow identifier to be recorded, and obtaining a flow simulation operation ending signal, an event configuration result of the flow to be stored and parameter information required to be used by the flow to be stored;
S023: responding to the flow circulation simulation operation ending signal, and associating the circulation flow identifier to be recorded, the event configuration result of the circulation flow to be stored and the parameter information required by the circulation flow to be stored to obtain circulation flow test configuration data to be stored;
s024: and updating the configuration database according to the to-be-stored circulation flow test configuration data.
The embodiment realizes that the RPA is called to carry out the circulation flow test recording before the step of acquiring the circulation flow test configuration data from the configuration database, and provides a basis for the follow-up automatic circulation flow test.
And for S021, acquiring a flow test recording request sent by a user.
The recording request of the circulation flow test is a request for calling the RPA to record the circulation flow test.
The to-be-recorded flow process identifier refers to a recorded flow process identifier of a flow process test required to be performed by a flow process test recording request.
S022, responding to the transfer flow test recording request, calling the RPA simulator to call a flow transfer operation of third-party software for the transfer flow corresponding to the transfer flow identifier to be recorded, and sending a recording flow transfer result by the third-party software when the flow transfer operation is finished; and generating a flow circulation simulation operation ending signal according to the recording flow circulation result, and taking an event in the flow circulation operation of calling the third-party software by the simulator on the circulation flow corresponding to the circulation flow identifier to be recorded as an event configuration result of the circulation flow to be stored, wherein the parameter information used in the flow circulation operation of calling the third-party software by the simulator on the circulation flow corresponding to the circulation flow identifier to be recorded is taken as the parameter information required by the circulation flow to be stored.
And for S023, responding to the flow simulation operation ending signal, correlating the flow identifier to be recorded, the event configuration result of the flow to be stored and the parameter information needed by the flow to be stored into a data record, and taking the data record as flow test configuration data to be stored.
The flow test configuration data to be stored is flow test configuration data to be stored in the configuration database.
In one embodiment, the step of calling the RPA to perform a flow-to-flow simulation operation according to the to-be-recorded flow identifier to obtain a flow-to-flow simulation operation end signal, an event configuration result of a to-be-stored flow, and parameter information required to be used by the to-be-stored flow includes:
s0221: acquiring a circulation flow exception handling strategy to be stored;
s0222: and calling the RPA to perform flow simulation operation according to the flow identifier to be recorded and the flow exception handling strategy to be stored to obtain a flow simulation operation ending signal, an event configuration result of the flow to be stored and parameter information required by the flow to be stored.
According to the method and the device for testing and recording the flow, the flow test recording is carried out based on the flow abnormal processing strategy to be stored, so that RPA can be called to carry out automatic processing when the flow is abnormal, manual processing by a person is avoided, the degree of automation of the method and the device is improved, and the accuracy of a target function test environment verification test report is improved.
For S0221, the to-be-stored flow exception handling policy input by the user may be obtained, or the to-be-stored flow exception handling policy sent by the third party software may be obtained.
And the to-be-stored abnormal flow processing strategy, namely the to-be-recorded abnormal flow processing strategy of the flow corresponding to the flow identifier. Flow anomaly handling policies include, but are not limited to: the method comprises a circulation flow identifier, a flow node identifier, an event configuration result of circulation flow exception handling and an exception handling mode. The event configuration result of the circulation flow exception handling is the configuration result of the event which needs to be executed by the RPA when the circulation flow is abnormal. The exception handling means include, but are not limited to: neglecting, screenshot, retrying according to a preset retry rule. Retry according to a preset retry rule includes, but is not limited to: and after waiting for the preset time, retrying, and after retrying for preset times, neglecting and prompting according to preset information if normal execution is not possible.
For S0222, in response to the request for testing and recording the flow process, invoking the RPA simulator to invoke a flow process simulation operation of third party software on the flow process corresponding to the flow process identifier to be recorded, when the flow process is abnormal, adopting the flow process abnormality processing strategy to be stored to process, and when the flow process simulation operation is finished, the third party software will send a flow process result; 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 the third-party software by a simulator on the circulation flow corresponding to the circulation flow identifier to be recorded as an event configuration result of the circulation flow to be stored, and taking parameter information used in the flow circulation simulation operation of calling the third-party software by the simulator on the circulation flow corresponding to the circulation flow identifier to be recorded as parameter information needed by the circulation flow to be stored.
In the process of calling the RPA to perform the flow simulation operation, unexpected situations may occur, for example, abnormal situations such as overtime of website opening time, expiration of user password, etc., and at this time, the operation needs to be performed according to the to-be-stored flow abnormal processing strategy by calling the RPA.
In one embodiment, 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:
s311: invoking the RPA to start a Postman tool according to the invoked Rest interface test configuration data;
s312: the RPA is called to fill in request parameters in the Postman tool according to the call Rest interface test configuration data to obtain a target Postman tool;
s313: the RPA is called to carry out request submitting operation on the target Postman tool according to the call Rest interface test configuration data, and the request submitting operation is used for calling a target Rest interface corresponding to a Rest interface identifier of the call Rest interface test configuration data;
s314: acquiring a return value of the Http sent by the target Rest interface, and obtaining a return value of the 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 the call Rest interface verification test result is normal, otherwise, determining that the test result of the call Rest interface verification test result 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 call Rest interface verification test result.
The embodiment realizes the automation of simulating the third party software to call the Rest interface of the software to be tested, and improves the testing efficiency.
For S311, invoking the RPA simulates third party software to launch a Postman tool according to the invoke Rest interface test configuration data.
And for S312, calling the RPA to select a request type of get request, filling in a user name and a password and filling in an interface call address in the Postman tool according to the call Rest interface test configuration data, and obtaining a target Postman tool after filling in.
And for S313, calling the RPA to click a submit button on the target Postman tool according to the call Rest interface test configuration data so as to perform request submit operation (a simulator clicks the submit button on third party software), thereby enabling the target Postman tool to log in the software to be tested according to the request parameters.
And for S314, acquiring a return value of the Http transmitted by the target Rest interface of the software to be tested, and taking the acquired return value of the Http as the return value of the Http to be judged.
For S315, for example, the interface call address is www.student.com/getStudent and the parameter stuno=20, the request submitting operation sends the student number StuNo to the corresponding target Rest interface identifier of the call Rest interface test configuration data, when the target Rest interface is expected to return the student basic information, when the return code of the return value of Http to be judged is 200, it is indicated that the target Rest interface is normal, the target Rest interface can normally provide services, and in the body part of the return value of Http to be judged, JSON format text content is displayed, which is not limited in detail herein.
In one embodiment, before the step of obtaining the call Rest interface test configuration data 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 for calling the Rest interface according to the Rest interface identifier to be recorded, and obtaining a Rest interface calling ending signal, an event configuration result of the Rest interface to be stored and parameter information required to be used by the Rest interface to be stored;
s033: responding to the call Rest interface ending signal, and associating the Rest interface identifier to be recorded, the event configuration result of the Rest interface to be stored and the parameter information required to be used by the call Rest interface to be stored to obtain call Rest interface test configuration data to be stored;
s034: and updating the configuration database according to the call Rest interface test configuration data to be stored.
The embodiment realizes the recording of the simulation operation of calling the Rest interface by calling the RPA before the step of obtaining the test configuration data of calling the Rest interface from the configuration database, and provides a basis for the follow-up automation of the verification test of calling the Rest interface.
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 RPA to carry out recording for calling Rest interface test.
The to-be-recorded Rest interface identifier refers to a Rest interface identifier of a record for which a Rest interface test recording request needs to be called.
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 identification to be recorded, and when the call is ended, the software to be tested sends a result of recording and calling the Rest interface; and generating a call Rest interface ending signal according to the recording call Rest interface result, simulating an event in the process that the third party software calls the Rest interface corresponding to the Rest interface identifier to be recorded as an event configuration result of the Rest interface to be stored, and simulating parameter information used in the process that the third party software calls the Rest interface corresponding to the Rest interface identifier to be recorded as parameter information needed to be used by the Rest interface to be stored.
And for S033, responding to the call Rest interface ending 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 to be used by the call Rest interface to be stored into a data record, and taking the data record as call Rest interface test configuration data to be stored.
The call Rest interface test configuration data to be stored is call Rest interface test configuration data which needs to be stored in a configuration database.
In one embodiment, the step of calling the RPA to perform an exception verification test of the SQL script execution log according to the SQL script execution log test configuration data to obtain an exception 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 entering an SQL execution log catalog of the target server;
s42: calling the RPA to perform error searching 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 searching result;
s43: and when the error searching result is empty, determining that the test result of the SQL script execution log exception verification test result is normal, otherwise, determining that the test result of the SQL script execution log exception verification test result is abnormal, and calling the RPA to perform screenshot on the error searching result to obtain error data of the SQL script execution log exception verification test result.
The embodiment realizes the automatic abnormal verification test of the SQL script execution log by the RPA, realizes the automatic operation of simulating the SQL script execution log by an operation and maintenance personnel and carrying out error searching, and improves the test efficiency; by automatically carrying out the abnormal verification test of the SQL script execution log, the time for carrying out error searching 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, simulating an operation and maintenance person to log in the target server and entering an SQL execution log catalog of the target server.
And S42, calling the RPA to acquire an error searching command from the SQL script execution log test configuration data, searching the error searching command in a log file under the SQL execution log directory of the target server, and taking the searched data as an error searching result.
For S43, when the error lookup result is null, it means that no error is found in the log file under 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 exception verification test result is normal; when the error searching result is not empty, the error is searched in the log file under the SQL execution log directory of the target server, at the moment, the test result of the SQL script execution log exception verification test result is required to be determined to be abnormal, the RPA is called to perform screenshot on the error searching result, and the picture obtained by screenshot is taken as error data of the SQL script execution log exception verification test result.
In one 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 record request, calling the RPA to perform the exception verification test of the SQL script execution log according to the SQL script execution log mark to be recorded to obtain an exception verification test end signal of the SQL script execution log, an event configuration result of the exception verification test of the SQL script execution log to be stored and parameter information required by the exception verification test of the SQL script execution log to be stored;
s043: responding to an abnormal verification test ending signal of the SQL script execution log, and associating the SQL script execution log identification to be recorded, an event configuration result of the abnormal verification test of the SQL script execution log to be stored and 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 the record of the abnormal verification test of the SQL script execution log by calling the RPA before the step of acquiring the SQL script execution log test configuration data from the configuration database, and provides a basis for the subsequent automatic abnormal verification test of the SQL script execution log.
For S041, acquiring an SQL script execution log test recording request sent by a user.
The SQL script execution log test record request is a request for calling the RPA to conduct record of the abnormal verification test of the SQL script execution log.
The SQL script execution log identification to be recorded refers to the recorded SQL script execution log identification of the SQL script execution log test record request requiring 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 searching on the SQL script execution log corresponding to the SQL script execution log identification to be recorded, and obtaining a recording error searching result when searching is finished; and generating an abnormal verification test ending signal of the SQL script execution log according to the recorded error searching result, wherein an event in error searching of the SQL script execution log corresponding to the SQL script execution log mark to be recorded is used as an event configuration result of the abnormal verification test of the SQL script execution log to be stored by a simulation operation and maintenance personnel, and parameter information used in error searching of the SQL script execution log corresponding to the SQL script execution log mark to be recorded is used as parameter information required by the abnormal verification test of the SQL script execution log to be stored by the simulation operation and maintenance personnel.
And for S043, responding to an abnormal verification test ending signal of the SQL script execution log, associating the SQL script execution log identification to be recorded, an event configuration result of the abnormal verification test of the SQL script execution log to be stored and 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 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 application proposes a functional test environment verification device based on RPA, the device comprising:
a request acquisition module 100, configured to acquire a verification test request of a functional test environment;
the circulation flow test module 200 is configured to respond to the verification test request of the functional test environment, obtain circulation flow test configuration data from a configuration database, and call RPA to perform circulation flow test according to the circulation flow test configuration data, so as to obtain a circulation flow test result;
the call Rest interface verification test module 300 is configured to obtain call Rest interface test configuration data from the configuration database in response to the verification test request of the functional test environment, and call the RPA to perform 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 exception verification test module 400 of the SQL script execution log is configured to obtain SQL script execution log test configuration data from the configuration database in response to the verification test request of the functional test environment, and call the RPA to perform exception 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 exception verification test result;
and the report generating module 500 is configured to generate a report according to the flow process 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.
According to the method, the device and the system, the circulation flow test is conducted according to the circulation flow test configuration data by calling the RPA, the circulation flow test result is obtained, the Rest interface verification test is called by calling the RPA according to the Rest interface test configuration data, the Rest interface verification test result is obtained, the abnormal verification test of the SQL script execution log is conducted by calling the RPA according to the SQL script execution log test configuration data, the SQL script execution log abnormal verification test result is obtained, and report generation is conducted according to the circulation flow test result, the Rest interface verification test result and the SQL script execution log abnormal verification test result, and a target function test environment verification test report is obtained.
Referring to fig. 3, in an embodiment of the present application, there is further provided a computer device, which may be a server, and an internal structure thereof may be as shown in fig. 3. The computer device includes a processor, a memory, a network interface, and a database connected by a system bus. Wherein the computer is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, computer programs, and a database. The memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The database of the computer equipment is used for storing data such as the RPA-based functional test environment verification method and the like. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program, when executed by a processor, implements a RPA-based functional test environment verification method. The RPA-based functional test environment verification method 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 (remote procedure access) 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 functional test environment, acquiring call Rest interface test configuration data from the configuration database, and calling the RPA to carry out call Rest interface verification test according to the call Rest interface test configuration data to obtain a call Rest interface 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 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; and 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 to obtain a target function test environment verification test report.
According to the method, the device and the system, the circulation flow test is conducted according to the circulation flow test configuration data by calling the RPA, the circulation flow test result is obtained, the Rest interface verification test is called by calling the RPA according to the Rest interface test configuration data, the Rest interface verification test result is obtained, the abnormal verification test of the SQL script execution log is conducted by calling the RPA according to the SQL script execution log test configuration data, the SQL script execution log abnormal verification test result is obtained, and report generation is conducted according to the circulation flow test result, the Rest interface verification test result and the SQL script execution log abnormal verification test result, and a target function test environment verification test report is obtained.
An embodiment of the present application further provides a computer-readable storage medium having stored thereon a computer program which, when executed by a processor, implements a RPA-based functional test environment verification method, 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 (remote procedure access) 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 functional test environment, acquiring call Rest interface test configuration data from the configuration database, and calling the RPA to carry out call Rest interface verification test according to the call Rest interface test configuration data to obtain a call Rest interface 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 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; and 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 to obtain a target function test environment verification test report.
According to the method for verifying the functional test environment based on the RPA, the RPA is called to conduct the circulation process test according to the circulation process test configuration data to obtain a circulation process test result, the RPA is called to conduct the 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 conduct the 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, and report generation is conducted according to the circulation 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, so that verification test of a software environment for automatically conducting functional test is achieved, time of functional test is shortened, and probability of occurrence of problems after product online is reduced.
Those skilled in the art will appreciate that implementing all or part of the above described methods may be accomplished by way of a computer program stored on a non-transitory computer readable storage medium, which when executed, may comprise the steps of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium provided by the present application and used in embodiments may include non-volatile and/or volatile memory. The nonvolatile 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), dual speed data rate SDRAM (SSRSDRAM), enhanced SDRAM (ESDRAM), synchronous Link DRAM (SLDRAM), memory bus direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM), among others.
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 one … …" does not exclude the presence of other like elements in a process, apparatus, article or method that comprises the element.
The foregoing description is only of the preferred embodiments of the present application and is not intended to limit the scope of the application, and all equivalent structures or equivalent processes using the descriptions and drawings of the present application or directly or indirectly applied to other related technical fields are included in the scope of the application.

Claims (8)

1. An RPA-based functional test environment verification method, the method comprising:
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 (remote procedure access) 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 functional test environment, acquiring call Rest interface test configuration data from the configuration database, and calling the RPA to carry out call Rest interface verification test according to the call Rest interface test configuration data to obtain a call Rest interface 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 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;
report generation is carried out 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 a target function test environment verification test report is obtained;
before the step of obtaining the configuration data of the circulation flow test from the configuration database, the method further comprises the following steps:
acquiring a circulation flow test recording request, wherein the circulation flow test recording request carries a circulation flow identifier to be recorded;
responding to the flow test recording request, calling the RPA to perform flow simulation operation according to the flow identifier to be recorded, and obtaining a flow simulation operation ending signal, an event configuration result of the flow to be stored and parameter information required to be used by the flow to be stored;
Responding to the flow circulation simulation operation ending signal, and associating the circulation flow identifier to be recorded, the event configuration result of the circulation flow to be stored and the parameter information required by the circulation flow to be stored to obtain circulation flow test configuration data to be stored;
updating the configuration database according to the to-be-stored circulation flow test configuration data;
the step of calling the RPA to carry out the test for verifying the call Rest interface according to the test configuration data of the call Rest interface to obtain the test result for verifying the call Rest interface comprises the following steps:
invoking the RPA to start a Postman tool according to the invoked Rest interface test configuration data;
the RPA is called to fill in request parameters in the Postman tool according to the call Rest interface test configuration data to obtain a target Postman tool;
the RPA is called to carry out request submitting operation on the target Postman tool according to the call Rest interface test configuration data, and the request submitting operation is used for calling a target Rest interface corresponding to a Rest interface identifier of the call Rest interface test configuration data;
acquiring a return value of the Http sent by the target Rest interface, and obtaining a return value of the 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 the call Rest interface verification test result is normal, otherwise, determining that the test result of the call Rest interface verification test result 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 call Rest interface verification test result.
2. The method for verifying a functional test environment based on RPA according to claim 1, wherein the step of calling the RPA to perform a flow-to-flow simulation operation according to the to-be-recorded flow identifier to obtain a flow-to-flow simulation operation end signal, an event configuration result of a to-be-stored flow, and parameter information required to be used by the to-be-stored flow, includes:
acquiring a circulation flow exception handling strategy to be stored;
and calling the RPA to perform flow simulation operation according to the flow identifier to be recorded and the flow exception handling strategy to be stored to obtain a flow simulation operation ending signal, an event configuration result of the flow to be stored and parameter information required by the flow to be stored.
3. The RPA-based functional test environment verification method of claim 1, further comprising, prior to the step of retrieving call Rest interface test configuration data from the configuration database:
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 for calling the Rest interface according to the Rest interface identifier to be recorded, and obtaining a Rest interface calling ending signal, an event configuration result of the Rest interface to be stored and parameter information required to be used by the Rest interface to be stored;
responding to the call Rest interface ending signal, and associating the Rest interface identifier to be recorded, the event configuration result of the Rest interface to be stored and the parameter information required to be used by the call Rest interface to be stored to obtain call Rest interface test configuration data to be stored;
and updating the configuration database according to the call Rest interface test configuration data to be stored.
4. The RPA-based functional test environment verification method according to claim 1, wherein the step of calling the RPA to perform an exception 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 exception verification test result comprises:
Calling the RPA to log in a target server according to the SQL script execution log test configuration data and entering an SQL execution log catalog of the target server;
calling the RPA to perform error searching 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 searching result;
and when the error searching result is empty, determining that the test result of the SQL script execution log exception verification test result is normal, otherwise, determining that the test result of the SQL script execution log exception verification test result is abnormal, and calling the RPA to perform screenshot on the error searching result to obtain error data of the SQL script execution log exception verification test result.
5. The RPA-based functional test environment verification method according to claim 1, further comprising, prior to the step of obtaining SQL script execution log test configuration data from the configuration database:
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 record request, calling the RPA to perform the exception verification test of the SQL script execution log according to the SQL script execution log mark to be recorded to obtain an exception verification test end signal of the SQL script execution log, an event configuration result of the exception verification test of the SQL script execution log to be stored and parameter information required by the exception verification test of the SQL script execution log to be stored;
responding to an abnormal verification test ending signal of the SQL script execution log, and associating the SQL script execution log identification to be recorded, an event configuration result of the abnormal verification test of the SQL script execution log to be stored and 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.
6. An RPA-based functional test environment verification device for implementing the method of any one of claims 1 to 5, the device comprising:
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 functional test environment, acquiring circulation flow test configuration data from a configuration database, and calling an RPA (remote procedure access) to perform circulation flow test according to the circulation flow test configuration data to obtain a circulation flow test result;
the call Rest interface verification test module is used for responding to the verification test request of the functional test environment, acquiring call Rest interface test configuration data from the configuration database, and calling the RPA to carry out call Rest interface verification test according to the call Rest interface test configuration data to obtain a call 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 functional test environment, acquiring SQL script execution log test configuration data from the configuration database, and calling the RPA to perform 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;
and the report generating module is used for generating a report 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.
7. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor implements the steps of the method of any one of claims 1 to 5 when the computer program is executed.
8. A computer readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the steps of the method of any of claims 1 to 5.
CN202011496955.2A 2020-12-17 2020-12-17 RPA-based functional test environment verification method, device, equipment and medium Active CN112612695B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202011496955.2A CN112612695B (en) 2020-12-17 2020-12-17 RPA-based functional test environment verification method, device, equipment and medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202011496955.2A CN112612695B (en) 2020-12-17 2020-12-17 RPA-based functional test environment verification method, device, equipment and medium

Publications (2)

Publication Number Publication Date
CN112612695A CN112612695A (en) 2021-04-06
CN112612695B true CN112612695B (en) 2023-09-15

Family

ID=75241012

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202011496955.2A Active CN112612695B (en) 2020-12-17 2020-12-17 RPA-based functional test environment verification method, device, equipment and medium

Country Status (1)

Country Link
CN (1) CN112612695B (en)

Families Citing this family (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113127370A (en) * 2021-05-14 2021-07-16 中国工商银行股份有限公司 Report system smoking test method, RPA robot and system
CN115022314B (en) * 2022-04-24 2024-02-20 中银金融科技有限公司 Enterprise-level RPA cloud management platform
CN114900445B (en) * 2022-04-28 2024-04-16 北京百度网讯科技有限公司 Flow recording method and device and electronic equipment

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107766236A (en) * 2017-09-21 2018-03-06 平安科技（深圳）有限公司 Test assignment automatic management method, apparatus, equipment and storage medium
CN109828903A (en) * 2018-12-14 2019-05-31 中国平安人寿保险股份有限公司 Automated testing method, device, computer installation and storage medium
CN110209586A (en) * 2019-06-04 2019-09-06 苏州浪潮智能科技有限公司 A kind of automatic software test method based on artificial intelligence, terminal and storage medium

Family Cites Families (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US10705948B2 (en) * 2017-10-30 2020-07-07 Bank Of America Corporation Robotic process automation simulation of environment access for application migration
US11527324B2 (en) * 2017-11-10 2022-12-13 Reliant Immune Diagnostics, Inc. Artificial intelligence response system based on testing with parallel/serial dual microfluidic chip
US10606687B2 (en) * 2017-12-04 2020-03-31 Bank Of America Corporation Process automation action repository and assembler
US11314627B2 (en) * 2018-04-20 2022-04-26 Sap Se Test automation system for distributed heterogenous environments
WO2020252081A1 (en) * 2019-06-10 2020-12-17 Argos Labs Inc. Systems and methods for robotic process automation

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107766236A (en) * 2017-09-21 2018-03-06 平安科技（深圳）有限公司 Test assignment automatic management method, apparatus, equipment and storage medium
CN109828903A (en) * 2018-12-14 2019-05-31 中国平安人寿保险股份有限公司 Automated testing method, device, computer installation and storage medium
CN110209586A (en) * 2019-06-04 2019-09-06 苏州浪潮智能科技有限公司 A kind of automatic software test method based on artificial intelligence, terminal and storage medium

Also Published As

Publication number Publication date
CN112612695A (en) 2021-04-06

Similar Documents

Publication Publication Date Title
CN112612695B (en) RPA-based functional test environment verification method, device, equipment and medium
CN109101430B (en) Test method, device and equipment
CN111563051A (en) Crawler-based data verification method and device, computer equipment and storage medium
CN112199300A (en) Interface testing method and device, electronic equipment and storage medium
CN112667499A (en) Page component testing method and device, computer equipment and storage medium
CN112395202A (en) Interface automation test method and device, computer equipment and storage medium
CN113126955A (en) Random data generation method and device, intelligent terminal and storage medium
CN112637282B (en) Information pushing method and device, computer equipment and storage medium
CN112612706A (en) Automated testing method, computer device and storage medium
CN112000582A (en) Server-side automatic test early warning method, device, equipment and storage medium
CN109445758B (en) Data processing method, device, computer equipment and storage medium
CN114633898B (en) Measurement method, device, equipment and medium for attitude adjustment of aircraft component
CN113672497B (en) Method, device and equipment for generating non-buried point event and storage medium
CN117131545A (en) Data processing method and device, storage medium and terminal
CN115033481A (en) Method and device for automatic test code generation based on browser access and computer equipment
CN113886262A (en) Software automation test method and device, computer equipment and storage medium
CN110517010B (en) Data processing method, system and storage medium
CN114661745A (en) Recruitment information publishing method and device based on RPA and AI
CN113064917A (en) Data query method and device, computer equipment and storage medium
CN113285915A (en) Registration management method and device and private cloud control server
CN112882922B (en) Test method and related device
CN111651429B (en) Big data scheduling parameter management method, device and distributed platform
CN114116520B (en) Algorithm evaluation method, device, gateway and storage medium
CN116975395B (en) Error feedback data processing method, device, equipment and medium
CN117632768A (en) Server testing method, device, equipment and storage medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
TA01 Transfer of patent application right

Effective date of registration: 20230822

Address after: Units 01, 07, and 08, 02/F, Building 3, No. 11 Spectral Middle Road, Huangpu District, Guangzhou City, Guangdong Province, 510700

Applicant after: Guangdong Shuyuan Technology Co.,Ltd.

Address before: 518000 Room 202, block B, aerospace micromotor building, No.7, Langshan No.2 Road, Xili street, Nanshan District, Shenzhen City, Guangdong Province

Applicant before: Shenzhen LIAN intellectual property service center

Effective date of registration: 20230822

Address after: 518000 Room 202, block B, aerospace micromotor building, No.7, Langshan No.2 Road, Xili street, Nanshan District, Shenzhen City, Guangdong Province

Applicant after: Shenzhen LIAN intellectual property service center

Address before: 518000 Room 201, building A, No. 1, Qian Wan Road, Qianhai Shenzhen Hong Kong cooperation zone, Shenzhen, Guangdong (Shenzhen Qianhai business secretary Co., Ltd.)

Applicant before: PING AN PUHUI ENTERPRISE MANAGEMENT Co.,Ltd.

TA01 Transfer of patent application right
GR01 Patent grant
GR01 Patent grant