CN112612691A - Method and system for realizing automatic test data management and control based on SVN, electronic device and storage medium - Google Patents
Method and system for realizing automatic test data management and control based on SVN, electronic device and storage medium Download PDFInfo
- Publication number
- CN112612691A CN112612691A CN202011379040.3A CN202011379040A CN112612691A CN 112612691 A CN112612691 A CN 112612691A CN 202011379040 A CN202011379040 A CN 202011379040A CN 112612691 A CN112612691 A CN 112612691A
- Authority
- CN
- China
- Prior art keywords
- test
- test data
- svn
- result
- compiling
- 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
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/3684—Test management for test design, e.g. generating new test cases
-
- 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 method and a system for realizing automatic test data management and control based on SVN, electronic equipment and a storage medium, belonging to the technical field of test, wherein the method is used for compiling test data according to the requirements of a service scene and correspondingly uploading the compiled test data to an SVN version library; selecting a test case to be tested from the SVN version library, and acquiring writing test data corresponding to the test case; obtaining an expected result of the test case according to the written test data; testing the compiled test data to obtain the actual test result; comparing the actual result with the expected result, and if the actual result is consistent with the expected result, ending the test; if the two results are not consistent, retesting. According to the invention, through the SVN version control of the test data, the one-time passing rate of the scene test is improved, the test quality is improved, and the one-time passing rate of the test is improved by more than 50%.
Description
Technical Field
The invention belongs to the technical field of automatic testing, and particularly relates to a method and a system for realizing automatic testing data management and control based on SVN, electronic equipment and a storage medium.
Background
With the development of communication technology, the telecommunication industry has also developed dramatically in charging services. Therefore, higher requirements are provided for a service support system, the architecture is continuously upgraded, and the system is continuously and flexibly expanded. The support system intellectualization and operation automation become the inevitable result of the future development trend and system evolution. In the 5G era, the service of the telecommunication system is more complex, and the requirements on the test quality and efficiency are higher and higher in the service promotion process of new requirements. And the business personnel and the testing personnel update and submit the test data in time and are inconsistent, so that the problem of low test effect and test quality is caused.
Disclosure of Invention
Aiming at the problems of poor test effect and poor test quality, the invention provides a method and a system for realizing automatic test data management and control of a version control System (SVN) based on open source codes, electronic equipment and a storage medium.
A method for realizing automatic test data management and control based on SVN comprises the following steps:
compiling test data according to the service scene requirements, and correspondingly uploading the compiled test data to an SVN version library;
selecting a test case to be tested from the SVN version library, and acquiring the compiling test data corresponding to the test case;
obtaining an expected result of the test case according to the written test data;
testing the compiled test data to obtain an actual test result;
comparing the actual result with the expected result, and if the actual result is consistent with the expected result, ending the test; if the two results are not consistent, retesting.
Preferably, the written test data includes a test script and an expected result.
Preferably, the name of each test case corresponding to the test writing test data includes a number corresponding to the test case one to one.
Preferably, the step of obtaining the written test data corresponding to the test case from the SVN version library includes:
and the path and the name of the compiling test data in the SVN version library are configured through the test case parameters, and the compiling test data in the SVN version library is automatically acquired through reading the parameters of the test case.
Preferably, the SVN version repository is accessed by a username and password login of the SVN version repository.
Preferably, the method further comprises: and after the test is finished, a test report is automatically generated and the viewing and downloading are supported.
The embodiment of the invention provides a system for realizing automatic test data management and control based on SVN, which comprises:
the configuration module is used for compiling test data according to the service scene requirements and correspondingly uploading the compiled test data to the SVN version library;
the acquisition module is used for selecting a test case to be tested from the SVN version library, acquiring the compiling test data corresponding to the test case and acquiring an expected result of the test case according to the compiling test data;
the test module is used for testing the written test data to obtain the actual test result;
the comparison module is used for comparing the actual result with the expected result, and if the actual result is consistent with the expected result, the test is finished; if the two results are not consistent, retesting.
An embodiment of the present invention provides an electronic device, which includes at least one processing unit and at least one storage unit, where the storage unit stores a computer program, and when the program is executed by the processing unit, the processing unit is caused to execute the method described above.
A storage medium storing a computer program executable by an electronic device according to an embodiment of the present invention is configured to, when the program runs on the electronic device, cause the electronic device to execute the method described above.
Compared with the prior art, the invention has the beneficial effects that:
in each test, the expected result is compared with the actual result tested by compiling the test data, if the expected result is consistent with the actual result tested by compiling the test data, the test is finished, and if the expected result is inconsistent with the actual result tested by compiling the test data, the test data is compiled to be updated to replace the test data which is updated, so that the accuracy and timeliness of the test data are improved, the test quality is improved, the rework of a tester and the communication cost of service personnel on the test data are reduced, and the test efficiency is improved; in addition, the one-time passing rate of the scene test is improved through the SVN version control of the test data, the test quality is improved, and the one-time passing rate of the test is improved by more than 50%.
Drawings
FIG. 1 is a schematic structural diagram of an implementation system of the SVN-based automated test data management and control of the present invention;
FIG. 2 is a schematic flow chart of an implementation method of the SVN-based automated test data management and control of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention. All other embodiments, which can be obtained by a person skilled in the art without any inventive step based on the embodiments of the present invention, are within the scope of the present invention.
In the description of the present invention, it should be noted that the terms "center", "upper", "lower", "left", "right", "vertical", "horizontal", "inner", "outer", etc., indicate orientations or positional relationships based on the orientations or positional relationships shown in the drawings, and are only for convenience of description and simplicity of description, but do not indicate or imply that the device or element being referred to must have a particular orientation, be constructed and operated in a particular orientation, and thus, should not be construed as limiting the present invention. Furthermore, the terms "first," "second," and "third" are used for descriptive purposes only and are not to be construed as indicating or implying relative importance.
In the description of the present invention, it should also be noted that, unless otherwise explicitly specified or limited, the terms "mounted," "connected," and "connected" are to be construed broadly, e.g., as meaning either a fixed connection, a removable connection, or an integral connection; can be mechanically or electrically connected; they may be connected directly or indirectly through intervening media, or they may be interconnected between two elements. The specific meanings of the above terms in the present invention can be understood in specific cases to those skilled in the art.
Referring to fig. 1, a schematic structural diagram of an implementation system for SVN-based automated test data management and control according to an embodiment of the present application is shown, which includes:
the configuration module 1 is used for compiling test data according to the service scene requirements and correspondingly uploading the compiled test data to the SVN version library 2;
the acquisition module 3 is used for selecting a test case to be tested from the SVN version library 2, acquiring writing test data corresponding to the test case, and acquiring an expected result of the test case according to the writing test data;
the test module 4 is used for testing the written test data and obtaining the actual test result;
the comparison module 5 is used for comparing the actual result with the expected result, and if the actual result is consistent with the expected result, the test is finished; if the two results are not consistent, retesting.
Specifically, the tester writes test data according to the business scenario change, uploads the test data to the SVN version library 2, and writes the test data including a test script and an expected result. The paths and names of the test data in the SVN version library 2 are configured through test case parameters, namely, only the test case parameters are read, the compiling test data can be obtained from the SVN version library 2, and expected results can be obtained correspondingly; then automatically testing the compiled test data to obtain an actual result; comparing the actual result with the expected result, and if the actual result is consistent with the expected result, ending the test; if the two results are not consistent, retesting. According to the system, the one-time passing rate of the scene test is improved through the SVN version management and control of the test data, the test quality is improved, and the one-time passing rate of the test is improved by more than 50%.
As shown in fig. 2, this embodiment further provides an implementation method for controlling automated test data based on SVN, which includes:
step 1: compiling test data according to the service scene requirements, and correspondingly uploading the compiled test data to an SVN version library 2;
specifically, the SVN version library 2 is accessed through the user name and password login of the SVN version library 2, and the SVN version library 2 data is updated and submitted. Compiling test data including a test script and an expected result, and configuring a folder by the test script and the expected result, wherein the folder is named according to a standard naming rule and stored in a standard directory; in addition, the name of the folder name contains the test case number, namely, the test case number corresponds to the test case number one by one. Each updating needs to determine the folder name of the test data according to the test case number.
In addition, a database function test case is adopted in the SVN version library 2, which is specifically shown in table 1.
TABLE 1
| Database object _ Table |
| Database object _ index |
| Database object _ sequence |
| Database object _ View |
| Database object _ user |
| Database object _ Lock |
| Database object recycle bin |
| Database Access _ general Access |
| Database access transaction |
| Database access _ System View |
| Database access character terminal |
| Database access _ Programming interface |
| Database management and control _ tool |
| Database management and control _ all table access control |
| Database management and control _ sqlome switch |
| Database management and control _ Log management |
| Database management and control-license management |
| Database management and control _ version admission control |
| Database management and control-online upgrade |
| Database management and control-communication mode |
| Database management and control _ elastic scaling |
| Database management and control-multi-tenant management |
| Database management and control _ connection management |
| Database management and control _ redo log lock control |
| Database management and control-multiple cluster management |
| Database management and control-multinode management |
| Database management and control asynchronous redo |
Step 2: selecting a test case to be tested from the SVN version library 2, and acquiring writing test data corresponding to the test case;
specifically, the path and name of the writing test data in the SVN version library 2 are configured through test case parameters, and the writing test data in the SVN version library 2 is automatically obtained by reading the parameters of the test case.
And step 3: obtaining an expected result of the test case according to the written test data;
and 4, step 4: testing the compiled test data to obtain the actual test result;
and 5: comparing the actual result with the expected result, and if the actual result is consistent with the expected result, ending the test; if the two results are not consistent, retesting;
step 6: and after the test is finished, a test report is automatically generated and the viewing and downloading are supported.
By the method, the accuracy and timeliness of the test data are improved, the test quality is improved, the rework cost of the tester and the communication cost of business personnel for the test data are reduced, and the test efficiency is improved; and the problem of inaccurate test caused by the change of the service scene and the untimely change of the test data is reduced by over 80 percent.
The present embodiment also provides an electronic device, which includes at least one processing unit and at least one storage unit, where the storage unit stores a computer program, and when the program is executed by the processing unit, the processing unit is enabled to execute the method.
The present embodiment also provides a storage medium storing a computer program executable by an electronic device, which, when the program is run on the electronic device, causes the electronic device to perform the above-mentioned method.
The above is only a preferred embodiment of the present invention, and is not intended to limit the present invention, and various modifications and changes will occur to those skilled in the art. Any modification, equivalent replacement, or improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.
Claims (9)
1. A method for realizing automatic test data management and control based on SVN is characterized by comprising the following steps:
compiling test data according to the service scene requirements, and correspondingly uploading the compiled test data to an SVN version library;
selecting a test case to be tested from the SVN version library, and acquiring the compiling test data corresponding to the test case;
obtaining an expected result of the test case according to the written test data;
testing the compiled test data to obtain an actual test result;
comparing the actual result with the expected result, and if the actual result is consistent with the expected result, ending the test; if the two results are not consistent, retesting.
2. The method of claim 1, wherein the test writing test data comprises test scripts and expected results.
3. The method of claim 2, wherein each test case name corresponding to the test writing test data comprises a number corresponding to the test case one to one.
4. The method of claim 3, wherein the step of obtaining the written test data corresponding to the test case from the SVN version library comprises:
and the path and the name of the compiling test data in the SVN version library are configured through the test case parameters, and the compiling test data in the SVN version library is automatically acquired through reading the parameters of the test case.
5. The method of claim 1, wherein the SVN version repository is accessed via a username and password login of the SVN version repository.
6. The method of claim 1, further comprising: and after the test is finished, a test report is automatically generated and the viewing and downloading are supported.
7. An implementation system for automatic test data management and control based on SVN, for implementing the method of any claim in claims 1-6, comprising:
the configuration module is used for compiling test data according to the service scene requirements and correspondingly uploading the compiled test data to the SVN version library;
the acquisition module is used for selecting a test case to be tested from the SVN version library, acquiring the compiling test data corresponding to the test case and acquiring an expected result of the test case according to the compiling test data;
the test module is used for testing the written test data to obtain the actual test result;
the comparison module is used for comparing the actual result with the expected result, and if the actual result is consistent with the expected result, the test is finished; if the two results are not consistent, retesting.
8. An electronic device, comprising at least one processing unit and at least one memory unit, wherein the memory unit stores a computer program that, when executed by the processing unit, causes the processing unit to perform the method of any of claims 1 to 6.
9. A storage medium storing a computer program executable by an electronic device, the program, when run on the electronic device, causing the electronic device to perform the method of any one of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011379040.3A CN112612691A (en) | 2020-11-30 | 2020-11-30 | Method and system for realizing automatic test data management and control based on SVN, electronic device and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011379040.3A CN112612691A (en) | 2020-11-30 | 2020-11-30 | Method and system for realizing automatic test data management and control based on SVN, electronic device and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112612691A true CN112612691A (en) | 2021-04-06 |
Family
ID=75228316
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011379040.3A Pending CN112612691A (en) | 2020-11-30 | 2020-11-30 | Method and system for realizing automatic test data management and control based on SVN, electronic device and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112612691A (en) |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103246604A (en) * | 2013-03-29 | 2013-08-14 | 北京京东尚科信息技术有限公司 | Soft testing system, soft testing method, controlling device and executing devices |
| CN106326116A (en) * | 2016-08-17 | 2017-01-11 | 北京奇虎科技有限公司 | Method and device for testing product |
| CN107704391A (en) * | 2017-09-29 | 2018-02-16 | 马上消费金融股份有限公司 | A kind of method of testing and device based on Selenium |
| CN107832231A (en) * | 2017-12-05 | 2018-03-23 | 郑州云海信息技术有限公司 | A kind of system detection method, device and medium |
| CN108647147A (en) * | 2018-05-15 | 2018-10-12 | 南京璇玑信息技术有限公司 | It is a kind of to execute automatic test machine people and its application method using atlas analysis |
| CN108959067A (en) * | 2018-05-31 | 2018-12-07 | 康键信息技术（深圳）有限公司 | Test method, device and the computer readable storage medium of search engine |
| CN111061244A (en) * | 2019-11-09 | 2020-04-24 | 许继集团有限公司 | Automatic testing method for power distribution master station monitoring system |
| CN111209185A (en) * | 2019-12-23 | 2020-05-29 | 厦门市美亚柏科信息股份有限公司 | Keyword-based automated testing method and computer-readable storage medium |
-
2020
- 2020-11-30 CN CN202011379040.3A patent/CN112612691A/en active Pending
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103246604A (en) * | 2013-03-29 | 2013-08-14 | 北京京东尚科信息技术有限公司 | Soft testing system, soft testing method, controlling device and executing devices |
| CN106326116A (en) * | 2016-08-17 | 2017-01-11 | 北京奇虎科技有限公司 | Method and device for testing product |
| CN107704391A (en) * | 2017-09-29 | 2018-02-16 | 马上消费金融股份有限公司 | A kind of method of testing and device based on Selenium |
| CN107832231A (en) * | 2017-12-05 | 2018-03-23 | 郑州云海信息技术有限公司 | A kind of system detection method, device and medium |
| CN108647147A (en) * | 2018-05-15 | 2018-10-12 | 南京璇玑信息技术有限公司 | It is a kind of to execute automatic test machine people and its application method using atlas analysis |
| CN108959067A (en) * | 2018-05-31 | 2018-12-07 | 康键信息技术（深圳）有限公司 | Test method, device and the computer readable storage medium of search engine |
| CN111061244A (en) * | 2019-11-09 | 2020-04-24 | 许继集团有限公司 | Automatic testing method for power distribution master station monitoring system |
| CN111209185A (en) * | 2019-12-23 | 2020-05-29 | 厦门市美亚柏科信息股份有限公司 | Keyword-based automated testing method and computer-readable storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108595342B (en) | Unit testing method and device | |
| US20170228220A1 (en) | Self-healing automated script-testing tool | |
| CN111382070A (en) | Compatibility testing method and device, storage medium and computer equipment | |
| CN112181854B (en) | Method, device, equipment and storage medium for generating process automation script | |
| CN111240955A (en) | Automatic testing method and device for Http interface, storage medium and electronic device | |
| CN111679982A (en) | Automatic testing method for REST API (representational State transfer) interface software | |
| US7761841B1 (en) | Enhanced data loading for test management tool | |
| US9134975B1 (en) | Determining which computer programs are candidates to be recompiled after application of updates to a compiler | |
| CN107357721B (en) | Method and device for testing system | |
| US10846206B2 (en) | Adaptive software testing | |
| CN117009243A (en) | Chip performance automatic test method, device, computer equipment and storage medium | |
| CN116107892A (en) | Automatic test method, device, equipment and storage medium | |
| CN113448826A (en) | Software automation test system and method | |
| CN109062805A (en) | A kind of AEP memory firmware promotion and demotion test method, device, terminal and storage medium | |
| CN111949543A (en) | Testing method and device based on distributed platform, electronic equipment and storage medium | |
| CN112069082A (en) | Automatic testing method and system | |
| CN112612691A (en) | Method and system for realizing automatic test data management and control based on SVN, electronic device and storage medium | |
| CN109474822B (en) | Android television multi-language automatic testing method and device | |
| CN111629200A (en) | Method and device for rapidly detecting differential packet reliability and readable storage medium | |
| CN113835936A (en) | Universal test system and method for Andriod equipment | |
| CN115421749A (en) | Hard disk firmware refreshing method, system, device and medium based on Linux system | |
| CN114546749A (en) | Chip random test case regression method, device, equipment and readable medium | |
| CN112559346A (en) | Service testing method and device | |
| CN115437903A (en) | Interface test method, device, apparatus, storage medium, and program | |
| CN101976219A (en) | Method and system for debugging automatic testing script and agent device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |