CN101136798A - Data configuration automatized test system and method - Google Patents
Data configuration automatized test system and method Download PDFInfo
- Publication number
- CN101136798A CN101136798A CNA2007100309778A CN200710030977A CN101136798A CN 101136798 A CN101136798 A CN 101136798A CN A2007100309778 A CNA2007100309778 A CN A2007100309778A CN 200710030977 A CN200710030977 A CN 200710030977A CN 101136798 A CN101136798 A CN 101136798A
- Authority
- CN
- China
- Prior art keywords
- subsystem
- data configuration
- case
- database
- test
- 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
Images
Landscapes
- Debugging And Monitoring (AREA)
Abstract
The system includes instance management subsystem (IMS), instance drive subsystem (IDS), instance execution script subsystem, and subsystem for executing commands of data configuration, database monitor subsystem, and log management subsystem (LMS). The method includes steps: using IMS edits test data to be tested, and submits edited test data to automated test system; executing instance drive to carry out automated test for the test data to be tested; after all designs for test are executed completely, LMS checks through executed result. Implementing automated test for data configuration of communication system, the invention raises speed and precision of test as well as saves manpower.
Description
Technical field
The present invention relates to the automatic test field of communication system data configuration.
Background technology
All need to use data configuration in the existing communication apparatus greatly, data configuration provides operation required various data messages for equipment, so correct, the correctness that stable operation depends on data configuration to a great extent of equipment.Test is to guarantee the correct effective ways of data configuration, can the data of verification msg configuration store in database be contemplated that not consistently with us by test, is correct with these data that guarantee finally to offer the equipment use.
At present the test of data configuration is all finished by the tester is manual, after the tester executes a data configuration order, by certain mode database is inquired about, obtain the influence of configuration order, draw this data configuration order conclusion whether correct at last database manipulation to database.This manual test method has following deficiency:
1. workload is very big;
2. the tester is had relatively high expectations;
3. Ce Shi accuracy, validity tested person personnel's level and emotion influence are bigger;
4. efficient is very low;
5. especially be unfavorable for smoke test and regression test.
On the other hand, data configuration relates generally to the operation to database, and whether checking correctly is the emphasis that we should pay close attention to the database operating result.At present manual test is limited to the dynamics of database auditing, for operated concrete tables of data and the data field that arrives in the data configuration of big data quantity and the data configuration process, adopts the method effect of manual test to be difficult to desirable.
Because above deficiency, manual test is difficult to guarantee fully the accuracy of data configuration, occurs test leakage and mistake survey easily, data with mistake offer the equipment use thus, in case equipment uses these misdatas, just might cause unusual even the machine of delaying, cause very big loss to enterprise.
Summary of the invention
The objective of the invention is to propose a kind of system and method to data configuration realization automatic test, by this system and method, solve present data configuration manual test inefficiency, validity is low and to problems such as the database inspection are not enough, for equipment provides configuration data accurately.
For achieving the above object, the invention provides a kind of data configuration automatized test system, it comprises following subsystem:
The use-case driver sub-system is used to instruct data configuration command execution subsystem operations database and receive execution result;
Data configuration command execution subsystem is used to receive and carry out the data configuration order that described use-case driver sub-system sends, and execution result is returned to described use-case driver sub-system;
Use-case is carried out the script subsystem, is used to preserve the expected results of data configuration order to database manipulation; Whether the execution result of checking described data configuration command execution subsystem operations database is consistent with described expected results, and check result is returned described use-case driver sub-system.
Further, also comprise: the case management subsystem is used for editor and preserves the data configuration order;
And described use-case driver sub-system also is used for reading described data configuration order from described case management subsystem, and described data configuration order is sent to described data configuration command execution subsystem.
Further, also comprise following subsystem:
The log management subsystem is used for logging test results
The database monitor subsystem is used to trigger storing process, and described storing process is the operation that database is taken place in order to write down;
And, described use-case driver sub-system also is used for: after described data configuration command execution subsystem returns result to database manipulation, call described use-case execution script subsystem database is checked, and the outcome record that described use-case execution script subsystem is returned arrives described log management subsystem;
Further, described use-case is carried out the script subsystem and is comprised: the precondition acquisition module, be used for before the data configuration command execution, obtaining data, and use when verifying for execution result; The result verification module is used for after the data configuration command execution is finished, and whether data that described database monitor subsystem produces and anticipatory data be consistent verifies described data configuration order by inquiring about.
And described database monitor subsystem is realized the monitoring of operation that database is taken place by creating trigger.
The present invention also provides a kind of data configuration automatized method of testing, and it may further comprise the steps:
Step 10: described use-case driver sub-system is called described use-case and is carried out the script subsystem, obtains advance data;
Step 20: described use-case driver sub-system sends to described data configuration command execution subsystem with the data configuration order;
Step 30: described data configuration command execution subsystem receives the data configuration order and carries out, and execution result is returned described use-case driver sub-system;
Step 40: described use-case driver sub-system receives execution result, if run succeeded, calls described use-case execution script subsystem database is checked, checks whether described data configuration order is consistent with expected results to the operation of database.
Further, described step 40 also comprises: get nowhere if carry out, call described use-case execution script subsystem database is checked, check whether described data configuration order is operated database.
Further, described step 10 comprises following process:
Step 81: described case management subsystem editor Test Design, described Test Design is made up of at least one testing procedure, and described testing procedure is made up of one group of manmachine command that is mutually related;
Step 82: described case management subsystem is submitted to the Test Design that edits under the assigned catalogue;
Step 83: described use-case driver sub-system reads testing procedure in the described Test Design and the manmachine command in the described testing procedure in order, carry out the script subsystem according to manmachine command number from described use-case and call corresponding use-case and carry out script, obtain advance data.
Further, carry out after the described step 40, also carry out following steps:
Step 91: described use-case is carried out the script subsystem will check that the result of database returns described use-case driver sub-system;
Step 92: described use-case driver sub-system writes daily record according to the described log management subsystem of database auditing call by result with check result.
Compared with prior art, the present invention can realize the automatic test of communication system data configuration, improves the speed and the accuracy of test, saves manpower.
Description of drawings
Fig. 1 is a system configuration schematic diagram of the present invention;
Fig. 2 is a use-case organization chart of the present invention;
Fig. 3 is a daily record organization chart of the present invention;
Fig. 4 is a method flow diagram of the present invention.
Embodiment
Below in conjunction with the drawings and specific embodiments the present invention is described in more detail.
Figure 1 shows that system configuration schematic diagram of the present invention.As shown in the figure, this system comprises case management subsystem 11, use-case driver sub-system 12, use-case execution script subsystem 16, data configuration command execution subsystem 15, database monitor subsystem 14 and log management subsystem 13.
Case management subsystem 11 mainly links to each other with use-case driver sub-system 12 with use-case management of webpage subsystem, be responsible for the test data in the system is carried out centralized and unified management, and can be user's use-case data management function efficiently of providing convenience by multiple modes such as the Web page, text editings, use-case driver sub-system 12 reads from case management subsystem 11 and once tests needed all test datas and order is carried out.
Use-case driver sub-system 12 is mainly carried out script subsystem 16, data configuration command execution subsystem 15 and log management subsystem 13 with case management subsystem 11, use-case and is linked to each other, be responsible for reading pending use-case data, corresponding use-case is simply resolved and called to the use-case data carrying out script these use-case data are handled from case management subsystem 11, test data is sent to data configuration command execution subsystem 15, call use-case according to execution result and carry out script and database 18 is checked and check result is write log management subsystem 13.
Data configuration command execution subsystem 15 links to each other with database 18, is responsible for carrying out concrete configuration order and execution result is returned to use-case driver sub-system 12.
14 of database monitor subsystems link to each other with database 18, and only need move once, be responsible for triggering when bound pair database 18 is operated outside corresponding storing process to note extraneous details, for result verification provides necessary foundation to database 18 operations.
Fig. 2 is a use-case organization chart of the present invention.System shown in Figure 1 is in realizing automatic test course, and case management subsystem 11 can Test Design of editor, and this design as shown in Figure 2, comprises testing bunch, and described test bunch is made up of a plurality of testing procedures, and each testing procedure comprises several test commands again.
Fig. 3 is a daily record organization chart of the present invention.This daily record is kept in the log management subsystem 13, and as shown in the figure, daily record comprises overall journal file, Log Directory and more detailed logging file, and when database is operated when changing, this changes to be responsible for record, for the test of configuration data provides foundation.
Based on system shown in Figure 1, present embodiment is realized the method that third party's audio-video frequency content is uploaded in the IPTV system, comprise following step:
Steps A: need the test data of test to edit by 11 pairs of case management subsystems, and submit to automatization test system;
Step B: carry out use-case and drive, the test data of needs test is carried out automatic test;
Step C: after all Test Design are complete, check execution result by log management subsystem 13.
Describe above-mentioned 3 steps among Fig. 4 in detail, concrete is described below:
(1) from database 18, derives all table names, and save as txt file;
(2) operation trigger generation script generates the trigger that all show all operations automatically;
(3) generate all use-cases that once need to test and tabulate, and it is submitted under the assigned catalogue;
(4) operation use-case driver sub-system 12, use-case driver sub-system 12 orders read all configuration orders;
(5) 12 pairs of configuration orders of use-case driver sub-system are simply resolved, and obtain configuration order number;
(6) use-case driver sub-system 12 is called use-case according to the command number of configuration order and is carried out script subsystem 16, and operating database 18 uses when obtaining advance data for result verification;
(7) use-case driver sub-system 12 sends to 15 execution of data configuration command execution subsystem with this configuration order;
(8) data configuration command execution subsystem 15 is received configuration order, and it is resolved and operating database 18;
(9) database monitor subsystem 14 monitors the operation of configuration order to database 18, and the temporary table that operation note is created by trigger is noted;
(10) data configuration command execution subsystem 15 returns to use-case driver sub-system 12 with the execution result of configuration order;
(11) use-case driver sub-system 12 obtains the execution result of configuration order;
(12) unsuccessful if configuration order is carried out, use-case driver sub-system 12 is checked database 18, checks that whether configuration order is to database 18 generation operations and according to the check result log;
(13) if configuration order runs succeeded, use-case driver sub-system 12 is called 16 pairs of databases 18 of use-case execution script subsystem once more and is checked, checks whether configuration order is consistent with desired value (writing in the script according to test case) to the operation that database 18 produces;
(14) use-case driver sub-system 12 is according to database 18 check result logs;
(15) use-case driver sub-system 12 reads next bar configuration order and repeats the operation of front.
In actual application, the present invention sets a time in night to move automatically, and the result of operation can automatically record, and the developer just can view execution result in the next morning by the web page.
The present invention has the following advantages: the invention provides a cover is configured into capable automatic test to data holonomic system and method, by this system and method, can realize automatic test easily to the data configuration-system, it is big to have solved the manual test workload on the one hand, efficient is not high, accuracy is not high, and is difficult in maintenance, shortcomings such as reusability difference; By the means of testing of automation, exploitation, tester can be focused on attentiveness in the more significant work such as structure of test case on the other hand.System's formation among the present invention is simple, and the clear standard of operation flow, whole system are easy to revise, expand and safeguard, the easy to implement and popularization of entire method.
Certainly; the present invention also can have other various embodiments; under the situation that does not deviate from spirit of the present invention and essence thereof; those of ordinary skill in the art work as can make various corresponding changes and distortion according to the present invention, but these corresponding changes and distortion all should belong to the protection range of the appended claim of the present invention.
Claims (9)
1. a data configuration automatized test system is characterized in that, comprises following subsystem:
The use-case driver sub-system is used to the smooth execution of coordinating, dispatching the operate as normal of all subsystems and controlling whole automatic test flow process;
Data configuration command execution subsystem is used to receive and carry out the data configuration order that described use-case driver sub-system sends, and execution result is returned to described use-case driver sub-system;
Use-case is carried out the script subsystem, is used for the operation of analogue data configuration order to database, preserves the expected results of operation; Whether the execution result of checking described data configuration command execution subsystem operations database is consistent with described expected results, and check result is returned described use-case driver sub-system.
2. data configuration automatized test system as claimed in claim 1 is characterized in that,
Also comprise: the case management subsystem is used for editor and preserves the data configuration order;
And,
Described use-case driver sub-system also is used for reading described data configuration order from described case management subsystem, and described data configuration order is sent to described data configuration command execution subsystem.
3. data configuration automatized test system as claimed in claim 2 is characterized in that,
Also comprise following subsystem:
The log management subsystem is used for logging test results;
The database monitor subsystem is used for all changes of monitor database, and described monitoring is finished by triggering storing process, and described storing process is the operation that database is taken place in order to write down;
And,
Described use-case driver sub-system also is used for: after described data configuration command execution subsystem returns result to database manipulation, call described use-case execution script subsystem database is checked, and the outcome record that described use-case execution script subsystem is returned arrives described log management subsystem.
4. as each described data configuration automatized test system in the claim 1 to 3, it is characterized in that, described use-case is carried out the script subsystem and is comprised: the precondition acquisition module, be used for before the data configuration command execution, obtaining data, and use when verifying for execution result; The result verification module is used for after the data configuration command execution is finished, and whether data that described database monitor subsystem produces and anticipatory data be consistent verifies described data configuration order by inquiring about.
5. as each described data configuration automatized test system in the claim 1 to 3, it is characterized in that described database monitor subsystem is realized the monitoring of operation that database is taken place by creating trigger.
6. a data configuration automatized method of testing is characterized in that, may further comprise the steps:
Step 10: described use-case driver sub-system is called described use-case and is carried out the script subsystem, obtains advance data;
Step 20: described use-case driver sub-system sends to described data configuration command execution subsystem with the data configuration order;
Step 30: described data configuration command execution subsystem receives the data configuration order and carries out, and execution result is returned described use-case driver sub-system;
Step 40: described use-case driver sub-system receives execution result, if run succeeded, calls described use-case execution script subsystem database is checked, checks whether described data configuration order is consistent with expected results to the operation of database.
7. data configuration automatized method of testing as claimed in claim 6, it is characterized in that, described step 40 also comprises: get nowhere if carry out, call described use-case execution script subsystem database is checked, check whether described data configuration order is operated database.
8. data configuration automatized method of testing as claimed in claim 6 is characterized in that, described step 10 comprises following process:
Step 81: described case management subsystem editor Test Design, described Test Design is made up of at least one testing procedure, and described testing procedure is made up of one group of manmachine command that is mutually related;
Step 82: described case management subsystem is submitted to the Test Design that edits under the assigned catalogue;
Step 83: described use-case driver sub-system reads testing procedure in the described Test Design and the manmachine command in the described testing procedure in order, carry out the script subsystem according to manmachine command number from described use-case and call corresponding use-case and carry out script, obtain advance data.
9. data configuration automatized method of testing as claimed in claim 6 is characterized in that, carries out after the described step 40, also carries out following steps:
Step 91: described use-case is carried out the script subsystem will check that the result of database returns described use-case driver sub-system;
Step 92: described use-case driver sub-system writes daily record according to the described log management subsystem of database auditing call by result with check result.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2007100309778A CN101136798A (en) | 2007-10-16 | 2007-10-16 | Data configuration automatized test system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2007100309778A CN101136798A (en) | 2007-10-16 | 2007-10-16 | Data configuration automatized test system and method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101136798A true CN101136798A (en) | 2008-03-05 |
Family
ID=39160653
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNA2007100309778A Pending CN101136798A (en) | 2007-10-16 | 2007-10-16 | Data configuration automatized test system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101136798A (en) |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101489244A (en) * | 2008-09-25 | 2009-07-22 | 中国移动通信集团浙江有限公司 | Test method for detecting caller authentication data of short message center |
| WO2011079690A1 (en) * | 2009-12-29 | 2011-07-07 | 北京世纪高通科技有限公司 | Journal monitoring method and device |
| CN103761185A (en) * | 2014-01-14 | 2014-04-30 | 烽火通信科技股份有限公司 | Automated testing system and automated testing method |
| CN103812726A (en) * | 2014-01-26 | 2014-05-21 | 烽火通信科技股份有限公司 | Automated testing method and device for data communication equipment |
| CN104601403A (en) * | 2015-01-07 | 2015-05-06 | 上海瀚之友信息技术服务有限公司 | Automatic test system |
| CN105989025A (en) * | 2015-01-30 | 2016-10-05 | 阿里巴巴集团控股有限公司 | Data checking method ad device |
| CN107193736A (en) * | 2017-05-18 | 2017-09-22 | 恒生电子股份有限公司 | Method of testing, device, electronic equipment and storage medium |
| CN108446370A (en) * | 2018-03-15 | 2018-08-24 | 苏州思必驰信息科技有限公司 | Voice data statistical method and system |
| CN115269443A (en) * | 2022-09-29 | 2022-11-01 | 中邮消费金融有限公司 | Software defect automatic positioning test method and system |
-
2007
- 2007-10-16 CN CNA2007100309778A patent/CN101136798A/en active Pending
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101489244A (en) * | 2008-09-25 | 2009-07-22 | 中国移动通信集团浙江有限公司 | Test method for detecting caller authentication data of short message center |
| CN101489244B (en) * | 2008-09-25 | 2014-01-29 | 中国移动通信集团浙江有限公司 | Test method for detecting caller authentication data of short message center |
| WO2011079690A1 (en) * | 2009-12-29 | 2011-07-07 | 北京世纪高通科技有限公司 | Journal monitoring method and device |
| CN103761185A (en) * | 2014-01-14 | 2014-04-30 | 烽火通信科技股份有限公司 | Automated testing system and automated testing method |
| CN103761185B (en) * | 2014-01-14 | 2016-06-22 | 烽火通信科技股份有限公司 | A kind of automatization test system and method |
| CN103812726A (en) * | 2014-01-26 | 2014-05-21 | 烽火通信科技股份有限公司 | Automated testing method and device for data communication equipment |
| CN103812726B (en) * | 2014-01-26 | 2017-02-01 | 烽火通信科技股份有限公司 | Automated testing method and device for data communication equipment |
| CN104601403A (en) * | 2015-01-07 | 2015-05-06 | 上海瀚之友信息技术服务有限公司 | Automatic test system |
| CN105989025A (en) * | 2015-01-30 | 2016-10-05 | 阿里巴巴集团控股有限公司 | Data checking method ad device |
| CN107193736A (en) * | 2017-05-18 | 2017-09-22 | 恒生电子股份有限公司 | Method of testing, device, electronic equipment and storage medium |
| CN108446370A (en) * | 2018-03-15 | 2018-08-24 | 苏州思必驰信息科技有限公司 | Voice data statistical method and system |
| CN115269443A (en) * | 2022-09-29 | 2022-11-01 | 中邮消费金融有限公司 | Software defect automatic positioning test method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101136798A (en) | Data configuration automatized test system and method | |
| CN101241467B (en) | Automatized white box test system and method facing to WEB application | |
| CN101713823B (en) | Satellite telemetry data reduction processing method | |
| US11176028B2 (en) | System, method and storage device for CIM/E model standard compliance test | |
| CN108268377A (en) | A kind of service test method of server, device and medium | |
| CN108920250A (en) | The method and device of Application Container | |
| CN102306122A (en) | Automated testing method and equipment | |
| CN102831188A (en) | Promoting message setting method and terminal | |
| CN103164328A (en) | Method and device and system for regression testing of service function | |
| CN102831052A (en) | Automatic generating device and method for test case | |
| CN102945629B (en) | Generating method and system of three-dimensional simulation training case of power grid substation | |
| CN107783902A (en) | A kind of Selenium automated testing methods and system from coding | |
| CN102541740A (en) | Android-based automatic test method for mobile phone notes | |
| CN109597763B (en) | Consistency verification method and device for normalizing multiple items of data | |
| CN101174237B (en) | Automatic test method, system and test device | |
| CN106355303A (en) | Data model automatic evaluation system | |
| CN110209584A (en) | A kind of automatic generation of test data and relevant apparatus | |
| CN101604290B (en) | Background module test method and backstage module test system | |
| Rong et al. | DevDocOps: towards automated documentation for DevOps | |
| CN110321536B (en) | Science and technology report online writing and presenting management system | |
| CN109299016A (en) | Assessment document structure tree method, system and terminal device | |
| CN104331360A (en) | Automatic testing platform | |
| CN105550008A (en) | Method for automatically and repeatedly updating BIOS + ME based on Linux | |
| CN108062266A (en) | A kind of PCIE-SSD automated testing methods based on cloud platform | |
| CN117114600A (en) | RPA virtual employee management method and system for power grid production command center |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Open date: 20080305 |