CN116881164A - Verification and correction method, device and equipment for test data in financial information system - Google Patents

Verification and correction method, device and equipment for test data in financial information system Download PDF

Info

Publication number
CN116881164A
CN116881164A CN202310944416.8A CN202310944416A CN116881164A CN 116881164 A CN116881164 A CN 116881164A CN 202310944416 A CN202310944416 A CN 202310944416A CN 116881164 A CN116881164 A CN 116881164A
Authority
CN
China
Prior art keywords
test data
data
verification
verified
technical
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.)
Pending
Application number
CN202310944416.8A
Other languages
Chinese (zh)
Inventor
林锐
叶建锋
邓立恒
赖集瑞
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Industrial and Commercial Bank of China Ltd ICBC
Original Assignee
Industrial and Commercial Bank of China Ltd ICBC
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Industrial and Commercial Bank of China Ltd ICBC filed Critical Industrial and Commercial Bank of China Ltd ICBC
Priority to CN202310944416.8A priority Critical patent/CN116881164A/en
Publication of CN116881164A publication Critical patent/CN116881164A/en
Pending legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/36—Preventing errors by testing or debugging software
    • G06F11/3668—Software testing
    • G06F11/3672—Test management
    • G06F11/3684—Test management for test design, e.g. generating new test cases
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/36—Preventing errors by testing or debugging software
    • G06F11/3668—Software testing
    • G06F11/3672—Test management
    • G06F11/3688—Test management for test execution, e.g. scheduling of test suites
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00—Error detection; Error correction; Monitoring
    • G06F11/36—Preventing errors by testing or debugging software
    • G06F11/3668—Software testing
    • G06F11/3672—Test management
    • G06F11/3692—Test management for test results analysis
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00—Arrangements for software engineering
    • G06F8/40—Transformation of program code
    • G06F8/41—Compilation
    • G06F8/42—Syntactic analysis

Abstract

The application relates to a verification and correction method and device for test data in a financial information system, computer equipment, a storage medium and a computer program product, and relates to the technical fields of financial science and technology and computers. The application can improve the testing efficiency of the financial information system. The method comprises the following steps: obtaining test data to be verified; the test data to be verified consists of subject data, predicate data and object data; predicate data includes query, add, delete, or modify; determining a target technical verification rule and a target service verification rule according to predicate data of test data to be verified; according to the target technical verification rule and the target service verification rule, respectively carrying out technical validity verification and service validity verification on the test data to be verified to obtain a technical validity verification result and a service validity verification result; and correcting the test data to be checked under the condition that any one of the technical validity check result and the service validity check result is that the check is not passed.

Description

Verification and correction method, device and equipment for test data in financial information system
Technical Field
The present application relates to the field of financial science and technology and computer technology, and in particular, to a method, an apparatus, a computer device, a storage medium and a computer program product for verifying and correcting test data in a financial information system.
Background
With the development of computer software technology, financial information systems such as a bank customer information system and the like appear, and in the testing process of the financial information system, various forms of test data are required to be checked and corrected, so that a certain amount of testing tasks can be brought to related technicians.
In the conventional technology, when a financial information system is tested, verification and correction can be usually performed only by manually and serially connecting test data to be verified; however, for massive test data requirements, related technicians manually check and correct the test data one by one, so that the problem of low test efficiency exists.
Disclosure of Invention
In view of the foregoing, it is desirable to provide a verification and correction method, apparatus, computer device, computer readable storage medium, and computer program product for test data in a financial information system.
In a first aspect, the present application provides a method for verifying and correcting test data in a financial information system.
The method comprises the following steps:
obtaining test data to be verified; the test data to be verified consists of subject data, predicate data and object data; the predicate data includes queries, additions, deletions, or modifications;
determining a target technical verification rule and a target service verification rule according to predicate data of the test data to be verified;
according to the target technical verification rule and the target service verification rule, respectively carrying out technical validity verification and service validity verification on the test data to be verified to obtain a technical validity verification result and a service validity verification result;
and correcting the test data to be verified under the condition that any one of the technical validity verification result and the service validity verification result is that verification fails.
In one embodiment, before determining the target technical verification rule and the target service verification rule according to the predicate data of the test data to be verified, the method further includes:
acquiring a technical check rule and a business check rule which are respectively and correspondingly configured for each predicate data;
the determining a target technical verification rule and a target service verification rule according to the predicate data of the test data to be verified comprises the following steps:
And identifying a target technical check rule and a target service check rule from the configured multiple technical check rules and multiple service check rules according to the predicate data of the test data to be checked.
In one embodiment, the performing technical validity check and service validity check on the test data to be checked according to the target technical check rule and the target service check rule includes:
extracting technical item data and business item data contained in the test data to be checked; performing technical validity verification on the technical item data according to the target technical verification rule; and carrying out service validity verification on the service item data according to the target service verification rule.
In one embodiment, the correcting the test data to be verified when any one of the technical validity verification result and the service validity verification result is that verification fails includes:
generating first correction prompt information corresponding to the test data to be verified according to the target technology verification rule under the condition that the technology validity verification result is that verification fails; and correcting the test data to be verified according to the first correction prompt information.
In one embodiment, when any one of the technical validity check result and the service validity check result is that the check fails, the correcting the test data to be checked further includes:
generating second correction prompt information corresponding to the test data to be checked according to the target service check rule under the condition that the service validity check result is that the check is not passed; and correcting the test data to be verified according to the second correction prompt information.
In one embodiment, the method further comprises:
under the condition that a replacement instruction for the test data to be verified is received, replacing the test data to be verified with third test data to be verified, wherein the third test data to be verified comprises first test data to be verified and/or second test data to be verified; the first test data to be verified is obtained by modifying the test data to be verified according to the first modification prompt information; the second test data to be verified is obtained by modifying the test data to be verified according to the second modification prompt information; and executing the third test data to be verified.
In one embodiment, after obtaining the test data to be verified, the method further includes:
detecting whether the test data to be checked has data missing or not; determining a data missing part under the condition that the data missing of the test data to be checked is detected; and generating perfect prompt information of the test data to be checked according to the data missing part and ending the checking flow.
In a second aspect, the application further provides a verification and correction device for the test data in the financial information system. The device comprises:
the data acquisition module is used for acquiring test data to be checked; the test data to be verified consists of subject data, predicate data and object data; the predicate data includes queries, additions, deletions, or modifications;
the rule determining module is used for determining a target technical checking rule and a target service checking rule according to predicate data of the test data to be checked;
the data verification module is used for respectively carrying out technical validity verification and business validity verification on the test data to be verified according to the target technical verification rule and the target business verification rule to obtain a technical validity verification result and a business validity verification result;
And the data correction module is used for correcting the test data to be verified under the condition that any one of the technical validity verification result and the service validity verification result is not passed.
In a third aspect, the present application also provides a computer device. The computer device comprises a memory storing a computer program and a processor which when executing the computer program performs the steps of:
obtaining test data to be verified; the test data to be verified consists of subject data, predicate data and object data; the predicate data includes queries, additions, deletions, or modifications; determining a target technical verification rule and a target service verification rule according to predicate data of the test data to be verified; according to the target technical verification rule and the target service verification rule, respectively carrying out technical validity verification and service validity verification on the test data to be verified to obtain a technical validity verification result and a service validity verification result; and correcting the test data to be verified under the condition that any one of the technical validity verification result and the service validity verification result is that verification fails.
In a fourth aspect, the present application also provides a computer-readable storage medium. The computer readable storage medium having stored thereon a computer program which when executed by a processor performs the steps of:
obtaining test data to be verified; the test data to be verified consists of subject data, predicate data and object data; the predicate data includes queries, additions, deletions, or modifications; determining a target technical verification rule and a target service verification rule according to predicate data of the test data to be verified; according to the target technical verification rule and the target service verification rule, respectively carrying out technical validity verification and service validity verification on the test data to be verified to obtain a technical validity verification result and a service validity verification result; and correcting the test data to be verified under the condition that any one of the technical validity verification result and the service validity verification result is that verification fails.
In a fifth aspect, the present application also provides a computer program product. The computer program product comprises a computer program which, when executed by a processor, implements the steps of:
Obtaining test data to be verified; the test data to be verified consists of subject data, predicate data and object data; the predicate data includes queries, additions, deletions, or modifications; determining a target technical verification rule and a target service verification rule according to predicate data of the test data to be verified; according to the target technical verification rule and the target service verification rule, respectively carrying out technical validity verification and service validity verification on the test data to be verified to obtain a technical validity verification result and a service validity verification result; and correcting the test data to be verified under the condition that any one of the technical validity verification result and the service validity verification result is that verification fails.
The verification and correction method, the verification and correction device, the computer equipment, the storage medium and the computer program product of the test data in the financial information system are realized by acquiring the test data to be verified; the test data to be verified consists of subject data, predicate data and object data; predicate data includes query, add, delete, or modify; determining a target technical verification rule and a target service verification rule according to predicate data of test data to be verified; according to the target technical verification rule and the target service verification rule, respectively carrying out technical validity verification and service validity verification on the test data to be verified to obtain a technical validity verification result and a service validity verification result; and correcting the test data to be checked under the condition that any one of the technical validity check result and the service validity check result is that the check is not passed. In this way, the corresponding target technical verification rule and target service verification rule are determined by analyzing predicate data of the test data to be verified, and technical validity verification and service validity verification are respectively carried out on the test data to be verified; if the verification result is that the verification is not passed, correcting the test data to be verified; therefore, the test data to be checked is checked and corrected in a targeted and efficient way by utilizing a computer technology, and the generation of abnormal service data is effectively avoided; the verification and correction process of the whole test data is not needed to be greatly participated in, so that the inefficient process of manually verifying and correcting the test data one by related technicians is effectively avoided, and the test efficiency of the financial information system is greatly improved.
Drawings
FIG. 1 is a diagram of an application environment for a method of verification and correction of test data in a financial information system according to one embodiment;
FIG. 2 is a flow chart of a method for verifying and correcting test data in a financial information system according to one embodiment;
FIG. 3 is a flow chart of a technical validity check and business validity check step in one embodiment;
FIG. 4 is a flow chart of a method for verifying and correcting test data in a financial information system according to an embodiment;
FIG. 5 is a flowchart illustrating a method for verifying and correcting test data in a financial information system according to another embodiment;
FIG. 6 is a block diagram illustrating an exemplary apparatus for verifying and correcting test data in a financial information system;
fig. 7 is an internal structural diagram of a computer device in one embodiment.
Detailed Description
The present application will be described in further detail with reference to the drawings and examples, in order to make the objects, technical solutions and advantages of the present application more apparent. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the application.
It should be noted that, the client information (including, but not limited to, client device information, client personal information, etc.) and the data (including, but not limited to, data for analysis, stored data, presented data, etc.) related to the present application are information and data authorized by the client or sufficiently authorized by each party, and the collection, use and processing of the related data need to comply with the relevant laws and regulations and standards of the relevant country and region.
The verification and correction method for the test data in the financial information system provided by the embodiment of the application can be applied to an application environment shown in fig. 1. Wherein the financial client 101 communicates with the server 102 via a network. The data storage system may store data that the server 102 needs to process. The data storage system may be integrated on the server 102 or may be located on a cloud or other network server.
Specifically, the method for generating and processing test data in the financial information system according to the embodiment of the present application may be executed by the server 102.
Illustratively, the server 102 obtains the test data to be verified sent by the financial client 101; the test data to be verified consists of subject data, predicate data and object data; predicate data includes query, add, delete, or modify; the server 102 determines a target technical verification rule and a target service verification rule according to predicate data of test data to be verified; according to the target technical verification rule and the target service verification rule, respectively carrying out technical validity verification and service validity verification on the test data to be verified to obtain a technical validity verification result and a service validity verification result; the server 102 corrects the test data to be verified under the condition that any one of the technical validity verification result and the service validity verification result is that the verification is not passed.
The financial client 101 in the present application may be, but not limited to, various personal computers, notebook computers, smart phones, tablet computers, etc. The server 102 may be implemented as a stand-alone server or as a server cluster of multiple servers.
In one embodiment, as shown in fig. 2, a method for verifying and correcting test data in a financial information system is provided, and the method is applied to the server 102 in fig. 1 for illustration, and includes the following steps:
step S201, test data to be checked are obtained; the test data to be verified consists of subject data, predicate data and object data; predicate data includes queries, additions, deletions, or modifications.
The subject data may be a subject of test data required by a preset bank client information system, for example: personal client number, unit client legal representative, etc., may also be subject information related to the test data, such as: personal client number 020000000001.
The object data may be an object of a test data condition required by a preset bank client information system, such as: certificate number, residence address, also object information related to test data, such as: the occupation is teacher.
Specifically, the server 102 obtains test data to be verified sent by the bank client 101 in response to a verification and correction instruction of the test data in the financial information system.
Step S202, determining a target technical verification rule and a target service verification rule according to predicate data of test data to be verified.
The technical verification rule can be a set of rule for verifying technical validity summarized and configured by related technicians according to historical test experience.
The service verification rule may be a set of rules for verifying the validity of the service summarized and configured by the related technicians according to historical test experience.
Specifically, the server 102 identifies a target technical verification rule and a target service verification rule from among the configured plurality of technical verification rules and the plurality of service verification rules according to predicate data of test data to be verified.
And step S203, respectively carrying out technical validity check and service validity check on the test data to be checked according to the target technical check rule and the target service check rule to obtain a technical validity check result and a service validity check result.
The technical validity check and the service validity check are respectively used for checking whether the data meet the technical validity requirement and the service validity requirement of the financial information system, so that abnormal data can be avoided.
Specifically, the server 102 extracts technical item data and service item data contained in test data to be verified; according to the target technical verification rule, technical validity verification is carried out on the technical item data; and carrying out service validity check on the service item data according to the target service check rule.
And step S204, correcting the test data to be checked under the condition that any one of the technical validity check result and the service validity check result is that the check is not passed.
Specifically, the server 102 corrects the test data to be verified according to the target technical verification rule and/or the target service verification rule when any one of the technical validity verification result and the service validity verification result is that the verification is not passed.
In the verification and correction method of the test data in the financial information system, the test data to be verified is obtained; the test data to be verified consists of subject data, predicate data and object data; predicate data includes query, add, delete, or modify; determining a target technical verification rule and a target service verification rule according to predicate data of test data to be verified; according to the target technical verification rule and the target service verification rule, respectively carrying out technical validity verification and service validity verification on the test data to be verified to obtain a technical validity verification result and a service validity verification result; and correcting the test data to be checked under the condition that any one of the technical validity check result and the service validity check result is that the check is not passed. In this way, the corresponding target technical verification rule and target service verification rule are determined by analyzing predicate data of the test data to be verified, and technical validity verification and service validity verification are respectively carried out on the test data to be verified; if the verification result is that the verification is not passed, correcting the test data to be verified; therefore, the test data to be checked is checked and corrected in a targeted and efficient way by utilizing a computer technology, and the generation of abnormal service data is effectively avoided; the verification and correction process of the whole test data is not needed to be greatly participated in, so that the inefficient process of manually verifying and correcting the test data one by related technicians is effectively avoided, and the test efficiency of the financial information system is greatly improved.
In one embodiment, before determining the target technology verification rule and the target service verification rule according to predicate data of the test data to be verified, the method further includes the following steps:
acquiring a technical check rule and a business check rule which are respectively and correspondingly configured for each predicate data;
according to predicate data of test data to be checked, a target technical check rule and a target service check rule are determined, and the method specifically comprises the following steps:
and identifying a target technical check rule and a target service check rule from the configured multiple technical check rules and multiple service check rules according to predicate data of the test data to be checked.
Wherein each predicate data includes a query, an addition, a deletion, and a modification.
Specifically, the server 102 acquires a technical check rule and a service check rule configured correspondingly for each predicate data; and identifying a target technical check rule and a target service check rule from the configured multiple technical check rules and multiple service check rules according to predicate data of the test data to be checked.
In this embodiment, by acquiring a technical verification rule and a service verification rule configured corresponding to each predicate data, and according to the predicate data of test data to be verified, a target technical verification rule and a target service verification rule are identified in a targeted manner.
In one embodiment, as shown in fig. 3, in the step S203, according to a target technology verification rule and a target service verification rule, the technology validity verification and the service validity verification are performed on the test data to be verified, respectively, and specifically the method includes the following steps:
step S301, extracting technical item data and service item data contained in the test data to be verified.
Step S302, technical validity verification is carried out on the technical item data according to the target technical verification rule.
Step S303, according to the target business verification rule, business validity verification is carried out on the business item data.
Specifically, the server 102 identifies and extracts technical term data and service term data from the test data to be verified, performs technical validity verification on the technical term data according to a target technical verification rule, and performs service validity verification on the service term data according to the target service verification rule.
For example, technical validity check is performed on technical item data in the target test data:
query statement: when checking that the uploading statement has no query condition, checking is not passed; otherwise, checking is passed.
Newly added sentences: comparing the value of each field to be uploaded with the table structure, and checking that when the data types are inconsistent or the uploading length exceeds the field definition length, the check is not passed; otherwise, checking is passed.
Modifying the sentence: comparing the modified value of each field with the table structure, and checking that when the data type is inconsistent or the uploading length exceeds the field definition length, the check is not passed; otherwise, checking is passed.
Delete statement: checking that the record conforming to the deleting condition is larger than the parameter set value, and checking is not passed; otherwise, checking is passed.
And carrying out service validity check on service item data of the target test data:
newly added sentences: multiple newly added service verification rules can be defined for each table, for example, for a personal information table T10, whether the newly added and sent certificate already has the same certificate or not is verified, if so, the verification is not passed; otherwise, checking is passed.
Modifying the sentence: multiple correction service verification rules can be defined for each table, such as for a personal information table T10, and verification of non-empty fields of a service, such as occupation, whether correction is empty or not, and if correction is empty, verification is not passed; otherwise, checking is passed.
Delete statement: multiple deletion service verification rules can be defined for each table, such as checking whether all certificates of the client are deleted or not for the unit information table T20, if so, the checking is not passed; otherwise, checking is passed.
In this embodiment, by performing technical validity check and service validity check on technical item data and service item data according to a target technical check rule and a target service check rule, test data which do not meet technical validity requirements and service validity requirements can be screened out, so that generation of abnormal service data is effectively avoided.
In one embodiment, in the step S204, when any one of the technical validity check result and the service validity check result is that the check fails, the method corrects the test data to be checked, and specifically includes the following steps:
under the condition that the technical validity check result is that the check fails, generating first correction prompt information corresponding to the test data to be checked according to the target technical check rule; and correcting the test data to be verified according to the first correction prompt information.
Specifically, the server 102 generates first correction prompt information corresponding to test data to be verified according to a target technology verification rule when the technical validity verification result is that verification fails; and correcting the test data to be verified according to the first correction prompt information.
For example, technical validity check is not passed, and may be recommended according to the following rule:
query statement: returning prompt information 'can not be queried in a full table', and suggesting an increasing condition where cino= 'uploading test client number'; after the tester fills in the customer number, the verification passes.
Newly added sentences: comparing the values of the fields to the table structure, checking that when the data types or lengths are inconsistent, the data types or lengths defined by the table structure are converted, for example, the data structures of the fields of the certificate types are defined as digital types, but the character '001' is sent to the uploading sentence, and the character '001' is automatically converted into the digital 1 and recommended.
Modifying the sentence: comparing the modified value of each field with the table structure, checking that when the data type is inconsistent or the length of the field is exceeded, converting the modified value into the data type or length defined by the table structure and recommending the modified value.
Delete statement: and if the record conforming to the deletion condition is checked to be larger than the parameter set value, returning a prompt message of deleting the record to be larger than the parameter value N and requesting to add the deletion condition.
In this embodiment, a first modification prompt message corresponding to test data to be verified is generated according to a target technology verification rule, and the test data to be verified is modified according to the first modification prompt message; the test data which does not meet the technical legal requirements can be pertinently modified, so that the test data which meets the technical legal requirements can be accurately obtained.
In one embodiment, in the step S204, when any one of the technical validity check result and the service validity check result is that the check fails, the method corrects the test data to be checked, and specifically includes the following steps:
generating second correction prompt information corresponding to test data to be checked according to a target service check rule under the condition that the service validity check result is that the check is not passed; and correcting the test data to be verified according to the second correction prompt information.
Specifically, the server 102 generates second correction prompt information corresponding to the test data to be checked according to the target service check rule when the service validity check result is that the check fails; and correcting the test data to be verified according to the second correction prompt information.
For example, the service validity check is not passed, and may be recommended according to the following rule:
newly added sentences: and respectively defining recommendation rules corresponding to a plurality of newly added service verification rules for each table, for example, checking whether the newly added and sent certificate already has the same certificate for the personal information table T10, if so, checking fails, generating a new number by using a random number for the certificate number, and recommending the new number to a tester.
Modifying the sentence: respectively defining recommendation rules corresponding to a plurality of correction service verification rules for each table, such as a personal information table T10, verifying whether a non-empty field of a service, such as occupation, is corrected to be empty, if so, verifying that the correction is not passed, replacing the original value of a database of the field which is not passed, and recommending the database to a tester; the value of the verification pass is unchanged.
Delete statement: and (3) defining recommendation rules corresponding to a plurality of deletion service verification rules for each table, for example, checking whether all certificates of the client are deleted for the unit information table T20, if so, checking not to pass, and adding deletion conditions: the certificate record ID is not equal to the account opening certificate record ID and is recommended to the tester.
In the embodiment, the second modification prompt information corresponding to the test data to be checked is generated according to the target service check rule; modifying the test data to be verified according to the second modification prompt information; the test data which does not meet the legal requirement of the service can be pertinently modified, so that the test data which meets the legal requirement of the service can be accurately obtained.
In one embodiment, the method further comprises the following steps:
under the condition that a replacement instruction aiming at the test data to be verified is received, replacing the test data to be verified with third test data to be verified, which comprises the first test data to be verified and/or the second test data to be verified; the first test data to be checked is obtained by modifying the test data to be checked according to the first modification prompt information; the second test data to be checked is obtained by modifying the test data to be checked according to the second modification prompt information; and executing the third test data to be verified.
Specifically, the server 102 replaces the test data to be verified with third test data to be verified including the first test data to be verified and/or the second test data to be verified when receiving a replacement instruction for the test data to be verified; the first test data to be checked is obtained by modifying the test data to be checked according to the first modification prompt information; the second test data to be checked is obtained by modifying the test data to be checked according to the second modification prompt information; and executing the third test data to be checked to obtain a corresponding execution result.
In this embodiment, the test data to be verified is replaced by third test data to be verified including the first test data to be verified and/or the second test data to be verified; therefore, the test data meeting the requirements of the demander after replacement can be flexibly and efficiently obtained.
In one embodiment, after obtaining the test data to be verified, the method further includes the following steps:
detecting whether the test data to be checked has data missing or not; determining a data missing part under the condition that the data missing of the test data to be checked is detected; and generating perfect prompt information of the test data to be checked according to the data missing part and ending the checking flow.
The data missing may be a missing of one or more of subject data, predicate data, and object data of the test data to be verified.
Specifically, the server 102 detects whether there is a data loss in the test data to be checked; determining a data missing part under the condition that the data missing of the test data to be checked is detected; and generating perfect prompt information of the test data to be checked according to the data missing part and ending the checking flow.
In the embodiment, by detecting whether the data of the test data to be checked has data missing, generating perfect prompt information of the test data to be checked and ending the checking flow according to the data missing part under the condition that the data of the test data to be checked is detected to have data missing; therefore, the preliminary verification of the test data to be verified can be realized, the test data with data missing can be screened out, and the test efficiency of the financial information system can be improved.
In one embodiment, as shown in fig. 4, a method for verifying and correcting test data in a financial information system in a specific embodiment is provided, which specifically includes the following steps:
step S401, test data to be verified is obtained; the test data to be verified consists of subject data, predicate data and object data; predicate data includes queries, additions, deletions, or modifications.
Step S402, detecting whether the test data to be checked has data missing; when detecting that the test data to be checked has data missing, determining a data missing part; and generating perfect prompt information of the test data to be checked according to the data missing part and ending the checking flow.
Step S403, obtaining a technical check rule and a business check rule which are respectively and correspondingly configured for each predicate data; and identifying a target technical check rule and a target service check rule from the configured multiple technical check rules and multiple service check rules according to predicate data of the test data to be checked.
Step S404, extracting technical item data and business item data contained in test data to be checked; according to the target technical verification rule, technical validity verification is carried out on the technical item data; and carrying out service validity check on the service item data according to the target service check rule.
Step S405, generating first correction prompt information corresponding to test data to be checked according to a target technology checking rule when the technical validity checking result is that the checking is not passed; and correcting the test data to be verified according to the first correction prompt information.
Step S406, generating second correction prompt information corresponding to the test data to be checked according to the target service check rule when the service validity check result is that the check fails; and correcting the test data to be verified according to the second correction prompt information.
Step S407, in the case of receiving a replacement instruction for the target test data, replacing the target test data with third target test data including the first target test data and/or the second target test data; the first target test data are obtained by modifying the target test data according to the first modification prompt information; the second target test data is obtained by modifying the target test data according to the second modification prompt information; and executing the third target test data.
In the verification and correction method of the test data in the financial information system, corresponding target technical verification rules and target service verification rules are determined by analyzing predicate data of the test data to be verified, and technical validity verification and service validity verification are respectively carried out on the test data to be verified; if the verification result is that the verification is not passed, correcting the test data to be verified; therefore, the test data to be checked is checked and corrected in a targeted and efficient way by utilizing a computer technology, and the generation of abnormal service data is effectively avoided; the verification and correction process of the whole test data is not needed to be greatly participated in, so that the inefficient process of manually verifying and correcting the test data one by related technicians is effectively avoided, and the test efficiency of the financial information system is greatly improved.
In order to more clearly clarify the verification and correction method of the test data in the financial information system provided by the embodiment of the application, a specific embodiment is used for specifically explaining the verification and correction method of the test data in the financial information system. In one embodiment, as shown in fig. 5, the application further provides a verification and correction method for test data in a financial information system, which specifically comprises the following steps:
step one: the security verification unit 1 performs statement pre-verification on the generated SQL (Structured Query Language ) statement, and is divided into the following sub-modules:
technical validity checking module: for the up-feed statement, respectively checking the technical legality:
query statement: when checking that the uploading statement has no query condition, checking is not passed; otherwise, checking is passed.
Newly added sentences: comparing the value of each field to be uploaded with the table structure, and checking that when the data types are inconsistent or the uploading length exceeds the field definition length, the check is not passed; otherwise, checking is passed.
Modifying the sentence: comparing the modified value of each field with the table structure, and checking that when the data type is inconsistent or the uploading length exceeds the field definition length, the check is not passed; otherwise, checking is passed.
Delete statement: checking that the record conforming to the deleting condition is larger than the parameter set value, and checking is not passed; otherwise, checking is passed.
And a service validity checking module: for the up-send statement, checking whether the business legitimacy meets the business legitimacy requirement of the financial information system or not respectively, and avoiding generating abnormal business data:
newly added sentences: multiple newly added service verification rules can be defined for each table, for example, for a personal information table T10, whether the newly added and sent certificate already has the same certificate or not is verified, if so, the verification is not passed; otherwise, checking is passed.
Modifying the sentence: multiple correction service verification rules can be defined for each table, such as for a personal information table T10, and verification of non-empty fields of a service, such as occupation, whether correction is empty or not, and if correction is empty, verification is not passed; otherwise, checking is passed.
Delete statement: multiple deletion service verification rules can be defined for each table, such as checking whether all certificates of the client are deleted or not for the unit information table T20, if so, the checking is not passed; otherwise, checking is passed.
Step two: the intelligent recommendation unit 2 can intelligently recommend statement replacement values for the statements which do not pass the verification.
Technical validity check is not passed, and the following rule is recommended:
Query statement: returning prompt information 'can not be queried in a full table', and suggesting an increasing condition where cino= 'uploading test client number'; after the tester fills in the customer number, the verification passes.
Newly added sentences: comparing the values of the fields to the table structure, checking that when the data types or lengths are inconsistent, the data types or lengths defined by the table structure are converted, for example, the data structures of the fields of the certificate types are defined as digital types, but the character '001' is sent to the uploading sentence, and the character '001' is automatically converted into the digital 1 and recommended.
Modifying the sentence: comparing the modified value of each field with the table structure, checking that when the data type is inconsistent or the length of the field is exceeded, converting the modified value into the data type or length defined by the table structure and recommending the modified value.
Delete statement: and if the record conforming to the deletion condition is checked to be larger than the parameter set value, returning a prompt message of deleting the record to be larger than the parameter value N and requesting to add the deletion condition.
The service validity check is not passed, and the recommendation is carried out according to the following rules:
newly added sentences: and respectively defining recommendation rules corresponding to a plurality of newly added service verification rules for each table, for example, checking whether the newly added and sent certificate already has the same certificate for the personal information table T10, if so, checking fails, generating a new number by using a random number for the certificate number, and recommending the new number to a tester.
Modifying the sentence: respectively defining recommendation rules corresponding to a plurality of correction service verification rules for each table, such as a personal information table T10, verifying whether a non-empty field of a service, such as occupation, is corrected to be empty, if so, verifying that the correction is not passed, replacing the original value of a database of the field which is not passed, and recommending the database to a tester; the value of the verification pass is unchanged.
Delete statement: and (3) defining recommendation rules corresponding to a plurality of deletion service verification rules for each table, for example, checking whether all certificates of the client are deleted for the unit information table T20, if so, checking not to pass, and adding deletion conditions: the certificate record ID is not equal to the account opening certificate record ID and is recommended to the tester.
Step three: the automatic replacement unit 3 returns the sentences generated by the intelligent recommendation unit to the testers, and the testers can choose not to accept the recommendation, so that the sentences are not executed any more; and if the testers choose to accept the recommendation, submitting the sentences generated by the intelligent recommendation unit to the database for execution.
The beneficial effects brought by the embodiment are as follows:
by using a safety threshold control tool, the test data to be checked is checked and corrected in a targeted and efficient way by using a computer technology, so that the generation of abnormal service data is effectively avoided, and the illegal data influence on the database is caused.
It should be understood that, although the steps in the flowcharts related to the embodiments described above are sequentially shown as indicated by arrows, these steps are not necessarily sequentially performed in the order indicated by the arrows. The steps are not strictly limited to the order of execution unless explicitly recited herein, and the steps may be executed in other orders. Moreover, at least some of the steps in the flowcharts described in the above embodiments may include a plurality of steps or a plurality of stages, which are not necessarily performed at the same time, but may be performed at different times, and the order of the steps or stages is not necessarily performed sequentially, but may be performed alternately or alternately with at least some of the other steps or stages.
Based on the same inventive concept, the embodiment of the application also provides a verification and correction device for the test data in the financial information system, which is used for realizing the verification and correction method for the test data in the financial information system. The implementation scheme of the device for solving the problem is similar to that described in the above method, so the specific limitation in the embodiments of the device for verifying and correcting the test data in one or more financial information systems provided below can be referred to the limitation of the method for verifying and correcting the test data in the financial information system hereinabove, and will not be repeated here.
In one embodiment, as shown in fig. 6, there is provided a verification and correction device for test data in a financial information system, including:
the data acquisition module 601 is configured to acquire test data to be verified; the test data to be verified consists of subject data, predicate data and object data; predicate data includes query, add, delete, or modify;
the rule determining module 602 is configured to determine a target technical verification rule and a target service verification rule according to predicate data of test data to be verified;
the data verification module 603 is configured to perform technical validity verification and service validity verification on test data to be verified according to a target technical verification rule and a target service verification rule, respectively, to obtain a technical validity verification result and a service validity verification result;
and the data correction module 604 is configured to correct the test data to be verified when any one of the technical validity check result and the service validity check result is that the verification fails.
In one embodiment, the verification and correction device for test data in the financial information system further comprises a rule acquisition module, configured to acquire a technical verification rule and a business verification rule which are respectively configured correspondingly for each predicate data; the rule determining module 602 is further configured to identify a target technical verification rule and a target service verification rule from the configured plurality of technical verification rules and the configured plurality of service verification rules according to predicate data of the test data to be verified.
In one embodiment, the data verification module 603 is further configured to extract technical term data and service term data included in the test data to be verified; according to the target technical verification rule, technical validity verification is carried out on the technical item data; and carrying out service validity check on the service item data according to the target service check rule.
In one embodiment, the data correction module 604 is further configured to generate, according to a target technology verification rule, first correction prompt information corresponding to the test data to be verified, if the technical validity verification result is that the verification fails; and correcting the test data to be verified according to the first correction prompt information.
In one embodiment, the data correction module 604 is further configured to generate, according to the target service verification rule, second correction prompt information corresponding to the test data to be verified, if the service validity verification result is that the verification fails; and correcting the test data to be verified according to the second correction prompt information.
In one embodiment, the verification and correction device for test data in the financial information system further includes a data replacement module, configured to replace the test data to be verified with third test data to be verified including the first test data to be verified and/or the second test data to be verified, when a replacement instruction for the test data to be verified is received; the first test data to be checked is obtained by modifying the test data to be checked according to the first modification prompt information; the second test data to be checked is obtained by modifying the test data to be checked according to the second modification prompt information; and executing the third test data to be verified.
In one embodiment, the verification and correction device for the test data in the financial information system further comprises a preliminary verification module, which is used for detecting whether the test data to be verified has data missing; determining a data missing part under the condition that the data missing of the test data to be checked is detected; and generating perfect prompt information of the test data to be checked according to the data missing part and ending the checking flow.
All or part of each module in the verification and correction device for the test data in the financial information system can be realized by software, hardware and a combination 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, the internal structure of which may be as shown in fig. 7. The computer device includes a processor, a memory, an Input/Output interface (I/O) and a communication interface. The processor, the memory and the input/output interface are connected through a system bus, and the communication interface is connected to the system bus through the input/output interface. 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 database of the computer equipment is used for storing technical check rules, business check rules and other data. The input/output interface of the computer device is used to exchange information between the processor and the external device. The communication interface of the computer device is used for communicating with an external terminal through a network connection. The computer program, when executed by the processor, implements a method for verifying and modifying test data in a financial information system.
It will be appreciated by those skilled in the art that the structure shown in FIG. 7 is merely a block diagram of some of the structures associated with the present inventive arrangements and is not limiting of the computer device to which the present inventive arrangements may be applied, and that a particular computer device may include more or fewer components than shown, or may combine some of the components, or have a different arrangement of components.
In one embodiment, a computer device is provided, comprising a memory and a processor, the memory having stored therein a computer program, the processor implementing the steps of the method embodiments described above when the computer program is executed.
In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored which, when executed by a processor, carries out the steps of the method embodiments described above.
In an embodiment, a computer program product is provided, comprising a computer program which, when executed by a processor, implements the steps of the method embodiments described above.
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, database, or other medium used in embodiments provided herein may include at least one of non-volatile and volatile memory. The nonvolatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical Memory, high density embedded nonvolatile Memory, resistive random access Memory (ReRAM), magnetic random access Memory (Magnetoresistive Random Access Memory, MRAM), ferroelectric Memory (Ferroelectric Random Access Memory, FRAM), phase change Memory (Phase Change Memory, PCM), graphene Memory, and the like. Volatile memory can include random access memory (Random Access Memory, RAM) or external cache memory, and the like. By way of illustration, and not limitation, RAM can be in the form of a variety of forms, such as static random access memory (Static Random Access Memory, SRAM) or dynamic random access memory (Dynamic Random Access Memory, DRAM), and the like. The databases referred to in the embodiments provided herein may include at least one of a relational database and a non-relational database. The non-relational database may include, but is not limited to, a blockchain-based distributed database, and the like. The processor referred to in the embodiments provided in the present application may be a general-purpose processor, a central processing unit, a graphics processor, a digital signal processor, a programmable logic unit, a data processing logic unit based on quantum computing, or the like, but is not limited thereto.
The technical features of the above embodiments may be arbitrarily combined, and all possible combinations of the technical features in the above embodiments are not described for brevity of description, however, as long as there is no contradiction between the combinations of the technical features, they should be considered as the scope of the description.
The foregoing examples illustrate only a few embodiments of the application and are described in detail herein without thereby limiting the scope of the application. It should be noted that it will be apparent to those skilled in the art that several variations and modifications can be made without departing from the spirit of the application, which are all within the scope of the application. Accordingly, the scope of the application should be assessed as that of the appended claims.

Claims (11)

1. A method for verifying and correcting test data in a financial information system, the method comprising:
obtaining test data to be verified; the test data to be verified consists of subject data, predicate data and object data; the predicate data includes queries, additions, deletions, or modifications;
determining a target technical verification rule and a target service verification rule according to predicate data of the test data to be verified;
According to the target technical verification rule and the target service verification rule, respectively carrying out technical validity verification and service validity verification on the test data to be verified to obtain a technical validity verification result and a service validity verification result;
and correcting the test data to be verified under the condition that any one of the technical validity verification result and the service validity verification result is that verification fails.
2. The method of claim 1, further comprising, prior to determining a target technology verification rule and a target traffic verification rule based on predicate data of the test data to be verified:
acquiring a technical check rule and a business check rule which are respectively and correspondingly configured for each predicate data;
the determining a target technical verification rule and a target service verification rule according to the predicate data of the test data to be verified comprises the following steps:
and identifying a target technical check rule and a target service check rule from the configured multiple technical check rules and multiple service check rules according to the predicate data of the test data to be checked.
3. The method according to claim 1, wherein the performing technical validity check and service validity check on the test data to be checked according to the target technical check rule and the target service check rule respectively includes:
Extracting technical item data and business item data contained in the test data to be checked;
performing technical validity verification on the technical item data according to the target technical verification rule;
and carrying out service validity verification on the service item data according to the target service verification rule.
4. The method according to claim 1, wherein, in the case that any one of the technical validity check result and the service validity check result is that the check fails, correcting the test data to be checked includes:
generating first correction prompt information corresponding to the test data to be verified according to the target technology verification rule under the condition that the technology validity verification result is that verification fails;
and correcting the test data to be verified according to the first correction prompt information.
5. The method according to claim 1, wherein, in the case that any one of the technical validity check result and the service validity check result is that the check fails, correcting the test data to be checked further includes:
generating second correction prompt information corresponding to the test data to be checked according to the target service check rule under the condition that the service validity check result is that the check is not passed;
And correcting the test data to be verified according to the second correction prompt information.
6. The method according to any one of claims 1 to 5, further comprising:
under the condition that a replacement instruction for the test data to be verified is received, replacing the test data to be verified with third test data to be verified, wherein the third test data to be verified comprises first test data to be verified and/or second test data to be verified; the first test data to be verified is obtained by modifying the test data to be verified according to the first modification prompt information; the second test data to be verified is obtained by modifying the test data to be verified according to the second modification prompt information;
and executing the third test data to be verified.
7. The method of claim 1, further comprising, after obtaining the test data to be verified:
detecting whether the test data to be checked has data missing or not;
determining a data missing part under the condition that the data missing of the test data to be checked is detected;
and generating perfect prompt information of the test data to be checked according to the data missing part and ending the checking flow.
8. A verification and correction device for test data in a financial information system, the device comprising:
the data acquisition module is used for acquiring test data to be checked; the test data to be verified consists of subject data, predicate data and object data; the predicate data includes queries, additions, deletions, or modifications;
the rule determining module is used for determining a target technical checking rule and a target service checking rule according to predicate data of the test data to be checked;
the data verification module is used for respectively carrying out technical validity verification and business validity verification on the test data to be verified according to the target technical verification rule and the target business verification rule to obtain a technical validity verification result and a business validity verification result;
and the data correction module is used for correcting the test data to be verified under the condition that any one of the technical validity verification result and the service validity verification result is not passed.
9. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor implements the steps of the method of any of claims 1 to 7 when the computer program is executed.
10. A computer readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the steps of the method of any of claims 1 to 7.
11. A computer program product comprising a computer program, characterized in that the computer program, when being executed by a processor, implements the steps of the method of any of claims 1 to 7.
CN202310944416.8A 2023-07-28 2023-07-28 Verification and correction method, device and equipment for test data in financial information system Pending CN116881164A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202310944416.8A CN116881164A (en) 2023-07-28 2023-07-28 Verification and correction method, device and equipment for test data in financial information system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202310944416.8A CN116881164A (en) 2023-07-28 2023-07-28 Verification and correction method, device and equipment for test data in financial information system

Publications (1)

Publication Number Publication Date
CN116881164A true CN116881164A (en) 2023-10-13

Family

ID=88262054

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202310944416.8A Pending CN116881164A (en) 2023-07-28 2023-07-28 Verification and correction method, device and equipment for test data in financial information system

Country Status (1)

Country Link
CN (1) CN116881164A (en)

Similar Documents

Publication Publication Date Title
CN109474578B (en) Message checking method, device, computer equipment and storage medium
CN109800258B (en) Data file deployment method, device, computer equipment and storage medium
CN111090788B (en) json file comparison method and device, storage medium and computer equipment
CN112181804A (en) Parameter checking method, equipment and storage medium
CN112328499A (en) Test data generation method, device, equipment and medium
CN111159482A (en) Data verification method and system
CN116881164A (en) Verification and correction method, device and equipment for test data in financial information system
CN114490415A (en) Service testing method, computer device, storage medium, and computer program product
CN116881163A (en) Method, device and equipment for generating and processing test data in financial information system
CN114741673B (en) Behavior risk detection method, clustering model construction method and device
CN117278625A (en) Message conversion method, device, computer equipment and storage medium
CN117151887A (en) Authority adjusting method, authority adjusting device, computer equipment and storage medium
CN116756393A (en) Site information batch maintenance method and device, electronic equipment and storage medium
CN117453661A (en) Resource allocation method, device, computer equipment and storage medium
CN115660875A (en) Account data processing method and device, computer equipment and storage medium
CN115629958A (en) Universal field level automatic checking method and device for different service interfaces
CN117610815A (en) Resource quota data processing method, device, computer equipment and storage medium
CN117708151A (en) Data processing method and device and computer equipment
CN114238367A (en) Asset security information management method and device and computer equipment
CN116228305A (en) Data verification method, device, computer equipment and storage medium
CN117827832A (en) Data verification method, device, computer equipment and storage medium
CN115695173A (en) Network security exception access method, apparatus, device, medium and program product
CN117112424A (en) Method, device, equipment, medium and product for generating test case
CN117971649A (en) Data processing method, device, computer equipment and storage medium
CN115827478A (en) Code viewing method and device, computer equipment and storage medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination