Method and system for testing terminal communication based on SQL (Structured Query Language) database

Abstract

The invention discloses a terminal communication test method and system based on an SQL database. The method comprises the following steps: determining test content; establishing a relation between the terminal and a computer with a preset SQL database through serial port communication, wherein a plurality of simulation meters of the SQL database are respectively used for simulating a plurality of electric energy meters; when multi-protocol analysis reply is carried out, received data frame protocols are distinguished and analyzed firstly and stored in a structural body, then the data frame protocols enter different processing function trees to be processed one by one, reply information frames are established, and finally information is replied through a serial port. Editing the running state of the simulation meter, and simulating the running state of at least one electric energy meter; and enabling the terminal to send a message of the collection task to each simulation table, or / and each simulation table to report timed freezing data or table data to the terminal. According to the invention, the test cost and the site demand are reduced, the test time is shortened, the test can be carried out quickly, conveniently and clearly, and the test efficiency is improved.

Description

Technical Field

[0001] The present invention relates to a terminal communication test method in the technical field of power systems, particularly to a terminal communication test method based on an SQL database, and also to a terminal communication test system based on an SQL database. Background Art

[0002] Special transformer terminals and concentrators are important intelligent devices in power systems, mainly used for the acquisition, monitoring, and control of electricity consumption data. Special transformer terminals (special transformer user electricity management terminals) are usually installed on special transformers, responsible for real-time acquisition of electricity consumption data such as voltage, current, and power, and performing functions such as remote meter reading, load control, and anti-stealing electricity, helping power companies efficiently manage the electricity consumption of large industrial users. Concentrators are mostly used in residential areas or low-voltage distribution networks. As data transfer stations, they can collect information from multiple electricity meters at the same time and upload the data to the main station through communication methods such as 4G and carrier waves to achieve remote centralized meter reading and electricity consumption analysis. Both support intelligent functions (such as abnormal alarm, remote upgrade) and are key devices for building smart grids and realizing refined energy management.

[0003] Electric energy meter data acquisition is an important function of special transformer terminals or concentrators and requires comprehensive and multiple tests. Currently, during communication tests, multiple electric energy meters need to work together for information acquisition and interaction. Testing in different scenarios requires a lot of time and space, slowing down the work progress and increasing the work cost. Summary of the Invention

[0004] To solve the technical problems of the existing terminal communication test methods being time-consuming, laborious, and having high test costs, the present invention provides a terminal communication test method and system based on an SQL database.

[0005] The present invention is implemented by the following technical solutions: A terminal communication test method based on an SQL database, which includes the following steps:

[0006] Determine the test content;

[0007] Establish a connection between the terminal and a computer with a pre-set SQL database through serial communication. Multiple simulation tables in the SQL database are respectively used to simulate multiple electric energy meters, and each simulation table stores all the data of the corresponding electric energy meter;

[0008] When performing multi-protocol parsing and reply between the terminal and the SQL database, first distinguish and parse the received data frame protocol, store the parsing result in the created structure, then enter different processing function trees according to the structure information for processing one by one, form a reply information frame, and finally reply the information through the serial port;

[0009] Edit the running status of the simulation meter to simulate the status when at least one electricity meter is running;

[0010] According to the test content, enable the terminal to send a message for the acquisition task to each simulation meter, and / or each simulation meter reports the timed frozen data or meter data to the terminal, so as to implement the simulation communication test between the terminal and multiple electricity meters.

[0011] In the present invention, by establishing a serial port communication between a computer and a terminal, multiple simulation meters in an SQL database in the computer are respectively used to simulate multiple electricity meters, and the running status of the electricity meters is simulated by the simulation meters, so as to realize the message interaction between the terminal and the simulation meters. That is, only one computer needs to work to simulate the communication status when multiple electricity meters are working, and the test scenario can be changed at any time. Compared with the ordinary terminal communication test method, the present invention reduces the test cost and site requirements, shortens the test time, quickly promotes the process, and solves the technical problems of the existing terminal communication test method being time-consuming, laborious, and having a high test cost.

[0012] As a further improvement of the above solution, when the terminal issues an acquisition task, each simulation meter defines two timestamps. The first timestamp is the simulation meter time, and the second timestamp is the real time obtained from the computer when writing the first timestamp.

[0013] As a further improvement of the above solution, when performing serial port communication, a separate process is created, and according to the set parameters, the process always receives data frames or sends data.

[0014] As a further improvement of the above solution, the structural rules followed by the structure include: (1) using an unsigned char string to identify the type of the currently active member; (2) encapsulating multiple members using a union type, and cooperating with the unsigned char string to identify the currently used member; (3) using a structure pointer for the members of the large structure, and dynamically allocating memory when storing data.

[0015] Among them, after the multi-protocol parsing and reply, the memory allocated in the structure is released; when the multi-protocol parsing is completed and replied, each simulation meter judges whether the address conforms. If it conforms, a reply is made; otherwise, no reply is made.

[0016] As a further improvement of the above solution, the column headers of each simulation meter include time, row object identifier, row object attribute, column object attribute, data type, and data content; among them, the time column is used to store the timestamp of the meter time corresponding to the record of the corresponding row data, and when the timestamp is 0, it represents the current meter status.

[0017] As a further improvement of the above solution, the terminal communication test method further includes the following steps:

[0018] Establish a human-computer interaction interface; the user operation items of the interface include: (1) setting serial port parameters and connecting to the serial port; (2) viewing and recording communication data; (3) creating or eliminating an analog meter, powering on or off an analog meter; (4) viewing all data in the SQL database and being able to change, replace, copy, and delete the data of each analog meter.

[0019] Further, when the system time reaches a predetermined time node, a freeze task or a reporting mechanism is automatically triggered, and every time the time changes, it is judged whether it is a whole time node by the method of taking the remainder.

[0020] As a further improvement of the above solution, the terminal is connected to the computer through a USB-485 serial port, and message reply is carried out through the 698 or 645 protocol.

[0021] As a further improvement of the above solution, the terminal is a dedicated transformer terminal or a concentrator.

[0022] The present invention also provides a terminal communication test system based on an SQL database, which includes:

[0023] A test input module, which is used to determine the test content;

[0024] A serial port communication module, which is used to establish a connection between the terminal and a computer with a preset SQL database through serial port communication. Multiple analog meters in the SQL database are respectively used to simulate multiple electric energy meters, and each analog meter stores all data of the corresponding electric energy meter;

[0025] An analysis and reply module, which is used to first distinguish and analyze the data frame protocol received during multi-protocol analysis and reply between the terminal and the SQL database, store the analysis result in a created structure, then enter different processing function trees according to the structure information for processing one by one, form a reply information frame, and finally reply the information through the serial port;

[0026] A simulation operation module, which is used to edit the operation state of the analog meter and simulate the state when at least one electric energy meter is running;

[0027] A communication test module, which is used to make the terminal send a message of a collection task to each analog meter according to the test content, and / or, each analog meter reports timed freeze data or table data to the terminal, so as to realize the simulation communication test between the terminal and multiple electric energy meters.

[0028] Compared with the existing terminal communication test system, the terminal communication test method and system based on the SQL database of the present invention have the following beneficial effects:

[0029] 1. The terminal communication test method based on the SQL database establishes serial communication between a computer and a terminal, uses multiple simulation tables in the SQL database in the computer to simulate multiple electric energy meters respectively, and uses virtual tables to simulate the operating states of actual electric energy meters, so as to realize the message interaction between the terminal and the simulation tables. That is, only one computer needs to work to simulate the communication conditions when multiple electric energy meters are working, and the test scenario can be changed at any time. Compared with the ordinary terminal communication test method, the present invention reduces the test cost and site requirements, shortens the test time, quickly promotes the test process, and solves the technical problems of the existing terminal communication test method being time-consuming, laborious, and having a high test cost.

[0030] 2. The terminal communication test method based on the SQL database consists of serial communication, parsing and reply of 698 and 645 protocols, data access and storage in the SQL database, simulation of time and operation of reporting tasks, human-computer operation interaction interface, etc. Compared with traditional entities, it is more convenient, the operation is more flexible, it is a great help to testers, the test is more intuitive, communication problems can be detected faster, and at the same time, parameter setting is also simpler and more convenient, and the entire test can be completed by one person, and the test efficiency is significantly improved. BRIEF DESCRIPTION OF THE DRAWINGS

[0031] Figure 1 is a flowchart of the terminal communication test method based on the SQL database according to Embodiment 1 of the present invention;

[0032] Figure 2 is a framework diagram of the terminal communication test method based on the SQL database according to Embodiment 1 of the present invention. DETAILED DESCRIPTION OF THE EMBODIMENTS

[0033] In order to make the objectives, technical solutions and advantages of the present invention clearer, the present invention will be further described in detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present invention and are not used to limit the present invention.

[0034] Embodiment 1

[0035] Please refer to Figure 1 and Figure 2 , this embodiment provides a terminal communication test method based on the SQL database, and this terminal test method is used to simulate the communication between a terminal and multiple electric energy meters. Among them, the terminal is a dedicated transformer terminal or a concentrator, and communication can be established between multiple acquisition terminals and multiple electric energy meters respectively to collect electric energy meter data, and the electric energy meter can also report frozen data or meter data to the terminal. In this embodiment, the terminal communication test method mainly includes the following steps.

[0036] Step 1. Determine the test content. The test content here can be determined according to the test requirements, such as time calibration, acquisition task parameters, etc.

[0037] Step 2. Establish a connection between the terminal and the computer with a preset SQL database through serial communication. Multiple simulation tables in the SQL database are respectively used to simulate multiple electric energy meters, and all data of the corresponding electric energy meter are stored in each simulation table. When performing serial communication, a separate process is created, and according to the set parameters, the process continuously receives data frames or sends data. The column headers of each simulation table include time, row object identifier, row object attribute, column object attribute, data type, and data content. Among them, the time column is used to store the time stamp (the number of seconds from 00:00:00 UTC on January 1, 1970 to the present) of the table time corresponding to the recorded row data, which is convenient for storage and comparison. When the time stamp is 0, it represents the state of the electric meter at that time, such as the communication address of the electric meter, the temperature inside the table, etc. In this embodiment, the terminal is connected to the computer through a USB-485 serial port.

[0038] Step 3. When performing multi-protocol parsing and reply between the terminal and the SQL database, first distinguish and parse the protocol of the received data frame, and store the parsing result in the created structure, and then enter different processing function trees according to the structure information for processing one by one. Each situation is processed one by one, including reading, storing, changing data, changing the task table, etc., and a reply information frame is formed, and finally the information is replied through the serial port. In this embodiment, the message is replied through the 698 or 645 protocol. After the entire process is completed, the memory allocated in the parsing structure needs to be released. Whether the frame reply is successful or not, the step of releasing the memory must be there, otherwise serious problems such as wild pointers will cause the program to crash.

[0039] In this embodiment, multiple simulation tables can coexist simultaneously, representing electric energy meters with different operating conditions. When replying after parsing the protocol frame, each table needs to be judged. If the address does not match, no reply will be made, fully simulating the scenario where the table receives information. The structural rules followed by the structure include: (1) Use an unsigned char string to identify the type of the currently active member; (2) Use a union type to encapsulate multiple members, and cooperate with the unsigned char string to identify the member currently in use; (3) The members of the large structure use structure pointers, and memory is dynamically allocated when storing data. After multi-protocol parsing and reply, each simulation table judges whether the address matches. If it does, a reply will be made; otherwise, no reply will be made. After multi-protocol parsing and reply, release the memory allocated in the structure.

[0040] Step 4. Edit the operating state of the simulation table to simulate the state when at least one electric energy meter is running. Here, the operating state of one or more electric energy meters can be simulated.

[0041] Step 5: According to the test content, make the terminal send the message of the acquisition task to each analog meter, and / or each analog meter reports the timed frozen data or meter data to the terminal to implement the analog communication test between the terminal and multiple electric energy meters. When the terminal issues an acquisition task and needs to report meter data or freeze data at regular intervals, the internal clock of the meter is required, and the clocks of each meter can be different for convenient and quick setting and shortening the test time.

[0042] Each analog meter defines two timestamps. The first timestamp is the analog meter time, and the second timestamp is the real time obtained from the computer when the first timestamp is written. When the system time reaches the predetermined time node, the freezing task or reporting mechanism is automatically triggered, and whenever the time changes, it is judged whether it is an integer time node by the method of taking the remainder. For example, some freezing tasks require freezing once every 5 minutes. Then divide the timestamp by 300 (the unit is seconds). If the result is 0, the freezing operation is performed. In this way, by continuously obtaining the real time of the computer, the elapsed time can be known, and thus the time of the analog meter can be known. This is more accurate and simpler than setting a time loop inside the program.

[0043] Step 6: Establish a human-machine interaction interface. The user operation items of the interface include: (1) setting the serial port parameters and connecting to the serial port; (2) viewing and recording the communication data; (3) creating or eliminating an analog meter, which is achieved by establishing or destroying an SQL database table; powering on or off an analog meter, which is achieved by operating a sequence with a work meter serial number; (4) viewing all the data in the SQL database, including voltage, address, time, frozen data, etc., and being able to perform operations such as changing, replacing, copying, and deleting the data of each analog meter. In this way, an analog electric meter that meets one's expectations under specific circumstances can be created in a short time for rapid testing.

[0044] In this embodiment, the terminal establishes a connection through serial port communication, resolves the content of the 698 or 645 protocol, and can read data, rewrite data, change task configurations, etc. according to different parsing contents, and finally forms a data frame of the same protocol for transmission. During this period, all data storage and reading are completed by the SQL database. One table in the database represents an electric energy meter and stores all the data of this meter, which is equivalent to the terminal communicating with multiple electric energy meters simultaneously. In addition, a timer is set to synchronize the time flowing through the computer every second and trigger tasks in specific situations for active reporting to complete the entire data communication simulation. A windows interface is established on the outermost layer for human-machine interaction, such as setting serial port communication parameters, viewing and changing data in the database, viewing communication content, powering on and off analog meters, etc., which is more convenient for personnel to operate.

[0045] In some embodiments, the following are cases of logical steps required during testing:

[0046] 1. Determine the test content. Here, take the broadcast time calibration message as an example.

[0047] 2. Establish a connection between the terminal and the simulated meter. Power on the required simulated meter to be in a working state (able to receive and reply to messages). Connect the computer to the terminal using a USB-485 serial port, configure the correct 485 serial port parameters, and click the "Connect Serial Port" button to establish a communication connection.

[0048] 3. Edit the operating status of the simulated meter. Change data such as time and voltage in the database through the interface to simulate the operating status of one or more meters during operation. For example, set two meters with normal time operation, two meters with an over-range time exceeding five minutes, and two meters with correct time but an over-range time not exceeding five minutes.

[0049] 4. The terminal sends a broadcast message and checks the meter results. If the terminal sends the correct message at the correct time, then it should be that: the meters with an over-range time not exceeding five minutes are calibrated, the meters with normal clocks are not affected, and the meters with an over-range time exceeding five minutes cannot be calibrated. The meters with an over-range time exceeding five minutes will be sensed by the terminal and generate a message reported to the master station.

[0050] In some embodiments, the following are the logical steps for testing the change of the acquisition task:

[0051] 1. Determine the test content. Take the sending of acquisition task parameters as an example this time, and publish the freezing of voltage, current and other data every hour for acquisition.

[0052] 2. Establish a connection between the terminal and the simulated meter. Power on the meter to be simulated to be in a working state (able to receive and reply to messages). Connect the computer to the terminal using a USB-485 serial port, configure the correct 485 serial port parameters, and click the "Connect Serial Port" button to establish a communication connection.

[0053] 3. Edit the operating status of the simulated meter. Change data such as time and voltage in the database through the interface to simulate the operating status of one or more meters during operation.

[0054] 4. Wait for the terminal to send the acquisition task and check the reported message of the frozen data. Under normal circumstances, each meter should report its own frozen data every hour. To make this process proceed quickly, the time of the simulated meter can be artificially changed. For example, after freezing and reporting a message at 5:00, change the meter time to 5:59. It can quickly test whether the second report is normal. If there is accumulated data such as frozen electric energy over time, this data can be changed while changing the time of the simulated meter to make the data closer to the real value.

[0055] In summary, the terminal communication test method based on the SQL database in this embodiment has the following beneficial effects:

[0056] 1. For the terminal communication test method based on the SQL database, by establishing serial communication between the computer and the terminal, using multiple simulation tables in the SQL database in the computer to simulate multiple electric energy meters respectively, and using virtual tables to simulate the operating states of actual electric energy meters, message interaction between the terminal and the simulation tables is realized. That is, only one computer needs to work to simulate the communication conditions when multiple electric energy meters are working, and the test scenario can be changed at any time. Compared with the ordinary terminal communication test method, the present invention reduces the test cost and site requirements, shortens the test time, quickly promotes the test process, and solves the technical problems of the existing terminal communication test method being time-consuming, laborious, and having a high test cost.

[0057] 2. The terminal communication test method based on the SQL database consists of serial communication, parsing and reply of 698 and 645 protocols, data access and storage in the SQL database, simulation of time and operation of reporting tasks, human-computer operation interaction interface, etc. Compared with traditional entities, it is more convenient and the operation is more flexible. It is a great help to testers. The test is more intuitive, and communication problems can be detected faster. At the same time, parameter setting is also simpler and more convenient, and the entire test can be completed by one person, and the test efficiency is significantly improved.

[0058] Embodiment 2

[0059] This embodiment provides a terminal communication test system based on the SQL database. The terminal communication test system includes a test input module, a serial communication module, a parsing and reply module, a simulation operation module, and a communication test module.

[0060] The test input module is used to determine the test content. The serial communication module is used to establish a connection between the terminal and a computer with a pre-set SQL database through serial communication. Multiple simulation tables in the SQL database are respectively used to simulate multiple electric energy meters, and each simulation table stores all the data of the corresponding electric energy meter. The parsing and reply module is used for multi-protocol parsing and reply between the terminal and the SQL database. First, it distinguishes and parses the received data frame protocol, stores the parsing result in the created structure, then enters different processing function trees according to the structure information to process one by one, and constructs a reply information frame, and finally replies the information through the serial port.

[0061] The simulation operation module is used to edit the operating state of the simulation table and simulate the state when at least one electric energy meter is operating. The communication test module is used to make the terminal send the message of the acquisition task to each simulation table according to the test content, or / and, each simulation table reports the timed frozen data or table data to the terminal, so as to realize the simulated communication test between the terminal and multiple electric energy meters.

[0062] When the terminal communication test system conducts cross-sampling communication tests on concentrators and dedicated transformer terminals, it addresses the problems of large amounts of time and cost, enabling fast, convenient, and clear testing and improving testing efficiency.

[0063] Embodiment 3

[0064] This embodiment provides a terminal communication test system based on an SQL database. On the basis of Embodiment 2, this system adds a human-computer interaction module (which can be a dedicated test display terminal or a display module set on a computer), and the human-computer interaction module is provided with a human-computer interaction interface. The human-computer interaction interface mainly includes the following operation items: (1) setting serial port parameters and connecting to the serial port; (2) viewing and recording communication data; (3) creating or eliminating a simulated meter, powering on or powering off a simulated meter; (4) viewing all data in the SQL database and being able to change, replace, copy, and delete the data of each simulated meter. In this way, a simulated electric meter that meets one's expectations under specific circumstances can be created in a short time, and testing can be carried out quickly, which is more convenient for testing.

[0065] Embodiment 4

[0066] This embodiment provides a computer terminal, which includes 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 of the terminal communication test method based on the SQL database in Embodiment 1.

[0067] When the method of Embodiment 1 is applied, it can be applied in the form of software. For example, it can be designed as an independently running program and installed on a computer terminal, which can be a computer, a smart phone, a control system, and other Internet of Things devices, etc. The method of Embodiment 1 can also be designed as an embedded running program and installed on a computer terminal, such as installed on a single-chip microcomputer.

[0068] Embodiment 5

[0069] 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 of the terminal communication test method based on the SQL database in Embodiment 1.

[0070] When the method of Embodiment 1 is applied, it can be applied in the form of software. For example, it can be designed as an independently running program on a computer-readable storage medium. The computer-readable storage medium can be a USB flash drive, designed as a USB key, and designed as a program that starts the entire method through external triggering via the USB flash drive.

[0071] The above are only the preferred embodiments of the present invention and are not intended to limit the present invention. Any modifications, equivalent replacements, improvements, etc. made within the spirit and principles of the present invention shall be included within the protection scope of the present invention.

Claims

1. A terminal communication test method based on SQL database, characterized in that: It includes the following steps: Determine the test content; The terminal is connected to a computer with a preset SQL database through serial communication, wherein the multiple simulation tables of the SQL database are respectively used to simulate multiple electric energy meters, and each simulation table stores all data of the corresponding electric energy meter; When performing multi-protocol parsing reply between the terminal and the SQL database, first distinguish and parse the received data frame protocol, and store the parsing result in the created structure, then enter different processing function trees one by one according to the structure information, and form a reply information frame, and finally reply information through the serial port; Editing the operating state of the simulation meter to simulate the operating state of at least one electric energy meter; According to the test content, the terminal sends a message of the collection task to each simulation meter, or / and each simulation meter reports the timing freezing data or meter data to the terminal, so as to realize the simulation communication test between the terminal and multiple electric energy meters.

2. The terminal communication test method based on SQL database according to claim 1, characterized in that: When the terminal issues a collection task, each simulation table defines two timestamps, the first timestamp is the simulation table time, and the second timestamp is the real time obtained from the computer when writing the first timestamp.

3. The terminal communication test method based on SQL database according to claim 1, characterized in that: During serial communication, a separate process is created, and according to the set parameters, the process is made to receive data frames or send data at all times.

4. The terminal communication test method based on SQL database according to claim 1, characterized in that: The structural rules followed by the structure include: (1) using an unsigned char string to identify the currently active member type; (2) using a union type to encapsulate multiple members, and using an unsigned char string to identify the currently used member; (3) using a structure pointer for the members of a large structure to dynamically allocate memory when storing data; After the multi-protocol analysis is replied, the memory opened in the structure is released; when the multi-protocol analysis is completed and replied, each simulation table determines whether the address is consistent, and replies if it is, otherwise no reply is made.

5. The terminal communication test method based on SQL database according to claim 1, characterized in that: The column header of each simulation table includes time, row object identifier, row object attribute, column object attribute, data type, and data content; among them, the time column is used to store the timestamp of the table time recording the corresponding row data, and when the timestamp is 0, it represents the meter status at that time.

6. The terminal communication test method based on SQL database according to claim 1, characterized in that: The terminal communication test method also includes the following steps: Establish a human-computer interaction interface; the user operation items of the interface include: (1) setting serial port parameters and connecting to the serial port; (2) viewing and recording communication data; (3) creating or eliminating a simulation table, powering on or off a simulation table; (4) viewing all data in the SQL database, and being able to change, replace, copy, and delete the data of each simulation table.

7. The terminal communication test method based on SQL database as claimed in claim 2, characterized in that: When the system time reaches the predetermined time node, the freezing task or reporting mechanism is automatically triggered, and every time the time changes, it is determined whether it is an integer time node by dividing the remainder.

8. The terminal communication test method based on SQL database according to claim 1, characterized in that: The terminal is connected to the computer via the USB-485 serial port, and message reply is performed via the 698 or 645 protocol.

9. The terminal communication test method based on SQL database according to claim 1, characterized in that: The terminal is a dedicated terminal or a concentrator.

10. A terminal communication test system based on SQL database, characterized in that: It includes: A test input module, which is used to determine the test content; A serial communication module, which is used to establish a connection between the terminal and a computer preset with an SQL database through serial communication, wherein the multiple simulation tables of the SQL database are respectively used to simulate multiple electric energy meters, and each simulation table stores all data of the corresponding electric energy meter; The parsing reply module is used to distinguish and parse the received data frame protocol when performing multi-protocol parsing reply between the terminal and the SQL database, and store the parsing result in the created structure, and then enter different processing function trees for processing one by one according to the structure information, and form a reply information frame, and finally reply information through the serial port; A simulation operation module, which is used to edit the operation status of the simulation meter and simulate the operation status of at least one electric energy meter; A communication test module is used to enable the terminal to send a message of a collection task to each simulation meter according to the test content, or / and each simulation meter to report timed freezing data or meter data to the terminal, so as to realize a simulated communication test between the terminal and multiple electric energy meters.

Images