CN110609790A - Analytic program test method, device, medium and computer equipment - Google Patents

Analytic program test method, device, medium and computer equipment Download PDF

Info

Publication number
CN110609790A
CN110609790A CN201910817141.5A CN201910817141A CN110609790A CN 110609790 A CN110609790 A CN 110609790A CN 201910817141 A CN201910817141 A CN 201910817141A CN 110609790 A CN110609790 A CN 110609790A
Authority
CN
China
Prior art keywords
bill data
verification
analysis
verified
verification result
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
CN201910817141.5A
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.)
OneConnect Smart Technology Co Ltd
Original Assignee
OneConnect Smart Technology Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by OneConnect Smart Technology Co Ltd filed Critical OneConnect Smart Technology Co Ltd
Priority to CN201910817141.5A priority Critical patent/CN110609790A/en
Publication of CN110609790A publication Critical patent/CN110609790A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/36Preventing errors by testing or debugging software
    • G06F11/3668Software testing
    • G06F11/3672Test management
    • G06F11/3688Test management for test execution, e.g. scheduling of test suites
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/36Preventing errors by testing or debugging software
    • G06F11/3668Software testing
    • G06F11/3672Test management
    • G06F11/3692Test management for test results analysis

Abstract

The invention provides a method and a device for testing an analytic program, a computer storage medium and computer equipment; the method comprises the following steps: responding to an analysis program test instruction, and acquiring analysis bill data of a target user account analyzed by a latest analysis program within a preset time interval; determining an analysis program updating identifier corresponding to the analysis program test instruction; if the analysis program update identification is a first update identification, verifying the analysis bill data according to a first verification rule to obtain a first verification result, and determining the first verification result as a test result of the latest analysis program; and if the update identifier of the analysis program is a second update identifier, verifying the analysis bill data according to a second verification rule to obtain a second verification result, and determining the second verification result as the test result of the latest analysis program. The technical scheme of the invention can fully and reasonably utilize the test resources and effectively improve the test efficiency of the analysis program.

Description

Analytic program test method, device, medium and computer equipment
Technical Field
The invention relates to the field of computers, in particular to a method, a device, a medium and computer equipment for testing an analytic program.
Background
Bank card information, such as credit card billing data, that is visible on non-banking platforms is crawled and parsed from the bank's official website by a parser. In order to ensure that the information of the bank card seen by the user on the platform is consistent with the information of the bank card seen by the user who personally visits a bank official website. When the parser is updated, it must be tested by a tester before it is released formally.
The reasons for the update of the parser in the actual situation are:
1. when the analysis program analyzes data, no problem occurs, the bank official website does not update or change the version of the data, but the analysis program is updated due to other functional requirements;
2. when the analysis program analyzes the bill data, problems occur, such as analysis errors caused by updating or revising the bank official network data.
However, in actual testing, no matter what the reason for updating the parser is, the updated parser needs to be tested as long as the parser is updated, and the testing mode is consistent, that is, the bank card information generated by the user within the preset time interval, such as the credit card billing data of the last 12 months, is manually verified by the tester.
The test mode does not perform targeted test according to the update reason of the analysis program, more test resources are wasted, and the manual verification mode is low in efficiency.
Disclosure of Invention
The invention provides a method, a device, a medium and a computer device for testing an analysis program aiming at the defects of the prior art.
An embodiment of the present invention provides a method for testing an analysis program according to a first aspect, including:
responding to an analysis program test instruction, and acquiring analysis bill data of a target user account analyzed by a latest analysis program within a preset time interval;
determining an analysis program updating identifier corresponding to the analysis program test instruction;
if the analysis program update identification is a first update identification, verifying the analysis bill data according to a first verification rule to obtain a first verification result, and determining the first verification result as a test result of the latest analysis program;
and if the update identifier of the analysis program is a second update identifier, verifying the analysis bill data according to a second verification rule to obtain a second verification result, and determining the second verification result as the test result of the latest analysis program.
Further, the verifying the parsed bill data according to the first verification rule to obtain a first verification result includes:
taking the obtained analysis bill data of the target user account analyzed by the analysis program of the previous version in a preset time interval as verification bill data;
and comparing the analyzed bill data with the verified bill data to obtain a first verification result.
Further, the comparing the parsed bill data with the verified bill data to obtain a first verification result includes:
comparing key fields of each analyzed bill record in the analyzed bill data with each verified bill record in the verified bill data;
if the comparison is consistent, determining that the first verification result is successful;
and if the comparison is inconsistent, determining that the first verification result is test failure.
Further, the verifying the analyzed bill data according to a second verification rule to obtain a second verification result includes:
obtaining verified bill data successfully tested and verified last time;
according to the verified bill data, splitting the analyzed bill data into machine verified bill data and manual verified bill data;
processing the verified bill data and the machine verified bill data according to a preset machine verification rule to obtain a machine verification result;
sending a data verification request containing the manual verification bill data to a manual verification terminal, and receiving a manual verification result fed back by the manual verification terminal;
and obtaining a second verification result according to the machine verification result and the manual verification result.
Further, the parsed bill data includes at least one parsed bill record; the verified billing data comprises at least one verified billing record;
the splitting the parsed bill data into machine-verified bill data and manual-verified bill data according to the verified bill data includes:
determining a time interval corresponding to the verified bill data;
determining the recording time corresponding to each analysis bill record in the analysis bill data;
analyzing bill records of which the recording time does not belong to the time interval in the analyzed bill data to serve as manual verification bill data;
and in the analysis bill data, taking the analysis bill record with the recording time belonging to the time interval as machine verification bill data.
Further, the processing the verified bill data and the machine verified bill data according to a preset machine verification rule to obtain a machine verification result includes:
importing the verified bill data into a first reconciliation table, and importing the machine verified bill data into a second reconciliation table, wherein the field formats of the first reconciliation table and the second reconciliation table are the same;
sending a preset SOL statement to a preset database so that the preset database can carry out account rolling processing on the first account table and the second account table;
and taking the received account rolling result fed back by the database as a machine verification result.
Further, the obtaining a second verification result according to the machine verification result and the manual verification result includes:
and if the second verification result is that the test is successful, storing the analyzed bill data as verified bill data successfully verified by the test.
An embodiment of the present invention provides an analytic program test apparatus according to a second aspect, including:
the analysis data acquisition module is used for responding to an analysis program test instruction and acquiring analysis bill data of a target user account analyzed by the latest analysis program within a preset time interval;
the updating identification determining module is used for determining the analysis program updating identification corresponding to the analysis program testing instruction;
the first verification module is used for verifying the analysis bill data according to a first verification rule to obtain a first verification result when the analysis program update identifier is the first update identifier, and determining the first verification result as the test result of the latest analysis program;
and the second verification module is used for verifying the analysis bill data according to a second verification rule to obtain a second verification result when the analysis program update identifier is a second update identifier, and determining the second verification result as the test result of the latest analysis program.
Embodiments of the present invention provide according to a third aspect a computer readable storage medium, on which a computer program is stored, which when executed by a processor implements the analytical program testing method described above.
An embodiment of the present invention provides a computer device according to a fourth aspect, the computer device including:
one or more processors;
storage means for storing one or more programs;
when the one or more programs are executed by the one or more processors, the one or more processors are caused to implement the analytical program testing method described above.
In the embodiment of the invention, by responding to the analysis program test instruction, analysis bill data of a target user account analyzed by the latest analysis program in a preset time interval is obtained; determining an analysis program updating identifier corresponding to the analysis program test instruction; if the analysis program update identifier is a first update identifier, verifying the analysis bill data according to a first verification rule to obtain a first verification result, and determining the first verification result as a test result of the latest analysis program; if the analysis program update identifier is the second update identifier, the analysis bill data is verified according to a second verification rule to obtain a second verification result, and the second verification result is determined as the test result of the latest analysis program, so that the test resources can be fully and reasonably utilized, and the test efficiency of the analysis program is effectively improved.
Additional aspects and advantages of the invention will be set forth in part in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention.
Drawings
The foregoing and/or additional aspects and advantages of the present invention will become apparent and readily appreciated from the following description of the embodiments, taken in conjunction with the accompanying drawings of which:
FIG. 1 is a flow chart illustrating a method for analyzing a program test according to an embodiment of the present invention;
FIG. 2 is a schematic structural diagram of a program analysis testing apparatus according to an embodiment of the present invention;
fig. 3 is a schematic structural diagram of a computer device according to an embodiment of the present invention.
Detailed Description
Reference will now be made in detail to embodiments of the present invention, examples of which are illustrated in the accompanying drawings, wherein like or similar reference numerals refer to the same or similar elements or elements having the same or similar function throughout. The embodiments described below with reference to the drawings are illustrative only and should not be construed as limiting the invention.
It will be understood by those skilled in the art that, unless otherwise specified, the singular forms "a", "an", "the" and "the" may include the plural forms as well, and the "first" and "second" used herein are only used to distinguish one technical feature from another and are not intended to limit the order, number, etc. of the technical features. It will be further understood that the terms "comprises" and/or "comprising," when used in this specification, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof.
It will be understood by those skilled in the art that, unless otherwise defined, all terms (including technical and scientific terms) used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention belongs. It will be further understood that terms, such as those defined in commonly used dictionaries, should be interpreted as having a meaning that is consistent with their meaning in the context of the prior art and will not be interpreted in an idealized or overly formal sense unless expressly so defined herein.
The embodiment of the invention provides an analytic program test method, and the following describes in detail a specific implementation manner of the invention with reference to the accompanying drawings. As shown in fig. 1, the analytic program test method provided in the embodiment of the present invention includes the following steps:
s110: responding to an analysis program test instruction, and acquiring analysis bill data of a target user account analyzed by a latest analysis program within a preset time interval;
s120: determining an analysis program updating identifier corresponding to the analysis program test instruction;
s130: if the analysis program update identification is a first update identification, verifying the analysis bill data according to a first verification rule to obtain a first verification result, and determining the first verification result as a test result of the latest analysis program;
s140: and if the update identifier of the analysis program is a second update identifier, verifying the analysis bill data according to a second verification rule to obtain a second verification result, and determining the second verification result as the test result of the latest analysis program.
It should be noted that, in a common test, a tester needs to manually verify and analyze the bill data in full, the analysis of the bill data refers to analyzing the bill data obtained by analyzing the unresolved bill data after an analysis program crawls the unresolved bill data from a bank official website, and the full verification refers to verifying all analyzed bill data. Considering that the update of the analysis program is not caused by inaccurate analysis data of the analysis program, in this embodiment, two verification rules for verifying the analysis bill data are formulated according to the update reason of the analysis program, and the corresponding verification rule is selected according to the analysis program test instruction issued by the tester to verify the analysis bill data during the test, so that the test resources can be fully and reasonably utilized, the workload of the tester is reduced, the test process is shortened, the test efficiency of the analysis program is improved, and the analysis program can be more quickly issued to the production environment.
Specifically, when the analysis program needs to be tested, a tester issues an analysis program test instruction to a test server, when the test server receives the analysis program test instruction, the bank official network information and the target user account information associated with the analysis program test instruction are determined, the latest version of the analysis program is used, namely the latest analysis program crawls the bill data of the target user account within a preset time interval from the bank official network information to the bank official network, and further analyzes the crawled bill data to obtain the analysis bill data. The bank official website information refers to bank official website addresses, the number of the website addresses is determined by a tester according to a specific application scene, for example, whether bill data obtained by crawling and analyzing from 10 bank official websites is correct or not needs to be tested in a certain test, then 10 bank official website addresses need to be accurate, target user account numbers are login information used for logging in the bank official websites and include information such as login account number names and login passwords, the target user account numbers also need to be prepared in advance by the tester, the number of the account numbers can be determined by the tester according to the specific application scene, the invention is not limited to this, it can be understood that each bank official website address corresponds to at least one target user account number, and the preset time interval can also be set according to the specific application scene, for example, 12 months and the like. The following is an example to aid in understanding the process of obtaining parsed bill data during testing: in a certain test, only the safe bank needs to be tested, so that the bank official website information only comprises bank official website ebank. pingan. com. cn/xxx of the safe bank, the corresponding target user account numbers are Zhang III and Li IV, the analytic program in the test respectively uses the login information of Zhang III and Li IV to log in the safe bank official website, and then data crawling and analytic operation is carried out to obtain the credit card bill data of Zhang III and Li IV in about 12 months.
And after the test server analyzes the analyzed bill data, determining an analysis program update identifier which is corresponding to the analysis program test instruction and used for indicating an update reason of the analysis program, wherein the analysis program update identifier may be a first update identifier or a second update identifier, the first update identifier indicates that the update reason of the analysis program is that the analysis program does not have a problem when analyzing the data, the bank official website does not update or change the version of the data, but the analysis program has other functional requirements, so that a developer updates the analysis program, and the second update identifier indicates that the update reason of the analysis program is that the analysis program has a problem when analyzing the bill data, for example, analysis errors are caused by update or change of the bank official website data.
The test server needs to determine which parser update identifier corresponding to the parser test instruction is, and selects a corresponding verification rule according to the determination result to verify the parsed bill data. Specifically, if the parser update identifier is a first update identifier, the parser bill data is verified according to a first verification rule to obtain a first verification result, and if the parser update identifier is a second update identifier, the parser bill data is verified according to a second verification rule to obtain a second verification result, and finally the obtained verification result, that is, the first verification result or the second verification result, is determined as the test result of the latest parser.
In one embodiment, in step S130, verifying the parsed bill data according to a first verification rule to obtain a first verification result, specifically including:
s131: taking the obtained analysis bill data of the target user account analyzed by the analysis program of the previous version in a preset time interval as verification bill data;
s132: and comparing the analyzed bill data with the verified bill data to obtain a first verification result.
Specifically, step S132: comparing the analyzed bill data with the verified bill data to obtain a first verification result, wherein the first verification result comprises:
comparing key fields of each analyzed bill record in the analyzed bill data with each verified bill record in the verified bill data;
if the comparison is consistent, determining that the first verification result is successful;
and if the comparison is inconsistent, determining that the first verification result is test failure.
In this embodiment, when the analysis update program is the first update identifier, since the data of the bank official website is not changed, and the analysis program of the previous version has no problem in analyzing the bill data, that is, the analysis program of the previous version can correctly analyze the bill data crawled by the official website, so that the bill data can be verified without manual verification, and only by crawling to the bank official website by using the latest analysis program and the analysis program of the previous version and analyzing the bill data in the same preset time interval, and comparing the two bill data, it can be determined whether the latest analysis program can correctly analyze the bill data.
This embodiment does not need the tester to carry out manual verification to analysis bill data, can greatly reduced tester's work load to machine verification is for manual verification, verifies that speed is faster and the error rate is lower.
In one embodiment, in step S140, verifying the parsed bill data according to a second verification rule to obtain a second verification result, specifically including:
s141: obtaining verified bill data successfully tested and verified last time;
s142: according to the verified bill data, splitting the analyzed bill data into machine verified bill data and manual verified bill data;
s143: processing the verified bill data and the machine verified bill data according to a preset machine verification rule to obtain a machine verification result;
s144: sending a data verification request containing the manual verification bill data to a manual verification terminal, and receiving a manual verification result fed back by the manual verification terminal;
s145: and obtaining a second verification result according to the machine verification result and the manual verification result.
Corresponding to claim 3, it should be noted that,
in this embodiment, when the analysis update program is the second update identifier, the bank official website updates or changes the version of the data, so the analysis program needs to be updated accordingly, otherwise, an error occurs when the bill data is analyzed, and the analysis bill data obtained by crawling and analyzing the latest analysis program from the bank official website can be confirmed by a tester only by manual confirmation of whether the analysis bill data is consistent with the bill data seen from the bank official website, and it can be determined that the accuracy of the analysis bill data by the latest analysis program is not problematic only by confirmation of data consistency.
However, considering that the analysis bill data successfully tested and verified last time, that is, the two data sets of the verified bill data and the analysis bill data may have an intersection, the test server may verify the intersection bill data according to a preset comparison rule, and the non-intersection part in the analysis bill data may only be verified by the tester in person because there is no corresponding bill data that passes the verification. Therefore, the analyzed bill data can be divided into two parts of bill data, namely machine verification bill data and manual verification bill data, wherein the machine verification bill data is verified by a machine, namely a test server, and the manual verification bill data needs to be sent to a manual verification terminal and verified manually.
For example, the latest parsing program parses the bill data of the last 12 months of the peace bank credit card crawled by the user zhang in the peace bank, and then parses the crawled data to obtain the parsing result, so as to obtain the bill data of 2018 months 1-12, if the obtained verified bill data successfully verified in the last test is the bill data of 2017 months 9-18 months 8, it can be determined that the non-intersection bill data between the parsed bill data and the verified bill data is the bill data of 2018 months 9-12, and the data that the tester needs to verify in the test, that is, the manually verified bill data is the bill data of 2018 months 9-12 months and 4 months instead of 2018 months 1-12.
And finally, determining a second verification result according to a machine verification result obtained by verification of the test server and a manual verification result fed back by the manual verification terminal. If the machine verification result and the manual verification result are both verification successful, then the second verification result may be determined to be test successful, and if the machine verification result fails verification, or the manual verification result fails verification, or both verification fails, then the second verification result is determined to be test failed.
In this embodiment, verified bill data that is successfully verified in a history test, for example, verified bill data that is successfully verified last time, is stored, and is compared with analyzed bill data that needs to be verified in a next test when the next test is performed, so that the analyzed bill data can be divided into two parts of bill data, and a tester only needs to be responsible for verifying one part of bill data, which effectively reduces the amount of bill data that needs to be verified by the tester, and particularly when the analysis program is frequently updated, the method provided by this embodiment can more significantly reduce the amount of bill data that is responsible for verification in each test by the tester, thereby improving the test efficiency of the analysis program and indirectly accelerating the issuing speed of the analysis program.
In one embodiment, the parsed bill data includes at least one parsed bill record; the verified billing data includes at least one verified billing record.
Step S142: splitting the analyzed bill data into machine-verified bill data and manual-verified bill data according to the verified bill data, specifically comprising:
determining a time interval corresponding to the verified bill data;
determining the recording time corresponding to each analysis bill record in the analysis bill data;
analyzing bill records of which the recording time does not belong to the time interval in the analyzed bill data to serve as manual verification bill data;
and in the analysis bill data, taking the analysis bill record with the recording time belonging to the time interval as machine verification bill data.
In this embodiment, by comparing the recording time with the time interval, it can be determined that the analysis bill data is repeated with the verified bill data, that is, there is an intersection analysis bill record. For example, in the last test, the analyzed bill data obtained by analysis is the bill data generated by the target user account in 2018 from 1 month to 12 months, after the verification is successful, the analyzed bill data which is successfully verified is stored as the verified bill data, and the corresponding time interval is 2018 from 1 month to 12 months. The analysis bill record is a bank card consumption record of the user of the bank record, and the corresponding recording time is the time corresponding to the bank card consumption record.
In one embodiment, step S143: processing the verified bill data and the machine verified bill data according to a preset machine verification rule to obtain a machine verification result, which specifically comprises:
importing the verified bill data into a first reconciliation table, and importing the machine verified bill data into a second reconciliation table, wherein the field formats of the first reconciliation table and the second reconciliation table are the same;
sending a preset SOL statement to a preset database so that the preset database can carry out account rolling processing on the first account table and the second account table;
and taking the received account rolling result fed back by the database as a machine verification result.
In the present embodiment, when comparing the two data sets of the verified bill data and the machine bill data, one data set, such as the machine bill data, is taken as a reference, and then the other data set is circularly matched according to the field by one stroke, this matching logic involves two layers of cycles, and when the amount of data to be processed is large, the processing efficiency is very low.
The first reconciliation table and the second reconciliation table have the same field format and are the same table, and only bill data from different data sets are stored.
In the embodiment, the two data sets are matched by using the SQL statements provided by the database, so that the processing efficiency is improved. Such as SQL: select case where a. amp < > b. amp the 1 else 0 end from a join b. order _ no ═ b. order _ no, can find out the inconsistent sum.
The speed of the test server comparing the two data sets of the verified bill data and the machine bill data can be improved, and the test efficiency is further improved.
In one embodiment, step S145: obtaining a second verification result according to the machine verification result and the manual verification result, and then:
s146: and if the second verification result is that the test is successful, storing the analyzed bill data as verified bill data successfully verified by the test.
In this embodiment, during the storage, a preset time interval corresponding to the analyzed bill data is also used as a time interval, and a mapping relationship is established between the preset time interval and the analyzed bill data.
For example, during testing, the analysis program crawls the bill data of the peace and security bank user Zhang III in 2018 from 1 month to 12 months from the bank official website, after the testing is successful, the testing server stores the part of the bill data as the verified bill data, and establishes an association relation with the preset time interval, namely the time interval from 18 years from 1 month to 12 months, so that the time interval corresponding to the verified bill data can be determined during subsequent testing.
Specifically, during storage, it is also necessary to determine that a mapping relationship is established between the analyzed bill data and the test batch of the current test, so that during subsequent tests, verified bill data that passes the last test verification can be determined according to the test batch. The test lot may be a test time, or a test number, etc.
Preferably, in order to save memory space, the verified bill data of the last test may be saved only in the database, and the verified bill data of the last time or earlier may be deleted.
In order to better understand the technical solution of the present invention, the present invention further provides an analysis program testing apparatus, as shown in fig. 2, including the following modules:
the analysis data acquisition module 110 is configured to respond to an analysis program test instruction, and acquire analysis bill data of a target user account analyzed by a latest analysis program within a preset time interval;
an update identifier determining module 120, configured to determine an analysis program update identifier corresponding to the analysis program test instruction;
a first verification module 130, configured to, when the analysis program update identifier is a first update identifier, verify the analysis billing data according to a first verification rule to obtain a first verification result, and determine the first verification result as a test result of the latest analysis program;
and the second verification module 140 is configured to, when the analysis program update identifier is the second update identifier, verify the analysis billing data according to a second verification rule to obtain a second verification result, and determine the second verification result as the test result of the latest analysis program.
In one embodiment, the first authentication module 130 includes:
the verification data determining sub-module 131 is configured to use the obtained analysis bill data of the target user account analyzed by the analysis program of the previous version in a preset time interval as verification bill data;
the first result obtaining sub-module 132 is configured to compare the parsed bill data with the verified bill data to obtain a first verification result.
In an embodiment, the first result obtaining sub-module 132 specifically includes:
a field comparison unit: comparing key fields of each analyzed bill record in the analyzed bill data with each verified bill record in the verified bill data;
and the first result determining unit is used for determining that the first verification result is successful when the comparison is consistent, and determining that the first verification result is failed when the comparison is inconsistent.
In one embodiment, the second verification module 140 includes:
a verified data obtaining sub-module 141, configured to obtain verified bill data that is successfully verified in the previous test;
the analysis data splitting sub-module 142 is configured to split the analysis bill data into machine verification bill data and manual verification bill data according to the verified bill data;
a machine result obtaining sub-module 143, configured to process the verified bill data and the machine verified bill data according to a preset machine verification rule, so as to obtain a machine verification result;
a manual result receiving submodule 144, configured to send a data verification request including the manual verification billing data to a manual verification terminal, and receive a manual verification result fed back by the manual verification terminal;
and the second result obtaining submodule 145 is configured to obtain a second verification result according to the machine verification result and the manual verification result.
In one embodiment, the parsed bill data includes at least one parsed bill record; the verified billing data comprises at least one verified billing record;
the parsing data splitting sub-module 142 specifically includes:
the time interval determining unit is used for determining a time interval corresponding to the verified bill data;
the recording time determining unit is used for determining the recording time corresponding to each analysis bill record in the analysis bill data;
the manual data determining unit is used for taking the analysis bill records of which the recording time does not belong to the time interval in the analysis bill data as manual verification bill data;
and the machine data determining unit is used for taking the analysis bill record of which the recording time belongs to the time interval in the analysis bill data as machine verification bill data.
In one embodiment, the machine result obtaining sub-module 143 specifically includes:
the data import unit is used for importing the verified bill data into a first account checking table and importing the machine verified bill data into a second account checking table, and the field formats of the first account checking table and the second account checking table are the same;
the statement sending unit is used for sending a preset SOL statement to a preset database so that the preset database can carry out account rolling processing on the first account table and the second account table;
and the machine result obtaining unit is used for taking the received account rolling result fed back by the database as a machine verification result.
In an embodiment, after executing the function corresponding to the second result obtaining sub-module 145, the parsing program testing apparatus provided by the present invention further executes the following functions corresponding to the sub-modules:
and the verified data storage sub-module 146 is configured to, when the second verification result is that the test is successful, store the parsed bill data as verified bill data that is verified successfully in the current test.
It should be noted that the analysis program testing apparatus provided in the embodiment of the present invention can implement the functions implemented by the analysis program testing method, and specific implementation of the functions refers to the description in the analysis program testing method, which is not described herein again.
The embodiment of the invention also provides a computer readable storage medium, wherein a computer program is stored on the computer readable storage medium, and when the computer program is executed by a processor, the analytic program test method is realized. The storage medium includes, but is not limited to, any type of disk (including floppy disks, hard disks, optical disks, CD-ROMs, and magneto-optical disks), ROMs (Read-Only memories), RAMs (Random AcceSS memories), EPROMs (EraSable Programmable Read-Only memories), EEPROMs (Electrically EraSable Programmable Read-Only memories), flash memories, magnetic cards, or optical cards. That is, a storage medium includes any medium that stores or transmits information in a form readable by a device (e.g., a computer). Which may be a read-only memory, magnetic or optical disk, or the like.
An embodiment of the present invention further provides a computer device, where the computer device includes:
one or more processors 210;
a storage device 220 for storing one or more programs 200,
when the one or more programs 200 are executed by the one or more processors 210, the one or more processors 210 are caused to implement the analytical program testing method described above.
Fig. 3 is a schematic structural diagram of the computer device of the present invention, which includes a processor 210, a storage device 220, an input unit 230, a display unit 240, and other components. Those skilled in the art will appreciate that the structural elements shown in fig. 3 do not constitute a limitation of all computer devices and may include more or fewer components than those shown, or some of the components may be combined. The storage device 220 may be used to store the application program 200 and various functional modules, and the processor 210 executes the application program 200 stored in the storage device 220, thereby performing various functional applications of the apparatus and data processing. The storage 220 may be an internal memory or an external memory, or include both internal and external memories. The memory may comprise read-only memory, Programmable ROM (PROM), Electrically Programmable ROM (EPROM), Electrically Erasable Programmable ROM (EEPROM), flash memory, or random access memory. The external memory may include a hard disk, a floppy disk, a ZIP disk, a usb-disk, a magnetic tape, etc. The disclosed memory devices include, but are not limited to, these types of memory devices. The disclosed storage device 220 is provided by way of example only and not by way of limitation.
The input unit 230 is used for receiving input of signals and receiving related requests of selecting voice files and the like input by users. The input unit 230 may include a touch panel and other input devices. The touch panel can collect touch operations of a user on or near the touch panel (for example, operations of the user on or near the touch panel by using any suitable object or accessory such as a finger, a stylus and the like) and drive the corresponding connecting device according to a preset program; other input devices may include, but are not limited to, one or more of a physical keyboard, function keys (e.g., play control keys, switch keys, etc.), a trackball, a mouse, a joystick, and the like. The display unit 240 may be used to display information input by a user or information provided to the user and various menus of the computer device. The display unit 240 may take the form of a liquid crystal display, an organic light emitting diode, or the like. The processor 210 is a control center of the computer device, connects various parts of the entire computer using various interfaces and lines, and performs various functions and processes data by operating or executing software programs and/or modules stored in the storage device 220 and calling data stored in the storage device.
In one embodiment, a computer device includes one or more processors 210, and one or more storage devices 220, one or more applications 200, wherein the one or more applications 200 are stored in the storage device 220 and configured to be executed by the one or more processors 210, the one or more applications 200 configured to perform the analytical procedure testing method described in the above embodiments.
It should be understood that, although the steps in the flowcharts of the figures are shown in order as indicated by the arrows, the steps are not necessarily performed in order as indicated by the arrows. The steps are not performed in the exact order shown and may be performed in other orders unless explicitly stated herein. Moreover, at least a portion of the steps in the flow chart of the figure may include multiple sub-steps or multiple stages, which are not necessarily performed at the same time, but may be performed at different times, which are not necessarily performed in sequence, but may be performed alternately or alternately with other steps or at least a portion of the sub-steps or stages of other steps.
It should be understood that each functional unit in the embodiments of the present invention may be integrated into one processing module, each unit may exist alone physically, or two or more units may be integrated into one module. The integrated module can be realized in a hardware mode, and can also be realized in a software functional module mode.
The foregoing is only a partial embodiment of the present invention, and it should be noted that, for those skilled in the art, various modifications and decorations can be made without departing from the principle of the present invention, and these modifications and decorations should also be regarded as the protection scope of the present invention.

Claims (10)

1. An analytical procedure testing method, comprising:
responding to an analysis program test instruction, and acquiring analysis bill data of a target user account analyzed by a latest analysis program within a preset time interval;
determining an analysis program updating identifier corresponding to the analysis program test instruction;
if the analysis program update identification is a first update identification, verifying the analysis bill data according to a first verification rule to obtain a first verification result, and determining the first verification result as a test result of the latest analysis program;
and if the update identifier of the analysis program is a second update identifier, verifying the analysis bill data according to a second verification rule to obtain a second verification result, and determining the second verification result as the test result of the latest analysis program.
2. The analytical procedure testing method of claim 1,
the verifying the analyzed bill data according to the first verification rule to obtain a first verification result, including:
taking the obtained analysis bill data of the target user account analyzed by the analysis program of the previous version in a preset time interval as verification bill data;
and comparing the analyzed bill data with the verified bill data to obtain a first verification result.
3. The parser test method according to claim 2,
the comparing the analyzed bill data with the verified bill data to obtain a first verification result, including:
comparing key fields of each analyzed bill record in the analyzed bill data with each verified bill record in the verified bill data;
if the comparison is consistent, determining that the first verification result is successful;
and if the comparison is inconsistent, determining that the first verification result is test failure.
4. The analytical procedure testing method of claim 1,
the verifying the analyzed bill data according to the second verification rule to obtain a second verification result, including:
obtaining verified bill data successfully tested and verified last time;
according to the verified bill data, splitting the analyzed bill data into machine verified bill data and manual verified bill data;
processing the verified bill data and the machine verified bill data according to a preset machine verification rule to obtain a machine verification result;
sending a data verification request containing the manual verification bill data to a manual verification terminal, and receiving a manual verification result fed back by the manual verification terminal;
and obtaining a second verification result according to the machine verification result and the manual verification result.
5. The parser test method according to claim 4,
the analysis bill data comprises at least one analysis bill record; the verified billing data comprises at least one verified billing record;
the splitting the parsed bill data into machine-verified bill data and manual-verified bill data according to the verified bill data includes:
determining a time interval corresponding to the verified bill data;
determining the recording time corresponding to each analysis bill record in the analysis bill data;
analyzing bill records of which the recording time does not belong to the time interval in the analyzed bill data to serve as manual verification bill data;
and in the analysis bill data, taking the analysis bill record with the recording time belonging to the time interval as machine verification bill data.
6. The parser test method according to claim 4,
the processing the verified bill data and the machine verified bill data according to a preset machine verification rule to obtain a machine verification result, comprising:
importing the verified bill data into a first reconciliation table, and importing the machine verified bill data into a second reconciliation table, wherein the field formats of the first reconciliation table and the second reconciliation table are the same;
sending a preset SOL statement to a preset database so that the preset database can carry out account rolling processing on the first account table and the second account table;
and taking the received account rolling result fed back by the database as a machine verification result.
7. The parser test method according to claim 4,
obtaining a second verification result according to the machine verification result and the manual verification result, and then:
and if the second verification result is that the test is successful, storing the analyzed bill data as verified bill data successfully verified by the test.
8. An analytical program testing device, comprising:
the analysis data acquisition module is used for responding to an analysis program test instruction and acquiring analysis bill data of a target user account analyzed by the latest analysis program within a preset time interval;
the updating identification determining module is used for determining the analysis program updating identification corresponding to the analysis program testing instruction;
the first verification module is used for verifying the analysis bill data according to a first verification rule to obtain a first verification result when the analysis program update identifier is the first update identifier, and determining the first verification result as the test result of the latest analysis program;
and the second verification module is used for verifying the analysis bill data according to a second verification rule to obtain a second verification result when the analysis program update identifier is a second update identifier, and determining the second verification result as the test result of the latest analysis program.
9. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the analytical program testing method of any one of claims 1 to 7.
10. A computer device, characterized in that the computer device comprises:
one or more processors;
storage means for storing one or more programs;
when executed by the one or more processors, cause the one or more processors to implement the parser test method of any of claims 1-7.
CN201910817141.5A 2019-08-30 2019-08-30 Analytic program test method, device, medium and computer equipment Pending CN110609790A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201910817141.5A CN110609790A (en) 2019-08-30 2019-08-30 Analytic program test method, device, medium and computer equipment

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201910817141.5A CN110609790A (en) 2019-08-30 2019-08-30 Analytic program test method, device, medium and computer equipment

Publications (1)

Publication Number Publication Date
CN110609790A true CN110609790A (en) 2019-12-24

Family

ID=68891070

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201910817141.5A Pending CN110609790A (en) 2019-08-30 2019-08-30 Analytic program test method, device, medium and computer equipment

Country Status (1)

Country Link
CN (1) CN110609790A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112131128A (en) * 2020-09-29 2020-12-25 网易(杭州)网络有限公司 Data testing method, device, storage medium and electronic device

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112131128A (en) * 2020-09-29 2020-12-25 网易(杭州)网络有限公司 Data testing method, device, storage medium and electronic device
CN112131128B (en) * 2020-09-29 2023-08-22 网易(杭州)网络有限公司 Data testing method and device, storage medium and electronic device

Similar Documents

Publication Publication Date Title
KR102151326B1 (en) Data processing method and device
EP3396558B1 (en) Method for user identifier processing, terminal and nonvolatile computer readable storage medium thereof
CN110532461B (en) Information platform pushing method and device, computer equipment and storage medium
CN110046155B (en) Method, device and equipment for updating feature database and determining data features
EP3850516A1 (en) Optimized execution of fraud detection rules
CN111159227B (en) Data query method, device, equipment and storage medium
WO2019140850A1 (en) Test case recommendation method, electronic apparatus and readable storage medium
CN110609790A (en) Analytic program test method, device, medium and computer equipment
CN113778878A (en) Interface testing method and device, electronic equipment and storage medium
CN117495544A (en) Sandbox-based wind control evaluation method, sandbox-based wind control evaluation system, sandbox-based wind control evaluation terminal and storage medium
CN111159482A (en) Data verification method and system
CN115203300A (en) Data verification method and device
CN115658731A (en) Data query method, device, equipment and storage medium
US7516048B2 (en) Externalized metric calculation engine
CN112181485A (en) Script execution method and device, electronic equipment and storage medium
CN111767222A (en) Data model verification method and device, electronic equipment and storage medium
CN111901299A (en) Application authentication method and device, electronic equipment and storage medium
CN114327377B (en) Method and device for generating demand tracking matrix, computer equipment and storage medium
KR101737575B1 (en) Method and device for verifying data based on sql sentences generated automatically
CN117407430B (en) Data query method, device, computer equipment and storage medium
CN111666301B (en) Service interface testing method, computer device and storage medium
CN111158746B (en) Method and device for acquiring call relationship
CN117112389A (en) Code detection method, device, computer equipment and storage medium
CN117149745A (en) Report form checking method, device, equipment and storage medium of new and old systems
CN117194538A (en) Configuration and calling method, device and equipment of data service interface 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