CN117724981A

CN117724981A - Test report generation method, device, equipment and storage medium

Info

Publication number: CN117724981A
Application number: CN202311872998.XA
Authority: CN
Inventors: 叶旭
Original assignee: Jinzhuan Xinke Co Ltd
Current assignee: Jinzhuan Xinke Co Ltd
Priority date: 2023-12-29
Filing date: 2023-12-29
Publication date: 2024-03-19

Abstract

The invention discloses a test report generation method, a device, equipment and a storage medium, relates to the technical field of big data, and particularly relates to the technical field of data testing. The method comprises the following steps: executing a test structured query statement SQL of a test case in an input case file to obtain a result object list; the result object list comprises database connection information, test SQL execution flow and influence result; generating a simulated interactive picture according to the result object list; and determining a test document report according to the simulated interactive picture and the preliminary test document. By the technical scheme, the generation efficiency of the automatic test report of the database can be improved.

Description

Test report generation method, device, equipment and storage medium

Technical Field

The present invention relates to the field of big data technologies, and in particular, to a method, an apparatus, a device, and a storage medium for generating a test report.

Background

The automatic test scheme of the database is based on jdbc mode, the generated test report only comprises test results, and most of the test report is only used for internal automatic test, and cannot be used as an external Proof of Concept (Poc) test report for third party clients. The Poc test report provided to the customer needs to have a screenshot of the operation process for the customer to review; with the popularization of domestic databases in various fields in recent years, a method for automatically testing and generating test process pictures according to test cases and summarizing to obtain test reports is needed.

Disclosure of Invention

The invention provides a test report generation method, a device, equipment and a storage medium scale, which are used for improving the generation efficiency of an automatic test report of a database.

According to an aspect of the present invention, there is provided a test report generating method, the method comprising:

executing a test structured query statement SQL of a test case in an input case file to obtain a result object list; the result object list comprises database connection information, test SQL execution flow and influence result;

generating a simulated interactive picture according to the result object list;

and determining a test document report according to the simulated interactive picture and the preliminary test document.

According to another aspect of the present invention, there is provided a test report generating apparatus including:

the result object list determining module is used for executing the test structured query statement SQL of the test case in the input case file to obtain a result object list; the result object list comprises database connection information, test SQL execution flow and influence result;

the simulated interactive picture generation module is used for generating a simulated interactive picture according to the result object list;

and the test document report determining module is used for determining a test document report according to the simulated interactive picture and the preliminary test document.

According to another aspect of the present invention, there is provided an electronic apparatus including:

at least one processor; and

a memory communicatively coupled to the at least one processor; wherein,

the memory stores a computer program executable by the at least one processor to enable the at least one processor to perform the test report generating method according to any one of the embodiments of the present invention.

According to another aspect of the present invention, there is provided a computer readable storage medium storing computer instructions for causing a processor to execute a test report generating method according to any one of the embodiments of the present invention.

According to the technical scheme, a result object list is obtained by executing a test structured query statement SQL of a test case in an input case file; the result object list comprises database connection information, a test SQL execution flow and an influence result, then a simulated interaction picture is generated according to the result object list, and a test document report is determined according to the simulated interaction picture and the preliminary test document. According to the technical scheme, the pictures for simulating the test interaction can be automatically generated, the test report document can be automatically generated, the automation is realized, and the manual operation cost is reduced.

It should be understood that the description in this section is not intended to identify key or critical features of the embodiments of the invention or to delineate the scope of the invention. Other features of the present invention will become apparent from the description that follows.

Drawings

In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings required for the description of the embodiments will be briefly described below, and it is apparent that the drawings in the following description are only some embodiments of the present invention, and other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.

FIG. 1 is a flow chart of a test report generation method according to a first embodiment of the present invention;

FIG. 2 is a flow chart of a test report generation method according to a second embodiment of the present invention;

FIG. 3 is a schematic diagram of a test report generating device according to a third embodiment of the present invention;

fig. 4 is a schematic structural diagram of an electronic device implementing a test report generating method according to an embodiment of the present invention.

Detailed Description

In order that those skilled in the art will better understand the present invention, a technical solution in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in which it is apparent that the described embodiments are only some embodiments of the present invention, not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the present invention without making any inventive effort, shall fall within the scope of the present invention.

It should be noted that the terms "first," "second," "target," and the like in the description and claims of the present invention and in the above figures are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that the embodiments of the invention described herein may be implemented in sequences other than those illustrated or otherwise described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.

In addition, in the technical scheme of the invention, the related processes of collecting, storing, using, processing, transmitting, providing, disclosing and the like of the input case file and the like all accord with the regulations of related laws and regulations, and the public welcome is not violated.

Example 1

Fig. 1 is a flowchart of a test report generating method according to an embodiment of the present invention. The present embodiment is applicable to the case of how to automatically generate a test report, and the method may be performed by a test report generating device, which may be implemented in hardware and/or software, and may be integrated in an electronic device, such as a server, carrying the test report generating function. As shown in fig. 1, the test report generating method of the present embodiment may include:

s110, executing a test structured query statement SQL of the test case in the input case file to obtain a result object list.

In this embodiment, the input case file refers to a case file for testing that is prepared in advance. The test case refers to an instance for testing in an input case file. The test structured query statement SQL, namely query SQL, refers to SQL statements in test cases.

The result object list is the result obtained after the completion process is executed on the test case; optionally, the result object list includes database connection information, test SQL execution flow and influence result; the database connection information is connection information between the simulation user client login information and the database when the test case is executed. The test QSL execution process is the process of executing test cases. The influence result refers to the number of lines in the test SQL, which is the influence of a certain line data on the whole test SQL.

Alternatively, a test case list and a test database are extracted from an input case file; initializing a connection pool connected with test data according to the database type of the test database; the connection pool is used for executing test cases; and executing the test SQL of the test cases in the test case list to obtain a result object list.

The test case list comprises at least one test case. The test database refers to a database corresponding to the input case file.

Specifically, an SQL file parser may be used to read and parse an input case file, extract a test case list and a test database, and initialize a connection pool connected with test data according to a database type of the test database, so as to execute the test case, and further test SQL of the test case in the test case list, so as to obtain a result object list. It should be noted that the connection pool may execute multi-session SQL, capture the affected SQL line number and return the result.

It can be understood that relevant data in the test process is recorded to obtain a result object list, so that pictures in the operation process can be generated conveniently.

Further, after extracting the test case list and the test database from the input case file, the method further includes: generating a preliminary test document according to the test case list; the preliminary test document is formatted.

The initial test document is an initial document used for finally generating a test report; optionally, the preliminary test document includes a test title, a table corresponding to the test title, and a test method and a test procedure column in the table.

S120, generating a simulation interaction picture according to the result object list.

In this embodiment, the simulation interactive picture refers to a picture of recording the test operation process.

Specifically, automatic screenshot can be performed on the generation or operation process of each content in the result object list, and a simulated interactive picture is obtained.

S130, determining a test document report according to the simulated interactive picture and the preliminary test document.

In this embodiment, the test document report refers to a document report that is finally generated and can be directly used for the third party client to review and review.

Specifically, the simulated interactive picture and the preliminary test document can be fused to obtain a test document report.

Example two

Fig. 2 is a flowchart of a test report generating method according to a second embodiment of the present invention. The embodiment further optimizes the "generate simulated interactive pictures according to the result object list" and "determine test document reports according to the simulated interactive pictures and the preliminary test documents" based on the above embodiment, respectively, and provides an alternative embodiment. As shown in fig. 2, the test report generating method of the present embodiment may include:

s210, executing a test structured query statement SQL of the test case in the input case file to obtain a result object list.

The result object list comprises database connection information, test SQL execution flow and influence results.

S220, generating a simulation interaction picture according to the result object list.

Alternatively, a generic drawing template is used to generate simulated interactive pictures from a list of resulting objects based on a drawing tool.

Specifically, a drawing tool can be adopted to draw and obtain a simulated interactive picture according to each content in the result object list based on a general drawing template.

After obtaining the simulated interactive picture, the simulated interactive picture is placed under the designated directory in a certain hierarchical relationship, and then the path of the simulated interactive picture can be added into the result object list as a parameter of the result object list.

S230, determining a test document report according to the simulated interactive picture and the preliminary test document.

Optionally, according to the result object list, the simulated interactive picture is filled into a table of the preliminary test document, and a test document report is obtained.

Specifically, based on the result object list, the simulated interactive pictures can be sequentially filled into the corresponding tables of each test case in the preliminary test document, so as to obtain a test document report.

It should be noted that all log information in the whole process may also be recorded for subsequent debugging.

Example III

Fig. 3 is a schematic structural diagram of a test report generating device according to a third embodiment of the present invention. The present embodiment may be applicable to the case of how to automatically generate a test report, and the apparatus may be implemented in the form of hardware and/or software and may be integrated in an electronic device, such as a server, carrying the test report generation function. As shown in fig. 3, the test report generating apparatus of the present embodiment may include:

the result object list determining module 310 is configured to execute the test structured query language SQL of the test case in the input case file to obtain a result object list; the result object list comprises database connection information, test SQL execution flow and influence result;

the simulated interactive picture generation module 320 is configured to generate a simulated interactive picture according to the result object list;

the test document report determining module 330 is configured to determine a test document report according to the simulated interactive picture and the preliminary test document.

Optionally, the result object list determining module 310 is specifically configured to:

extracting a test case list and a test database from an input case file;

initializing a connection pool connected with test data according to the database type of the test database; the connection pool is used for executing test cases;

and executing the test SQL of the test cases in the test case list to obtain a result object list.

Optionally, the apparatus further comprises a preliminary test document generation module for:

after a test case list and a test database are extracted from an input case file, generating a preliminary test document according to the test case list; the preliminary test file comprises a test title, a table corresponding to the test title, and a test method and a test process column in the table;

the preliminary test document is formatted.

Optionally, the simulated interactive picture generation module 320 is specifically configured to:

and generating a simulated interactive picture according to the result object list by adopting a universal drawing template based on the drawing tool.

Optionally, the test document report determining module 330 is specifically configured to:

and filling the simulated interactive pictures into a table of the preliminary test document according to the result object list to obtain a test document report.

The test report generating device provided by the embodiment of the invention can execute the test report generating method provided by any embodiment of the invention, and has the corresponding functional modules and beneficial effects of the executing method.

Example IV

Fig. 4 is a schematic structural diagram of an electronic device implementing a test report generating method according to an embodiment of the present invention, and fig. 4 is a schematic structural diagram of an electronic device 10 that may be used to implement an embodiment of the present invention. Electronic devices are intended to represent various forms of digital computers, such as laptops, desktops, workstations, personal digital assistants, servers, blade servers, mainframes, and other appropriate computers. Electronic equipment may also represent various forms of mobile devices, such as personal digital processing, cellular telephones, smartphones, wearable devices (e.g., helmets, glasses, watches, etc.), and other similar computing devices. The components shown herein, their connections and relationships, and their functions, are meant to be exemplary only, and are not meant to limit implementations of the inventions described and/or claimed herein.

As shown in fig. 4, the electronic device 10 includes at least one processor 11, and a memory, such as a Read Only Memory (ROM) 12, a Random Access Memory (RAM) 13, etc., communicatively connected to the at least one processor 11, in which the memory stores a computer program executable by the at least one processor, and the processor 11 may perform various appropriate actions and processes according to the computer program stored in the Read Only Memory (ROM) 12 or the computer program loaded from the storage unit 18 into the Random Access Memory (RAM) 13. In the RAM 13, various programs and data required for the operation of the electronic device 10 may also be stored. The processor 11, the ROM 12 and the RAM 13 are connected to each other via a bus 14. An input/output (I/O) interface 15 is also connected to bus 14.

Various components in the electronic device 10 are connected to the I/O interface 15, including: an input unit 16 such as a keyboard, a mouse, etc.; an output unit 17 such as various types of displays, speakers, and the like; a storage unit 18 such as a magnetic disk, an optical disk, or the like; and a communication unit 19 such as a network card, modem, wireless communication transceiver, etc. The communication unit 19 allows the electronic device 10 to exchange information/data with other devices via a computer network, such as the internet, and/or various telecommunication networks.

The processor 11 may be a variety of general and/or special purpose processing components having processing and computing capabilities. Some examples of processor 11 include, but are not limited to, a Central Processing Unit (CPU), a Graphics Processing Unit (GPU), various specialized Artificial Intelligence (AI) computing chips, various processors running machine learning model algorithms, digital Signal Processors (DSPs), and any suitable processor, controller, microcontroller, etc. The processor 11 performs the various methods and processes described above, such as the test report generation method.

In some embodiments, the test report generating method may be implemented as a computer program tangibly embodied on a computer-readable storage medium, such as storage unit 18. In some embodiments, part or all of the computer program may be loaded and/or installed onto the electronic device 10 via the ROM 12 and/or the communication unit 19. One or more of the steps of the test report generating method described above may be performed when the computer program is loaded into the RAM 13 and executed by the processor 11. Alternatively, in other embodiments, processor 11 may be configured to perform the test report generating method in any other suitable manner (e.g., by means of firmware).

Various implementations of the systems and techniques described here above may be implemented in digital electronic circuitry, integrated circuit systems, field Programmable Gate Arrays (FPGAs), application Specific Integrated Circuits (ASICs), application Specific Standard Products (ASSPs), systems On Chip (SOCs), load programmable logic devices (CPLDs), computer hardware, firmware, software, and/or combinations thereof. These various embodiments may include: implemented in one or more computer programs, the one or more computer programs may be executed and/or interpreted on a programmable system including at least one programmable processor, which may be a special purpose or general-purpose programmable processor, that may receive data and instructions from, and transmit data and instructions to, a storage system, at least one input device, and at least one output device.

A computer program for carrying out methods of the present invention may be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general purpose computer, special purpose computer, or other programmable data processing apparatus, such that the computer programs, when executed by the processor, cause the functions/acts specified in the flowchart and/or block diagram block or blocks to be implemented. The computer program may execute entirely on the machine, partly on the machine, as a stand-alone software package, partly on the machine and partly on a remote machine or entirely on the remote machine or server.

In the context of the present invention, a computer-readable storage medium may be a tangible medium that can contain, or store a computer program for use by or in connection with an instruction execution system, apparatus, or device. The computer readable storage medium may include, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any suitable combination of the foregoing. Alternatively, the computer readable storage medium may be a machine readable signal medium. More specific examples of a machine-readable storage medium would include an electrical connection based on one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

To provide for interaction with a user, the systems and techniques described here can be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to a user; and a keyboard and a pointing device (e.g., a mouse or a trackball) through which a user can provide input to the electronic device. Other kinds of devices may also be used to provide for interaction with a user; for example, feedback provided to the user may be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form, including acoustic input, speech input, or tactile input.

The systems and techniques described here can be implemented in a computing system that includes a background component (e.g., as a data server), or that includes a middleware component (e.g., an application server), or that includes a front-end component (e.g., a user computer having a graphical user interface or a web browser through which a user can interact with an implementation of the systems and techniques described here), or any combination of such background, middleware, or front-end components. The components of the system can be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: local Area Networks (LANs), wide Area Networks (WANs), blockchain networks, and the internet.

The computing system may include clients and servers. The client and server are typically remote from each other and typically interact through a communication network. The relationship of client and server arises by virtue of computer programs running on the respective computers and having a client-server relationship to each other. The server can be a cloud server, also called a cloud computing server or a cloud host, and is a host product in a cloud computing service system, so that the defects of high management difficulty and weak service expansibility in the traditional physical hosts and VPS service are overcome.

It should be appreciated that various forms of the flows shown above may be used to reorder, add, or delete steps. For example, the steps described in the present invention may be performed in parallel, sequentially, or in a different order, so long as the desired results of the technical solution of the present invention are achieved, and the present invention is not limited herein.

The above embodiments do not limit the scope of the present invention. It will be apparent to those skilled in the art that various modifications, combinations, sub-combinations and alternatives are possible, depending on design requirements and other factors. Any modifications, equivalent substitutions and improvements made within the spirit and principles of the present invention should be included in the scope of the present invention.

Claims

1. A test report generation method, comprising:

generating a simulated interactive picture according to the result object list;

2. The method of claim 1, wherein executing the test structured query language SQL of the test case in the input case file results in a result object list, comprising:

extracting a test case list and a test database from the input case file;

initializing a connection pool connected with the test data according to the database type of the test database; the connection pool is used for executing test cases;

3. The method of claim 2, further comprising, after extracting the test case list and the test database from the input case file:

generating a preliminary test document according to the test case list; the preliminary test file comprises a test title, a table corresponding to the test title, and a test method and a test process column in the table;

formatting the preliminary test document.

4. The method of claim 1, wherein generating a simulated interactive picture from the list of result objects comprises:

and generating a simulated interactive picture by adopting a universal drawing template based on a drawing tool according to the result object list.

5. The method of claim 1, wherein determining a test document report from the simulated interactive picture and a preliminary test document comprises:

and filling the simulated interactive picture into a table of the preliminary test document according to the result object list to obtain a test document report.

6. A test report generating apparatus, comprising:

7. The apparatus of claim 6, wherein the result object list determination module is specifically configured to:

extracting a test case list and a test database from the input case file;

8. The apparatus of claim 7, further comprising a preliminary test document generation module for:

after a test case list and a test database are extracted from the input case file, generating a preliminary test document according to the test case list; the preliminary test file comprises a test title, a table corresponding to the test title, and a test method and a test process column in the table;

formatting the preliminary test document.

9. An electronic device, the electronic device comprising:

at least one processor; and

a memory communicatively coupled to the at least one processor; wherein,

the memory stores a computer program executable by the at least one processor to enable the at least one processor to perform the test report generating method of any one of claims 1-5.

10. A computer readable storage medium storing computer instructions for causing a processor to perform the test report generating method of any one of claims 1-5.