A method and device for checking basic information of variables

Abstract

The present application discloses a method and device for checking variable basic information. The method includes: obtaining a test case file and a configured engineering database, where the test case file includes several lines of variable data information, and each line of variable data information includes a first point name, a data type, and first additional information; searching in a sheet page according to the first point name to obtain a second point name corresponding to the first point name, and obtaining second additional information corresponding to the second point name; based on first pre-configured information, obtaining all sheet pages in the engineering database corresponding to the second data type; searching for the second point name corresponding to the first point name in all obtained sheet pages according to the first point name, and determining a first comparison result of the data type according to the search result, and marking the first comparison result in the test case file; comparing the first additional information with the corresponding second additional information one by one to obtain a second comparison result for each first additional information, and marking each second comparison result in the test case file; based on the first comparison result and the second comparison result, determining a final comparison result for each line of variable data information. The method provided by the present application greatly improves the efficiency and quality of testing and saves labor costs.

Description

Technical Field

[0001] This application relates to the field of automated testing for checking basic variable information, and particularly to a method and device for checking basic variable information. Background Art

[0002] I / O variable information is an important part of the nuclear power plant DCS. Whether it is correctly configured in the real-time database of the nuclear power plant DCS will directly affect multiple functions such as the acquisition of external data by the nuclear power plant DCS, the transmission of corresponding data within the DCS, logical calculation, and the output of DCS control commands. Therefore, the verification of the correctness of I / O variable information configuration has always been one of the important contents of nuclear power plant DCS testing.

[0003] Currently, during the implementation of the Daya Bay NC-DCS transformation project, there are numerous variable points. Each variable point has different attributes, including point name, point type, station number, point description, etc. The integration test in the factory test of the Daya Bay NC-DCS transformation project includes a test item for checking the above information - basic variable information check. The basic variable information check test mainly checks whether the information exported from the database configuration is consistent with the user's design input. For the Daya Bay NC-DCS transformation project, the basic variable information check involves approximately more than 7,000 points. If relying solely on manual checking and verification, the verification efficiency will be very low.

[0004] In the prior art, during the variable information check process, relevant functions in Excel are mainly used for data search and comparison, and finally implemented through the VBA computer language. However, this method requires all data to be found before comparison, which will result in a relatively long check time. Moreover, the variable information check in the prior art cannot output error prompts, which is not convenient for subsequent data modification. Summary of the Invention

[0005] In view of the above-mentioned disadvantages of the prior art, the present invention discloses a method and device for checking basic variable information to solve the above problems.

[0006] To achieve the above object and other related objects, the present invention discloses a method for checking basic variable information, including:

[0007] Obtain a test case file and a configured engineering database file. Among them, the test case file includes several lines of variable data information, and each line of the variable data information includes a first point name, a data type, and first additional information;

[0008] For each line of the variable data information in the test case file, perform the following information comparison steps:

[0009] Search in the sheet pages of the engineering database file according to the first point name to obtain a second point name corresponding to the first point name, and obtain second attached information corresponding to the second point name;

[0010] Based on first pre-configured information, obtain all sheet pages in the engineering database file corresponding to the data type, where the first pre-configured information includes the correspondence between the data type and the sheet page;

[0011] Search for a second point name corresponding to the first point name in all obtained sheet pages according to the first point name, determine a first comparison result of the data type according to the search result, and mark the first comparison result in the test case file;

[0012] Compare the first attached information with the corresponding second attached information one by one to obtain a second comparison result for each first attached information, and mark each second comparison result in the test case file;

[0013] Based on the first comparison result and each second comparison result, determine a final comparison result for each row of the variable data information, and mark the final comparison result in the test case file.

[0014] In an optional embodiment of the present invention, the method further includes: when a second point name corresponding to the first point name cannot be found in multiple sheet pages, mark that the first point name does not exist in the test case file.

[0015] In an optional embodiment of the present invention, before searching in the sheet pages of the engineering database according to the first point name to obtain a second point name corresponding to the first point name and obtaining second attached information corresponding to the second point name, the method further includes:

[0016] Configure the correspondence between the header of the test case file and the headers of each sheet page to unify the column names in the test case file and each sheet page in the engineering database that have different names but the same meaning.

[0017] In an optional embodiment of the present invention, the step of marking the inspection result of the data type in the test case file according to the search result specifically includes:

[0018] If a second point name with the same name as the first point name is found in all found sheet pages, no mark is made in the test case file,

[0019] Otherwise, mark that the data types are different in the test case file and mark the actual data type of the second point name.

[0020] In an alternative embodiment of the present invention, the finding of the second point name corresponding to the first point name in all obtained sheet pages according to the first point name specifically includes:

[0021] Find the column where the second point name is located in the row where the column name is in the sheet page;

[0022] Search one by one in the column where the second point name is located to determine whether there is a point name with the same information as the first point name in this column.

[0023] In an alternative embodiment of the present invention, the generation process of the test case file is specifically as follows:

[0024] Use a document conversion tool to convert the input-output data table in PDF format provided by the user into an input-output data table in Word format;

[0025] Based on the input-output data table in Word format, make multiple input-output data in EXCEL format;

[0026] Use an EXCEL merging tool to merge multiple input-output data in EXCEL format to form the test case file.

[0027] In an alternative embodiment of the present invention, it is characterized in that the test case is based on an EXCEL file, and the test case is used as a standard file in the data inspection process.

[0028] In an alternative embodiment of the present invention, it is characterized in that the corresponding relationship between the data type and the sheet page is specifically as follows:

[0029] Sheet names such as analog input signal AVI, 4-limit analog input signal AVI4, 6-limit analog input signal AVI6, and 8-limit analog input signal AVI8 all correspond to the analog input signal AI data type in the test case file. The sheet name of analog output signal AVO corresponds to the AO data type in the test case. The sheet names of DVI and DVI2 correspond to the DI data type in the test case. The sheet name of digital output signal DVO corresponds to the digital output DO data type in the test case.

[0030] In an alternative embodiment of the present invention, it is characterized in that the first accessory information includes one or a combination of two or more of station number, point description, lower limit of dimension range, and upper limit of dimension.

[0031] To achieve the above and other related objectives, the present invention also provides a variable basic information checking device, comprising:

[0032] A file acquisition module, configured to acquire a test case file and a configured engineering database file, wherein the test case file includes several lines of variable data information, and each line of the variable data information includes a first point name, a data type, and first affiliated information;

[0033] A point name checking module, configured to search in the sheet page of the engineering database according to the first point name to obtain a second point name corresponding to the first point name, and obtain second affiliated information corresponding to the second point name;

[0034] A configuration relationship acquisition module, configured to acquire all sheet pages in the engineering database corresponding to the data type based on first pre-configuration information, wherein the first pre-configuration information includes the corresponding relationship between the data type and the sheet page;

[0035] A data type checking module, configured to search for the second point name corresponding to the first point name in all acquired sheet pages according to the first point name, and determine a first comparison result of the data type according to the search result, and mark the first comparison result in the test case file;

[0036] An affiliated information checking module, configured to compare the first affiliated information with the corresponding second affiliated information one by one to obtain a second comparison result of each first affiliated information, and mark each second comparison result in the test case file;

[0037] A final check result marking module, configured to determine a final comparison result of each line of the variable data information based on the first comparison result and the second comparison result, and mark the final comparison result in the test case file.

[0038] Beneficial effects:

[0039] The present invention first obtains a test case file and a configured engineering database file. The test case file includes several lines of variable data information, and each line of the variable data information includes a first point name, a data type, and first affiliated information. Then, for each line of the variable data information in the test case file, the following information comparison steps are performed: Search in the sheet page of the engineering database file according to the first point name to obtain a second point name corresponding to the first point name, and obtain second affiliated information corresponding to the second point name; Based on first pre-configured information, obtain all sheet pages in the engineering database file corresponding to the data type, where the first pre-configured information includes the correspondence between the data type and the sheet page; Search for the second point name corresponding to the first point name in all the obtained sheet pages according to the first point name, and determine a first comparison result of the data type according to the search result, and mark the first comparison result in the test case file; Compare the first affiliated information with the corresponding second affiliated information one by one to obtain a second comparison result for each first affiliated information, and mark each second comparison result in the test case file; Based on the first comparison result and each second comparison result, determine a final comparison result for each line of the variable data information, and mark the final comparison result in the test case file.

[0040] Using the method provided in this application can greatly improve the inspection efficiency and quality of variable information. At the same time, marking the inspection results in the test case file facilitates subsequent changes. BRIEF DESCRIPTION OF THE DRAWINGS

[0041] The accompanying drawings herein are incorporated into the specification and form a part of the specification, showing embodiments consistent with the present application, and are used together with the specification to explain the principles of the present application. Obviously, the accompanying drawings in the following description are only some embodiments of the present application. For those of ordinary skill in the art, other drawings can be obtained based on these drawings without creative efforts. In the drawings:

[0042] Figure 1 It is a flowchart of a method for checking basic variable information shown in an exemplary embodiment of the present application.

[0043] Figure 2 It is a partial example diagram of a test case file shown in an exemplary embodiment of the present application.

[0044] Figure 3 It is a partial example diagram of an engineering database shown in an exemplary embodiment of the present application.

[0045] Figure 4A correspondence diagram between a data type and a sheet page shown in an exemplary embodiment of the present application.

[0046] Figure 5 A schematic diagram of the inspection result provided by an exemplary embodiment of the present application.

[0047] Figure 6 A schematic diagram of the main interface of the variable basic information inspection automation test software.

[0048] Figure 7 A block diagram of a variable basic information inspection device shown in an exemplary embodiment of the present application. Detailed implementation manners

[0049] The following uses specific specific examples to illustrate the implementation manners of the present invention. Those skilled in the art can easily understand other advantages and effects of the present invention from the content disclosed in this specification. The present invention can also be implemented or applied through other different specific implementation manners. Various details in this specification can also be modified or changed based on different viewpoints and applications without departing from the spirit of the present invention. It should be noted that, without conflict, the following embodiments and the features in the embodiments can be combined with each other.

[0050] It should be noted that the diagrams provided in the following embodiments only illustrate the basic concept of the present invention in a schematic manner. Therefore, only the components related to the present invention are shown in the diagrams, rather than being drawn according to the number, shape, and size of the components in actual implementation. The type, quantity, and ratio of each component in actual implementation can be arbitrarily changed, and the component layout type may also be more complex.

[0051] In the following description, a large number of details are discussed to provide a more thorough explanation of the embodiments of the present invention. However, it is obvious to those skilled in the art that the embodiments of the present invention can be implemented without these specific details. In other embodiments, well-known structures and devices are shown in the form of block diagrams rather than in detail to avoid making the embodiments of the present invention difficult to understand.

[0052] Embodiments of the present application respectively propose a method for checking variable basic information, and the following will describe these embodiments in detail.

[0053] Please refer to Figure 1 as shown Figure 1 is a flowchart of a method for checking variable basic information shown in an exemplary embodiment of the present application. Combining Figure 1 as shown, a method for checking variable basic information according to an embodiment of the present disclosure includes:

[0054] Step S101: Obtain the test case file and the configured project database file. The test case file includes several lines of variable data information, and each line of the variable data information includes a first point name, a data type, and first supplementary information.

[0055] For each line of the variable data information in the test case file, perform the following information comparison steps:

[0056] Step S102: Search in the sheet page of the project database file according to the first point name to obtain the corresponding second point name, and obtain the corresponding second supplementary information of the second point name.

[0057] Step S103: Based on the first pre-configuration information, obtain all the sheet pages in the project database file corresponding to the data type. The first pre-configuration information includes the corresponding relationship between the data type and the sheet page.

[0058] Step S104: Search for the corresponding second point name according to the first point name in all the obtained sheet pages, determine the first comparison result of the data type according to the search result, and mark the first comparison result in the test case file.

[0059] Step S105: Compare the first supplementary information with the corresponding second supplementary information one by one to obtain the second comparison result of each first supplementary information, and mark each second comparison result in the test case file.

[0060] Step S106: Based on the first comparison result and each second comparison result, determine the final comparison result of each line of the variable data information, and mark the final comparison result in the test case file.

[0061] Using the method provided by this application can greatly improve the inspection efficiency and quality of variable information. At the same time, marking the inspection results in the test case file facilitates subsequent changes. In addition, the method provided by this application is developed according to the characteristics of engineering projects and has the characteristics of universality. It can be promoted to other projects on the basis of meeting the transformation of Daya Bay NC-DCS.

[0062] Now, in combination with Appendix Figure 1 Appendix Figure 2 Appendix Figure 3 Appendix Figure 4 And Appendix Figure 5 to introduce the implementation process of each step in detail:

[0063] First, step S101 is executed to obtain a test case file and a configured engineering database file. Among them, the test case file includes several lines of variable data information, and each line of the variable data information includes a first point name, a data type, and first supplementary information.

[0064] Please refer to Figure 2 as shown Figure 2 which shows a partial example diagram of a test case file in a specific embodiment of the present application. Combining Figure 2 as shown, the first supplementary information includes a station number, a point description, a dimension, a dimension lower limit, a dimension upper limit, a power supply method, etc. It can be understood that in other embodiments, the first supplementary information can also be adjusted accordingly according to actual test requirements, which is not limited herein.

[0065] In this embodiment, the test case file is an EXCEL version file made based on the PDF version of the I / O table provided by the user. The test case file is used as a standard file in the variable check process, and its generation process is as follows:

[0066] Use a document conversion tool to convert the PDF version of the input-output data table provided by the user into a word version of the input-output data table;

[0067] It should be noted that the document conversion tool described in the present application is a PDF to Word tool.

[0068] Based on the word version of the input-output data table, multiple EXCEL versions of the input-output data are made;

[0069] Use an EXCEL merging tool to merge multiple EXCEL versions of the input-output data to form the test case file.

[0070] It should be noted that the document conversion tool and the EXCEL merging tool described in the present application are both software developed based on the present application. Among them, the PDF to Word tool is used to restore the file to the original Word file that formed the PDF file, that is, the text part is converted into Word text, the picture part is restored to a picture, and the scanned file is defaulted to be restored to a picture; the EXCEL merging tool can merge multiple files and multiple sheet pages, can merge specified sheet pages, or can merge all sheet pages.

[0071] In this embodiment, the configured engineering database file is the file to be inspected. When all the point information in the test case file can be fully corresponded in the engineering database, that is, all the variable points in the test case file have corresponding variable points in the engineering database file, and all the point item values of these corresponding variable points are also exactly the same, then the engineering configuration is correct; otherwise, it is incorrect and needs to be modified according to the test file.

[0072] As Figure 3 shown, it is an example diagram of the engineering database provided in a specific embodiment of the present application. As Figure 3 shown, the described engineering database includes AVI sheet page, AVI4 sheet page, AVI6 sheet page, AVI8 sheet page, AVIE sheet page, AVO sheet page, DV sheet page, DVI sheet page, DVO sheet page, PVI sheet page, etc. Among them, the name of each sheet page represents the data type of all variable data information in this page. For example, if the sheet page name is AVI, then the data type of all variable information in this page is AVI (analog input signal); and for another example, if the sheet page name is AVO, then the data type of all variable information in this page is AVO (analog output signal).

[0073] For each line of the variable data information in the test case file, perform the following information comparison steps:

[0074] Step S102, search in the sheet pages of the engineering database according to the first point name to obtain the second point name corresponding to the first point name, and obtain the second affiliated information corresponding to the second point name.

[0075] It should be noted that in a specific embodiment of the application, the "for in" function in Python is used to traverse all the sheet pages in the engineering database, and then the "if" function is used to search for whether there is a second point name corresponding to the first point name. If a second point name matching the first point name is obtained in a certain sheet page of the engineering database, then the second affiliated information matching the first affiliated information in the second point name is read simultaneously, and then the subsequent steps are executed; if after traversing all the sheet pages of the engineering database, no second point name matching the first point name is found, then "this point name does not exist" is marked in the row where the first point name is located in the test case file.

[0076] The present application mainly adopts the traversal method because the engineering project test usually requires full coverage. It can be understood that in other embodiments, for other tests without special requirements, the search may not be carried out by the traversal method.

[0077] This application uses the "for in" function in Python to search for variable data information in each sheet page in just a few seconds, greatly improving the efficiency of the inspection.

[0078] Step S103: based on first pre-configuration information, obtaining all sheet pages in the engineering database file corresponding to the data type, wherein the first pre-configuration information includes a correspondence between the data type and the sheet page.

[0079] See also Figure 4 As shown, in a specific embodiment of the present application, the corresponding relationship between the data type and the sheet page is as follows:

[0080] The sheet page names of analog input signal AVI, 4-limit analog input signal AVI4, 6-limit analog input signal AVI6 and 8-limit analog input signal AVI8 all correspond to the analog input signal AI data type in the test case file, the sheet page names of analog output signal AVO correspond to the AO data type in the test case, the sheet page names of DVI and DVI2 correspond to the DI data type in the test case, and the sheet page name of digital output signal DVO corresponds to the digital output DO data type in the test case.

[0081] It should be noted that the above embodiment is only a specific example in the actual testing process. It can be understood that in other embodiments, corresponding configurations can also be made according to actual testing requirements.

[0082] Step S104, searching for a second point name corresponding to the first point name in all acquired sheet pages according to the first point name, determining a first comparison result of the data type according to the search result, and marking the first comparison result in the test case file, as follows:

[0083] After obtaining all the sheet pages in the engineering database file corresponding to the data type, search in the column where the point names of these sheet pages are located to see whether there is a second point name corresponding to the first point name. If so, it means that the comparison results of the data types are the same. If not, it means that the comparison results of the data types are different, and the actual results of the data types are recorded in the remarks column in the test case file (the actual results mentioned here refer to the search results in the sheet page).

[0084] Step S105: Compare each piece of the first supplementary information with the corresponding second supplementary information one by one to obtain the second comparison result for each piece of the first supplementary information, and mark each second comparison result in the test case file.

[0085] In a specific embodiment of the application, the "IF function" in Python is used to compare the first supplementary information and the second supplementary information.

[0086] It should be noted that due to a special situation regarding the column names of the columns where the first supplementary information is located in the test case file and the column names of the columns where the second supplementary information is located in the engineering database file, that is, the column names are different but their meanings are the same.

[0087] For example, in the test case file, a certain column name is "Point Description" while in the engineering database file it is called "Variable Description", and in the test case file, a certain column name is "Dimension" while in the engineering database file it is called "Unit", etc. In such situations, if the configuration relationship between the column names of the columns where the first supplementary information is located and the column names of the columns where the second supplementary information is located in the engineering database file is not set up, it will result in the inability to find the first supplementary information in the sheet of the engineering database file, thereby leading to incorrect inspection results.

[0088] In view of this, the method for checking variable basic information provided by this application further includes the following steps:

[0089] Configure the corresponding relationship between the headers of the test case file and the headers of each sheet to unify the column names that are different in name but the same in meaning in the test case file and each sheet in the engineering database.

[0090] Step S106: Based on the first comparison results and the second comparison results, determine the final comparison result for each row of the variable data information, and mark the final comparison result in the test case file.

[0091] In a specific embodiment, Step S106 is specifically as follows:

[0092] When the first comparison result and the second comparison result in a certain row are both the same, mark the inspection result as the same in the test case file; otherwise, mark the inspection result as different in the test case file.

[0093] Please refer to Figure 5 as shown Figure 5 which is a schematic diagram of the inspection results provided by an exemplary embodiment of this application. Combining Figure 5 as shown, the final comparison results of multiple rows of variable information data can be seen.

[0094] Finally, it should also be noted that based on the design method provided by the present invention, this application also developed an automated test software for checking the basic information of variables using Python. Please refer to Figure 6 as shown in Figure 6 Fig. Figure 6 is the main interface diagram of the automated test software for checking the basic information of variables. Combining Figure 6 as described above, the automated test software includes a "Select Database Excel File" control, a "Select Test Case Excel File" control, a "Fill in the Number of Header Rows" control, a "Preview Data" control, a "Please Configure Header Relationship" control, a "Please Configure Sheet Correspondence Relationship" control, a "Refresh Drop-down List" control, a "Start Check" control, and a "Save Excel" control. The usage steps of this test software are as follows:

[0095] First, click the "Select Database Excel File" control and the "Select Test Case Excel File" control to import the selected database Excel file and test case file into the automated test software for checking the basic information of variables. Then, click the "Fill in the Number of Header Rows" control, the "Preview Data" control, the "Please Configure Header Relationship" control, the "Please Configure Sheet Correspondence Relationship" control, the "Refresh Drop-down List" control, and the "Start Check" control in sequence. Finally, click the "Save Excel" control to save the generated check results.

[0096] The automated test software for checking the basic information of variables provided by this application considers open interfaces when designing the interface, allowing users to independently select and configure, with strong versatility. At the same time, it considers human factors. When working on-site, select according to the steps. When the pre-input configuration is not selected, the subsequent buttons cannot be clicked, and an error operation will pop up a window prompt. In addition, it also considers reducing the number of user operation steps by defaulting the regular configuration as already configured, which can be modified according to actual needs during subsequent execution.

[0097] Please refer to Figure 7As shown in the figure, the present application also provides a variable basic information checking device, which includes a file acquisition module 701, a naming check module 702, a configuration relationship acquisition module 703, a data type check module 704, an attached information check module 705, and a final check result annotation module 706. The file acquisition module 701 is used to acquire a test case file and a configured engineering database file. Among them, the test case file includes several lines of variable data information, and each line of the variable data information includes a first name, a data type, and a first attached information. The naming check module 702 is used to search in the sheet page of the engineering database file according to the first name to obtain a second name corresponding to the first name, and obtain a second attached information corresponding to the second name. The configuration relationship acquisition module 703 is used to obtain all the sheet pages in the engineering database file corresponding to the second data type based on the first pre-configuration information, where the first pre-configuration information includes the corresponding relationship between the data type and the sheet page. The data type check module 704 is used to search for the second name corresponding to the first name in all the obtained sheet pages according to the first name, and determine the first comparison result of the second data type according to the search result, and mark the first comparison result in the test case file. The attached information check module 705 is used to compare the first attached information with the corresponding second attached information one by one to obtain the second comparison result of each first attached information and mark each second comparison result in the test case file. The final check result annotation module 706 is used to determine the final comparison result of each line of the variable data information based on the first comparison result and each second comparison result, and mark the final comparison result in the test case file.

[0098] It should be noted that the flowcharts and block diagrams in the accompanying drawings illustrate the possible architectures, functions, and operations of systems, methods, and computer program products according to various embodiments of the present application. Among them, each block in the flowchart or block diagram may represent a module, a program segment, or a part of the code, and the above-mentioned module, program segment, or part of the code includes one or more executable instructions for implementing the specified logical function. It should also be noted that in some alternative implementations, the functions marked in the block may occur in a different order than marked in the accompanying drawings. For example, two consecutive blocks shown may actually be executed substantially in parallel, and they may sometimes be executed in the reverse order, depending on the functions involved. It should also be noted that each block in the block diagram or flowchart, and the combination of blocks in the block diagram or flowchart, can be implemented by a dedicated hardware-based system for performing the specified functions or operations, or can be implemented by a combination of dedicated hardware and computer instructions.

[0099] The units involved in the embodiments described in this application can be implemented in software or in hardware, and the described units can also be provided in a processor. Among them, the names of these units do not, in some cases, constitute a limitation on the units themselves.

Claims

1. A method for checking basic variable information, characterized in that, Including: Obtain a test case file and a configured engineering database file, where the test case file includes several lines of variable data information, and each line of the variable data information includes a first point name, a data type, and first supplementary information; For each line of the variable data information in the test case file, perform the following information comparison steps: Search in the sheet page of the engineering database according to the first point name to obtain a second point name corresponding to the first point name, and obtain second supplementary information corresponding to the second point name; Based on first pre-configuration information, obtain all sheet pages in the engineering database corresponding to the data type, where the first pre-configuration information includes the correspondence between the data type and the sheet page; Search for the second point name corresponding to the first point name in all obtained sheet pages according to the first point name, and determine a first comparison result of the data type according to the search result, and mark the first comparison result in the test case file; Compare the first supplementary information with the corresponding second supplementary information one by one to obtain a second comparison result of each first supplementary information, and mark each second comparison result in the test case file; Based on the first comparison result and the second comparison result, determine a final comparison result of each line of the variable data information, and mark the final comparison result in the test case file.

2. The variable basic information checking method according to claim 1, characterized in that The method further includes: When the second point name corresponding to the first point name cannot be found in multiple sheet pages, mark that the first point name does not exist in the test case file.

3. The variable basic information checking method according to claim 1, characterized in that Before searching in the sheet page of the engineering database according to the first point name to obtain the second point name corresponding to the first point name and obtaining the second supplementary information corresponding to the second point name, the method further includes: Configure the correspondence between the header of the test case file and the headers of each sheet page to unify the column names in the test case file and each sheet page in the engineering database that have different column names but the same meaning.

4. The method for checking basic variable information according to claim 1, characterized in that And marking the inspection result of the data type in the test case file according to the search result specifically includes: If a second point name with the same name as the first point name is found in all found sheet pages, no mark is made in the test case file; Otherwise, mark that the data types are different in the test case file and mark the actual data type of the second point name.

5. The method for checking variable basic information according to claim 1, characterized in that The searching for the second point name corresponding to the first point name in all obtained sheet pages according to the first point name specifically includes: Search for the column where the second point name is located in the row where the column name is located in the sheet page; Search one by one in the column where the second point name is located to determine whether there is a point name with the same information as the first point name in this column.

6. The variable basic information checking method according to claim 1, characterized in that The generation process of the test case file is specifically as follows: Use a document conversion tool to convert the input-output data table in PDF format provided by the user into a Word version of the input-output data table; Based on the Word version of the input-output data table, create multiple EXCEL versions of the input-output data; Use an EXCEL merging tool to merge multiple EXCEL versions of the input-output data to form the test case file.

7. The method for checking variable basic information according to claim 6, characterized in that, The test case is based on an EXCEL file, and the test case is used as a standard file during the data check process.

8. The variable basic information checking method according to claim 1, characterized in that The correspondence between the data types and the sheet pages is as follows: Sheet names such as Analog Input Signal AVI, 4-Limit Analog Input Signal AVI4, 6-Limit Analog Input Signal AVI6, and 8-Limit Analog Input Signal AVI8 all correspond to the Analog Input Signal AI data type in the test case file. The Sheet name Analog Output Signal AVO corresponds to the AO data type in the test case. The Sheet names DVI and DVI2 correspond to the DI data type in the test case. The Sheet name Digital Output Signal DVO corresponds to the Digital Output DO data type in the test case.

9. The variable basic information checking method according to claim 1, characterized in that The first supplementary information includes one or more combinations of station number, point description, dimension, lower limit of range, and upper limit of dimension.

10. A variable basic information checking device, characterized in that, It includes: A file acquisition module for acquiring a test case file and a configured engineering database file, where the test case file includes several lines of variable data information, and each line of the variable data information includes a first point name, a data type, and first supplementary information; A point name check module for searching in the sheet pages of the engineering database according to the first point name to obtain a second point name corresponding to the first point name, and obtaining second supplementary information corresponding to the second point name; A configuration relationship acquisition module for obtaining all sheet pages in the engineering database corresponding to the data type based on first pre-configuration information, where the first pre-configuration information includes the correspondence between the data type and the sheet page; A data type check module for searching for a second point name corresponding to the first point name in all the obtained sheet pages according to the first point name, and determining a first comparison result of the data type based on the search result, and marking the first comparison result in the test case file; A supplementary information check module for comparing the first supplementary information with the corresponding second supplementary information one by one to obtain a second comparison result for each first supplementary information, and marking each second comparison result in the test case file; A final check result marking module for determining a final comparison result for each line of the variable data information based on the first comparison result and the second comparison result, and marking the final comparison result in the test case file.

Images