CN111258903A - Test case file conversion method, device and storage medium - Google Patents

Abstract

The invention provides a test case file conversion method, which includes: respectively determining the content of the Xmind test case file and the format of the Excel test case file template; by parsing the format of the Excel test case file template to be generated and Parse the data of each test case in the Xmind test case file to be converted, obtain the cell location where the pre-defined key element names in the Excel test case file template to be generated are located, and make the data in the test case One-to-one correspondence with the names of the key elements; the data in each parsed test case is written into the parsed Excel test case file template in turn according to the corresponding key element name, where the name of the key element in the same row is located. The column corresponding to the cell position to generate the Excel test case file. The invention can directly convert the complete Xmind version test case into the Excel version test case, which saves the cost and improves the efficiency.

Description

Test case file conversion method, device and storage medium

technical field

The invention relates to the technical field of document data processing, and more particularly, to a method, a device and a storage medium for converting an Xmind test case file into an Excel test case file.

Background technique

Excel is an important part of Microsoft Office suite software. It can process various data, analyze statistics and assist decision-making operations, and is widely used in many fields such as management, statistical finance, and finance. Excel can meet most of the requirements for writing test cases, but if the business system to be tested is relatively large and each module has a relatively close business connection, the idea of using Excel to write test cases is not so clear, and it is not easy to review. Using the mind-directed map in Xmind can sort out test cases well, divide test cases, and establish certain business connections between test cases.

Xmind is a very practical business mind mapping software. It applies the world's most advanced Eclipse RCP software architecture and strives to create an easy-to-use and efficient visual thinking software, emphasizing the software's scalability, cross-platform, stability and performance. Use advanced software technology to help users truly increase productivity. Writing test cases with Xmind is more flexible, clearer and easier to revise.

However, because most test case management systems in the industry (such as Shenbing system and Zen Tao system) do not support the import of Xmind files, but only support the import of Excel files, testers write test case outlines through Xmind, and then manually according to the outline Rewrite the test case for the Excel version. This hinders the popularization and use of Xmind in writing test cases, and the advantages of Xmind in writing test cases cannot be fully utilized, which increases the labor cost of testers and reduces work efficiency.

SUMMARY OF THE INVENTION

In view of the above problems, the purpose of the present invention is to provide a test case file conversion method, device and storage medium, which realizes that the complete Xmind version test case can be converted into an Excel version test case, so that Xmind has the advantage in writing test cases. It can be fully utilized and can be converted into an Excel version that can be input into the test case management system, which provides convenience for test case writers.

According to an aspect of the present invention, a test case file conversion method is provided, the method comprising the following steps:

S110: According to the Xmind test case file to be converted and the Excel test case file template to be generated, respectively determine the content of the Xmind test case file and the format of the Excel test case file template;

S120: By parsing the format of the Excel test case file template to be generated and parsing the data of each test case in the Xmind test case file to be converted, obtain the pre-defined Excel test case file template to be generated The cell position where the name of the key element is located, and the data in the test case is in one-to-one correspondence with the name of the key element; wherein, the name of the key element is used to describe the test item in the Excel test case file template The name;

S130: Write the parsed data in each test case into the column corresponding to the cell position where the name of the key element in the same row in the parsed Excel test case file template is in turn according to the name of the corresponding key element. Generate Excel test case files.

Further, before S110, it also includes: respectively reading the Xmind test case file to be converted and the Excel test case file template to be generated, wherein the Xmind test case file to be converted and the Excel test case file to be generated How use case file templates are read is defined in command line format.

Further, the command line format is the linux command line format, and the first parameter name and the second parameter name are defined; wherein, the first parameter name is used to mark the Xmind test case file that needs to be converted, and the second parameter name Template used to mark the Excel test case file that needs to be generated.

In S120, use the extension package xlwt to parse the Excel test case file template to be generated, obtain the format specification of the Excel test case file template to be generated, and obtain the cell where the predefined key element name is located Location.

In S120, the process of parsing the data of each test case in the Xmind test case file to be converted includes: sorting the key element names in alphabetical order according to the column positions of the cell positions where the key element names are located to form key element names group; and the content of the Xmind test case file to be converted is parsed and converted into the content of the JSON data format; wherein, the data of each described test case in the content of the JSON data format adopts the self-defined JSON data processing successively Methods are converted to key feature data sets.

Further, the process of converting into a key element data group by using a self-defined JSON data processing method includes: extracting the value of the content in the JSON data format as a result set, performing parent-child association on the result set, and sequentially extracting parent nodes The value and the sub-node values at all levels are regarded as data corresponding to the key element names in the key element name group one-to-one, forming a key element data group.

In S130, the data in the key element data group is sequentially written into the column corresponding to the key element name in the Excel test case file template, and the data in each key element data group is written in the same row corresponding to the key element name column to generate the final Excel version test case file.

According to another aspect of the present invention, a test case file conversion system is provided, comprising:

The file content and format determination unit is used to respectively determine the content of the Xmind test case file and the format of the Excel test case file template according to the Xmind test case file to be converted and the Excel test case file template to be generated;

a file template parsing unit, configured to parse the format of the Excel test case file template to be generated, and obtain the cell position where the pre-defined key element names in the Excel test case file template to be generated are located;

a file content parsing unit, configured to parse the data of each test case in the Xmind test case file to be converted, so that the data in the test case corresponds to the name of the key element one by one;

The test case writing unit is used to sequentially write the parsed data in each of the test cases into the key elements in the same row in the parsed Excel test case file template according to the corresponding key element names. The column corresponding to the cell position where the element name is located to generate an Excel test case file.

According to another aspect of the present invention, an electronic device is provided, comprising a memory and a processor, wherein a computer program is stored in the memory, and when the computer program is executed by the processor, the steps of the above test case file conversion method are implemented.

According to another aspect of the present invention, a computer-readable storage medium is provided, wherein a test case file conversion program is stored in the computer-readable storage medium, and when the test case file conversion program is executed by a processor, the above-mentioned Steps of the test case file conversion method.

The present invention has the following beneficial effects: using the above-mentioned method for converting Xmind test case files to Excel test case files according to the present invention, Xmind test cases can be automatically converted into Excel form, and it is not necessary to repeatedly write Xmind test case outlines and complete Excel version test case files , saving time and cost and significantly improving efficiency. Testers can also enjoy the function of converting Xmind test cases to Excel test cases without spending a high cost to purchase the Xmind pro version. The converted Excel test cases can be adapted to all test case management systems.

To the achievement of the above and related objects, one or more aspects of the invention comprise the features hereinafter described in detail and particularly pointed out in the claims. The following description and accompanying drawings illustrate certain exemplary aspects of the invention in detail. These aspects are indicative, however, of but a few of the various ways in which the principles of the invention may be employed. Furthermore, the present invention is intended to include all such aspects and their equivalents.

Description of drawings

Other objects and results of the present invention will be more apparent and readily understood by reference to the following description taken in conjunction with the accompanying drawings and the contents of the claims, and as the present invention is more fully understood. In the attached image:

1 is a flowchart of a test case file conversion method according to Embodiment 1 of the present invention;

Fig. 2 is the Xmind test case file to be converted in the embodiment of the present invention 1;

Fig. 3 is the Excel test case file template to be generated in the embodiment of the present invention 1;

Fig. 4 is the Excel test case file after conversion in the embodiment of the present invention 1;

5 is a schematic diagram of a logical structure of a test case file conversion system according to Embodiment 2 of the present invention;

FIG. 6 is a schematic diagram of a logical structure of an electronic device according to Embodiment 3 of the present invention.

The same reference numbers indicate similar or corresponding features or functions throughout the drawings.

Detailed ways

In the following description, for the purposes of explanation, numerous specific details are set forth in order to provide a thorough understanding of one or more embodiments. It will be apparent, however, that the embodiments may be practiced without these specific details. In other instances, well-known structures and devices are shown in block diagram form in order to facilitate describing one or more embodiments

Glossary

Test case: A test case is a scientific organization of the behavior of software testing, with the purpose of transforming the behavior of software testing into a manageable mode; at the same time, a test case is also one of the methods to quantify testing. First, different types of software have different test cases. Usually a test case file contains multiple test cases.

Extension package xlwt: An extension tool for writing Excel files in the Python language.

JSON (JavaScript Object Notation, JS Object Notation) is a lightweight data exchange format. It is based on a subset of ECMAScript (the js specification developed by the European Computer Association), and uses a text format that is completely independent of the programming language to store and represent data. Concise and clear hierarchy makes JSON an ideal data exchange language. The data structure is a key-value pair structure of {key1:value1, key2:value2, ...keyN:valueN}. In object-oriented languages, the key is the property of the object, and the value is the corresponding value.

Linux is a set of Unix-like operating systems that are free to use and spread freely. It is a multi-user, multi-tasking, multi-threading and multi-CPU operating system based on POSIX and UNIX.

The specific embodiments of the present invention will be described in detail below with reference to the accompanying drawings.

Example 1

FIG. 1 is a flowchart of a test case file conversion method according to Embodiment 1 of the present invention.

As shown in Figure 1, the test case file conversion method according to Embodiment 1 of the present invention, applied to an electronic device, is used to convert the Xmind test case file into an Excel test case file, including the following steps:

S110: According to the Xmind test case file to be converted and the Excel test case file template to be generated, respectively determine the content of the Xmind test case file and the format of the Excel test case file template.

In step S110, use the PYTHON language to parse the Xmind test case file to be converted to obtain its content, and use the Java language to parse the Excel test case file template to be generated to obtain its format.

S120: By parsing the format of the Excel test case file template to be generated and parsing the data of each test case in the Xmind test case file to be converted, obtain the pre-defined Excel test case file template to be generated The cell position where the name of the key element is located, and the data in the test case is in one-to-one correspondence with the name of the key element; wherein, the name of the key element is used to describe the test item in the Excel test case file template name; the number of key elements depends on the actual situation of the test case.

In step S120, the expansion package xlwt is used to parse the Excel test case file template to be generated to obtain the cell position where the pre-defined key element names in the Excel test case file template to be generated are located, and the parsing package xmindparser is used to parse the to-be-converted The content of each test case in the Xmind test case file is converted into JSON data format. Make a one-to-one correspondence between test case data and key element names in the content converted into JSON data format.

S130: Write the data in each parsed test case into the column corresponding to the cell position where the name of the key element in the same row in the parsed Excel test case file template is in turn according to the name of the corresponding key element, to generate Excel test case file.

The way of writing is to use the extension package xlwt. The expansion package xlwt is used to write the parsed data of each test case, that is, each data in the key element data group, into the column corresponding to the key element name in the Excel test case file template in turn, and each key element data group in The data is written into the same row and column, and finally the converted Excel test case file is generated.

Before S110, the method further includes: respectively reading the Xmind test case file to be converted and the Excel test case file template to be generated, wherein the Xmind test case file to be converted and the Excel test case file to be generated How templates are read is defined in command line format.

Read the Xmind test case file to be converted and the Excel test case file template to be generated, respectively, to obtain the content of the Xmind test case file and the format of the Excel test case file template.

Among them, all Xmind test case files and all Excel test case file templates are stored in the memory. All Excel test case file templates include Excel test case file templates for various test case management systems.

Determine the Excel test case file template to be generated according to the import file rules of the test case management system used and the Xmind test case file to be converted.

Reading the Xmind test case file to be converted and the Excel test case file template to be generated, the specific process includes: defining the reading mode of the Xmind test case file to be converted and the Excel test case file template to be generated in a command line format. The command line format can use the linux command line format. Define the reading method of the Xmind test case file to be converted and the Excel test case file template to be generated in linux command line format. Specifically, -x passes in the file name of the Xmind test case file to be converted, and -e passes in the file name of the Xmind test case file to be generated. The file name of the Excel test case file template, -x and -e are the parameter names of the program. -x passes in the file name of the Xmind test case file, which is used to mark and call the Xmind test case file that needs to be converted, -e passes in the file name of the Excel test case file template, which is used to mark and call the Excel test case that needs to be generated The template used by the file.

For example, in practical applications, if the Xmind test case file to be converted is named "Platform Project Test Case.Xmind", it should be converted into the Excel version according to the Excel test case file template named "Platform Project Test Case Template.xls". Test case, the calling command should be "python rXmind.py-x platform project test case.Xmind-e platform project test case template.xls".

On the other hand, if the tester only uses one Excel test case file template, the Excel test case file template to be generated is the specified Excel test case file template.

The way to read the file is to read the Xmind test case file to be converted and the default Excel test case file template. The specific process includes: setting template_name as the default Excel test case file template file name, in the command line format, only define the file to be The reading method of the converted Xmind test case file, -x passes in the file name of the Xmind test case file to be converted, and there is no need to repeatedly define the reading method of the Excel test case template file. For example, the calling command should be "python rXmind.py-x platform project testcase.Xmind"

The methods of the present application may employ the PYTHON locale.

In S120, the format of the Excel test case file to be generated is parsed, and the cell position of the pre-defined key element name in the Excel test case file template to be generated is obtained. The specific process includes: using the extension package xlwt to parse the to-be-generated test case file Excel test case file template, to obtain the format specification of the Excel test case file template to be generated, to obtain the cell position where the pre-defined key element names are located.

FIG. 3 is an Excel test case file template to be generated in Embodiment 1 of the present invention.

As shown in Figure 3, the name of the Excel test case file template to be generated is platform project test case template.xls, the name of the test case test project described in this template is "test case path, test case name, test case description, test case Steps, Test Case Expected Results", so the key element names are pre-defined as: Test Case Path, Test Case Name, Test Case Description, Test Case Steps, Test Case Expected Results.

After the platform project test case template .xls is parsed, the location of the cell where the test case path is obtained is Sheet1! $A$1, the column position is column A; the cell position where the test case name is located is Sheet1! $B$1, the column position is column B; the cell position where the test case description is located is Sheet1! $C$1, the column position is column C, and the cell position of the test case step is Sheet1! $E$1, the column position is column E; the cell position where the expected result of the test case is located is Sheet1! $F$1, the column position is column F.

Parse the data of each test case in the Xmind test case file to be converted, and make the data in the test case correspond to the names of key elements one by one. Sort to form key element name groups; parse and convert the content of the Xmind test case file to be converted into content in JSON data format, and use the custom JSON data processing method for the data of each test case in the content in JSON data format. Convert to key feature dataset. The Xmind parsing package Xmindparser can be used to convert the content of the Xmind test case file into the content of the JSON data format. The number of key element data groups is the same as the number of test cases in the Xmind test case file, and each test case has a corresponding key element data group.

Using a custom JSON data processing method to convert it into a key element data group, the process includes: extracting the value of each test case in the content of the JSON data format as a result set, and making parent-child associations for each result set respectively, and sequentially extracting the parent The node values and the sub-node values at all levels are used as data corresponding to the key element names in the key element name group to form key element data groups.

In the Excel test case file template named "platform project test case template.xls" shown in Figure 3, the key element names are sorted alphabetically according to the column position of the cell location, and the formed key element name group is { Test Case Path; Test Case Name; Test Case Description; Test Case Steps; Test Case Expected Results}.

FIG. 2 is an Xmind test case file to be converted in Embodiment 1 of the present invention.

Convert the content of the Xmind test case file to be converted with the file name "Platform Project Test Case.Xmind" as shown in Figure 2 to JSON data format, and the result is {'title':'Platform Project Case',' topics':[{'title':'Query check','topics':[{'title':'Order number','topics':[{'title':'Text box: support fuzzy search'},{ 'title':'Empty: query all approved application and redemption order libraries under this institution'},{'title':'Fuzzy search: query fuzzy search for the approved application and redemption order database under this institution' },{'title':'Full-word search: query the whole-word search for the approved application and redemption order library under the institution'},{'title':'Special characters: the query result is empty'}]}. In this way, the content of the Xmind test case file in the form of a logic diagram is converted into a JSON data format.

Then, the content of the JSON data format converted from the content of the Xmind test case file is parsed above, and the custom JSON data processing method in this embodiment is used for further processing to obtain the Excel test case written and parsed in the next step. File templates with data required for each test case. Extract the value of the first test case in the JSON data format as the result set, and make a parent-child association with the result set, extract the parent node (platform project test case) as the key element of the data corresponding to the test case path, the first-level child node (query check_order number) is used as the data corresponding to the name of the key element test case, and the secondary child node (text box: support fuzzy search) is used as the data corresponding to the key element test case description, and the data corresponding to the key element test case description can be described according to the colon Split into the data corresponding to the key element test case step (text box) and the data corresponding to the expected result of the key element test case (supports fuzzy search) to form the key element data group of the first test case. The results are as follows: (Test case path ) platform project test case; (test case name) query check_order number; (test case description) text box: support fuzzy search; (test case step) text box, (test case expected result) support fuzzy search. Then turn other test cases into corresponding key element data groups one by one.

FIG. 4 is an Excel test case file after conversion in Embodiment 1 of the present invention.

In this embodiment, the test case whose file name is "Platform Project Test Case.Xmind" is converted into an Excel version according to the method of the present invention, according to the template whose file name is "Platform Project Test Case Template.xls" The results of the test case are shown in Figure 4.

The method for converting the Xmind test case file to the Excel test case file of the present invention can automatically convert the Xmind test case into the Excel form, without repeatedly writing the Xmind test case outline and the complete Excel version test case file, saving time and cost, and significantly improving efficiency . Testers can also enjoy the function of converting Xmind test cases to Excel test cases without spending a high cost to purchase the Xmind pro version. The converted Excel test cases can be adapted to all test case management systems.

Example 2

FIG. 5 is a schematic diagram of a logical structure of a test case file conversion system according to Embodiment 2 of the present invention.

As shown in Figure 5, a test case file conversion system is used to convert Xmind test case files into Excel test case files, including:

The file content and format determination unit is used to respectively determine the content of the Xmind test case file and the format of the Excel test case file template according to the Xmind test case file to be converted and the Excel test case file template to be generated;

a file template parsing unit, configured to parse the format of the Excel test case file template to be generated, and obtain the cell position where the pre-defined key element names in the Excel test case file template to be generated are located;

a file content parsing unit, configured to parse the data of each test case in the Xmind test case file to be converted, so that the data in the test case corresponds to the name of the key element one by one;

The test case writing unit is used to sequentially write the parsed data in each of the test cases into the key elements in the same row in the parsed Excel test case file template according to the corresponding key element names. The column corresponding to the cell position where the element name is located to generate an Excel test case file.

The system for converting Xmind test case files to Excel test case files of the present invention can automatically convert Xmind test cases into Excel form, without repeatedly writing Xmind test case outlines and complete Excel version test case files, saving time and cost and significantly improving efficiency . Testers can also enjoy the function of converting Xmind test cases to Excel test cases without spending a high cost to purchase the Xmind pro version. The converted Excel test cases can be adapted to all test case management systems.

Example 3

FIG. 6 is a schematic diagram of a logical structure of an electronic device according to Embodiment 3 of the present invention.

As shown in FIG. 6 , an electronic device 1 includes a memory 3 and a processor 2, and a computer program 4 is stored in the memory 3. When the computer program 4 is executed by the processor 2, the method for converting a test case file as in the embodiment 1 is realized. step.

The computer program 4 includes a file reading program, a file parsing program and a file writing program. When these programs are executed by the processor 2, the operations that can be realized are as follows:

The file reading program, when the file reading program is executed by the processor, respectively reads the Xmind test case file to be converted and the Excel test case file template to be generated, according to the Xmind test case file to be converted and the Excel test case file to be generated. Use case file template, respectively determine the content of the Xmind test case file and the format of the Excel test case file template;

A file parsing program, when the file parsing program is executed by the processor, the Excel test case file template parsing program to be generated parses the format of the Excel test case file template to be generated, and obtains the predefined Excel test case file template to be generated. The location of the cell where the name of the key element is located; the Xmind test case file parsing program to be converted parses the data of each test case in the Xmind test case file to be converted, so that the data in the test case corresponds to the name of the key element one by one ;

The file writing program, when the file writing program is executed by the processor, writes the data in each parsed test case into the parsed Excel test case file template in the same row in sequence according to the corresponding key element name. The column corresponding to the cell position where the element name is located to generate an Excel test case file.

Example 4

A computer-readable storage medium stores a test case file conversion program, and when the test case file conversion program is executed by a processor, implements the steps of the method for test case file conversion in Embodiment 1. The test case conversion-based program may include the above-mentioned file reading program, file parsing program, and file writing program.

1 , 2 , 3 , 4 , 5 and 6 , the method, device and storage medium for converting an Xmind test case file to an Excel test case file according to the present invention are described by way of example. However, those skilled in the art should understand that various improvements can be made to the method, device and storage medium for converting an Xmind test case file to an Excel test case file proposed by the present invention without departing from the content of the present invention. Therefore, the protection scope of the present invention should be determined by the contents of the appended claims.

Claims (10)

1. A test case file conversion method is characterized by comprising the following steps:

s110: respectively determining the content of the Xmind test case file and the format of an Excel test case file template according to the Xmind test case file to be converted and the Excel test case file template to be generated;

s120: acquiring the position of a cell where a predefined key element name is located in the Excel test case file template to be generated by analyzing the format of the Excel test case file template to be generated and analyzing the data of each test case in the Xmind test case file to be converted, and enabling the data in the test case to correspond to the key element name one by one; the key element names are names used for describing test items in the Excel test case file template;

s130: and sequentially writing the data in each analyzed test case into the columns corresponding to the positions of the cells with the key element names in the same line in the file template of the analyzed Excel test case according to the corresponding key element names so as to generate the Excel test case file.

2. The test case file conversion method of claim 1, before S110, further comprising: and respectively reading the Xmind test case file to be converted and the Excel test case file template to be generated, wherein the reading modes of the Xmind test case file to be converted and the Excel test case file template to be generated are defined in a command line format.

3. The test case file conversion method of claim 2, wherein the command line format is a linux command line format, defining a first reference name and a second reference name; the first reference name is used for marking the Xmind test case file to be converted, and the second reference name is used for marking the template used by the Excel test case file to be generated.

4. The test case file conversion method according to claim 1, wherein in S120, the Excel test case file template to be generated is analyzed by using an extension package xlwt, a formatting specification of the Excel test case file template to be generated is obtained, and a cell position where the predefined key element name is located is obtained.

5. The method according to claim 1, wherein in S120, the process of parsing the data of each test case in the xmnd test case file to be converted includes:

sorting the key element names according to the alphabetic sequence of the column positions of the cells where the key element names are located to form a key element name group; analyzing and converting the content of the Xmind test case file to be converted into the content in the JSON data format; and sequentially converting the data of each test case in the contents of the JSON data format into a key element data group by adopting a self-defined JSON data processing method.

6. The test case file transformation method of claim 5, wherein the process of transforming into key element data groups using the customized JSON data processing method comprises:

and extracting the value of the content in the JSON data format as a result set, performing parent-child association on the result set, and sequentially extracting parent node values and child node values at each level as data which are in one-to-one correspondence with the key element names in the key element name group to form a key element data group.

7. The method for converting the test case file according to claim 6, wherein in S130, the data in the key element data group is sequentially written into the columns corresponding to the key element names in the Excel test case file template, and the data in each key element data group is written into the columns corresponding to the key element names in the same row, so as to generate the final Excel version test case file.

8. A test case file conversion system, comprising:

the file content and format determining unit is used for respectively determining the content of the Xmind test case file and the format of the Excel test case file template according to the Xmind test case file to be converted and the Excel test case file template to be generated;

the file template analysis unit is used for analyzing the format of the Excel test case file template to be generated and acquiring the position of a cell where a predefined key element name is located in the Excel test case file template to be generated;

the file content analysis unit is used for respectively analyzing the data of each test case in the Xmind test case file to be converted so as to enable the data in the test cases to correspond to the key element names one by one;

and the test case writing unit is used for sequentially writing the analyzed data in each test case into the columns corresponding to the cell positions where the key element names in the same row in the analyzed Excel test case file template are located according to the corresponding key element names so as to generate the Excel test case file.

9. An electronic device comprising a memory and a processor, wherein the memory stores a computer program, and the computer program when executed by the processor implements the steps of the test case file conversion method according to any one of claims 1 to 7.

10. A computer-readable storage medium, in which a test case file conversion program is stored, and when the test case file conversion program is executed by a processor, the steps of the test case file conversion method according to any one of claims 1 to 7 are implemented.

Images