CN105975390A - Complex test scene-based test data recovery method - Google Patents
Complex test scene-based test data recovery method Download PDFInfo
- Publication number
- CN105975390A CN105975390A CN201610277703.8A CN201610277703A CN105975390A CN 105975390 A CN105975390 A CN 105975390A CN 201610277703 A CN201610277703 A CN 201610277703A CN 105975390 A CN105975390 A CN 105975390A
- Authority
- CN
- China
- Prior art keywords
- test data
- test
- recovery
- scene
- under complicated
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/36—Preventing errors by testing or debugging software
- G06F11/3668—Software testing
- G06F11/3672—Test management
- G06F11/3688—Test management for test execution, e.g. scheduling of test suites
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computer Hardware Design (AREA)
- Quality & Reliability (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Debugging And Monitoring (AREA)
Abstract
The invention discloses a complex test scene-based test data recovery method and relates to the technical field of tests. The method is used for creating a test data recovery system and quickly recovering original test data through a visual interface. The method comprises the main steps of 1, storing an operation log; 2, developing a visual program; and 3, executing a corresponding script file to recover the test data. Through the method, test personnel can quickly recover the original test data only by starting the test data recovery system, selecting a path of the operation log and clicking recovery without re-preparing test data of a same scene, so that the test work efficiency is greatly improved.
Description
Technical field
The present invention relates to technical field of measurement and test, a kind of based on the recovery test data under complicated test scene
Method.
Background technology
In software test procedure, in order to cover code logic, tester can create much have pin according to test case
Test data to property, for simply testing data, prepare fairly simple, but for complicated test scene, often need
Want tester to create much and test data.
In test process, some operation possible additions and deletions can change the test data created originally, when wanting to test same scene
Wait, need tester to prepare identical data again, because data before cannot use because of changing.So give and survey
Examination personnel bring the work of a large amount of repetition, cause testing efficiency low, labor intensive and time.
Summary of the invention
The present invention is directed to current needs and the weak point of prior art development, it is provided that a kind of based on complicated test scene
Under recovery test data method.
Of the present invention a kind of based on the recovery test data method under complicated test scene, solve above-mentioned technical problem and adopt
Technical scheme as follows: described based on the recovery test data method under complicated test scene, creating one, to test data extensive
Complex system, by the test data that the fast quick-recovery of visualization interface is original, its key step includes: step one, preserves operation day
Will；Step 2, develops visualization procedure；Step 3, performs corresponding scripts file access pattern test data.
Preferably, described step one preserves Operation Log, and tester is in test process, and code logic records each step
Operation, the additions and deletions of data base are changed and look into, daily record all can record corresponding sql statement.
Preferably, described step 2 exploitation visualization procedure, utilize java exploitation or correlation technique exploitation visualization journey
Sequence, obtains the DDL statement in Operation Log, automatically generates contrary sql script file.
Preferably, step 3, perform the reverse sql script file generated in step 2.
Of the present invention a kind of compared with prior art have based on the recovery test data method under complicated test scene
Providing the benefit that: the present invention is operated by visualization interface, tester has only to open test data recovery system,
Select Operation Log path, click on and recover to get final product the test data that fast quick-recovery is original, it is not necessary to tester is preparing again
The test data of same scene；Substantially increase test job efficiency, additionally, the method can be with other automated test tools
It is used in combination.
Figure of description
Fig. 1 is the schematic diagram of described visualization interface operation.
Detailed description of the invention
For making the object, technical solutions and advantages of the present invention clearer, below in conjunction with specific embodiment, to this
Bright described a kind of based on the recovery test data method further description under complicated test scene.
The present invention proposes and a kind of will research and develop test job based on the recovery test data method under complicated test scene,
Set up from demand, to the procedure of carrying out of research and development with test job, the growth progress of record demand, it is simple to research and development test job
Efficiently perform and Liability Retroact.This recovery test data method, by the test data that the fast quick-recovery of visualization interface is original, no
Need tester again preparing the test data of same scene, be greatly improved test job efficiency.
Embodiment:
Described in the present embodiment a kind of based on the recovery test data method under complicated test scene, grasped by visualization interface
Make, will research and develop test job, from demand create, to research and development with test job carry out procedure, using demand establishment as flow process
Beginning, using research and development progress as one of the recording of growing up of flow process, after having researched and developed, research staff submit to tester；
After tester has tested, demand is closed.
Based on the recovery test data method under complicated test scene described in the present embodiment, create test data and recover
System, by the test data that the fast quick-recovery of visualization interface is original, its key step includes:
Step one, preserves Operation Log；Tester is in test process, and code logic can record the operation of each step, for
The additions and deletions of data base change looks into, and all can record corresponding sql statement in daily record；
Step 2, develops visualization procedure；Java exploitation or correlation technique exploitation visualization procedure can be utilized, obtain operation
DDL statement (UPDAT, INSERT, DELETE) in daily record, automatically generates contrary sql script file；
Step 3, performs corresponding scripts file access pattern test data；Perform the reverse sql script file generated in step 2；Institute
State reverse sql script, such as: cancel statement delete----> insert statement insert.
Based on the recovery test data method under complicated test scene described in the present embodiment, as shown in Figure 1, in visualization
Operating in interface, tester has only to open test data recovery system, rotation process log path, clicks on and recovers i.e.
Can recover to test data.Testing data method by this recovery, the generation of reverse script and the execution of sql statement are all by testing
Data recovery system performs in the code of backstage.Owing to the test data of simple test scene prepare fairly simple, institute of the present invention
State the method recovering to test data and be also applied for simple test scene.
Above-mentioned detailed description of the invention is only the concrete case of the present invention, and the scope of patent protection of the present invention includes but not limited to
Above-mentioned detailed description of the invention, any that meet claims of the present invention and any person of an ordinary skill in the technical field
The suitably change being done it or replacement, all should fall into the scope of patent protection of the present invention.
Claims (4)
1. test data method based on the recovery under complicated test scene for one kind, it is characterised in that create test data extensive
Complex system, by the test data that the fast quick-recovery of visualization interface is original, its key step includes: step one, preserves operation day
Will；Step 2, develops visualization procedure；Step 3, performs corresponding scripts file access pattern test data.
It is a kind of based on the recovery test data method under complicated test scene, it is characterised in that
Described step one preserves Operation Log, and tester is in test process, and code logic records the operation of each step, for data
The additions and deletions in storehouse change looks into, and all can record corresponding sql statement in daily record.
It is a kind of based on the recovery test data method under complicated test scene, it is characterised in that
Described step 2 exploitation visualization procedure, utilizes java exploitation or correlation technique exploitation visualization procedure, obtains Operation Log
In DDL statement, automatically generate contrary sql script file.
It is a kind of based on the recovery test data method under complicated test scene, it is characterised in that
Step 3, performs the reverse sql script file generated in step 2.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610277703.8A CN105975390A (en) | 2016-04-28 | 2016-04-28 | Complex test scene-based test data recovery method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610277703.8A CN105975390A (en) | 2016-04-28 | 2016-04-28 | Complex test scene-based test data recovery method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105975390A true CN105975390A (en) | 2016-09-28 |
Family
ID=56993315
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610277703.8A Pending CN105975390A (en) | 2016-04-28 | 2016-04-28 | Complex test scene-based test data recovery method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105975390A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107976965A (en) * | 2016-10-21 | 2018-05-01 | 费希尔-罗斯蒙特系统公司 | Apparatus and method for dynamic device description language menu |
| CN108304569A (en) * | 2018-02-13 | 2018-07-20 | 中国银行股份有限公司 | A kind of test data accumulation method and device |
| CN115145831A (en) * | 2022-09-05 | 2022-10-04 | 湖南长银五八消费金融股份有限公司 | Non-invasive test data recovery method and system |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101789002A (en) * | 2010-01-22 | 2010-07-28 | 浪潮(北京)电子信息产业有限公司 | Database compatibility test device and method for server |
-
2016
- 2016-04-28 CN CN201610277703.8A patent/CN105975390A/en active Pending
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101789002A (en) * | 2010-01-22 | 2010-07-28 | 浪潮(北京)电子信息产业有限公司 | Database compatibility test device and method for server |
Non-Patent Citations (1)
| Title |
|---|
| 芮冰冰: "基于VMware的NTFS文件备份与恢复系统的设计与实现", 《中国优秀硕士学位论文全文数据库信息科技辑》 * |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107976965A (en) * | 2016-10-21 | 2018-05-01 | 费希尔-罗斯蒙特系统公司 | Apparatus and method for dynamic device description language menu |
| CN107976965B (en) * | 2016-10-21 | 2022-08-23 | 费希尔-罗斯蒙特系统公司 | Apparatus and method for dynamic device description language menu |
| CN108304569A (en) * | 2018-02-13 | 2018-07-20 | 中国银行股份有限公司 | A kind of test data accumulation method and device |
| CN108304569B (en) * | 2018-02-13 | 2021-10-29 | 中国银行股份有限公司 | Test data accumulation method and device |
| CN115145831A (en) * | 2022-09-05 | 2022-10-04 | 湖南长银五八消费金融股份有限公司 | Non-invasive test data recovery method and system |
| CN115145831B (en) * | 2022-09-05 | 2022-11-08 | 湖南长银五八消费金融股份有限公司 | Non-invasive test data recovery method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9189377B1 (en) | Automation testing using descriptive maps | |
| CN102331967B (en) | Method for managing chip verification test cases | |
| US20170192882A1 (en) | Method and system for automatically generating a plurality of test cases for an it enabled application | |
| US9135714B1 (en) | Method and system for integrating a graphical user interface capture for automated test and retest procedures | |
| CN102567201B (en) | Method for automatically recovering cross-model GUI (graphic user interface) test scripts | |
| US20120173998A1 (en) | Three-dimensional gui object stores in automation test tools | |
| CN102110053B (en) | Random testing method based on Android | |
| US10459830B2 (en) | Executable code abnormality detection | |
| CN107301130A (en) | A kind of VR all-in-ones testing tool and its method | |
| Essick et al. | Optimizing vetoes for gravitational-wave transient searches | |
| CN102968375B (en) | Based on the infeasible paths detection method of association rule mining | |
| CN105975390A (en) | Complex test scene-based test data recovery method | |
| CN106021118B (en) | Test code generating method and device, test frame code execution method and device | |
| CN109408065A (en) | A kind of code publishing tool | |
| US10365995B2 (en) | Composing future application tests including test action data | |
| CN103488562B (en) | Automated testing method and device | |
| CN102411538B (en) | Method for restoring test script of graphical user interface based on event reachability mode | |
| CN109491922A (en) | One kind being based on model-driven test method and apparatus | |
| KR101009424B1 (en) | Method and apparatus for automatizing test of graphical user interface software | |
| CN103235978A (en) | Disaster monitoring and early warning system and method for establishing disaster monitoring and early warning system | |
| Pal et al. | A classification of software defect prediction models | |
| Han et al. | Automated warship software testing system based on loadrunner automation API | |
| Yuan et al. | Towards dynamic adaptive automated test generation for graphical user interfaces | |
| WO2017063555A1 (en) | Automatic system repair method and apparatus based on automatic exercise | |
| CN109752064A (en) | A kind of automation method for drafting for the mine remnants water level isopleth that accuracy is high |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20160928 |
|
| WD01 | Invention patent application deemed withdrawn after publication |