CN113064828A - Automatic testing method and device, computer equipment and storage medium - Google Patents
Automatic testing method and device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN113064828A CN113064828A CN202110395390.7A CN202110395390A CN113064828A CN 113064828 A CN113064828 A CN 113064828A CN 202110395390 A CN202110395390 A CN 202110395390A CN 113064828 A CN113064828 A CN 113064828A
- Authority
- CN
- China
- Prior art keywords
- worksheet
- parameter
- parameter test
- test values
- acquiring
- 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.)
- Pending
Links
- 238000012360 testing method Methods 0.000 title claims abstract description 191
- 238000004590 computer program Methods 0.000 claims description 13
- 238000012423 maintenance Methods 0.000 abstract description 5
- 238000010998 test method Methods 0.000 abstract description 2
- 238000013522 software testing Methods 0.000 abstract 1
- 238000000034 method Methods 0.000 description 8
- 238000010586 diagram Methods 0.000 description 6
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000001360 synchronised effect Effects 0.000 description 2
- 230000005540 biological transmission Effects 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
- 238000011056 performance test Methods 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
Images
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
-
- 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 invention is applicable to the technical field of computers, and provides an automatic testing method, an automatic testing device, computer equipment and a storage medium. The automatic test method comprises the following steps: acquiring a target worksheet corresponding to a measured object from an Excel file, wherein the Excel file comprises at least one worksheet, each worksheet is named by using a worksheet identifier, each worksheet identifier corresponds to one measured object, and each worksheet stores a parameter test value of the corresponding measured object; and acquiring a parameter test value of the tested object, and carrying out automatic test. According to the scheme, data of software testing is stored by using the Excel file, one or more worksheets are created in the Excel file, and data of a tested object is stored in each worksheet, so that the test data of the tested object corresponds to one worksheet, even if a large number of tested objects in a project need parameterization, only one Excel file needs to be managed, and management and maintenance of the parameterization file are effectively facilitated.
Description
Technical Field
The invention belongs to the technical field of computers, and particularly relates to an automatic testing method and device, computer equipment and a storage medium.
Background
Computer software generally needs to be automatically tested after being developed, so that problems existing in the software can be found, and the problems are solved, so that the software is continuously improved. The automatic test comprises an interface automatic test, a WebUI automatic test, a unit test and various performance tests. In software automation test, a parameterized mode is commonly used for performing data-driven automation test.
In the existing software automation test tool, for test data required by a tested object, it is common to manage the test data required by the tested object by using a single txt file or csv file.
However, in the existing automated testing tool, when a large number of objects to be tested need parameterization in a project, a large number of parameterization files need management and maintenance, and the management and maintenance are inconvenient.
Disclosure of Invention
The embodiment of the invention aims to provide an automatic testing method, and aims to solve the technical problems that a large number of parameterized files need to be managed and maintained and are inconvenient to manage and maintain when a large number of objects to be tested need parameterization in a project in the existing automatic testing tool.
The embodiment of the invention is realized in such a way that the automatic testing method comprises the following steps:
acquiring a target worksheet corresponding to a measured object from an Excel file, wherein the Excel file comprises at least one worksheet, each worksheet is named by using a worksheet identifier, each worksheet identifier corresponds to one measured object, and each worksheet stores a parameter test value of the corresponding measured object;
and acquiring a parameter test value of the tested object, and carrying out automatic test.
Another object of an embodiment of the present invention is to provide an automatic testing apparatus, which includes:
the system comprises an acquisition module, a parameter test module and a parameter test module, wherein the acquisition module is used for acquiring a target worksheet corresponding to a measured object from an Excel file, the Excel file comprises at least one worksheet, each worksheet is named by one worksheet identifier, each worksheet identifier corresponds to one measured object, and each worksheet stores a parameter test value of the corresponding measured object;
and the acquisition testing module is used for acquiring the parameter testing value of the tested object and carrying out automatic testing.
It is a further object of an embodiment of the present invention to provide a computer device, which includes a memory and a processor, wherein the memory stores a computer program, and the computer program, when executed by the processor, causes the processor to execute the steps of the above-mentioned automated testing method.
It is another object of an embodiment of the present invention to provide a computer-readable storage medium, on which a computer program is stored, which, when executed by a processor, causes the processor to perform the steps of the above-mentioned automated testing method.
The automatic testing method provided by the embodiment of the invention stores the data of the software test by using the Excel file, creates one or more worksheets in the Excel file, and stores the data of a tested object in each worksheet, so that the test data of the tested object corresponds to one worksheet, and when testing, the automatic test is completed by only finding the worksheet corresponding to the tested object according to the worksheet identification, then reading the parameter test value in the corresponding worksheet and using the read parameter test value. Therefore, even if a large number of objects to be tested in the project need parameterization, only one Excel file needs to be managed, and management and maintenance of the parameterization file are effectively facilitated.
Drawings
Fig. 1 is a flowchart of an automated testing method according to an embodiment of the present invention;
fig. 2 is a flowchart for obtaining a parameter test value of a tested object and performing an automated test according to an embodiment of the present invention;
FIG. 3 is a block diagram of an automated testing apparatus according to an embodiment of the present invention;
fig. 4 is a block diagram illustrating a structure of a test acquisition module in an automatic testing apparatus according to an embodiment of the present invention;
FIG. 5 is a block diagram showing an internal configuration of a computer device according to an embodiment;
fig. 6 is a schematic diagram of a target worksheet in an Excel file according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
It will be understood that, as used herein, the terms "first," "second," and the like may be used herein to describe various elements, but these elements are not limited by these terms unless otherwise specified. These terms are only used to distinguish one element from another. For example, a first xx script may be referred to as a second xx script, and similarly, a second xx script may be referred to as a first xx script, without departing from the scope of the present application.
As shown in fig. 1, in an embodiment, an automated testing method is provided, which may specifically include the following steps:
step S202, a target worksheet corresponding to the measured object is obtained from an Excel file, the Excel file comprises at least one worksheet, each worksheet is named by one worksheet identifier, each worksheet identifier corresponds to one measured object, and each worksheet stores a parameter test value of the corresponding measured object.
In the embodiment of the invention, each worksheet is named by using a worksheet identifier, namely, each worksheet corresponds to a unique worksheet identifier, and then each measured object corresponds to a worksheet identifier, so that when one measured object needs to be automatically tested, the corresponding worksheet identifier of the measured object is known, and the corresponding worksheet identifier can be searched for through the name of each worksheet in an Excel file, so that a target worksheet corresponding to the measured object can be obtained.
In the embodiment of the invention, the parameter test values of each tested object comprise at least one group of parameter test values, each group of parameter test values comprises parameter test values of a plurality of parameters, each parameter corresponds to one parameter identifier in each worksheet of an Excel file, the parameter test values corresponding to each parameter identifier are arranged in the same column, and the parameter test values corresponding to each parameter identifier in the same row are a group of parameter test values. For example, as shown in fig. 6, in a worksheet corresponding to the work identifier order in the figure, the parameter identifiers such as nid, connt, and mobile are stored in the first line of the work, and the second line in a column corresponding to each parameter identifier starts to identify the corresponding parameter test value for the parameter.
And step S204, acquiring a parameter test value of the tested object, and carrying out automatic test.
In the embodiment of the invention, the target worksheet corresponding to the object to be tested is obtained, the data in the target worksheet is read to obtain the parameter test value of the object to be tested, and then the obtained parameter test value can be used for testing, so that the automatic test of the object to be tested can be completed. The present embodiment does not limit the specific method for obtaining the parameter test value of the measured object, for example, in an embodiment, the storage rule of the parameter test value in each worksheet satisfies: as shown in fig. 2, step S204 may specifically include the following steps:
step S302, acquiring the total row number N of the parameter test values of the target worksheet.
In the embodiment of the invention, the total row number N of the parameter test values of the target worksheet does not include the first row where the parameter identifier is located, and the total row number of the parameter test values of the target worksheet is also the group number of the parameter test values in the target worksheet. A set of parametric test values is used for an automated test.
Step S304, a group of parameter test values in the ith row is obtained, and the group of parameter test values is used for carrying out automatic test.
In an embodiment of the present invention, starting with i equal to 1, the set of parameter test values in row 1 refers to the first row of parameter test values below the row in which the parameter is located in the target worksheet. After a set of parametric test values is obtained, a test is performed using the set of parametric test values.
And step S306, judging whether i is smaller than N, when i is smaller than N, enabling i = i +1, and repeating the previous step until i is equal to N.
In the embodiment of the present invention, a target worksheet may include multiple sets of parameter test values, after a parameter test value of one row is obtained, whether there are other sets of parameter test values below can be obtained by judging whether i is less than N, when i is less than N, i = i +1, step S304 is executed to obtain a set of parameter test values of the next row and perform an automated test, and this is repeated until i is equal to N, so that the multiple sets of parameter test values of the object to be tested respectively complete the automated test.
The automatic testing method provided by the embodiment of the invention stores the data of the software test by using the Excel file, creates one or more worksheets in the Excel file, and stores the data of a tested object in each worksheet, so that the test data of the tested object corresponds to one worksheet, and when testing, the automatic test is completed by only finding the worksheet corresponding to the tested object according to the worksheet identification, then reading the parameter test value in the corresponding worksheet and using the read parameter test value. Therefore, even if a large number of objects to be tested in the project need parameterization, only one Excel file needs to be managed, and management and maintenance of the parameterization file are effectively facilitated.
In another embodiment of the present invention, obtaining a target worksheet corresponding to a measured object from an Excel file comprises:
and referencing a first interface in the SDK program, wherein the first interface is a worksheet data interface and is used for reading and returning a worksheet object with a designated worksheet name in the designated path Excel file.
In the embodiment of the invention, a jar package readexcel, a Software Development Kit (SDK) program of an Excel data reading tool library packaged with a Java version can be developed in advance and written in readexcel, and then the jar package of the Excel data reading tool library is introduced through a BeanShell preprocessing program block of a Jmeter tool, so that the SDK program can be referred, a worksheet data interface is arranged in the SDK program, and a target worksheet corresponding to a tested object can be obtained from an Excel file by using the worksheet data interface.
In the embodiment of the invention, the storage rule of the parameter test value in each worksheet satisfies the following conditions: the parameter test values corresponding to each parameter identification are arranged in the same column, the parameter test value corresponding to each parameter identification in the same row is a group of parameter test values, and the first row of the parameter test value corresponding to each parameter identification can be written in the corresponding column of the parameter test values is taken as an example for explanation, the SDK program can also be provided with a second interface, the second interface is a data total row number interface and is used for reading and returning the data total row number of the worksheet object, and the total row number N of the parameter test values of the target worksheet can be obtained by using the data total row number interface by referring to the second interface in the SDK program.
In the embodiment of the present invention, the SDK program may further include a third interface, where the third interface is a cell data interface, and is used to read and return data of cells in a designated row and a designated column of the worksheet object. 6. After a circulation controller of a logic controller is added to a Jmeter test tool, the total row number of the parameterized data is transmitted to the circulation number of the circulation controller for interface test parameterized transmission value calling, a BeanShell preprocessing program block is created under the circulation controller of the Jmeter test tool, a jar packet of an Excel data reading tool library is quoted, a getParamdata method in the jar packet is called to obtain each column of test data corresponding to the 1 st row in an Excel worksheet, and therefore the obtained column of parameterized data is transmitted to corresponding interface parameters for interface calling test.
The invention provides an automatic test method, which designs an SDK program, wherein the SDK program comprises a worksheet data interface, a data total row number interface and a cell data interface, and writes the SDK program into a jar package ready excel.jar of an Excel data reading tool library, obtains a target worksheet corresponding to a tested object and obtains a parameter test value of the tested object in the target worksheet, and can be realized by referring to the ready excel.jar package, so that the ready excel.jar package can be used for reading parameterized test data of different worksheets under the Excel sheet by a uniform method for different types of automatic tests based on data driving, and the problem that the methods or tools using the parameterized data under 2 and different test scenes are not uniform is effectively solved.
As shown in fig. 3, in one embodiment, an automated testing apparatus is provided, which may be integrated in a computer device, and specifically may include an obtaining module 510 and an obtaining testing module 520.
The obtaining module 510 is configured to obtain a target worksheet corresponding to a measured object from an Excel file, where the Excel file includes at least one worksheet, each worksheet is named by a worksheet identifier, each worksheet identifier corresponds to one measured object, and each worksheet stores a parameter test value of the corresponding measured object.
The obtaining and testing module 520 is used for obtaining the parameter testing value of the tested object and performing the automatic testing.
As shown in fig. 4, in an embodiment, the obtaining test module 520 specifically includes: a first acquisition unit 521, a second acquisition unit 522, a test unit 523, and a determination unit 524.
A first obtaining unit 521, configured to obtain the total row number N of the target worksheet test parameter values.
A second obtaining unit 522, configured to obtain a set of parameter test values in the ith row.
The testing unit 523 is configured to perform an automated test on the obtained parameter test value.
And a judging unit 524, configured to judge whether i is less than N.
And when the judging unit judges that i is smaller than N, i = i +1, the second acquiring unit acquires a group of parameter test values in the ith row, and then the testing unit performs automatic testing by using the acquired group of parameter test values in the ith row.
In an automated testing apparatus provided in an embodiment of the present invention, functional implementations of the obtaining module 510 and the obtaining testing module 520 included in the automated testing apparatus correspond to steps S202 and S204 in the above automated testing method, functional implementations of the first obtaining unit 521 included in the obtaining testing module 520 correspond to step S302 included in step S204 in the above automated testing method, functional implementations of the second obtaining unit 522 and the testing unit 523 correspond to step S304 included in step S204 in the above automated testing method, and functional implementations of the determining unit 524 correspond to step S306 in the above automated testing method, and details of the detailed explanation, refinement, and optimization of the automated testing apparatus refer to the above specific embodiment in the automated testing method, and are not repeated herein.
FIG. 5 is a diagram illustrating an internal structure of a computer device in one embodiment. The computer device comprises a processor, a memory, a network interface, an input device and a display screen which are connected through a system bus. Wherein the memory includes a non-volatile storage medium and an internal memory. The non-volatile storage medium of the computer device stores an operating system and may also store a computer program that, when executed by the processor, causes the processor to implement an automated testing method. The internal memory may also have a computer program stored therein, which when executed by the processor, causes the processor to perform an automated testing method. The display screen of the computer equipment can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment can be a touch layer covered on the display screen, a key, a track ball or a touch pad arranged on the shell of the computer equipment, an external keyboard, a touch pad or a mouse and the like.
Those skilled in the art will appreciate that the architecture shown in fig. 5 is merely a block diagram of some of the structures associated with the disclosed aspects and is not intended to limit the computing devices to which the disclosed aspects apply, as particular computing devices may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.
In one embodiment, the automated testing apparatus provided herein may be implemented in the form of a computer program that is executable on a computer device such as that shown in fig. 5. The memory of the computer device may store various program modules that make up the automated testing apparatus, such as the acquisition module and the acquisition test module shown in FIG. 3. The computer program of each program module causes the processor to execute the steps of the automated testing method of each embodiment of the present application described in the present specification.
For example, the computer device shown in fig. 5 may execute step S202 through an acquisition module in the automated testing apparatus shown in fig. 3. The computer device may perform step S204 by acquiring the test module.
In one embodiment, a computer device is proposed, the computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the following steps when executing the computer program:
step S202, a target worksheet corresponding to a measured object is obtained from an Excel file, the Excel file comprises at least one worksheet, each worksheet is named by a worksheet identifier, each worksheet identifier corresponds to one measured object, and each worksheet stores a parameter test value of the corresponding measured object;
and step S204, acquiring a parameter test value of the tested object, and carrying out automatic test.
In one embodiment, a computer readable storage medium is provided, having a computer program stored thereon, which, when executed by a processor, causes the processor to perform the steps of:
step S202, a target worksheet corresponding to a measured object is obtained from an Excel file, the Excel file comprises at least one worksheet, each worksheet is named by a worksheet identifier, each worksheet identifier corresponds to one measured object, and each worksheet stores a parameter test value of the corresponding measured object;
and step S204, acquiring a parameter test value of the tested object, and carrying out automatic test.
It should be understood that, although the steps in the flowcharts of the embodiments of the present invention are shown in sequence as indicated by the arrows, the steps are not necessarily performed in sequence as indicated by the arrows. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise. Moreover, at least a portion of the steps in various embodiments may include multiple sub-steps or multiple stages that are not necessarily performed at the same time, but may be performed at different times, and the order of performance of the sub-steps or stages is not necessarily sequential, but may be performed in turn or alternately with other steps or at least a portion of the sub-steps or stages of other steps.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by a computer program, which can be stored in a non-volatile computer-readable storage medium, and can include the processes of the embodiments of the methods described above when the program is executed. Any reference to memory, storage, database, or other medium used in the embodiments provided herein may include non-volatile and/or volatile memory, among others. Non-volatile memory can include read-only memory (ROM), Programmable ROM (PROM), Electrically Programmable ROM (EPROM), Electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), Dynamic RAM (DRAM), Synchronous DRAM (SDRAM), Double Data Rate SDRAM (DDRSDRAM), Enhanced SDRAM (ESDRAM), Synchronous Link DRAM (SLDRAM), Rambus Direct RAM (RDRAM), direct bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).
The technical features of the embodiments described above may be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the embodiments described above are not described, but should be considered as being within the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
The above-mentioned embodiments only express several embodiments of the present invention, and the description thereof is more specific and detailed, but not construed as limiting the scope of the present invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the inventive concept, which falls within the scope of the present invention. Therefore, the protection scope of the present patent shall be subject to the appended claims.
The above description is only for the purpose of illustrating the preferred embodiments of the present invention and is not to be construed as limiting the invention, and any modifications, equivalents and improvements made within the spirit and principle of the present invention are intended to be included within the scope of the present invention.
Claims (9)
1. An automated testing method, comprising:
acquiring a target worksheet corresponding to a measured object from an Excel file, wherein the Excel file comprises at least one worksheet, each worksheet is named by using a worksheet identifier, each worksheet identifier corresponds to one measured object, and each worksheet stores a parameter test value of the corresponding measured object;
and acquiring a parameter test value of the tested object, and carrying out automatic test.
2. An automated testing method according to claim 1, wherein the parameter test values of each tested object comprise at least one group of parameter test values, each group of parameter test values comprises parameter test values of a plurality of parameters;
in each worksheet of the Excel file, each parameter corresponds to one parameter identifier, parameter test values corresponding to each parameter identifier are arranged in the same column, and the parameter test values corresponding to each parameter identifier in the same row are a group of parameter test values.
3. The automated testing method of claim 2, wherein obtaining the parameter testing value of the tested object and performing the automated testing comprises:
acquiring the total row number N of the parameter test values of the target worksheet;
acquiring a group of parameter test values in the ith row, and carrying out automatic test by using the group of parameter test values;
and judging whether i is smaller than N, when i is smaller than N, enabling i = i +1, and repeating the previous step until i is equal to N.
4. The automated testing method of claim 2, wherein obtaining the target worksheet corresponding to the object to be tested from the Excel file comprises:
and referencing a first interface in the SDK program, wherein the first interface is a worksheet data interface and is used for reading and returning a worksheet object with a designated worksheet name in the designated path Excel file.
5. The automated testing method of claim 4, wherein obtaining the parameter test value of the tested object comprises:
a second interface in the SDK program is referred, wherein the second interface is a total data row number interface and is used for reading and returning the total data row number of the worksheet object;
and referencing a third interface in the SDK program, wherein the third interface is a cell data interface and is used for reading and returning data of cells in specified rows and specified columns of the worksheet object.
6. An automated testing apparatus, comprising:
the system comprises an acquisition module, a parameter test module and a parameter test module, wherein the acquisition module is used for acquiring a target worksheet corresponding to a measured object from an Excel file, the Excel file comprises at least one worksheet, each worksheet is named by one worksheet identifier, each worksheet identifier corresponds to one measured object, and each worksheet stores a parameter test value of the corresponding measured object;
and the acquisition testing module is used for acquiring the parameter testing value of the tested object and carrying out automatic testing.
7. The automated testing device of claim 6, wherein the get test module comprises:
the first acquisition unit is used for acquiring the total row number N of the parameter test values of the target worksheet;
the second acquisition unit is used for acquiring a group of parameter test values in the ith row;
the testing unit is used for automatically testing the acquired parameter testing value;
a judging unit for judging whether i is smaller than N;
and when the judging unit judges that i is smaller than N, i = i +1, the second acquiring unit acquires a group of parameter test values in the ith row, and then the testing unit performs automatic testing by using the acquired group of parameter test values in the ith row.
8. A computer arrangement, comprising a memory and a processor, the memory having stored therein a computer program that, when executed by the processor, causes the processor to carry out the steps of the automated testing method of any of claims 1 to 5.
9. A computer-readable storage medium, having stored thereon a computer program which, when executed by a processor, causes the processor to carry out the steps of the automated testing method of any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110395390.7A CN113064828A (en) | 2021-04-13 | 2021-04-13 | Automatic testing method and device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110395390.7A CN113064828A (en) | 2021-04-13 | 2021-04-13 | Automatic testing method and device, computer equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113064828A true CN113064828A (en) | 2021-07-02 |
Family
ID=76566647
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110395390.7A Pending CN113064828A (en) | 2021-04-13 | 2021-04-13 | Automatic testing method and device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113064828A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113627892A (en) * | 2021-08-16 | 2021-11-09 | 深圳市云采网络科技有限公司 | BOM data identification method and electronic equipment thereof |
| CN113900562A (en) * | 2021-12-09 | 2022-01-07 | 深圳佑驾创新科技有限公司 | Excel-based testing method and device and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107729243A (en) * | 2017-10-12 | 2018-02-23 | 上海携程金融信息服务有限公司 | API automated testing method, system, equipment and storage medium |
| CN110134584A (en) * | 2019-04-12 | 2019-08-16 | 深圳壹账通智能科技有限公司 | A kind of generation method, device, storage medium and the server of interface testing use-case |
| CN111488274A (en) * | 2020-03-27 | 2020-08-04 | 杭州海兴电力科技股份有限公司 | Test case construction method, test equipment and storage medium |
| CN111522741A (en) * | 2020-04-14 | 2020-08-11 | 北京奇艺世纪科技有限公司 | Interface test code generation method and device, electronic equipment and readable storage medium |
-
2021
- 2021-04-13 CN CN202110395390.7A patent/CN113064828A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107729243A (en) * | 2017-10-12 | 2018-02-23 | 上海携程金融信息服务有限公司 | API automated testing method, system, equipment and storage medium |
| CN110134584A (en) * | 2019-04-12 | 2019-08-16 | 深圳壹账通智能科技有限公司 | A kind of generation method, device, storage medium and the server of interface testing use-case |
| CN111488274A (en) * | 2020-03-27 | 2020-08-04 | 杭州海兴电力科技股份有限公司 | Test case construction method, test equipment and storage medium |
| CN111522741A (en) * | 2020-04-14 | 2020-08-11 | 北京奇艺世纪科技有限公司 | Interface test code generation method and device, electronic equipment and readable storage medium |
Non-Patent Citations (1)
| Title |
|---|
| YLG001: "python利用Excel读取和存储测试数据完成接口自动化", pages 1 - 3, Retrieved from the Internet <URL:https://www.cnblogs.com/yhms/p/10138969.html> * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113627892A (en) * | 2021-08-16 | 2021-11-09 | 深圳市云采网络科技有限公司 | BOM data identification method and electronic equipment thereof |
| CN113627892B (en) * | 2021-08-16 | 2023-09-01 | 深圳市云采网络科技有限公司 | BOM data identification method and electronic equipment thereof |
| CN113900562A (en) * | 2021-12-09 | 2022-01-07 | 深圳佑驾创新科技有限公司 | Excel-based testing method and device and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11984179B2 (en) | Redundant circuit assigning method and device, and medium | |
| US11881278B2 (en) | Redundant circuit assigning method and device, apparatus and medium | |
| CN113064828A (en) | Automatic testing method and device, computer equipment and storage medium | |
| CN110109897A (en) | Database script generation method, device, computer equipment and storage medium | |
| CN111026647B (en) | Method and device for acquiring code coverage rate, computer equipment and storage medium | |
| CN112115005B (en) | Test data acquisition method and device, computer equipment and storage medium | |
| CN113282513B (en) | Interface test case generation method and device, computer equipment and storage medium | |
| CN111897727A (en) | Software testing method and device, computer equipment and storage medium | |
| CN111459796B (en) | Automated testing method, apparatus, computer device and storage medium | |
| CN110633213B (en) | Unit test method, unit test device, computer equipment and storage medium | |
| CN111162946B (en) | Method for constructing model inference network, data processing method, data processing device and storage medium | |
| CN112153375A (en) | Front-end performance testing method, device, equipment and medium based on video information | |
| CN109542782B (en) | NFC test method and device based on machine learning and computer equipment | |
| CN114138634B (en) | Test case selection method and device, computer equipment and storage medium | |
| CN115934512A (en) | Storage system dynamic test method and device, computer equipment and storage medium | |
| CN113176995B (en) | Interface testing method, device, equipment and medium based on testing scene | |
| CN113868127A (en) | Online debugging method and device, computer equipment and storage medium | |
| CN109582516B (en) | SSD back-end performance analysis method and device, computer equipment and storage medium | |
| CN107885663B (en) | Method and device for automatically generating test case, computer equipment and storage medium | |
| US20210141673A1 (en) | Method for configuration of an automation system | |
| CN112187564A (en) | vSAN performance test method, apparatus, computer device and storage medium | |
| CN113407438B (en) | Module testing method, computer device, and storage medium | |
| CN111367816B (en) | Mobile test method and device, computer equipment and storage medium | |
| CN114706785B (en) | Coverage rate filtering file generation method, coverage rate filtering file generation device, coverage rate filtering file generation equipment and coverage rate filtering file generation medium | |
| CN116842029B (en) | Asset management method, device, computer equipment and storage medium |
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 |