Ground equipment test data automatic arrangement method, device and equipment and storage medium

Abstract

The invention discloses a ground equipment test data automatic arrangement method, apparatus and device, and a storage medium. The method comprises the steps of obtaining a file type and a storage structure of software test data of ground equipment; selecting an XML test data file and a DB test data file from the software test data according to the file type and the storage structure, and performing structure analysis on the XML test data file and the DB test data file to obtain a structure analysis result; and automatically analyzing and extracting the software test data by using a Python language according to the structure analysis result to obtain a test data arrangement result, and displaying the test data arrangement result through an Excel file, so that the quality cost caused by incomplete test data analysis is effectively reduced, the time and manpower expenses are greatly reduced, and the test efficiency is improved. The software quality of the ground equipment is effectively guaranteed, and the speed and efficiency of automatic arrangement of the test data of the ground equipment are improved.

Description

Technical Field

[0001] The present invention relates to the field of ground equipment software technology, and in particular to a method, device, equipment and storage medium for automatically arranging ground equipment test data. Background Art

[0002] With the rapid development of high-tech and the increasing demand for information warfare, equipment software has become increasingly complex, which has led to an increasing correlation between system reliability and software, and the quality requirements for software have continued to increase.

[0003] To ensure the high reliability of the software, a large number of tests are required throughout the entire life cycle of software development to provide comprehensive data support for the software's functions, performance characteristics, stability and security, so as to ensure the robustness of the software in various scenarios. During the testing process, it is difficult to discover potential problems by simply checking whether the test results are correct. Only test data can accurately reflect the quality of the software. Therefore, the test data must be analyzed in order to effectively detect hidden problems and accurately locate the root cause, so as to quickly and accurately fix the problems.

[0004] With the increasing complexity of software and the deepening of testing, the scale of test data continues to grow, especially for frequently used ground equipment, the data increases dramatically, and the traditional method of manual analysis of test data cannot meet the current needs of massive data; on the one hand, the traditional method is repetitive physical labor, which is prone to human errors. The comprehensiveness and accuracy of problem discovery do not match the human resources and time costs it consumes, and the timeliness is poor. The speed of manual analysis often cannot keep up with the project progress, thus missing the best decision-making opportunity; on the other hand, the format and structure of ground equipment software test data are different, and manual conversion and standardization are required, which increases the complexity of the work, and requires judgment on the correctness of the test results. The ability to identify abnormal data is highly dependent on the experience and ability of data analysts. Summary of the invention

[0005] The main purpose of the present invention is to provide a method, device, equipment and storage medium for automatic organization of ground equipment test data, aiming to solve the technical problems in the prior art that as the complexity of software increases, traditional manual analysis of test data cannot meet the needs of massive data, the identification of abnormal data depends on the experience and ability of data analysts, and the accuracy of test results is low.

[0006] In a first aspect, the present invention provides a method for automatically arranging ground equipment test data, the method comprising the following steps:

[0007] Obtain the file type and storage structure of software test data of ground equipment;

[0008] Selecting an XML test data file and a DB test data file from the software test data according to the file type and the storage structure, performing structural analysis on the XML test data file and the DB test data file, and obtaining a structural analysis result;

[0009] According to the structural analysis results, the software test data is automatically parsed and extracted using Python language to obtain test data collation results, and the test data collation results are displayed in an Excel file.

[0010] Optionally, the file type and storage structure of the software test data of the ground equipment are obtained, including:

[0011] Acquire software test data of ground equipment, analyze the software test data, and obtain the file type and storage structure of the software test data.

[0012] Optionally, selecting an XML test data file and a DB test data file from the software test data according to the file type and the storage structure, performing structural analysis on the XML test data file and the DB test data file, and obtaining a structural analysis result includes:

[0013] Using Python language to filter out XML test data files and DB test data files from the software test data according to the file type and the storage structure;

[0014] Performing structural analysis on the XML test data file to obtain various XML elements, generating an XML tree structure according to the various XML elements, and using the XML tree structure as an XML structural analysis result;

[0015] The DB test data file is subjected to structural analysis to obtain various database tables, and each database table is used as a DB structural analysis result.

[0016] Optionally, the using Python language to filter out XML test data files and DB test data files from the software test data according to the file type and the storage structure includes:

[0017] Traverse all files of the current process to determine whether the current process test data represented by each file is within the time period of this round of testing;

[0018] When the current process test data is within the current round of test time period, the XML test data file and the DB test data file are screened out from the software test data using Python language according to the file type and the storage structure.

[0019] Optionally, after traversing all files of the current process and determining whether the current process test data represented by each file is within the current round of test time period, the ground equipment test data automatic sorting method further includes:

[0020] When the current process test data of the current file is not within the current round test time period, continue to traverse the remaining files of the current process.

[0021] Optionally, the software test data is automatically parsed and extracted using Python language according to the structural analysis result to obtain a test data collation result, and the test data collation result is displayed in an Excel file, including:

[0022] According to the structural analysis results, the software test data is automatically parsed and extracted using Python language to obtain specific data of each level of the process;

[0023] Automatically organize the specific data to obtain test data organization results;

[0024] The test data collation results are presented in an Excel file.

[0025] Optionally, presenting the test data sorting results through an Excel file includes:

[0026] Using the description information of the test data sorting result as the row title of the Excel file;

[0027] Using the process execution time of the test data sorting result as the column title of the Excel file;

[0028] Normal data and abnormal data in the test data sorting result are displayed in different colors.

[0029] In a second aspect, in order to achieve the above-mentioned purpose, the present invention further proposes a device for automatically arranging test data of ground equipment, the device for automatically arranging test data of ground equipment comprising:

[0030] Data analysis module, used to obtain the file type and storage structure of software test data of ground equipment;

[0031] A structure analysis module, used for selecting an XML test data file and a DB test data file from the software test data according to the file type and the storage structure, performing structure analysis on the XML test data file and the DB test data file, and obtaining a structure analysis result;

[0032] The parsing and extraction module is used to automatically parse and extract the software test data using Python language according to the structural analysis results, obtain the test data sorting results, and display the test data sorting results through Excel files.

[0033] In the third aspect, to achieve the above-mentioned purpose, the present invention also proposes a ground equipment test data automatic organization device, the ground equipment test data automatic organization device comprising: a memory, a processor and a ground equipment test data automatic organization program stored in the memory and executable on the processor, the ground equipment test data automatic organization program is configured to implement the steps of the ground equipment test data automatic organization method as described above.

[0034] In a fourth aspect, in order to achieve the above-mentioned purpose, the present invention also proposes a storage medium, on which a ground equipment test data automatic organization program is stored, and when the ground equipment test data automatic organization program is executed by a processor, the steps of the ground equipment test data automatic organization method described above are implemented.

[0035] The method for automatically arranging ground equipment test data proposed in the present invention obtains the file type and storage structure of the software test data of the ground equipment; selects an XML test data file and a DB test data file from the software test data according to the file type and the storage structure, performs structural analysis on the XML test data file and the DB test data file, and obtains a structural analysis result; uses Python language to automatically parse and extract the software test data according to the structural analysis result to obtain a test data arranging result, and displays the test data arranging result through an Excel file, which can effectively solve the problems of low efficiency and high error rate caused by repetitive physical labor, and significantly improves data analysis efficiency and shortens the software development cycle. , accurately discover faults and locate their sources, facilitate statistics on test case execution coverage, conduct supplementary tests in a timely manner, and effectively control the risk of misinterpretation and delays in the software development cycle due to insufficient knowledge reserves of analysts. It not only eliminates human errors, but also improves analysis efficiency, helps to discover potential problems, and has important capabilities in ensuring software quality and shortening the development cycle. It effectively reduces the quality costs caused by incomplete test data analysis, significantly reduces the learning costs of analysts and the risk of errors caused by switching between different types of files for review, ensures the adequacy and comprehensiveness of software testing, and greatly reduces time and manpower expenses. While improving efficiency, it effectively ensures the quality of ground equipment software and improves the speed and efficiency of automatic collation of ground equipment test data. BRIEF DESCRIPTION OF THE DRAWINGS

[0036] Figure 1A schematic diagram of the device structure of the hardware operating environment involved in the embodiment of the present invention;

[0037] Figure 2 It is a flowchart of a first embodiment of the method for automatically arranging ground equipment test data of the present invention;

[0038] Figure 3 It is a flow chart of a second embodiment of the method for automatically arranging ground equipment test data of the present invention;

[0039] Figure 4 A schematic diagram of a flow chart of a third embodiment of a method for automatically arranging ground equipment test data according to the present invention;

[0040] Figure 5 It is a flowchart of a fourth embodiment of the method for automatically arranging ground equipment test data of the present invention;

[0041] Figure 6 It is a tree structure diagram of the XML test data file in the method for automatically arranging ground equipment test data of the present invention;

[0042] Figure 7 A flow chart for screening the validity of test data in the method for automatically arranging test data of ground equipment of the present invention;

[0043] Figure 8 It is a functional module diagram of the first embodiment of the automatic arrangement device for ground equipment test data of the present invention.

[0044] The realization of the purpose, functional features and advantages of the present invention will be further explained in conjunction with embodiments and with reference to the accompanying drawings. DETAILED DESCRIPTION

[0045] 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.

[0046] The solution of the embodiment of the present invention is mainly: by obtaining the file type and storage structure of the software test data of the ground equipment; selecting the XML test data file and the DB test data file from the software test data according to the file type and the storage structure, performing structural analysis on the XML test data file and the DB test data file to obtain the structural analysis result; according to the structural analysis result, using Python language to automatically parse and extract the software test data to obtain the test data sorting result, and presenting the test data sorting result through an Excel file, which can effectively solve the problems of low efficiency and high error rate caused by repetitive physical labor, and significantly improve the data analysis efficiency, shorten the software development cycle, accurately discover faults, locate the source, facilitate the statistics of test case execution coverage, and conduct supplementary tests in time, effectively control It can reduce the risk of misinterpretation and delay of software development cycle due to insufficient knowledge reserve of analysts, not only eliminate human errors, but also improve analysis efficiency, help to discover potential problems, and play an important role in ensuring software quality and shortening development cycle, effectively reduce the quality cost caused by incomplete test data analysis, significantly reduce the learning cost of analysts and the risk of errors caused by switching between different types of files for review, ensure the adequacy and comprehensiveness of software testing, greatly reduce time and manpower expenses, effectively ensure the quality of ground equipment software while improving efficiency, improve the speed and efficiency of automatic sorting of ground equipment test data, and solve the technical problems in the existing technology that as the complexity of software increases, traditional manual analysis of test data cannot meet the needs of massive data, the identification of abnormal data depends on the experience and ability of data analysts, and the accuracy of test results is low.

[0047] Reference Figure 1 , Figure 1 The figure is a schematic diagram of the device structure of the hardware operating environment involved in the embodiment of the present invention.

[0048] like Figure 1As shown, the device may include: a processor 1001, such as a CPU, a communication bus 1002, a user interface 1003, a network interface 1004, and a memory 1005. Among them, the communication bus 1002 is used to realize the connection and communication between these components. The user interface 1003 may include a display screen (Display), an input unit such as a keyboard (Keyboard), and the optional user interface 1003 may also include a standard wired interface and a wireless interface. The network interface 1004 may optionally include a standard wired interface and a wireless interface (such as a Wi-Fi interface). The memory 1005 may be a high-speed RAM memory, or it may be a stable memory (Non-Volatile Memory), such as a disk memory. The memory 1005 may optionally be a storage device independent of the aforementioned processor 1001.

[0049] Those skilled in the art will understand that Figure 1 The device structure shown in the figure does not constitute a limitation of the device, and may include more or less components than shown in the figure, or combine certain components, or arrange the components differently.

[0050] like Figure 1 As shown, the memory 1005 as a storage medium may include an operating device, a network communication module, a user interface module, and a ground equipment test data automatic organization program.

[0051] The device of the present invention calls the ground equipment test data automatic arrangement program stored in the memory 1005 through the processor 1001, and performs the following operations:

[0052] Obtain the file type and storage structure of software test data of ground equipment;

[0053] Selecting an XML test data file and a DB test data file from the software test data according to the file type and the storage structure, performing structural analysis on the XML test data file and the DB test data file, and obtaining a structural analysis result;

[0054] According to the structural analysis results, the software test data is automatically parsed and extracted using Python language to obtain test data collation results, and the test data collation results are displayed in an Excel file.

[0055] The device of the present invention calls the ground equipment test data automatic arrangement program stored in the memory 1005 through the processor 1001, and also performs the following operations:

[0056] Acquire software test data of ground equipment, analyze the software test data, and obtain the file type and storage structure of the software test data.

[0057] The device of the present invention calls the ground equipment test data automatic arrangement program stored in the memory 1005 through the processor 1001, and also performs the following operations:

[0058] Using Python language to filter out XML test data files and DB test data files from the software test data according to the file type and the storage structure;

[0059] Performing structural analysis on the XML test data file to obtain various XML elements, generating an XML tree structure according to the various XML elements, and using the XML tree structure as an XML structural analysis result;

[0060] The DB test data file is subjected to structural analysis to obtain various database tables, and each database table is used as a DB structural analysis result.

[0061] The device of the present invention calls the ground equipment test data automatic arrangement program stored in the memory 1005 through the processor 1001, and also performs the following operations:

[0062] Traverse all files of the current process to determine whether the current process test data represented by each file is within the time period of this round of testing;

[0063] When the current process test data is within the current round of test time period, the XML test data file and the DB test data file are screened out from the software test data using Python language according to the file type and the storage structure.

[0064] The device of the present invention calls the ground equipment test data automatic arrangement program stored in the memory 1005 through the processor 1001, and also performs the following operations:

[0065] When the current process test data of the current file is not within the current round test time period, continue to traverse the remaining files of the current process.

[0066] The device of the present invention calls the ground equipment test data automatic arrangement program stored in the memory 1005 through the processor 1001, and also performs the following operations:

[0067] According to the structural analysis results, the software test data is automatically parsed and extracted using Python language to obtain specific data of each level of the process;

[0068] Automatically organize the specific data to obtain test data organization results;

[0069] The test data collation results are presented in an Excel file.

[0070] The device of the present invention calls the ground equipment test data automatic arrangement program stored in the memory 1005 through the processor 1001, and also performs the following operations:

[0071] Using the description information of the test data sorting result as the row title of the Excel file;

[0072] Using the process execution time of the test data sorting result as the column title of the Excel file;

[0073] Normal data and abnormal data in the test data sorting result are displayed in different colors.

[0074] This embodiment adopts the above scheme, by obtaining the file type and storage structure of the software test data of the ground equipment; selecting the XML test data file and the DB test data file from the software test data according to the file type and the storage structure, performing structural analysis on the XML test data file and the DB test data file to obtain the structural analysis result; using the Python language to automatically parse and extract the software test data according to the structural analysis result to obtain the test data sorting result, and presenting the test data sorting result through an Excel file, which can effectively solve the problems of low efficiency and high error rate caused by repetitive manual labor, and significantly improve the data analysis efficiency, shorten the software development cycle, and accurately develop It can find faults and locate their sources, facilitate statistics on the execution coverage of test cases, conduct supplementary tests in a timely manner, and effectively control the risks of misinterpretation and delays in the software development cycle due to insufficient knowledge reserves of analysts. It not only eliminates human errors, but also improves analysis efficiency and helps to discover potential problems. It has important capabilities in ensuring software quality and shortening the development cycle, effectively reduces the quality costs caused by incomplete test data analysis, significantly reduces the learning costs of analysts and the risk of errors caused by switching between different types of files for review, ensures the adequacy and comprehensiveness of software testing, greatly reduces time and manpower expenses, and effectively ensures the quality of ground equipment software while improving efficiency, and improves the speed and efficiency of automatic sorting of ground equipment test data.

[0075] Based on the above hardware structure, an embodiment of the method for automatically organizing ground equipment test data of the present invention is proposed.

[0076] Reference Figure 2 , Figure 2 It is a flowchart diagram of the first embodiment of the method for automatically organizing ground equipment test data of the present invention.

[0077] In a first embodiment, the method for automatically arranging ground equipment test data includes the following steps:

[0078] Step S10: Obtain the file type and storage structure of the software test data of the ground equipment.

[0079] It should be noted that the software test data is test data stored in association with the software of the ground equipment, and different test data have corresponding file types and storage structures.

[0080] Step S20: selecting an XML test data file and a DB test data file from the software test data according to the file type and the storage structure, performing structural analysis on the XML test data file and the DB test data file, and obtaining a structural analysis result.

[0081] It should be understood that, by selecting extensible markup language (XML) test data files and database (DB) test data files from the software test data through the file type and the storage structure, and after performing structural analysis on the XML test data files and the DB test data files, the structural analysis results of the corresponding XML test data files and DB test data files can be obtained respectively.

[0082] Step S30: According to the structural analysis result, the software test data is automatically parsed and extracted using Python language to obtain a test data collation result, and the test data collation result is displayed in an Excel file.

[0083] It can be understood that the software test data can be parsed and extracted according to the structural analysis results, and the automatic parsing and extraction of the software test data can be realized by using Python language, so as to obtain the test data collation results, and then the test data collation results can be displayed through Excel files.

[0084] This embodiment adopts the above scheme, by obtaining the file type and storage structure of the software test data of the ground equipment; selecting the XML test data file and the DB test data file from the software test data according to the file type and the storage structure, performing structural analysis on the XML test data file and the DB test data file to obtain the structural analysis result; using the Python language to automatically parse and extract the software test data according to the structural analysis result to obtain the test data sorting result, and presenting the test data sorting result through an Excel file, which can effectively solve the problems of low efficiency and high error rate caused by repetitive manual labor, and significantly improve the data analysis efficiency, shorten the software development cycle, and accurately develop It can find faults and locate their sources, facilitate statistics on the execution coverage of test cases, conduct supplementary tests in a timely manner, and effectively control the risks of misinterpretation and delays in the software development cycle due to insufficient knowledge reserves of analysts. It not only eliminates human errors, but also improves analysis efficiency and helps to discover potential problems. It has important capabilities in ensuring software quality and shortening the development cycle, effectively reduces the quality costs caused by incomplete test data analysis, significantly reduces the learning costs of analysts and the risk of errors caused by switching between different types of files for review, ensures the adequacy and comprehensiveness of software testing, greatly reduces time and manpower expenses, and effectively ensures the quality of ground equipment software while improving efficiency, and improves the speed and efficiency of automatic sorting of ground equipment test data.

[0085] Further, Figure 3 FIG. 1 is a flow chart of a second embodiment of the method for automatically arranging ground equipment test data according to the present invention. Figure 3 As shown, a second embodiment of the method for automatically arranging ground equipment test data of the present invention is proposed based on the first embodiment. In this embodiment, step S10 specifically includes the following steps:

[0086] Step S11: Acquire software test data of ground equipment, analyze the software test data, and obtain the file type and storage structure of the software test data.

[0087] It should be noted that after obtaining the software test data of the ground equipment, the file type and storage structure of the software test data can be obtained by analyzing the software test data.

[0088] Through the above-mentioned scheme, this embodiment obtains the software test data of the ground equipment, analyzes the software test data, and obtains the file type and storage structure of the software test data. It can quickly obtain the file type and storage structure of the test data, thereby improving the speed and efficiency of automatic sorting of ground equipment test data.

[0089] Further, Figure 4FIG. 1 is a flow chart of a third embodiment of the method for automatically arranging ground equipment test data according to the present invention. Figure 4 As shown, a third embodiment of the method for automatically arranging ground equipment test data of the present invention is proposed based on the first embodiment. In this embodiment, step S20 specifically includes the following steps:

[0090] Step S21: Using Python language to select and retrieve XML test data files and DB test data files from the software test data according to the file type and the storage structure.

[0091] It should be noted that, according to the file type and the storage structure, Python language can be used for data screening, that is, a test data parsing tool can be written in Python language to screen out XML test data files and DB test data files from the software test data.

[0092] In the specific implementation, in the field of ground equipment software, the test data includes multiple file types such as PDF, TXT, DB, XML, ASC, etc., but because the DB files storing the original data and the XML files storing the execution status of the control process already contain all the test information, only these two types of files need to be analyzed and processed. The test data is stored in the "test record" folder under the program path and is stored according to different control process categories.

[0093] Furthermore, the step S21 specifically includes the following steps:

[0094] Traverse all files of the current process to determine whether the current process test data represented by each file is within the time period of this round of testing;

[0095] When the current process test data is within the current round of test time period, the XML test data file and the DB test data file are screened out from the software test data using Python language according to the file type and the storage structure.

[0096] It can be understood that by traversing all files of the current process, it is determined whether the current process test data represented by each file is within the time period of this round of testing; when the current process test data is within the time period of this round of testing, the XML test data file and the DB test data file are filtered out from the software test data using Python language according to the file type and the storage structure.

[0097] Furthermore, after traversing all files of the current process and determining whether the current process test data represented by each file is within the time period of this round of testing, the method for automatically arranging ground equipment test data further includes the following steps:

[0098] When the current process test data of the current file is not within the current round test time period, continue to traverse the remaining files of the current process.

[0099] In the specific implementation, a test data parsing tool is written in Python. This tool traverses the test files, filters the file types, parses the target files, extracts specific data, and automatically organizes the test data. Then, the test data is screened, parsed, and extracted for effectiveness. That is, a test data parsing tool is written in Python to extract the core information in the test data and automatically organize it, which greatly reduces the labor cost of manual data review, effectively solves the problems of low efficiency and high error rate caused by repetitive physical labor, significantly improves data analysis efficiency, and shortens the software development cycle.

[0100] Step S22: Perform structural analysis on the XML test data file to obtain various XML elements, generate an XML tree structure according to each XML element, and use the XML tree structure as the XML structural analysis result.

[0101] It can be understood that by performing structural analysis on the XML test data file, XML elements can be obtained, and then an XML tree structure can be generated according to each XML element, so that the XML tree structure is used as the XML structural analysis result.

[0102] In the specific implementation, the XML test data file structure is analyzed, and each element is parsed to extract a regular tree structure.

[0103] Step S23: Perform structural analysis on the DB test data file to obtain each database table, and use each database table as a DB structural analysis result.

[0104] It should be understood that by performing structural analysis on the DB test data file, each database table can be obtained, and then each database table is used as a DB structural analysis result.

[0105] In a specific implementation, the DB test data file structure is analyzed, which includes multiple database tables, each of which contains one or more groups of data.

[0106] Through the above scheme, this embodiment uses Python language to filter out XML test data files and DB test data files from the software test data according to the file type and the storage structure; performs structural analysis on the XML test data file to obtain each XML element, generates an XML tree structure according to each XML element, and uses the XML tree structure as the XML structural analysis result; performs structural analysis on the DB test data file to obtain each database table, and uses each database table as the DB structural analysis result, so that the XML structural analysis result and the DB structural analysis result can be quickly obtained, effectively solving the problems of low efficiency and high error rate caused by repetitive manual labor, and significantly improving the data analysis efficiency, and improving the speed and efficiency of automatic sorting of ground equipment test data.

[0107] Further, Figure 5 FIG. 4 is a flow chart of a fourth embodiment of the method for automatically arranging ground equipment test data according to the present invention. Figure 5 As shown, a fourth embodiment of the method for automatically arranging ground equipment test data of the present invention is proposed based on the first embodiment. In this embodiment, step S30 specifically includes the following steps:

[0108] Step S31: According to the structural analysis results, the software test data is automatically parsed and extracted using Python language to obtain specific data for each level of the process.

[0109] It should be noted that, according to the structural analysis results, the software test data can be automatically parsed and extracted using Python language, and specific data of each level of the process can be extracted.

[0110] In the specific implementation, see Figure 6 , Figure 6 This is a tree structure diagram of the XML test data file in the method for automatically arranging ground equipment test data of the present invention, such as Figure 6 As shown, each element is parsed and a regular tree structure is extracted. The tree structure corresponding to the test result is a primary process, a secondary process, a tertiary process and a specific process.

[0111] Step S32: automatically organize the specific data to obtain test data organization results.

[0112] It can be understood that after the specific data is automatically sorted, the test data sorting results can be obtained, and the test data can be analyzed and sorted. The file format covers commonly used storage types of ground equipment software such as XML and DB, which is conducive to discovering potential software defects, so as to take timely measures to correct them and improve software quality.

[0113] Step S33: Display the test data sorting results through an Excel file.

[0114] It should be understood that after obtaining the test data collation results, they can be presented through an Excel file.

[0115] Furthermore, the step S33 specifically includes the following steps:

[0116] Using the description information of the test data sorting result as the row title of the Excel file;

[0117] Using the process execution time of the test data sorting result as the column title of the Excel file;

[0118] Normal data and abnormal data in the test data sorting result are displayed in different colors.

[0119] It should be understood that see Figure 7 , Figure 7 This is a flow chart of test data validity screening in the method for automatically arranging test data of ground equipment of the present invention, such as Figure 7 As shown, test data validity screening; based on the execution time of this round of testing, the test data is screened again to ensure the timeliness of the data; XML test data file parsing and extraction; automatic parsing of XML files to quickly extract the description information and execution results of each step, DB test data file parsing and extraction, and automatic parsing of DB files.

[0120] In the specific implementation, the test data collation results are displayed through Excel files, and the results extracted from XML test data and DB test data are written into the Excel files. The row header of each table is the description information of the data, and the column header is the execution time of the process. Normal data is displayed in black and abnormal data is displayed in red, which is convenient for manual viewing. Analysts do not need to master professional knowledge such as relevant file formats, and can clearly view the execution results and quickly locate abnormal data, effectively controlling the risk of misinterpretation and delay of software development cycle caused by insufficient knowledge reserves of analysts; the collated test data is displayed through Excel files, and the abnormal data is highlighted. On the one hand, it is beneficial for analysts to understand the test results in time and quickly query the status information of the system when the abnormality occurs, so as to accurately discover the fault and locate the source. On the other hand, it is convenient to count the execution coverage of the test case and conduct supplementary tests in time; there is no limit on the amount of test data, which is suitable for the huge amount of test data of current ground equipment software, and at the same time meets the growth demand of test data scale in the future.

[0121] Through the above scheme, this embodiment analyzes the software test data through the structural analysis results to extract specific data of each level of the process; automatically organizes the specific data to obtain test data organization results; and displays the test data organization results through an Excel file, which can effectively solve the problems of low efficiency and high error rate caused by repetitive physical labor, and significantly improve data analysis efficiency, shorten the software development cycle, accurately discover faults and locate the source, facilitate statistics on test case execution coverage, and conduct supplementary tests in a timely manner, effectively control the risk of misinterpretation and software development cycle delays caused by insufficient knowledge reserves of analysts, not only eliminate human errors, but also improve analysis efficiency.

[0122] Correspondingly, the present invention further provides a device for automatically organizing ground equipment test data.

[0123] Reference Figure 8 , Figure 8 It is a functional module diagram of the first embodiment of the automatic arrangement device for ground equipment test data of the present invention.

[0124] In a first embodiment of the ground equipment test data automatic arrangement device of the present invention, the ground equipment test data automatic arrangement device comprises:

[0125] The data analysis module 10 is used to obtain the file type and storage structure of the software test data of the ground equipment.

[0126] The structure analysis module 20 is used to select an XML test data file and a DB test data file from the software test data according to the file type and the storage structure, perform structure analysis on the XML test data file and the DB test data file, and obtain a structure analysis result.

[0127] The parsing and extraction module 30 is used to automatically parse and extract the software test data using Python language according to the structural analysis results, obtain the test data sorting results, and display the test data sorting results through an Excel file.

[0128] The data analysis module 10 is also used to obtain software test data of ground equipment, analyze the software test data, and obtain the file type and storage structure of the software test data.

[0129] The structural analysis module 20 is also used to use Python language to filter out XML test data files and DB test data files from the software test data according to the file type and the storage structure; perform structural analysis on the XML test data file to obtain each XML element, generate an XML tree structure according to each XML element, and use the XML tree structure as the XML structural analysis result; perform structural analysis on the DB test data file to obtain each database table, and use each database table as the DB structural analysis result.

[0130] The structural analysis module 20 is also used to traverse all files of the current process to determine whether the current process test data represented by each file is within the time period of this round of testing; when the current process test data is within the time period of this round of testing, the XML test data file and the DB test data file are screened out from the software test data using Python language according to the file type and the storage structure.

[0131] The structure analysis module 20 is further configured to continue traversing the remaining files of the current process when the current process test data of the current file is not within the current round test time period.

[0132] The parsing and extraction module 30 is also used to automatically parse and extract the software test data using Python language according to the structural analysis results to obtain specific data of each level of the process; automatically organize the specific data to obtain test data organization results; and display the test data organization results through an Excel file.

[0133] The parsing and extraction module 30 is also used to use the descriptive information of the test data sorting result as the row title of the Excel file; use the process execution time of the test data sorting result as the column title of the Excel file; and display the normal data and abnormal data in the test data sorting result in different colors.

[0134] Among them, the steps implemented by each functional module of the ground equipment test data automatic sorting device can refer to the various embodiments of the ground equipment test data automatic sorting method of the present invention, and will not be repeated here.

[0135] In addition, an embodiment of the present invention further provides a storage medium, on which a ground equipment test data automatic arrangement program is stored. When the ground equipment test data automatic arrangement program is executed by a processor, the following operations are implemented:

[0136] Obtain the file type and storage structure of software test data of ground equipment;

[0137] Selecting an XML test data file and a DB test data file from the software test data according to the file type and the storage structure, performing structural analysis on the XML test data file and the DB test data file, and obtaining a structural analysis result;

[0138] According to the structural analysis results, the software test data is automatically parsed and extracted using Python language to obtain test data collation results, and the test data collation results are displayed in an Excel file.

[0139] Furthermore, when the ground equipment test data automatic arrangement program is executed by the processor, the following operations are also implemented:

[0140] Acquire software test data of ground equipment, analyze the software test data, and obtain the file type and storage structure of the software test data.

[0141] Furthermore, when the ground equipment test data automatic arrangement program is executed by the processor, the following operations are also implemented:

[0142] Using Python language to filter out XML test data files and DB test data files from the software test data according to the file type and the storage structure;

[0143] Performing structural analysis on the XML test data file to obtain various XML elements, generating an XML tree structure according to the various XML elements, and using the XML tree structure as an XML structural analysis result;

[0144] The DB test data file is subjected to structural analysis to obtain various database tables, and each database table is used as a DB structural analysis result.

[0145] Furthermore, when the ground equipment test data automatic arrangement program is executed by the processor, the following operations are also implemented:

[0146] Using Python language to filter out XML test data files and DB test data files from the software test data according to the file type and the storage structure;

[0147] Performing structural analysis on the XML test data file to obtain various XML elements, generating an XML tree structure according to the various XML elements, and using the XML tree structure as an XML structural analysis result;

[0148] The DB test data file is subjected to structural analysis to obtain various database tables, and each database table is used as a DB structural analysis result.

[0149] Furthermore, when the ground equipment test data automatic arrangement program is executed by the processor, the following operations are also implemented:

[0150] When the current process test data of the current file is not within the current round test time period, continue to traverse the remaining files of the current process.

[0151] Furthermore, when the ground equipment test data automatic arrangement program is executed by the processor, the following operations are also implemented:

[0152] According to the structural analysis results, the software test data is automatically parsed and extracted using Python language to obtain specific data of each level of the process;

[0153] Automatically organize the specific data to obtain test data organization results;

[0154] The test data collation results are presented in an Excel file.

[0155] Furthermore, when the ground equipment test data automatic arrangement program is executed by the processor, the following operations are also implemented:

[0156] Using the description information of the test data sorting result as the row title of the Excel file;

[0157] Using the process execution time of the test data sorting result as the column title of the Excel file;

[0158] Normal data and abnormal data in the test data sorting result are displayed in different colors.

[0159] Those skilled in the art will appreciate that all or part of the steps in the above-mentioned implementation method can be accomplished by instructing related hardware through a program, and the program is stored in a storage medium, including a number of instructions for enabling a device (which may be a single-chip microcomputer, chip, etc.) or a processor to execute all or part of the steps of the method described in each implementation method of the present application; and the aforementioned storage medium is a computer-readable storage medium, including but not limited to: U disk, mobile hard disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), disk or optical disk, and other media that can store program codes.

[0160] It should be noted that, in this article, the terms "include", "comprises" or any other variations thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device. In the absence of further restrictions, an element defined by the sentence "comprises a ..." does not exclude the existence of other identical elements in the process, method, article or device including the element.

[0161] The serial numbers of the above embodiments of the present invention are only for description and do not represent the advantages or disadvantages of the embodiments.

[0162] The above are only preferred embodiments of the present invention, and are not intended to limit the patent scope of the present invention. Any equivalent structure or equivalent process transformation made using the contents of the present invention specification and drawings, or directly or indirectly applied in other related technical fields, are also included in the patent protection scope of the present invention.

Claims

1. A method for automatically arranging ground equipment test data, characterized in that: The method for automatically arranging ground equipment test data comprises: Obtain the file type and storage structure of software test data of ground equipment; Selecting an XML test data file and a DB test data file from the software test data according to the file type and the storage structure, performing structural analysis on the XML test data file and the DB test data file, and obtaining a structural analysis result; According to the structural analysis results, the software test data is automatically parsed and extracted using Python language to obtain test data collation results, and the test data collation results are displayed in an Excel file.

2. The method for automatically arranging ground equipment test data according to claim 1, characterized in that: The file type and storage structure of obtaining the software test data of the ground equipment include: Acquire software test data of ground equipment, analyze the software test data, and obtain the file type and storage structure of the software test data.

3. The method for automatically arranging ground equipment test data according to claim 1, characterized in that: The step of selecting an XML test data file and a DB test data file from the software test data according to the file type and the storage structure, performing structural analysis on the XML test data file and the DB test data file, and obtaining a structural analysis result includes: Using Python language to filter out XML test data files and DB test data files from the software test data according to the file type and the storage structure; Performing structural analysis on the XML test data file to obtain various XML elements, generating an XML tree structure according to the various XML elements, and using the XML tree structure as an XML structural analysis result; The DB test data file is subjected to structural analysis to obtain various database tables, and each database table is used as a DB structural analysis result.

4. The method for automatically arranging ground equipment test data according to claim 3, characterized in that: The method of selecting and retrieving the XML test data file and the DB test data file from the software test data using the Python language according to the file type and the storage structure includes: Traverse all files of the current process to determine whether the current process test data represented by each file is within the time period of this round of testing; When the current process test data is within the current round of test time period, the XML test data file and the DB test data file are screened out from the software test data using Python language according to the file type and the storage structure.

5. The method for automatically arranging ground equipment test data according to claim 4, characterized in that: After traversing all files of the current process and determining whether the current process test data represented by each file is within the current round of test time period, the ground equipment test data automatic sorting method further includes: When the current process test data of the current file is not within the current round test time period, continue to traverse the remaining files of the current process.

6. The method for automatically arranging ground equipment test data according to claim 1, characterized in that: The method of automatically parsing and extracting the software test data using Python language according to the structural analysis results to obtain test data collation results, and presenting the test data collation results through an Excel file, includes: According to the structural analysis results, the software test data is automatically parsed and extracted using Python language to obtain specific data of each level of the process; Automatically organize the specific data to obtain test data organization results; The test data collation results are presented in an Excel file.

7. The method for automatically arranging ground equipment test data according to claim 6, characterized in that: The test data sorting results are displayed in an Excel file, including: Using the description information of the test data sorting result as the row title of the Excel file; Using the process execution time of the test data sorting result as the column title of the Excel file; Normal data and abnormal data in the test data sorting result are displayed in different colors.

8. A device for automatically arranging ground equipment test data, characterized in that: The ground equipment test data automatic arrangement device comprises: Data analysis module, used to obtain the file type and storage structure of software test data of ground equipment; A structure analysis module, used for selecting an XML test data file and a DB test data file from the software test data according to the file type and the storage structure, performing structure analysis on the XML test data file and the DB test data file, and obtaining a structure analysis result; The parsing and extraction module is used to automatically parse and extract the software test data using Python language according to the structural analysis results, obtain the test data sorting results, and display the test data sorting results through Excel files.

9. A ground equipment test data automatic sorting device, characterized in that: The ground equipment test data automatic organization device comprises: a memory, a processor and a ground equipment test data automatic organization program stored in the memory and executable on the processor, wherein the ground equipment test data automatic organization program is configured to implement the steps of the ground equipment test data automatic organization method as described in any one of claims 1 to 7.

10. A storage medium, characterized in that: The storage medium stores a program for automatically arranging ground equipment test data, and when the program for automatically arranging ground equipment test data is executed by a processor, the steps of the method for automatically arranging ground equipment test data as described in any one of claims 1 to 7 are implemented.

Images