CN113052463B - Workflow verification method, workflow verification device, computer equipment and storage medium - Google Patents
Workflow verification method, workflow verification device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN113052463B CN113052463B CN202110319728.0A CN202110319728A CN113052463B CN 113052463 B CN113052463 B CN 113052463B CN 202110319728 A CN202110319728 A CN 202110319728A CN 113052463 B CN113052463 B CN 113052463B
- Authority
- CN
- China
- Prior art keywords
- verification
- data
- workflow
- database
- baseline
- 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
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0633—Workflow analysis
-
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Theoretical Computer Science (AREA)
- Quality & Reliability (AREA)
- Economics (AREA)
- Entrepreneurship & Innovation (AREA)
- General Physics & Mathematics (AREA)
- Strategic Management (AREA)
- Physics & Mathematics (AREA)
- Educational Administration (AREA)
- Operations Research (AREA)
- Tourism & Hospitality (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- Game Theory and Decision Science (AREA)
- Development Economics (AREA)
- Computer Hardware Design (AREA)
- General Engineering & Computer Science (AREA)
- Debugging And Monitoring (AREA)
Abstract
The invention relates to the field of data processing, and discloses a workflow verification method, a workflow verification device, computer equipment and a storage medium, wherein the workflow verification method comprises the following steps: acquiring baseline entry data from a workflow management platform by receiving a verification request comprising workflow items, test code data and verification files, and simultaneously acquiring a test environment system; generating an independent environment system according to the code data and the test environment system; recording baseline database-falling data of baseline workflow execution baseline parameter entering data under a test environment system, simultaneously recording new database-falling data of new workflow execution baseline parameter entering data under an independent environment system, and recording database-falling data to be verified of new workflow execution newly added parameter entering data; performing verification processing through a data verification model to obtain a verification result; and outputting and displaying a verification report according to the verification result. The invention realizes automatic verification workflow and outputs verification report, avoids regression test, and reduces the cost of manual verification.
Description
Technical Field
The present invention relates to the field of data processing of big data, and in particular, to a workflow verification method, a workflow verification device, a computer device, and a storage medium.
Background
Currently, various fields have business systems including various workflows, such as a leave-request approval process, an attendance approval process, a credit card application auditing process, a loan application auditing process, and the like; and the workflow of the business system can change, add and delete nodes along with the change or the new demand of the business flow. In the prior art, the secondary development is usually carried out on the bottom workflow engine to realize the change or the new increase of the business process, the interface test of each node is needed to be carried out on the changed workflow after the development is completed, the database record is needed to be queried manually, whether the database record accords with expectations is judged manually so as to complete the verification of the workflow, the regression test is also needed in the verification process, the labor cost of the regression test is very time-consuming and huge, the verification period of the whole workflow is very long, the efficiency is low, the labor input cost is high, and the risk of human verification errors is high.
Disclosure of Invention
The workflow verification method, the workflow verification device, the workflow verification computer equipment and the workflow verification storage medium provided by the invention realize verification processing through the data verification model and can automatically output verification reports, so that regression tests are avoided, the cost of manual verification is reduced, the risk of verification omission is avoided, and the verification accuracy and efficiency are improved.
A workflow verification method, comprising:
receiving a verification request, and acquiring workflow items, test code data and verification files in the verification request; the test code data comprises newly added parameter data and code data;
acquiring baseline entry data corresponding to the workflow item from a workflow management platform, and simultaneously acquiring a test environment system corresponding to the workflow item, wherein the test environment system comprises a baseline workflow corresponding to the workflow item;
generating an independent environment system according to the code data and the test environment system; the independent environment system comprises a new version of workflow corresponding to the workflow item;
inputting the baseline entry parameter data into the baseline workflow, recording baseline database data of the baseline workflow for executing the baseline entry data, inputting the baseline entry parameter data into the new workflow, recording new database data of the new workflow for executing the baseline entry data, inputting the new entry parameter data into the new workflow, and recording database data to be verified of the new workflow for executing the new entry data;
Performing verification processing on the baseline database data, the new version database data, the database data to be verified and the verification file through the data verification model to obtain a verification result output by the data verification model;
and outputting and displaying a verification report according to the verification result.
A workflow verification apparatus comprising:
the receiving module is used for receiving the verification request and acquiring workflow items, test code data and verification files in the verification request; the test code data comprises newly added parameter data and code data;
the system comprises an acquisition module, a workflow management platform and a workflow management module, wherein the acquisition module is used for acquiring baseline entry parameter data corresponding to the workflow item from the workflow management platform and simultaneously acquiring a test environment system corresponding to the workflow item, and the test environment system comprises a baseline workflow corresponding to the workflow item;
the generating module is used for generating an independent environment system according to the code data and the test environment system; the independent environment system comprises a new version of workflow corresponding to the workflow item;
the input module is used for inputting the baseline entry parameter data into the baseline workflow, recording baseline database falling data of the baseline workflow for executing the baseline entry data, inputting the baseline entry parameter data into the new workflow, recording new database falling data of the new workflow for executing the baseline entry data, inputting the new entry parameter data into the new workflow, and recording database falling data to be verified of the new workflow for executing the new entry data;
The verification module is used for carrying out verification processing on the baseline database data, the new version database data, the database data to be verified and the verification file through the data verification model to obtain a verification result output by the data verification model;
and the output module is used for outputting and displaying a verification report according to the verification result.
A computer device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, the processor implementing the steps of the workflow verification method described above when the computer program is executed.
A computer readable storage medium storing a computer program which, when executed by a processor, performs the steps of the workflow verification method described above.
The workflow verification method, the workflow verification device, the computer equipment and the storage medium provided by the invention acquire workflow items, test code data and verification files in a verification request by receiving the verification request; the test code data comprises newly added parameter data and code data; acquiring baseline entry data corresponding to the workflow item from a workflow management platform, and simultaneously acquiring a test environment system corresponding to the workflow item, wherein the test environment system comprises a baseline workflow corresponding to the workflow item; generating an independent environment system according to the code data and the test environment system; the independent environment system comprises a new version of workflow corresponding to the workflow item; inputting the baseline entry parameter data into the baseline workflow, recording baseline database data of the baseline workflow for executing the baseline entry data, inputting the baseline entry parameter data into the new workflow, recording new database data of the new workflow for executing the baseline entry data, inputting the new entry parameter data into the new workflow, and recording database data to be verified of the new workflow for executing the new entry data; performing verification processing on the baseline database data, the new version database data, the database data to be verified and the verification file through the data verification model to obtain a verification result output by the data verification model; and outputting and displaying a verification report according to the verification result.
Thus, the invention realizes that by receiving a verification request containing a workflow item, test code data and a verification file, the baseline entry parameter data corresponding to the workflow item is obtained from a workflow management platform, and a test environment system corresponding to the workflow item is obtained at the same time; generating an independent environment system according to the code data and the test environment system; recording baseline database-falling data of the baseline parameter-entering data executed by a baseline workflow under the test environment system, simultaneously recording new database-falling data of the baseline parameter-entering data executed by a new workflow under the independent environment system, and recording database-falling data to be verified of the newly added parameter-entering data executed by the new workflow; performing verification processing on the baseline database data, the new version database data, the database data to be verified and the verification file through the data verification model to obtain a verification result output by the data verification model; according to the verification result, a verification report is output and displayed, so that an independent environment system is generated through mirroring, the data verification model is used for verifying the same baseline database data and the new database data which are respectively output by the baseline workflow and the new workflow, whether the new workflow is compatible with and meets the current baseline workflow is determined, and the data verification model is used for verifying the baseline database data, the database data to be verified and the verification file, so that the verification report can be automatically output, the regression test is avoided, the cost of manual verification is reduced, the risk of verification omission is avoided, and the verification accuracy and efficiency are improved.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings that are needed in the description of the embodiments of the present invention will be briefly described below, it being obvious that the drawings in the following description are only some embodiments of the present invention, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a schematic view of an application environment of a workflow verification method according to an embodiment of the invention;
FIG. 2 is a flow chart of a workflow verification method in an embodiment of the invention;
FIG. 3 is a flowchart of step S30 of a workflow verification method in an embodiment of the invention;
FIG. 4 is a flowchart of step S50 of a workflow verification method in an embodiment of the invention;
FIG. 5 is a flowchart of step S501 of a workflow verification method in an embodiment of the invention;
FIG. 6 is a flowchart of step S503 of a workflow verification method in an embodiment of the invention;
FIG. 7 is a flowchart of step S504 of a workflow verification method in an embodiment of the invention;
FIG. 8 is a functional block diagram of a workflow verification apparatus in an embodiment of the invention;
FIG. 9 is a schematic diagram of a computer device in accordance with an embodiment of the invention.
Detailed Description
The following description of the embodiments of the present invention will be made clearly and fully with reference to the accompanying drawings, in which it is evident that the embodiments described are some, but not all embodiments of the invention. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
The workflow verification method provided by the invention can be applied to an application environment as shown in fig. 1, wherein a client (computer equipment) communicates with a server through a network. Among them, clients (computer devices) include, but are not limited to, personal computers, notebook computers, smartphones, tablet computers, cameras, and portable wearable devices. The server may be implemented as a stand-alone server or as a server cluster composed of a plurality of servers.
In one embodiment, as shown in fig. 2, a workflow verification method is provided, and the technical scheme mainly includes the following steps S10-S60:
s10, receiving a verification request, and acquiring workflow items, test code data and verification files in the verification request; the test code data includes newly added parameter data and code data.
The verification request is understandably generated by performing verification trigger on a workflow corresponding to the workflow item, namely, a developer is required to develop the workflow, and triggers the verification request after the workflow item, the test code data and the verification file corresponding to the workflow are determined, for example, after a verification approval process, a checking attendance approval process, a credit card application verification process, a loan application verification process and the like are performed on the development of the verification edition, the workflow item is the item name of the workflow required to be verified, the item name of the workflow is unique, the test code data is a code file set related to the workflow item upgrade, the test code data comprises newly added reference data and code data, the newly added reference data is input into the input workflow written in a newly added node or variable in the workflow of the verification upgrade, the newly added reference data can be started from the beginning, the newly added reference data can also be written in the corresponding node or the verification file, the newly added reference data is the newly added reference code data, the newly added reference code data is the newly added reference code file is the newly added, and the newly added reference code file is input into the corresponding to the workflow, and the newly added reference code file is added in the verification file is the standard file, and the newly added reference code file is added, and the code file is added to the reference file is added, and the standard file is added to the standard file is added.
S20, acquiring baseline entry data corresponding to the workflow item from a workflow management platform, and simultaneously acquiring a test environment system corresponding to the workflow item, wherein the test environment system comprises a baseline workflow corresponding to the workflow item.
The workflow management platform is capable of managing all workflow items and storing all baseline entry data corresponding to each workflow item and the test environment system, wherein the baseline entry data is entry data corresponding to the workflow item under a current business system, the entry data is input parameters (input workflow) written for verifying the workflow, the baseline entry data is entry parameter data for verifying the workflow under the test environment system, and the test environment system comprises the baseline workflow corresponding to the workflow item, and the baseline workflow is a workflow for executing the workflow item for the current business system.
S30, generating an independent environment system according to the code data and the test environment system; the independent environment system includes a new version of workflow corresponding to the workflow item.
Understandably, the system identical to the test environment system is completely copied by the mirror image technology, the code data is deployed in the mirror image generating system to obtain the independent environment system, the independent environment system is a system for upgrading the workflow corresponding to the workflow item, the independent environment system comprises the new version workflow corresponding to the workflow item, and the new version workflow is the workflow to be verified after upgrading.
In one embodiment, as shown in fig. 3, in the step S30, that is, generating an independent environment system according to the code data and the test environment system, the method includes:
s301, mirroring the test environment system to generate a to-be-processed environment system.
It can be understood that the environment system to be processed, which is the same as the test environment system, is copied by a mirroring technology, wherein the mirroring technology is a technology of generating an item to be copied by mirroring through a mirrored warehouse (Harbor) of a Docker container, using a copy mirroring function in the Docker container technology, centering on the item, and configuring a copy policy for the item.
In an embodiment, in the step S301, the mirroring the test environment system to generate a pending environment system includes:
S3011, installing a mirror image warehouse installation package in the Docker container, and setting a mirror image warehouse configuration to deploy the mirror image warehouse.
Understandably, the Docker container is a container already deployed in the workflow management platform.
S3012, marking the test environment system as a source item through the mirror warehouse, and generating a copy instruction corresponding to the test environment system.
S3013, executing the copying instruction through the mirror warehouse, and carrying out mirror copying on the test environment system to obtain the environment system to be processed.
The environment system to be processed is a system which is identical to the test environment system by copying by using a copy mirror function in the Docker container technology, and the processing procedure of the mirror copy is a procedure of copying by using a copy mirror function in the Docker container technology. S302, deploying the code data into the environment system to be processed to obtain an independent environment system.
Understandably, the deploying process is to install the new plug-in the code data, then find a folder corresponding to the workflow item, and migrate the up-conversion code file in the code data to the found folder, thereby generating the independent environment system.
The environment system to be processed and the test environment system have the same file structure, namely the environment system to be processed and the test environment system have the same folder and files under the folder.
In this way, the test environment system and the independent environment system can be separated independently, and the independent environment system is a system deployed on the test environment system, so that the influence of the environment system on the test result can be reduced.
The invention realizes that the environment system to be processed is generated by mirroring the test environment system; the code data is deployed into the environment system to be processed to obtain an independent environment system, so that the independent environment system is quickly and accurately built through a mirror image technology and a deployment method, the building period of the independent environment system is shortened, the code data is separated from a test environment system, the influence of environments is avoided, convenience is provided for subsequent verification operation, the verification period is shortened, and the verification complexity is reduced.
S40, inputting the baseline entry parameter data into the baseline workflow, recording baseline database falling data of the baseline workflow for executing the baseline entry data, simultaneously inputting the baseline entry parameter data into the new version workflow, recording new database falling data of the new version workflow for executing the baseline entry data, inputting the new entry parameter data into the new version workflow, and recording database falling data to be verified of the new version workflow for executing the new entry data.
The method comprises the steps of inputting the baseline input parameters into the baseline workflow, updating a data table in a database under the test environment system according to each node passing through the baseline workflow, triggering interfaces corresponding to each node and responding, recording all updated and responded data, generating baseline database data, wherein the baseline database data comprises a set of all databases under the test environment system and interfaces corresponding to each response, inputting the baseline input parameters into the new version workflow, updating the data table in the database under the independent environment system according to each node passing through the new version workflow, triggering interfaces corresponding to each node and responding, recording all updated and responded data, generating new version database data, and judging whether the baseline database meets the requirement of the baseline workflow by the baseline database and the new version workflow or not according to the same baseline input parameters.
S50, checking the base line database data, the new version database data, the database data to be checked and the checking file through the data checking model to obtain a checking result output by the data checking model.
The data verification model can be used for realizing automatic verification of the baseline database data, the new version database data and the verification file, outputting a verification result, the data verification model comprises a first comparison model, a second comparison model and a verification model, the baseline database data and the new version database data are compared through the first comparison model to obtain a first comparison result, the comparison method can be set according to requirements, whether the first comparison result is qualified or not is judged, namely whether the baseline database data and the new version database data are completely consistent after white list processing, if the first comparison result is qualified, the second comparison model is used for comparing the baseline database data and the to-be-verified database data to obtain a second comparison result, the second comparison result is checked with the verification file through the verification model, the comparison method is used for checking whether the baseline database data and the new version database data are qualified or not, and then the comparison result is combined, and the first comparison result is obtained.
In an embodiment, as shown in fig. 4, in step S50, the verifying the baseline database data, the new version database data, the database data to be verified and the verification file by the data verification model to obtain a verification result output by the data verification model includes:
s501, comparing the baseline database data with the new version database data through a first comparison model to obtain a first comparison result; the data verification model includes the first comparison model, a second comparison model, and a verification model.
The first comparison model is a database comparison tool, such as a compare tool of an oracle database, compares the baseline database data with the new version database data, outputs the comparison result of the baseline database data and the new version database data in a report form, determines the report as a first difference result in a text format or an XML format, and filters the first difference result to determine the first comparison result, wherein the first comparison result comprises a qualified test and a unqualified test.
Wherein the data verification model comprises the first comparison model, a second comparison model and a verification model.
In an embodiment, as shown in fig. 5, in step S501, that is, the comparing, by using a first comparison model, the baseline database data with the new version database data to obtain a first comparison result includes:
s5011, comparing the baseline database data with the new version database data through the first comparison model to obtain a first difference result.
Understandably, the comparison model is used to compare the baseline database data with the new version database data by using a compare tool of the oracle database, and one comparison is performed between each database and database table in the baseline database data and each database and database table in the new version database data, so that the first difference result can be compared, and the first difference result indicates the data difference between the baseline database data and the new version database data.
S5012, performing white list processing on the first difference result through the first comparison model to obtain a filtering result.
The method may be a complete match, i.e. a complete match with the fields listed in the whitelist, and the preset whitelist may be a set of fields in the baseline database data except for the running water and the automatically generated fields, so that only the fields useful for comparison results in the first difference result are focused on, and the filtering result is generated.
S5013, determining the first comparison result according to the filtering result.
Understandably, if the filtering result does not include any field, indicating that there is no data with a difference, the first comparison result is qualified for testing, and if the filtering result includes any field, the first comparison result is unqualified for testing.
The invention realizes that the baseline database data and the new version database data are compared through the first comparison model to obtain a first difference result; performing white list processing on the first difference result through the first comparison model to obtain a filtering result; and determining the first comparison result according to the filtering result, so that a first difference result is obtained by comparing the baseline database data with the new version database data, filtering the filtered result by a white list technology, and determining the first comparison result according to whether a difference field exists in the filtered result.
S502, judging whether the first comparison result is qualified or not.
And S503, when the first comparison result is detected to be qualified in test, comparing the baseline database data with the database data to be verified through the second comparison model to obtain a second comparison result.
Understandably, if the first comparison result is detected to be qualified, the baseline database data and the database to be verified are compared through two comparison models, the second comparison model is a model for comparing a database and a database table, the second comparison model uses a database comparison tool, such as a comparison tool of an oracle database, to compare the baseline database data and the database to be verified, the comparison result of the baseline database data and the database to be verified is output in a report form, the format of the report can be a text format or an XML format, the report is determined to be a second difference result, the second difference result is filtered to determine that the second comparison result is qualified and unqualified.
In an embodiment, as shown in fig. 6, in step S503, that is, the comparing, by the second comparison model, the baseline database data with the database data to be verified to obtain a second comparison result includes:
s5031, comparing the baseline database data with the database data to be verified through the second comparison model to obtain a second difference result.
Understandably, the comparison of the baseline database data and the database to be verified is performed by using the compare tool of the oracle database through the second comparison module, and each database and database table in the baseline database data and each database and database table in the database to be verified are compared, so that the second difference result can be compared, and the second difference result indicates the data difference between the baseline database data and the database to be verified.
S5032, carrying out blacklist processing on the second difference result through the second comparison model to obtain the second comparison result.
The blacklist processing is an operation process of listing redundant or invalid fields as a preset blacklist, removing the fields listed in the preset blacklist from the result, and removing the fields listed in the preset blacklist from the second difference result, where the preset blacklist may be a field set of fields automatically generated by running water and a known system, and the second difference result remaining after the blacklist processing is determined as the second comparison result.
The invention realizes that the baseline database data and the database data to be verified are compared through the second comparison model to obtain a second difference result; and carrying out blacklist processing on the second difference result through the second comparison model to obtain the second comparison result, so that redundant or invalid fields are removed by using the blacklist technology, and the second comparison result is determined, thereby avoiding interference of the redundant or invalid fields on the verification result.
S504, inputting the second comparison result and the verification file into the verification model, and checking the second comparison result and the verification file through the verification model to obtain a checking result.
The verification model can be used for verifying the second comparison result according to the verification file, outputting a verification result model, wherein the verification process is to judge whether each database field in the second comparison result is completely consistent with each attribute item in the verification file through the verification model, and under the condition that the database fields are consistent with each attribute item in the verification file, matching the attribute values corresponding to the database fields with the attribute ranges corresponding to the attribute items consistent with the database fields through the verification model to obtain verification values corresponding to the database fields, and determining whether the verification result is qualified according to the sum of all the verification values.
In an embodiment, as shown in fig. 7, in step S504, the checking the second comparison result with the verification document by the verification model to obtain a checking result includes:
s5041, judging whether all database fields in the second comparison result are completely consistent with all attribute items in the verification file or not through the verification model; the second comparison result comprises a database field and an attribute value corresponding to the database field; the verification file comprises attribute items and attribute ranges corresponding to the attribute items.
The second comparison result includes the database field and the attribute value corresponding to the database field, where the database field is a field of a difference between the baseline database and the database to be verified, the attribute value is a value given to the database field, whether each database field in the second comparison result is consistent with the attribute item of the euro crown in the verification file is judged by the verification model, the verification file includes the attribute item and an attribute range corresponding to the attribute item, the attribute item is a field expected after the workflow is up-scaled, and the attribute range is a qualified reference range determined for the attribute item according to development requirements, that is, the attribute item is qualified in the reference range.
And S5042, if each database field in the second comparison result is completely consistent with the attribute item in the verification file, matching the attribute value corresponding to the database field with the attribute range corresponding to the attribute item consistent with the database field through the verification model to obtain a verification value corresponding to the database field.
It is understood that when each of the database fields and each of the attribute items are completely identical, matching, by the verification model, an attribute value corresponding to the database field with an attribute range corresponding to the attribute item identical to the database field, determining whether each of the attribute values is within the attribute range corresponding thereto, and determining the verification value corresponding to the attribute value, that is, the verification value corresponding to the database field, according to a deviation between the attribute value and a center of the attribute range corresponding thereto.
In an embodiment, in step S5042, the matching, by the verification model, the attribute value corresponding to the database field and the attribute range corresponding to the attribute item consistent with the database field to obtain the verification value corresponding to the database field includes:
And S50421, judging whether the attribute value corresponding to the database field is matched with the attribute range corresponding to the attribute item consistent with the database field through the verification model.
It is understood that the attribute range may be a numerical range or a conditional range (including a conditional requirement range).
And S50422, if the attribute value is matched with the attribute range, determining the verification value corresponding to the database field as a qualified value.
It is understood that the matching method may be set according to requirements, such as text matching, numerical matching, conditional matching, and the like, and the qualification value is a value of deviation between the attribute value and the center of the attribute range corresponding thereto.
S50423, if the attribute value does not match the attribute range, determining that the verification value corresponding to the database field is an unsuitable value.
Understandably, in the case where the mismatch value is a mismatch, a negative infinity value is given.
The invention realizes that whether the attribute value corresponding to the database field is matched with the attribute range corresponding to the attribute item consistent with the database field or not is judged by the verification model; if the attribute value is matched with the attribute range, determining that the verification value corresponding to the database field is a qualified value; if the attribute value is not matched with the attribute range, determining that the verification value corresponding to the database field is an unsuitable value, so that matching through a verification model is realized, the verification value corresponding to the database field can be rapidly identified, and the identification efficiency is improved.
S5043, determining the verification result based on the verification values corresponding to the database fields.
It is understood that, according to the sum of all the verification values, whether the verification result is verified is determined to be qualified, that is, whether the sum of all the verification values is greater than or equal to a preset threshold value is determined, and if the sum of all the verification values is greater than or equal to the preset threshold value, the verification result is determined to be verified to be qualified.
The invention realizes that whether each database field in the second comparison result is completely consistent with each attribute item in the verification file or not is judged through the verification model; each database field in the second comparison result is completely consistent with the attribute item in the verification file, and the verification value corresponding to the database field is obtained by matching the attribute value corresponding to the database field with the attribute range corresponding to the attribute item consistent with the database field through the verification model; and determining the checking result according to the checking values corresponding to the database fields, so that each checking value is determined through a checking model, and the checking result is automatically output according to all the checking values, thereby improving the checking efficiency, reducing the cost of manual checking and improving the checking accuracy.
S505, determining the first comparison result and the check result as the verification result.
Understandably, the first comparison result and the collation result are combined into the verification result.
The invention realizes that the baseline database data is compared with the new version database data through a first comparison model to obtain a first comparison result; when the first comparison result is detected to be qualified in test, comparing the baseline database data with the database data to be verified through the second comparison model to obtain a second comparison result; inputting the second comparison result and the verification file into the verification model, and checking the second comparison result and the verification file through the verification model to obtain a checking result; the first comparison result and the check result are determined to be the check result, so that whether the new version of workflow is compatible with and meets the current baseline workflow can be rapidly and accurately judged through the first comparison result, the difference between the second comparison result and the check file can be identified through the check model, the check result is determined finally, the regression test is avoided, the cost of manual check is reduced, the risk of the check is avoided, and the accuracy and efficiency are improved.
And S60, outputting and displaying a verification report according to the verification result.
Understandably, the verification result indicates whether the verification request is verified, that is, whether the test code data of the workflow item is upgraded passes verification, the verification result is analyzed to output the verification report, and the verification report is displayed on an interface, wherein the analysis process is to perform data tracking analysis on the first comparison result and the verification result in the verification result, output each index of verification, and the verification report is a report of a set of each index of verification.
The invention realizes that the workflow item, the test code data and the verification file in the verification request are obtained by receiving the verification request; the test code data comprises newly added parameter data and code data; acquiring baseline entry data corresponding to the workflow item from a workflow management platform, and simultaneously acquiring a test environment system corresponding to the workflow item, wherein the test environment system comprises a baseline workflow corresponding to the workflow item; generating an independent environment system according to the code data and the test environment system; the independent environment system comprises a new version of workflow corresponding to the workflow item; inputting the baseline entry parameter data into the baseline workflow, recording baseline database data of the baseline workflow for executing the baseline entry data, inputting the baseline entry parameter data into the new workflow, recording new database data of the new workflow for executing the baseline entry data, inputting the new entry parameter data into the new workflow, and recording database data to be verified of the new workflow for executing the new entry data; performing verification processing on the baseline database data, the new version database data, the database data to be verified and the verification file through the data verification model to obtain a verification result output by the data verification model; and outputting and displaying a verification report according to the verification result.
Thus, the invention realizes that by receiving a verification request containing a workflow item, test code data and a verification file, the baseline entry parameter data corresponding to the workflow item is obtained from a workflow management platform, and a test environment system corresponding to the workflow item is obtained at the same time; generating an independent environment system according to the code data and the test environment system; recording baseline database-falling data of the baseline parameter-entering data executed by a baseline workflow under the test environment system, simultaneously recording new database-falling data of the baseline parameter-entering data executed by a new workflow under the independent environment system, and recording database-falling data to be verified of the newly added parameter-entering data executed by the new workflow; performing verification processing on the baseline database data, the new version database data, the database data to be verified and the verification file through the data verification model to obtain a verification result output by the data verification model; according to the verification result, a verification report is output and displayed, so that an independent environment system is generated through mirroring, the data verification model is used for verifying the same baseline database data and the new database data which are respectively output by the baseline workflow and the new workflow, whether the new workflow is compatible with and meets the current baseline workflow is determined, and the data verification model is used for verifying the baseline database data, the database data to be verified and the verification file, so that the verification report can be automatically output, the regression test is avoided, the cost of manual verification is reduced, the risk of verification omission is avoided, and the verification accuracy and efficiency are improved.
In one embodiment, a workflow verification apparatus is provided, which corresponds to the workflow verification method in the above embodiment one by one. As shown in fig. 8, the workflow verification apparatus includes a receiving module 11, an acquiring module 12, a generating module 13, an input module 14, a verification module 15, and an output module 16. The functional modules are described in detail as follows:
the receiving module 11 is used for receiving a verification request and acquiring workflow items, test code data and verification files in the verification request; the test code data comprises newly added parameter data and code data;
an obtaining module 12, configured to obtain baseline entry parameter data corresponding to the workflow item from a workflow management platform, and obtain a test environment system corresponding to the workflow item, where the test environment system includes a baseline workflow corresponding to the workflow item;
a generating module 13, configured to generate an independent environment system according to the code data and the test environment system; the independent environment system comprises a new version of workflow corresponding to the workflow item;
an input module 14, configured to input the baseline entry parameter data into the baseline workflow, record baseline database dropping data of the baseline workflow for executing the baseline entry data, input the baseline entry parameter data into the new workflow, record new database dropping data of the new workflow for executing the baseline entry data, and input the new entry parameter data into the new workflow, record database dropping data to be verified of the new workflow for executing the new entry data;
The verification module 15 is configured to perform verification processing on the baseline database data, the new version database data, the database data to be verified and the verification file through the data verification model, and obtain a verification result output by the data verification model;
and the output module 16 is used for outputting and displaying a verification report according to the verification result.
For specific limitations of the workflow verification apparatus, reference may be made to the above limitations of the workflow verification method, and no further description is given here. The various modules in the workflow verification apparatus described above may be implemented in whole or in part by software, hardware, and combinations thereof. The above modules may be embedded in hardware or may be independent of a processor in the computer device, or may be stored in software in a memory in the computer device, so that the processor may call and execute operations corresponding to the above modules.
In one embodiment, a computer device is provided, which may be a server, and the internal structure of which may be as shown in fig. 9. The computer device includes a processor, a memory, a network interface, and a database connected by a system bus. Wherein the processor of the computer device 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 internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. 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 workflow verification method.
In one embodiment, a computer device is provided that includes a memory, a processor, and a computer program stored on the memory and executable on the processor, the processor implementing the workflow verification method of the above embodiments when the computer program is executed by the processor.
In one embodiment, a computer readable storage medium is provided, on which a computer program is stored, which when executed by a processor implements the workflow verification method of the above embodiments.
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 used in embodiments provided herein 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), double Data Rate SDRAM (DDRSDRAM), 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 will be apparent to those skilled in the art that, for convenience and brevity of description, only the above-described division of the functional units and modules is illustrated, and in practical application, the above-described functional distribution may be performed by different functional units and modules according to needs, i.e. the internal structure of the apparatus is divided into different functional units or modules to perform all or part of the above-described functions.
The above embodiments are only for illustrating the technical solution of the present invention, and not for limiting the same; although the invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present invention, and are intended to be included in the scope of the present invention.
Claims (8)
1. A workflow verification method, comprising:
receiving a verification request, and acquiring workflow items, test code data and verification files in the verification request; the test code data comprises newly added parameter data and code data;
Acquiring baseline entry data corresponding to the workflow item from a workflow management platform, and simultaneously acquiring a test environment system corresponding to the workflow item, wherein the test environment system comprises a baseline workflow corresponding to the workflow item;
generating an independent environment system according to the code data and the test environment system; the independent environment system comprises a new version of workflow corresponding to the workflow item;
inputting the baseline entry parameter data into the baseline workflow, recording baseline database data of the baseline workflow for executing the baseline entry data, inputting the baseline entry parameter data into the new workflow, recording new database data of the new workflow for executing the baseline entry data, inputting the new entry parameter data into the new workflow, and recording database data to be verified of the new workflow for executing the new entry data;
performing verification processing on the baseline database data, the new version database data, the database data to be verified and the verification file through a data verification model to obtain a verification result output by the data verification model;
Outputting and displaying a verification report according to the verification result;
the step of performing verification processing on the baseline database data, the new version database data, the database data to be verified and the verification file through the data verification model to obtain a verification result output by the data verification model, comprises the following steps:
comparing the baseline database data with the new version database data through a first comparison model to obtain a first comparison result; the data verification model comprises the first comparison model, a second comparison model and a verification model;
judging whether the first comparison result is qualified or not;
when the first comparison result is detected to be qualified in test, comparing the baseline database data with the database data to be verified through the second comparison model to obtain a second comparison result;
inputting the second comparison result and the verification file into the verification model, and checking the second comparison result and the verification file through the verification model to obtain a checking result;
determining the first comparison result and the verification result as the verification result;
and checking the second comparison result with the verification file through the verification model to obtain a checking result, wherein the checking result comprises the following steps of:
Judging whether all database fields in the second comparison result are completely consistent with all attribute items in the verification file or not through the verification model; the second comparison result comprises a database field and an attribute value corresponding to the database field; the verification file comprises attribute items and attribute ranges corresponding to the attribute items;
if all the database fields in the second comparison result are completely consistent with the attribute items in the verification file, matching the attribute values corresponding to the database fields with the attribute ranges corresponding to the attribute items consistent with the database fields through the verification model to obtain verification values corresponding to the database fields;
and determining the checking result according to the checking values corresponding to the database fields.
2. The workflow verification method of claim 1, wherein the generating an independent environment system from the code data and the test environment system comprises:
mirroring the test environment system to generate an environment system to be processed;
and deploying the code data into the environment system to be processed to obtain an independent environment system.
3. The workflow verification method of claim 1, wherein comparing the baseline database data with the new version of database data by a first comparison model, results in a first comparison result, comprises:
Comparing the baseline database data with the new version database data through the first comparison model to obtain a first difference result;
performing white list processing on the first difference result through the first comparison model to obtain a filtering result;
and determining the first comparison result according to the filtering result.
4. The workflow verification method of claim 1, wherein comparing the baseline database data with the database data to be verified by the second comparison model to obtain a second comparison result comprises:
comparing the baseline database data with the database data to be verified through the second comparison model to obtain a second difference result;
and carrying out blacklist processing on the second difference result through the second comparison model to obtain the second comparison result.
5. The workflow verification method as claimed in claim 4, wherein said matching, by said verification model, the attribute value corresponding to said database field and the attribute range corresponding to said attribute item consistent with said database field to obtain the verification value corresponding to the database field comprises:
judging whether an attribute value corresponding to the database field is matched with an attribute range corresponding to the attribute item consistent with the database field through the verification model;
If the attribute value is matched with the attribute range, determining that the verification value corresponding to the database field is a qualified value;
and if the attribute value is not matched with the attribute range, determining that the verification value corresponding to the database field is an unsuitable value.
6. A workflow verification apparatus, comprising:
the receiving module is used for receiving the verification request and acquiring workflow items, test code data and verification files in the verification request; the test code data comprises newly added parameter data and code data;
the system comprises an acquisition module, a workflow management platform and a workflow management module, wherein the acquisition module is used for acquiring baseline entry parameter data corresponding to the workflow item from the workflow management platform and simultaneously acquiring a test environment system corresponding to the workflow item, and the test environment system comprises a baseline workflow corresponding to the workflow item;
the generating module is used for generating an independent environment system according to the code data and the test environment system; the independent environment system comprises a new version of workflow corresponding to the workflow item;
the input module is used for inputting the baseline entry parameter data into the baseline workflow, recording baseline database falling data of the baseline workflow for executing the baseline entry data, inputting the baseline entry parameter data into the new workflow, recording new database falling data of the new workflow for executing the baseline entry data, inputting the new entry parameter data into the new workflow, and recording database falling data to be verified of the new workflow for executing the new entry data;
The verification module is used for carrying out verification processing on the baseline database data, the new version database data, the database data to be verified and the verification file through a data verification model to obtain a verification result output by the data verification model;
the output module is used for outputting and displaying a verification report according to the verification result;
the verification module is further configured to:
comparing the baseline database data with the new version database data through a first comparison model to obtain a first comparison result; the data verification model comprises the first comparison model, a second comparison model and a verification model;
judging whether the first comparison result is qualified or not;
when the first comparison result is detected to be qualified in test, comparing the baseline database data with the database data to be verified through the second comparison model to obtain a second comparison result;
inputting the second comparison result and the verification file into the verification model, and checking the second comparison result and the verification file through the verification model to obtain a checking result;
determining the first comparison result and the verification result as the verification result;
And checking the second comparison result with the verification file through the verification model to obtain a checking result, wherein the checking result comprises the following steps of:
judging whether all database fields in the second comparison result are completely consistent with all attribute items in the verification file or not through the verification model; the second comparison result comprises a database field and an attribute value corresponding to the database field; the verification file comprises attribute items and attribute ranges corresponding to the attribute items;
if all the database fields in the second comparison result are completely consistent with the attribute items in the verification file, matching the attribute values corresponding to the database fields with the attribute ranges corresponding to the attribute items consistent with the database fields through the verification model to obtain verification values corresponding to the database fields;
and determining the checking result according to the checking values corresponding to the database fields.
7. A computer device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, characterized in that the processor implements the workflow verification method according to any one of claims 1 to 5 when executing the computer program.
8. A computer readable storage medium storing a computer program, characterized in that the computer program, when executed by a processor, implements the workflow verification method of any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110319728.0A CN113052463B (en) | 2021-03-25 | 2021-03-25 | Workflow verification method, workflow verification device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110319728.0A CN113052463B (en) | 2021-03-25 | 2021-03-25 | Workflow verification method, workflow verification device, computer equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113052463A CN113052463A (en) | 2021-06-29 |
| CN113052463B true CN113052463B (en) | 2023-09-26 |
Family
ID=76515685
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110319728.0A Active CN113052463B (en) | 2021-03-25 | 2021-03-25 | Workflow verification method, workflow verification device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113052463B (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110851351A (en) * | 2019-10-12 | 2020-02-28 | 深圳壹账通智能科技有限公司 | Deployment environment testing method and device, computer equipment and storage medium |
| CN111563051A (en) * | 2020-07-16 | 2020-08-21 | 平安国际智慧城市科技股份有限公司 | Crawler-based data verification method and device, computer equipment and storage medium |
| CN111679965A (en) * | 2020-04-23 | 2020-09-18 | 平安国际智慧城市科技股份有限公司 | Automatic testing method and device, computer equipment and storage medium |
| CN112363929A (en) * | 2020-11-10 | 2021-02-12 | 中国平安人寿保险股份有限公司 | System online method and device, computer equipment and storage medium |
-
2021
- 2021-03-25 CN CN202110319728.0A patent/CN113052463B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110851351A (en) * | 2019-10-12 | 2020-02-28 | 深圳壹账通智能科技有限公司 | Deployment environment testing method and device, computer equipment and storage medium |
| CN111679965A (en) * | 2020-04-23 | 2020-09-18 | 平安国际智慧城市科技股份有限公司 | Automatic testing method and device, computer equipment and storage medium |
| CN111563051A (en) * | 2020-07-16 | 2020-08-21 | 平安国际智慧城市科技股份有限公司 | Crawler-based data verification method and device, computer equipment and storage medium |
| CN112363929A (en) * | 2020-11-10 | 2021-02-12 | 中国平安人寿保险股份有限公司 | System online method and device, computer equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113052463A (en) | 2021-06-29 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109446068B (en) | Interface test method, device, computer equipment and storage medium | |
| CN110209650B (en) | Data normalization and migration method and device, computer equipment and storage medium | |
| CN109032824A (en) | Database method of calibration, device, computer equipment and storage medium | |
| CN113127347B (en) | Interface testing method, device, equipment and readable storage medium | |
| US9356966B2 (en) | System and method to provide management of test data at various lifecycle stages | |
| CN111563051B (en) | Crawler-based data verification method and device, computer equipment and storage medium | |
| CA3131079A1 (en) | Test case generation method and device, computer equipment and storage medium | |
| CN108776643B (en) | Target code merging control method and system based on version control process | |
| CN113448862B (en) | Software version testing method and device and computer equipment | |
| CN113837584B (en) | Service processing system and abnormal data processing method based on service processing system | |
| CN111984659B (en) | Data updating method, device, computer equipment and storage medium | |
| CN117493199A (en) | Code verification method, device, computer equipment and storage medium | |
| CN114443039A (en) | Input parameter verification method and device, electronic equipment and storage medium | |
| CN113052463B (en) | Workflow verification method, workflow verification device, computer equipment and storage medium | |
| CN109684205B (en) | System testing method, device, electronic equipment and storage medium | |
| CN110737426B (en) | Program block creating method, program block creating device, computer equipment and storage medium | |
| CN113568869A (en) | File management method, management platform and computer readable storage medium | |
| CA3084413A1 (en) | Method for automatically validating cots and device for implementing the method | |
| CN114595159B (en) | Test data generation method, device, equipment and storage medium | |
| US11782938B2 (en) | Data profiling and monitoring | |
| CN112699023B (en) | Project interface testing method and device, computer equipment and storage medium | |
| CN110162507B (en) | Snapshot overwriting method, device, computer equipment and storage medium | |
| CN112685309A (en) | Unit testing method, unit testing device, storage medium and computer equipment | |
| CN115660875A (en) | Account data processing method and device, computer equipment and storage medium | |
| WO2021084763A1 (en) | Management device, management method, and management program |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |