CN113127340A

CN113127340A - Multi-test information linking method, system and medium

Info

Publication number: CN113127340A
Application number: CN202110324613.0A
Authority: CN
Inventors: 杨鄢铭
Original assignee: Shandong Yingxin Computer Technology Co Ltd
Current assignee: Shandong Yingxin Computer Technology Co Ltd
Priority date: 2021-03-26
Filing date: 2021-03-26
Publication date: 2021-07-16
Anticipated expiration: 2041-03-26
Also published as: CN113127340B

Abstract

The invention discloses a multi-test information linking method, which comprises the following steps: acquiring a test result, creating a first preset file and a test template, and creating a link subfile based on the test result, the first preset file and the test template; acquiring a first scanning start bit of the link subfile, and executing a linking step based on the first scanning start bit and the link subfile to obtain a first jump link; modifying the first scanning start bit to obtain a second scanning start bit, and executing a judgment step based on the second scanning start bit to obtain a first judgment result; generating a linked test file based on the first judgment result and the first jump link; the invention can automatically establish link between the test report and the test result, greatly improves the processing efficiency of the test report and improves the accuracy of the test report.

Description

Multi-test information linking method, system and medium

Technical Field

The invention relates to the technical field of software programming, in particular to a method, a system and a medium for linking multiple test information.

Background

In the process of server production test, corresponding test results are generated for each firmware in the server, and the test results are in the form of pictures. When the test report of the server is completed, the test result picture and the corresponding test report item need to be linked in a targeted manner, so that the test report is complete. In the prior art, the test result picture and the corresponding test report are linked in a manual configuration and identification mode, the mode is time-consuming and extremely low in efficiency, and many uncertainty factors are generated under manual participation, so that the accuracy of the test report is reduced.

Disclosure of Invention

The invention mainly solves the problems of low processing efficiency, poor accuracy of processing results and overhigh time cost of the prior art for linking the test report and the test result picture.

In order to solve the technical problems, the invention adopts a technical scheme that: the method for linking the multiple test information comprises the following steps:

acquiring a test result, creating a first preset file and a test template, and creating a link subfile based on the test result, the first preset file and the test template;

acquiring a first scanning start bit of the link subfile, and executing a linking step based on the first scanning start bit and the link subfile to obtain a first jump link;

modifying the first scanning start bit to obtain a second scanning start bit, and executing a judgment step based on the second scanning start bit to obtain a first judgment result;

and generating a linked test file based on the first judgment result and the first jump link.

As an improvement, the step of creating a link subfile based on the test result, the first preset file and the test template further comprises:

configuring a first execution function, and executing a first presetting step on the first preset file based on the first execution function and the test template to obtain a second preset file;

and configuring a second execution function, and executing a second preset step on the second preset file based on the second execution function and the test result to obtain the link subfile.

As an improvement, the linking step includes:

acquiring first subfile information located in the first scanning start bit in the link subfiles;

acquiring first identification information corresponding to the first subfile information in the link subfile;

integrating the first subfile information and the first identification information to obtain a first link medium;

generating the first jump link based on the first link medium.

As an improvement, the step of generating the first jump link based on the first link medium further includes:

and configuring a hyperlink function, and calling the hyperlink function to establish the first jump link between the result subfile corresponding to the first subfile information in the test result and the first link medium.

As an improvement, the judging step includes:

acquiring second subfile information located in the second scanning start bit in the link subfiles;

setting a character value, and judging whether the second subfile information is matched with the character value; if the first judgment result is matched with the second judgment result, the first judgment result is set as a first result; and if not, setting the first judgment result as a second result.

As an improvement, the step of generating a linked test file based on the first judgment result and the first jump link further includes:

when the first judgment result is the first result, the linked test file is generated based on the first jump link;

when the first judgment result is the second result, executing the linking step based on the second scanning start bit to obtain a second jump link; modifying the second scanning start bit to obtain a third scanning start bit; and executing the judging step based on the third scanning start bit to obtain a second judging result, and generating the linked test file based on the second judging result, the first jump link and the second jump link.

As an improvement, the first presetting step includes:

setting the first scanning start bit in the first preset file based on the test template;

acquiring document information and chart information of the test template;

and calling the first execution function, and modifying the chart value of the first preset file based on the document information and the chart information to obtain the second preset file.

As an improvement, the second presetting step includes:

calling the second execution function to acquire third subfile information in the test result and third identification information corresponding to the third subfile information;

setting a first information filling field and a second information filling field of the second preset file;

and respectively placing the third subfile information and the third identification information into the first information filling domain and the second information filling domain to obtain the link subfile.

The invention also provides a multi-test information linking system, which comprises:

the system comprises a subfile creating module, a linking module, a circulating judgment module and a report generating module;

the subfile creating module is used for acquiring a test result and creating a first preset file and a test template; the subfile creating module creates a link subfile according to the test result, the first preset file and the test template;

the link module is used for acquiring a first scanning start bit of the link subfile, and executing a link step based on the first scanning start bit and the link subfile to obtain a first jump link;

the cycle judgment module is used for modifying the first scanning start bit to obtain a second scanning start bit, and the cycle judgment module executes a judgment step through the second scanning start bit to obtain a first judgment result;

and the report generating module is used for generating a linked test file according to the first judgment result and the first jump link.

The present invention also provides a computer readable storage medium having stored thereon a computer program which, when executed by a processor, implements the steps of the method of linking multiple test information.

The invention has the beneficial effects that:

1. the multi-test information linking method can realize the automatic link establishment of the test report and the test result under the framework of the method, and can meet the link requirements of various template test reports by modifying a basic table under the framework, thereby greatly improving the processing efficiency of the test reports and improving the accuracy of the test reports.

2. The multi-test information linking system can automatically establish the link between the test report and the test result under the framework generated by the system through the mutual matching of the subfile creating module, the linking module, the circulating judgment module and the report generating module, and can meet the linking requirements of various template test reports by modifying a basic table under the framework, thereby greatly improving the processing efficiency of the test reports and improving the accuracy of the test reports.

3. The computer-readable storage medium can realize the cooperation of the bootstrap file creating module, the linking module, the circulation judging module and the report generating module, further realize the automatic link establishment of the test report and the test result, and can meet the link requirements of various template test reports, thereby greatly improving the processing efficiency of the test report, improving the accuracy of the test report and simultaneously effectively increasing the operability of the multi-test information linking method.

Drawings

In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and other drawings can be obtained by those skilled in the art without creative efforts.

FIG. 1 is a flowchart of a method for linking multiple test messages according to embodiment 1 of the present invention;

fig. 2 is a schematic flowchart of a multi-test information linking method according to embodiment 1 of the present invention;

fig. 3 is a schematic diagram illustrating an implementation effect of the third information linking architecture according to embodiment 1 of the present invention;

FIG. 4 is a schematic diagram illustrating an implementation effect of linking subfiles according to embodiment 1 of the present invention;

FIG. 5 is a schematic diagram of an implementation effect of the test template according to embodiment 1 of the present invention;

fig. 6 is an architecture diagram of a multi-test information linking system according to embodiment 2 of the present invention.

Detailed Description

The following detailed description of the preferred embodiments of the present invention, taken in conjunction with the accompanying drawings, will make the advantages and features of the invention easier to understand by those skilled in the art, and thus will clearly and clearly define the scope of the invention.

In the description of the present invention, it should be noted that the described embodiments of the present invention are a part of the embodiments of the present invention, and not all embodiments; all other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.

In the description of the present invention, it should be noted that the terms "first", "second", "third", and "fourth" are used for descriptive purposes only and are not to be construed as indicating or implying relative importance.

In the description of the present invention, it should be noted that, unless otherwise explicitly specified or limited, the terms "preset file", "test template", "link subfile", "scan start bit", "link step", "link medium", "hyperlink function", "jump link", "determination result", "linked test file", "execute function", "preset step", "subfile information", "identification information", "result subfile", "hyperlink", "document information", "chart value", "information fill field", "subfile creation module", "link module", "loop determination module", "report generation module" are to be interpreted broadly. The specific meanings of the above terms in the present invention can be understood in specific cases to those skilled in the art.

In the description of the present invention, it is to be noted that:

text is Text;

file Name is the document Name;

sheet Name is the chart Name;

py is an execution program;

picture Name is the Picture Name;

report is the name of a folder;

setting is the naming of a folder;

folder Name is the Folder identification Name;

xlsx is a Test file table;

test _ Waveform is a name of a folder.

Example 1

The present embodiment provides a method for linking multiple test messages, as shown in fig. 1 to 5, including the following steps:

in the embodiment, the firmware test report of the server includes many test items related to the server, and a test result generated by the test needs to be linked with the corresponding test item, and the prior art generally adopts a manual mode, so that the efficiency is extremely low and errors are easy to occur, and for the above problems, the linking method of multiple test information described in the embodiment solves the problems in a program mode:

it should be noted that, in this embodiment, the compiling of the specific program is compiled by python, which is only an implementation manner, and it can also be compiled by java, c language and c + + alone or in combination according to the specific idea of the method described in this embodiment.

In this embodiment, some existing manners of data or information are defined as follows: "fileset," "file," "list," "picture," and the like, are just one embodiment, and it is within the skill of the art to define data or information as other forms such as models, arrangements, sequences, codes, and the like.

S100, creating a first information link architecture, wherein the first information link architecture comprises: report file, Setting file (i.e. first preset file), Test template. xlsx (i.e. Test template); acquiring a Test result, creating a Test _ Waveform file based on the Test result, and placing the Test _ Waveform file into the first information link architecture to obtain a second information link architecture; creating a link subfile based on the second information link architecture;

it should be noted that the Report file is a file set for storing the link result after the execution of the method is completed; the Setting file is a file set for storing some preset items; xlsx is a Test template created according to a Test report, and the Test template is various and can be specifically set according to the Test report.

It should be noted that, because the Test results are usually many, the Test items in the Test results, and the Test data and the Test pictures corresponding to the Test items are identified, the Test data and the Test pictures are sorted according to the Test items, and are stored in the result sub-file, and the result sub-files are summarized to obtain a Test _ Waveform file; and placing the Test _ Waveform file into the first information link architecture established in the step S100 to obtain a second information link architecture, where the second information link architecture is an object that needs to be specifically operated.

Specifically, step S100 includes:

s110, executing a first presetting step: setting a first scanning start bit in a Setting file based on the Test template.xlsx, and then perfecting the Setting file based on the Test template.xlsx to obtain a second preset file;

it should be noted that the first scanning start bit includes rows and columns;

it should be noted that refining the Setting file based on the Test template. Setting a first file path of a Setting file; configuring a first execution function; acquiring a File Name (document information) and a Sheet Name (chart information) in Test template. And calling a first execution function to access the first File path, and modifying the Sheet value (namely the chart value) of the Setting File based on the File Name and the Sheet Name to finally obtain a second preset File.

It should be noted that the specific codes include:

import openpyxl; // configure the executive function;

import os; // configure the executive function;

setting r '\ Setting \ setting.xlsx'; setting a first file path of a Setting file;

load _ workflow (setting); v/Call function execution;

whs — opset. works [0 ]; // select sheet value;

FileName ═ ws [ 'a2' ], value; // modifying the sheet value based on File Name;

SheetName ═ ws [ 'B2' ]. value; modification of Sheet values based on Sheet Name;

s120, executing a second presetting step: perfecting the second preset file according to a result sub-file in the Test _ Waveform file to obtain a link sub-file;

it should be noted that the completing the second preset file includes: setting a second file path of the Test _ Waveform file; configuring a second execution function; calling a second function to access the second file path, and acquiring the Folder Name (namely, third subfile information) of a result subfile of the Test result in the Test _ Waveform file and the Picture Name (namely, third identification information) corresponding to the Folder Name; setting a first information filling field and a second information filling field of a second preset file; and respectively and sequentially placing the Folder Name and the Picture Name into the first information filling domain and the second information filling domain to obtain a link subfile.

It should be noted that the specific codes include:

folder _ path \ \ Test _ Waveform'; // set the second file path for the Test _ Waveform file;

folder _ content ═ os.listdir (folder _ path); v/call a second function to access the second file path;

foldernemerow ═ 2; setting a first information filling field of a second preset file;

FolderNameColumn ═ 4; setting a first information filling field of a second preset file;

for item in folder _ content; v/put Folder Name into the first information-filled field;

cell (foldernemerow, FolderNameColumn). V/put Folder Name into the first information-filled field;

foldernemerow ═ foldernemerow + 1; v/put in turn;

s130, establishing a link between the Report file and Test template.xlsx;

it should be noted that, a third file path of the Test Template. xlsx is acquired, the third file path is added to the execution path of the Report file, and a third execution function for the Test Template. xls is set in the data layer of the Report file, and at this time, the link establishment of the Report folder and the Test Template is completed.

In this embodiment, the connection between the Report file and the Test template. xlsx is performed, and the Report file may or may not exist, so this step is an unnecessary step and is not limited at all.

The specific code comprises:

report r '\ \' + ws [ 'a2' ], value + ', xlsx'// set Test Template path;

cell (foldernemerow, FolderNameColumn). Set the third execution function for Test template. xls;

foldernemerow ═ foldernemerow + 1; // select the sheet at Test template. xlsxsx;

s200, after the connection is established, a linking step is carried out on the link subfiles based on the first scanning start bit to obtain a first link medium; continuing to execute the linking step based on the first linking medium to obtain a first jump link;

specifically, step S200 includes:

s210, acquiring a first Folder Name (namely first subfile information) in the link subfile based on a first scanning start bit;

s220, acquiring a Picture Name (namely first identification information) corresponding to the first Folder Name; sorting the first Picture Name and the first Folder Name to obtain a Text file (namely a first link medium);

s230, configuring and calling a hyperlink function to establish a hyperlink (namely a first jump link) for a result sub-file corresponding to the first Folder Name in the Text file and the Test _ Waveform file.

It should be noted that the specific codes include:

max _ row + 1; // set the scanning Range

Cell (4,7) value; acquiring a first scanning start bit;

cell (4,8) value; acquiring a first scanning start bit;

s300, after the first jump link is obtained, modifying a first scanning start bit to obtain a second scanning start bit; executing a judging step based on the second scanning start bit to obtain a first judging result;

specifically, step S300 includes:

s310, acquiring a second Folder Name (namely second subfile information) corresponding to a second scanning start bit in the link subfiles;

s320, judging whether the second Folder Name is a null character (namely a character value); if the character is a null character (namely, matched), outputting a first judgment result of finishing the link (namely, a first result); if the character is not a null character (i.e. not matched), the judgment result of continuing the circular link (i.e. the second result) is output.

It should be noted that, in this step, the modified second scan start bit is usually the first scan start bit +2, and the modification of the first scan start bit can be specifically set according to the Test template.

S400, generating a corresponding linked test file based on the first judgment result;

specifically, step S400 includes:

s410, when the judgment result is that the link is finished, setting the first jump link as a linked test file;

s420, when the judgment result is that the cyclic link is continued, acquiring a second Picture Name corresponding to the second Folder Name in the link subfile, and executing the link step according to the second Picture Name and the second Folder Name to obtain a second jump link and a third scanning start bit; continuing to execute the judging step according to the third scanning start bit, and when the second Folder Name corresponding to the third scanning start bit is a null character, indicating that the circulation can be ended, and integrating the first jump link and the second jump link to obtain a chained test file; and when the second Folder Name corresponding to the third scanning start bit is a non-empty character, continuing to execute the linking step according to the third scanning start bit until the newly obtained scanning bit is an empty character.

It should be noted that the second Picture Name, the second Folder Name, and the third scanning start bit do not only represent the result after one cycle, and if the second Folder Name is not a null character, the second Picture Name, the second Folder Name, and the third scanning start bit are executed continuously according to the linking step to obtain a plurality of corresponding second jump links and third scanning start bits; and outputting a judgment result which is specifically the completion of the circular link at the moment when the link of the whole test result is completed and the circulation is not needed when the second Folder Name corresponding to the third scanning start bit is a null character.

It should be noted that, after the linked test file is obtained, the linked test file is placed into the Report file; the viewing of the file may be performed in the Report.

The specific codes of step S300 to step S400 include:

it should be noted that the linked test file is only one embodiment, and may be represented in various forms such as a test report, a test list, or a test chart.

It should be noted that the method described in this embodiment may be integrated into an auto.py program by means of a code, and the auto.py program is added to the second information linking architecture described in this embodiment to obtain a third information linking architecture; py is only an implementation of the execution program, and is not limited, and may be other names and other suffix types, such as: start.exe; in subsequent use, if the test template is changed, the matching of the corresponding template can be realized only by modifying the first link subfile in the Setting folder, and then the auto.

It should be noted that, in this embodiment, corresponding linking is performed only on Data types in the test report, similarly, corresponding linking may be performed on Clock Data types in the test report by the method, and the method may be compiled into a program and introduced into the test instrument, and when the test instrument performs a test, the program is run to achieve the same effect.

It should be noted that, for another Clock data type, the specific code portions are changed in steps S300 and S400, and the specific code includes:

by the multi-test information linking method described in this embodiment, a plurality of test results and test reports corresponding to the test results can be accurately linked, and corresponding operations can be realized only by modifying the cyclic items in the program, so that the method is very convenient and fast, the processing efficiency of the test reports is greatly improved, human resources and time resources are saved, the test cost is reduced, and the accuracy of the test reports is improved.

Example 2

The present embodiment provides a multi-test information linking system, as shown in fig. 6, including: the system comprises a subfile creating module, a linking module, a circulating judgment module and a report generating module;

in the multi-test information linking system, the subfile creating module is configured to create a first information linking architecture, where the first information linking architecture includes: report file, Setting file (i.e. first preset file), Test template. xlsx (i.e. Test template); the subfile creating module is further used for obtaining a Test result and creating a Test _ Waveform file based on the Test result, and the subfile creating module is used for placing the Test _ Waveform file into the first information link architecture to obtain a second information link architecture; the subfile creating module creates a link subfile based on the second information link architecture;

specifically, the subfile creating module executes a first preset step: the subfile creating module sets a first scanning start bit in the Setting file based on the Test template.xlsx, and then perfects the Setting file based on the Test template.xlsx to obtain a second preset file;

specifically, the subfile creating module executes a second preset step: the subfile creating module completes the second preset file according to a result subfile in the Test _ Waveform file to obtain a link subfile;

specifically, the subfile creating module is further configured to obtain a third file path of the Test template.xlsxx, add the third file path to the execution path of the Report file, and set a third execution function for the Test template.xls in the data layer of the Report file, where the establishment of the links between the Report folder and the Test Template is completed.

In the multi-test information linking system, a linking module is used for executing a linking step on a linking subfile based on a first scanning start bit after connection is established to obtain a first linking medium;

specifically, the link module acquires a first Folder Name (i.e., first subfile information) in the link subfile based on the first scanning start bit; the link module judges whether the first Folder Name is a non-empty character, and if so, the link module acquires a Picture Name (namely first identification information) corresponding to the first Folder Name; the link module arranges the first Picture Name and the first Folder Name to obtain a Text file (namely a first link medium);

specifically, the link module is used for continuing to execute the link step according to the first link medium to obtain a first jump link;

specifically, the link module configures and calls a hyperlink function to establish a hyperlink between a Text file and a result sub-file corresponding to the first Folder Name in a Test _ Waveform file, so as to obtain a first jump link.

In the multi-test information link system, the loop judgment module is used for modifying the first scanning start bit after the first jump link is obtained to obtain a second scanning start bit, and executing a judgment step according to the second scanning start bit to obtain a second jump link and a first judgment result;

specifically, the loop judgment module acquires a second Folder Name (i.e., second subfile information) corresponding to a second scanning start bit in the link subfiles; the circulation judging module judges whether the second Folder Name is a null character; if the character is a null character, the cyclic judgment module outputs a judgment result of the completion of the link; if the character is not empty, the cyclic judgment module continues to circularly link the judgment result.

In the multi-test information link system, a report generation module is used for generating a corresponding linked test file according to the judgment result;

specifically, when the judgment result is that the loop link is continued, the report generation module sets the first skip link as a linked test file; when the judgment result is that the cyclic link is completed, the report generation module acquires a second Picture Name corresponding to a second Folder Name in the link subfile, and executes the link step according to the second Picture Name and the second Folder Name to obtain a second skip link and a third scanning start bit; and when the second Folder Name corresponding to the third scanning start bit is a null character, the Report generation module arranges the first jump link and the second jump link to obtain a linked test file, and places the linked test file into a Report file.

Through the multi-test-information linking system described in the embodiment, a plurality of test results and test reports corresponding to the test results can be accurately and automatically linked through the cooperation of each module, so that the system is very convenient and fast, the processing efficiency of the test reports is greatly improved, the human resources and the time resources are saved, the test cost is reduced, and the accuracy of the test reports is improved.

Example 3

The present embodiments provide a computer-readable storage medium comprising:

the storage medium is used for storing computer software instructions for implementing the multi-test information linking method according to embodiment 1, and includes a program for executing the multi-test information linking method; specifically, the executable program may be built in the multi-test information linking system described in embodiment 2, so that the multi-test information linking system may implement the multi-test information linking method described in embodiment 1 by executing the built-in executable program.

Furthermore, the computer-readable storage medium of the present embodiments may take any combination of one or more readable storage media, where a readable storage medium includes an electronic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination thereof.

Different from the prior art, the method, the system and the medium for linking the multiple test information can automatically establish the link between the test report and the test result under the framework of the method, and can meet the link requirements of various template test reports by modifying a basic table under the framework.

The numbers of the embodiments disclosed in the embodiments of the present invention are merely for description, and do not represent the merits of the embodiments.

It will be understood by those skilled in the art that all or part of the steps of implementing the above embodiments may be implemented by hardware, and a program that can be implemented by the hardware and can be instructed by the program to be executed by the relevant hardware may be stored in a computer readable storage medium, where the storage medium may be a read-only memory, a magnetic or optical disk, and the like.

The above description is only an embodiment of the present invention, and not intended to limit the scope of the present invention, and all modifications of equivalent structures and equivalent processes performed by the present specification and drawings, or directly or indirectly applied to other related technical fields, are included in the scope of the present invention.

Claims

1. A method for linking multiple test messages is characterized by comprising the following steps:

2. The method for linking multiple test messages according to claim 1, wherein: the step of creating a link subfile based on the test result, the first preset file and the test template further comprises:

3. The method for linking multiple test messages according to claim 1 or 2, characterized in that: the linking step includes:

generating the first jump link based on the first link medium.

4. The method of linking multiple test messages according to claim 3, wherein: the step of generating the first jump link based on the first link medium further comprises:

5. The method of linking multiple test messages according to claim 4, wherein: the judging step comprises the following steps:

6. The method of linking multiple test messages according to claim 5, wherein: the step of generating a linked test file based on the first judgment result and the first jump link further comprises:

7. The method of linking multiple test messages according to claim 2, wherein: the first presetting step comprises:

acquiring document information and chart information of the test template;

8. The method of linking multiple test messages according to claim 2, wherein: the second presetting step comprises:

9. A system for linking multiple test messages, comprising: the system comprises a subfile creating module, a linking module, a circulating judgment module and a report generating module;

10. A computer-readable storage medium, characterized in that a computer program is stored on the computer-readable storage medium, which computer program, when being executed by a processor, carries out the steps of the method for linking multiple test messages according to any one of claims 1 to 8.