CN116431627A - Electronic equipment database table generation method, system, equipment and medium - Google Patents

Electronic equipment database table generation method, system, equipment and medium Download PDF

Info

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
Application number
CN202211556381.2A
Other languages
Chinese (zh)
Inventor
詹达峰
袁苇
张宏辉
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Fujian Newland Communication Science Technologies Co ltd
Original Assignee
Fujian Newland Communication Science Technologies Co ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Fujian Newland Communication Science Technologies Co ltd filed Critical Fujian Newland Communication Science Technologies Co ltd
Priority to CN202211556381.2A priority Critical patent/CN116431627A/en
Publication of CN116431627A publication Critical patent/CN116431627A/en
Pending legal-status Critical Current

Links

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

Electronic equipment database table generation method, system, equipment and medium
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.
CN202211556381.2A 2022-12-06 2022-12-06 Electronic equipment database table generation method, system, equipment and medium Pending CN116431627A (en)

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)

Similar Documents

Publication Publication Date Title
US10055338B2 (en) Completing functional testing
CN110309071B (en) Test code generation method and module, and test method and system
CN102184138B (en) Method and system for automatically reproducing and positioning software error
US10146672B2 (en) Method and system for automated user interface (UI) testing through model driven techniques
CN109448100B (en) Three-dimensional model format conversion method, system, computer device and storage medium
US8832125B2 (en) Extensible event-driven log analysis framework
US9239773B1 (en) Method and system for debugging a program that includes declarative code and procedural code
CN109815119B (en) APP link channel testing method and device
CN110737594B (en) Database standard conformance testing method and device for automatically generating test cases
CN104317618A (en) Firmware partitioning method and device
CN115658529A (en) Automatic testing method for user page and related equipment
CN107818029A (en) A kind of cloud hard disc data recovers the automated testing method of uniformity
CN112433948A (en) Simulation test system and method based on network data analysis
US20170344461A1 (en) Automated exception resolution during a software development session based on previous exception encounters
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
CN115757174A (en) Database difference detection method and device
CN111522737B (en) Automatic test verification method and device for front-end interface and storage medium
GB2537341A (en) The sequenced common action and flow representation automation model (SCAFRA)
JP2016042317A (en) Software design support device, and method
CN104252409A (en) Method and system for obtaining WebApp executing process
CN109669868A (en) The method and system of software test
CN116016158B (en) Hybrid cloud aPaaS platform deployment method, device, equipment and computer storage medium
CN110968342B (en) Version comparison method, device and system

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