Automatic test method and system for power transmission monitoring and shooting device

Abstract

The invention relates to an automatic testing method and system for a power transmission monitoring and photographing device, and the method comprises the steps: writing a software package updating script through simulating the behavior of a user according to the page element position of a client browser of the power transmission monitoring and photographing device, and carrying out the updating of built-in software of the device; acquiring an ID number, a sim card number and a communication plan of the power transmission monitoring and photographing device and an account number and a password required for network connection, summarizing the ID number, the sim card number and the communication plan into a table, and obtaining a configuration file for realizing network connection of the power transmission monitoring and photographing device according to a generated summary table file path, a configuration file template for realizing network connection of the monitoring and photographing device and connection mode information; further compiling into a batch processing file; and based on the batch processing file for realizing the network connection, performing function test on the built-in software of the power transmission monitoring and shooting device by utilizing the automatic test script to obtain test results, generating a corresponding test report, and classifying the test results.

Description

Technical Field

[0001] The present invention relates to the technical field of software testing, and specifically to an automated testing method and system for a power transmission monitoring device. Background Art

[0002] The statements in this part only provide background technical information related to the present invention, and do not necessarily constitute prior art.

[0003] A power transmission monitoring device is a device for improving the efficiency of power transmission line inspection operations. Through this device, 24-hour all-weather real-time inspection and autonomous early warning can be achieved. Most of the software built into the power transmission monitoring device is developed by combining the B / S architecture (i.e., the browser / server mode) and Web applications, and its performance is ensured to be stable and reliable through continuous iterative updates. And every time the software is updated, regression testing needs to be carried out on the software to timely discover defects in the software.

[0004] Due to the short release cycle and fast update iteration of the Web application software of the power transmission monitoring device, it directly leads to the complication of the detection process and the increase in workload. If testers still adopt the method of manual testing for testing, not only is the efficiency low, but there are also many limitations, such as missed testing, wrong testing, etc., which cannot meet the requirements of complex Web application testing tasks. Summary of the Invention

[0005] In order to solve the technical problems existing in the above background art, the present invention provides an automated testing method and system for a power transmission monitoring device, which combines testing tools and programming languages to automatically simulate user interactions and verify the perfection, accuracy, and stability of the application software functions.

[0006] In order to achieve the above object, the present invention adopts the following technical solutions:

[0007] The first aspect of the present invention provides an automated testing method for a power transmission monitoring device, including the following steps:

[0008] According to the positions of page elements of the power transmission monitoring device client in the browser, write a software package update script by simulating user behaviors;

[0009] Obtain the ID number, sim card number, communication plan of the power transmission monitoring device, as well as the account and password required for connecting to the network, and summarize them in a table. Based on the VBA language and the generated summary table file path, determine the configuration file template and connection mode information for the monitoring device to achieve network connection, obtain the configuration file for the power transmission monitoring device to achieve network connection, and further write it as a batch file for realizing automatic network connection;

[0010] Based on a batch file for implementing network connection, use an automated test script to update and perform functional tests on the built-in software of the power transmission monitoring device, obtain test results, generate corresponding test reports, and classify the test results.

[0011] Furthermore, according to the page element positions in the client browser of the power transmission monitoring device, write a software package update script by simulating user behaviors; including: invoking the recording function of an automated test tool, and generating a corresponding update script by simulating user behaviors such as user login, clicking on the device management tab, and clicking on the administrator logout tab through the recording function.

[0012] Furthermore, according to the page element positions in the client browser of the power transmission monitoring device, write a software package update script by simulating user behaviors; also including: invoking an automated test tool, writing time waiting commands for the startup and program update of the power transmission monitoring device, waiting for target elements to appear, simulating the input of text in the search box by the user, scripts for outputting update status reports, and JavaScript statements for modifying the web page CSS styles to form corresponding update scripts.

[0013] Furthermore, the batch file includes instructions for generating and importing configuration files, instructions for connecting to a wireless local area network, and instructions for controlling the display of the COM window.

[0014] Furthermore, based on a batch file for implementing network connection, use an automated test script to update and perform functional tests on the built-in software of the power transmission monitoring device; including: using the batch file to connect the power transmission monitoring device to the network and update the built-in software of the power transmission monitoring device, and using the test script to perform functional tests on the device's built-in software.

[0015] Furthermore, based on a batch file for implementing network connection, use an automated test script to update and perform functional tests on the built-in software of the power transmission monitoring device; also including: using the automated test script to simulate the user clicking on the information tab, clicking on the functions of taking pictures, recording videos, alarming, one-key video recording, and sound collection of the test monitoring device, capturing and determining the working status information of the power transmission monitoring device and the version information of the built-in software, and outputting the test report in text form.

[0016] Furthermore, the working status information of the power transmission monitoring device at least includes battery voltage, battery power, charging status, and CPU temperature.

[0017] The second aspect of the present invention provides an automated test system for a power transmission monitoring device, including:

[0018] A software update module, configured to: write a software package update script by simulating user behaviors according to the page element positions in the client browser of the power transmission monitoring device;

[0019] The connection module is configured to: obtain the ID number, SIM card number, communication plan of the power transmission monitoring device, as well as the account and password required for network connection, and summarize them into a table. Based on the VBA language and the generated summary table file path, determine the configuration file template and connection mode information for the monitoring device to achieve network connection, obtain the configuration file for the power transmission monitoring device to achieve network connection, and further compile it into a batch file for realizing automatic network connection;

[0020] The function test module is configured to: based on the batch file for realizing network connection, use the automatic test script to update and test the functions of the built-in software of the power transmission monitoring device, obtain the test results and generate corresponding test reports, and classify the test results.

[0021] The third aspect of the present invention provides a computer-readable storage medium, on which a computer program is stored, and when the program is executed by a processor, the steps in the above-mentioned automatic test method for the power transmission monitoring device are realized.

[0022] The fourth aspect of the present invention provides a computer device, including a memory, a processor, and a computer program stored on the memory and executable on the processor. When the processor executes the program, the steps in the above-mentioned automatic test method for the power transmission monitoring device are realized.

[0023] Compared with the prior art, the above one or more technical solutions have the following beneficial effects:

[0024] 1. Through the automatic test tool and VBA technology, a complex automatic test process for the power transmission monitoring device is realized, effectively integrating different types of test tasks of the same device, facilitating the management and maintenance of test cases, being able to simulate the interaction between the user and the software of the power transmission monitoring device, execute repetitive test tasks, greatly reducing the repetitive labor of testers, significantly improving the execution speed of testing, and reducing the impact of test costs and work errors.

[0025] 2. When the software of the power transmission monitoring device is updated or upgraded, only a small amount of modification to the automatic test script is required to adapt to the new software version, greatly reducing the maintenance workload and cost of testing.

[0026] 3. During automatic testing, in addition to being able to store the test results in the log, the test results can also be presented in the form of a prompt box on the web page in real time, facilitating testers to timely discover the functional defects of the software of the power transmission monitoring device. BRIEF DESCRIPTION OF THE DRAWINGS

[0027] The specification drawings constituting a part of the present invention are used to provide a further understanding of the present invention. The schematic embodiments of the present invention and their descriptions are used to explain the present invention and do not constitute an improper limitation to the present invention.

[0028] Figure 1 It is a schematic diagram of the architecture of the automated test method for the transmission monitoring and photographing device provided by one or more embodiments of the present invention;

[0029] Figure 2 It is a schematic diagram of the functional module structure of the automated test system for the transmission monitoring and photographing device provided by one or more embodiments of the present invention;

[0030] Figure 3 It is a schematic diagram of the architecture of Selenium WebDriver provided by one or more embodiments of the present invention. Specific embodiments

[0031] The present invention will be further described below in conjunction with the accompanying drawings and embodiments.

[0032] It should be noted that the following detailed descriptions are all exemplary and are intended to provide further descriptions of the present invention. Unless otherwise specified, all technical and scientific terms used herein have the same meaning as commonly understood by those of ordinary skill in the technical field to which the present invention belongs.

[0033] Selenium is a set of powerful automated software tools that can be used in combination with many browsers, operating systems, and programming languages, and can be used to support the development of automated test tools for web applications.

[0034] VBA (Visual Basic for Applications) is an event-driven programming language that can be used to write automated scripts for controlling related applications.

[0035] As introduced in the background art, the software built into the transmission monitoring and photographing device needs to be updated frequently, resulting in low efficiency during testing. Therefore, the following embodiments propose an automated test method and system for the transmission monitoring and photographing device, which combines the characteristics of Selenium and VBA to achieve automatic simulation of user interactions and verify the perfection, accuracy, and stability of the application software functions.

[0036] Embodiment 1:

[0037] Write a software package update script by simulating user behavior according to the positions of page elements of the transmission monitoring and photographing device client in the browser;

[0038] Obtain the ID number, sim card number, communication plan of the transmission monitoring and photographing device, as well as the account and password required to connect to the network, and summarize them in a table. Based on the VBA language and the generated summary table file path, determine the configuration file template and connection mode information for the monitoring and photographing device to achieve network connection, obtain the configuration file for the transmission monitoring and photographing device to achieve network connection, and further write it as a batch file for automatic network connection;

[0039] Based on a batch file for implementing network connection, the built-in software of the power transmission monitoring device is updated and functionally tested using an automated test script, and the test results are obtained and a corresponding test report is generated, and the test results are classified.

[0040] In this embodiment, the software package update script is a series of click actions to complete the software update. The software package to be updated is saved locally and data is uploaded through connection with the device via the local network port.

[0041] The VBA script for wireless network access is used during functional testing. Functional testing needs to be completed: wireless network connection with the device (VBA script), detection of device status and functions (Selenium automated test script).

[0042] The basic process is: first complete the update (script 1), and then test (connect to wireless - script 2, execute test - script 3).

[0043] This embodiment provides an automated test method for the functions of the power transmission monitoring device, including two parts: software package update and functional testing. As Figure 1 shown, the software package update part includes the following steps:

[0044] Step 1: Enable the automated test tool. In this embodiment, the tool "SeleniumIDE" is taken as an example. This tool provides a graphical user interface, allowing users to record and playback test cases through click operations and integrating it in the browser in the form of a browser plugin, supporting multiple browsers, such as Chrome, Firefox, and Edge. SeleniumIDE can be loaded through the built-in plugin function of the browser. For example, by accessing the browser's WebStore and searching for "SeleniumIDE" and installing and starting it according to the prompts.

[0045] Step 2: Record and write the software package update script for the functions of the power transmission monitoring device, including a recording part and a writing part.

[0046] The script of the recording part completes the text input of the user login account password and the tab click function on the browser by using the Selenium IDE plugin (this plugin supports the recording function), thereby automatically generating the script.

[0047] The script of the writing part is to supplement and write time waiting commands, the part waiting for the target element to appear after clicking the tab, modifying the CSS style to ensure the floating tab appears, etc. in the Selenium IDE plugin according to actual needs. The writing part aims to improve the software package automatic update script to avoid program crashes and the inability to successfully complete the expected software package update.

[0048] In this embodiment, the recording function is used to record behaviors such as text input of the user login account password, clicking on the device management tab, and clicking on the administrator logout tab, and generate a corresponding software package update script. At the same time, based on this script, time waiting commands for device startup and program update, loop clicking, waiting for the target element to appear, simulating the user to input text in the search box, scripts for updating status report output, and JavaScript statements for modifying the web page CSS style are written to improve the software package automatic update script.

[0049] Step 3: Connect the network interface and execute the software package automatic update script. Connect the local network port to the device through an RJ45 adapter cable and execute the update script generated by recording and writing.

[0050] Step 4: Check the software package automatic update report. View the software update status success indication flag and update error record in the report in Selenium IDE.

[0051] Step 5: After the software package program update is completed, use the update script edited in Step 2 to update the next device.

[0052] The functional test part includes the following steps:

[0053] Step 1: Obtain and summarize the information of the transmission monitoring device, specifically including the PMSID number of the monitoring device (the ID number of the device in the engineering project management system), WIFI account and password, sim card number, communication plan, etc. Summarize the information in Excel for unified management and the development of VBA macro scripts.

[0054] Step 2: Write a VBA script for automatic one-key connection of the device. Write a VBA script in a spreadsheet software (such as Microsoft Excel), specifically including:

[0055] Generate the file path where the device information summary table is located in the spreadsheet;

[0056] According to the generated summary table file path, the configuration file template for WIFI connection of the monitoring device, the WIFI account password and connection mode information of the device, write the corresponding WIFI configuration file for the device; in this embodiment, the configuration file is an xml file;

[0057] Write a batch file (.bat file) according to the WIFI configuration file, including instructions for xml configuration generation and import, instructions for wlan connection, and instructions for controlling the appearance of the COM window.

[0058] In the above steps, the script written in VBA language can complete the automatic network connection. Taking the automatic connection of the wireless network as an example: the wireless account of each surveillance camera device is an ID number, such as 60624730010446572, 60624730010446515, 60624730010446504. Information such as the wireless password, communication plan information, and test records of these devices will be sent to the testers in the form of a table in groups. Usually, there are hundreds of devices transferred in batches, and the quantity is huge and they are all in the powered-on state (wireless enabled). At this time, if manually locate the wireless account according to the table order and manually enter the password, the efficiency is too low and errors are likely to occur.

[0059] The script written in VBA language in this embodiment can complete the automatic network connection, which can not only improve the efficiency, but also reduce the error rate, and is easy to integrate with the existing system. Specifically:

[0060] 1. Improve efficiency: Using VBA language to implement the automatic connection of the wireless network can improve the efficiency for the problem of connecting the wireless accounts of a large number of surveillance camera devices, realize the automatic configuration of the wireless password in a fast batch, and greatly reduce the time required for manual input.

[0061] 2. Reduce the error rate: Manual input of information is prone to human errors, such as mistyping numbers or letters. Using the VBA script for automatic connection can ensure that the information is accurately applied to each device because the data directly comes from the pre-prepared table, avoiding the possibility of human error.

[0062] 3. Easy to integrate with the existing system: The information of the surveillance camera devices is usually sorted by office software (such as the Office suite) and often uses spreadsheet software (such as Excel) for data management and analysis. Using VBA can directly interface seamlessly with these existing office software, conveniently read and write the data in the table, thus simplifying the entire work process.

[0063] Step 3: Conduct functional tests based on the Selenium automation script. The script includes using the Selenium API of the programming language used to simulate clicking on the information tab, clicking on functions such as taking pictures, recording videos, alarming, one-key video recording, and sound collection of the tested surveillance camera devices, and capturing and judging the normality of the device working status information, such as battery voltage, battery power, charging status, CPU temperature, etc.

[0064] Specifically, for some information that is not directly displayed as an element on a web page, that is, this data is dynamically loaded from the server through AJAX or other asynchronous requests, but can be obtained through a POST request. In order to access this information in automated testing or data scraping, use the web request API in the programming language adopted (such as the requests library in the Python language) to simulate a POST request and process the response. For example, dynamically loaded information such as software version numbers, background addresses, and port numbers.

[0065] Secondly, it includes the output of the test report, which outputs the test report in the form of direct display on a web page, display in a COM window, or text saving. The test report should at least include the device ID number, the working status information of the device, the inspector information, problem records, and the inspection time.

[0066] Step 4: The tester can check the test results displayed on the web page or in the COM window, check the test report exported in text form, determine the perfection of the device function, record and group the problematic ones, so as to complete the function test of the power transmission monitoring device and classify and store it out of the warehouse.

[0067] By comprehensively using Selenium and VBA technologies to implement a complex automated testing process for power transmission monitoring devices, it effectively integrates different types of test tasks for the same device, facilitating the management and maintenance of test cases. It can simulate the interaction between users and the power transmission monitoring device software, execute repetitive test tasks, greatly reduce the repetitive labor of testers, significantly improve the execution speed of testing, and reduce the impact of testing costs and work errors.

[0068] When the software of the power transmission monitoring device is updated or upgraded, only a small modification to the automated test script is required to adapt to the new software version, greatly reducing the maintenance workload and cost of testing.

[0069] During automated testing, in addition to being able to store the test results in the log, they can also be presented in the form of a prompt box on the web page in real time, facilitating testers to promptly discover functional defects in the power transmission monitoring device software.

[0070] Example Two:

[0071] The automated testing system for power transmission monitoring devices includes:

[0072] A software update module, configured to: write a software package update script by simulating the behavior of users according to the position of page elements of the power transmission monitoring device client in the browser;

[0073] The connection module is configured to: obtain the ID number, SIM card number, communication plan of the power transmission monitoring device, as well as the account and password required for network connection, and summarize them into a table. Based on the VBA language and the generated summary table file path, determine the configuration file template and connection mode information for the monitoring device to achieve network connection, obtain the configuration file for the power transmission monitoring device to achieve network connection, and further compile it into a batch file for automatic network connection;

[0074] The function test module is configured to: based on the batch file for network connection, use an automatic test script to update and test the built-in software of the power transmission monitoring device, obtain the test results and generate corresponding test reports, and classify the test results.

[0075] As Figure 2 shown, according to the idea of hierarchical design and different characteristics of system testing, the automatic testing system of the power transmission monitoring device is divided into an automatic software update module based on SeleniumIDE, a WIFI automatic connection module based on VBA, and a device function automatic testing module based on Selenium.

[0076] The automatic software update module based on SeleniumIDE includes an information configuration layer, a page location layer, and a page operation layer. The information configuration layer configures the local address where the software package is stored and the device URL information to be accessed. The page location layer locates the positions of the ID, CSS, and linkText information of the web page elements through the built-in browser driver of SeleniumIDE. The page operation layer performs operations such as text input, click, and display of hidden drop-down menus.

[0077] The WIFI automatic connection module based on VBA includes a device information configuration layer, an xml file configuration layer, and a bat file configuration layer. The device information configuration layer configures information such as the PMSID information of the monitoring device, the WI FI account and password, the SIM card number, and the communication plan. The xml file configuration layer configures the settings for wireless network connection, including information such as SSID, password (encrypted), and security type. The bat file configuration layer configures the cmd commands for wireless connection, including commands for xml configuration import, wlan connection, and control of the CO M window display.

[0078] The device function automated testing module based on Selenium includes a driver configuration layer, a page location layer, a page operation layer, and a test report layer. The driver configuration layer configures the Selenium browser driver to be used. The basic configuration layer configures the software version number to be checked, the background address, background port, and protocol type to be uploaded. The page location layer configures the ID, CSS, and link Text elements of the web page to be located. The service request layer uses the request API in the adopted programming language (such as the requests library in Python language) to simulate POST requests and process responses, so as to obtain element information such as software version number information, background address, and port number that are not directly displayed on the web page. The page operation layer then performs operations such as clicking and showing hidden drop-down menus. The test report layer outputs the results of the function test, and the results are presented in the form of text and web page elements.

[0079] As Figure 3 shown, the Selenium architecture includes programming language bindings, browser drivers, and web browsers. Selenium WebDriver provides bindings for multiple programming languages. Common programming language bindings include: Python, JavaScript,.NET / C#, Ruby. These bindings provide interfaces to the Selenium WebDriver API. In this embodiment, the test script is written in Python language, but the provided methods and systems allow the use of the syntax and features of the above various programming languages to write test scripts, as long as the corresponding API interfaces are used. The browser driver is a key component for interacting with specific browsers. Each browser has a corresponding driver program to control instances of that browser. Commonly used browsers include Chrome, Edge, Firefox, and Safari information.

[0080] Embodiment 3:

[0081] This embodiment provides a computer-readable storage medium, on which a computer program is stored. When the program is executed by a processor, it implements the steps in the automated testing method of the power transmission monitoring device as described in Embodiment 2 above.

[0082] Embodiment 4:

[0083] This embodiment provides a computer device, including a memory, a processor, and a computer program stored on the memory and executable on the processor. When the processor executes the program, it implements the steps in the automated testing method of the power transmission monitoring device as described in Embodiment 2 above.

[0084] The steps involved in the second to fourth embodiments above correspond to those in the first embodiment. For specific implementation manners, reference may be made to the relevant description part of the first embodiment. The term "computer-readable storage medium" should be understood to include a single medium or multiple media containing one or more instruction sets; it should also be understood to include any medium that can store, encode, or carry an instruction set for execution by a processor and cause the processor to execute any method in the present invention.

[0085] The foregoing is only a preferred embodiment of the present invention and is not intended to limit the present invention. For those skilled in the art, various modifications and variations can be made to the present invention. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention shall be included within the protection scope of the present invention.

Claims

1. An automated testing method for a power transmission monitoring device, characterized in that: The following steps are involved: According to the page element position of the client browser of the power transmission monitoring device, write the software package update script by simulating the user's behavior; The ID number, SIM card number, communication plan, and account and password required to connect to the network of the power transmission monitoring device are obtained, and the results are summarized in a table. Based on the VBA language and the generated summary table file path, the configuration file template and connection mode information of the monitoring device to achieve network connection, the configuration file for the power transmission monitoring device to achieve network connection is obtained, and further compiled into a batch file for achieving automatic network connection. Based on the batch files for realizing network connection, the built-in software of the power transmission monitoring device is functionally tested using the automatic test script, the test results are obtained, the corresponding test report is generated, and the test results are classified.

2. The automatic testing method for a power transmission monitoring device according to claim 1, characterized in that: According to the page element position of the client browser of the power transmission monitoring device, a software package update script is written by simulating user behavior; including: calling the recording function of the automatic testing tool, simulating the user behavior of user login, device management tab click and administrator exit tab click through the recording function, and generating a corresponding update script.

3. The automatic testing method for a power transmission monitoring device according to claim 1, characterized in that: According to the page element position of the client browser of the power transmission monitoring device, a software package update script is written by simulating the user's behavior; it also includes: calling the automatic testing tool, writing the time waiting command for the power transmission monitoring device to start and update the program, waiting for the target element to appear, simulating the user to enter text in the search box, updating the status report output script and modifying the JavaScript statement of the CSS style of the web page to form a corresponding update script.

4. The automatic testing method for a power transmission monitoring device according to claim 1, characterized in that: Batch files include commands for generating and importing configuration files, commands for connecting to wireless LAN, and commands for controlling the display of COM windows.

5. The automatic testing method for a power transmission monitoring device according to claim 1, characterized in that: Based on the batch file that realizes the network connection, the built-in software of the power transmission monitoring device is updated and the function is tested by using the automatic test script; including: using the batch file to connect the power transmission monitoring device to the network and update the built-in software of the power transmission monitoring device, and using the test script to execute the function test of the built-in software of the device.

6. The automatic testing method for a power transmission monitoring device according to claim 1, characterized in that: Based on the batch files that realize network connection, the built-in software of the power transmission monitoring device is updated and functionally tested using the automatic test script; it also includes: using the automatic test script to simulate the user clicking on the information tab, clicking on the test monitoring device's photo taking, video recording, alarm, one-key video recording, and sound collection functions, capturing and identifying the working status information of the power transmission monitoring device and the version information of the built-in software, and outputting the test report in text form.

7. The automatic testing method for a power transmission monitoring device according to claim 1, characterized in that: The working status information of the power transmission monitoring device includes at least battery voltage, battery power, charging status and CPU temperature.

8. The automatic test system for power transmission monitoring device is characterized by: include: The software update module is configured to: write a software package update script by simulating user behavior according to the page element position of the power transmission monitoring device client in the browser; The connection module is configured to: obtain the ID number, SIM card number, communication plan, and account number and password required for connecting to the network of the power transmission monitoring device, and summarize them in a table; based on the VBA language and the generated summary table file path, determine the configuration file template and connection mode information for the monitoring device to achieve network connection, obtain the configuration file for the power transmission monitoring device to achieve network connection, and further compile it into a batch file for realizing automatic network connection; The functional test module is configured as follows: based on a batch file for realizing network connection, using an automatic test script to update and perform functional tests on the built-in software of the power transmission monitoring device, obtain test results and generate corresponding test reports, and classify the test results.

9. A computer-readable storage medium, characterized in that: A computer program is stored thereon, and when the program is executed by a processor, the steps in the automated testing method for a power transmission monitoring device as described in any one of claims 1-7 are implemented.

10. A computer device, characterized in that: It includes a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the program, the steps in the automated testing method for a power transmission monitoring device as described in any one of claims 1 to 7 are implemented.

Images