CN113778886B - Processing method and device for test cases - Google Patents
Processing method and device for test cases Download PDFInfo
- Publication number
- CN113778886B CN113778886B CN202111081219.5A CN202111081219A CN113778886B CN 113778886 B CN113778886 B CN 113778886B CN 202111081219 A CN202111081219 A CN 202111081219A CN 113778886 B CN113778886 B CN 113778886B
- Authority
- CN
- China
- Prior art keywords
- test case
- case data
- data
- modified
- test
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000012360 testing method Methods 0.000 title claims abstract description 285
- 238000003672 processing method Methods 0.000 title claims abstract description 10
- 238000012545 processing Methods 0.000 claims abstract description 64
- 238000004458 analytical method Methods 0.000 claims abstract description 8
- 238000000034 method Methods 0.000 claims description 52
- 230000004048 modification Effects 0.000 claims description 23
- 238000012986 modification Methods 0.000 claims description 23
- 238000010586 diagram Methods 0.000 description 12
- 238000004891 communication Methods 0.000 description 10
- 230000006870 function Effects 0.000 description 8
- 230000008676 import Effects 0.000 description 8
- 230000008569 process Effects 0.000 description 8
- 238000004590 computer program Methods 0.000 description 6
- 230000009471 action Effects 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 3
- 230000005540 biological transmission Effects 0.000 description 2
- 238000007796 conventional method Methods 0.000 description 2
- 230000003993 interaction Effects 0.000 description 2
- 238000012546 transfer Methods 0.000 description 2
- 239000008186 active pharmaceutical agent Substances 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000002093 peripheral effect Effects 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 230000011664 signaling Effects 0.000 description 1
- 238000013522 software testing Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/36—Preventing errors by testing or debugging software
- G06F11/3668—Software testing
- G06F11/3672—Test management
- G06F11/3684—Test management for test design, e.g. generating new test cases
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Abstract
The embodiment of the application provides a processing method and a processing device for a test case, wherein the processing method comprises the following steps: acquiring an EXCEL file to be processed; the EXCEL file to be processed comprises test case data to be modified, wherein the test case data to be modified is obtained by analyzing the structure of a test case database for storing the test case data to be modified; modifying the test case data to be modified to obtain a target EXCEL file; content analysis is carried out on the target EXCEL file so as to obtain a plurality of test case data; the plurality of test case data is stored in a test case database. By means of the technical scheme, the writing efficiency can be improved.
Description
Technical Field
The application relates to the field of software testing, in particular to a method and a device for processing test cases.
Background
TestLink is a web-based test case management system, whose main functions are the creation, management and execution of test cases, and which also provides some simple statistical functions.
At present, although the TestLink can perform import and export operations of test cases, modification of the test cases is very difficult due to the fact that the exported file format is in an extensible markup language (eXtensible Markup Language, XML) format, so that a user can only create and modify the test cases on a web interface, and the problem of lower writing efficiency of the test cases is caused.
Disclosure of Invention
The embodiment of the application aims to provide a processing method and a processing device for test cases so as to improve writing efficiency.
In a first aspect, an embodiment of the present application provides a method for processing a test case, where the method includes: acquiring an EXCEL file to be processed; the EXCEL file to be processed comprises test case data to be modified, wherein the test case data to be modified is obtained by analyzing the structure of a test case database for storing the test case data to be modified; modifying the test case data to be modified to obtain a target EXCEL file; content analysis is carried out on the target EXCEL file so as to obtain a plurality of test case data; the plurality of test case data is stored in a test case database.
Therefore, the embodiment of the application analyzes the structure of the test case database to obtain the EXCEL file to be processed, and can directly edit the EXCEL file, thereby accelerating the writing efficiency.
In one possible embodiment, storing a plurality of test case data into a test case database includes: based on a remote procedure call XML-RPC protocol, sending first test case data to a server so that the server creates a first test case according to the first test case data and stores the first test case into a test case database; the first test case data is any one of a plurality of test case data.
Therefore, the embodiment of the application can use the XML-RPC technology supported by the test case database to carry out the importing operation of the test case, thereby not only accelerating the importing efficiency, but also ensuring the importing progress to be visible.
In one possible embodiment, the test case database includes a node hierarchy table storing IDs of all nodes in the form of an adjacency table; the method for obtaining the EXCEL file to be processed comprises the following steps: the ID of the test case under the father node is obtained by carrying out iterative query on the IDs of the father nodes in all the nodes; acquiring test case data to be modified according to the ID of the test case under the father node; and generating the EXCEL file to be processed by using the test case data to be modified.
Therefore, by means of the technical scheme, the method and the device can improve the acquisition efficiency of the EXCEL file.
In one possible embodiment, according to the ID of the test case under the parent node, obtaining the test case data to be modified includes: constructing a test case linked list by using the ID of the test case under the father node; and obtaining the test case data to be modified by carrying out joint query on the test case linked list.
Therefore, by means of the technical scheme, the method and the device can further improve the obtaining efficiency of the EXCEL file.
In one possible embodiment, each of the plurality of test case data includes a name, a digest, a premise, an operation step, and a result.
In a second aspect, an embodiment of the present application provides a processing apparatus for a test case, including: the acquisition module is used for acquiring the EXCEL file to be processed; the EXCEL file to be processed comprises test case data to be modified, wherein the test case data to be modified is obtained by analyzing the structure of a test case database for storing the test case data to be modified; the modification module is used for modifying the test case data to be modified to obtain a target EXCEL file; the analysis module is used for carrying out content analysis on the target EXCEL file so as to obtain a plurality of test case data; and the storage module is used for storing the plurality of test case data into the test case database.
In one possible embodiment, the storage module is specifically configured to: based on a remote procedure call XML-RPC protocol, sending first test case data to a server so that the server creates a first test case according to the first test case data and stores the first test case into a test case database; the first test case data is any one of a plurality of test case data.
In one possible embodiment, the test case database includes a node hierarchy table storing IDs of all nodes in the form of an adjacency table; the acquisition module is specifically configured to: the ID of the test case under the father node is obtained by carrying out iterative query on the IDs of the father nodes in all the nodes; acquiring test case data to be modified according to the ID of the test case under the father node; and generating the EXCEL file to be processed by using the test case data to be modified.
In one possible embodiment, the obtaining module is specifically configured to: constructing a test case linked list by using the ID of the test case under the father node; and obtaining the test case data to be modified by carrying out joint query on the test case linked list.
In one possible embodiment, each of the plurality of test case data includes a name, a digest, a premise, an operation step, and a result.
In a third aspect, embodiments of the present application provide a storage medium having stored thereon a computer program which, when executed by a processor, performs the method of the first aspect or any alternative implementation of the first aspect.
In a fourth aspect, an embodiment of the present application provides an electronic device, including: a processor, a memory and a bus, the memory storing machine-readable instructions executable by the processor, the processor and the memory in communication via the bus when the electronic device is running, the machine-readable instructions when executed by the processor performing the method of the first aspect or any alternative implementation of the first aspect.
In a fifth aspect, the application provides a computer program product which, when run on a computer, causes the computer to perform the method of the first aspect or any of the possible implementations of the first aspect.
In order to make the above objects, features and advantages of the embodiments of the present application more comprehensible, preferred embodiments accompanied with figures are described in detail below.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings that are needed in the embodiments of the present application will be briefly described below, it should be understood that the following drawings only illustrate some embodiments of the present application and should not be considered as limiting the scope, and other related drawings can be obtained according to these drawings without inventive effort for a person skilled in the art.
Fig. 1 shows a schematic diagram of an application scenario provided by an embodiment of the present application;
FIG. 2 is a schematic diagram illustrating a method for processing a test case according to an embodiment of the present application;
FIG. 3 is a schematic structural diagram of a processing device for a test case according to an embodiment of the present application;
fig. 4 shows a block diagram of an electronic device according to an embodiment of the present application.
Detailed Description
The technical solutions in the embodiments of the present application will be described below with reference to the accompanying drawings in the embodiments of the present application.
It should be noted that: like reference numerals and letters denote like items in the following figures, and thus once an item is defined in one figure, no further definition or explanation thereof is necessary in the following figures. Meanwhile, in the description of the present application, the terms "first", "second", and the like are used only to distinguish the description, and are not to be construed as indicating or implying relative importance.
At present, testLink only supports the import and export of XML format files, but because the exported test cases are difficult to modify due to XML format, the import can only be carried out again with the original content, and the method has the problem of lower writing efficiency of the test cases.
In addition, the prior art also discloses an excel-to-xml conversion method applicable to the TestLink, which comprises the steps of obtaining an excel template filled with test cases, wherein the excel template is manufactured according to an xml file derived from the TestLink, then reading data in the excel template by using a POI technology and assembling the data into xml data, and finally calling the XMLwriter to output a corresponding xml format file according to the assembled xml data.
However, for the method, since the XML import and export of the TestLink itself is used, and the function of the TestLink system itself is not perfect, the maximum data transmission of 100K can be supported, so that the import size of the test case is limited, the import time is long, and the format modification process is complicated.
Based on the above, the embodiment of the application skillfully provides a processing scheme of a test case, by acquiring an EXCEL file to be processed, wherein the EXCEL file to be processed comprises test case data to be modified, the test case data to be modified is obtained by analyzing the structure of a test case database for storing the test case data to be modified, then the test case data to be modified is modified to obtain a target EXCEL file, then the content of the target EXCEL file is analyzed to obtain a plurality of test case data, and finally the plurality of test case data are stored in the test case database.
Therefore, the embodiment of the application analyzes the structure of the test case database to obtain the EXCEL file to be processed, and can directly edit the EXCEL file, thereby accelerating the writing efficiency.
Referring to fig. 1, fig. 1 shows a schematic diagram of an application scenario provided by an embodiment of the present application. As shown in fig. 1, the application scenario includes a processing node, a server, and a test case database. The processing node can be respectively connected with the server and the test case database in a communication way, and the server can be also connected with the test case database in a communication way.
It should be understood that the specific device of the processing node may be set according to actual requirements, and embodiments of the present application are not limited thereto.
For example, the processing node may be a computer, a server, or the like.
It should also be understood that the specific device of the server may be set according to actual requirements, and embodiments of the present application are not limited thereto.
For example, the server may be a single server, a cluster of servers, or the like.
It should also be understood that the specific device of the test case database may also be set according to actual requirements, and embodiments of the present application are not limited thereto.
For example, the test case database may be TestLink, or the like.
In order to facilitate an understanding of embodiments of the present application, the following description is made by way of specific examples.
Specifically, the processing node may parse the structure (or database structure) of the test case database to obtain the EXCEL file to be processed. Then, the processing node can modify the test case data to be modified in the EXCEL file to be processed to obtain the target EXCEL file. The processing node can then perform content parsing on the target EXCEL file to obtain a plurality of test case data. Finally, the processing node may send the plurality of test case data to the server based on a remote procedure call (XML Remote Procedure Call, XML-RPC) protocol, respectively, so that the server creates test cases, and import the created test cases into the test case database.
It should be noted that, although fig. 1 shows a specific application scenario, those skilled in the art should understand that the application scenario may be modified according to actual needs, and those skilled in the art are not limited thereto.
For example, while FIG. 1 shows a specific number of processing nodes and servers, those skilled in the art will correspondingly appreciate that the application scenario may include more processing nodes and/or servers.
Referring to fig. 2, fig. 2 is a schematic diagram illustrating a processing method of a test case according to an embodiment of the application. As shown in fig. 2, the processing method includes:
in step S210, the processing node obtains an EXCEL file to be processed. The EXCEL file to be processed comprises test case data to be modified, the test case data to be modified is obtained by analyzing the structure of a test case database, and the test case database is used for storing the test case data to be modified.
It should be understood that the specific format of the EXCEL file may be set according to actual requirements, and embodiments of the present application are not limited thereto.
For example, the format of the EXCEL file may be xls or xlsx, so that the embodiment of the application can use the EXCEL file as a carrier of the test case content, and compared with the XML file, the embodiment of the application has the advantages of clear file content display, easy copying and easy modification of the file content, and the like.
It should also be understood that the data included in the test case data to be modified may be set according to actual requirements, and embodiments of the present application are not limited thereto.
For example, the test case data to be modified includes at least one of the following data: name, abstract, premise, operational steps, and result.
Correspondingly, the data contained in other test case data are similar, and specific reference may be made to the description related to the test case data to be modified, and the detailed description will not be repeated later.
It should also be understood that the specific process of the processing node obtaining the EXCEL file to be processed may be set according to actual requirements, and embodiments of the present application are not limited thereto.
Alternatively, in the case where the test case database is TestLink and the test case database includes a node hierarchy table (i.e., node_hierarchy table), the processing node may determine that the node hierarchy table stores the tree structure in the manner of an adjacency table by retrieving the node hierarchy table, i.e., the node hierarchy table stores IDs of all nodes. Wherein, the adjacency list is a storage structure combining sequential allocation and chained allocation.
Then, the processing node can obtain the IDs of all test cases under the parent node by iteratively querying the IDs of the parent node in the tree structure. The parent node may be a parent node of a single test case or a parent node of a test case set, so the IDs of all the test cases include the ID of the test case set (i.e., the wait_id) and the ID of the single test case (i.e., the case_id).
It should be understood that the number and form of the parent nodes may be set according to actual requirements, and embodiments of the present application are not limited thereto.
For example, the number of parent nodes may be 1 or a plurality of parent nodes.
It should also be understood that the specific set of test case sets and the specific cases of the individual test cases may be set according to actual requirements, and the embodiment of the present application is not limited thereto.
For example, a set of a plurality of test cases including a first test case for user login, a second test case for password modification, and a third test case for user addition is a test case set. Meanwhile, the first test case, the second test case or the third test case are all single test cases.
Although the above description uses a plurality of test cases to form a test case set as an example, it should be understood by those skilled in the art that a test case set may also be formed by a plurality of test case sets, and embodiments of the present application are not limited thereto.
Then, the processing node may construct a test case linked list using the ID of the test case.
For example, the processing node may construct a first test case linked list (i.e., wait_list) using the IDs of all test case sets. For another example, the processing node may also construct a second test case linked list (i.e., case_list) using the IDs of all individual test cases.
Then, because the specific information of the test cases is stored in different tables, the processing node can perform joint query through the IDs of the test cases in the test case linked list (namely, the IDs of the test cases can be regarded as query paths), and all the specific information of the test cases in the test case linked list can be obtained. Such as name, ID, abstract, premise, operation steps and result.
For example, the processing node may obtain all information of the corresponding test case by using the ID of the test case set in the first test case linked list. For another example, the processing node may obtain all information of the corresponding test case by using the ID of the single test case in the second test case linked list.
And finally, the processing node can write all the specific information of the acquired test case into the file in the EXCEL format through the xlwt library in the Python for storage.
That is, the specific steps of step S110 may be combined into the following steps: the processing node obtains the ID of the test case under the father node by carrying out iterative query on the IDs of the father node in all the nodes, then the processing node constructs a test case linked list by utilizing the IDs of the test cases under the father node in all the nodes, then the processing node obtains the test case data to be modified by carrying out joint query on the test case linked list, and finally the processing node generates the EXCEL file to be processed by utilizing the test case data to be modified.
It should be noted that, although the TestLink is described above as an example, those skilled in the art should understand that, in the case where the test case database is another database, the above steps may be adaptively modified, and embodiments of the present application are not limited thereto.
Step S220, the processing node modifies the test case data to be modified to obtain the target EXCEL file.
It should be understood that the modification manner of the processing node for modifying the test case data to be modified may be set according to actual requirements, and the embodiment of the present application is not limited thereto.
For example, the processing node may receive instructions entered by the user to effect modification of the test case data to be modified, i.e., it may be modified manually.
For another example, in the event that a large number of modifications are required, the processing node may implement the modification of the test case data to be modified based on the local script, i.e., it may be modified in an automated manner.
It should also be understood that the specific process of modifying the test case data to be modified by the processing node to obtain the target EXCEL file may be set according to actual requirements, and embodiments of the present application are not limited thereto.
For example, the processing node may modify the test case data to be modified in the EXCEL file to modify it into a new test case that meets the requirements.
For another example, the processing node may write a new test case from scratch using the EXCEL file as a template.
That is, the embodiment of the application can modify part of data in the test case data to be modified, and can also modify all data of the test case data to be modified.
It should be noted that, in the conventional method, if the test case is to be modified, the modification needs to be performed step by step, and the modification needs to be performed after the operation is performed step by step (for example, the modification is performed after the modification is performed step by step, the modification is performed in the second step, the modification is performed after the modification is performed step by step, etc.), so that it takes a long time to perform the modification of the test case based on the conventional method. However, if it is exported to be modified into an EXCEL file, since the EXCEL file has some shortcut operations (for example, editing of a list of a plurality of tables can be quickly realized by a pull operation for one modified operation), it can be written by the above-described characteristics of the EXCEL file, and it can omit clicking and saving operations, so that writing efficiency can be improved.
In step S230, the processing node performs content analysis on the target EXCEL file to obtain a plurality of test case data.
Specifically, the processing node can read the content of the target EXCEL file, so that the test case information in the target EXCEL file can be restored to the test case data. Such as names, abstracts, premises, operational steps and results. The name format, abstract format and precondition format are string format, and the operation steps and result are array with indefinite length.
The processing node may then divide all of the information of a test case into one test case data (alternatively referred to as an array).
For example, the processing node may take a row of data in the target EXCEL file as one test case data.
In step S240, the processing node stores the plurality of test case data in the test case database.
It should be understood that the specific process of storing the plurality of test case data into the test case database by the processing node may be set according to actual requirements, and the embodiment of the present application is not limited thereto.
Optionally, the XML-RPC protocol is invoked based on a remote procedure, and the first test case data is sent to the server, so that the server creates the first test case according to the first test case data, and stores the first test case in the test case database. The first test case data is any one of a plurality of test case data. Therefore, the embodiment of the application can use the XML-RPC technology supported by the test case database to carry out the importing operation of the test case, thereby not only accelerating the importing efficiency, but also ensuring the importing progress to be visible.
For example, in the case where the test case database is TestLink, the processing node may connect with the server through an XML-RPC using a TestLink specified Uniform resource locator (Uniform Resource Locator, URL) and user APIs. The processing node may then disassemble and fill out the current test case data into hypertext transfer protocol (Hyper Text Transfer Protocol, HTTP) requests based on the connection information, and send the HTTP requests in XML-RPC format requirements to the server for test case creation operations.
Here, since the processing node does not know the package format of the ID for the test, it is necessary to send the test case to a designated server to perform format package of the ID of the test case.
Therefore, since the existing writing mode is to directly edit in the web page and only needs to write one item, the embodiment of the application can directly edit the test cases finished before into new test cases meeting the requirements by using the EXCEL tool or write the new test cases from scratch and import the new test cases. And for the test cases with high reusability, the embodiment of the application can greatly improve the writing efficiency.
In addition, the embodiment of the application adopts a mode of directly connecting a background database to collect data, uses the python database xlwt to write the EXCEL file, and can also use an XML-RPC mode to upload the use cases, so that the whole process is clear, and the problems of difficult use case modification by using an XML file format and importation failure and long time consumption caused by overlarge imported use case files are avoided.
It should be understood that the above-described processing methods of test cases are merely exemplary, and that various modifications can be made by those skilled in the art based on the above-described methods.
Referring to fig. 3, fig. 3 is a schematic structural diagram of a processing apparatus 300 for a test case according to an embodiment of the application. It should be understood that, in the processing apparatus 300 corresponding to the method embodiment, each step of the method embodiment can be performed, and specific functions of the processing apparatus 300 may be referred to the above description, and detailed descriptions are omitted herein as appropriate to avoid repetition. The processing device 300 includes at least one software functional module that can be stored in memory in the form of software or firmware (firmware) or cured in an Operating System (OS) of the processing device 300. Specifically, the processing apparatus 300 includes:
an obtaining module 310, configured to obtain an EXCEL file to be processed; the EXCEL file to be processed comprises test case data to be modified, wherein the test case data to be modified is obtained by analyzing the structure of a test case database for storing the test case data to be modified; the modification module 320 is configured to modify the test case data to be modified to obtain a target EXCEL file; the parsing module 330 is configured to parse the content of the target EXCEL file to obtain a plurality of test case data; the storage module 340 is configured to store a plurality of test case data into a test case database.
In one possible embodiment, the storage module 340 is specifically configured to: based on a remote procedure call XML-RPC protocol, sending first test case data to a server so that the server creates a first test case according to the first test case data and stores the first test case into a test case database; the first test case data is any one of a plurality of test case data.
In one possible embodiment, the test case database includes a node hierarchy table storing IDs of all nodes in the form of an adjacency table; the obtaining module 310 is specifically configured to: the ID of the test case under the father node is obtained by carrying out iterative query on the IDs of the father nodes in all the nodes; acquiring test case data to be modified according to the ID of the test case under the father node; and generating the EXCEL file to be processed by using the test case data to be modified.
In one possible embodiment, the obtaining module 310 is specifically configured to: constructing a test case linked list by using the ID of the test case under the father node; and obtaining the test case data to be modified by carrying out joint query on the test case linked list.
In one possible embodiment, each of the plurality of test case data includes a name, a digest, a premise, an operation step, and a result.
It will be clear to those skilled in the art that, for convenience and brevity of description, reference may be made to the corresponding procedure in the foregoing method for the specific working procedure of the apparatus described above, and this will not be repeated here.
Referring to fig. 4, fig. 4 is a block diagram illustrating a structure of an electronic device 400 according to an embodiment of the application. As shown in fig. 4. Electronic device 400 may include a processor 410, a communication interface 420, a memory 430, and at least one communication bus 440. Wherein the communication bus 440 is used to enable direct connection communication of these components. The communication interface 420 of the device in the embodiment of the present application is used for performing signaling or data communication with other node devices. The processor 410 may be an integrated circuit chip with signal processing capabilities. The processor 410 may be a general-purpose processor, including a central processing unit (Central Processing Unit, CPU), a network processor (Network Processor, NP), etc.; but may also be a Digital Signal Processor (DSP), application Specific Integrated Circuit (ASIC), an off-the-shelf programmable gate array (FPGA) or other programmable logic device, discrete gate or transistor logic device, discrete hardware components. The disclosed methods, steps, and logic blocks in the embodiments of the present application may be implemented or performed. A general purpose processor may be a microprocessor or the processor 410 may be any conventional processor or the like.
The Memory 430 may be, but is not limited to, random access Memory (Random Access Memory, RAM), read Only Memory (ROM), programmable Read Only Memory (Programmable Read-Only Memory, PROM), erasable Read Only Memory (Erasable Programmable Read-Only Memory, EPROM), electrically erasable Read Only Memory (Electric Erasable Programmable Read-Only Memory, EEPROM), etc. The memory 430 has stored therein computer readable instructions which, when executed by the processor 410, can cause the electronic device 400 to perform the steps of the method embodiments described above.
The electronic device 400 may also include a memory controller, an input-output unit, an audio unit, an image acquisition unit.
The memory 430, the memory controller, the processor 410, the peripheral interface, the input/output unit, the audio unit, and the image acquisition unit are electrically connected directly or indirectly to each other, so as to realize data transmission or interaction. For example, the elements may be electrically coupled to each other via one or more communication buses 440. The processor 410 is configured to execute executable modules stored in the memory 430, such as software functional modules or computer programs included in the electronic device 400.
The input and output unit is used for realizing interaction between the intelligent equipment and the user terminal. The input-output unit may be, but is not limited to, a data input-output interface, or the like.
The image acquisition unit may be configured to cause the smart device to acquire a gesture image or a face image. The image may be, but is not limited to, a camera or the like.
The audio unit provides an audio interface to the user, which may include one or more microphones, one or more speakers, and audio circuitry.
It is to be understood that the configuration shown in fig. 4 is merely illustrative, and that the electronic device 400 may also include more or fewer components than those shown in fig. 4, or have a different configuration than that shown in fig. 4. The components shown in fig. 4 may be implemented in hardware, software, or a combination thereof.
The present application also provides a storage medium having stored thereon a computer program which, when executed by a processor, performs the method of any one of the alternative implementations of the smart device side of the embodiments.
The present application also provides a computer program product which, when run on a computer, causes the computer to perform the method of any one of the alternative implementations of the smart device side in the embodiments.
It will be clear to those skilled in the art that, for convenience and brevity of description, reference may be made to the corresponding procedure in the foregoing method for the specific working procedure of the system described above, and this will not be repeated here.
It should be noted that, in the present specification, each embodiment is described in a progressive manner, and each embodiment is mainly described as different from other embodiments, and identical and similar parts between the embodiments are all enough to be referred to each other. For the apparatus class embodiments, the description is relatively simple as it is substantially similar to the method embodiments, and reference is made to the description of the method embodiments for relevant points.
In the several embodiments provided in the present application, it should be understood that the disclosed apparatus and method may be implemented in other manners. The apparatus embodiments described above are merely illustrative, for example, of the flowcharts and block diagrams in the figures that illustrate the architecture, functionality, and operation of possible implementations of apparatus, methods and computer program products according to various embodiments of the present application. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams and/or flowchart illustration, and combinations of blocks in the block diagrams and/or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
In addition, functional modules in the embodiments of the present application may be integrated together to form a single part, or each module may exist alone, or two or more modules may be integrated to form a single part.
The functions, if implemented in the form of software functional modules and sold or used as a stand-alone product, may be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present application may be embodied essentially or in a part contributing to the prior art or in a part of the technical solution, in the form of a software product stored in a storage medium, comprising several instructions for causing a computer device (which may be a personal computer, a server, a network device, etc.) to perform all or part of the steps of the method according to the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a random access Memory (RAM, random Access Memory), a magnetic disk, or an optical disk, or other various media capable of storing program codes. It is noted that relational terms such as first and second, and the like are used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Moreover, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.
The above description is only of the preferred embodiments of the present application and is not intended to limit the present application, but various modifications and variations can be made to the present application by those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the protection scope of the present application. It should be noted that: like reference numerals and letters denote like items in the following figures, and thus once an item is defined in one figure, no further definition or explanation thereof is necessary in the following figures.
The foregoing is merely illustrative of the present application, and the present application is not limited thereto, and any person skilled in the art will readily recognize that variations or substitutions are within the scope of the present application. Therefore, the protection scope of the present application shall be subject to the protection scope of the claims.
Claims (8)
1. A method for processing a test case, comprising:
iteratively inquiring IDs of parent nodes in all nodes stored in a node hierarchy table to obtain the IDs of test cases under the parent nodes; the node hierarchy table is stored in a test case database; the node hierarchy table stores IDs of all nodes in the form of an adjacency table;
acquiring test case data to be modified according to the ID of the test case under the father node;
generating an EXCEL file to be processed by utilizing the test case data to be modified;
modifying the test case data to be modified to obtain a target EXCEL file;
content analysis is carried out on the target EXCEL file so as to obtain a plurality of test case data;
and storing the plurality of test case data into the test case database.
2. The processing method of claim 1, wherein the storing the plurality of test case data into the test case database comprises:
based on a remote procedure call XML-RPC protocol, sending first test case data to a server so that the server creates a first test case according to the first test case data and stores the first test case into a test case database; the first test case data is any one test case data in the plurality of test case data.
3. The processing method according to claim 1, wherein the obtaining the test case data to be modified according to the ID of the test case under the parent node includes:
constructing a test case linked list by using the ID of the test case under the father node;
and obtaining the test case data to be modified by carrying out joint query on the test case linked list.
4. A method of processing according to any one of claims 1 to 3, wherein each of the plurality of test case data includes a name, a digest, a premise, an operation step, and a result.
5. A test case processing apparatus, comprising:
the acquisition module is used for carrying out iterative query on the IDs of the father nodes in all the nodes stored in the node hierarchy table so as to acquire the IDs of the test cases under the father nodes; acquiring test case data to be modified according to the ID of the test case under the father node; generating an EXCEL file to be processed by utilizing the test case data to be modified; the node hierarchy table is stored in a test case database; the node hierarchy table stores IDs of all nodes in the form of an adjacency table;
the modification module is used for modifying the test case data to be modified to obtain a target EXCEL file;
the analysis module is used for carrying out content analysis on the target EXCEL file so as to obtain a plurality of test case data;
and the storage module is used for storing the plurality of test case data into the test case database.
6. The processing device according to claim 5, wherein the storage module is specifically configured to: based on a remote procedure call XML-RPC protocol, sending first test case data to a server so that the server creates a first test case according to the first test case data and stores the first test case into a test case database; the first test case data is any one test case data in the plurality of test case data.
7. The processing device according to claim 5, wherein the acquisition module is specifically configured to: constructing a test case linked list by using the ID of the test case under the father node; and obtaining the test case data to be modified by carrying out joint query on the test case linked list.
8. The processing apparatus according to any one of claims 5 to 7, wherein each of the plurality of test case data includes a name, a digest, a premise, an operation step, and a result.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111081219.5A CN113778886B (en) | 2021-09-15 | 2021-09-15 | Processing method and device for test cases |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111081219.5A CN113778886B (en) | 2021-09-15 | 2021-09-15 | Processing method and device for test cases |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113778886A CN113778886A (en) | 2021-12-10 |
| CN113778886B true CN113778886B (en) | 2023-11-10 |
Family
ID=78844211
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111081219.5A Active CN113778886B (en) | 2021-09-15 | 2021-09-15 | Processing method and device for test cases |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113778886B (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104156342A (en) * | 2014-08-01 | 2014-11-19 | 福建星网视易信息系统有限公司 | Method and device for converting Excel format testing case into XML (extensive markup language) format |
| CN108984417A (en) * | 2018-08-15 | 2018-12-11 | 北京达佳互联信息技术有限公司 | Method for testing software, device, terminal and storage medium |
| CN109857662A (en) * | 2019-01-25 | 2019-06-07 | 浙江数链科技有限公司 | Case data processing method, device, computer equipment and storage medium |
| CN111177074A (en) * | 2019-12-26 | 2020-05-19 | 广东飞企互联科技股份有限公司 | Xml to excel conversion method and system suitable for testlink |
| CN111191419A (en) * | 2019-12-26 | 2020-05-22 | 广东飞企互联科技股份有限公司 | Excel-to-xml method and system applicable to testlink |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110389889A (en) * | 2018-04-20 | 2019-10-29 | 伊姆西Ip控股有限责任公司 | For the visualization method of test case, equipment and computer readable storage medium |
-
2021
- 2021-09-15 CN CN202111081219.5A patent/CN113778886B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104156342A (en) * | 2014-08-01 | 2014-11-19 | 福建星网视易信息系统有限公司 | Method and device for converting Excel format testing case into XML (extensive markup language) format |
| CN108984417A (en) * | 2018-08-15 | 2018-12-11 | 北京达佳互联信息技术有限公司 | Method for testing software, device, terminal and storage medium |
| CN109857662A (en) * | 2019-01-25 | 2019-06-07 | 浙江数链科技有限公司 | Case data processing method, device, computer equipment and storage medium |
| CN111177074A (en) * | 2019-12-26 | 2020-05-19 | 广东飞企互联科技股份有限公司 | Xml to excel conversion method and system suitable for testlink |
| CN111191419A (en) * | 2019-12-26 | 2020-05-22 | 广东飞企互联科技股份有限公司 | Excel-to-xml method and system applicable to testlink |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113778886A (en) | 2021-12-10 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107832045B (en) | Method and apparatus for cross programming language interface conversion | |
| US10282197B2 (en) | Open application lifecycle management framework | |
| US10122380B2 (en) | Compression of javascript object notation data using structure information | |
| US7870482B2 (en) | Web browser extension for simplified utilization of web services | |
| US11798208B2 (en) | Computerized systems and methods for graph data modeling | |
| KR20210005043A (en) | Input and output schema mapping | |
| CN110780874B (en) | Method and device for generating information | |
| CN112882844B (en) | Joint debugging method, device and storage medium based on network front end and network back end | |
| CN109614088B (en) | Form component generation method and device | |
| CN115016784B (en) | Low code application multiplexing method, application analysis system, equipment and storage medium | |
| CN113721910A (en) | Interface code generation method and device, electronic equipment and computer readable medium | |
| CN111124883B (en) | Test case library introduction method, system and equipment based on tree form | |
| CN111143310B (en) | Log recording method and device and readable storage medium | |
| CN113778886B (en) | Processing method and device for test cases | |
| CN116069725A (en) | File migration method, device, apparatus, medium and program product | |
| CN114282895A (en) | Data processing method and device, electronic equipment and storage medium | |
| CN110740046B (en) | Method and device for analyzing service contract | |
| CN113536748A (en) | Method and device for generating chart data | |
| CN112579325A (en) | Business object processing method and device, electronic equipment and storage medium | |
| CN116662018B (en) | Management method, device and system of server, electronic equipment and storage medium | |
| CN108984189B (en) | Module parsing method and device | |
| CN115061723A (en) | Information processing method, information processing device, electronic equipment and computer readable storage medium | |
| CN115129743A (en) | Database access method, device and storage medium | |
| CN113760698A (en) | Method and device for converting test case file data | |
| CN116909575A (en) | Product model deployment method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |