A method for checking and correcting interlocking table

Abstract

The present invention relates to a method for checking and correcting an interlocking table, comprising the following steps S1: defining a document path, opening a log record file, and distinguishing the paths of the interlocking tables to be corrected therein; S2: standardizing the names, file types, and names of each page of the interlocking table; S3: performing basic processing on the cells of each page of the interlocking table; S4: correcting the cells of the interlocking table that need to check the sorting of the section list; S5: checking and correcting the cells of the interlocking table that need to check parameters according to the parameter rule feature definition; S6: saving and closing the checked and corrected interlocking table file, and finally closing the log file. The above scheme reduces the time, misjudgment, and omission problems of manual inspection and correction, and improves work efficiency; it is conducive to solving the implementation of the fully unmanned process of automated testing.

Description

Technical Field

[0001] The invention relates to the field of rail transit data correction, and in particular to a method for checking and correcting an interlocking table. Background Art

[0002] The main function of the computer interlocking equipment in the urban rail transit signal system equipment is to ensure the correctness of the interlocking logic relationship between signal equipment and to complete operations such as establishing, unlocking, and canceling routes. It is an important part of the urban rail transit signal system and is related to the safety and efficiency of the signal system operation. The interlocking table is an illustration of the interlocking relationship of the station signal equipment, which is used to clearly give the station interlocking relationship. The interlocking logic of the computer interlocking system is restricted by the interlocking table. It can be seen that the interlocking table is the guarantee for the correct interlocking logic relationship in urban rail transit.

[0003] At present, the interlocking table can basically realize the automatic generation of corresponding tables according to the template format through tools, which provides a powerful condition for the automated testing of interlocking related products. However, due to the diversity of interlocking rules and the particularity of the interlocking related interfaces and requirements of a large number of urban rail projects, there may still be various problems in the generation of interlocking tables. On the one hand, the diversity of interlocking rules may result in a large variety of templates and untimely tool updates, resulting in some content being unable to be generated or errors in the generator. On the other hand, the particularity of the interface and requirements may still require manual input or changes after the interlocking table is automatically generated. These two aspects can easily cause errors or non-standardization in the compilation of interlocking tables, affecting downstream input.

[0004] In the automated testing platform, interlocking-related data tests in urban rail projects are all based on the UI interactive automated testing of the ATS (Automatic Train Supervision) station diagram. First of all, as the input file for automated testing, the interlocking table should be checked and corrected with as little human involvement as possible. Secondly, if the interlocking table requires too much manual inspection and preprocessing, it will not only bring about the problem of manual modification: low efficiency, and problems such as missed inspections, missed corrections, and wrong corrections, but also affect the degree of realization of the fully unmanned process of test automation because of the need for manual participation during the period. Summary of the invention

[0005] In order to solve the above problems, the present invention provides a method for checking and correcting an interlocking table, which specifically comprises the following steps:

[0006] S1: define the document path, open the log file, and identify the location of the interlock table to be corrected under the document path;

[0007] S2: Standardize the file name, file type and name of each page of the interlocking table;

[0008] S3: Perform basic processing on the cells of each page of the interlocking table;

[0009] S4: Correct the cells in the interlock table that need to check the sorting of the segment list;

[0010] S5: Check and correct the cells of the interlocking table that need to check parameters according to the parameter rule feature definition;

[0011] S6: Save and close the checked and corrected interlock table file, and finally close the log file.

[0012] Specifically, the S2 step includes the following contents:

[0013] S21: Check and modify the file name of the interlock table. If there is a space at the end of the name, delete it; if there are spaces and / or dashes between words and numbers and / or between words in the file name, modify them to single underscores; if there is version information in the file name, delete the version information;

[0014] S22: Change the file type of the interlocking table to xlsx file type;

[0015] S23: Check the names of each page in the interlocking table. If there are spaces and / or dashes between words in the page name, they are all changed to single underscores; if there are spaces at the beginning and / or end of the page name, they are deleted.

[0016] Specifically, the step S3 includes the following contents: performing basic processing on the cells of each page regarding the interlocking device and the logical relationship, changing the Chinese commas therein into English commas, and removing all spaces in the cells.

[0017] Specifically, the S4 step includes the following contents:

[0018] S41: Check the list of the inner sections of the route in the route table, and re-sort them if they are not sorted in the forward direction according to the direction of the signal.

[0019] S42: Check the approach section list of the approach section table, and re-sort it if it is not sorted in reverse order according to the direction of the signal.

[0020] Specifically, the step S41 includes the following contents:

[0021] S411: Query the column number of the inner section of the route in the route table;

[0022] S412: extracting the list in the inner section of the route and performing basic processing, that is, deleting the line feed and carriage return characters therein;

[0023] S413: Check the list of inner sections of the route according to the same direction of the signal lights. If the sequence is wrong, correct it.

[0024] Specifically, the step S42 includes the following contents:

[0025] S421: Query the column number of the close segment in the close segment table;

[0026] S422: extract the approaching section list of the incoming signal and perform basic processing, that is, split the prefix conditions of the turnout position and delete the line feed and carriage return characters therein;

[0027] S423: Check the approach section list in reverse order of the signals, and make corrections if the order is wrong.

[0028] Specifically, the step S5 includes the following contents:

[0029] S51: Check and correct the cell format and content of the automatic wrap table.

[0030] S52: Check other conditions for opening the approach signal table signal and correct any errors.

[0031] Specifically, the step S51 includes the following contents:

[0032] S511: query the merged cell information of the automatic wrap table, extract the vertically merged cells in the list, and then split them, and fill in the same information as the first cell;

[0033] S512: Query the route type column number, the fully automatic return identification column number, the priority route identification column in the fully automatic return, the return section column number, and the remarks column number of the automatic return table;

[0034] S513: If the fully automatic reentry identification column number and / or the priority route identification column number in the fully automatic reentry is not found, insert a new column according to the identification column sorting, fill in the corresponding title in the new column, and initialize the cell format in the new column;

[0035] S514: If there is a newly inserted column of the fully automatic return identification column and / or the priority route identification column in the fully automatic return, determine the value of the fully automatic return identification column and / or the priority route identification column in the fully automatic return according to the name of the automatic return table and the relevant route, fill it in, and check whether the route type is correct, and correct it if there is an error;

[0036] S515: If a new fully automatic reentry identification column and / or a priority route identification column in the fully automatic reentry is not inserted, then it is only necessary to check whether the values ​​of the route type class, the fully automatic reentry identification column and the priority route identification column in the fully automatic reentry are correct, and correct any errors.

[0037] Specifically, the step S52 includes the following contents:

[0038] S521: Query the OtherConditions column number of Non CBTC in the route signal table;

[0039] S522: Get the OtherConditions value of Non CBTC according to the signal in the route signal table, first perform basic processing on it, delete the carriage return and line feed characters, then check whether there is a horizontal line before the characters such as "ESP", "ESB", "PSD", and "KC". If there is, replace it with an underscore, check whether there is an English comma after these characters, if not, add it, and finally check the Overlap condition "O_" to check whether there is an English comma before the character, if not, add it.

[0040] The present invention has the following beneficial effects:

[0041] 1. The above scheme designs a method for automatic inspection and correction of the interlocking table, which greatly reduces the time of manual inspection and correction, and avoids the misjudgment and omission problems that occur during manual inspection and correction, thereby improving work efficiency;

[0042] 2. The above scheme not only refers to the input file when the interlocking table is generated, but also checks the content of the interlocking table based on the input file combined with the equipment coordinates of the station diagram, parameter rule feature definitions, etc., which provides a way of thinking for the automatic generation of the interlocking table;

[0043] 3. The above scheme effectively ensures the input standardization of the interlocking table of the automated test input file, which is conducive to the implementation of the fully unmanned process of automated testing. BRIEF DESCRIPTION OF THE DRAWINGS

[0044] Figure 1 A design idea diagram for checking and correcting the interlocking table of the present invention;

[0045] Figure 2 The flowchart of the interlocking table inspection and correction of the present invention. DETAILED DESCRIPTION

[0046] The following is a further detailed description of the inspection and correction method of an interlocking table proposed by the present invention in conjunction with the accompanying drawings and specific implementation methods.

[0047] like Figure 1 and Figure 2As shown, the interlocking table inspection and correction method provided by the present invention comprises the following steps:

[0048] S1: Define the document path, open the log file, and distinguish the interlock table file location in the document path;

[0049] S11: define the document path;

[0050] S12: Open the log record file and distinguish the interlock table file in the document path;

[0051] S13: According to the location of the interlocking table, several interlocking tables Control_Table to be checked and corrected in the project are distinguished from the document path, the project parameter configuration file ConfigFile, and the ATS station diagram export device information file TLE (including device type and coordinates, etc.).

[0052] S2: Standardize the name, type and name of each interlocking table and each sheet page;

[0053] S21: Check and modify the file name of the interlocking table. If there is a space at the end of the file name, delete it; if there are spaces and / or dashes between words and numbers and / or between words in the file name, modify them to single underscores; if there is version information in the file name, delete the version information;

[0054] S22: Check and modify the file type of the interlocking table. If the file type is not xlsx, but is xls, xlsm, csv, etc., the file type is uniformly modified to xlsx.

[0055] S23: Check and modify the names of each sheet page in the interlocking table. If there are spaces and / or dashes between words in the sheet page name, they are all modified to single underscores; if there are spaces at the beginning and / or end of the sheet page name, they are deleted.

[0056] S3: Perform basic processing on the interlocking device cells and logical relationship cells in each sheet page of the interlocking table: change the Chinese comma "," to English comma ",", and delete all spaces in each cell.

[0057] S4: Modify the cells in the interlocking table that need to check the sorting of the segment list, including the following:

[0058] S41: Check the list of sections inside the route in the Route_List_ route table. If it is not sorted in the forward direction according to the signal direction, re-sort it. It includes the following contents:

[0059] S411: Query the column number of the inner section of the route in the Route_List_ route table;

[0060] S412: extracting the list of internal sections of the route and performing basic processing, i.e. deleting the line feed and carriage return characters therein;

[0061] S413: Check the list of the inner sections of the route according to the same direction of the signal machine. If the order is wrong, re-sort it through correction. Specifically, the same direction check is performed on the inner sections of the route. Taking two sections as an example, the first step is to determine the interlocking station where the sections are located. If they are not in the same interlocking station, the interlocking stations can be compared. If they are in the same interlocking station, the positions need to be compared according to the coordinates in the TLE station map for sorting.

[0062] S42: Check the list of approach sections in the Approach_Section table. If it is not sorted in the reverse order according to the direction of the signal, re-sort it, including the following:

[0063] S421: Query the column number of the approach section in the Approach_Section approach section table;

[0064] S422: extract the approach section list of the signal machine, and perform basic processing, that is, split the prefix condition of the switch position and delete the line feed and carriage return characters therein. Splitting the switch position specifically includes extracting the character string between “<” and ">”;

[0065] S423: Check the approaching section list in reverse order according to the signal, and if the order is wrong, re-order it through correction. Specifically, reverse check the approaching section of the signal, take two sections as an example, first determine the interlocking station where the section is located, if they are not in the same interlocking station, compare the interlocking stations, if they are in the same interlocking station, it is necessary to compare the positions according to the coordinates in the TLE station map, so as to sort them.

[0066] S5: Check and correct the cells in the interlocking table that need to check parameters according to the parameter rule feature definition, including the following:

[0067] S51: Check and correct the cell format and content of the Cycle_ automatic wrap table, specifically including the following:

[0068] S511: querying the merged cell information of the Cycle_automatic wrapping table, extracting the vertically merged cells in the list, and then splitting them, and the content of the split cells is the same as the content of the previously merged cells;

[0069] S512: Query the route type column number, the fully automatic return identification column number, the priority route identification column number in the fully automatic return, the return section column number, and the remarks column number of the Cycle_automatic return table;

[0070] S513: If any one of the fully automatic reentry identification column number and the priority route identification column number in the fully automatic reentry is not found or both are not found, insert a new column according to the identification column sorting, fill in the title of the missing corresponding column, and initialize the format of the cell of the column;

[0071] S514: If there is a situation where a new fully automatic return identification column and / or a priority route identification column in the fully automatic return needs to be inserted, determine the value of the fully automatic return identification column and / or the priority route identification column in the fully automatic return based on the name of the Cycle_automatic return table and the relevant route situation, fill them in, and check whether the route type is correct. If there is an error, correct it.

[0072] The basis for judgment is:

[0073] (1) If the Cycle_Automatic Return table contains two routes, then the Fully Automatic Return column is filled with "N", and the Priority Route column in the Fully Automatic Return is filled with "NA". The two route types are "EZ" and "OJ" respectively.

[0074] (2) If the Cycle_Automatic Reversal Table contains 4 routes, if the starting signals of the first and third routes are the same, then the Fully Automatic Reversal column is filled with "Y", otherwise it is filled with "N";

[0075] If the fully automatic reversal is "Y", you need to find out whether the 1st and 2nd routes or the 3rd and 4th routes are the priority routes (the 2nd route is the same as the 1st route, and the 3rd route is the same as the 4th route, so there are four routes). According to the definition of the priority route, you need to determine which of the 1st and 3rd routes has the terminal signal farther from the initial signal, which corresponds to the reverse position of the switch when entering the reversal section, and thus it is the priority route. Fill in "Y" in the priority route identification column in the fully automatic reversal, otherwise fill in "N". The route types are "EZ", "OJ", "EZ" and "OJ" respectively;

[0076] If the fully automatic return is "N", then the fully automatic return column is filled with "N" and the priority route column in the fully automatic return is filled with "NA". The route types are "EZ", "OZ", "EZ" and "OJ".

[0077] S515: If a new fully automatic return identification column and / or a priority route identification column in the fully automatic return is not inserted, then it is only necessary to check whether the values ​​of the route type, the fully automatic return identification column and the priority route identification column in the fully automatic return are correct, and correct any errors.

[0078] The inspection is based on:

[0079] (1) If the Cycle_Automatic Return table contains two routes, then check whether the Full Automatic Return column is filled with "N", whether the Priority Route column in the Full Automatic Return is filled with "NA", and whether the two route types are "EZ" and "OJ" respectively. If there are any errors, correct them.

[0080] (2) If the Cycle contains 4 routes, then check whether the fully automatic return column contains "Y";

[0081] If the fully automatic return is "Y", then check whether the fully automatic return column is filled with "Y", and whether the priority route column in the fully automatic return is filled with "Y" and "N". If there is an error, correct it. Check whether the route types are "EZ", "OJ", "EZ" and "OJ" respectively. If there is an error, correct it;

[0082] As for whether to fill in "Y" or "N" in the priority route column in the fully automatic reversal, it is necessary to determine which of the terminal signals of the 1st route and the 3rd route is farther from the initial signal. The corresponding one is the reverse position of the switch when entering the reversal section, so that the priority route, the priority route identification column in the fully automatic reversal is filled in with "Y", otherwise fill in "N", the 2nd route is the same as the 1st route, and the 3rd route is the same as the 4th route.

[0083] If the fully automatic return is "N", then check whether the fully automatic return column is filled with "N", and the priority route column in the fully automatic return is filled with "NA". If there is an error, correct it. The route types are "EZ", "OZ", "EZ" and "OJ". If there is an error, correct it.

[0084] S52: Check other conditions for opening the signals in the Route_Signal_Route Signal table and correct any errors.

[0085] S521: Query the column number of OtherConditions of Non CBTC (Non Communication-Based Train Control) in the Route_Signal_Route Signal table;

[0086] S522: In the Route_Signal_ route signal table, get the OtherConditions value of NonCBTC according to the signal, first perform basic processing on it, delete the carriage return and line feed characters, then check whether there are horizontal lines before the characters such as "ESP", "ESB", "PSD", and "KC". If there are, replace them with underscores, check whether there are English commas after these characters, if not, add them, and finally check the Overlap (protection section) condition "O_", check whether there is a comma before the character, if not, add it.

[0087] S6: Save and close the checked and corrected interlock table, and finally close the log file.

[0088] The present invention has the following beneficial effects:

[0089] 1. The above scheme designs a method for automatic inspection and correction of the interlocking table, which greatly reduces the time of manual inspection and correction, and avoids the misjudgment and omission problems that occur during manual inspection and correction, thereby improving work efficiency;

[0090] 2. The above scheme not only refers to the input file when the interlocking table is generated, but also checks the content of the interlocking table based on the input file combined with the equipment coordinates of the station diagram, parameter rule feature definitions, etc., which provides a way of thinking for the automatic generation of the interlocking table;

[0091] 3. The above scheme effectively ensures the input standardization of the interlocking table of the automated test input file, which is conducive to the implementation of the fully unmanned process of automated testing.

[0092] Although the content of the present invention has been described in detail through the above preferred embodiments, it should be appreciated that the above description should not be considered as a limitation of the present invention. After reading the above content, it will be apparent to those skilled in the art that various modifications and substitutions of the present invention will occur. Therefore, the protection scope of the present invention should be limited by the appended claims.

Claims

1. A method for checking and correcting an interlocking table, characterized in that: The following steps are involved: S1: define the document path, open the log file, and identify the location of the interlock table to be corrected under the document path; S2: Standardize the file name, file type and name of each page of the interlocking table; S3: Perform basic processing on the cells of each page of the interlocking table; S4: Correct the cells in the interlock table that need to check the sorting of the segment list; S5: Check and correct the cells of the interlocking table that need to check parameters according to the parameter rule feature definition; S6: Save and close the checked and corrected interlock table file, and finally close the log file; The S2 step includes the following contents: S21: Check and modify the file name of the interlock table. If there is a space at the end of the name, delete it; if there are spaces and / or dashes between words and numbers and / or between words in the file name, modify them to single underscores; if there is version information in the file name, delete the version information; S22: Change the file type of the interlocking table to xlsx file type; S23: Check the names of each page in the interlocking table, and if there are spaces and / or dashes between words in the page name, they are all changed to single underscores; if there are spaces at the beginning and / or end of the page name, they are deleted; The S4 step includes the following contents: S41: Check the list of the inner sections of the route in the route table, and re-sort them if they are not sorted in the forward direction according to the direction of the signal. S42: Check the approach section list of the approach section table, and re-sort it if it is not sorted in reverse order according to the direction of the signal; The S41 step includes the following contents: S411: Query the column number of the inner section of the route in the route table; S412: extracting the list in the inner section of the route and performing basic processing, that is, deleting the line feed and carriage return characters therein; S413: Check the list of the inner sections of the route according to the same direction of the signal lights, and make corrections if the sequence is wrong; The S5 step includes the following contents: S51: Check and correct the cell format and content of the automatic wrap table. S52: Check other conditions for opening the route signal table signal and correct any errors; The step S51 includes the following contents: S511: query the merged cell information of the automatic wrap table, extract the vertically merged cells in the list, and then split them, and fill in the same information as the first cell; S512: Query the route type column number, the fully automatic return identification column number, the priority route identification column in the fully automatic return, the return section column number, and the remarks column number of the automatic return table; S513: If the fully automatic reentry identification column number and / or the priority route identification column number in the fully automatic reentry is not found, insert a new column according to the identification column sorting, fill in the corresponding title in the new column, and initialize the cell format in the new column; S514: If there is a newly inserted column of the fully automatic return identification column and / or the priority route identification column in the fully automatic return, determine the value of the fully automatic return identification column and / or the priority route identification column in the fully automatic return according to the name of the automatic return table and the relevant route, fill it in, and check whether the route type is correct, and correct it if there is an error; S515: If there is no new fully automatic return identification column and / or a priority route identification column in the fully automatic return, then it is only necessary to check whether the values ​​of the route type class, the fully automatic return identification column and the priority route identification column in the fully automatic return are correct, and correct them if there are any errors; The step S52 includes the following contents: S521: Query the OtherConditions column number of Non CBTC in the route signal table; S522: Get the OtherConditions value of Non CBTC according to the signal in the route signal table, first perform basic processing on it, delete the carriage return and line feed characters, then check whether there are horizontal lines before the characters "ESP", "ESB", "PSD", and "KC". If there are, replace them with underscores, check whether there are English commas after these characters, if not, add them, and finally check the Overlap condition "O_" to check whether there is an English comma before the character, if not, add it.

2. The method for checking and correcting an interlocking table according to claim 1, characterized in that: The S3 step includes performing basic processing on the cells of each page regarding the interlocking devices and logical relationships: changing the Chinese commas therein to English commas, and deleting all spaces in the cells.

3. The method for checking and correcting an interlocking table according to claim 1, characterized in that: The step S42 includes the following contents: S421: Query the column number of the close segment in the close segment table; S422: extract the approaching section list of the incoming signal and perform basic processing, that is, split the prefix conditions of the turnout position and delete the line feed and carriage return characters therein; S423: Check the approach section list in reverse order of the signals, and make corrections if the order is wrong.

Images