CN113052463A - Workflow verification method and device, computer equipment and storage medium - Google Patents
Workflow verification method and device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN113052463A CN113052463A CN202110319728.0A CN202110319728A CN113052463A CN 113052463 A CN113052463 A CN 113052463A CN 202110319728 A CN202110319728 A CN 202110319728A CN 113052463 A CN113052463 A CN 113052463A
- Authority
- CN
- China
- Prior art keywords
- data
- verification
- 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.)
- Granted
Links
Images
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 method comprises the following steps: acquiring baseline reference data from a workflow management platform and acquiring a test environment system at the same time by receiving a verification request comprising a workflow project, test code data and a verification file; generating an independent environment system according to the code data and the test environment system; recording baseline database dropping data of baseline workflow execution baseline parameter entering data under the test environment system, simultaneously recording new version database dropping data of new version workflow execution baseline parameter entering data under the independent environment system, and recording new version database dropping data to be checked of new version 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 checking workflow and outputs checking report, avoids regression test and reduces cost of manual checking.
Description
Technical Field
The invention relates to the field of data processing of big data, in particular to a workflow verification method and device, computer equipment and a storage medium.
Background
At present, each field has a business system containing various workflows, such as a leave request approval process, an attendance approval process, a credit card application and verification process, a loan application and verification process and the like; the workflow of the service system needs to be changed, added and deleted with the change of the service flow or the requirement of adding new nodes. In the prior art, the change of a business process or a new requirement is realized by performing secondary development on a bottom workflow engine, after the development is completed, an interface test of each node needs to be performed on a changed workflow, a database record needs to be manually inquired, whether the expected result is met or not is manually judged, so that the verification of the workflow is completed, a regression test needs to be performed in the verification process, the time consumption and the huge labor cost of the regression test are very long, the verification period of the whole workflow is very long, the efficiency is low, the labor input cost is high, and the risk of manual verification errors is high.
Disclosure of Invention
The invention provides a workflow verification method, a workflow verification device, computer equipment and a storage medium, which realize verification processing through a data verification model and can automatically output a verification report, thereby avoiding regression testing, reducing the cost of manual verification, avoiding the risk of omission of verification and improving the accuracy and efficiency of verification.
A workflow validation method, comprising:
receiving a verification request, and acquiring a workflow project, test code data and a verification file in the verification request; the test code data comprises newly added reference data and code data;
acquiring baseline parameter data corresponding to the workflow project from a workflow management platform, and acquiring a test environment system corresponding to the workflow project, wherein the test environment system comprises a baseline workflow corresponding to the workflow project;
generating an independent environment system according to the code data and the test environment system; the independent environment system comprises a new version workflow corresponding to the workflow project;
inputting the baseline entry parameter data into the baseline workflow, recording baseline database dropping data of the baseline entry parameter data executed by the baseline workflow, simultaneously inputting the baseline entry parameter data into the new version workflow, recording new version database dropping data of the baseline entry parameter data executed by the new version workflow, inputting the new entry parameter data into the new version workflow, and recording to-be-verified database dropping data of the newly added entry parameter data executed by the new version workflow;
the baseline database falling data, the new version database falling data, the database falling data to be verified and the verification file are verified through the data verification model, and verification results output by the data verification model are obtained;
and outputting and displaying a verification report according to the verification result.
A workflow validation apparatus comprising:
the system comprises a receiving module, a verification module and a verification module, wherein the receiving module is used for receiving a verification request and acquiring a workflow project, test code data and a verification file in the verification request; the test code data comprises newly added reference data and code data;
the acquisition module is used for acquiring baseline parameter data corresponding to the workflow project from a workflow management platform and acquiring a test environment system corresponding to the workflow project, wherein the test environment system comprises a baseline workflow corresponding to the workflow project;
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 workflow corresponding to the workflow project;
the input module is used for inputting the baseline entry parameter data into the baseline workflow, recording baseline database dropping data of the baseline entry parameter data executed by the baseline workflow, simultaneously inputting the baseline entry parameter data into the new-version workflow, recording new-version database dropping data of the baseline entry parameter data executed by the new-version workflow, inputting the new-entry parameter data into the new-version workflow, and recording database dropping data to be checked and verified of the newly added parameter data executed by the new-version workflow;
the verification module is used for verifying the baseline database falling data, the new version database falling data, the database falling 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 an examination report according to the examination result.
A computer device comprising a memory, a processor and a computer program stored in said memory and executable on said processor, said processor implementing the steps of the above workflow verification method when executing said computer program.
A computer-readable storage medium, in which a computer program is stored which, when being executed by a processor, carries out the steps of the above workflow verification method.
According to the workflow verification method, the workflow verification device, the computer equipment and the storage medium, provided by the invention, 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 reference data and code data; acquiring baseline parameter data corresponding to the workflow project from a workflow management platform, and acquiring a test environment system corresponding to the workflow project, wherein the test environment system comprises a baseline workflow corresponding to the workflow project; generating an independent environment system according to the code data and the test environment system; the independent environment system comprises a new version workflow corresponding to the workflow project; inputting the baseline entry parameter data into the baseline workflow, recording baseline database dropping data of the baseline entry parameter data executed by the baseline workflow, simultaneously inputting the baseline entry parameter data into the new version workflow, recording new version database dropping data of the baseline entry parameter data executed by the new version workflow, inputting the new entry parameter data into the new version workflow, and recording to-be-verified database dropping data of the newly added entry parameter data executed by the new version workflow; the baseline database falling data, the new version database falling data, the database falling data to be verified and the verification file are verified through the data verification model, and verification results output by the data verification model are obtained; and outputting and displaying a verification report according to the verification result.
Therefore, the invention realizes that the baseline access parameter data corresponding to the workflow project is acquired from the workflow management platform by receiving the verification request containing the workflow project, the test code data and the verification file, and the test environment system corresponding to the workflow project is acquired at the same time; generating an independent environment system according to the code data and the test environment system; recording baseline database dropping data of the baseline parameter entering data executed by the baseline workflow under the test environment system, simultaneously recording new version database dropping data of the baseline parameter entering data executed by the new version workflow under the independent environment system, and recording to-be-verified database dropping data of the newly added parameter entering data executed by the new version workflow; the baseline database falling data, the new version database falling data, the database falling data to be verified and the verification file are verified through the data verification model, and verification results output by the data verification model are obtained; 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 entry parameter data input baseline workflow and baseline database dropping data and new database dropping data respectively output by the new workflow, whether the new workflow is compatible or not is determined, the current baseline workflow is met, the baseline database dropping data, the database dropping data to be verified and the verification file are verified through the data verification model, the verification report can be automatically output, regression testing 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 needed to be used in the description of the embodiments of the present invention will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art that other drawings can be obtained according to these drawings without inventive labor.
FIG. 1 is a schematic diagram 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 one embodiment of the invention;
FIG. 3 is a flowchart of step S30 of the workflow verification method in one embodiment of the invention;
FIG. 4 is a flowchart of step S50 of the workflow verification method in one embodiment of the invention;
FIG. 5 is a flowchart illustrating the step S501 of the workflow verification method according to an embodiment of the present invention;
FIG. 6 is a flowchart of step S503 of the workflow verification method in one embodiment of the present invention;
FIG. 7 is a flowchart of step S504 of the workflow verification method in one embodiment of the invention;
FIG. 8 is a functional block diagram of a workflow verification apparatus in one embodiment of the present invention;
FIG. 9 is a schematic diagram of a computer device in an embodiment of the invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The workflow verification method provided by the invention can be applied to the application environment shown in fig. 1, wherein a client (computer device) communicates with a server through a network. The client (computer device) includes, but is not limited to, various personal computers, notebook computers, smart phones, tablet computers, cameras, and portable wearable devices. The server may be implemented as a stand-alone server or as a server cluster consisting of a plurality of servers.
In an embodiment, as shown in fig. 2, a workflow verification method is provided, which mainly includes the following steps S10-S60:
s10, receiving a verification request, and acquiring a workflow project, test code data and a verification file in the verification request; the test code data includes newly added reference data and code data.
Understandably, the verification request is generated by triggering the verification of the workflow corresponding to the workflow item, that is, after a developer develops the workflow and determines that the workflow item, the test code data and the verification document corresponding to the workflow are completed, the verification request is triggered, for example, after a leave approval process, an attendance approval process, a credit card application verification process, a loan application verification process and the like are developed, the verification request of each workflow is triggered, the workflow item is the item name of the workflow to be verified, the item name of the workflow is unique, each workflow area can be separated, the test code data is a code file set related to the upgraded version of the workflow item, and the test code data comprises newly added reference data and code data, the new added parameter data is input parameter data of an input workflow compiled for verifying a new added node or a variable in an upgraded workflow, the new added parameter data can be compiled from the beginning, corresponding input parameter data can be added on the basis of baseline parameter data, the code data comprises a new add-in and an upgraded code file, the new add-in is an add-in which is required to be added in the upgraded workflow, or an add-in corresponding to the node is introduced by adding a node in the workflow, the verification file is a reference file of a prediction result after verification, namely a file of a qualified standard of each index output after the test code data is upgraded, and the verification file comprises an attribute item and an attribute range corresponding to the attribute item.
S20, acquiring baseline parameter data corresponding to the workflow project from a workflow management platform, and acquiring a test environment system corresponding to the workflow project, wherein the test environment system comprises a baseline workflow corresponding to the workflow project.
Understandably, the workflow management platform manages all workflow projects, and can store all baseline parameter entry data corresponding to the workflow projects and the test environment system, the baseline parameter entry data is parameter entry data corresponding to the workflow projects under the current business system, the parameter entry data is input parameters (input workflow) written for verifying the workflow, the baseline parameter entry data is parameter entry data for verifying under the test environment system, the test environment system comprises the baseline workflow corresponding to the workflow projects, and the baseline workflow is a workflow executed by the current business system on the workflow projects.
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 a workflow corresponding to the workflow item.
Understandably, by the mirror image technology, completely copying a system the same as the test environment system, deploying code data in a system generated by the mirror image to obtain the independent environment system, wherein 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 checked after upgrading.
In an embodiment, as shown in fig. 3, the step S30 of generating an independent environment system according to the code data and the test environment system includes:
s301, mirroring the test environment system to generate a to-be-processed environment system.
Understandably, the to-be-processed environment system which is the same as the test environment system is copied through a mirror image technology, wherein the mirror image technology is a technology which uses a mirror image copying function in a Docker container technology through a mirror image warehouse (Harbor) of the Docker container, takes an item as a center, and marks the item to be copied and generates the item through mirror image by configuring a copy strategy on the item.
In an embodiment, in the step S301, that is, the mirroring the test environment system to generate the to-be-processed environment system, includes:
s3011, installing a mirror image warehouse installation package in the Docker container, and setting mirror image warehouse configuration to deploy a mirror image warehouse.
Understandably, the Docker container is a container already deployed in the workflow management platform.
S3012, marking the testing environment system as a source item through the mirror image warehouse, and generating a copy instruction corresponding to the testing environment system.
And S3013, executing the copy instruction through the mirror image warehouse, and performing mirror image copy on the test environment system to obtain the to-be-processed environment system.
Understandably, the to-be-processed environment system is a system which is the same as the test environment system and is generated by copying through a copy mirror function in a Docker container technology, and the processing process of mirror image copying is a process of copying through a copy mirror function in the Docker container technology. S302, deploying the code data to the to-be-processed environment system to obtain an independent environment system.
Understandably, the deployment process is to install the newly added plug-in the code data, then find a folder of the workflow project, and migrate the upgraded code file in the code data to the found folder, thereby generating the independent environment system.
The file structures of the to-be-processed environment system and the test environment system are the same, namely the to-be-processed environment system and the test environment system have the same folder and files under the folder.
Therefore, 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 to-be-processed environment system is generated by mirroring the test environment system; the code data are deployed to the to-be-processed environment system to obtain the 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 independent environment system is separated from the test environment system, the influence between environments is avoided, convenience is provided for subsequent verification operation, the verification period is shortened, and the verification complexity is reduced.
And S40, inputting the baseline entering parameter data into the baseline workflow, recording baseline database falling data of the baseline entering parameter data executed by the baseline workflow, simultaneously inputting the baseline entering parameter data into the new-version workflow, recording new-version database falling data of the baseline entering parameter data executed by the new-version workflow, inputting the new-version parameter data into the new-version workflow, and recording to-be-checked database falling data of the new-version workflow executed by the new-version parameter data.
Understandably, the baseline entry parameter data is input into the baseline workflow, each node through which the baseline entry parameter data passes in the baseline workflow updates a data table in a database under the test environment system, triggers and responds to an interface corresponding to each node, records all updated and responded data, and generates the baseline database dropping data, the baseline database dropping data comprises a set of all databases under the test environment system and interfaces corresponding to each response, and simultaneously inputs the baseline entry parameter data into the new workflow, each node through which the new version entry parameter data passes in the new workflow updates a data table in a database under the independent environment system, triggers and responds to an interface corresponding to each node, and records all updated and responded data, and generating the new edition database, wherein the new edition database comprises all databases in the independent environment system and a set of responding interfaces, so that the baseline database falling data and the new edition database falling data are respectively obtained by inputting the same baseline entry parameter data into the baseline workflow and the new edition workflow, and whether the new edition workflow is compatible with the current baseline workflow or not can be judged by comparing the baseline database falling data with the new edition database falling data.
And S50, verifying the baseline database falling data, the new database falling data, the database falling data to be verified and the verification file through the data verification model, and obtaining a verification result output by the data verification model.
Understandably, the data verification model can realize automatic verification of the baseline database dropping data, the new database dropping data and the verification file and output verification results, the data verification model comprises a first comparison model, a second comparison model and a verification model, the baseline database dropping data and the new database dropping data are compared through the first comparison model to obtain a first comparison result, the comparison method can be set according to requirements to judge whether the first comparison result is qualified by testing, namely whether the baseline database dropping data and the new database dropping data are completely consistent after being subjected to white list processing is judged, if the first comparison result is qualified by testing, the baseline database dropping data and the database dropping data to be verified are compared through the second comparison model to obtain a second comparison result, and the second comparison result is verified with the verification file through the verification model, the checking method is that redundant or invalid data is removed by using a blacklist processing mode, then a matching comparison method is carried out for checking to obtain a checking result, the first comparison result and the checking result are merged, and the checking result is output.
In an embodiment, as shown in fig. 4, in the step S50, that is, performing, by the data verification model, verification processing on the baseline database falling data, the new database falling data, the database falling to be verified, and the verification file to obtain a verification result output by the data verification model, the method includes:
s501, comparing the base line database dropping data with the new version database dropping data through a first comparison model to obtain a first comparison result; the data verification model comprises the first comparison model, the second comparison model and a verification model.
Understandably, the first comparison model is a model for comparing a database and a database table, the first comparison model compares the baseline database falling data with the new database falling data by using a database comparison tool, such as a match tool of an oracle database, and outputs a comparison result of the baseline database falling data and the new database falling data in a report form, the report form may be a text format or an XML format, the report is determined as a first difference result, and the first difference result is filtered to determine the first comparison result, wherein the first comparison result includes a qualified test result and a unqualified test result.
The data verification model comprises the first comparison model, the second comparison model and a verification model.
In an embodiment, as shown in fig. 5, in step S501, that is, comparing the baseline database falling data with the new database falling data through the first comparison model to obtain a first comparison result, the step includes:
s5011, comparing the baseline database falling data with the new version database falling data through the first comparison model to obtain a first difference result.
Understandably, the baseline database falling data and the new version database falling data are compared through a match tool of an oracle database applied to the first comparison model, and each database and database table in the baseline database falling data and each database and database table in the new version database falling data are compared one by one, so that a first difference result can be compared, and the first difference result shows the data difference between the baseline database falling data and the new version database falling data.
S5012, performing white list processing on the first difference result through the first comparison model to obtain a filtering result.
Understandably, the white list processing is to extract only relevant data matched with fields in a preset white list, and screen out relevant data matched with the fields listed in the preset white list from the first difference result, the matching method may be a complete matching, that is, a complete matching with the fields listed in the white list, and the preset white list may be a field set in the baseline database data except for running water and automatically generated fields, so that only fields useful for comparison results in the first difference result are concerned, and the filtering result is generated.
S5013, determining the first comparison result according to the filtering result.
Understandably, if the filtering result does not contain any field, which indicates that no difference data exists, the first comparison result is qualified in the test, and if the filtering result contains any field, the first comparison result is unqualified in the test.
The invention realizes that the baseline database dropping data and the new version database dropping 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 falling data with the new version database falling data, the filtering result is obtained by screening through a white list technology, and the first comparison result is determined according to whether a difference field exists in the filtering result.
And S502, judging whether the first comparison result is qualified in the test.
And S503, when the first comparison result is detected to be qualified, comparing the baseline database falling data with the database falling data to be checked through the second comparison model to obtain a second comparison result.
Understandably, if the first comparison result is detected to be qualified in the test, comparing the baseline database falling data with the database falling data to be checked through two comparison models, wherein the second comparison model is a model for comparing the database falling data with the database falling data to be checked, the second comparison model uses a database comparison tool, such as a match tool of an oracle database, to compare the baseline database falling data with the database falling data to be checked, and outputs the comparison result of the baseline database falling data with the database falling data to be checked in a report form, the report form can be a text format or an XML format, the report is determined as a second difference result, the second difference result is filtered to determine the second comparison result, and the second comparison result comprises the qualified test and the unqualified test.
In an embodiment, as shown in fig. 6, in step S503, that is, comparing the baseline database falling data with the database falling under verification through the second comparison model to obtain a second comparison result, the method includes:
s5031, comparing the baseline database data and the to-be-verified database data with the second comparison model to obtain a second difference result.
Understandably, the baseline database falling data and the database falling data to be checked are compared by using a match tool of an oracle database through the second comparison model, and each database and database table in the baseline database falling data and each database and database table in the database falling data to be checked are compared one by one, so that the second difference result can be compared, and the second difference result shows the data difference between the baseline database falling data and the database falling data to be checked.
S5032, performing blacklist processing on the second difference result through the second comparison model to obtain the second comparison result.
Understandably, the blacklist processing is an operation process of listing redundant or invalid fields as a preset blacklist, removing the listed fields in the preset blacklist from results, removing the listed fields in the preset blacklist from the second difference result, and the preset blacklist may be a field set of fields automatically generated by running water and a known system, and determining the second difference result remaining after the blacklist processing as the second comparison result.
The invention realizes that the baseline database falling data and the database falling data to be verified are compared through the second comparison model to obtain a second difference result; and performing blacklist processing on the second difference result through the second comparison model to obtain the second comparison result, so that the redundant or invalid field is removed by using a blacklist technology, and the second comparison result is determined, thereby avoiding the interference of the redundant or invalid field on the verification result.
S504, inputting the second comparison result and the verification file into the verification model, and verifying the second comparison result and the verification file through the verification model to obtain a verification result.
Understandably, the verification model realizes the verification of the second comparison result according to the verification file and outputs a model of the verification result, 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, under the condition of consistency, 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 to obtain a verification value corresponding to the database field, and whether the verification result is qualified or not is determined according to the sum of all the verification values.
In an embodiment, as shown in fig. 7, in the step S504, that is, the checking the second comparison result with the check file through the check model to obtain a check result, the method includes:
s5041, judging whether each database field in the second comparison result is completely consistent with each attribute item in the verification file 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.
Understandably, the second comparison result includes the database field and the attribute value corresponding to the database field, the database field is a field of a difference between the baseline database falling data and the database falling data to be verified, the attribute value is a value assigned to the database field, it is determined by the verification model whether each database field in the second comparison result is consistent with the attribute item of the european in the verification file, 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 executed after the edition is upgraded, and the attribute range is a qualified standard range determined for the attribute item according to the development requirement, that is, the attribute item is qualified in the standard range.
S5042, if each database field in the second comparison result is completely consistent with an attribute item in the verification file, matching, by the verification model, an attribute value corresponding to the database field with an attribute range corresponding to the attribute item consistent with the database field to obtain a verification value corresponding to the database field.
Understandably, when each database field is completely consistent with each attribute item, 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, judging whether each attribute value is in the attribute range corresponding to the attribute value, and determining the verification value corresponding to the attribute value, namely the verification value corresponding to the database field according to the deviation between the attribute value and the center of the attribute range corresponding to the attribute value.
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:
s50421, judging whether the attribute value corresponding to the database field matches with the attribute range corresponding to the attribute item consistent with the database field through the verification model.
Understandably, the attribute range may be a numerical range or a conditional range (including a conditional requirement range).
S50422, if the attribute value matches the attribute range, determining that the verification value corresponding to the database field is a qualified value.
Understandably, the matching method can be set according to requirements, such as text matching, numerical matching, condition matching, and the like, and the qualified value is a value of deviation between the attribute value and the center of the attribute range corresponding to the attribute value.
S50423, if the attribute value does not match the attribute range, determining that the verification value corresponding to the database field is an unqualified value.
Understandably, the unqualified value is a negative infinite value given in the case of unmatched values.
The invention realizes that whether the attribute value corresponding to the database field is matched with the attribute range corresponding to the attribute item with the same database field is judged through the verification model; if the attribute value is matched with the attribute range, determining that the check value corresponding to the database field is a qualified value; if the attribute value is not matched with the attribute range, the check value corresponding to the database field is determined to be an unqualified value, so that matching through a check model is realized, the check value corresponding to the database field can be rapidly identified, and the identification efficiency is improved.
S5043, determining the verification result according to the verification value corresponding to each of the database fields.
Understandably, according to the sum of all the check values, determining whether the check result is qualified, namely, judging whether the sum of all the check values is greater than or equal to a preset threshold value, and if the sum of all the check values is greater than or equal to the preset threshold value, determining that the check result is qualified.
According to the invention, whether each database field in the second comparison result is completely consistent with each attribute item in the verification file is judged through the verification model; 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 the verification value corresponding to the database field; and determining the checking result according to the checking values corresponding to the database fields, so that the checking values are determined through a checking model, the checking result is automatically output according to all the checking values, the checking efficiency is improved, the manual checking cost is reduced, and the checking accuracy is improved.
S505, determining the first comparison result and the check result as the check result.
Understandably, the first alignment result and the check result are merged into the check result.
According to the invention, the baseline database dropping data and the new version database dropping data are compared through a first comparison model to obtain a first comparison result; when the first comparison result is detected to be qualified, comparing the baseline database falling data with the database falling 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 verifying the second comparison result and the verification file through the verification model to obtain a verification result; determining the first comparison result and the check result as the check result, so as to determine the check result by determining whether the first comparison result of comparing the baseline falling database data output by the first comparison model with the new falling database data is qualified, comparing the second comparison result with the second comparison model to output the second comparison result, and finally checking the second comparison result with the check file to output the check result, wherein the first comparison result of comparing the baseline falling database data with the new falling database data can determine whether the next check operation is performed, and the first comparison result can rapidly and accurately determine whether the new working flow is compatible with the current baseline working flow, and the check model can identify the difference between the second comparison result and the check file to determine the check result, finally, the verification result is determined, so that regression testing is avoided, the cost of manual verification is reduced, the risk of omission of verification is avoided, and the verification 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 to be qualified, that is, indicates whether the test code data upgrading the workflow project passes the verification, the verification result is analyzed to output the verification report and is displayed on an interface, the analysis process is to perform data tracking analysis on the first comparison result and the verification result in the verification result and output each index of the verification, and the verification report is a report of a set of each index of the verification.
The method and the device realize that the workflow project, 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 reference data and code data; acquiring baseline parameter data corresponding to the workflow project from a workflow management platform, and acquiring a test environment system corresponding to the workflow project, wherein the test environment system comprises a baseline workflow corresponding to the workflow project; generating an independent environment system according to the code data and the test environment system; the independent environment system comprises a new version workflow corresponding to the workflow project; inputting the baseline entry parameter data into the baseline workflow, recording baseline database dropping data of the baseline entry parameter data executed by the baseline workflow, simultaneously inputting the baseline entry parameter data into the new version workflow, recording new version database dropping data of the baseline entry parameter data executed by the new version workflow, inputting the new entry parameter data into the new version workflow, and recording to-be-verified database dropping data of the newly added entry parameter data executed by the new version workflow; the baseline database falling data, the new version database falling data, the database falling data to be verified and the verification file are verified through the data verification model, and verification results output by the data verification model are obtained; and outputting and displaying a verification report according to the verification result.
Therefore, the invention realizes that the baseline access parameter data corresponding to the workflow project is acquired from the workflow management platform by receiving the verification request containing the workflow project, the test code data and the verification file, and the test environment system corresponding to the workflow project is acquired at the same time; generating an independent environment system according to the code data and the test environment system; recording baseline database dropping data of the baseline parameter entering data executed by the baseline workflow under the test environment system, simultaneously recording new version database dropping data of the baseline parameter entering data executed by the new version workflow under the independent environment system, and recording to-be-verified database dropping data of the newly added parameter entering data executed by the new version workflow; the baseline database falling data, the new version database falling data, the database falling data to be verified and the verification file are verified through the data verification model, and verification results output by the data verification model are obtained; 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 entry parameter data input baseline workflow and baseline database dropping data and new database dropping data respectively output by the new workflow, whether the new workflow is compatible or not is determined, the current baseline workflow is met, the baseline database dropping data, the database dropping data to be verified and the verification file are verified through the data verification model, the verification report can be automatically output, regression testing 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 an embodiment, a workflow verification apparatus is provided, and the workflow verification apparatus corresponds to the workflow verification methods in the above embodiments one to one. As shown in fig. 8, the workflow verification apparatus includes a receiving module 11, an obtaining module 12, a generating module 13, an input module 14, a verification module 15, and an output module 16. The functional modules are explained in detail as follows:
the receiving module 11 is configured to receive a verification request, and obtain a workflow item, test code data, and a verification file in the verification request; the test code data comprises newly added reference data and code data;
an obtaining module 12, configured to obtain, from a workflow management platform, baseline entry data corresponding to the workflow project, and obtain a test environment system corresponding to the workflow project, where the test environment system includes a baseline workflow corresponding to the workflow project;
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 workflow corresponding to the workflow project;
the input module 14 is configured to input the baseline entry parameter data into the baseline workflow, record baseline database dropping data of the baseline entry parameter data executed by the baseline workflow, simultaneously input the baseline entry parameter data into the new-version workflow, record new version database dropping data of the baseline entry parameter data executed by the new-version workflow, input the new entry parameter data into the new-version workflow, and record to-be-verified database dropping data of the new entry parameter data executed by the new-version workflow;
the verification module 15 is configured to perform verification processing on the baseline database dropping data, the new version database dropping data, the to-be-verified database dropping data 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 an examination report according to the examination result.
For the specific definition of the workflow verification apparatus, reference may be made to the above definition of the workflow verification method, which is not described herein again. 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 modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.
In one embodiment, a computer device is provided, which may be a server, and its internal structure diagram 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 comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. 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, which includes a memory, a processor, and a computer program stored on the memory and executable on the processor, and when the processor executes the computer program, the workflow verification method in the above embodiments is implemented.
In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored, which, when being executed by a processor, implements the workflow verification method in the above-described embodiments.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, storage, databases, or other media used in embodiments provided herein may include non-volatile and/or volatile memory. Non-volatile memory can include read-only memory (ROM), Programmable ROM (PROM), Electrically Programmable ROM (EPROM), Electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), Dynamic RAM (DRAM), Synchronous DRAM (SDRAM), Double Data Rate SDRAM (DDRSDRAM), Enhanced SDRAM (ESDRAM), Synchronous Link DRAM (SLDRAM), Rambus Direct RAM (RDRAM), direct bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).
It will be apparent to those skilled in the art that, for convenience and brevity of description, only the above-mentioned division of the functional units and modules is illustrated, and in practical applications, the above-mentioned function distribution may be performed by different functional units and modules according to needs, that is, the internal structure of the apparatus is divided into different functional units or modules to perform all or part of the above-mentioned functions.
The above-mentioned embodiments are only used for illustrating the technical solutions of the present invention, and not for limiting the same; although the present 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 solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; such modifications and substitutions do not substantially depart from the spirit and scope of the embodiments of the present invention, and are intended to be included within the scope of the present invention.
Claims (10)
1. A workflow verification method, comprising:
receiving a verification request, and acquiring a workflow project, test code data and a verification file in the verification request; the test code data comprises newly added reference data and code data;
acquiring baseline parameter data corresponding to the workflow project from a workflow management platform, and acquiring a test environment system corresponding to the workflow project, wherein the test environment system comprises a baseline workflow corresponding to the workflow project;
generating an independent environment system according to the code data and the test environment system; the independent environment system comprises a new version workflow corresponding to the workflow project;
inputting the baseline entry parameter data into the baseline workflow, recording baseline database dropping data of the baseline entry parameter data executed by the baseline workflow, simultaneously inputting the baseline entry parameter data into the new version workflow, recording new version database dropping data of the baseline entry parameter data executed by the new version workflow, inputting the new entry parameter data into the new version workflow, and recording to-be-verified database dropping data of the newly added entry parameter data executed by the new version workflow;
the baseline database falling data, the new version database falling data, the database falling data to be verified and the verification file are verified through the data verification model, and verification results output by the data verification model are obtained;
and outputting and displaying a verification report according to the verification result.
2. The workflow verification method of claim 1, wherein said generating an independent environment system from said code data and said test environment system comprises:
mirroring the test environment system to generate a to-be-processed environment system;
and deploying the code data to the to-be-processed environment system to obtain an independent environment system.
3. The workflow verification method according to claim 2, wherein the obtaining of the verification result output by the data verification model by performing verification processing on the baseline landing library data, the new landing library data, the to-be-verified landing library data and the verification file through the data verification model comprises:
comparing the baseline database dropping data with the new version database dropping data through a first comparison model to obtain a first comparison result; the data verification model comprises the first comparison model, the second comparison model and a verification model;
judging whether the first comparison result is qualified;
when the first comparison result is detected to be qualified, comparing the baseline database falling data with the database falling 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 verifying the second comparison result and the verification file through the verification model to obtain a verification result;
and determining the first comparison result and the check result as the check result.
4. The workflow verification method of claim 3, wherein comparing the baseline drop library data with the new drop library data via a first comparison model to obtain a first comparison result comprises:
comparing the baseline database dropping data with the new version database dropping 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.
5. The workflow verification method of claim 3, wherein comparing the baseline landing library data with the to-be-verified landing library data through the second comparison model to obtain a second comparison result comprises:
comparing the baseline database falling data with the database falling 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 a second comparison result.
6. The workflow verification method of claim 3, wherein said verifying the second comparison result with the verification document by the verification model to obtain a verification result comprises:
judging whether each database field in the second comparison result is completely consistent with each attribute item 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 value corresponding to each database field.
7. The workflow verification method of claim 6, wherein the obtaining a verification value corresponding to a database field by matching an attribute value corresponding to the database field with an attribute range corresponding to the attribute item that is consistent with the database field through the verification model comprises:
judging whether the attribute value corresponding to the database field is matched with the attribute range corresponding to the attribute item with the consistent database field through the verification model;
if the attribute value is matched with the attribute range, determining that the check 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 check value corresponding to the database field is an unqualified value.
8. A workflow validation apparatus, comprising:
the system comprises a receiving module, a verification module and a verification module, wherein the receiving module is used for receiving a verification request and acquiring a workflow project, test code data and a verification file in the verification request; the test code data comprises newly added reference data and code data;
the acquisition module is used for acquiring baseline parameter data corresponding to the workflow project from a workflow management platform and acquiring a test environment system corresponding to the workflow project, wherein the test environment system comprises a baseline workflow corresponding to the workflow project;
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 workflow corresponding to the workflow project;
the input module is used for inputting the baseline entry parameter data into the baseline workflow, recording baseline database dropping data of the baseline entry parameter data executed by the baseline workflow, simultaneously inputting the baseline entry parameter data into the new-version workflow, recording new-version database dropping data of the baseline entry parameter data executed by the new-version workflow, inputting the new-entry parameter data into the new-version workflow, and recording database dropping data to be checked and verified of the newly added parameter data executed by the new-version workflow;
the verification module is used for verifying the baseline database falling data, the new version database falling data, the database falling 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 an examination report according to the examination result.
9. A computer device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, wherein the processor implements the workflow verification method according to any one of claims 1 to 7 when executing the computer program.
10. A computer-readable storage medium, in which a computer program is stored which, when being executed by a processor, carries out a workflow verification method according to any one of claims 1 to 7.
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 true CN113052463A (en) | 2021-06-29 |
| CN113052463B 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 |
|---|---|
| CN113052463B (en) | 2023-09-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN113127347B (en) | Interface testing method, device, equipment and readable storage medium | |
| CN110209650B (en) | Data normalization and migration 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 | |
| CN110851351A (en) | Deployment environment testing method and device, computer equipment and storage medium | |
| CN111158730B (en) | System updating method, device, electronic equipment and readable storage medium | |
| CN111897727A (en) | Software testing method and device, computer equipment and storage medium | |
| CN113886262A (en) | Software automation test method and device, computer equipment and storage medium | |
| US11823086B2 (en) | Membership analyzing method, apparatus, computer device and storage medium | |
| CN110737426B (en) | Program block creating method, program block creating device, computer equipment and storage medium | |
| CN117493188A (en) | Interface testing method and device, electronic equipment and storage medium | |
| CN113052463B (en) | Workflow verification method, workflow verification device, computer equipment and storage medium | |
| CN112699023B (en) | Project interface testing method and device, computer equipment and storage medium | |
| CN115357269A (en) | Configuration information updating method and device, computer equipment and storage medium | |
| CN112685309A (en) | Unit testing method, unit testing device, storage medium and computer equipment | |
| US11314631B2 (en) | Method for automatically validating COTS and device for implementing the method | |
| CN115080417A (en) | Test case automatic generation method, electronic equipment and storage medium | |
| CN114706787A (en) | Service test method, service test device, equipment and storage medium | |
| CN114116664A (en) | Database table building statement processing method and device, computer equipment and storage medium | |
| CN113918594A (en) | Method and device for generating structured query statement and computer equipment | |
| CN114595159B (en) | Test data generation method, device, equipment and storage medium | |
| US20240248688A1 (en) | Package generation for configuring a working environment on a server instance | |
| US20240248692A1 (en) | Package for configuring a working environment on a server instance | |
| WO2021084763A1 (en) | Management device, management method, and management program | |
| CN116955156A (en) | Flow recording playback test method and device and electronic equipment |
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 |