CN116431627A - Electronic equipment database table generation method, system, equipment and medium - Google Patents
Electronic equipment database table generation method, system, equipment and medium Download PDFInfo
- Publication number
- CN116431627A CN116431627A CN202211556381.2A CN202211556381A CN116431627A CN 116431627 A CN116431627 A CN 116431627A CN 202211556381 A CN202211556381 A CN 202211556381A CN 116431627 A CN116431627 A CN 116431627A
- Authority
- CN
- China
- Prior art keywords
- test
- database table
- file
- database
- table generation
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 28
- 238000012360 testing method Methods 0.000 claims abstract description 193
- 238000004590 computer program Methods 0.000 claims description 15
- 238000013500 data storage Methods 0.000 claims description 6
- 238000004458 analytical method Methods 0.000 claims description 5
- 238000013523 data management Methods 0.000 abstract description 7
- 238000010586 diagram Methods 0.000 description 9
- 230000006870 function Effects 0.000 description 4
- 238000012986 modification Methods 0.000 description 4
- 230000004048 modification Effects 0.000 description 4
- 238000012545 processing Methods 0.000 description 4
- 238000004519 manufacturing process Methods 0.000 description 3
- 230000000694 effects Effects 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 1
- 238000012552 review Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/36—Preventing errors by testing or debugging software
- G06F11/3668—Software testing
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Computer Hardware Design (AREA)
- Quality & Reliability (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a method, a system, equipment and a medium for generating a database table of electronic equipment in the technical field of computers, wherein the method comprises the following steps: step S10, acquiring a JSON format test file of the electronic equipment, and storing the test file into a preset path; s20, reading a test file from the preset path, analyzing the test file to obtain test data, and automatically generating a database table generation file based on the test data; step S30, the database table generation file opens a database based on the trigger signal, and then automatically generates a database table in the database; and S40, directly storing the test data of the electronic equipment into the database table. The invention has the advantages that: the database table is automatically generated, and convenience in test data management of the electronic equipment is greatly improved.
Description
Technical Field
The present invention relates to the field of computer technologies, and in particular, to a method, a system, an apparatus, and a medium for generating a database table of an electronic device.
Background
The electronic device needs to be subjected to a series of tests before leaving the factory, and the tests generate corresponding test data, so that the test data need to be archived in order to facilitate the traceability of the electronic device when the electronic device fails. For archiving of test data, a paper file is conventionally used for recording, but with the progress of technology, the method has been changed to uploading test data to a database of a server for archiving due to inconvenient storage and review.
However, there are differences in test items of different models and styles of electronic devices, and there are differences in test data generated by the test, so that workers need to continuously modify and reconstruct the form style of the database, and a great deal of time and effort are required.
Therefore, how to provide a method, a system, a device and a medium for generating a database table of an electronic device, so as to automatically generate the database table, thereby improving the convenience of test data management of the electronic device, and becoming a technical problem to be solved urgently.
Disclosure of Invention
The invention aims to solve the technical problem of providing a method, a system, equipment and a medium for generating a database table of electronic equipment, which realize automatic generation of the database table so as to improve the convenience of test data management of the electronic equipment.
In a first aspect, the present invention provides a method for generating a database table of an electronic device, including the following steps:
step S10, acquiring a JSON format test file of the electronic equipment, and storing the test file into a preset path;
s20, reading a test file from the preset path, analyzing the test file to obtain test data, and automatically generating a database table generation file based on the test data;
step S30, the database table generation file opens a database based on the trigger signal, and then automatically generates a database table in the database;
and S40, directly storing the test data of the electronic equipment into the database table.
Further, the step S20 specifically includes:
based on a trigger signal of an initialization key on a display interface, reading a test file from the preset path in real time, analyzing each node of the test file to obtain test data at least comprising a work order number, equipment data, a test result, test time, a test failure item, a test item standard value and a test item actual value, automatically generating a database table generation file based on the test data, and prompting that the initialization is successful on the display interface.
Further, the step S30 specifically includes:
and automatically opening a database by the database table generation file based on the trigger signal of the double click, and automatically generating a database table by the database based on the database table generation file.
Further, the step S40 specifically includes:
after the test equipment performs the test operation on the electronic equipment, the generated test data are stored in the database table in real time.
In a second aspect, the present invention provides an electronic device database table generating system, including the following modules:
the test file acquisition module is used for acquiring a JSON format test file of the electronic equipment and storing the test file into a preset path;
the test file analysis module is used for reading a test file from the preset path, analyzing the test file to obtain test data, and automatically generating a database table generation file based on the test data;
the database table generation module is used for opening a database based on a trigger signal by the database table generation file, and further automatically generating a database table in the database;
and the test data storage module is used for directly storing the test data of the electronic equipment into the database table.
Further, the test file parsing module is specifically configured to:
based on a trigger signal of an initialization key on a display interface, reading a test file from the preset path in real time, analyzing each node of the test file to obtain test data at least comprising a work order number, equipment data, a test result, test time, a test failure item, a test item standard value and a test item actual value, automatically generating a database table generation file based on the test data, and prompting that the initialization is successful on the display interface.
Further, the database table generation module is specifically configured to:
and automatically opening a database by the database table generation file based on the trigger signal of the double click, and automatically generating a database table by the database based on the database table generation file.
Further, the test data storage module is specifically configured to:
after the test equipment performs the test operation on the electronic equipment, the generated test data are stored in the database table in real time.
In a third aspect, the present invention provides an electronic device database table generating device, comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing the method of the first aspect when executing the program.
In a fourth aspect, the present invention provides an electronic device database table generating medium having stored thereon a computer program which when executed by a processor implements the method of the first aspect.
One or more technical solutions provided in the embodiments of the present invention at least have the following technical effects or advantages:
by reading the JSON format test file of the electronic equipment, analyzing the test file to obtain test data at least comprising a work order number, equipment data, a test result, test time, a test failure item, a test item standard value and a test item actual value, automatically generating a database table generation file based on the test data, automatically generating a database table based on the database table generation file, directly storing the test data of the electronic equipment into the database table, namely automatically generating the database table according to the test file of the electronic equipment with a specific model and style, without continuously modifying and reconstructing the database table, thereby avoiding delay production due to the creation error of the database table, and finally greatly improving the convenience of electronic equipment test data management.
The foregoing description is only an overview of the present invention, and is intended to be implemented in accordance with the teachings of the present invention in order that the same may be more clearly understood and to make the same and other objects, features and advantages of the present invention more readily apparent.
Drawings
The invention will be further described with reference to examples of embodiments with reference to the accompanying drawings.
Fig. 1 is a flowchart of a method for generating a database table of an electronic device according to the present invention.
Fig. 2 is a schematic structural diagram of an electronic device database table generating system according to the present invention.
Fig. 3 is a schematic structural diagram of an electronic device database table generating device according to the present invention.
Fig. 4 is a schematic structural diagram of an electronic device database table generating medium according to the present invention.
Detailed Description
According to the method, the system, the equipment and the medium for generating the database table of the electronic equipment, the database table is automatically generated, and therefore convenience in test data management of the electronic equipment is improved.
According to the technical scheme in the embodiment of the application, the overall thought is as follows: and analyzing the test file to obtain test data by reading the test file in the JSON format, automatically generating a database table generating file based on the test data, and automatically generating a database table based on the database table generating file, namely automatically generating the database table according to the test file of the electronic equipment with a specific model and style, so that the convenience of electronic equipment test data management is improved.
Example 1
The embodiment provides a method for generating a database table of electronic equipment, as shown in fig. 1, including the following steps:
step S10, acquiring a JSON format test file of the electronic equipment, and storing the test file into a preset path; in specific implementation, the test file can be selected by browsing a file interface;
s20, reading a test file from the preset path, analyzing the test file to obtain test data, and automatically generating a database table generation file based on the test data;
step S30, the database table generation file opens a database based on the trigger signal, and then automatically generates a database table in the database; namely, the database table is automatically generated based on the test file in the JSON format, and the modification and reconstruction are not needed manually, so that the workload of database table creation is reduced, and the error of manual operation can be avoided;
and S40, directly storing the test data of the electronic equipment into the database table, and avoiding error reporting caused by structural errors of the database table.
The step S20 specifically includes:
based on a trigger signal of an initialization key on a display interface, reading a test file from the preset path in real time, analyzing each node of the test file to obtain test data at least comprising a work order number, equipment data, a test result, test time, a test failure item, a test item standard value and a test item actual value, automatically generating a database table generation file based on the test data, and prompting that the initialization is successful on the display interface. In particular implementations, the database table generation file may be stored to a designated folder.
And the work order number, the equipment data, the test result, the test time, the test failure project, the test project standard value and the test project actual value are used as column names of a database table.
The step S30 specifically includes:
and automatically opening a database by the database table generation file based on the trigger signal of the double click, and automatically generating a database table by the database based on the database table generation file. In particular implementations, the database table may be automatically generated based on a trigger signal to execute a key.
The step S40 specifically includes:
after the test equipment performs the test operation on the electronic equipment, the generated test data are stored in the database table in real time.
Example two
The embodiment provides an electronic device database table generating system, as shown in fig. 2, including the following modules:
the test file acquisition module is used for acquiring a JSON format test file of the electronic equipment and storing the test file into a preset path; in specific implementation, the test file can be selected by browsing a file interface;
the test file analysis module is used for reading a test file from the preset path, analyzing the test file to obtain test data, and automatically generating a database table generation file based on the test data;
the database table generation module is used for opening a database based on a trigger signal by the database table generation file, and further automatically generating a database table in the database; namely, the database table is automatically generated based on the test file in the JSON format, and the modification and reconstruction are not needed manually, so that the workload of database table creation is reduced, and the error of manual operation can be avoided;
and the test data storage module is used for directly storing the test data of the electronic equipment into the database table, so that error reporting caused by structural errors of the database table is avoided.
The test file analysis module is specifically configured to:
based on a trigger signal of an initialization key on a display interface, reading a test file from the preset path in real time, analyzing each node of the test file to obtain test data at least comprising a work order number, equipment data, a test result, test time, a test failure item, a test item standard value and a test item actual value, automatically generating a database table generation file based on the test data, and prompting that the initialization is successful on the display interface. In particular implementations, the database table generation file may be stored to a designated folder.
And the work order number, the equipment data, the test result, the test time, the test failure project, the test project standard value and the test project actual value are used as column names of a database table.
The database table generation module is specifically configured to:
and automatically opening a database by the database table generation file based on the trigger signal of the double click, and automatically generating a database table by the database based on the database table generation file. In particular implementations, the database table may be automatically generated based on a trigger signal to execute a key.
The test data storage module is specifically configured to:
after the test equipment performs the test operation on the electronic equipment, the generated test data are stored in the database table in real time.
Based on the same inventive concept, the application provides an electronic device embodiment corresponding to the first embodiment, and the details of the third embodiment are described in detail.
Example III
The present embodiment provides an electronic device database table generating device, as shown in fig. 3, including a memory, a processor, and a computer program stored in the memory and capable of running on the processor, where the processor executes the computer program to implement any one of the implementation manners of the first embodiment.
Since the electronic device described in this embodiment is a device for implementing the method described in the first embodiment of the present application, those skilled in the art will be able to understand the specific implementation of the electronic device and various modifications thereof based on the method described in the first embodiment of the present application, so how the method described in the embodiment of the present application is implemented in this electronic device will not be described in detail herein. The apparatus used to implement the methods of the embodiments of the present application are within the scope of what is intended to be protected by the present application.
Based on the same inventive concept, the application provides a storage medium corresponding to the first embodiment, and the details of the fourth embodiment are described in detail.
Example IV
The present embodiment provides an electronic device database table generating medium, as shown in fig. 4, on which a computer program is stored, where when the computer program is executed by a processor, any implementation manner of the first embodiment may be implemented.
The technical scheme provided in the embodiment of the application has at least the following technical effects or advantages:
by reading the JSON format test file of the electronic equipment, analyzing the test file to obtain test data at least comprising a work order number, equipment data, a test result, test time, a test failure item, a test item standard value and a test item actual value, automatically generating a database table generation file based on the test data, automatically generating a database table based on the database table generation file, directly storing the test data of the electronic equipment into the database table, namely automatically generating the database table according to the test file of the electronic equipment with a specific model and style, without continuously modifying and reconstructing the database table, thereby avoiding delay production due to the creation error of the database table, and finally greatly improving the convenience of electronic equipment test data management.
It will be appreciated by those skilled in the art that embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
While specific embodiments of the invention have been described above, it will be appreciated by those skilled in the art that the specific embodiments described are illustrative only and not intended to limit the scope of the invention, and that equivalent modifications and variations of the invention in light of the spirit of the invention will be covered by the claims of the present invention.
Claims (10)
1. A method for generating a database table of electronic equipment is characterized by comprising the following steps: the method comprises the following steps:
step S10, acquiring a JSON format test file of the electronic equipment, and storing the test file into a preset path;
s20, reading a test file from the preset path, analyzing the test file to obtain test data, and automatically generating a database table generation file based on the test data;
step S30, the database table generation file opens a database based on the trigger signal, and then automatically generates a database table in the database;
and S40, directly storing the test data of the electronic equipment into the database table.
2. The method for generating a database table of an electronic device according to claim 1, wherein: the step S20 specifically includes:
based on a trigger signal of an initialization key on a display interface, reading a test file from the preset path in real time, analyzing each node of the test file to obtain test data at least comprising a work order number, equipment data, a test result, test time, a test failure item, a test item standard value and a test item actual value, automatically generating a database table generation file based on the test data, and prompting that the initialization is successful on the display interface.
3. The method for generating a database table of an electronic device according to claim 1, wherein: the step S30 specifically includes:
and automatically opening a database by the database table generation file based on the trigger signal of the double click, and automatically generating a database table by the database based on the database table generation file.
4. The method for generating a database table of an electronic device according to claim 1, wherein: the step S40 specifically includes:
after the test equipment performs the test operation on the electronic equipment, the generated test data are stored in the database table in real time.
5. An electronic device database table generation system, characterized in that: the device comprises the following modules:
the test file acquisition module is used for acquiring a JSON format test file of the electronic equipment and storing the test file into a preset path;
the test file analysis module is used for reading a test file from the preset path, analyzing the test file to obtain test data, and automatically generating a database table generation file based on the test data;
the database table generation module is used for opening a database based on a trigger signal by the database table generation file, and further automatically generating a database table in the database;
and the test data storage module is used for directly storing the test data of the electronic equipment into the database table.
6. The electronic device database table generation system of claim 5, wherein: the test file analysis module is specifically configured to:
based on a trigger signal of an initialization key on a display interface, reading a test file from the preset path in real time, analyzing each node of the test file to obtain test data at least comprising a work order number, equipment data, a test result, test time, a test failure item, a test item standard value and a test item actual value, automatically generating a database table generation file based on the test data, and prompting that the initialization is successful on the display interface.
7. The electronic device database table generation system of claim 5, wherein: the database table generation module is specifically configured to:
and automatically opening a database by the database table generation file based on the trigger signal of the double click, and automatically generating a database table by the database based on the database table generation file.
8. The electronic device database table generation system of claim 5, wherein: the test data storage module is specifically configured to:
after the test equipment performs the test operation on the electronic equipment, the generated test data are stored in the database table in real time.
9. An electronic device database table generating device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the method of any one of claims 1 to 4 when executing the program.
10. An electronic device database table generating medium having stored thereon a computer program, which when executed by a processor implements a method according to any of claims 1 to 4.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202211556381.2A CN116431627A (en) | 2022-12-06 | 2022-12-06 | Electronic equipment database table generation method, system, equipment and medium |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202211556381.2A CN116431627A (en) | 2022-12-06 | 2022-12-06 | Electronic equipment database table generation method, system, equipment and medium |
Publications (1)
Publication Number | Publication Date |
---|---|
CN116431627A true CN116431627A (en) | 2023-07-14 |
Family
ID=87080290
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202211556381.2A Pending CN116431627A (en) | 2022-12-06 | 2022-12-06 | Electronic equipment database table generation method, system, equipment and medium |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN116431627A (en) |
-
2022
- 2022-12-06 CN CN202211556381.2A patent/CN116431627A/en active Pending
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN110309071B (en) | Test code generation method and module, and test method and system | |
US9064056B2 (en) | Completing functional testing | |
CN102184138B (en) | Method and system for automatically reproducing and positioning software error | |
US20170228220A1 (en) | Self-healing automated script-testing tool | |
US20170277624A1 (en) | Method and system for automated user interface (ui) testing through model driven techniques | |
US9239773B1 (en) | Method and system for debugging a program that includes declarative code and procedural code | |
CN110737594B (en) | Database standard conformance testing method and device for automatically generating test cases | |
CN109815119B (en) | APP link channel testing method and device | |
CN104317618A (en) | Firmware partitioning method and device | |
CN107818029A (en) | A kind of cloud hard disc data recovers the automated testing method of uniformity | |
CN115658529A (en) | Automatic testing method for user page and related equipment | |
CN112433948A (en) | Simulation test system and method based on network data analysis | |
CN112882941A (en) | Integrated test system and method based on micro-service architecture | |
CN108241543B (en) | Method, service server and system for executing service operation breakpoint | |
CN108073511B (en) | Test code generation method and device | |
US11106571B2 (en) | Identification of input object in a graphical user interface | |
CN116431627A (en) | Electronic equipment database table generation method, system, equipment and medium | |
CN107092671B (en) | Method and equipment for managing meta information | |
CN115757174A (en) | Database difference detection method and device | |
CN111858315B (en) | Software debugging method, device, equipment and medium based on version management | |
CN113946509A (en) | Buried point searching and comparing method and device, computing device and readable storage medium | |
CN110968342B (en) | Version comparison method, device and system | |
CN113868140A (en) | Automatic testing method and storage medium | |
CN112712421A (en) | Method, equipment and storage medium for automatically downloading running bill | |
CN111522737B (en) | Automatic test verification method and device for front-end interface and storage medium |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination |