Disclosure of Invention
The technical scheme of the invention is as follows: a test document information maintenance method based on multi-system cooperation comprises the following steps:
S1, according to an original material provided by a consignor, performing preliminary arrangement according to project information to form an excel document of 'measured piece information';
s2, automatically reading an excel document of the tested piece information by using a back-end information reading module, extracting information of a project name and a project source in the excel document, storing the information into a database for table X, and simultaneously storing a testing original material into a back-end information management storage module;
S3, based on the main key item name of the table X, linking the table X to the table Y in the database according to the existing data in the database;
S4, the project tested piece information pushed by the front-end display module is downloaded and received from a database, and testing is started;
s5, extracting information from a test result document comprising a test description, a test record, a test problem list and a test report generated in the test process by using a back-end information reading module to store the information in a table Z, and simultaneously storing the test result document in a back-end information management storage module;
s6, based on a main key item code of the table Z, linking the table Z to the table Y in the database according to the existing data in the database;
S7, simultaneously displaying all document information of the inside and the outside of a certain item through a data link X-Y-Z of a database by taking the item code number or the item name as a search key in a front-end display module.
Further, in the step S1, the measured piece information excel document is used to facilitate synchronization of offline and online management, and online information is transmitted to the tester as an information stream, offline information is used as data archive, so that information backtracking is facilitated.
Further, in the step S2, the "back-end information reading module" is used to automatically read the specific information in the excel document and automatically generate a new record in the database table X of the corresponding item.
Further, in the step S3, the item name is a unique identifier linking the external material and the internal information management.
Further, in the step S4, all the external materials received for the item may be searched and downloaded by inputting "item name" or "item code" as a search key.
Further, in the step S5, the documents generated during the test have the same unique identifier, i.e., the item code, which is an identifier generated for internal management of the item, and is unique.
Further, in the step S6, the item code is a unique identifier of a certain item generated to facilitate internal information management.
Further, in the step S7, the background record XYZ forms a data link by "item name" and "item code". The item can be searched by inputting the item name or the item code, so that the measured item condition of the item and the progress condition of the item can be known.
According to the test document information maintenance method based on the multi-collaboration system, the information is extracted from the external document, the information is extracted from the internal document, the internal information and the external information are related, the internal information barriers and the external information barriers are opened, and the quick, convenient and safe test document information maintenance method is provided for management staff and test staff.
Detailed Description
The method for maintaining the test document information based on the multi-system cooperation is further described in detail below with reference to the accompanying drawings and the specific embodiments. Advantages and features of the invention will become more apparent from the following description and from the claims.
As shown in fig. 1 and 2, the present invention provides a test document information maintenance method, comprising:
S1, according to an original material provided by a consignor, performing preliminary arrangement according to project information to form an excel document of 'measured piece information';
s2, automatically reading an excel document of the tested piece information by using a back-end information reading module, extracting information of a project name and a project source in the excel document, storing the information into a database for table X, and simultaneously storing a testing original material into a back-end information management storage module;
S3, based on the main key item name of the table X, linking the table X to the table Y in the database according to the existing data in the database;
S4, the project tested piece information pushed by the front-end display module is downloaded and received from a database, and testing is started;
s5, extracting information from a test result document comprising a test description, a test record, a test problem list and a test report generated in the test process by using a back-end information reading module to store the information in a table Z, and simultaneously storing the test result document in a back-end information management storage module;
s6, based on a main key item code of the table Z, linking the table Z to the table Y in the database according to the existing data in the database;
S7, simultaneously displaying all document information of the inside and the outside of a certain item through a data link X-Y-Z of a database by taking the item code number or the item name as a search key in a front-end display module.
In the embodiment of the test document information maintenance method, in the step S1, the original material contains the document and the software code, and an excel document meeting the program input requirement is formed according to the document information and the code information.
In the embodiment of the test document information maintenance method, in the step S1, each line of record in the excel document corresponds to a document or code, and the information in each line of record includes a project name, a project type, a medium type and a project source, if the record corresponds to the document, the information of the page number of the document is also included, and if the record corresponds to the code, the information of the line number of the code is also included.
In the embodiment of the method for maintaining test document information, in the step S2, the original material including the test code and the original document is uploaded to a "back-end information management storage module" for searching and downloading according to the internal code of the project.
In the embodiment of the test document information maintenance method of the present invention, in the step S3, the table Y is a data table established when a project stands, and has two joint primary keys of "project name" and "project code" in the table Y.
In the test document information maintenance method of the present invention, in the embodiment, in the step S3, the unique identifiers of the association tables X and Y are "item names".
In the test document information maintenance method of the present invention, in the step S5, the basic information of the document of the test description, the test record and the test question sheet is "project code".
In the test document information maintenance method according to the embodiment of the present invention, in the step S6, the unique identifier of the association table Y and the unique identifier of the table Z are "item code numbers".
In the embodiment of the method for maintaining test document information, in the step S7, the foreground display module receives the variation information of the project material in real time, and performs real-time tracking on the management of the project information stream.
In the embodiment of the test document information maintenance method, in the step S7, the progress situation of the project is tracked in real time through the foreground management module, so that project node delay caused by information lag of a certain link is avoided.
Specifically, the test document information maintenance method based on multi-system cooperation provided by the invention comprises the following specific steps:
(1) Preliminary information arrangement is carried out according to project original materials provided by a consignor, basic information is imported into a database for table X through programming, and related documents are stored at the same time;
(2) The database automatically associates the table X with the table Y according to the corresponding primary key relation;
(3) After receiving relevant test original materials for testing, storing all documents formed in the whole testing process into a database, and establishing a new record in the database in a table Z;
(4) The database automatically associates the table Y with the table Z according to the corresponding primary key relation until the table X-Y-Z forms a complete database link;
As shown in FIG. 2, according to one embodiment of the present application, a method for maintaining test document information based on multi-system collaboration is provided. The method comprises the following steps S1 to S3:
S1, receiving an external tested file, carrying out preliminary arrangement on the external file according to the item to which the external file belongs, and generating a corresponding record in a database after information extraction;
S2, downloading and receiving project documents and project codes in the database through the display module, and starting testing work. After the test is completed, uploading the generated test process documents such as test description, test records, test problem sheets and the like to a database for archiving, and generating records of a database table;
S3, judging the completion condition of the project according to the document condition uploaded by the tester so as to determine whether the progress condition of the project meets the condition of performing review;
S4, the information flow of the whole testing process is smooth from outside to inside, and the smooth proceeding of the whole testing process is ensured through the system.
It will be apparent to those skilled in the art that various modifications and variations can be made to the present invention without departing from the spirit or scope of the invention. Thus, it is intended that the present invention also include such modifications and alterations insofar as they come within the scope of the appended claims or the equivalents thereof.