CN114896175A - Automatic test method, device, equipment and medium for report export function - Google Patents
Automatic test method, device, equipment and medium for report export function Download PDFInfo
- Publication number
- CN114896175A CN114896175A CN202210823502.9A CN202210823502A CN114896175A CN 114896175 A CN114896175 A CN 114896175A CN 202210823502 A CN202210823502 A CN 202210823502A CN 114896175 A CN114896175 A CN 114896175A
- Authority
- CN
- China
- Prior art keywords
- picture
- report
- exporting
- determining
- display file
- 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
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
-
- 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/3692—Test management for test results analysis
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/11—File system administration, e.g. details of archiving or snapshots
- G06F16/116—Details of conversion of file system types or formats
Abstract
The invention discloses an automatic testing method, a device, equipment and a computer readable storage medium for a report exporting function, belonging to the technical field of real estate Business Intelligence (BI), wherein the method comprises the following steps: the method comprises the steps of obtaining a first report when the report export function is normal, exporting the first report to obtain a first display file, and converting the first display file into a first picture; acquiring a second report after the version is updated, exporting the second report to obtain a second display file, and converting the second display file into a second picture; and comparing the first picture with the second picture, determining a difference area between the first picture and the second picture, and determining whether the current report exporting function is normal or not according to the difference area. Compared with the traditional testing means, the method does not need visual comparison of testers, complex and subtle table lookup can be found, omission is not easy to occur, so that the testing time of the report exporting function of the real estate BI system is saved, and the testing efficiency is improved.
Description
Technical Field
The invention relates to the technical field of real estate BI, in particular to a method, a device, equipment and a computer readable storage medium for automatically testing a report exporting function.
Background
In the field of real estate BI (business intelligence), a large amount of data in a system for marketing, design, engineering, cost, operation, and the like of a house enterprise needs to be displayed after an online report is exported. It is characterized in that: 1. a series of chart components are provided for selection by BI report analysts for making various online charts or reports, etc., which typically may be of several tens of categories, and continue to expand new components. 2. The pattern configuration of each chart component is very many, and the granularity can be set in a self-defined way according to the thickness of a configurable line, the transparency of colors, the frame size of the components, the configuration of the colors and the like.
And in the process of using the online report form, the export is a high-frequency use scene and is also the core function of the product. Therefore, it is very important to test the export to ensure the correctness of the exported core function. The traditional testing method is that after a tester exports an online report, the tester visually compares whether the pattern of an icon component in the exported display file is consistent with that of the online report. However, the arrangement of the components 1 is very complicated, the small differences are difficult to find, and the omission is easy, and the rework is required to be repeated. 2. The content to be compared is very numerous. In sum, the tester often needs to repeat the test on the same content, and a lot of time is consumed continuously.
Disclosure of Invention
The invention mainly aims to provide an automatic testing method, device and equipment for a report exporting function and a computer readable storage medium, and aims to solve the technical problems of long time consumption and low efficiency in testing the report exporting function of a real estate BI system in the prior art.
In order to achieve the above object, the present invention provides an automatic testing method for report exporting function, which comprises the following steps:
the method comprises the steps of obtaining a first report when a report export function is normal, exporting the first report to obtain a first display file, and converting the first display file into a first picture;
acquiring a second report after the version is updated, exporting the second report to obtain a second display file, and converting the second display file into a second picture;
comparing the first picture with the second picture, determining a difference area between the first picture and the second picture, and determining whether the current report export function is normal according to the difference area.
Optionally, the step of exporting the first report or the second report includes:
and receiving a report export request of an interface, and automatically exporting the first report or the second report.
Optionally, the step of comparing the first picture and the second picture includes:
determining a comparison algorithm, and performing corresponding preprocessing on the first picture and the second picture by using the comparison algorithm;
and comparing the first picture and the second picture after the preprocessing by using the comparison algorithm.
Optionally, the step of comparing the first picture and the second picture includes:
determining that a comparison algorithm is a structural similarity index algorithm, setting the first picture and the second picture as preset sizes and carrying out graying processing;
and comparing the grayed first picture and the second picture with preset sizes by using the structural similarity index algorithm.
Optionally, before the step of determining the difference region between the first picture and the second picture, the method further includes:
comparing the first picture with the second picture by using the structural similarity index algorithm, and determining the similarity between the first picture and the second picture;
and if the similarity does not meet a preset value, determining a difference area between the first picture and the second picture.
Optionally, after the step of determining the difference region between the first picture and the second picture, the method further includes:
identifying the difference areas on the first picture and the second picture to respectively obtain a first marked picture and a second marked picture;
and combining the first marked picture and the second marked picture to obtain a test result picture.
Optionally, after the step of combining the first marked picture and the second marked picture to obtain the test result picture, the method further includes:
and outputting the test result and the test result picture as a test report, and sending the test report to an automatic test related party with a report export function.
In addition, to achieve the above object, the present invention further provides an automatic testing apparatus for a report exporting function, including:
the first picture conversion module is used for acquiring a first report when the report export function is normal, exporting the first report to obtain a first display file, and converting the first display file into a first picture;
the second picture conversion module is used for acquiring a second report form with an updated version, exporting the second report form to obtain a second display file, and converting the second display file into a second picture;
and the determining module is used for comparing the first picture with the second picture, determining a difference area between the first picture and the second picture, and determining whether the current report exporting function is normal or not according to the difference area.
In addition, in order to achieve the above object, the present invention further provides an automatic test device with a report export function, wherein the automatic test device with a report export function comprises: a memory, a processor and a computer program stored on said memory and executable on said processor, said computer program being configured to implement the steps of the automated testing method of report exporting functionality as described above.
In addition, to achieve the above object, the present invention further provides a computer readable storage medium, wherein the computer readable storage medium stores a computer program, and the computer program, when executed by a processor, implements the steps of the automated testing method for report exporting function as described above.
The embodiment of the invention provides a method, a device and equipment for automatically testing a report exporting function and a computer readable storage medium, wherein the method comprises the following steps: the method comprises the steps of obtaining a first report when a report export function is normal, exporting the first report to obtain a first display file, and converting the first display file into a first picture; acquiring a second report after the version is updated, exporting the second report to obtain a second display file, and converting the second display file into a second picture; comparing the first picture with the second picture, determining a difference area between the first picture and the second picture, and determining whether the current report export function is normal according to the difference area.
The online report is exported to be a display file, the display file is converted into a picture, a difference area between the report with a normal export function and the report corresponding to the export function to be determined whether to be normal or not is determined through an image recognition algorithm, and pixel-level pattern differences are displayed, so that the pattern differences between the front version and the rear version of the system and/or the pattern differences of the system at different use moments can be visually seen through the picture mode. Compared with the traditional testing means, the method does not need visual comparison of testers, complex and subtle table lookup can be found, omission is not easy to occur, so that the testing time of the report exporting function of the real estate BI system is saved, and the testing efficiency is improved.
Drawings
FIG. 1 is a schematic diagram of a hardware execution environment execution device according to an embodiment of the present invention;
fig. 2 is a schematic flow chart illustrating an embodiment of an automated testing method for report export function according to the present invention.
The implementation, functional features and advantages of the objects of the present invention will be further explained with reference to the accompanying drawings.
Detailed Description
It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
Referring to fig. 1, fig. 1 is a schematic structural diagram of an operating device in a hardware operating environment according to an embodiment of the present invention.
As shown in fig. 1, the operation device may include: a processor 1001, such as a Central Processing Unit (CPU), a communication bus 1002, a user interface 1003, a network interface 1004, and a memory 1005. Wherein a communication bus 1002 is used to enable connective communication between these components. The user interface 1003 may include a Display screen (Display), an input unit such as a Keyboard (Keyboard), and the optional user interface 1003 may also include a standard wired interface, a wireless interface. The network interface 1004 may optionally include a standard wired interface, a WIreless interface (e.g., a WIreless-FIdelity (WI-FI) interface). The Memory 1005 may be a Random Access Memory (RAM) Memory, or a Non-Volatile Memory (NVM), such as a disk Memory. The memory 1005 may alternatively be a storage device separate from the processor 1001.
Those skilled in the art will appreciate that the configuration shown in FIG. 1 does not constitute a limitation of the operating device and may include more or fewer components than shown, or some components may be combined, or a different arrangement of components.
As shown in fig. 1, a memory 1005, which is a kind of storage medium, may include therein an operating system, a data storage module, a network communication module, a user interface module, and a computer program.
In the operating device shown in fig. 1, the network interface 1004 is mainly used for data communication with other devices; the user interface 1003 is mainly used for data interaction with a user; the processor 1001 and the memory 1005 in the execution apparatus of the present invention may be provided in an execution apparatus that calls a computer program stored in the memory 1005 by the processor 1001 and performs the following operations:
the method comprises the steps of obtaining a first report when a report export function is normal, exporting the first report to obtain a first display file, and converting the first display file into a first picture;
acquiring a second report after the version is updated, exporting the second report to obtain a second display file, and converting the second display file into a second picture;
comparing the first picture with the second picture, determining a difference area between the first picture and the second picture, and determining whether the current report export function is normal according to the difference area.
Further, the processor 1001 may call the computer program stored in the memory 1005, and also perform the following operations:
the step of exporting the first report or the second report includes:
and receiving a report export request of an interface, and automatically exporting the first report or the second report.
Further, the processor 1001 may call the computer program stored in the memory 1005, and also perform the following operations:
the step of comparing the first picture and the second picture comprises:
determining a comparison algorithm, and performing corresponding preprocessing on the first picture and the second picture by using the comparison algorithm;
and comparing the first picture and the second picture after the preprocessing by using the comparison algorithm.
Further, the processor 1001 may call the computer program stored in the memory 1005, and also perform the following operations:
the step of comparing the first picture and the second picture comprises:
determining that a comparison algorithm is a structural similarity index algorithm, setting the first picture and the second picture as preset sizes and carrying out graying processing;
and comparing the grayed first picture and the second picture with preset sizes by using the structural similarity index algorithm.
Further, the processor 1001 may call the computer program stored in the memory 1005, and also perform the following operations:
before the step of determining the difference region between the first picture and the second picture, the method further includes:
comparing the first picture with the second picture by using the structural similarity index algorithm, and determining the similarity between the first picture and the second picture;
and if the similarity does not meet a preset value, determining a difference area between the first picture and the second picture.
Further, the processor 1001 may call the computer program stored in the memory 1005, and also perform the following operations:
after the step of determining the difference region between the first picture and the second picture, the method further includes:
identifying the difference areas on the first picture and the second picture to respectively obtain a first marked picture and a second marked picture;
and combining the first marked picture and the second marked picture to obtain a test result picture.
Further, the processor 1001 may call the computer program stored in the memory 1005, and also perform the following operations:
after the step of combining the first marked picture and the second marked picture to obtain the test result picture, the method further includes:
and outputting the test result and the test result picture as a test report, and sending the test report to an automatic test related party with a report export function.
An embodiment of the present invention provides an automated testing method for a report export function, and referring to fig. 2, fig. 2 is a flowchart illustrating an embodiment of an automated testing method for a report export function according to the present invention.
In this embodiment, the automated testing method for the report exporting function includes:
step S10: the method comprises the steps of obtaining a first report when a report export function is normal, exporting the first report to obtain a first display file, and converting the first display file into a first picture;
the acquired first report is the report when the report export function is determined to be normal, the developer does not modify the icon assembly generating the first report, and the system version is not iterated. After the first report is obtained, a first display file is obtained after exporting, in this embodiment, a ppt (power point) file is used as a representative display file, and then the display file is converted into a picture.
The report can be exported after being made on a webpage by using a chart component in the room-enterprise BI system, or can be exported after being made on line and uploaded to the room-enterprise BI system.
Step S20: acquiring a second report after the version is updated, exporting the second report to obtain a second display file, and converting the second display file into a second picture;
the second report can be made after the icon assembly for generating the first report is modified or the system version is iteratively upgraded according to actual development requirements; or a second report is made without any change;
the report exporting function of the room enterprise BI system can be determined to be normal according to whether the difference area appears, the report exporting function of the room enterprise BI system can be determined to be normal according to whether the difference area is an expected area for modification and iteration, and the report exporting function of the room enterprise BI system can be determined to be normal according to whether the difference area outside the expected area appears.
And after a second report is produced, exporting a second display file and converting the second display file to obtain a second picture in the same way.
When the code of the program is changed, the same report is continuously used to export the program to be the second display file, and the report used in the step S10 and the step S20 is the same report. The second report can be understood as a new version report which is made by compiling a new code program, but not manually made, and the code is updated at the moment and is different from the running code of the first report. Under the operation of different code versions, the derived content of the same web-side report is different.
Step S30: comparing the first picture with the second picture, determining a difference area between the first picture and the second picture, and determining whether the current report export function is normal according to the difference area.
Comparing the first picture with the second picture through an image recognition algorithm, determining a difference area between the first picture and the second picture, and determining whether the style, the attribute and the like of each component configuration are consistent, such as the difference between the custom-set component style and the attribute and the like of the thickness of a line, the transparency of a color, the frame size of a component, the configuration of the color and the like.
If the same room-enterprise BI system is used for making and exporting reports, theoretically, the pictures corresponding to the first report and the second report cannot be different unless the export function of the room-enterprise BI system fails due to format conversion between the reports and the display files and data processing, and further the difference exists between the reports and the display files. Therefore, the current report export function abnormity can be determined through the difference area between the first picture and the second picture.
If different room-enterprise BI systems are used for making and exporting reports, and a room-enterprise BI system which is different from the first report and is modified is used for making and exporting a second report, the difference area of the first picture and the second picture is theoretically only the difference area for modifying the room-enterprise BI system, the difference area can be in one-to-one correspondence with the modification of the room-enterprise BI system, and the remaining difference area except the expectation can be determined as the difference area caused by the current report export function abnormity. Therefore, it can be determined where modifications to the room enterprise BI system will be, what the new export functionality introduced by the modifications will be.
The online report exporting function of the room-enterprise BI system of the iteration version before and after the test can be accurate to the pixel level, and the difference of all the graph component styles can be identified. The device helps testers to find problems in time, increases the test accuracy, reduces the workload and ensures the product quality.
In this embodiment, a first report when the report export function is normal is obtained, the first report is exported to obtain a first display file, and the first display file is converted into a first picture; acquiring a second report after the version is updated, exporting the second report to obtain a second display file, and converting the second display file into a second picture; comparing the first picture with the second picture, determining a difference area between the first picture and the second picture, and determining whether the current report export function is normal according to the difference area.
The online report is exported to be a display file, the display file is converted into a picture, a difference area between the report with a normal export function and the report corresponding to the export function to be determined whether to be normal or not is determined through an image recognition algorithm, and pixel-level pattern differences are displayed, so that the pattern differences between the front version and the rear version of the system and/or the pattern differences of the system at different use moments can be visually seen through the picture mode. Compared with the traditional testing means, the method does not need visual comparison of testers, complex and subtle table lookup can be found, omission is not easy to occur, so that the testing time of the report exporting function of the real estate BI system is saved, and the testing efficiency is improved.
Optionally, the step of exporting the first report or the second report includes:
and receiving a report export request of an interface, and automatically exporting the first report or the second report.
The PPT report is exported to be an asynchronous task, the traditional manual click downloading is carried out, and the time for waiting for several minutes is needed when the data volume is large. In the embodiment, an interface automatic request mode is used for replacing a manual page click to export the online report, so that part of time is saved, and the test efficiency of the report export function of the real estate BI system is improved.
Optionally, the step of comparing the first picture and the second picture includes:
determining a comparison algorithm, and performing corresponding preprocessing on the first picture and the second picture by using the comparison algorithm;
and comparing the first picture and the second picture after the preprocessing by using the comparison algorithm.
Optionally, the step of comparing the first picture and the second picture includes:
determining that a comparison algorithm is a structural similarity index algorithm, setting the first picture and the second picture as preset sizes and carrying out graying processing;
and comparing the grayed first picture and the second picture with preset sizes by using the structural similarity index algorithm.
In the present embodiment, the comparison algorithm employs an SSIM (Structural Similarity Index) algorithm. The corresponding preprocessing is to process the pictures converted from the display files into a uniform size (e.g., 800 × 600) to align the pixels. And then each pixel in the picture is expressed by using the RGB color space, and the picture is grayed so as to reduce the data volume of contrast processing.
Optionally, before the step of determining the difference region between the first picture and the second picture, the method further includes:
comparing the first picture with the second picture by using the structural similarity index algorithm, and determining the similarity between the first picture and the second picture;
and if the similarity does not meet a preset value, determining a difference area between the first picture and the second picture.
And calculating a Structural Similarity Index (SSIM) between the two versions of the picture, the first picture and the second picture. The range of the difference value and the similarity is 0-100%, and 100% is completely consistent.
If the same room-enterprise BI system is used to make and export reports, the similarity between the first picture and the second picture should meet the preset value of approximately 100%. And if the similarity does not meet the preset numerical value, the export function of the room-enterprise BI system is proved to be failed.
If different room-enterprise BI systems are used for making reports and exporting reports, and a room-enterprise BI system which is different from the first report and is modified is used for making a second report and exporting the second report, a preset value which is required to meet the similarity between the first picture and the second picture needs to be set according to the modification of a specific developer. If a particular developer makes a 20% modification, then the default value should be 80%. If the similarity does not meet the preset value, it is proved that the export function of the room enterprise BI system fails in addition to the 20% modification made by the specific developer.
Optionally, after the step of determining the difference region between the first picture and the second picture, the method further includes:
identifying the difference areas on the first picture and the second picture to respectively obtain a first marked picture and a second marked picture;
and combining the first marked picture and the second marked picture to obtain a test result picture.
After the difference area between the first picture and the second picture is determined, the difference area is respectively marked on the first picture and the second picture, the difference area is drawn by calculating a boundary box of the outline of the difference area, and a first mark picture and a second mark picture are obtained. And merging the first marked picture and the second marked picture marked with the difference areas into a new test result picture, for example, splicing the left and the right into a test result picture.
Optionally, after the step of combining the first marked picture and the second marked picture to obtain the test result picture, the method further includes:
and outputting the test result and the test result picture as a test report, and sending the test report to an automatic test related party with a report export function.
And finally, outputting a test report, outputting the test result and the test result picture as the test report, generating an email or other communication tool messages and sending the email or other communication tool messages to related personnel of an automatic test related party with a report form export function.
In addition, an embodiment of the present invention further provides an automatic testing apparatus for a report export function, where the automatic testing apparatus for a report export function includes:
the first picture conversion module is used for acquiring a first report when the report export function is normal, exporting the first report to obtain a first display file, and converting the first display file into a first picture;
the second picture conversion module is used for acquiring a second report form with an updated version, exporting the second report form to obtain a second display file, and converting the second display file into a second picture;
and the determining module is used for comparing the first picture with the second picture, determining a difference area between the first picture and the second picture, and determining whether the current report exporting function is normal or not according to the difference area.
Optionally, the first picture conversion module or the second picture conversion module is further configured to
And receiving a report export request of an interface, and automatically exporting the first report or the second report.
Optionally, the determining module is further used for
Determining a comparison algorithm, and performing corresponding preprocessing on the first picture and the second picture by using the comparison algorithm;
and comparing the first picture and the second picture after the preprocessing by using the comparison algorithm.
Optionally, the determining module is further used for
Determining that a comparison algorithm is a structural similarity index algorithm, setting the first picture and the second picture as preset sizes and carrying out graying processing;
and comparing the grayed first picture and the second picture with preset sizes by using the structural similarity index algorithm.
Optionally, the determining module is further used for
Comparing the first picture with the second picture by using the structural similarity index algorithm, and determining the similarity between the first picture and the second picture;
and if the similarity does not meet a preset value, determining a difference area between the first picture and the second picture.
Optionally, the determining module is further used for
Identifying the difference areas on the first picture and the second picture to respectively obtain a first marked picture and a second marked picture;
and combining the first marked picture and the second marked picture to obtain a test result picture.
Optionally, the determining module is further used for
And outputting the test result and the test result picture as a test report, and sending the test report to an automatic test related party with a report export function.
The automatic testing device for the report exporting function provided by the invention adopts the automatic testing method for the report exporting function in the embodiment, and solves the technical problems of long time consumption and low efficiency in the testing of the report exporting function of the real estate BI system in the prior art. Compared with the prior art, the beneficial effects of the automatic testing device for the report export function provided by the embodiment of the invention are the same as the beneficial effects of the automatic testing method for the report export function provided by the embodiment, and other technical features of the automatic testing device for the report export function are the same as those disclosed by the embodiment method, and are not repeated herein.
In addition, an embodiment of the present invention further provides an automated testing device with a report export function, where the automated testing device with the report export function includes: a memory, a processor and a computer program stored on said memory and executable on said processor, said computer program being configured to implement the steps of the automated testing method of report exporting functionality as described above.
In addition, an embodiment of the present invention further provides a computer-readable storage medium, where a computer program is stored on the computer-readable storage medium, and when the computer program is executed by a processor, the steps of the automated testing method for the report exporting function described above are implemented.
It should be noted that, in this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or system that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or system. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in the process, method, article, or system in which the element is included.
The above-mentioned serial numbers of the embodiments of the present invention are merely for description and do not represent the merits of the embodiments.
Through the above description of the embodiments, those skilled in the art will clearly understand that the method of the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but in many cases, the former is a better implementation manner. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium (e.g., ROM/RAM, magnetic disk, optical disk) as described above and includes instructions for enabling a terminal device (e.g., a mobile phone, a computer, a server, or a network device) to execute the method according to the embodiments of the present invention.
The above description is only a preferred embodiment of the present invention, and not intended to limit the scope of the present invention, and all modifications of equivalent structures and equivalent processes, which are made by using the contents of the present specification and the accompanying drawings, or directly or indirectly applied to other related technical fields, are included in the scope of the present invention.
Claims (10)
1. An automatic test method for a report export function is characterized by comprising the following steps:
the method comprises the steps of obtaining a first report when a report export function is normal, exporting the first report to obtain a first display file, and converting the first display file into a first picture;
acquiring a second report after the version is updated, exporting the second report to obtain a second display file, and converting the second display file into a second picture;
comparing the first picture with the second picture, determining a difference area between the first picture and the second picture, and determining whether the current report export function is normal according to the difference area.
2. The method for automated testing of report export functionality according to claim 1, wherein said step of exporting said first report or said second report comprises:
and receiving a report export request of an interface, and automatically exporting the first report or the second report.
3. The method for automated testing of report exporting functionality according to claim 1, wherein said step of comparing said first picture to said second picture comprises:
determining a comparison algorithm, and performing corresponding preprocessing on the first picture and the second picture by using the comparison algorithm;
and comparing the first picture and the second picture after the preprocessing by using the comparison algorithm.
4. The automated testing method of report exporting functionality according to claim 3, wherein said step of comparing said first picture to said second picture comprises:
determining that a comparison algorithm is a structural similarity index algorithm, setting the first picture and the second picture as preset sizes and carrying out graying processing;
and comparing the grayed first picture and the second picture with preset sizes by using the structural similarity index algorithm.
5. The method for automated testing of report exporting functionality according to claim 4, wherein said step of determining a difference area between said first picture and said second picture further comprises, prior to said step of:
comparing the first picture with the second picture by using the structural similarity index algorithm, and determining the similarity between the first picture and the second picture;
and if the similarity does not meet a preset value, determining a difference area between the first picture and the second picture.
6. The method for automated testing of report exporting functionality according to claim 1, wherein said step of determining a difference area between said first picture and said second picture further comprises, after said step of determining a difference area between said first picture and said second picture:
identifying the difference areas on the first picture and the second picture to respectively obtain a first marked picture and a second marked picture;
and combining the first marked picture and the second marked picture to obtain a test result picture.
7. The method for automatically testing report exporting capability according to claim 6, wherein after said step of combining said first marked picture and said second marked picture to obtain a test result picture, further comprising:
and outputting the test result and the test result picture as a test report, and sending the test report to an automatic test related party with a report export function.
8. The utility model provides an automatic testing arrangement of report export function which characterized in that, automatic testing arrangement of report export function includes:
the first picture conversion module is used for acquiring a first report when the report export function is normal, exporting the first report to obtain a first display file, and converting the first display file into a first picture;
the second picture conversion module is used for acquiring a second report form with an updated version, exporting the second report form to obtain a second display file, and converting the second display file into a second picture;
and the determining module is used for comparing the first picture with the second picture, determining a difference area between the first picture and the second picture, and determining whether the current report exporting function is normal or not according to the difference area.
9. An automated test equipment for report export functionality, the automated test equipment comprising: memory, processor and computer program stored on the memory and executable on the processor, the computer program being configured to implement the steps of the automated testing method of report exporting functionality according to any of claims 1 to 7.
10. A computer-readable storage medium, characterized in that a computer program is stored on the computer-readable storage medium, which computer program, when being executed by a processor, carries out the steps of the method for automated testing of report exporting functionality according to any of the claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210823502.9A CN114896175A (en) | 2022-07-14 | 2022-07-14 | Automatic test method, device, equipment and medium for report export function |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210823502.9A CN114896175A (en) | 2022-07-14 | 2022-07-14 | Automatic test method, device, equipment and medium for report export function |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114896175A true CN114896175A (en) | 2022-08-12 |
Family
ID=82730334
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210823502.9A Pending CN114896175A (en) | 2022-07-14 | 2022-07-14 | Automatic test method, device, equipment and medium for report export function |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114896175A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117095418A (en) * | 2023-10-18 | 2023-11-21 | 深圳迅策科技有限公司 | Table comparison method and device based on picture pixel difference |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106598763A (en) * | 2016-12-09 | 2017-04-26 | 四川长虹电器股份有限公司 | Method for testing BI report |
| CN110955603A (en) * | 2019-12-03 | 2020-04-03 | 望海康信(北京)科技股份公司 | Automatic testing method and device, electronic equipment and computer readable storage medium |
| CN111966600A (en) * | 2020-08-31 | 2020-11-20 | 平安健康保险股份有限公司 | Webpage testing method and device, computer equipment and computer readable storage medium |
| CN112346911A (en) * | 2020-11-24 | 2021-02-09 | 星云海数字科技股份有限公司 | Report data statistical function testing method and system |
| US20210142242A1 (en) * | 2019-11-11 | 2021-05-13 | Jpmorgan Chase Bank, N.A. | System and method for implementing smart business intelligence testing tools |
| CN113946510A (en) * | 2021-10-14 | 2022-01-18 | 中国平安财产保险股份有限公司 | WEB page testing method, device and equipment and computer storage medium |
-
2022
- 2022-07-14 CN CN202210823502.9A patent/CN114896175A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106598763A (en) * | 2016-12-09 | 2017-04-26 | 四川长虹电器股份有限公司 | Method for testing BI report |
| US20210142242A1 (en) * | 2019-11-11 | 2021-05-13 | Jpmorgan Chase Bank, N.A. | System and method for implementing smart business intelligence testing tools |
| CN110955603A (en) * | 2019-12-03 | 2020-04-03 | 望海康信(北京)科技股份公司 | Automatic testing method and device, electronic equipment and computer readable storage medium |
| CN111966600A (en) * | 2020-08-31 | 2020-11-20 | 平安健康保险股份有限公司 | Webpage testing method and device, computer equipment and computer readable storage medium |
| CN112346911A (en) * | 2020-11-24 | 2021-02-09 | 星云海数字科技股份有限公司 | Report data statistical function testing method and system |
| CN113946510A (en) * | 2021-10-14 | 2022-01-18 | 中国平安财产保险股份有限公司 | WEB page testing method, device and equipment and computer storage medium |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117095418A (en) * | 2023-10-18 | 2023-11-21 | 深圳迅策科技有限公司 | Table comparison method and device based on picture pixel difference |
| CN117095418B (en) * | 2023-10-18 | 2024-03-01 | 深圳迅策科技有限公司 | Table comparison method and device based on picture pixel difference |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108958736B (en) | Page generation method and device, electronic equipment and computer readable medium | |
| CN109614424B (en) | Page layout generation method, device, computing equipment and medium | |
| CN111553131B (en) | PSD file analysis method, device, equipment and readable storage medium | |
| CN107273104B (en) | Processing method and device for configuration data structure | |
| CN113808231A (en) | Information processing method and device, image rendering method and device, and electronic device | |
| CN113741898B (en) | Form generation method, device and equipment | |
| CN114896175A (en) | Automatic test method, device, equipment and medium for report export function | |
| CN106919406A (en) | A kind of desktop application component issue, update method and device | |
| JP2021006982A (en) | Method and device for determining character color | |
| CN115455135A (en) | Visual automatic modeling method and device, electronic equipment and storage medium | |
| CN112433713A (en) | Application program design graph processing method and device | |
| CN111158842A (en) | Operation flow detection method, device and storage medium | |
| CN115758005A (en) | Large-screen image processing method, device and medium | |
| CN115756461A (en) | Annotation template generation method, image identification method and device and electronic equipment | |
| CN115480940A (en) | Page calling method, device and medium for financial ratio indexes | |
| CN115657899A (en) | Icon processing method and device, electronic equipment and storage medium | |
| CN113238942A (en) | User interface testing method and device, electronic equipment and storage medium | |
| CN112947918A (en) | Data display method and device | |
| CN114237795A (en) | Terminal interface display method and device, electronic equipment and readable storage medium | |
| CN113626022A (en) | Object model creating method and device, storage medium and electronic equipment | |
| CN112261227A (en) | Method for multi-screen equal-proportion adaptation of mobile terminal | |
| CN112163151A (en) | Simulation recommendation method, computer equipment and storage medium | |
| CN110674119A (en) | Data processing method, system and computer readable storage medium | |
| CN110633197A (en) | Method and device for detecting excessive drawing | |
| CN113468460B (en) | Method, device and equipment for rendering Web page based on YAML (Yaml language) |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20220812 |
|
| RJ01 | Rejection of invention patent application after publication |