CN103761189B - Test case management method and system - Google Patents
Test case management method and system Download PDFInfo
- Publication number
- CN103761189B CN103761189B CN201410053538.9A CN201410053538A CN103761189B CN 103761189 B CN103761189 B CN 103761189B CN 201410053538 A CN201410053538 A CN 201410053538A CN 103761189 B CN103761189 B CN 103761189B
- Authority
- CN
- China
- Prior art keywords
- test
- test case
- application
- case
- management
- 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.)
- Expired - Fee Related
Links
- 238000012360 testing method Methods 0.000 title claims abstract description 331
- 238000007726 management method Methods 0.000 title claims abstract description 93
- 238000000034 method Methods 0.000 claims abstract description 14
- 238000013507 mapping Methods 0.000 claims description 26
- 230000008569 process Effects 0.000 abstract description 3
- 238000012986 modification Methods 0.000 description 11
- 230000004048 modification Effects 0.000 description 11
- 238000010586 diagram Methods 0.000 description 8
- 238000013461 design Methods 0.000 description 4
- 238000004321 preservation Methods 0.000 description 4
- 238000004458 analytical method Methods 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 230000003993 interaction Effects 0.000 description 2
- 230000033764 rhythmic process Effects 0.000 description 2
- 238000009825 accumulation Methods 0.000 description 1
- 239000002253 acid Substances 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 230000019771 cognition Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 230000002950 deficient Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000001788 irregular Effects 0.000 description 1
- 238000002955 isolation Methods 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
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, it relates to a kind of testing case management and
System.
Background technology
As the core link guaranteeing reliability in software development process, it extremely closes to the quality of final products for software test
Important.The agile development pattern that industry main flow is adopted at present makes the rhythm of software development more and more faster, and traditional craft is surveyed
Examination mode does not catch up with the paces of the version updating replacement gradually, and the cost input of tester is remained high, and seriously drags slow product
Product develop rhythm.In this context, automatization testing technique is developed as a kind of feasible solution, and automatization surveys
The design of example on probation is then the key point of this technology.Currently numerous software companys develop respective automatic test work one after another
Tool, builds the automatic test system of oneself, but neither one efficient automatization case management method well, lead to survey
The reusability of example on probation is very low, and the automatic test cases that developer writes often voluntarily can only be used by developer, and other
People cannot reuse, lead to same module automatic test cases between different developers repeat write.Additionally, test case
Design closely related to the understanding of tested software and the accumulation of experience with tester, and allegro software development
In journey and development teams new person addition so that test case write and running quality is uneven.
For improving testing efficiency, count the automatic test Ji Yu extensible markup language (xml) for the money at present on the market
Use-case data storehouse product comes out, although solving the problems referred to above to a certain extent, it is insurmountable solid that it yet suffers from some
Defective: be first xml be tree in itself, be not easy to represent two-dimensional data table information；Next, its data volume is compared same
Types of database seems and compares redundancy, in particular for xml node level very deep in the case of, its parsing technical difficulty hinder
The rapid data of this type data base calls；And the most important, how existing database due to disadvantages mentioned above, preserved with local
Form be stored in single client, cannot share between different clients.
As a Lightweight Database, sqlite is a in accordance with atomicity, concordance, isolation and persistency
(acid) Relational DBMS, its design object is Embedded, because it only has single data file, makes
Obtain its consumption space resources very little, but the huge big volume data file to tb rank can be supported；Have very well simultaneously
Cross-platform characteristic, the operating system of multiple current main-stream can be supported, the design of its "Green" software ensures that its operation is independent of it
His software library.Due to its many advantages, invention introduces a kind of testing case management based on sqlite data base and
System.
Content of the invention
The technical problem to be solved in the present invention is, for the above-mentioned automatic test cases reusability of prior art
Low, test case quality is uneven, and existing automatic test cases database product complex structure, is only capable of by local
The defect that the mode called uses, provides a kind of testing case management and system, by based on interior in sqlite data base
The multiple levels of management form put, user only need to install a management application in client, using multiple on-link mode (OLM)s by sqlite number
According to storehouse be directed into management application in, management application on by the multiple levels of management form in sqlite data base is carried out select with
Modification, fast accurate searches the required test case using of tester, and then completes test process on the client 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, including
Following steps:
S1. the access setting up management application with sqlite data base links；
S2. to project entity table execution first choice operation simultaneously edit item relevant information, obtain and described first choice
The option of operation corresponding test application entity table；
S3. the second selection operation edit test application related information is executed to described test application entity table, obtain with
The option of the corresponding test case entity table of described second selection operation；
S4. the 3rd selection operation edit test case relevant information is executed to described test case entity table, obtain with
The corresponding test case of described 3rd selection operation；
S5. run described test case and generate test report, described test report is stored in described management application.
Preferably, step s3 includes:
S31. described test application entity table is executed with described second selection operation and edits the related letter of described test application
Breath；
S321. access the first test case relation table；
S322. the mapping relations according to described first test case relation table, obtain corresponding with described second selection operation
Described test case entity table option.
Preferably, step s3 includes:
S31. described test application entity table is executed with described second selection operation and edits the related letter of described test application
Breath；
S331. obtain the option of scheme entity table corresponding with described second selection operation；
S332. the 4th selection operation edit scenario relevant information are executed to described scheme entity table；
S333. access the second test case relation table；
S334. the mapping relations according to described second test case relation table, obtain corresponding with described 4th selection operation
Described test case entity table option.
Preferably, described first choice operation, described second selection operation, described 3rd selection operation, described 4th choosing
Select operation, and to described item related information, described test application related information, described test case relevant information and institute
State the editor of scheme relevant information, all execute in management application.
Preferably, to described item related information, described test application related information, described test case relevant information with
And the editor of described scheme relevant information, synchronously it is stored in described sqlite data base.
Preferably, methods described further includes steps of
S6. test report described in described management applied analysis, when meeting a certain logic Rule of judgment, from described
Specific follow-up test use-case is called in sqlite data base.
The present invention also provides a kind of test case management system, including following part:
Management application, selects edit operation for executing to database table, and preserves test report；
Sqlite data base, for preserving test case, described sqlite data base includes:
Project entity table, for preserving item related information；
Test application entity table, for preserving test application related information；
Test case entity table, for preserving test case relevant information；
Scheme entity table, for preserving scheme relevant information；
First test case relation table, for preserving option and the test case entity table of described test application entity table
Mapping relations between option；And
Second test case relation table, for preserving the option of described scheme entity table and described test case entity table
Mapping relations between option.
Preferably, described item related information, comprising: index of articles, project name, project describe in detail, establishment of item
Person, and Item version number；
Described test application related information, comprising: test application references, affiliated index of articles, instrument value, test application name
Claim, founder is applied in test, 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
Use-case Run Script, test case describe in detail, test case grade；
Described scheme relevant information, comprising: scheme index, affiliated test application references, Scenario Name, scheme are retouched in detail
State, scheme founder, version number.
Preferably, described sqlite data base and multiple described management applications being installed on different clients realize data altogether
Enjoy, form multiple described described test case management systems based on sqlite data base.
Preferably, described management application also includes logic judgment module, for analyzing described test report, special when meeting one
When determining logical judgment condition, call specific follow-up test use-case from described sqlite data base.
Implement testing case management and the system of the present invention, have the advantages that and realizing test case
It is ensured that database file compact while quickly accurately calling, the test case realized between multi-client is shared, greatly
Improve the efficiency of test job, reduce the human cost of test job, make writing of test case tend to standardizing, its survey
Test result is more reliable and more stable.
Brief description
Below in conjunction with drawings and Examples, the invention will be further described, in accompanying drawing:
Fig. 1 is the flow chart of the testing case management first embodiment of the present invention；
Fig. 2 is the functional block diagram of the first embodiment of the shared sqlite data base of multiple client of the present invention；
Fig. 3 is the functional block diagram of the second embodiment of the shared sqlite data base of multiple client of the present invention；
Fig. 4 is the flow chart of the acquisition test case entity table options method first embodiment of the present invention；
Fig. 5 is the flow chart of the acquisition test case entity table options method second embodiment of the present invention；
Fig. 6 is the flow chart of the testing case management second embodiment of the present invention；
Fig. 7 is the functional block diagram of the test case management system first embodiment of the present invention；
Fig. 8 is the functional block diagram of the testing case management second embodiment of the present invention.
Specific embodiment
In order to be more clearly understood to the technical characteristic of the present invention, purpose and effect, now comparison accompanying drawing describes in detail
The specific embodiment of the present invention.
Fig. 1 is the flow chart of the testing case management first embodiment of the present invention, as shown in figure 1, in the present embodiment
In, the method for the present invention comprises the following steps:
S1. the access setting up management application 10 with sqlite data base 20 links；
S2. to project entity table 21 execution first choice operation simultaneously edit item relevant information, obtain and described first choosing
Select the option of operation corresponding test application entity table 22；
S3. described test application entity table 22 is executed by the second selection operation and edits test application related information, obtain
The option of test case entity table 23 corresponding with described second selection operation；
S4. the 3rd selection operation is executed to described test case entity table 23 and edit test case relevant information, obtain
Test case corresponding with described 3rd selection operation；
S5. run described test case and generate test report, described test report is stored in described management application.
In step s1 of the present embodiment, management application 10 is installed on the client, and described client includes PC,
The mobile terminal of small workstation, server, smart mobile phone, panel computer and other forms, user can be on the client
Clicking operation is carried out to management application 10, assigns the instruction accessing sqlite data base 20 to client.In the present invention,
Sqlite data base 20 preserves in a variety of forms, except being arranged on same client with management application in the form of local preservation
On, more more easily access path can also be provided the user by the form that strange land preserves.For example, this sqlite data base
20 can be stored in the webserver in the way of with cloud network, and client is by way of wired or wireless to this webserver
Initiate to access, thus establishing the link relation with sqlite data base 20.In addition, above-mentioned sqlite data base 20 can also remember
Record in mobile data memory unit, including floppy disk, CD, usb flash disk, portable hard drive, and storage card etc..Client with
Above-mentioned mobile data memory unit realizes data interaction by interface so that client can call sqlite data base 20 at any time
In management table and test case, and carry out the modification of corresponding management table and test case and compilation operation.
Due to can be with the operation of the sqlite data base that conducts interviews in the form of being preserved using strange land, therefore this sqlite data
Storehouse 20 can be that multiple client provides service, and multiple client is set up and the linking and complete of described sqlite data base 20 respectively
Become call, change and compilation operation.As shown in Fig. 2 sharing a sqlite data base's 20 for the multiple client of the present invention
First embodiment functional block diagram.In the present embodiment, the first client 31, the second client 32, the 3rd client 33 are each equal
Independently installed management application 10, and its single described sqlite data base 20 being shared is in the form of the preservation of strange land, solely
Stand on each client, each client is by the form of above-mentioned wired or wireless link and interface data interaction to sqlite data
Storehouse 20 implements to access.
In addition to this it is possible to realize being total to of sqlite data base 20 by combining the local method preserving with strange land that preserves
Enjoy.As shown in figure 3, the second embodiment functional block diagram of the shared sqlite data base of multiple client for the present invention.?
In the present embodiment, sqlite data base 20 is installed on the second client 32 by the way of local preservation, and the first client 31
With the 3rd client 33, this sqlite data base 20 is not all installed.Three clients are mounted on managing application 10.Therefore, for
Second client 32, the management application 10 that it is installed is to real with sqlite data base 20 institute being mounted in this second client 32
Existing is local IP access；And for the first client 31 and the 3rd client 33, management application 10 that it is installed is to being installed on
The be accomplished that strange land accesses of sqlite data base 20 of the second client 32, the first client 31 and the 3rd client 33 must
First must each complete the data link with the second client 32, thus accessing sqlite data base 20.
With reference to Fig. 1, in step s2 of testing case management first embodiment, described management application 10 and sqlite
After the access link of data base 20 is successfully established, the project entity table 21 in this sqlite data base 20 is shown in client people
Machine interface, user's execution first choice operation in management application 10, for selecting the required project of test, described first choice
Operation can be single choice operation or final election operation.In test program, the mapping of each project option is one or more
Test application, this mapping relations is stored in the subject item index column in test application entity table 22, by editor described from
Belong to index of articles, user can be with the mapping relations between edit item and test application and any in project entity table 21
Add or delete project.One or more tests that record selected item is mapped by single choice operation, management application 10
Application；And for final election operation, due to being possible between projects that co-map one or more test application occurs, therefore manage
Ought to be with the common factor of the 10 multiple test applications being mapped plural items selected by record.Test application recorded above, will
Alternatively it is shown in test application entity table 22.
For project entity table 21, client, can also be to each item related information in addition to carrying out first choice operation
Enter edlin, described relevant information includes: index of articles, project name, project describe in detail, item creator, and project
Version number.User by the mark of above-mentioned entry and modification, convenient can fast accurate positioning be required selects when using in the future
Project.
In step s3 of testing case management first embodiment, specifically include two kinds of technical schemes, as Fig. 4 institute
Show, be the acquisition test case entity table options method first embodiment of the present invention, including following sub-step:
S31. described test application entity table 22 is executed with described second selection operation and edits described test application correlation
Information；
S321. access the first test case relation table 25；
S322. the mapping relations according to described first test case relation table 25, obtain and described second selection operation pair
The option of the described test case entity table 23 answered.
In sub-step s31, the test application entity table 22 in sqlite data base 20 is shown in the man-machine boundary of client
Face, user executes the second selection operation in management application 10, for selecting required test application, described second selection operation
It is to be elected additional member on the basis of testing some test application options shown by application entity table 22 or subtracted choosing, its result can be
Single choice operation or final election operation.In test program, each one or more test of test application option mapping is used
Example, this mapping relations is stored in the first test case relation table 25, and described first test case relation table 25 shows that test should
With comprising the mapping relations of some test cases, therefore in sub-step s321, management application 10 completes the second selection operation
Afterwards, by accessing the first test case relation table 25, the mapping relations that described test application 10 comprises some test cases are obtained.
Additionally, by editing described first test case relation table 25, user can edit reflecting between test application and test case
Penetrate relation, and arbitrarily add in test application entity table 22 or delete test application.
For test application entity table 22, client, can also be to each test application in addition to carrying out the second selection operation
Relevant information enters edlin, and described relevant information includes: test application references, affiliated index of articles, instrument
(instrumentation) value, test Apply Names, test application founder, and test application version number.It is right that user passes through
The mark of above-mentioned entry and modification, can apply during convenient use in the future in the required test selecting of fast accurate positioning.
In sub-step s322, for single choice operation, management application 10 is by mapped for selected for record test application one
Or multiple test case；And for final election operation, one or more due to being possible to co-map occurs between each test application
The common factor of multiple test cases that plural number test application selected by record is mapped by test case, therefore management application 10.Above-mentioned
The test case being recorded, will alternatively be shown in test case entity table 23.
As shown in figure 5, being the acquisition test case entity table options method second embodiment of the present invention, including following sub-step
Rapid:
S31. described test application entity table 22 is executed with described second selection operation and edits described test application correlation
Information；
S331. obtain the option of scheme entity table 24 corresponding with described second selection operation；
S332. the 4th selection operation edit scenario relevant information are executed to described scheme entity table 24；
S333. access the second test case relation table 26；
S334. the mapping relations according to described second test case relation table 26, obtain and described 4th selection operation pair
The option of the described test case entity table 23 answered.
In sub-step s31, the test application entity table 22 in sqlite data base 20 is shown in the man-machine boundary of client
Face, user executes the second selection operation in management application 10, for selecting required test application, described second selection operation
It is to be elected additional member on the basis of testing some test application options shown by application entity table 22 or subtracted choosing, its result can be
Single choice operation or final election operation.In test program, each test application option maps one or more schemes,
This mapping relations is stored in the subordinate test application references column in scheme entity table 24, by editing described subordinate test application
Index, user can edit the mapping relations between test application and scheme, and arbitrarily adds in test application entity table 22
Plus or delete project.
In sub-step s331, for single choice operation, management application 10 is by mapped for selected for record test application one
Or multiple scheme；And for final election operation, it is possible to that the one or more scheme of co-map occurs due between each test application,
Therefore plural number selected by record is tested the common factor of multiple schemes that application is mapped by management application 10.Scheme recorded above,
To alternatively be shown in scheme entity table 24.
In sub-step s332, the test application entity table 22 in sqlite data base 20 is shown in the man-machine boundary of client
Face, user executes the 4th selection operation in management application 10, for selecting required scheme, described 4th selection operation be
Elected additional member on the basis of some pattern options shown by scheme entity table 24 or subtracted choosing, its result can be single choice operation,
It can be final election operation.In test program, each pattern options maps one or more test cases, and this mapping relations is deposited
It is stored in the second test case relation table 26, described second test case relation table 26 shows that scheme comprises some test cases
Mapping relations, therefore in sub-step s333, management application 10, after completing the 4th selection operation, is used by accessing the second test
Example relation table 26, obtains the mapping relations that described scheme comprises some test cases.Additionally, being used by editing described second test
Example relation table 26, user can be with the mapping relations between edit scenario and test case and any in scheme entity table 24
Add or delete scheme.
For scheme entity table 24, client, can also be to each scheme relevant information in addition to carrying out the 4th selection operation
Enter edlin, described relevant information includes: scheme index, subordinate test application references, Scenario Name, scheme describe in detail, side
Case founder, version number.User by the mark of above-mentioned entry and modification, convenient when using in the future can fast accurate fixed
The required scheme selecting in position.
In sub-step s334, for single choice operation, management application 10 is by mapped for selected for record test application one
Or multiple test case；And for final election operation, one or more due to being possible to co-map occurs between each test application
The common factor of multiple test cases that scheme plural selected by record is mapped by test case, therefore management application 10.Above-mentioned remembered
The test case of record, will alternatively be shown in test case entity table 23.
With reference to Fig. 1, the test in step s4 of testing case management first embodiment, in sqlite data base 20
Use-case entity table 23 is shown in client man machine interface, and user executes the 3rd selection operation in management application 10, for selecting
Select required test case, described 3rd selection operation is some test case options shown by test case entity table 23
On the basis of elected additional member or subtracted choosing, its result can be single choice operation or final election operation.In test program, each
Individual test case option maps only one test case, and user can arbitrarily add in test case entity table 23 or delete
Except test case.
For test case entity table 23, client, can also be to each test case in addition to carrying out the 3rd selection operation
Relevant information enters edlin, and described relevant information includes: test case index, measuring and calculating use-case sequence number, test case title, test
Use-case Run Script, test case describe in detail, test case grade.User is by the mark of above-mentioned entry and modification, side
Can the required test case selecting of fast accurate positioning when just using in the future.
In step s5, by a series of above-mentioned selection operations, management application 10 filters out simultaneously in sqlite data base
Read some test cases, and run a series of selected test cases according to test case grade and set script,
Final obtain test report, this test report will be stored in management application 10 in the form of local preservation, for tester in the future
Member analyzes further to it and verifies.
It should be strongly noted that user applies on 10 to the form number being read from sqlite data base 20 in management
According to modifying, including item related information, test application related information, test case relevant information and scheme relevant information
Editor, its modification result is by the synchronous management application 10 preserving on the client and locally stored or strange land storage
In sqlite data base 20, facilitate the different testers of different clients test platform to repeat to call this amended number in the future
According to storehouse, and before need not being tested every time, voluntarily write test case, greatly improve testing efficiency.Meanwhile, this sqlite number
It is also provided with protected mode according to storehouse 20, only allow the user with modification authority that it is modified, and other do not have modification
The user of authority is only capable of carrying out Selection and call operation it is ensured that this data base's day-to-day operation will not lead to data base because of illegal modifications
Collapse.Additionally, user all applies in management to a series of Selection and calls of data in sqlite data base 20 and modification operation
Complete on 10, the data structure of sqlite data base 10 need not be understood, its man machine interface is friendly easy-to-use, reduces tester's
Using difficulty, it is to avoid because of Professional knowledge and experience irregular caused test result error.
Fig. 6 is the flow chart of the testing case management second embodiment of the present invention, as shown in figure 1, in the present embodiment
In, the method for the present invention comprises the following steps:
S1. the access setting up management application 10 with sqlite data base 20 links；
S2. to project entity table 21 execution first choice operation simultaneously edit item relevant information, obtain and described first choosing
Select the option of operation corresponding test application entity table 22；
S3. described test application entity table 22 is executed by the second selection operation and edits test application related information, obtain
The option of test case entity table 23 corresponding with described second selection operation；
S4. the 3rd selection operation is executed to described test case entity table 23 and edit test case relevant information, obtain
Test case corresponding with described 3rd selection operation；
S5. run described test case and generate test report, described test report is stored in described management application；
S6. the described management application 10 described test report of analysis, when meeting a certain logic Rule of judgment, from described
Specific follow-up test use-case is called in sqlite data base 20.
The present embodiment is with the difference of the first embodiment of the present invention, and after generating test report and preserving, management should
Intelligent logical identification will be carried out with 10 to this test report, when meeting a certain logic Rule of judgment, as the fortune of client cpu
Calculate the parameters such as frequency, operation time, operating temperature, operation level and exceed restriction threshold value, the management application 10 of the present invention will automatically
Specific follow-up test use-case is called from sqlite data base 20, to be monitored to the operation conditions of client further,
Decrease the artificial cognition operation of the test report of tester, further increase testing efficiency.
Fig. 7 is the functional block diagram of the test case management system first embodiment of the present invention, as shown in fig. 7, in this enforcement
In example, system includes:
Management application 10, selects edit operation for executing to database table, and preserves test report；
Sqlite data base 20, for preserving test case, described sqlite data base includes:
Project entity table 21, for preserving item related information；
Test application entity table 22, for preserving test application related information；
Test case entity table 23, for preserving test case relevant information；
Scheme entity table 24, for preserving scheme relevant information；
First test case relation table 25, closes for preserving the mapping between test application option and test case option
System；And
Second test case relation table 26, closes for preserving the mapping between pattern options and described test case option
System.
Fig. 8 is the functional block diagram of the test case management system second embodiment of the present invention, as shown in figure 8, in this enforcement
In example, system includes:
Management application 10, selects edit operation for executing to database table, and preserves test report, described management
Application 10 includes:
Logic judgment module 11, for analyzing described test report, when meeting a certain logic Rule of judgment, from described
Specific follow-up test use-case is called in sqlite data base 20；
Sqlite data base 20, for preserving test case, described sqlite data base 20 includes:
Project entity table 21, for preserving item related information；
Test application entity table 22, for preserving test application related information；
Test case entity table 23, for preserving test case relevant information；
Scheme entity table 24, for preserving scheme relevant information；
First test case relation table 25, closes for preserving the mapping between test application option and test case option
System；And
Second test case relation table 26, closes for preserving the mapping between pattern options and described test case option
System.
Above in conjunction with accompanying drawing embodiments of the invention are performed with description, but the invention is not limited in above-mentioned concrete
Embodiment, above-mentioned specific embodiment is only schematically, rather than restricted, those of ordinary skill in the art
Under the enlightenment of the present invention, in the case of without departing from present inventive concept and scope of the claimed protection, also can make a lot
Form, these belong within the protection of the present invention.
Claims (7)
1. a kind of testing case management is it is characterised in that the method comprising the steps of:
S1. set up management application (10) to link with the access of sqlite data base (20)；
S2. to project entity table (21) execution first choice operation simultaneously edit item relevant information, obtain and described first choice
The option of operation corresponding test application entity table (22)；
S31. described test application entity table (22) is executed by the second selection operation and edits test application related information；
S331. obtain the option of scheme entity table (24) corresponding with described second selection operation；
S332. the 4th selection operation edit scenario relevant information are executed to described scheme entity table (24)；
S333. access the second test case relation table (26)；
S334. the mapping relations according to described second test case relation table (26), obtain corresponding with described 4th selection operation
Test case entity table (23) option；
S4. the 3rd selection operation edit test case relevant information is executed to described test case entity table (23), obtain with
The corresponding test case of described 3rd selection operation；
S5. run described test case and generate test report, described test report is stored in described management application (10)；
Wherein, described item related information includes: index of articles, project name, project describe in detail, item creator, and
Item version number；Described test application related information includes: test application references, subject item index, instrument value, test application
Title, test application founder, and test application version number；Described test case relevant information includes: test case index,
Test case sequence number, test case title, test case Run Script, test case describe in detail, test case grade；Described
Scheme relevant information includes: scheme index, subordinate test application references, Scenario Name, scheme detailed description, scheme founder,
Version number.
2. testing case management according to claim 1 it is characterised in that the operation of described first choice, described the
Two selection operations, described 3rd selection operation, described 4th selection operation, and to described item related information, described test
The editor of application related information, described test case relevant information and described scheme relevant information, all in management application (10)
Upper execution.
3. testing case management according to claim 1 is it is characterised in that to described item related information, described
The editor of test application related information, described test case relevant information and described scheme relevant information, is synchronously stored in institute
State sqlite data base (20).
4. testing case management according to claim 1 is it is characterised in that methods described further includes following step
Rapid:
S6. described management application (10) analyzes described test report, when meeting a certain logic Rule of judgment, from described
Specific follow-up test use-case is called in sqlite data base (20).
5. a kind of test case management system based on the management method described in claim 1 is it is characterised in that described system bag
Include following part:
Management application (10), selects edit operation for executing to database table, and preserves test report；
Sqlite data base (20), for preserving test case, described sqlite data base (20) includes:
Project entity table (21), for preserving item related information；
Test application entity table (22), for preserving test application related information；Test case entity table (23), surveys for preserving
Example relevant information on probation；
Scheme entity table (24), for preserving scheme relevant information；
First test case relation table (25), for preserving the option of described test application entity table (22) and described test case
Mapping relations between the option of entity table (23)；And
Second test case relation table (26), for preserving the option of described scheme entity table (24) and described test case entity
Mapping relations between the option of table (23)；
Wherein, described item related information includes: index of articles, project name, project describe in detail, item creator, and
Item version number；
Described test application related information, comprising: test application references, subject item index, instrument value, test Apply Names,
Test application founder, and test application version number；
Described test case relevant information, comprising: test case index, test case sequence number, test case title, test case
Run Script, test case describe in detail, test case grade；
Described scheme relevant information, comprising: scheme index, subordinate test application references, Scenario Name, scheme describe in detail, side
Case founder, version number.
6. test case management system according to claim 5 is it is characterised in that a described sqlite data base (20)
Realize data sharing with multiple described management application (10) being installed on different clients, composition multiple based on described sqlite number
Described test case management system according to storehouse (20).
7. test case management system according to claim 5 is it is characterised in that described management application (10) also includes patrolling
Collect judge module (11), for analyzing described test report, when meeting a certain logic Rule of judgment, from described sqlite number
Call specific follow-up test use-case according in storehouse (20).
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 CN103761189A (en) | 2014-04-30 |
| CN103761189B true 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) |
Families Citing this family (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
| CN106547679B (en) * | 2015-09-17 | 2021-03-23 | 腾讯科技（深圳）有限公司 | Script management method and script management platform |
| CN106021114B (en) * | 2016-06-02 | 2018-07-10 | 北京光年无限科技有限公司 | Towards the automated testing method and system of intelligent robot |
| 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 |
| 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 |
| CN113778904B (en) * | 2021-11-10 | 2022-03-01 | 南京云柜网络科技有限公司 | Multi-terminal system testing method and device based on integrated test case |
Citations (2)
| 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 |
| CN201402459Y (en) * | 2008-12-25 | 2010-02-10 | 深圳市同洲电子股份有限公司 | Test case management device |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CA2358563A1 (en) * | 2001-10-05 | 2003-04-05 | Ibm Canada Limited - Ibm Canada Limitee | Method and system for managing software testing |
-
2014
- 2014-02-17 CN CN201410053538.9A patent/CN103761189B/en not_active Expired - Fee Related
Patent Citations (2)
| 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 |
| 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/》;20110729;第1-8页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103761189A (en) | 2014-04-30 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103761189B (en) | Test case management method and system | |
| CN109542791B (en) | A kind of program large-scale concurrent evaluating method based on container technique | |
| CN107844424B (en) | Model-based testing system and method | |
| CN108874919B (en) | Automatic checking method for planned land, electronic equipment, storage medium and system | |
| CN109783388B (en) | UI (user interface) automatic testing method and device and electronic equipment | |
| EP2778929B1 (en) | Test script generation system | |
| US9436734B2 (en) | Relative performance prediction of a replacement database management system (DBMS) | |
| CN104077401B (en) | Data migration device and data migration method for database | |
| US20140081613A1 (en) | Method, system and computer readable medium for scenario mangement of dynamic, three-dimensional geological interpretation and modeling | |
| CN107423214A (en) | Software regression testing use-case acquisition methods, device and storage medium and electronic equipment | |
| EP2572294B1 (en) | System and method for sql performance assurance services | |
| US9098630B2 (en) | Data selection | |
| CN108345532A (en) | A kind of automatic test cases generation method and device | |
| CN106708818A (en) | Pressure testing method and system | |
| CN104423961B (en) | A kind of method and system for generating test script | |
| CN107741903A (en) | Application compatibility method of testing, device, computer equipment and storage medium | |
| CN108021505A (en) | Data loading method, device and computer equipment | |
| Mellado et al. | Software product measurement and analysis in a continuous integration environment | |
| CN114490375B (en) | Performance test method, device, equipment and storage medium of application program | |
| CN107220171A (en) | The method of testing and device of a kind of virtual machine | |
| CN108540351A (en) | The automated testing method of distributed big data service | |
| CN111258881B (en) | Intelligent test system for workflow test | |
| CN105868956A (en) | Data processing method and device | |
| CN108363660A (en) | A kind of method of generating test program and device | |
| CN108763081A (en) | A kind of data library test method and its device, computer readable storage medium |
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 |
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. |
|
| CP01 | Change in the name or title of a patent holder | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20170201 |
|
| CF01 | Termination of patent right due to non-payment of annual fee |