CN105786695B - Data test method and system - Google Patents
Data test method and system Download PDFInfo
- Publication number
- CN105786695B CN105786695B CN201410835000.3A CN201410835000A CN105786695B CN 105786695 B CN105786695 B CN 105786695B CN 201410835000 A CN201410835000 A CN 201410835000A CN 105786695 B CN105786695 B CN 105786695B
- Authority
- CN
- China
- Prior art keywords
- data
- test
- verification
- database
- 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.)
- Active
Links
- 238000010998 test method Methods 0.000 title claims abstract description 21
- 238000012360 testing method Methods 0.000 claims abstract description 218
- 238000012795 verification Methods 0.000 claims abstract description 128
- 238000004891 communication Methods 0.000 claims abstract description 69
- 230000008676 import Effects 0.000 claims abstract description 42
- 230000010354 integration Effects 0.000 claims description 43
- 238000006243 chemical reaction Methods 0.000 claims description 10
- 241000208340 Araliaceae Species 0.000 claims 1
- 235000005035 Panax pseudoginseng ssp. pseudoginseng Nutrition 0.000 claims 1
- 235000003140 Panax quinquefolius Nutrition 0.000 claims 1
- 235000008434 ginseng Nutrition 0.000 claims 1
- 238000000034 method Methods 0.000 description 44
- 238000012545 processing Methods 0.000 description 18
- 230000008569 process Effects 0.000 description 11
- 238000004088 simulation Methods 0.000 description 11
- 230000000454 anti-cipatory effect Effects 0.000 description 8
- 238000005516 engineering process Methods 0.000 description 8
- 230000002159 abnormal effect Effects 0.000 description 4
- 230000009471 action 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
- 230000004048 modification Effects 0.000 description 4
- 238000012986 modification Methods 0.000 description 4
- 238000013522 software testing Methods 0.000 description 3
- 230000008859 change Effects 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 238000013500 data storage Methods 0.000 description 1
- 238000013524 data verification Methods 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
- 230000008520 organization Effects 0.000 description 1
- 230000008439 repair process Effects 0.000 description 1
Landscapes
- Debugging And Monitoring (AREA)
Abstract
The present invention provides a kind of data test method and system, wherein data test method includes: that multiple communication file format modules are arranged according to preset data integrated interface standard；In multiple communication file format modules, corresponding communication file format module is determined for the test data in each Integrated scenario；Test data in each Integrated scenario is imported into corresponding communication file format module；Carry out database verification and system interface verification automatically to the test data after importing；According to check results, test report is generated.Pass through the technical solution, the batch for realizing the dependence of Integrated scenario and its test data imports, multiple check can be executed automatically, promote the efficiency of data test, and solve the problems, such as large data sets at class software since service message amount is huge and business causes test verifying complicated and time consumption, inefficiency there are dependence, to reduce regression test workload, guarantee the coverage rate and quality of every round regression test.
Description
Technical field
The present invention relates to software testing technology fields, survey in particular to a kind of data test method and a kind of data
Test system.
Background technique
Currently, being had been introduced into informatization with the informatization gradually development to integrated fining direction
SOA framework and ESB technology, meanwhile, also bring the uniformity of interface standard, the diversity of data type, business datum access
Dependence complexity problem.
In the prior art, software testing technology or the testing process of tool foundation include: analogue recording, debugging playback,
Scene definition, dry run and report analysis, the testing process are used to provide the tool or test frame of automatic test, but right
In data integration class software, there are following three aspects problems to be solved:
One, integrated software product is excessive and framework is different with the technology of realization, same Software Testing Tool or technical modelling
The input or output of these products are difficult, and can not perfectly solve the interactive relation between these products.
Two, data interface standard is different.The not simple Excel format of data interface standard or TXT format exist
The data interface standard of XML format or user-defined format causes data preparation simulation and difficult communication.
Three, there are batch processing and business dependence between data, it is unfavorable for data organization, calling and verifying.
Therefore need a kind of new technical solution, can by digital simulation, executes scheduling, verify and be combined together automatically,
To guarantee the high efficiency and correctness of data test.
Summary of the invention
The present invention is based on the above problems, proposes a kind of new technical solution, can by digital simulation, execute tune
Degree, automatic verifying are combined together, to guarantee the high efficiency and correctness of data test.
In view of this, the first aspect of the present invention proposes a kind of data test method, it to be used for data integration class software, packet
It includes: according to preset data integrated interface standard, multiple communication file format modules is set；In multiple communication file format moulds
In plate, the corresponding communication file format module is determined for the test data in each Integrated scenario；It will be each described integrated
The test data in scene imports the corresponding communication file format module；Test data after importing is carried out automatically
Database verification and system interface verification；According to check results, test report is generated.
In the technical scheme, a kind of automated data test method based on the verifying of big data iteration is provided, it can
Simulate the data integration interface standard of each integrated system.A variety of Integrated scenarios are frequently included in test data, pass through the technical side
Case can determine most suitable communication text for data integration interface standard needed for each Integrated scenario for the Integrated scenario
Part format module, it is suitable according to handling so as to according to the data dependence relation in each Integrated scenario and each Integrated scenario
Test data batch is imported test macro by sequence and integrated communication protocols.In addition, additionally providing common field by the technical solution
Scape call method and batch data import call method, including recursive call and exit standard.And by the technical solution,
The database method of calibration after batch data imports is additionally provided, if database verifies successfully, according in Integrated scenario
The batch data that data dependence relation executes a business inside the scene imports, and otherwise, exits this scene.In the technology
In scheme, the system interface method of calibration after data import is additionally provided, with the proviso that data access is correctly, to verify successfully
It is unsuccessfully only to influence integrated node system with verification.Therefore, by the technical solution, Integrated scenario and its test data are realized
The batch of dependence import, and can be performed automatically multiple check, including data access verification and each system demonstration it is correct
The verification of property ensure that the high efficiency and correctness of data test to automatically generate test report, realize large data sets at
Software carries out data test automatically, improves the efficiency of data test.Furthermore it is also possible to solve large data sets at class software due to
Service message amount is huge and business has dependence and causes test verifying complicated and time consumption, inefficiency, to subtract
Lack regression test workload, ensure that the coverage rate and quality of every round regression test.
In the above-mentioned technical solutions, it is preferable that before the communication file format module is set, further includes: according to connecing
The preset data integrated interface standard is arranged in the setting command received.
It in the technical scheme, can be according to the setting of user, self-setting data integration interface standard.In the prior art
In, the data integration interface standard of different Integrated scenarios is different, and data integration interface standard is generally not simple excel format
Or txt format, and often there is the data integration interface standard of XML format or user-defined format, this to data preparation simulation and
Communication all causes difficulty.And by the technical program, self-setting data integration interface can be needed according to the test of user
Standard, so that the problem that the data integration interface standard for avoiding the occurrence of Integrated scenario is incompatible, improves the correct of data test
Property and convenience.
In the above-mentioned technical solutions, it is preferable that the test data importing pair by each Integrated scenario
The communication file format module answered, specifically includes: according to the test data, obtaining the test data described integrated
Scene in scene executes parameter；The scene is executed into parameter, the corresponding communication file format of the Integrated scenario is written
Template, and parameter is executed according to the scene, data conversion is carried out to the test data in the Integrated scenario.
In the technical scheme, it according to the data dependence relation in each Integrated scenario and each Integrated scenario, can incite somebody to action
Different business communication interface file data or user-defined format file are arranged in Same Scene, are imported as subsequent batch
Test data, and so on, a communication file format module can be determined for each tested Integrated scenario.In the skill
In art scheme, according to data integration communication standard, file introduction method, i.e. test data introduction method are provided, comprising: data
It reads, data parameters are written, data conversion and data are sent.In addition, in the technical scheme, can also for each Integrated scenario and
Data importing is scheduled, which specifically includes: being read the configuration of Integrated scenario, is read data processing importing batch processing
Script configuration, execute test scene, call data import batch processing script, circular treatment, whether verify structured query language,
Whether check system picture and normally exits or abnormal exit.
In the above-mentioned technical solutions, it is preferable that described pair import after test data carry out automatically database verification and
Before system interface verification, further includes: read the structured query language of the database verification of the test data and pre-
Measured data library returns the result；And the test data after described pair of importing carries out database verification, specifically includes: according to reading
The structured query language got carries out the database verification for the test data；And after described pair imports
Test data carry out automatically database verification and system interface verification after, further includes: compare the check results with it is described
Forecast database returns the result, for generating the test report.
In the technical scheme, after the importing of batch data each time, database verification step, database school will be executed
The definition referred generally to according to access data type is tested, the operation such as data increase, modification, deletion is carried out to database.Database school
Test and specifically include following methods: reading database batch verification structured query language, reading anticipatory data library return the result, hold
Row database verification structured query language, Inspection result and anticipatory data library return the result, in addition, verifying in database
In the process, overtime setting can also be carried out.Wherein, batch data each time processing import after or database batch verification knot
After structure query language, verification can be executed at corresponding operation system interface, which includes showing to data on interface
The verification of verification and inquiry correctness.The verification specifically includes following methods: read system executive, calling system program,
System login is common, reads data-driven configuration, read check results, data-driven executes, text verification, picture verification, member
Element verification, time-out are arranged, normally exit, exception exits.
In the above-mentioned technical solutions, it is preferable that further include: according to the format setting command received, the test is set
The format of report；And after completing the database verification, the test report is generated according to the format.
It in the technical scheme, can be each operation note log during data test, and according to presetting
Format, generate the test report of specified format.Wherein, the process for generating test report specifically includes: setting report generation lattice
Formula, setting report generation data generate report, export report.
The second aspect of the present invention proposes a kind of data testing system, is used for data integration class software, comprising: template is set
Unit is set, according to preset data integrated interface standard, multiple communication file format modules are set；Template determination unit, multiple
In the communication file format module, the corresponding communication file format mould is determined for the test data in each Integrated scenario
Plate；The test data in each Integrated scenario is imported the corresponding communication file format by data import unit
Template；Database verification unit carries out database verification and system interface verification to the test data after importing automatically；Report life
Test report is generated according to check results at unit.
In the technical scheme, a kind of automated data test method based on the verifying of big data iteration is provided, it can
Simulate the data integration interface standard of each integrated system.A variety of Integrated scenarios are frequently included in test data, pass through the technical side
Case can determine most suitable communication text for data integration interface standard needed for each Integrated scenario for the Integrated scenario
Part format module, it is suitable according to handling so as to according to the data dependence relation in each Integrated scenario and each Integrated scenario
Test data batch is imported test macro by sequence and integrated communication protocols.In addition, additionally providing common field by the technical solution
Scape call method and batch data import call method, including recursive call and exit standard.And by the technical solution,
The database method of calibration after batch data imports is additionally provided, if database verifies successfully, according in Integrated scenario
The batch data that data dependence relation executes a business inside the scene imports, and otherwise, exits this scene.In the technology
In scheme, the system interface method of calibration after data import is additionally provided, with the proviso that data access is correctly, to verify successfully
It is unsuccessfully only to influence integrated node system with verification.Therefore, by the technical solution, Integrated scenario and its test data are realized
The batch of dependence import, and can be performed automatically multiple check, including data access verification and each system demonstration it is correct
The verification of property ensure that the high efficiency and correctness of data test to automatically generate test report, realize large data sets at
Software carries out data test automatically, improves the efficiency of data test.Furthermore it is also possible to solve large data sets at class software due to
Service message amount is huge and business has dependence and causes test verifying complicated and time consumption, inefficiency, to subtract
Lack regression test workload, ensure that the coverage rate and quality of every round regression test.
In the above-mentioned technical solutions, it is preferable that further include: the communication file format mould is being arranged in standard setting unit
Before plate, according to the setting command received, the preset data integrated interface standard is set.
It in the technical scheme, can be according to the setting of user, self-setting data integration interface standard.In the prior art
In, the data integration interface standard of different Integrated scenarios is different, and data integration interface standard is generally not simple excel format
Or txt format, and often there is the data integration interface standard of XML format or user-defined format, this to data preparation simulation and
Communication all causes difficulty.And by the technical program, self-setting data integration interface can be needed according to the test of user
Standard, so that the problem that the data integration interface standard for avoiding the occurrence of Integrated scenario is incompatible, improves the correct of data test
Property and convenience.
In the above-mentioned technical solutions, it is preferable that the data import unit is specifically used for: according to the test data, obtaining
It takes scene of the test data in the Integrated scenario to execute parameter, and the scene is executed into parameter, the collection is written
Parameter is executed at the corresponding communication file format module of scene, and according to the scene, to the institute in the Integrated scenario
It states test data and carries out data conversion.
In the technical scheme, it according to the data dependence relation in each Integrated scenario and each Integrated scenario, can incite somebody to action
Different business communication interface file data or user-defined format file are arranged in Same Scene, are imported as subsequent batch
Test data, and so on, a communication file format module can be determined for each tested Integrated scenario.In the skill
In art scheme, according to data integration communication standard, file introduction method, i.e. test data introduction method are provided, comprising: data
It reads, data parameters are written, data conversion and data are sent.In addition, in the technical scheme, can also for each Integrated scenario and
Data importing is scheduled, which specifically includes: being read the configuration of Integrated scenario, is read data processing importing batch processing
Script configuration, execute test scene, call data import batch processing script, circular treatment, whether verify structured query language,
Whether check system picture and normally exits or abnormal exit.
In the above-mentioned technical solutions, it is preferable that further include: reading unit, the test data after importing at described Dui are automatic
Before carrying out database verification and system interface verification, the structuralized query of the database verification of the test data is read
Language and forecast database return the result；And the database verification unit is specifically used for: according to the structure read
Change query language, carries out the database verification for the test data；And the report generation unit is also used to: described
Test data after importing is carried out automatically database verification and system interface verification after, compare the check results with it is described
Forecast database returns the result, for generating the test report.
In the technical scheme, after the importing of batch data each time, database verification step, database school will be executed
The definition referred generally to according to access data type is tested, the operation such as data increase, modification, deletion is carried out to database.Database school
Test and specifically include following methods: reading database batch verification structured query language, reading anticipatory data library return the result, hold
Row database verification structured query language, Inspection result and anticipatory data library return the result, in addition, verifying in database
In the process, overtime setting can also be carried out.Wherein, batch data each time processing import after or database batch verification knot
After structure query language, verification can be executed at corresponding operation system interface, which includes showing to data on interface
The verification of verification and inquiry correctness.The verification specifically includes following methods: read system executive, calling system program,
System login is common, reads data-driven configuration, read check results, data-driven executes, text verification, picture verification, member
Element verification, time-out are arranged, normally exit, exception exits.
In the above-mentioned technical solutions, it is preferable that further include: format setting unit, according to the format setting command received,
The format of the test report is set；And the report generation unit is used for: after completing the database verification, according to institute
It states format and generates the test report.
It in the technical scheme, can be each operation note log during data test, and according to presetting
Format, generate the test report of specified format.Wherein, the process for generating test report specifically includes: setting report generation lattice
Formula, setting report generation data generate report, export report.
By above technical scheme, the batch for realizing the dependence of Integrated scenario and its test data is imported, and can
To execute multiple check automatically, the verification including data access verification and each system demonstration correctness, to automatically generate test
Report, ensure that the high efficiency and correctness of data test, realizes big data integrated software and carry out data test automatically, be promoted
The efficiency of data test.Furthermore it is also possible to solve large data sets into class software since service message amount is huge and business exists
Dependence and cause test verifying complicated and time consumption, inefficiency the problem of, to reduce regression test workload, ensure that
The coverage rate and quality of every round regression test.
Detailed description of the invention
Fig. 1 shows the flow chart of data test method according to an embodiment of the invention；
Fig. 2 shows the flow charts of data test method according to another embodiment of the invention；
Fig. 3 shows the block diagram of data testing system according to an embodiment of the invention.
Specific embodiment
To better understand the objects, features and advantages of the present invention, with reference to the accompanying drawing and specific real
Applying mode, the present invention is further described in detail.It should be noted that in the absence of conflict, the implementation of the application
Feature in example and embodiment can be combined with each other.
In the following description, numerous specific details are set forth in order to facilitate a full understanding of the present invention, still, the present invention may be used also
To be implemented using other than the one described here other modes, therefore, protection scope of the present invention is not by described below
Specific embodiment limitation.
Fig. 1 shows the flow chart of data test method according to an embodiment of the invention.
As shown in Figure 1, data test method according to an embodiment of the invention, is used for data integration class software, packet
It includes:
Step 102, according to preset data integrated interface standard, multiple communication file format modules are set.
Step 104, it in multiple communication file format modules, is determined for the test data in each Integrated scenario corresponding
Communication file format module.
Step 106, the test data in each Integrated scenario is imported into corresponding communication file format module.
Step 108, database verification and system interface verification are carried out automatically to the test data after importing.
Step 110, according to check results, test report is generated.
In the technical scheme, a kind of automated data test method based on the verifying of big data iteration is provided, it can
Simulate the data integration interface standard of each integrated system.A variety of Integrated scenarios are frequently included in test data, pass through the technical side
Case can determine most suitable communication text for data integration interface standard needed for each Integrated scenario for the Integrated scenario
Part format module, it is suitable according to handling so as to according to the data dependence relation in each Integrated scenario and each Integrated scenario
Test data batch is imported test macro by sequence and integrated communication protocols.In addition, additionally providing common field by the technical solution
Scape call method and batch data import call method, including recursive call and exit standard.And by the technical solution,
The database method of calibration after batch data imports is additionally provided, if database verifies successfully, according in Integrated scenario
The batch data that data dependence relation executes a business inside the scene imports, and otherwise, exits this scene.In the technology
In scheme, the system interface method of calibration after data import is additionally provided, with the proviso that data access is correctly, to verify successfully
It is unsuccessfully only to influence integrated node system with verification.Therefore, by the technical solution, Integrated scenario and its test data are realized
The batch of dependence import, and can be performed automatically multiple check, including data access verification and each system demonstration it is correct
The verification of property ensure that the high efficiency and correctness of data test to automatically generate test report, realize large data sets at
Software carries out data test automatically, improves the efficiency of data test.Furthermore it is also possible to solve large data sets at class software due to
Service message amount is huge and business has dependence and causes test verifying complicated and time consumption, inefficiency, to subtract
Lack regression test workload, ensure that the coverage rate and quality of every round regression test.
In the above-mentioned technical solutions, it is preferable that before communication file format module is set, further includes: according to receiving
Setting command, be arranged preset data integrated interface standard.
It in the technical scheme, can be according to the setting of user, self-setting data integration interface standard.In the prior art
In, the data integration interface standard of different Integrated scenarios is different, and data integration interface standard is generally not simple excel format
Or txt format, and often there is the data integration interface standard of XML format or user-defined format, this to data preparation simulation and
Communication all causes difficulty.And by the technical program, self-setting data integration interface can be needed according to the test of user
Standard, so that the problem that the data integration interface standard for avoiding the occurrence of Integrated scenario is incompatible, improves the correct of data test
Property and convenience.
In the above-mentioned technical solutions, it is preferable that the test data in each Integrated scenario is imported into corresponding communication file
Format module specifically includes: according to test data, obtaining scene of the test data in Integrated scenario and executes parameter；By scene
The corresponding communication file format module of parameter write-in Integrated scenario is executed, and parameter is executed according to scene, in Integrated scenario
Test data carries out data conversion.
In the technical scheme, it according to the data dependence relation in each Integrated scenario and each Integrated scenario, can incite somebody to action
Different business communication interface file data or user-defined format file are arranged in Same Scene, are imported as subsequent batch
Test data, and so on, a communication file format module can be determined for each tested Integrated scenario.In the skill
In art scheme, according to data integration communication standard, file introduction method, i.e. test data introduction method are provided, comprising: data
It reads, data parameters are written, data conversion and data are sent.In addition, in the technical scheme, can also for each Integrated scenario and
Data importing is scheduled, which specifically includes: being read the configuration of Integrated scenario, is read data processing importing batch processing
Script configuration, execute test scene, call data import batch processing script, circular treatment, whether verify structured query language,
Whether check system picture and normally exits or abnormal exit.
In the above-mentioned technical solutions, it is preferable that database verification and system are being carried out automatically to the test data after importing
Before the verification of interface, further includes: the structured query language and forecast database of the database verification of read test data return
As a result；And database verification is carried out to the test data after importing, it specifically includes: according to the structuralized query language read
Speech carries out database verification for test data；And database verification and system are being carried out automatically to the test data after importing
After the verification of interface, further includes: comparison check results are returned the result with forecast database, for generating test report.
In the technical scheme, after the importing of batch data each time, database verification step, database school will be executed
The definition referred generally to according to access data type is tested, the operation such as data increase, modification, deletion is carried out to database.Database school
Test and specifically include following methods: reading database batch verification structured query language, reading anticipatory data library return the result, hold
Row database verification structured query language, Inspection result and anticipatory data library return the result, in addition, verifying in database
In the process, overtime setting can also be carried out.Wherein, batch data each time processing import after or database batch verification knot
After structure query language, verification can be executed at corresponding operation system interface, which includes showing to data on interface
The verification of verification and inquiry correctness.The verification specifically includes following methods: read system executive, calling system program,
System login is common, reads data-driven configuration, read check results, data-driven executes, text verification, picture verification, member
Element verification, time-out are arranged, normally exit, exception exits.
In the above-mentioned technical solutions, it is preferable that further include: according to the format setting command received, test report is set
Format；And after completing database verification, test report is generated according to format.
It in the technical scheme, can be each operation note log during data test, and according to presetting
Format, generate the test report of specified format.Wherein, the process for generating test report specifically includes: setting report generation lattice
Formula, setting report generation data generate report, export report.
Fig. 2 shows the flow charts of data test method according to another embodiment of the invention.
As shown in Fig. 2, data test method according to another embodiment of the invention, comprising:
Step 202, it obtains batch data and verifies scene, is i.e. acquisition hospital process test scene.
Step 204, the execution parameter of preset each scene is obtained.
Step 206, it calls data access batch processing script, i.e., the register data of message of simulation of bulk is imported into default mould
Plate is sent to integrated platform by data integration communication protocol, and is distributed to clinical data centring system and outpatient service by platform
Doctor stands system, the two systems simulation of bulk can be registered message data storage to database.
Step 208, database authentication is carried out to data.It, can be the knot of database verification during database authentication
Structure query language and expected check results are compared, to obtain test report.
Step 210, judgement verifies whether to pass through, and when the judgment result is yes, 212 is entered step, when judging result is no
When, 216 are entered step, i.e. authentication failed can terminate this test scene, due to having dependence between outpatient service business, no
Need to carry out the verifying of system interface again.
Step 212, data verification result is shown in system interface.After verification passes through, simulation of bulk message of registering enters door
The clinical data centring system and outpatient clinician station station system interface for examining scene are verified.
Step 214, judge whether iteration business is completed, when the judgment result is yes, enter step 216, work as judging result
When being no, 206 are entered step, since outpatient clinician station needs to assign diagnosis after registering, enters step 206, then analog gate
It examines the batch importing diagnosis of doctor station and assigns message, then send the message to integrated platform, until the verifying of iteration business terminates
After enter step 216.No matter verification succeeds or fails, and requires to be confirmed whether also iteration business, after registering in this implementation
Outpatient clinician station needs to assign diagnosis, therefore, can be with return step 206, and simulation outpatient clinician station batch, which imports diagnosis and assigns, to disappear
Breath is sent to integrated platform.
Step 216, after outpatient service test scene, judge whether the scene is the last one scene, works as judging result
When to be, 218 are entered step, when the judgment result is no, return step 202 continues to verify.
Step 218, it generates test report and terminates to test.
By the technical solution, the data access standard of various integrated systems can be suitable for, first according to different business
Data dependence relation in scene and scene imports batch data, then executes multiple check automatically, and automatically generate test
Report, to ensure that the high efficiency and correctness of test, further improves working efficiency.
Fig. 3 shows the block diagram of data testing system according to an embodiment of the invention.
As shown in figure 3, data testing system 300 according to an embodiment of the invention, comprising: template-setup unit
302, according to preset data integrated interface standard, multiple communication file format modules are set；Template determination unit 304, multiple
In communication file format module, corresponding communication file format module is determined for the test data in each Integrated scenario；Data
Test data in each Integrated scenario is imported corresponding communication file format module by import unit 306；Database verification is single
Member 308 carries out database verification and system interface verification to the test data after importing automatically；Report generation unit 310, according to
Check results generate test report.
In the technical scheme, a kind of automated data test method based on the verifying of big data iteration is provided, it can
Simulate the data integration interface standard of each integrated system.A variety of Integrated scenarios are frequently included in test data, pass through the technical side
Case can determine most suitable communication text for data integration interface standard needed for each Integrated scenario for the Integrated scenario
Part format module, it is suitable according to handling so as to according to the data dependence relation in each Integrated scenario and each Integrated scenario
Test data batch is imported test macro by sequence and integrated communication protocols.In addition, additionally providing common field by the technical solution
Scape call method and batch data import call method, including recursive call and exit standard.And by the technical solution,
The database method of calibration after batch data imports is additionally provided, if database verifies successfully, according in Integrated scenario
The batch data that data dependence relation executes a business inside the scene imports, and otherwise, exits this scene.In the technology
In scheme, the system interface method of calibration after data import is additionally provided, with the proviso that data access is correctly, to verify successfully
It is unsuccessfully only to influence integrated node system with verification.Therefore, by the technical solution, Integrated scenario and its test data are realized
The batch of dependence import, and can be performed automatically multiple check, including data access verification and each system demonstration it is correct
The verification of property ensure that the high efficiency and correctness of data test to automatically generate test report, realize large data sets at
Software carries out data test automatically, improves the efficiency of data test.Furthermore it is also possible to solve large data sets at class software due to
Service message amount is huge and business has dependence and causes test verifying complicated and time consumption, inefficiency, to subtract
Lack regression test workload, ensure that the coverage rate and quality of every round regression test.
In the above-mentioned technical solutions, it is preferable that further include: standard setting unit 312, in setting communication file format module
Before, according to the setting command received, preset data integrated interface standard is set.
It in the technical scheme, can be according to the setting of user, self-setting data integration interface standard.In the prior art
In, the data integration interface standard of different Integrated scenarios is different, and data integration interface standard is generally not simple excel format
Or txt format, and often there is the data integration interface standard of XML format or user-defined format, this to data preparation simulation and
Communication all causes difficulty.And by the technical program, self-setting data integration interface can be needed according to the test of user
Standard, so that the problem that the data integration interface standard for avoiding the occurrence of Integrated scenario is incompatible, improves the correct of data test
Property and convenience.
In the above-mentioned technical solutions, it is preferable that data import unit 306 is specifically used for: according to test data, obtaining test
Scene of the data in Integrated scenario executes parameter, and scene is executed the corresponding communication file lattice of parameter write-in Integrated scenario
Formula template, and parameter is executed according to scene, data conversion is carried out to the test data in Integrated scenario.
In the technical scheme, it according to the data dependence relation in each Integrated scenario and each Integrated scenario, can incite somebody to action
Different business communication interface file data or user-defined format file are arranged in Same Scene, are imported as subsequent batch
Test data, and so on, a communication file format module can be determined for each tested Integrated scenario.In the skill
In art scheme, according to data integration communication standard, file introduction method, i.e. test data introduction method are provided, comprising: data
It reads, data parameters are written, data conversion and data are sent.In addition, in the technical scheme, can also for each Integrated scenario and
Data importing is scheduled, which specifically includes: being read the configuration of Integrated scenario, is read data processing importing batch processing
Script configuration, execute test scene, call data import batch processing script, circular treatment, whether verify structured query language,
Whether check system picture and normally exits or abnormal exit.
In the above-mentioned technical solutions, it is preferable that further include: reading unit 314, to the test data after importing automatically into
Before the verification of row database and system interface verification, the structured query language and prediction of the database verification of read test data
Database returns the result；And database verification unit 308 is specifically used for: according to the structured query language read, to survey
It tries data and carries out database verification；And report generation unit 310 is also used to: being counted automatically to the test data after importing
After library verification and system interface verification, comparison check results are returned the result with forecast database, for generating test report.
In the technical scheme, after the importing of batch data each time, database verification step, database school will be executed
The definition referred generally to according to access data type is tested, the operation such as data increase, modification, deletion is carried out to database.Database school
Test and specifically include following methods: reading database batch verification structured query language, reading anticipatory data library return the result, hold
Row database verification structured query language, Inspection result and anticipatory data library return the result, in addition, verifying in database
In the process, overtime setting can also be carried out.Wherein, batch data each time processing import after or database batch verification knot
After structure query language, verification can be executed at corresponding operation system interface, which includes showing to data on interface
The verification of verification and inquiry correctness.The verification specifically includes following methods: read system executive, calling system program,
System login is common, reads data-driven configuration, read check results, data-driven executes, text verification, picture verification, member
Element verification, time-out are arranged, normally exit, exception exits.
In the above-mentioned technical solutions, it is preferable that further include: format setting unit 316, according to the format setting life received
It enables, the format of test report is set；And report generation unit 310 is used for: after completing database verification, being generated according to format
Test report.
It in the technical scheme, can be each operation note log during data test, and according to presetting
Format, generate the test report of specified format.Wherein, the process for generating test report specifically includes: setting report generation lattice
Formula, setting report generation data generate report, export report.
The technical scheme of the present invention has been explained in detail above with reference to the attached drawings, by above technical scheme, realizes integrated field
The batch of the dependence of scape and its test data imports, and can be performed automatically multiple check, including data access verification and
The verification of each system demonstration correctness ensure that the high efficiency and correctness of data test to automatically generate test report, real
Show big data integrated software and carried out data test automatically, improves the efficiency of data test.Furthermore it is also possible to solve big data
Integrated class software is since service message amount is huge and business causes test verifying complicated and time consumption, inefficiency there are dependence
The problem of, to reduce regression test workload, it ensure that the coverage rate and quality of every round regression test.
The foregoing is only a preferred embodiment of the present invention, is not intended to restrict the invention, for the skill of this field
For art personnel, the invention may be variously modified and varied.All within the spirits and principles of the present invention, made any to repair
Change, equivalent replacement, improvement etc., should all be included in the protection scope of the present invention.
Claims (10)
1. a kind of data test method is used for data integration class software characterized by comprising
According to preset data integrated interface standard, multiple communication file format modules are set；
In multiple communication file format modules, the corresponding communication is determined for the test data in each Integrated scenario
File format template；
The test data in each Integrated scenario is imported into the corresponding communication file format module；
Carry out database verification and system interface verification automatically to the test data after importing；
According to check results, test report is generated.
2. data test method according to claim 1, which is characterized in that be arranged the communication file format module it
Before, further includes:
According to the setting command received, the preset data integrated interface standard is set.
3. data test method according to claim 2, which is characterized in that the institute by each Integrated scenario
It states test data and imports the corresponding communication file format module, specifically include:
According to the test data, obtains scene of the test data in the Integrated scenario and execute parameter；
The scene is executed into parameter, the corresponding communication file format module of the Integrated scenario is written, and according to the field
Scape executes parameter, carries out data conversion to the test data in the Integrated scenario.
4. data test method according to claim 3, which is characterized in that the test data after importing at described Dui is automatic
Before progress database verification and system interface verification, further includes:
The structured query language and forecast database for reading the database verification of the test data return the result；And
The test data after described pair of importing carries out database verification, specifically includes:
According to the structured query language read, the database verification is carried out for the test data；And
Test data after importing at described Dui is carried out automatically after database verification and system interface verification, further includes:
It compares the check results to return the result with the forecast database, for generating the test report.
5. data test method according to any one of claim 1 to 4, which is characterized in that further include:
According to the format setting command received, the format of the test report is set；And
After completing the database verification, the test report is generated according to the format.
6. a kind of data testing system is used for data integration class software characterized by comprising
Multiple communication file format modules are arranged according to preset data integrated interface standard in template-setup unit；
Template determination unit is that the test data in each Integrated scenario determines in multiple communication file format modules
The corresponding communication file format module；
The test data in each Integrated scenario is imported the corresponding communication file format by data import unit
Template；
Database verification unit carries out database verification and system interface verification to the test data after importing automatically；
Report generation unit generates test report according to check results.
7. data testing system according to claim 6, which is characterized in that further include:
Standard setting unit, before the communication file format module is set, according to the setting command received, described in setting
Preset data integrated interface standard.
8. data testing system according to claim 7, which is characterized in that the data import unit is specifically used for:
It according to the test data, obtains scene of the test data in the Integrated scenario and executes parameter, and by institute
It states scene and executes the corresponding communication file format module of the parameter write-in Integrated scenario, and ginseng is executed according to the scene
Number carries out data conversion to the test data in the Integrated scenario.
9. data testing system according to claim 8, which is characterized in that further include:
Reading unit is read before the test data after importing at described Dui carries out database verification and system interface verification automatically
The structured query language and forecast database for taking the database of the test data to verify return the result；And
The database verification unit is specifically used for:
According to the structured query language read, the database verification is carried out for the test data；And
The report generation unit is also used to:
After test data after importing at described Dui carries out database verification and system interface verification automatically, the verification is compared
As a result it is returned the result with the forecast database, for generating the test report.
10. data testing system according to any one of claims 6 to 9, which is characterized in that further include:
The format of the test report is arranged according to the format setting command received in format setting unit；And
The report generation unit is used for:
After completing the database verification, the test report is generated according to the format.
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 CN105786695A (en) | 2016-07-20 |
| CN105786695B true 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) |
Families Citing this family (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107391377B (en) * | 2017-07-26 | 2021-01-05 | 成都科来软件有限公司 | Method for testing software integration based on combined flow chart |
| 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 |
| 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 |
| CN110109824B (en) * | 2019-04-09 | 2022-05-17 | 平安科技（深圳）有限公司 | Big data autoregression test method and device, computer equipment and storage medium |
| CN110287097A (en) * | 2019-05-20 | 2019-09-27 | 深圳壹账通智能科技有限公司 | Batch testing method, device and computer readable storage medium |
| CN110188159B (en) * | 2019-05-27 | 2023-05-12 | 深圳前海微众银行股份有限公司 | Credit data access method, device, equipment and computer readable storage medium |
| CN112148346A (en) * | 2020-10-20 | 2020-12-29 | 云账户技术(天津)有限公司 | Method and device for docking platform system |
| CN115858372B (en) * | 2022-12-19 | 2024-04-26 | 上海浦东发展银行股份有限公司 | Batch data construction and automatic verification method and system based on OLAP system |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
Family Cites Families (1)
| 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 |
-
2014
- 2014-12-26 CN CN201410835000.3A patent/CN105786695B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
Non-Patent Citations (1)
| Title |
|---|
| 北京智友信诚科技有限公司.用友数据批量导入插件使用手册.《www.docin.com/p-179675489.html》.2011,第1-8页. |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105786695A (en) | 2016-07-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105786695B (en) | Data test method and system | |
| CN106354645B (en) | Test method and test platform based on background system service or interface | |
| CN103365770B (en) | Mobile terminal software test macro and method for testing software | |
| CN109726132A (en) | A kind of method for testing software and software test automation management system | |
| CN104268079B (en) | A kind of method and system of POS Application testings | |
| EP2615555A1 (en) | Framework for automated testing of mobile apps | |
| US20090271351A1 (en) | Rules engine test harness | |
| CN109582301A (en) | Method for processing business, device, equipment and the medium of task based access control scheduling system | |
| US9606901B1 (en) | System, method, and computer program for generating a detailed design of at least one telecommunications based integration testing project | |
| CN110493812B (en) | Distribution network test processing method, device and system, processor and master control equipment | |
| CN109902017A (en) | A kind of method and terminal based on RobotFramework test Dubbo interface | |
| CN112052172B (en) | Rapid test method and device for third-party channel and electronic equipment | |
| CN111309581B (en) | Application performance detection method and device in database upgrading scene | |
| CN112380255A (en) | Service processing method, device, equipment and storage medium | |
| CN109597733A (en) | A kind of multifunctional efficient dynamic chip verifying emulation mode and equipment | |
| CN112433944A (en) | Service testing method, device, computer equipment and storage medium | |
| CN112035363A (en) | Automatic interface testing method and device | |
| CN109784818A (en) | Product data processing method, device, equipment and storage medium based on BOM | |
| CN109597759A (en) | Test method and device, storage medium, the computer equipment of business software | |
| CN110287113A (en) | Automation interface test method | |
| CN112306857A (en) | Method and apparatus for testing applications | |
| CN113672674A (en) | Method, electronic device and storage medium for automatically arranging service flow | |
| CN117493188A (en) | Interface testing method and device, electronic equipment and storage medium | |
| CN112685291A (en) | System joint test method and related device | |
| CN114676066A (en) | Security testing method and device for target application, electronic equipment and 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 | ||
| PP01 | Preservation of patent right |
Effective date of registration: 20240202 Granted publication date: 20190917 |