CN111199146B - Test report generation method, device, computer equipment and storage medium - Google Patents
Test report generation method, device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN111199146B CN111199146B CN202010025847.0A CN202010025847A CN111199146B CN 111199146 B CN111199146 B CN 111199146B CN 202010025847 A CN202010025847 A CN 202010025847A CN 111199146 B CN111199146 B CN 111199146B
- Authority
- CN
- China
- Prior art keywords
- screening
- user
- test report
- column
- counted
- 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
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/3688—Test management for test execution, e.g. scheduling of test suites
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computer Hardware Design (AREA)
- Quality & Reliability (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Debugging And Monitoring (AREA)
Abstract
The embodiment of the application discloses a test report generation method, a test report generation device, computer equipment and a storage medium. The method comprises the following steps: receiving an Excel table of a test case to be counted, which is input by a user, and setting each column of a first row of the Excel table of the test case to be counted as a screening column; inserting a preset test report template into the Excel table of the test case to be counted, wherein the test report template comprises a blank table; receiving screening parameters input by a user, wherein the screening parameters comprise screening conditions and output coordinates; the data quantity of each screening column meeting the screening conditions is obtained, and the screened data quantity is output to the position corresponding to the output coordinate, so that the screening efficiency is improved, the problem of manual screening errors is avoided, and the manufacturing efficiency and accuracy of the test report are improved.
Description
Technical Field
The present application relates to the field of data processing technologies, and in particular, to a method and apparatus for generating a test report, a computer device, and a storage medium.
Background
Currently, most test reports are generated based on Excel charts. When generating test reports through Excel charts, a lot of data is often counted according to historical test case tables. The function of Excel screening was used at this time.
If the statistics are made every day, and the statistics are large, a lot of manpower is spent. Meanwhile, the manual screening mode is low in efficiency and is extremely prone to error.
Disclosure of Invention
The embodiment of the application provides a test report generation method, a device, computer equipment and a storage medium, which aim to solve the problems that the existing method for generating a test report by a manual screening mode is low in efficiency and is extremely prone to error.
In a first aspect, an embodiment of the present application provides a test report generating method, including:
receiving an Excel table of a test case to be counted, which is input by a user, and setting each column of a first row of the Excel table of the test case to be counted as a screening column;
inserting a preset test report template into the Excel table of the test case to be counted, wherein the test report template comprises a blank table;
receiving screening parameters input by a user, wherein the screening parameters comprise screening conditions and output coordinates;
and acquiring the number of data of which each screening column meets the screening condition, and outputting the number of the screened data to a position corresponding to the output coordinate.
The further technical scheme is that after the screening parameters input by the user are received, the method further comprises the following steps:
judging whether the screening conditions are obtained by combining screening items of each screening column;
and if the screening conditions are not obtained by combining the screening items of each screening column, sending out an error prompt.
The further technical scheme is that after the screening parameters input by the user are received, the method further comprises the following steps:
if the screening conditions are obtained by combining screening items of each screening column, judging whether the position corresponding to the output coordinate is in the blank table or not;
if the position corresponding to the output coordinate is not in the blank table, sending out an error prompt;
and if the position corresponding to the output coordinate is in the blank table, executing the steps of acquiring the number of the data of each screening column meeting the screening condition and outputting the number of the screened data to the position corresponding to the output coordinate.
The further technical scheme is that the screening parameters input by the receiving user comprise:
if a screening request input by a user is received, a preset screening parameter list is popped up, wherein the screening parameter list comprises a plurality of screening parameters;
and taking the screening parameters selected by the user in the screening parameter list as the screening parameters input by the user.
The further technical scheme is that the format of the screening condition is JSON format.
In a second aspect, an embodiment of the present application further provides a test report generating apparatus, including:
the first receiving unit is used for receiving a test case Excel table to be counted, which is input by a user, and setting each column of a first row of the test case Excel table to be counted as a screening column;
the inserting unit is used for inserting a preset test report template into the Excel table of the test case to be counted, wherein the test report template comprises a blank table;
the second receiving unit is used for receiving screening parameters input by a user, wherein the screening parameters comprise screening conditions and output coordinates;
and the acquisition unit is used for acquiring the number of the data of which each screening column meets the screening condition and outputting the number of the screened data to the position corresponding to the output coordinate.
The further technical scheme is that the test report generating device further comprises:
a first judging unit, configured to judge whether the screening condition is obtained by combining screening items in each of the screening columns;
the first prompting unit is used for sending out error prompts if the screening conditions are not obtained by combining the screening items of the screening columns;
the second judging unit is used for judging whether the position corresponding to the output coordinate is in the blank table or not if the screening condition is obtained by combining screening items of each screening column;
and the second prompting unit is used for sending out error prompting if the position corresponding to the output coordinate is not in the blank table.
The further technical scheme is that the second receiving unit comprises:
the pop-up unit is used for popping up a preset screening parameter list if a screening request input by a user is received, wherein the screening parameter list comprises a plurality of screening parameters;
and the selecting unit is used for taking the screening parameter selected by the user in the screening parameter list as the screening parameter input by the user.
In a third aspect, an embodiment of the present application further provides a computer device, which includes a memory and a processor, where the memory stores a computer program, and the processor implements the method when executing the computer program.
In a fourth aspect, embodiments of the present application also provide a computer readable storage medium storing a computer program which, when executed by a processor, implements the above method.
By applying the technical scheme of the embodiment of the application, the Excel table of the test case to be counted, which is input by a user, is received, and each column of the first row of the Excel table of the test case to be counted is set as a screening column; inserting a preset test report template into the Excel table of the test case to be counted, wherein the test report template comprises a blank table; receiving screening parameters input by a user, wherein the screening parameters comprise screening conditions and output coordinates; the data quantity of each screening column meeting the screening conditions is obtained, and the screened data quantity is output to the position corresponding to the output coordinate, so that the screening efficiency is improved, the problem of manual screening errors is avoided, and the manufacturing efficiency and accuracy of the test report are improved.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings required for the description of the embodiments will be briefly described below, and it is obvious that the drawings in the following description are some embodiments of the present application, and other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a schematic flow chart of a test report generating method according to an embodiment of the present application;
FIG. 2 is a flowchart of a test report generating method according to another embodiment of the present application;
FIG. 3 is a schematic flow chart of a test report generating method according to an embodiment of the present application;
FIG. 4 is a schematic block diagram of a test report generating device according to an embodiment of the present application;
FIG. 5 is a schematic block diagram of a second receiving unit of a test report generating device according to an embodiment of the present application;
FIG. 6 is a schematic block diagram of a test report generating apparatus according to another embodiment of the present application;
FIG. 7 is a schematic block diagram of a computer device provided by an embodiment of the present application;
fig. 8 is an effect diagram after step S1;
fig. 9 is an effect diagram after step S4.
Detailed Description
The following description of the embodiments of the present application will be made clearly and fully with reference to the accompanying drawings, in which it is evident that the embodiments described are some, but not all embodiments of the application. All other embodiments, which can be made by those skilled in the art based on the embodiments of the application without making any inventive effort, are intended to be within the scope of the application.
It should be understood that the terms "comprises" and "comprising," when used in this specification and the appended claims, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof.
It is also to be understood that the terminology used in the description of the application herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the application. As used in this specification and the appended claims, the singular forms "a," "an," and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise.
It should be further understood that the term "and/or" as used in the present specification and the appended claims refers to any and all possible combinations of one or more of the associated listed items, and includes such combinations.
As used in this specification and the appended claims, the term "if" may be interpreted as "when..once" or "in response to a determination" or "in response to detection" depending on the context. Similarly, the phrase "if a determination" or "if a [ described condition or event ] is detected" may be interpreted in the context of meaning "upon determination" or "in response to determination" or "upon detection of a [ described condition or event ]" or "in response to detection of a [ described condition or event ]".
Referring to fig. 1, fig. 1 is a flowchart illustrating a test report generating method according to an embodiment of the application. As shown, the method includes the following steps S1-S4.
S1, receiving a test case Excel table to be counted, which is input by a user, and setting each column of the first row of the test case Excel table to be counted as a screening column.
In specific implementation, a test case Excel table to be counted, which is input by a user, is received, and each column of the first row of the test case Excel table to be counted is set as a screening column. The first row of the Excel table to be counted is the row where the header of the Excel table to be counted is located.
Referring to fig. 8, an effect diagram after step S1 is shown. FIG. 8 illustrates the filter columns of the first row of the test case to be counted Excel table.
S2, inserting a preset test report template into the Excel table of the test case to be counted, wherein the test report template comprises a blank table.
In specific implementation, a preset test report template is inserted into the Excel table of the test case to be counted, and the test report template comprises a blank table. The blank table is a table to be counted, and no data exists in the blank table.
S3, receiving screening parameters input by a user, wherein the screening parameters comprise screening conditions and output coordinates.
In particular embodiments, a screening parameter input by a user is received, the screening parameter including a screening condition and an output coordinate.
In an embodiment, the format of the filtering condition is JSON format. JSON (Java Script Object Notation, JS object profile) is a lightweight data exchange format. The screening condition of the JSON format is convenient for extraction. For example, the screening conditions are:
{ "severity": 1,
"Bug type" [ "code error" ],
"Bug status" [ "closed", "resolved" ],
"whether to confirm" [ "confirmed" ] }.
In one embodiment, as depicted in FIG. 2, after step S3, the method further includes the following steps S21-S23.
S21, judging whether the screening conditions are obtained by combining screening items of each screening column.
In a specific implementation, it is determined whether the screening condition is obtained by combining screening items of each of the screening columns.
For example, in fig. 8, the filtering items of the priority column include: priority 1, priority 2, priority 3, and priority 4.
If the screening condition is not obtained by combining the screening items in each screening column, the process goes to step S23, and an error prompt is sent.
In a specific implementation, if the screening conditions are not obtained by combining the screening items in each screening column, the screening cannot be performed in the Excel table of the test case to be counted, so that an error prompt is sent to remind a user to modify the screening conditions.
And S22, if the screening conditions are obtained by combining screening items of each screening column, judging whether the position corresponding to the output coordinate is in the blank table.
In a specific implementation, if the filtering condition is obtained by combining filtering items in each filtering column, it is determined whether the position corresponding to the output coordinate is in the blank table.
If the position corresponding to the output coordinate is not in the blank table, turning to step S23, and sending out an error prompt.
In a specific implementation, if the position corresponding to the output coordinate is not in the blank table, it is indicated that the output position is wrong, so that an error prompt is sent.
And if the position corresponding to the output coordinate is in the blank table, executing step S4.
In one embodiment, as shown in fig. 3, the step of receiving the filtering parameters input by the user specifically includes the following steps S31-S32.
S31, if a screening request input by a user is received, a preset screening parameter list is popped up, wherein the screening parameter list comprises a plurality of screening parameters.
In specific implementation, if a screening request input by a user is received, a preset screening parameter list is popped up, wherein the screening parameter list comprises a plurality of screening parameters. The common screening parameters are recorded through a preset screening parameter list, so that the input efficiency of a user can be improved.
S32, taking the screening parameters selected by the user in the screening parameter list as the screening parameters input by the user.
In specific implementation, the screening parameters selected by the user in the screening parameter list are used as the screening parameters input by the user.
S4, acquiring the number of data of each screening column meeting the screening condition, and outputting the number of the screened data to the position corresponding to the output coordinate.
In a specific implementation, the number of data that each screening column satisfies the screening condition is acquired, and the number of data that is screened is output to a position (a position is specifically a cell) corresponding to the output coordinate. For example, in one embodiment, the number of data screened is 403. Test reports were obtained after screening of all screening conditions was completed.
Referring to fig. 9, an effect diagram after step S4 is shown. Fig. 9 shows the output of the number of data screened (i.e. 403 in the figure) to the location corresponding to the output coordinates.
By applying the technical scheme of the embodiment of the application, the Excel table of the test case to be counted, which is input by a user, is received, and each column of the first row of the Excel table of the test case to be counted is set as a screening column; inserting a preset test report template into the Excel table of the test case to be counted, wherein the test report template comprises a blank table; receiving screening parameters input by a user, wherein the screening parameters comprise screening conditions and output coordinates; the data quantity of each screening column meeting the screening conditions is obtained, and the screened data quantity is output to the position corresponding to the output coordinate, so that the screening efficiency is improved, the problem of manual screening errors is avoided, and the manufacturing efficiency and accuracy of the test report are improved.
Fig. 4 is a schematic block diagram of a test report generating device 40 according to an embodiment of the present application. As shown in fig. 4, the present application also provides a test report generating device 40 corresponding to the above test report generating method. The test report generating apparatus 40 includes a unit for performing the above-described test report generating method, and may be configured in a desktop computer, a tablet computer, a portable computer, or the like. Specifically, referring to fig. 4, the test report generating device 40 includes a first receiving unit 41, an inserting unit 42, a second receiving unit 43, and an acquiring unit 44.
The first receiving unit 41 is configured to receive a test case Excel table to be counted, which is input by a user, and set each column of a first row of the test case Excel table to be counted as a screening column.
The inserting unit 42 is configured to insert a preset test report template into the Excel table of the test case to be counted, where the test report template includes a blank table.
The second receiving unit 43 is configured to receive a filtering parameter input by a user, where the filtering parameter includes a filtering condition and an output coordinate.
An obtaining unit 44, configured to obtain the number of data that each of the filtering columns satisfies the filtering condition, and output the number of data that is filtered to a position corresponding to the output coordinate.
In an embodiment, as shown in fig. 5, the second receiving unit 43 includes an ejecting unit 431 and a selecting unit 432.
The pop-up unit 431 is configured to pop up a preset filtering parameter list if a filtering request input by a user is received, where the filtering parameter list includes a plurality of filtering parameters.
The selecting unit 432 is configured to take the filtering parameter selected by the user in the filtering parameter list as the filtering parameter input by the user.
Fig. 6 is a schematic block diagram of a test report generating device 40 according to another embodiment of the present application. As shown in fig. 6, the test report generating device 40 of the present embodiment is formed by adding the first judging unit 45, the first presenting unit 46, the second judging unit 47, and the second presenting unit 48 to the above-described embodiments.
A first judging unit 45 for judging whether the screening condition is obtained by combining the screening items of each of the screening columns.
The first prompting unit 46 is configured to issue an error prompt if the filtering condition is not obtained by combining the filtering items in each filtering column.
And a second judging unit 47, configured to judge whether the position corresponding to the output coordinate is in the blank table if the filtering condition is obtained by combining filtering items in each filtering column.
And a second prompting unit 48, configured to issue an error prompt if the position corresponding to the output coordinate is not in the blank table.
It should be noted that, as will be clearly understood by those skilled in the art, the specific implementation process of the test report generating device 40 and each unit may refer to the corresponding description in the foregoing method embodiment, and for convenience and brevity of description, the description is omitted here.
The test report generating means 40 described above may be implemented in the form of a computer program which is executable on a computer device as shown in fig. 7.
Referring to fig. 7, fig. 7 is a schematic block diagram of a computer device according to an embodiment of the present application. The computer device 500 may be a terminal, where the terminal may be an electronic device having a communication function, such as a smart phone, a tablet computer, a notebook computer, a desktop computer, a personal digital assistant, and a wearable device.
With reference to FIG. 7, the computer device 500 includes a processor 502, memory, and a network interface 505 connected by a system bus 501, where the memory may include a non-volatile storage medium 503 and an internal memory 504.
The non-volatile storage medium 503 may store an operating system 5031 and a computer program 5032. The computer program 5032, when executed, may cause the processor 502 to perform a test report generation method.
The processor 502 is used to provide computing and control capabilities to support the operation of the overall computer device 500.
The internal memory 504 provides an environment for the execution of a computer program 5032 in the non-volatile storage medium 503, which computer program 5032, when executed by the processor 502, causes the processor 502 to perform a test report generating method.
The network interface 505 is used for network communication with other devices. It will be appreciated by those skilled in the art that the architecture shown in fig. 7 is merely a block diagram of some of the architecture relevant to the present inventive arrangements and is not limiting of the computer device 500 to which the present inventive arrangements may be implemented, as a particular computer device 500 may include more or fewer components than shown, or may combine some of the components, or have a different arrangement of components.
Wherein the processor 502 is configured to execute a computer program 5032 stored in a memory to implement the steps of:
receiving an Excel table of a test case to be counted, which is input by a user, and setting each column of a first row of the Excel table of the test case to be counted as a screening column;
inserting a preset test report template into the Excel table of the test case to be counted, wherein the test report template comprises a blank table;
receiving screening parameters input by a user, wherein the screening parameters comprise screening conditions and output coordinates;
and acquiring the number of data of which each screening column meets the screening condition, and outputting the number of the screened data to a position corresponding to the output coordinate.
In one embodiment, when the step of receiving the filtering parameter input by the user is implemented by the processor 502, the following steps are specifically implemented:
if a screening request input by a user is received, a preset screening parameter list is popped up, wherein the screening parameter list comprises a plurality of screening parameters;
and taking the screening parameters selected by the user in the screening parameter list as the screening parameters input by the user.
In one embodiment, after implementing the step of receiving the filtering parameters input by the user, the processor 502 further implements the following steps:
judging whether the screening conditions are obtained by combining screening items of each screening column;
if the screening conditions are not obtained by combining the screening items of the screening columns, sending out an error prompt;
if the screening conditions are obtained by combining screening items of each screening column, judging whether the position corresponding to the output coordinate is in the blank table or not;
if the position corresponding to the output coordinate is not in the blank table, sending out an error prompt;
and if the position corresponding to the output coordinate is in the blank table, executing the steps of acquiring the number of the data of each screening column meeting the screening condition and outputting the number of the screened data to the position corresponding to the output coordinate.
It should be appreciated that in embodiments of the present application, the processor 502 may be a central processing unit (Central Processing Unit, CPU), the processor 502 may also be other general purpose processors, digital signal processors (Digital Signal Processor, DSP), application specific integrated circuits (Application Specific Integrated Circuit, ASIC), off-the-shelf Programmable gate arrays (FPGAs) or other Programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, or the like. Wherein the general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.
Those skilled in the art will appreciate that all or part of the flow in a method embodying the above described embodiments may be accomplished by computer programs instructing the relevant hardware. The computer program may be stored in a storage medium that is a computer readable storage medium. The computer program is executed by at least one processor in the computer system to implement the flow steps of the embodiments of the method described above.
Accordingly, the present application also provides a storage medium. The storage medium may be a computer readable storage medium. The storage medium stores a computer program. The computer program, when executed by a processor, causes the processor to perform the steps of:
receiving an Excel table of a test case to be counted, which is input by a user, and setting each column of a first row of the Excel table of the test case to be counted as a screening column;
inserting a preset test report template into the Excel table of the test case to be counted, wherein the test report template comprises a blank table;
receiving screening parameters input by a user, wherein the screening parameters comprise screening conditions and output coordinates;
and acquiring the number of data of which each screening column meets the screening condition, and outputting the number of the screened data to a position corresponding to the output coordinate.
In one embodiment, the processor, when executing the computer program to implement the step of receiving the filter parameter input by the user, specifically implements the following steps:
if a screening request input by a user is received, a preset screening parameter list is popped up, wherein the screening parameter list comprises a plurality of screening parameters;
and taking the screening parameters selected by the user in the screening parameter list as the screening parameters input by the user.
In one embodiment, the processor, after executing the computer program to implement the step of receiving the user-entered screening parameters, further implements the steps of:
judging whether the screening conditions are obtained by combining screening items of each screening column;
if the screening conditions are not obtained by combining the screening items of the screening columns, sending out an error prompt;
if the screening conditions are obtained by combining screening items of each screening column, judging whether the position corresponding to the output coordinate is in the blank table or not;
if the position corresponding to the output coordinate is not in the blank table, sending out an error prompt;
and if the position corresponding to the output coordinate is in the blank table, executing the steps of acquiring the number of the data of each screening column meeting the screening condition and outputting the number of the screened data to the position corresponding to the output coordinate.
The storage medium may be a U-disk, a removable hard disk, a Read-Only Memory (ROM), a magnetic disk, or an optical disk, or other various computer-readable storage media that can store program codes.
Those of ordinary skill in the art will appreciate that the elements and algorithm steps described in connection with the embodiments disclosed herein may be embodied in electronic hardware, in computer software, or in a combination of the two, and that the elements and steps of the examples have been generally described in terms of function in the foregoing description to clearly illustrate the interchangeability of hardware and software. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the solution. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present application.
In the several embodiments provided by the present application, it should be understood that the disclosed apparatus and method may be implemented in other manners. For example, the device embodiments described above are merely illustrative. For example, the division of each unit is only one logic function division, and there may be another division manner in actual implementation. For example, multiple units or components may be combined or may be integrated into another system, or some features may be omitted, or not performed.
The steps in the method of the embodiment of the application can be sequentially adjusted, combined and deleted according to actual needs. The units in the device of the embodiment of the application can be combined, divided and deleted according to actual needs. In addition, each functional unit in the embodiments of the present application may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit.
The integrated unit may be stored in a storage medium if implemented in the form of a software functional unit and sold or used as a stand-alone product. Based on such understanding, the technical solution of the present application is essentially or a part contributing to the prior art, or all or part of the technical solution may be embodied 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 terminal, a network device, etc.) to perform all or part of the steps of the method according to the embodiments of the present application.
In the foregoing embodiments, the descriptions of the embodiments are focused on, and for those portions of one embodiment that are not described in detail, reference may be made to the related descriptions of other embodiments.
It will be apparent to those skilled in the art that various modifications and variations can be made to the present application without departing from the spirit or scope of the application. Thus, it is intended that the present application also include such modifications and alterations insofar as they come within the scope of the appended claims or the equivalents thereof.
While the application has been described with reference to certain preferred embodiments, it will be understood by those skilled in the art that various changes and substitutions of equivalents may be made and equivalents will be apparent to those skilled in the art without departing from the scope of the application. Therefore, the protection scope of the application is subject to the protection scope of the claims.
Claims (7)
1. A test report generation method, comprising:
receiving an Excel table of a test case to be counted, which is input by a user, and setting each column of a first row of the Excel table of the test case to be counted as a screening column;
inserting a preset test report template into the Excel table of the test case to be counted, wherein the test report template comprises a blank table;
receiving screening parameters input by a user, wherein the screening parameters comprise screening conditions and output coordinates;
judging whether the screening conditions are obtained by combining screening items of each screening column;
if the screening conditions are not obtained by combining the screening items of the screening columns, sending out an error prompt;
if the screening conditions are obtained by combining screening items of each screening column, judging whether the position corresponding to the output coordinate is in the blank table or not;
if the position corresponding to the output coordinate is not in the blank table, sending out an error prompt;
and if the position corresponding to the output coordinate is in the blank table, acquiring the number of data of each screening column meeting the screening condition, and outputting the number of the screened data to the position corresponding to the output coordinate.
2. The test report generating method of claim 1, wherein the receiving the user-entered screening parameters comprises:
if a screening request input by a user is received, a preset screening parameter list is popped up, wherein the screening parameter list comprises a plurality of screening parameters;
and taking the screening parameters selected by the user in the screening parameter list as the screening parameters input by the user.
3. The test report generating method according to any one of claims 1 to 2, wherein the format of the filtering condition is JSON format.
4. A test report generating apparatus, comprising:
the first receiving unit is used for receiving a test case Excel table to be counted, which is input by a user, and setting each column of a first row of the test case Excel table to be counted as a screening column;
the inserting unit is used for inserting a preset test report template into the Excel table of the test case to be counted, wherein the test report template comprises a blank table;
the second receiving unit is used for receiving screening parameters input by a user, wherein the screening parameters comprise screening conditions and output coordinates;
a first judging unit, configured to judge whether the screening condition is obtained by combining screening items in each of the screening columns;
the first prompting unit is used for sending out error prompts if the screening conditions are not obtained by combining the screening items of the screening columns;
the second judging unit is used for judging whether the position corresponding to the output coordinate is in the blank table or not if the screening condition is obtained by combining screening items of each screening column;
the second prompting unit is used for sending out error prompts if the position corresponding to the output coordinate is not in the blank table;
and the acquisition unit is used for acquiring the number of the data of which each screening column meets the screening condition if the position corresponding to the output coordinate is in the blank table, and outputting the number of the screened data to the position corresponding to the output coordinate.
5. The test report generating apparatus of claim 4, wherein the second receiving unit comprises:
the pop-up unit is used for popping up a preset screening parameter list if a screening request input by a user is received, wherein the screening parameter list comprises a plurality of screening parameters;
and the selecting unit is used for taking the screening parameter selected by the user in the screening parameter list as the screening parameter input by the user.
6. A computer device, characterized in that it comprises a memory on which a computer program is stored and a processor which, when executing the computer program, implements the method according to any of claims 1-3.
7. A computer readable storage medium, characterized in that the storage medium stores a computer program which, when executed by a processor, implements the method according to any of claims 1-3.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010025847.0A CN111199146B (en) | 2020-01-10 | 2020-01-10 | Test report generation method, device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010025847.0A CN111199146B (en) | 2020-01-10 | 2020-01-10 | Test report generation method, device, computer equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111199146A CN111199146A (en) | 2020-05-26 |
| CN111199146B true CN111199146B (en) | 2023-09-26 |
Family
ID=70744612
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010025847.0A Active CN111199146B (en) | 2020-01-10 | 2020-01-10 | Test report generation method, device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111199146B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111858354A (en) * | 2020-07-23 | 2020-10-30 | 远光软件股份有限公司 | Method and device for automatically generating test report, storage medium and electronic equipment |
| CN113364808B (en) * | 2021-06-30 | 2022-09-16 | 北京天融信网络安全技术有限公司 | Industrial control firewall testing method, device, equipment and storage medium |
| CN113535223B (en) * | 2021-07-19 | 2023-10-24 | 长鑫存储技术有限公司 | Configuration method, device, storage medium and equipment of test flow |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108388514A (en) * | 2018-02-24 | 2018-08-10 | 平安科技（深圳）有限公司 | Automatic interface testing method, device, equipment and computer readable storage medium |
| CN110188435A (en) * | 2019-05-22 | 2019-08-30 | 东南大学 | A kind of ornamental plant intelligent selecting method based on Excel |
-
2020
- 2020-01-10 CN CN202010025847.0A patent/CN111199146B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108388514A (en) * | 2018-02-24 | 2018-08-10 | 平安科技（深圳）有限公司 | Automatic interface testing method, device, equipment and computer readable storage medium |
| CN110188435A (en) * | 2019-05-22 | 2019-08-30 | 东南大学 | A kind of ornamental plant intelligent selecting method based on Excel |
Non-Patent Citations (1)
| Title |
|---|
| 闫东日.EXCEL和VBA实现软件测试记录管理.电子制作.2018,(第16期),第81-82页. * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111199146A (en) | 2020-05-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111199146B (en) | Test report generation method, device, computer equipment and storage medium | |
| CN111478963B (en) | Message pushing method and device, electronic equipment and computer readable storage medium | |
| CN110069279B (en) | Method, device and storage medium for checking direct current control protection program | |
| US20200379748A1 (en) | Upgrading method and apparatus | |
| CN112801800A (en) | Behavior fund analysis system, behavior fund analysis method, computer equipment and storage medium | |
| US11106908B2 (en) | Techniques to determine document recognition errors | |
| CN111124878A (en) | Test report generation method and device, computer equipment and storage medium | |
| JP5250481B2 (en) | Rule design support method and rule design support device | |
| CN113886590A (en) | Data summarizing method and device, computer equipment and storage medium | |
| CN113746840A (en) | JSON format message generation method and device | |
| CN109684213A (en) | A kind of test method, device and storage medium | |
| CN109284975A (en) | Policy information batch modification method, apparatus, computer equipment and storage medium | |
| CN111506501B (en) | Method and device for generating test instruction set and electronic equipment | |
| CN108197074B (en) | Fast Fourier Transform (FFT) data processing method and device | |
| US9791509B2 (en) | Monitoring microprocessor interface information for a preset service using an address based filter | |
| CN111352610A (en) | Interface return value modification method and device, electronic equipment and storage medium | |
| CN115640301A (en) | Method and device for processing pull chain table, electronic equipment and storage medium | |
| CN109710476B (en) | System interface robustness testing method and device | |
| CN110008291B (en) | Data early warning method and device, storage medium and electronic equipment | |
| EP2813954A1 (en) | Information search apparatus and information search method | |
| CN108415922B (en) | Database modification method and application server | |
| CN111813769A (en) | Data processing method and device | |
| WO2015081749A1 (en) | Correction method and correction apparatus for input number | |
| US20140163917A1 (en) | Multi-sensing-elements calibration system, multi-sensing-elements calibration method and recording medium | |
| CN112835494A (en) | Voice recognition result error correction method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |