CN103761189A - Test case management method and system - Google Patents
Test case management method and system Download PDFInfo
- Publication number
- CN103761189A CN103761189A CN201410053538.9A CN201410053538A CN103761189A CN 103761189 A CN103761189 A CN 103761189A CN 201410053538 A CN201410053538 A CN 201410053538A CN 103761189 A CN103761189 A CN 103761189A
- Authority
- CN
- China
- Prior art keywords
- test
- test case
- relevant information
- application
- case
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000012360 testing method Methods 0.000 title claims abstract description 333
- 238000007726 management method Methods 0.000 title abstract description 79
- 238000000034 method Methods 0.000 claims abstract description 21
- 238000013507 mapping Methods 0.000 claims description 30
- 238000010586 diagram Methods 0.000 description 14
- 230000003760 hair shine Effects 0.000 description 9
- 238000012986 modification Methods 0.000 description 9
- 230000004048 modification Effects 0.000 description 9
- 238000010998 test method Methods 0.000 description 5
- 238000013461 design Methods 0.000 description 4
- 238000012217 deletion Methods 0.000 description 2
- 230000037430 deletion Effects 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 238000009434 installation Methods 0.000 description 2
- 230000033764 rhythmic process Effects 0.000 description 2
- 238000012356 Product development Methods 0.000 description 1
- 238000009825 accumulation Methods 0.000 description 1
- 238000004458 analytical method Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000019771 cognition Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000013100 final test Methods 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 230000001788 irregular Effects 0.000 description 1
- 238000002955 isolation Methods 0.000 description 1
- 230000002688 persistence Effects 0.000 description 1
- 230000001105 regulatory effect Effects 0.000 description 1
Images
Landscapes
- Debugging And Monitoring (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a test case management method and system. On the basis of multiple layers of management tables arranged in an SQLite database, a user only needs to install a management application at a client end, the SQLite database is led into the management application by means of multiple link modes, the management tables in the SQLite database are selected and modified on the management application, test cases which a tester needs to use are read quickly and precisely, and accordingly the testing process is finished at the client end and a test report is generated. Files of the database are small in size while the test cases are called quickly and precisely, test case sharing between multiple client ends is achieved, test efficiency is greatly improved, labor cost of testing is reduced, programming of the test cases tends to be standard, and test results are more stable and reliable.
Description
Technical field
The present invention relates to computer automated testing field, more particularly, relate to a kind of testing case management and system.
Background technology
Software test is as the core link of guaranteeing reliability in software development process, and its quality to final products is most important.The agile development pattern that industry main flow adopts at present makes the rhythm of software development more and more faster, and traditional manual test mode does not catch up with the paces that version updating is regenerated gradually, and tester's cost is dropped into and remained high, and seriously drags slow product development rhythm.Under this background, automatization testing technique is developed as a kind of feasible solution, and the design of automatic test cases is the key point of this technology.The numerous and confused exploitation of current numerous software company automated test tool separately, build the automatic test system of oneself, but the well efficient robotization case management method of neither one, cause the reusability of test case very low, the automatic test cases that developer writes often can only be used voluntarily by developer, and others cannot reuse, cause same module automatic test cases between different developers repeat write.In addition, the accumulation of understanding to tested software of the design of test case and tester and experience is closely related, and the adding of new person in allegro software development process and development teams, make test case write and running quality uneven.
For improving testing efficiency, the automatic test cases database product of existing number money based on extend markup language (XML) comes out on the market at present, although solved to a certain extent the problems referred to above, but still there are some insurmountable inherent shortcomings in it: be first that XML itself is tree structure, be not easy to represent the information of two-dimensional data table; Secondly, its data volume is compared the database of the same type comparison redundancy that seems, especially, in the very dark situation of XML node level, the rapid data that the technical difficulty of its parsing has hindered this type database calls; And the most important, existing database is due to above-mentioned shortcoming, and the form of preserving mainly with this locality is stored in single client, between different clients, cannot share.
As a light-duty database, SQLite is a Relational DBMS of observing atomicity, consistance, isolation and persistence (ACID), its design object is Embedded, because it only has single data file, make it consume very little of space resources, but can support the huge large volume data file to TB rank; Have good cross-platform characteristic simultaneously, can support the operating system of multiple current main-stream, the design of its "Green" software guarantees that its operation does not rely on other software libraries.Due to its many advantages, the present invention has introduced a kind of testing case management and system based on SQLite database.
Summary of the invention
The technical problem to be solved in the present invention is, above-mentioned automatic test cases reusability for prior art is low, test case quality is uneven, and existing automatic test cases database product complex structure, the defect that the mode that only can call by this locality is used, a kind of testing case management and system are provided, by the multiple levels of management form based on built-in in SQLite database, user only need install a management application in client, utilize multiple on-link mode (OLM) that SQLite database is directed in management application, in management application, by the multiple levels of management form in SQLite database, select and revise, fast accurate searches the test case of the required use of tester, and then in client, complete test process and generate test report.
The technical solution adopted for the present invention to solve the technical problems is: a kind of testing case management is provided, comprises the following steps:
S1. set up the access links of management application and SQLite database;
S2. project entity table is carried out to first and select operation edit item relevant information, the option of Test Application entity list corresponding to operation is selected in acquisition and described first;
S3. described Test Application entity list is carried out to second and select to operate and edit Test Application relevant information, obtain the option of the test case entity list corresponding with described the second selection operation;
S4. described test case entity list is carried out to the 3rd and select to operate and edit test case relevant information, obtain with the described the 3rd and select test case corresponding to operation;
S5. move described test case and generate test report, described test report is stored in to described management application.
Preferably, step S3 comprises:
S31. described Test Application entity list is carried out to described second and select to operate and edit described Test Application relevant information;
S321. access the first test case relation table;
S322. according to the mapping relations of described the first test case relation table, obtain the option of the described test case entity list corresponding with described the second selection operation.
Preferably, step S3 comprises:
S31. described Test Application entity list is carried out to described second and select to operate and edit described Test Application relevant information;
S331. obtain the option of the scheme entity list corresponding with described the second selection operation;
S332. described scheme entity list is carried out to the 4th and select operation edit scenario relevant information;
S333. access the second test case relation table;
S334. according to the mapping relations of described the second test case relation table, obtain the option of the described test case entity list corresponding with described the 4th selection operation.
Preferably, described first selects operation, described second to select operation, the described the 3rd to select operation, the described the 4th to select operation, and the editor to described project relevant information, described Test Application relevant information, described test case relevant information and described scheme relevant information, all in management application, carry out.
Preferably, to the editor of described project relevant information, described Test Application relevant information, described test case relevant information and described scheme relevant information, be synchronously stored in described SQLite database.
Preferably, described method is further comprising the steps:
S6. test report described in described management applied analysis when meeting a certain logic Rule of judgment, is called specific follow-up test use-case from described SQLite database.
The present invention also provides a kind of test case management system, comprises following part:
Management application, for database table is carried out and selected editing operation, and preserves test report;
SQLite database, for preserving test case, described SQLite database comprises:
Project entity table, for preserving project relevant information;
Test Application entity list, for preserving Test Application relevant information;
Test case entity list, for preserving test case relevant information;
Scheme entity list, for preserving scheme relevant information;
The first test case relation table, for preserving the mapping relations between the option of described Test Application entity list and the option of test case entity list; And
The second test case relation table, for preserving the mapping relations between the option of described scheme entity list and the option of described test case entity list.
Preferably, described project relevant information, comprising: index of articles, project name, project are described in detail, establishment of item person, and Item version number;
Described Test Application relevant information, comprising: Test Application index, affiliated index of articles, instrument value, Test Application title, Test Application founder, and Test Application version number;
Described test case relevant information, comprising: test case index, measuring and calculating use-case sequence number, test case title, test case Run Script, test case are described in detail, test case grade;
Described scheme relevant information, comprising: scheme index, affiliated Test Application index, Scenario Name, scheme detailed description, scheme founder, version number.
Preferably, described SQLite database and multiple described management application that is installed on different clients realize data sharing, form multiple described described test case management systems based on SQLite database.
Preferably, described management application also comprises logic judgment module, for analyzing described test report, when meeting a certain logic Rule of judgment, calls specific follow-up test use-case from described SQLite database.
Implement testing case management of the present invention and system, there is following beneficial effect: when the quick precision regulating of realizing test case is used, guarantee that database file volume is small and exquisite, the test case realizing between multi-client is shared, greatly improved the efficiency of test job, reduced the human cost of test job, made writing of test case be tending towards standardization, its test result is more reliable and more stable.
Accompanying drawing explanation
Below in conjunction with drawings and Examples, the invention will be further described, in accompanying drawing:
Fig. 1 is the process flow diagram of testing case management the first embodiment of the present invention;
Fig. 2 is the functional block diagram that multiple client of the present invention is shared the first embodiment of a SQLite database;
Fig. 3 is the functional block diagram that multiple client of the present invention is shared the second embodiment of a SQLite database;
Fig. 4 is the process flow diagram of acquisition test case entity list options method of the present invention the first embodiment;
Fig. 5 is the process flow diagram of acquisition test case entity list options method of the present invention the second embodiment;
Fig. 6 is the process flow diagram of testing case management the second embodiment of the present invention;
Fig. 7 is the functional block diagram of test case management system the first embodiment of the present invention;
Fig. 8 is the functional block diagram of testing case management the second embodiment of the present invention.
Embodiment
For technical characterictic of the present invention, object and effect being had more clearly, understand, now contrast accompanying drawing and describe the specific embodiment of the present invention in detail.
Fig. 1 is the process flow diagram of testing case management the first embodiment of the present invention, and as shown in Figure 1, in the present embodiment, method of the present invention comprises the following steps:
S1. set up the access links of management application 10 and SQLite database 20;
S2. project entity table 21 is carried out to the first selection operation edit item relevant information, obtain the option of the Test Application entity list 22 corresponding with described the first selection operation;
S3. described Test Application entity list 22 is carried out to the second selection and operate and edit Test Application relevant information, obtain the option of the test case entity list 23 corresponding with described the second selection operation;
S4. described test case entity list 23 is carried out to the 3rd and select to operate and edit test case relevant information, obtain with the described the 3rd and select test case corresponding to operation;
S5. move described test case and generate test report, described test report is stored in to described management application.
In the step S1 of the present embodiment, management application 10 is arranged in client, described client comprises PC, small-sized workstation, server, smart mobile phone, panel computer and other forms of mobile terminal, user can carry out clicking operation to management application 10 in client, assigns the instruction of access SQLite database 20 to client.In the present invention, SQLite database 20 is preserved in a variety of forms, and except form and the management application of preserving with this locality are arranged in same client, the form that can also preserve by strange land provides more access path more easily for user.For example, this SQLite database 20 can be stored in the webserver by the mode of cloud network, and client is initiated access by wired or wireless mode to this webserver, thereby establishes the link relation with SQLite database 20.In addition, above-mentioned SQLite database 20 can also be recorded in mobile data memory unit, comprises floppy disk, CD, USB flash drive, portable hard drive, and storage card etc.Client and above-mentioned mobile data memory unit, by Interface realization data interaction, make client can call at any time management table and the test case in SQLite database 20, and carry out corresponding management table and test case modification and compilation operation.
Due to the conduct interviews operation of SQLite database of the form that can adopt strange land to preserve, therefore this SQLite database 20 can provide service for multiple clients, and multiple clients are set up respectively and the linking and complete call, modification and compilation operation of described SQLite database 20.As shown in Figure 2, for multiple clients of the present invention, share the first embodiment functional block diagram of a SQLite database 20.In the present embodiment, the first client 31, the second client 32, the 3rd client 33 have all independently been installed management application 10 separately, and the form that the single described SQLite database 20 that it is shared adopts strange land to preserve, be independent of each client, each client is implemented access by above-mentioned wired or wireless link and the mutual form of interface data to SQLite database 20.
In addition, can also be by realizing sharing of SQLite database 20 in conjunction with the local method of preserving with strange land of preserving.As shown in Figure 3, for multiple clients of the present invention, share the second embodiment functional block diagram of a SQLite database.In the present embodiment, SQLite database 20 adopts local mode of preserving to be installed on the second client 32, and the first client 31 and the 3rd client 33 are not all installed this SQLite database 20.Three clients are all provided with management application 10.Therefore,, for the second client 32, what 10 pairs of the management application of its installation realized with the SQLite database 20 that is mounted in this second client 32 is local IP access; And for the first client 31 and the 3rd client 33, what 10 pairs of the management application of its installation were installed on that the SQLite database 20 of the second client 32 realizes is strange land access, the first client 31 and the 3rd client 33 must first complete the data link with the second client 32 separately, thus access SQLite database 20.
With reference to figure 1, in the step S2 of testing case management the first embodiment, after described management application 10 is successfully set up with the access links of SQLite database 20, project entity table 21 in this SQLite database 20 will be shown in client man-machine interface, user carries out the first selection operation in management application 10, for selecting to test required project, described the first selection operation can be single choice operation, can be also final election operation.In test procedure, each project option shines upon one or more Test Application, these mapping relations are stored in the subordinate project index edge order in Test Application entity list 22, by editing described subordinate index of articles, user can edit item and Test Application between mapping relations, and add arbitrarily or delete items in project entity table 21.For single choice operation, management application 10 is by the one or more Test Application that record selected item and shine upon; And for final election operation, owing to likely there are the one or more Test Application of common mapping between projects, therefore management application 10 will be recorded the common factor of multiple Test Application that selected plural project shines upon.Test Application recorded above, will be shown in Test Application entity list 22 as option.
For project entity table 21, client, except carrying out the first selection operation, can also edit each project relevant information, and described relevant information comprises: index of articles, project name, project are described in detail, establishment of item person, and Item version number.User is by mark and modification to above-mentioned entry, and while conveniently using, energy fast accurate is located the project of required selection in the future.
In the step S3 of testing case management the first embodiment, specifically comprise two kinds of technical schemes, as shown in Figure 4, be acquisition test case entity list options method of the present invention the first embodiment, comprise following sub-step:
S31. described Test Application entity list 22 is carried out to described second and select to operate and edit described Test Application relevant information;
S321. access the first test case relation table 25;
S322. according to the mapping relations of described the first test case relation table 25, obtain the option of the described test case entity list 23 corresponding with described the second selection operation.
In sub-step S31, Test Application entity list 22 in SQLite database 20 will be shown in client man-machine interface, user carries out the second selection operation in management application 10, for selecting required Test Application, described second to select operation be on the shown some Test Application options basis of Test Application entity list 22, elect additional member or subtract choosing, its result can be single choice operation, can be also final election operation.In test procedure, each Test Application option shines upon one or more test cases, these mapping relations are stored in the first test case relation table 25, described the first test case relation table 25 shows the mapping relations that Test Application comprises some test cases, therefore in sub-step S321, management application 10, completing after the second selection operation, by accessing the first test case relation table 25, obtains the mapping relations that described Test Application 10 comprises some test cases.In addition, by editing described the first test case relation table 25, user can edit the mapping relations between Test Application and test case, and in Test Application entity list 22, adds arbitrarily or deletion Test Application.
For Test Application entity list 22, client is except carrying out the second selection operation, can also edit each Test Application relevant information, described relevant information comprises: Test Application index, affiliated index of articles, instrument (Instrumentation) value, Test Application title, Test Application founder, and Test Application version number.User is by mark and modification to above-mentioned entry, and while conveniently using, energy fast accurate is located the Test Application of required selection in the future.
In sub-step S322, for single choice operation, management application 10 is by the one or more test cases that record selected Test Application and shine upon; And for final election operation, owing to likely there are the one or more test cases of common mapping between each Test Application, therefore management application 10 will be recorded the common factor of multiple test cases that selected plural Test Application shines upon.Test case recorded above, will be shown in test case entity list 23 as option.
As shown in Figure 5, be acquisition test case entity list options method of the present invention the second embodiment, comprise following sub-step:
S31. described Test Application entity list 22 is carried out to described second and select to operate and edit described Test Application relevant information;
S331. obtain the option of the scheme entity list 24 corresponding with described the second selection operation;
S332. described scheme entity list 24 is carried out to the 4th and select operation edit scenario relevant information;
S333. access the second test case relation table 26;
S334. according to the mapping relations of described the second test case relation table 26, obtain the option of the described test case entity list 23 corresponding with described the 4th selection operation.
In sub-step S31, Test Application entity list 22 in SQLite database 20 will be shown in client man-machine interface, user carries out the second selection operation in management application 10, for selecting required Test Application, described second to select operation be on the shown some Test Application options basis of Test Application entity list 22, elect additional member or subtract choosing, its result can be single choice operation, can be also final election operation.In test procedure, each Test Application option shines upon one or more schemes, these mapping relations are stored in the subordinate Test Application index column in scheme entity list 24, by editing described subordinate Test Application index, user can edit the mapping relations between Test Application and scheme, and adds arbitrarily or delete items in Test Application entity list 22.
In sub-step S331, for single choice operation, management application 10 is by the one or more schemes that record selected Test Application and shine upon; And for final election operation, owing to likely there are the one or more schemes of common mapping between each Test Application, therefore management application 10 will be recorded the common factor of multiple schemes that selected plural Test Application shines upon.Scheme recorded above, will be shown in scheme entity list 24 as option.
In sub-step S332, Test Application entity list 22 in SQLite database 20 will be shown in client man-machine interface, user carries out the 4th and selects operation in management application 10, for selecting required scheme, the described the 4th to select operation be on the shown some scheme options basis of scheme entity list 24, elect additional member or subtract choosing, its result can be single choice operation, can be also final election operation.In test procedure, each scheme option shines upon one or more test cases, these mapping relations are stored in the second test case relation table 26, described the second test case relation table 26 shows the mapping relations that scheme comprises some test cases, therefore in sub-step S333, management application 10, completing after the 4th selection operation, by accessing the second test case relation table 26, obtains the mapping relations that described scheme comprises some test cases.In addition, by editing described the second test case relation table 26, user can edit scenario and test case between mapping relations, and add arbitrarily or deletion scheme in scheme entity list 24.
For scheme entity list 24, client selects operation except carrying out the 4th, can also edit each scheme relevant information, described relevant information comprises: scheme index, subordinate Test Application index, Scenario Name, scheme detailed description, scheme founder, version number.User is by mark and modification to above-mentioned entry, and while conveniently using, energy fast accurate is located the scheme of required selection in the future.
In sub-step S334, for single choice operation, management application 10 is by the one or more test cases that record selected Test Application and shine upon; And for final election operation, owing to likely there are the one or more test cases of common mapping between each Test Application, therefore management application 10 will be recorded the common factor of multiple test cases that selected plural scheme shines upon.Test case recorded above, will be shown in test case entity list 23 as option.
With reference to figure 1, in the step S4 of testing case management the first embodiment, test case entity list 23 in SQLite database 20 will be shown in client man-machine interface, user carries out the 3rd and selects operation in management application 10, for selecting required test case, described the 3rd selection operation is on the shown some test case options basis of test case entity list 23, elect additional member or subtract choosing, and its result can be single choice operation, can be also final election operation.In test procedure, each test case option shines upon a unique test case, and user can add arbitrarily or delete test case in test case entity list 23.
For test case entity list 23, client selects operation except carrying out the 3rd, can also edit each test case relevant information, described relevant information comprises: test case index, measuring and calculating use-case sequence number, test case title, test case Run Script, test case are described in detail, test case grade.User is by mark and modification to above-mentioned entry, and while conveniently using, energy fast accurate is located the test case of required selection in the future.
In step S5, by above-mentioned a series of selection operations, management application 10 filters out and reads some test cases in SQLite database, and according to test case grade and the selected a series of test cases of set script operation, the final test report that obtains, this test report is stored in management application 10 by the form of preserving with this locality, for tester in the future, it is further analyzed and checking.
It should be noted that, user modifies to the list data reading from SQLite database 20 in management application 10, comprise project relevant information, Test Application relevant information, the editor of test case relevant information and scheme relevant information, it is revised result and will synchronously be kept in the SQLite database 20 of management in client application 10 and local storage or strange land storage, facilitate the different testers of different clients test platform to repeat to call this amended database in the future, and without write voluntarily test case before testing at every turn, greatly improved testing efficiency.Simultaneously; this SQLite database 20 is also provided with protected mode; only allow the user with modification authority to modify to it, and other users without modification authority only can carry out Selection and call operation, guarantee that this database day-to-day operation can not cause database collapse because of illegal modifications.In addition, a series of Selection and calls and the retouching operation of user to data in SQLite database 20 all completes in management application 10, without the data structure of understanding SQLite database 10, its man-machine interface friendliness is easy-to-use, reduced tester's use difficulty, avoided because of professional knowledge and irregular the caused test result error of experience.
Fig. 6 is the process flow diagram of testing case management the second embodiment of the present invention, and as shown in Figure 1, in the present embodiment, method of the present invention comprises the following steps:
S1. set up the access links of management application 10 and SQLite database 20;
S2. project entity table 21 is carried out to the first selection operation edit item relevant information, obtain the option of the Test Application entity list 22 corresponding with described the first selection operation;
S3. described Test Application entity list 22 is carried out to the second selection and operate and edit Test Application relevant information, obtain the option of the test case entity list 23 corresponding with described the second selection operation;
S4. described test case entity list 23 is carried out to the 3rd and select to operate and edit test case relevant information, obtain with the described the 3rd and select test case corresponding to operation;
S5. move described test case and generate test report, described test report is stored in to described management application;
S6. described test report is analyzed in described management application 10, when meeting a certain logic Rule of judgment, calls specific follow-up test use-case from described SQLite database 20.
The difference of the present embodiment and the first embodiment of the present invention is, after generating test report and preserving, management application 10 will be carried out intelligent logical identification to this test report, when meeting a certain logic Rule of judgment, as the operation frequency of client CPU, operation time, working temperature, the parameters such as operation level exceed restriction threshold value, management application 10 of the present invention will be called specific follow-up test use-case automatically from SQLite database 20, with the further operation conditions to client, monitor, reduced the artificial cognition operation of tester's test report, further improved testing efficiency.
Fig. 7 is the functional block diagram of test case management system the first embodiment of the present invention, and as shown in Figure 7, in the present embodiment, system comprises:
Project entity table 21, for preserving project relevant information;
Test Application entity list 22, for preserving Test Application relevant information;
Test case entity list 23, for preserving test case relevant information;
The first test case relation table 25, for preserving the mapping relations between Test Application option and test case option; And
The second test case relation table 26, for preserving the mapping relations between scheme option and described test case option.
Fig. 8 is the functional block diagram of test case management system the second embodiment of the present invention, and as shown in Figure 8, in the present embodiment, system comprises:
Project entity table 21, for preserving project relevant information;
Test Application entity list 22, for preserving Test Application relevant information;
Test case entity list 23, for preserving test case relevant information;
The first test case relation table 25, for preserving the mapping relations between Test Application option and test case option; And
The second test case relation table 26, for preserving the mapping relations between scheme option and described test case option.
By reference to the accompanying drawings embodiments of the invention have been carried out to description above; but the present invention is not limited to above-mentioned embodiment; above-mentioned embodiment is only schematic; rather than restrictive; those of ordinary skill in the art is under enlightenment of the present invention; not departing from the scope situation that aim of the present invention and claim protect, also can make a lot of forms, within these all belong to protection of the present invention.
Claims (10)
1. a testing case management, is characterized in that, said method comprising the steps of:
S1. set up the access links of management application (10) and SQLite database (20);
S2. project entity table (21) is carried out to first and select operation edit item relevant information, the option of Test Application entity list (22) corresponding to operation is selected in acquisition and described first;
S3. described Test Application entity list (22) is carried out to second and select to operate and edit Test Application relevant information, obtain the option of the test case entity list (23) corresponding with described the second selection operation;
S4. described test case entity list (23) is carried out to the 3rd and select to operate and edit test case relevant information, obtain with the described the 3rd and select test case corresponding to operation;
S5. move described test case and generate test report, described test report is stored in to described management application (10).
2. testing case management according to claim 1, is characterized in that, described step S3 comprises:
S31. described Test Application entity list (22) is carried out to described second and select to operate and edit described Test Application relevant information;
S321. access the first test case relation table (25);
S322. according to the mapping relations of described the first test case relation table (25), obtain the option of the described test case entity list (23) corresponding with described the second selection operation.
3. testing case management according to claim 1, is characterized in that, described step S3 comprises:
S31. described Test Application entity list (22) is carried out to described second and select to operate and edit described Test Application relevant information;
S331. obtain the option of the scheme entity list (24) corresponding with described the second selection operation;
S332. described scheme entity list (24) is carried out to the 4th and select operation edit scenario relevant information;
S333. access the second test case relation table (26);
S334. according to the mapping relations of described the second test case relation table (26), obtain the option of the described test case entity list (23) corresponding with described the 4th selection operation.
4. according to the testing case management described in any one claim in claim 1-3, it is characterized in that, described first selects operation, described second to select operation, the described the 3rd to select operation, the described the 4th to select operation, and the editor to described project relevant information, described Test Application relevant information, described test case relevant information and described scheme relevant information, all in the upper execution of management application (10).
5. according to the testing case management described in any one claim in claim 1-3, it is characterized in that, to the editor of described project relevant information, described Test Application relevant information, described test case relevant information and described scheme relevant information, be synchronously stored in described SQLite database (20).
6. testing case management according to claim 1, is characterized in that, described method is further comprising the steps:
S6. described test report is analyzed in described management application (10), when meeting a certain logic Rule of judgment, calls specific follow-up test use-case from described SQLite database (20).
7. a test case management system, is characterized in that, described system comprises following part:
Management application (10), for database table is carried out and selected editing operation, and preserves test report;
SQLite database (20), for preserving test case, described SQLite database (20) comprising:
Project entity table (21), for preserving project relevant information;
Test Application entity list (22), for preserving Test Application relevant information;
Test case entity list (23), for preserving test case relevant information;
Scheme entity list (24), for preserving scheme relevant information;
The first test case relation table (25), for preserving the mapping relations between the option of described Test Application entity list (22) and the option of described test case entity list (23); And
The second test case relation table (26), for preserving the mapping relations between option and the option of described test case entity list (23) that described scheme selects entity list (24).
8. test case management system according to claim 7, is characterized in that, described project relevant information, comprising: index of articles, project name, project are described in detail, establishment of item person, and Item version number;
Described Test Application relevant information, comprising: Test Application index, subordinate index of articles, instrument value, Test Application title, Test Application founder, and Test Application version number;
Described test case relevant information, comprising: test case index, measuring and calculating use-case sequence number, test case title, test case Run Script, test case are described in detail, test case grade;
Described scheme relevant information, comprising: scheme index, subordinate Test Application index, Scenario Name, scheme detailed description, scheme founder, version number.
9. test case management system according to claim 7, it is characterized in that, a described SQLite database (20) is realized data sharing with multiple described management application (10) that are installed on different clients, forms multiple described test case management systems based on described SQLite database (20).
10. test case management system according to claim 7, it is characterized in that, described management application (10) also comprises logic judgment module (11), be used for analyzing described test report, when meeting a certain logic Rule of judgment, from described SQLite database (20), call specific follow-up test use-case.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410053538.9A CN103761189B (en) | 2014-02-17 | 2014-02-17 | Test case management method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410053538.9A CN103761189B (en) | 2014-02-17 | 2014-02-17 | Test case management method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103761189A true CN103761189A (en) | 2014-04-30 |
| CN103761189B CN103761189B (en) | 2017-02-01 |
Family
ID=50528431
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410053538.9A Expired - Fee Related CN103761189B (en) | 2014-02-17 | 2014-02-17 | Test case management method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103761189B (en) |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105320701A (en) * | 2014-08-04 | 2016-02-10 | 腾讯科技（深圳）有限公司 | Method and device for screening function point test implementing ways, and terminal |
| CN105573905A (en) * | 2014-10-11 | 2016-05-11 | 航天信息股份有限公司 | Software compatibility testing method and system |
| CN106021114A (en) * | 2016-06-02 | 2016-10-12 | 北京光年无限科技有限公司 | Automated testing method and system for intelligent robot |
| CN106547679A (en) * | 2015-09-17 | 2017-03-29 | 腾讯科技（深圳）有限公司 | The method and script management platform of script management |
| CN106991040A (en) * | 2016-07-20 | 2017-07-28 | 平安科技（深圳）有限公司 | Data-interface method of testing and device |
| CN107024916A (en) * | 2016-12-08 | 2017-08-08 | 中国北方发动机研究所(天津) | A kind of diesel engine electric control system test case parameter automatic patching system and method |
| CN108647148A (en) * | 2018-05-15 | 2018-10-12 | 深圳市同维通信技术有限公司 | Test method, device, equipment and the storage medium of mobile terminal application program |
| CN109446104A (en) * | 2018-11-16 | 2019-03-08 | 郑州云海信息技术有限公司 | A kind of testing case management and device based on big data |
| CN109992513A (en) * | 2019-03-29 | 2019-07-09 | 携程计算机技术（上海）有限公司 | The automatization test system and method for mobile terminal APP |
| CN110188034A (en) * | 2019-05-10 | 2019-08-30 | 广州高鸿信息科技有限公司 | A kind of method for testing software based on information sharing |
| CN111352824A (en) * | 2018-12-21 | 2020-06-30 | 北京金山云网络技术有限公司 | Test method and device and computer equipment |
| CN113778904A (en) * | 2021-11-10 | 2021-12-10 | 南京云柜网络科技有限公司 | Multi-terminal system testing method and device based on integrated test case |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1601483A (en) * | 2004-10-22 | 2005-03-30 | 中国工商银行 | Automation software testing system based on script explanatory tool |
| US20080222608A1 (en) * | 2001-10-05 | 2008-09-11 | Jason Michael Gartner | Method and system for managing software testing |
| CN201402459Y (en) * | 2008-12-25 | 2010-02-10 | 深圳市同洲电子股份有限公司 | Test case management device |
-
2014
- 2014-02-17 CN CN201410053538.9A patent/CN103761189B/en not_active Expired - Fee Related
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080222608A1 (en) * | 2001-10-05 | 2008-09-11 | Jason Michael Gartner | Method and system for managing software testing |
| CN1601483A (en) * | 2004-10-22 | 2005-03-30 | 中国工商银行 | Automation software testing system based on script explanatory tool |
| CN201402459Y (en) * | 2008-12-25 | 2010-02-10 | 深圳市同洲电子股份有限公司 | Test case management device |
Non-Patent Citations (1)
| Title |
|---|
| 张晓辉等: "引入 SQLite 数据库在 Rational Functional Tester 中轻松读取测试数据", 《HTTP://WWW.IBM.COM/DEVELOPERWORKS/CN/RATIONAL/R-CN-RFTSQLITE/》 * |
Cited By (18)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105320701A (en) * | 2014-08-04 | 2016-02-10 | 腾讯科技（深圳）有限公司 | Method and device for screening function point test implementing ways, and terminal |
| CN105320701B (en) * | 2014-08-04 | 2019-06-14 | 腾讯科技（深圳）有限公司 | Screening technique, device and the terminal of function point test implementation |
| CN105573905B (en) * | 2014-10-11 | 2019-03-05 | 航天信息股份有限公司 | Software compatibility test method and system |
| CN105573905A (en) * | 2014-10-11 | 2016-05-11 | 航天信息股份有限公司 | Software compatibility testing method and system |
| CN106547679A (en) * | 2015-09-17 | 2017-03-29 | 腾讯科技（深圳）有限公司 | The method and script management platform of script management |
| CN106021114A (en) * | 2016-06-02 | 2016-10-12 | 北京光年无限科技有限公司 | Automated testing method and system for intelligent robot |
| CN106021114B (en) * | 2016-06-02 | 2018-07-10 | 北京光年无限科技有限公司 | Towards the automated testing method and system of intelligent robot |
| CN106991040A (en) * | 2016-07-20 | 2017-07-28 | 平安科技（深圳）有限公司 | Data-interface method of testing and device |
| CN106991040B (en) * | 2016-07-20 | 2020-05-05 | 平安科技（深圳）有限公司 | Data interface testing method and device |
| CN107024916A (en) * | 2016-12-08 | 2017-08-08 | 中国北方发动机研究所(天津) | A kind of diesel engine electric control system test case parameter automatic patching system and method |
| CN108647148A (en) * | 2018-05-15 | 2018-10-12 | 深圳市同维通信技术有限公司 | Test method, device, equipment and the storage medium of mobile terminal application program |
| CN109446104A (en) * | 2018-11-16 | 2019-03-08 | 郑州云海信息技术有限公司 | A kind of testing case management and device based on big data |
| CN111352824A (en) * | 2018-12-21 | 2020-06-30 | 北京金山云网络技术有限公司 | Test method and device and computer equipment |
| CN111352824B (en) * | 2018-12-21 | 2023-07-07 | 北京金山云网络技术有限公司 | Test method and device and computer equipment |
| CN109992513A (en) * | 2019-03-29 | 2019-07-09 | 携程计算机技术（上海）有限公司 | The automatization test system and method for mobile terminal APP |
| CN110188034A (en) * | 2019-05-10 | 2019-08-30 | 广州高鸿信息科技有限公司 | A kind of method for testing software based on information sharing |
| CN113778904A (en) * | 2021-11-10 | 2021-12-10 | 南京云柜网络科技有限公司 | Multi-terminal system testing method and device based on integrated test case |
| CN113778904B (en) * | 2021-11-10 | 2022-03-01 | 南京云柜网络科技有限公司 | Multi-terminal system testing method and device based on integrated test case |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103761189B (en) | 2017-02-01 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103761189A (en) | Test case management method and system | |
| US10540335B2 (en) | Solution to generate a scriptset for an automated database migration | |
| CN105589874B (en) | Detection method, device and the ETL tool of ETL task dependence | |
| CN107958057B (en) | Code generation method and device for data migration in heterogeneous database | |
| CN109542791B (en) | A kind of program large-scale concurrent evaluating method based on container technique | |
| CN104133772B (en) | Automatic test data generation method | |
| CN103678110B (en) | The method and apparatus of amendment relevant information is provided | |
| CN108345532A (en) | A kind of automatic test cases generation method and device | |
| CN104063325A (en) | Automatic generation device and method for test cases of embedded software | |
| US9098630B2 (en) | Data selection | |
| CN107741903A (en) | Application compatibility method of testing, device, computer equipment and storage medium | |
| US10922216B1 (en) | Intelligent automation test workflow | |
| CN105808428A (en) | Method for performing unified performance test on distributed file system | |
| CN109614315B (en) | Automatic generation method and system of data synchronization test case | |
| CN103425584A (en) | Large-scale application regression testing information processing method based on Java bytecode | |
| CN110990274B (en) | Data processing method, device and system for generating test cases | |
| CN103744647A (en) | Java workflow development system and method based on workflow GPD | |
| CN102981882B (en) | Analytic method and device | |
| CN103606037A (en) | Query and configuration method of business data and device thereof | |
| CN112163017B (en) | Knowledge mining system and method | |
| CN106294128B (en) | A kind of automated testing method and device exporting report data | |
| CN103955429B (en) | Determine the method and device of regression test scope | |
| CN104899141A (en) | Test case selecting and expanding method facing network application system | |
| CN106802928B (en) | Power grid historical data management method and system | |
| US10146530B1 (en) | Simulating and evaluating code branch merge |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| CP01 | Change in the name or title of a patent holder | ||
| CP01 | Change in the name or title of a patent holder |
Address after: Changan town in Guangdong province Dongguan 523860 usha Beach Road No. 18 Patentee after: GUANGDONG OPPO MOBILE TELECOMMUNICATIONS Corp.,Ltd. Address before: Changan town in Guangdong province Dongguan 523860 usha Beach Road No. 18 Patentee before: GUANGDONG OPPO MOBILE TELECOMMUNICATIONS Corp.,Ltd. |
|
| CF01 | Termination of patent right due to non-payment of annual fee | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20170201 |