CN105786695A - Data test method and system - Google Patents
Data test method and system Download PDFInfo
- Publication number
- CN105786695A CN105786695A CN201410835000.3A CN201410835000A CN105786695A CN 105786695 A CN105786695 A CN 105786695A CN 201410835000 A CN201410835000 A CN 201410835000A CN 105786695 A CN105786695 A CN 105786695A
- Authority
- CN
- China
- Prior art keywords
- data
- test
- verification
- file format
- integrated
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000010998 test method Methods 0.000 title claims abstract description 22
- 238000012360 testing method Methods 0.000 claims abstract description 213
- 238000012795 verification Methods 0.000 claims abstract description 118
- 238000004891 communication Methods 0.000 claims abstract description 65
- 230000008676 import Effects 0.000 claims abstract description 59
- 230000010354 integration Effects 0.000 claims abstract description 45
- 238000006243 chemical reaction Methods 0.000 claims description 10
- 238000000034 method Methods 0.000 description 80
- 230000008569 process Effects 0.000 description 24
- 238000012545 processing Methods 0.000 description 14
- 238000004088 simulation Methods 0.000 description 12
- 230000000454 anti-cipatory effect Effects 0.000 description 8
- 230000003247 decreasing effect Effects 0.000 description 6
- 238000013524 data verification Methods 0.000 description 5
- 238000005516 engineering process Methods 0.000 description 5
- 230000002159 abnormal effect Effects 0.000 description 4
- 238000012217 deletion Methods 0.000 description 4
- 230000037430 deletion Effects 0.000 description 4
- 238000003745 diagnosis Methods 0.000 description 4
- 238000007689 inspection Methods 0.000 description 4
- 238000013522 software testing Methods 0.000 description 3
- 238000010586 diagram Methods 0.000 description 2
- 230000008901 benefit Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000002452 interceptive effect Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
Landscapes
- Debugging And Monitoring (AREA)
Abstract
The invention provides a data test method and system. The data test method comprises the following steps: setting a plurality of communication file format templates according to a preset data integration interface standard; determining a corresponding communication file format template for test data in each integrated scene in the plurality of communication file format templates; importing the test data in each integrated scene into the corresponding communication file format template; automatically carrying out database check and system interface check on the imported test data; and generating a test report according to the check result. By adopting the data test method in the technical scheme provided by the invention, batch import of the integrated scene and the dependency relation of the test data is realized, multiple checks are automatically executed to improve the data test efficiency, and the problems of complex and time-consuming of test verification and low efficiency of large data integration software caused by the huge business message volume and the dependency relation of the business are solved, thereof the regression test workload is reduced, and the coverage and the quality of each turn of regression test are guaranteed.
Description
Technical field
The present invention relates to software testing technology field, in particular to a kind of data test method and a kind of data testing system.
Background technology
At present, along with informatization gradually to development integrated, the direction that becomes more meticulous, informatization has been introduced into SOA framework and ESB technology, meanwhile, the problem also bringing the dependence complexity of the uniformity of interface standard, the multiformity of data type, business datum access.
In the prior art, the testing process of software testing technology or instrument foundation includes: analogue recording, debugging playback, scene definition, dry run and report analysis, this testing process is for providing instrument or the test frame of automatic test, but there is three below aspect problem to be solved for data integration class software:
One, integrated software product too much and framework with to realize technology different, the input of same Software Testing Tool or these products of technical modelling or output difficulty, and cannot perfectly solve the interactive relation between these products.
Two, data interface standard is different.Data interface standard is not simple Excel form or TXT form, but there is the data interface standard of XML format or user-defined format, causes data to prepare simulation and difficult communication.
Three, there is batch processing and business dependence between data, be unfavorable for data tissue, call and verify.
It is thus desirable to a kind of new technical scheme, it is possible to by digital simulation, perform scheduling, automatically checking and combine, to ensure high efficiency and the correctness of data test.
Summary of the invention
The present invention is based on the problems referred to above, it is proposed that a kind of new technical scheme, it is possible to by digital simulation, performs scheduling, automatically checking and combines, to ensure high efficiency and the correctness of data test.
In view of this, a first aspect of the present invention proposes a kind of data test method, for data integration class software, including: according to preset data integrated interface standard, multiple communication file format module is set；In multiple described communication file format modules, determine the described communication file format module of correspondence for the test data in each Integrated scenario；Described test data in each described Integrated scenario are imported corresponding described communication file format module；Test data after importing are carried out automatically data base's verification and system interface verification；According to check results, generate test report.
In this technical scheme, it is provided that a kind of automation data method of testing based on the checking of big data iteration, it is possible to simulate the data integration interface standard of each integrated system.Test data frequently include multiple Integrated scenario, by this technical scheme, can for the data integration interface standard needed for each Integrated scenario, most suitable communication file format module is determined for this Integrated scenario, such that it is able to according to the data dependence relation in each Integrated scenario and each Integrated scenario, test batch data is imported test system according to processing sequence and integrated communication protocols.It addition, by this technical scheme, additionally provide common scene call method and batch data import call method, including recursive call with exit standard.And, by this technical scheme, additionally provide the data base's method of calibration after batch data imports, if data base verifies successfully, then perform the batch data of a business within this scene according to the data dependence relation in Integrated scenario to import, otherwise, exit this scene.In this technical scheme, additionally providing the system interface method of calibration after data import, its premise is data access is correct, and verifying successfully and verifying is unsuccessfully only affect integrated node system.Therefore, by this technical scheme, the batch of the dependence achieving Integrated scenario and test data thereof imports, and can automatically perform multiple check, including the verification of data access verification and each system demonstration correctness, thus automatically generating test report, it is ensured that the high efficiency of data test and correctness, achieving large data sets becomes software automatically to carry out data test, improves the efficiency of data test.Additionally, can also solve large data sets becomes class software to cause the problem testing checking complicated and time consumption, inefficiency owing to service message amount is huge and business exists dependence, thus decreasing regression test workload, it is ensured that every round regression tested coverage rate and quality.
In technique scheme, it is preferable that before described communication file format module is set, also include: according to the setting command received, described preset data integrated interface standard is set.
In this technical scheme, it is possible to the setting according to user, data integration interface standard is set voluntarily.In the prior art, the data integration interface standard of different Integrated scenarios is different, data integration interface standard is generally not simple excel form or txt form, and often there is the data integration interface standard of XML format or user-defined format, and this prepares simulation to data and all causes difficulty with communicating.And pass through the technical program, it is possible to need to arrange data integration interface standard voluntarily according to the test of user, thus the problem that the data integration interface standard that avoids the occurrence of Integrated scenario is incompatible, improve correctness and the convenience of data test.
In technique scheme, preferably, the described described communication file format module that described test data in each described Integrated scenario import correspondence, specifically includes: according to described test data, obtains described test data scene in described Integrated scenario and performs parameter；Described scene is performed the described communication file format module that Integrated scenario described in parameter read-in is corresponding, and performs parameter according to described scene, the described test data in described Integrated scenario are carried out data conversion.
In this technical scheme, according to the data dependence relation in each Integrated scenario and each Integrated scenario, different business communication interface file data in Same Scene or user-defined format file can be arranged, as the test data that follow-up batch imports, by that analogy, it is possible to be test for Integrated scenario for each and determine a communication file format module.In this technical scheme, according to data integration communication standard, it is provided that file introduction method, namely test data lead-in method, including: the write of digital independent, data parameters, data conversion and data send.Additionally, in this technical scheme, can also being that each Integrated scenario and data be introduced into row scheduling, this scheduling process specifically includes: read Integrated scenario configuration, read data process import the configuration of batch processing script, perform test scene, call data and import batch processing script, circular treatment, whether verify SQL, whether check system picture and normally exit or abnormal exit.
In technique scheme, preferably, described to import after test data automatically carry out data base's verification and system interface verification before, also include: read described test data described data base verification SQL and forecast database return result；And described to import after described test data carry out data base's verification, specifically include: according to the described SQL read, carry out described data base's verification for described test data；And described test data after importing are carried out automatically data base's verification and system interface verification after, also include: contrast described check results and described forecast database and return result, for generating described test report.
In this technical scheme, after batch data each time imports, will performing data base's checking procedure, data base's verification refers generally to, according to the definition accessing data type, data base carry out the operations such as data increase, amendment, deletion.Data base's verification specifically includes following methods: reading database batch verifies SQL, reading anticipatory data storehouse returns result, perform data base verifies SQL, Inspection result returns result with anticipatory data storehouse, additionally, in data base's checking procedure, it is also possible to carry out time-out setting.Wherein, after batch data each time processes and imports, or after data base's batch verification SQL, it is possible to perform verification at corresponding operation system interface, this verification includes the verification of verification and the inquiry correctness that data on interface are shown.This verification specifically includes following methods: read system executive, calling system program, system login are common, read data-driven configuration, read check results, data-driven performs, text verification, picture verification, element verification, time-out arrange, normally exit, extremely exit.
In technique scheme, it is preferable that also include: according to the form setting command received, the form of described test report is set；And after completing described data base verification, generate described test report according to described form.
In this technical scheme, it is possible to for each operation note daily record in data test process, and according to the form pre-set, generate the test report of specified format.Wherein, the process generating test report specifically includes: arranges report generation form, arrange report generation data, generate report, derive report.
A second aspect of the present invention proposes a kind of data testing system, for data integration class software, including: template-setup unit, according to preset data integrated interface standard, multiple communication file format module is set；Template determines unit, in multiple described communication file format modules, determines the described communication file format module of correspondence for the test data in each Integrated scenario；Data import unit, and the described test data in each described Integrated scenario are imported corresponding described communication file format module；Test data after importing are carried out data base's verification and system interface verification by data base's verification unit automatically；Report generation unit, according to check results, generates test report.
In this technical scheme, it is provided that a kind of automation data method of testing based on the checking of big data iteration, it is possible to simulate the data integration interface standard of each integrated system.Test data frequently include multiple Integrated scenario, by this technical scheme, can for the data integration interface standard needed for each Integrated scenario, most suitable communication file format module is determined for this Integrated scenario, such that it is able to according to the data dependence relation in each Integrated scenario and each Integrated scenario, test batch data is imported test system according to processing sequence and integrated communication protocols.It addition, by this technical scheme, additionally provide common scene call method and batch data import call method, including recursive call with exit standard.And, by this technical scheme, additionally provide the data base's method of calibration after batch data imports, if data base verifies successfully, then perform the batch data of a business within this scene according to the data dependence relation in Integrated scenario to import, otherwise, exit this scene.In this technical scheme, additionally providing the system interface method of calibration after data import, its premise is data access is correct, and verifying successfully and verifying is unsuccessfully only affect integrated node system.Therefore, by this technical scheme, the batch of the dependence achieving Integrated scenario and test data thereof imports, and can automatically perform multiple check, including the verification of data access verification and each system demonstration correctness, thus automatically generating test report, it is ensured that the high efficiency of data test and correctness, achieving large data sets becomes software automatically to carry out data test, improves the efficiency of data test.Additionally, can also solve large data sets becomes class software to cause the problem testing checking complicated and time consumption, inefficiency owing to service message amount is huge and business exists dependence, thus decreasing regression test workload, it is ensured that every round regression tested coverage rate and quality.
In technique scheme, it is preferable that also include: standard arranges unit, before arranging described communication file format module, according to the setting command received, described preset data integrated interface standard is set.
In this technical scheme, it is possible to the setting according to user, data integration interface standard is set voluntarily.In the prior art, the data integration interface standard of different Integrated scenarios is different, data integration interface standard is generally not simple excel form or txt form, and often there is the data integration interface standard of XML format or user-defined format, and this prepares simulation to data and all causes difficulty with communicating.And pass through the technical program, it is possible to need to arrange data integration interface standard voluntarily according to the test of user, thus the problem that the data integration interface standard that avoids the occurrence of Integrated scenario is incompatible, improve correctness and the convenience of data test.
In technique scheme, preferably, described data import unit specifically for: according to described test data, obtain described test data scene in described Integrated scenario and perform parameter, and described scene is performed the described communication file format module that Integrated scenario described in parameter read-in is corresponding, and perform parameter according to described scene, the described test data in described Integrated scenario are carried out data conversion.
In this technical scheme, according to the data dependence relation in each Integrated scenario and each Integrated scenario, different business communication interface file data in Same Scene or user-defined format file can be arranged, as the test data that follow-up batch imports, by that analogy, it is possible to be test for Integrated scenario for each and determine a communication file format module.In this technical scheme, according to data integration communication standard, it is provided that file introduction method, namely test data lead-in method, including: the write of digital independent, data parameters, data conversion and data send.Additionally, in this technical scheme, can also being that each Integrated scenario and data be introduced into row scheduling, this scheduling process specifically includes: read Integrated scenario configuration, read data process import the configuration of batch processing script, perform test scene, call data and import batch processing script, circular treatment, whether verify SQL, whether check system picture and normally exit or abnormal exit.
In technique scheme, preferably, also include: read unit, described to import after test data automatically carry out data base's verification and system interface verification before, read described test data described data base verification SQL and forecast database return result；And described data base's verification unit specifically for: according to the described SQL read, carry out described data base's verification for described test data；And described report generation unit is additionally operable to: described test data after importing are carried out automatically data base's verification and system interface verification after, contrast described check results and return result with described forecast database, for generating described test report.
In this technical scheme, after batch data each time imports, will performing data base's checking procedure, data base's verification refers generally to, according to the definition accessing data type, data base carry out the operations such as data increase, amendment, deletion.Data base's verification specifically includes following methods: reading database batch verifies SQL, reading anticipatory data storehouse returns result, perform data base verifies SQL, Inspection result returns result with anticipatory data storehouse, additionally, in data base's checking procedure, it is also possible to carry out time-out setting.Wherein, after batch data each time processes and imports, or after data base's batch verification SQL, it is possible to perform verification at corresponding operation system interface, this verification includes the verification of verification and the inquiry correctness that data on interface are shown.This verification specifically includes following methods: read system executive, calling system program, system login are common, read data-driven configuration, read check results, data-driven performs, text verification, picture verification, element verification, time-out arrange, normally exit, extremely exit.
In technique scheme, it is preferable that also include: form arranges unit, according to the form setting command received, the form of described test report is set；And described report generation unit is used for: after completing described data base verification, generate described test report according to described form.
In this technical scheme, it is possible to for each operation note daily record in data test process, and according to the form pre-set, generate the test report of specified format.Wherein, the process generating test report specifically includes: arranges report generation form, arrange report generation data, generate report, derive report.
By above technical scheme, the batch of the dependence achieving Integrated scenario and test data thereof imports, and can automatically perform multiple check, verification including data access verification and each system demonstration correctness, thus automatically generating test report, ensure that the high efficiency of data test and correctness, it is achieved that large data sets becomes software automatically to carry out data test, improves the efficiency of data test.Additionally, can also solve large data sets becomes class software to cause the problem testing checking complicated and time consumption, inefficiency owing to service message amount is huge and business exists dependence, thus decreasing regression test workload, it is ensured that every round regression tested coverage rate and quality.
Accompanying drawing explanation
Fig. 1 illustrates the flow chart of data test method according to an embodiment of the invention；
Fig. 2 illustrates the flow chart of data test method according to another embodiment of the invention；
Fig. 3 illustrates the block diagram of data testing system according to an embodiment of the invention.
Detailed description of the invention
In order to be more clearly understood that the above-mentioned purpose of the present invention, feature and advantage, below in conjunction with the drawings and specific embodiments, the present invention is further described in detail.It should be noted that when not conflicting, embodiments herein and the feature in embodiment can be mutually combined.
Elaborate a lot of detail in the following description so that fully understanding the present invention; but; the present invention can also adopt other to be different from other modes described here to implement, and therefore, protection scope of the present invention is by the restriction of following public specific embodiment.
Fig. 1 illustrates the flow chart of data test method according to an embodiment of the invention.
As it is shown in figure 1, data test method according to an embodiment of the invention, for data integration class software, including:
Step 102, according to preset data integrated interface standard, arranges multiple communication file format module.
Step 104, in multiple communication file format modules, determines the communication file format module of correspondence for the test data in each Integrated scenario.
Test data in each Integrated scenario are imported corresponding communication file format module by step 106.
Test data after importing are carried out data base's verification and system interface verification by step 108 automatically.
Step 110, according to check results, generates test report.
In this technical scheme, it is provided that a kind of automation data method of testing based on the checking of big data iteration, it is possible to simulate the data integration interface standard of each integrated system.Test data frequently include multiple Integrated scenario, by this technical scheme, can for the data integration interface standard needed for each Integrated scenario, most suitable communication file format module is determined for this Integrated scenario, such that it is able to according to the data dependence relation in each Integrated scenario and each Integrated scenario, test batch data is imported test system according to processing sequence and integrated communication protocols.It addition, by this technical scheme, additionally provide common scene call method and batch data import call method, including recursive call with exit standard.And, by this technical scheme, additionally provide the data base's method of calibration after batch data imports, if data base verifies successfully, then perform the batch data of a business within this scene according to the data dependence relation in Integrated scenario to import, otherwise, exit this scene.In this technical scheme, additionally providing the system interface method of calibration after data import, its premise is data access is correct, and verifying successfully and verifying is unsuccessfully only affect integrated node system.Therefore, by this technical scheme, the batch of the dependence achieving Integrated scenario and test data thereof imports, and can automatically perform multiple check, including the verification of data access verification and each system demonstration correctness, thus automatically generating test report, it is ensured that the high efficiency of data test and correctness, achieving large data sets becomes software automatically to carry out data test, improves the efficiency of data test.Additionally, can also solve large data sets becomes class software to cause the problem testing checking complicated and time consumption, inefficiency owing to service message amount is huge and business exists dependence, thus decreasing regression test workload, it is ensured that every round regression tested coverage rate and quality.
In technique scheme, it is preferable that before communication file format module is set, also include: according to the setting command received, preset data integrated interface standard is set.
In this technical scheme, it is possible to the setting according to user, data integration interface standard is set voluntarily.In the prior art, the data integration interface standard of different Integrated scenarios is different, data integration interface standard is generally not simple excel form or txt form, and often there is the data integration interface standard of XML format or user-defined format, and this prepares simulation to data and all causes difficulty with communicating.And pass through the technical program, it is possible to need to arrange data integration interface standard voluntarily according to the test of user, thus the problem that the data integration interface standard that avoids the occurrence of Integrated scenario is incompatible, improve correctness and the convenience of data test.
In technique scheme, it is preferable that the test data in each Integrated scenario are imported corresponding communication file format module, specifically includes: according to test data, obtain test data scene in Integrated scenario and perform parameter；Scene is performed the communication file format module that parameter read-in Integrated scenario is corresponding, and performs parameter according to scene, the test data in Integrated scenario are carried out data conversion.
In this technical scheme, according to the data dependence relation in each Integrated scenario and each Integrated scenario, different business communication interface file data in Same Scene or user-defined format file can be arranged, as the test data that follow-up batch imports, by that analogy, it is possible to be test for Integrated scenario for each and determine a communication file format module.In this technical scheme, according to data integration communication standard, it is provided that file introduction method, namely test data lead-in method, including: the write of digital independent, data parameters, data conversion and data send.Additionally, in this technical scheme, can also being that each Integrated scenario and data be introduced into row scheduling, this scheduling process specifically includes: read Integrated scenario configuration, read data process import the configuration of batch processing script, perform test scene, call data and import batch processing script, circular treatment, whether verify SQL, whether check system picture and normally exit or abnormal exit.
In technique scheme, it is preferable that before the test data after importing are carried out automatically data base's verification and system interface verification, also include: SQL and the forecast database of data base's verification of read test data return result；And the test data after importing are carried out data base's verification, specifically include: according to the SQL read, carry out data base's verification for test data；And after the test data after importing are carried out automatically data base's verification and system interface verification, also include: contrast check results returns result with forecast database, for generating test report.
In this technical scheme, after batch data each time imports, will performing data base's checking procedure, data base's verification refers generally to, according to the definition accessing data type, data base carry out the operations such as data increase, amendment, deletion.Data base's verification specifically includes following methods: reading database batch verifies SQL, reading anticipatory data storehouse returns result, perform data base verifies SQL, Inspection result returns result with anticipatory data storehouse, additionally, in data base's checking procedure, it is also possible to carry out time-out setting.Wherein, after batch data each time processes and imports, or after data base's batch verification SQL, it is possible to perform verification at corresponding operation system interface, this verification includes the verification of verification and the inquiry correctness that data on interface are shown.This verification specifically includes following methods: read system executive, calling system program, system login are common, read data-driven configuration, read check results, data-driven performs, text verification, picture verification, element verification, time-out arrange, normally exit, extremely exit.
In technique scheme, it is preferable that also include: according to the form setting command received, the form of test report is set；And after completing data base's verification, generate test report according to form.
In this technical scheme, it is possible to for each operation note daily record in data test process, and according to the form pre-set, generate the test report of specified format.Wherein, the process generating test report specifically includes: arranges report generation form, arrange report generation data, generate report, derive report.
Fig. 2 illustrates the flow chart of data test method according to another embodiment of the invention.
As in figure 2 it is shown, data test method according to another embodiment of the invention, including:
Step 202, obtains batch data checking scene, namely obtains hospital process test scene.
Step 204, obtains the execution parameter of each scene preset.
Step 206, call data access batch processing script, the default template of data importing of message of registering by simulation of bulk, it is sent to integrated platform by data integration communication protocol, and clinical data centring system and Out-Patient Doctor Workstation System it is distributed to by platform, can be registered by the simulation of bulk data of message of the two system store data base.
Data are carried out database authentication by step 208.In database authentication process, it is possible to the SQL of data base's verification and expection check results are compared, to obtain test report.
Step 210, it is judged that verify whether to pass through, when judged result is for being, enter step 212, when judged result is no, enter step 216, namely authentication failed just can terminate this test scene, owing to having dependence between outpatient service business, it is not necessary to carry out the checking of system interface again.
Step 212, at system interface video data the result.Verification is by rear, and simulation of bulk message of registering enters the clinical data centring system of outpatient service scene and station, clinician station system interface is verified.
Step 214, judge whether iteration business completes, when judged result is for being, enter step 216, when judged result is no, enter step 206, owing to after registering, clinician station needs to assign diagnosis, hence into step 206, then simulation clinician station batch imports diagnosis and assigns message, then integrated platform is sent the message to, until the checking of iteration business enters step 216 after terminating.No matter verifying successfully or failure, be required for being confirmed whether also iteration business, after registering in this enforcements, clinician station needs to assign diagnosis, therefore, it can return step 206, and the batch importing diagnosis of simulation clinician station is assigned message and is sent to integrated platform.
Step 216, after outpatient service test scene terminates, it is judged that whether this scene is last scene, when judged result is for being, enters step 218, when judged result is no, returns step 202, proceeds verification.
Step 218, generates test report and terminates test.
By this technical scheme, the data access standard of various integrated systems can be applicable to, first according to the data dependence relation in different business scene and scene, batch data is imported, then multiple check is automatically performed, and automatically generate test report, thus ensure that the high efficiency of test and correctness, further increase work efficiency.
Fig. 3 illustrates the block diagram of data testing system according to an embodiment of the invention.
As it is shown on figure 3, data testing system 300 according to an embodiment of the invention, including: template-setup unit 302, according to preset data integrated interface standard, multiple communication file format module is set；Template determines unit 304, in multiple communication file format modules, determines the communication file format module of correspondence for the test data in each Integrated scenario；Data import unit 306, and the test data in each Integrated scenario are imported corresponding communication file format module；Test data after importing are carried out data base's verification and system interface verification by data base's verification unit 308 automatically；Report generation unit 310, according to check results, generates test report.
In this technical scheme, it is provided that a kind of automation data method of testing based on the checking of big data iteration, it is possible to simulate the data integration interface standard of each integrated system.Test data frequently include multiple Integrated scenario, by this technical scheme, can for the data integration interface standard needed for each Integrated scenario, most suitable communication file format module is determined for this Integrated scenario, such that it is able to according to the data dependence relation in each Integrated scenario and each Integrated scenario, test batch data is imported test system according to processing sequence and integrated communication protocols.It addition, by this technical scheme, additionally provide common scene call method and batch data import call method, including recursive call with exit standard.And, by this technical scheme, additionally provide the data base's method of calibration after batch data imports, if data base verifies successfully, then perform the batch data of a business within this scene according to the data dependence relation in Integrated scenario to import, otherwise, exit this scene.In this technical scheme, additionally providing the system interface method of calibration after data import, its premise is data access is correct, and verifying successfully and verifying is unsuccessfully only affect integrated node system.Therefore, by this technical scheme, the batch of the dependence achieving Integrated scenario and test data thereof imports, and can automatically perform multiple check, including the verification of data access verification and each system demonstration correctness, thus automatically generating test report, it is ensured that the high efficiency of data test and correctness, achieving large data sets becomes software automatically to carry out data test, improves the efficiency of data test.Additionally, can also solve large data sets becomes class software to cause the problem testing checking complicated and time consumption, inefficiency owing to service message amount is huge and business exists dependence, thus decreasing regression test workload, it is ensured that every round regression tested coverage rate and quality.
In technique scheme, it is preferable that also include: standard arranges unit 312, before arranging communication file format module, according to the setting command received, preset data integrated interface standard is set.
In this technical scheme, it is possible to the setting according to user, data integration interface standard is set voluntarily.In the prior art, the data integration interface standard of different Integrated scenarios is different, data integration interface standard is generally not simple excel form or txt form, and often there is the data integration interface standard of XML format or user-defined format, and this prepares simulation to data and all causes difficulty with communicating.And pass through the technical program, it is possible to need to arrange data integration interface standard voluntarily according to the test of user, thus the problem that the data integration interface standard that avoids the occurrence of Integrated scenario is incompatible, improve correctness and the convenience of data test.
In technique scheme, preferably, data import unit 306 specifically for: according to test data, obtain test data scene in Integrated scenario and perform parameter, and scene is performed the communication file format module that parameter read-in Integrated scenario is corresponding, and perform parameter according to scene, the test data in Integrated scenario are carried out data conversion.
In this technical scheme, according to the data dependence relation in each Integrated scenario and each Integrated scenario, different business communication interface file data in Same Scene or user-defined format file can be arranged, as the test data that follow-up batch imports, by that analogy, it is possible to be test for Integrated scenario for each and determine a communication file format module.In this technical scheme, according to data integration communication standard, it is provided that file introduction method, namely test data lead-in method, including: the write of digital independent, data parameters, data conversion and data send.Additionally, in this technical scheme, can also being that each Integrated scenario and data be introduced into row scheduling, this scheduling process specifically includes: read Integrated scenario configuration, read data process import the configuration of batch processing script, perform test scene, call data and import batch processing script, circular treatment, whether verify SQL, whether check system picture and normally exit or abnormal exit.
In technique scheme, preferably, also including: read unit 314, before the test data after importing carry out data base's verification and system interface verification automatically, SQL and the forecast database of data base's verification of read test data return result；And data base's verification unit 308 specifically for: according to the SQL read, for test data carry out data base's verification；And report generation unit 310 is additionally operable to: after the test data after importing carry out data base's verification and system interface verification automatically, contrast check results returns result with forecast database, for generating test report.
In this technical scheme, after batch data each time imports, will performing data base's checking procedure, data base's verification refers generally to, according to the definition accessing data type, data base carry out the operations such as data increase, amendment, deletion.Data base's verification specifically includes following methods: reading database batch verifies SQL, reading anticipatory data storehouse returns result, perform data base verifies SQL, Inspection result returns result with anticipatory data storehouse, additionally, in data base's checking procedure, it is also possible to carry out time-out setting.Wherein, after batch data each time processes and imports, or after data base's batch verification SQL, it is possible to perform verification at corresponding operation system interface, this verification includes the verification of verification and the inquiry correctness that data on interface are shown.This verification specifically includes following methods: read system executive, calling system program, system login are common, read data-driven configuration, read check results, data-driven performs, text verification, picture verification, element verification, time-out arrange, normally exit, extremely exit.
In technique scheme, it is preferable that also include: form arranges unit 316, according to the form setting command received, the form of test report is set；And report generation unit 310 is used for: after completing data base's verification, generate test report according to form.
In this technical scheme, it is possible to for each operation note daily record in data test process, and according to the form pre-set, generate the test report of specified format.Wherein, the process generating test report specifically includes: arranges report generation form, arrange report generation data, generate report, derive report.
Technical scheme is described in detail above in association with accompanying drawing, by above technical scheme, the batch of the dependence achieving Integrated scenario and test data thereof imports, and can automatically perform multiple check, including the verification of data access verification and each system demonstration correctness, thus automatically generating test report, it is ensured that the high efficiency of data test and correctness, achieving large data sets becomes software automatically to carry out data test, improves the efficiency of data test.Additionally, can also solve large data sets becomes class software to cause the problem testing checking complicated and time consumption, inefficiency owing to service message amount is huge and business exists dependence, thus decreasing regression test workload, it is ensured that every round regression tested coverage rate and quality.
The foregoing is only the preferred embodiments of the present invention, be not limited to the present invention, for a person skilled in the art, the present invention can have various modifications and variations.All within the spirit and principles in the present invention, any amendment of making, equivalent replacement, improvement etc., should be included within protection scope of the present invention.
Claims (10)
1. a data test method, for data integration class software, it is characterised in that including:
According to preset data integrated interface standard, multiple communication file format module is set；
In multiple described communication file format modules, determine the described communication file format module of correspondence for the test data in each Integrated scenario；
Described test data in each described Integrated scenario are imported corresponding described communication file format module；
Test data after importing are carried out automatically data base's verification and system interface verification；
According to check results, generate test report.
2. data test method according to claim 1, it is characterised in that before described communication file format module is set, also include:
According to the setting command received, described preset data integrated interface standard is set.
3. data test method according to claim 2, it is characterised in that the described described communication file format module that described test data in each described Integrated scenario import correspondence, specifically includes:
According to described test data, obtain described test data scene in described Integrated scenario and perform parameter；
Described scene is performed the described communication file format module that Integrated scenario described in parameter read-in is corresponding, and performs parameter according to described scene, the described test data in described Integrated scenario are carried out data conversion.
4. data test method according to claim 3, it is characterised in that described to import after test data automatically carry out data base's verification and system interface verification before, also include:
The SQL and the forecast database that read the described data base verification of described test data return result；And
Described to import after described test data carry out data base's verification, specifically include:
According to the described SQL read, carry out described data base's verification for described test data；And
Described to import after test data automatically carry out data base's verification and system interface verification after, also include:
Contrast described check results and return result with described forecast database, for generating described test report.
5. data test method according to any one of claim 1 to 4, it is characterised in that also include:
According to the form setting command received, the form of described test report is set；And
After completing described data base verification, generate described test report according to described form.
6. a data testing system, for data integration class software, it is characterised in that including:
Template-setup unit, according to preset data integrated interface standard, arranges multiple communication file format module；
Template determines unit, in multiple described communication file format modules, determines the described communication file format module of correspondence for the test data in each Integrated scenario；
Data import unit, and the described test data in each described Integrated scenario are imported corresponding described communication file format module；
Test data after importing are carried out data base's verification and system interface verification by data base's verification unit automatically；
Report generation unit, according to check results, generates test report.
7. data testing system according to claim 6, it is characterised in that also include:
Standard arranges unit, before arranging described communication file format module, according to the setting command received, arranges described preset data integrated interface standard.
8. data testing system according to claim 7, it is characterised in that described data import unit specifically for:
According to described test data, obtain described test data scene in described Integrated scenario and perform parameter, and described scene is performed the described communication file format module that Integrated scenario described in parameter read-in is corresponding, and perform parameter according to described scene, the described test data in described Integrated scenario are carried out data conversion.
9. data testing system according to claim 8, it is characterised in that also include:
Read unit, described to import after test data automatically carry out data base's verification and system interface verification before, read described test data described data base verification SQL and forecast database return result；And
Described data base's verification unit specifically for:
According to the described SQL read, carry out described data base's verification for described test data；And
Described report generation unit is additionally operable to:
Described test data after importing are carried out automatically data base's verification and system interface verification after, contrast described check results and described forecast database and return result, for generating described test report.
10. the data testing system according to any one of claim 6 to 9, it is characterised in that also include:
Form arranges unit, according to the form setting command received, arranges the form of described test report；And
Described report generation unit is used for:
After completing described data base verification, generate described test report according to described form.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410835000.3A CN105786695B (en) | 2014-12-26 | 2014-12-26 | Data test method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410835000.3A CN105786695B (en) | 2014-12-26 | 2014-12-26 | Data test method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105786695A true CN105786695A (en) | 2016-07-20 |
| CN105786695B CN105786695B (en) | 2019-09-17 |
Family
ID=56389107
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410835000.3A Active CN105786695B (en) | 2014-12-26 | 2014-12-26 | Data test method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105786695B (en) |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107391377A (en) * | 2017-07-26 | 2017-11-24 | 成都科来软件有限公司 | A kind of method integrated based on combination flow chart test software |
| CN107577767A (en) * | 2017-09-05 | 2018-01-12 | 江苏电力信息技术有限公司 | A kind of uniform service layer method for building up based on big data |
| CN108388507A (en) * | 2018-01-24 | 2018-08-10 | 深圳市买买提信息科技有限公司 | Batch script testing method and device |
| CN109815039A (en) * | 2018-12-14 | 2019-05-28 | 深圳壹账通智能科技有限公司 | Test method and device, storage medium, the computer equipment of business software |
| CN110109824A (en) * | 2019-04-09 | 2019-08-09 | 平安科技（深圳）有限公司 | Big data automatic regression test method, apparatus, computer equipment and storage medium |
| CN110188159A (en) * | 2019-05-27 | 2019-08-30 | 深圳前海微众银行股份有限公司 | Collage-credit data cut-in method, device, equipment and computer readable storage medium |
| CN110287097A (en) * | 2019-05-20 | 2019-09-27 | 深圳壹账通智能科技有限公司 | Batch testing method, device and computer readable storage medium |
| CN111159262A (en) * | 2018-11-08 | 2020-05-15 | 百度在线网络技术（北京）有限公司 | Automatic driving simulation data processing method and device |
| CN112148346A (en) * | 2020-10-20 | 2020-12-29 | 云账户技术(天津)有限公司 | Method and device for docking platform system |
| CN115858372A (en) * | 2022-12-19 | 2023-03-28 | 上海浦东发展银行股份有限公司 | OLAP system-based batch data construction and automatic verification method and system |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070005635A1 (en) * | 2005-07-01 | 2007-01-04 | Microsoft Corporation | Importing database data to a non-database program |
| CN101452450A (en) * | 2007-11-30 | 2009-06-10 | 上海市电力公司 | Multiple source data conversion service method and apparatus thereof |
| CN101957865A (en) * | 2010-10-27 | 2011-01-26 | 杭州新中大软件股份有限公司 | Data exchange and sharing technology among heterogeneous systems |
| CN102054237A (en) * | 2011-01-28 | 2011-05-11 | 北京数码大方科技有限公司 | Method and device for processing product data |
| CN102480335A (en) * | 2010-11-30 | 2012-05-30 | 金蝶软件（中国）有限公司 | Method and system for transmitting business data |
| CN103246651A (en) * | 2012-02-02 | 2013-08-14 | 金蝶软件（中国）有限公司 | Method and system for data inputting |
-
2014
- 2014-12-26 CN CN201410835000.3A patent/CN105786695B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070005635A1 (en) * | 2005-07-01 | 2007-01-04 | Microsoft Corporation | Importing database data to a non-database program |
| CN101452450A (en) * | 2007-11-30 | 2009-06-10 | 上海市电力公司 | Multiple source data conversion service method and apparatus thereof |
| CN101957865A (en) * | 2010-10-27 | 2011-01-26 | 杭州新中大软件股份有限公司 | Data exchange and sharing technology among heterogeneous systems |
| CN102480335A (en) * | 2010-11-30 | 2012-05-30 | 金蝶软件（中国）有限公司 | Method and system for transmitting business data |
| CN102054237A (en) * | 2011-01-28 | 2011-05-11 | 北京数码大方科技有限公司 | Method and device for processing product data |
| CN103246651A (en) * | 2012-02-02 | 2013-08-14 | 金蝶软件（中国）有限公司 | Method and system for data inputting |
Cited By (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107391377A (en) * | 2017-07-26 | 2017-11-24 | 成都科来软件有限公司 | A kind of method integrated based on combination flow chart test software |
| CN107577767A (en) * | 2017-09-05 | 2018-01-12 | 江苏电力信息技术有限公司 | A kind of uniform service layer method for building up based on big data |
| CN108388507A (en) * | 2018-01-24 | 2018-08-10 | 深圳市买买提信息科技有限公司 | Batch script testing method and device |
| CN111159262A (en) * | 2018-11-08 | 2020-05-15 | 百度在线网络技术（北京）有限公司 | Automatic driving simulation data processing method and device |
| CN111159262B (en) * | 2018-11-08 | 2024-06-04 | 阿波罗智能技术(北京)有限公司 | Automatic driving simulation data processing method and device |
| CN109815039A (en) * | 2018-12-14 | 2019-05-28 | 深圳壹账通智能科技有限公司 | Test method and device, storage medium, the computer equipment of business software |
| CN110109824A (en) * | 2019-04-09 | 2019-08-09 | 平安科技（深圳）有限公司 | Big data automatic regression test method, apparatus, computer equipment and storage medium |
| CN110287097A (en) * | 2019-05-20 | 2019-09-27 | 深圳壹账通智能科技有限公司 | Batch testing method, device and computer readable storage medium |
| WO2020233330A1 (en) * | 2019-05-20 | 2020-11-26 | 深圳壹账通智能科技有限公司 | Batch testing method, apparatus, and computer-readable storage medium |
| CN110188159B (en) * | 2019-05-27 | 2023-05-12 | 深圳前海微众银行股份有限公司 | Credit data access method, device, equipment and computer readable storage medium |
| CN110188159A (en) * | 2019-05-27 | 2019-08-30 | 深圳前海微众银行股份有限公司 | Collage-credit data cut-in method, device, equipment and computer readable storage medium |
| CN112148346A (en) * | 2020-10-20 | 2020-12-29 | 云账户技术(天津)有限公司 | Method and device for docking platform system |
| CN115858372A (en) * | 2022-12-19 | 2023-03-28 | 上海浦东发展银行股份有限公司 | OLAP system-based batch data construction and automatic verification method and system |
| CN115858372B (en) * | 2022-12-19 | 2024-04-26 | 上海浦东发展银行股份有限公司 | Batch data construction and automatic verification method and system based on OLAP system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105786695B (en) | 2019-09-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105786695A (en) | Data test method and system | |
| CN111159049B (en) | Automatic interface testing method and system | |
| CN108628748B (en) | Automatic test management method and automatic test management system | |
| CN109933521A (en) | Automated testing method, device, computer equipment and storage medium based on BDD | |
| CN110058998B (en) | Software testing method and device | |
| CN112433944A (en) | Service testing method, device, computer equipment and storage medium | |
| CN110990274B (en) | Data processing method, device and system for generating test cases | |
| CN112306861A (en) | Unittest and Jenkins tool-based interface automatic testing system and method | |
| CN110737594A (en) | Database standard conformance testing method and device for automatically generating test cases | |
| CN105591779A (en) | Method and device for inspecting network element | |
| CN111400167A (en) | Redfish service compliance verification method, device, equipment and medium | |
| CN114443039A (en) | Input parameter verification method and device, electronic equipment and storage medium | |
| CN115794641A (en) | Method, device and equipment for making number based on business process and storage medium | |
| CN111752834A (en) | Automatic testing method and device | |
| CN107436814A (en) | A kind of generation method and device of resource layout template | |
| CN112860585B (en) | Test script assertion generation method and device | |
| CN105472015A (en) | Method and device for accessing cloud platform to third-party application | |
| CN110717315B (en) | System data batch modification method and device, storage medium and electronic equipment | |
| CN111427582A (en) | Management method, device and equipment of RT L code and computer readable storage medium | |
| CN105703964A (en) | Online application system test method and equipment | |
| US10678681B2 (en) | Method and device for automatic testing | |
| CN115982043A (en) | Vehicle interface testing method, device, equipment and storage medium | |
| TW201721434A (en) | Computer program product applicable to automatic generation of software testing data and method thereof capable of making sure each functional module can access accurate testing data for testing | |
| CN115934559A (en) | Testing method of intelligent form testing system | |
| CN113535581B (en) | Test script generation method, device, equipment and computer readable storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| PP01 | Preservation of patent right |
Effective date of registration: 20240202 Granted publication date: 20190917 |
|
| PP01 | Preservation of patent right |