CN114253854B - Automatic test method based on simulation report data of multi-type equipment - Google Patents

Automatic test method based on simulation report data of multi-type equipment Download PDF

Info

Publication number
CN114253854B
CN114253854B CN202111573768.4A CN202111573768A CN114253854B CN 114253854 B CN114253854 B CN 114253854B CN 202111573768 A CN202111573768 A CN 202111573768A CN 114253854 B CN114253854 B CN 114253854B
Authority
CN
China
Prior art keywords
data
equipment
script
acquisition
reporting
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.)
Active
Application number
CN202111573768.4A
Other languages
Chinese (zh)
Other versions
CN114253854A (en
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.)
Sichuan Cric Technology Co ltd
Original Assignee
Sichuan Cric Technology 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 Sichuan Cric Technology Co ltd filed Critical Sichuan Cric Technology Co ltd
Priority to CN202111573768.4A priority Critical patent/CN114253854B/en
Publication of CN114253854A publication Critical patent/CN114253854A/en
Application granted granted Critical
Publication of CN114253854B publication Critical patent/CN114253854B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/36Preventing errors by testing or debugging software
    • G06F11/3668Software testing
    • G06F11/3672Test management
    • G06F11/3688Test management for test execution, e.g. scheduling of test suites
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/06Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
    • G06Q10/063Operations research, analysis or management
    • G06Q10/0639Performance analysis of employees; Performance analysis of enterprise or organisation operations
    • G06Q10/06395Quality analysis or management
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/10Office automation; Time management
    • G06Q10/103Workflow collaboration or project management

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Human Resources & Organizations (AREA)
  • Strategic Management (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Theoretical Computer Science (AREA)
  • Quality & Reliability (AREA)
  • Physics & Mathematics (AREA)
  • Economics (AREA)
  • General Physics & Mathematics (AREA)
  • Tourism & Hospitality (AREA)
  • Marketing (AREA)
  • Operations Research (AREA)
  • General Business, Economics & Management (AREA)
  • Development Economics (AREA)
  • Educational Administration (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • Computer Hardware Design (AREA)
  • Game Theory and Decision Science (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
  • Debugging And Monitoring (AREA)

Abstract

The invention discloses an automatic test method based on multi-type equipment simulation report data, which is characterized in that a production intelligent system is built, and basic data information of equipment is configured in an equipment management system; storing the configuration into a data table; acquiring basic data information of equipment from an equipment management system, acquiring required report data, acquiring a report interface from the equipment acquisition system, acquiring script test data according to the report data, and writing a script; when executing the script, calling a corresponding reporting interface according to the acquisition mode of the equipment, executing reporting data to a server, and storing the reporting data in a data table; and testing the production manufacturing system, the equipment management system and the quality analysis data management by using the reported data. In the invention, under the condition that the production equipment or the network is not ready to be in place and the equipment cannot report data, the real equipment is simulated to report the data, so that the interface of the equipment acquisition system is tested in advance and test data is provided for other system modules.

Description

Automatic test method based on simulation report data of multi-type equipment
Technical Field
The invention relates to the technical field of automatic testing, in particular to an automatic testing method based on simulation report data of multiple types of equipment.
Background
With the development of industrial Internet industry, enterprise big data acquisition is a necessary path for entering industry 4.0. More and more factories begin to build intelligent production systems, and data acquisition of production equipment is the key first step, because the acquired data is data support of modules such as quality analysis data management, equipment OEE management, real-time yield statistics and the like. For system testing, the data collected by the production equipment is a test data source of system modules such as a Manufacturing Execution System (MES), a bulletin board center, a report center and the like. In the actual test process, software development is completed, but due to the reasons that factory equipment is not purchased in place, network transformation is not completed, production tasks are heavy, equipment cannot be coordinated and the like, system joint debugging test is not performed on real equipment, so that module test suspension or delay of equipment acquisition systems, equipment OEE management, real-time yield statistics and the like is caused, and project delivery schedule is affected.
Disclosure of Invention
The invention aims to provide an automatic test method based on multi-type equipment simulation report data, which is used for solving the problem that in the test process of an intelligent production system in the prior art, under the conditions that software is developed, hardware equipment and a network are not in place and real equipment report data cannot be coordinated, a plurality of modules of the whole system cannot be tested, so that projects cannot be delivered in schedule.
The invention solves the problems by the following technical proposal:
An automated test method based on multi-type equipment simulation report data, comprising the following steps:
step S1, a production intelligent system is built, wherein the production intelligent system comprises a server, a device management system communicated with the server, a data acquisition system, a production manufacturing system and quality analysis data management;
Step S2, configuring basic data information of equipment in an equipment management system, wherein the basic data information comprises equipment data and acquisition data; the equipment data comprises an equipment ID, an IP address, an equipment brand, an equipment type and an acquisition mode, and the acquisition data comprises an acquisition address, a data name, a data type, a service type corresponding to the data name, a fault detail code and a fault detail code acquisition address; storing the configuration into a data table of a database;
Step S3, acquiring basic data information of the equipment from the equipment management system, acquiring required reporting data, acquiring a reporting interface from the equipment acquisition system, acquiring script test data according to the service type and the data type of the reporting data, and writing a reporting data automation script;
S4, calling a corresponding reporting interface according to the acquisition mode of the equipment when executing the reporting data automation script, executing the reporting data to the server, and storing the reporting data in a data table defined by the equipment data acquisition system;
and S5, testing the production manufacturing system, the equipment management system and the quality analysis data management by using the reported data.
The report data automation script sets timing execution according to the service requirement.
The acquisition mode for acquiring script test data comprises the following steps:
A. Randomly generating by using script codes according to preset rules;
B. writing corresponding data in a CSV file of script reading equipment;
C. The script is written and retrieved from the database.
Compared with the prior art, the invention has the following advantages:
in the invention, under the condition that the production equipment or the network is not ready to be in place and the equipment cannot report data, the real equipment is simulated to report the data, so that the interface of the equipment acquisition system is tested in advance, and test data is provided for other system modules, so that project test is carried out according to a plan, and the project quality is ensured; when the production equipment and the network are all ready to be in place, the real machine joint debugging can be carried out in less time, the project period is shortened, the project delivery in time is ensured, and the production of a factory is not influenced.
Drawings
FIG. 1 is a system block diagram of the present invention;
FIG. 2 is a flow chart of the present invention;
FIG. 3 shows three script data acquisition modes according to the present invention.
Detailed Description
The present invention will be described in further detail with reference to examples, but embodiments of the present invention are not limited thereto.
Examples:
Referring to fig. 1 and 2, an automated test method based on multi-type device simulation report data includes:
step S1, a production intelligent system is built, wherein the production intelligent system comprises a server, a device management system communicated with the server, a data acquisition system, a production manufacturing system and quality analysis data management;
Step S2, configuring basic data information of equipment in an equipment management system, wherein the basic data information comprises equipment data and acquisition data; the equipment data comprises an equipment ID, an IP address, an equipment brand, an equipment type and an acquisition mode, and the acquisition data comprises an acquisition address, a data name, a data type, a service type corresponding to the data name, a fault detail code and a fault detail code acquisition address; storing the configuration into a data table of a database;
Step S3, acquiring basic data information of the equipment from the equipment management system, acquiring required reporting data, acquiring a reporting interface from the equipment acquisition system, acquiring script test data according to the service type and the data type of the reporting data, and writing a reporting data automation script;
S4, calling a corresponding reporting interface according to the acquisition mode of the equipment when executing the reporting data automation script, executing the reporting data to the server, and storing the reporting data in a data table defined by the equipment data acquisition system;
and S5, testing the production manufacturing system, the equipment management system and the quality analysis data management by using the reported data.
The functions of each system in the intelligent production system are as follows:
Device management system: maintaining a device foundation and collecting data, and providing a data source for an automation script; after simulating and reporting data such as equipment faults, states and the like to a server, testing can be carried out on equipment fault modules, equipment states and equipment OEE statistics;
production manufacturing system (MES): after simulating and reporting the equipment production data to a server, providing test data for modules such as real-time production data, yield analysis and the like;
and (3) quality analysis data management: after simulating and reporting the equipment quality data to a server, providing test data for modules such as a quality report form, SPC analysis and the like;
And the equipment acquisition system comprises: the system interface is tested in the process of executing the script, and a more complex script can be designed to test the fault tolerance and the robustness of the equipment acquisition system interface.
The automation script mainly involves two core tasks: (1) Executing the script to obtain various device reporting data, wherein the reporting data is required to be consistent with the real device reporting data, so that the data simulation real machine is convenient; (2) Executing script drives the equipment acquisition system interface to run, and reporting the equipment data to the server in the process of reporting the interface running by the equipment acquisition system.
The process of executing the script is that the simulation device reports data to the server, the script is successfully executed, and the data reported by the simulation device can be stored in a data table defined by a device data acquisition system, and is generally in a MySQL or MongoDB database. If the script does not have the BUG, the script execution fails, which indicates that the interface of the equipment data acquisition system has the BUG, and related research personnel are required to joint debugging and modify the BUG.
When executing the script, the script can be executed in a multithreading way, and whether the performance of the reported data interface is stable or not is tested.
The script can be executed at fixed time according to the service requirement, so that the test time is saved more effectively.
In the invention, under the condition that the production equipment or the network is not ready to be in place and the equipment cannot report data, the real equipment is simulated to report the data, so that the interface of the equipment acquisition system is tested in advance, and test data is provided for other system modules, so that project test is carried out according to a plan, and the project quality is ensured; when the production equipment and the network are all ready to be in place, the real machine joint debugging can be carried out in less time, the project period is shortened, the project delivery in time is ensured, and the production of a factory is not influenced.
Referring to fig. 3, the method for acquiring script test data includes:
A. Randomly generating by using script codes according to preset rules;
B. writing corresponding data in a CSV file of script reading equipment;
C. The script is written and retrieved from the database.
The types of data services reported by the devices are different, request parameters are different, and some request parameters require large amounts of data, so that the acquisition of script execution data is also an important step for writing a script. The scheme divides the data acquisition modes into three main categories:
1. according to a preset rule, randomly generating by using script codes: some devices have uncomplicated reporting data forms and small variation, such as upper limit and lower limit of quality data (weight, height, temperature and the like), and scripts can be written to randomly take values between the upper limit and the lower limit; for example, the time data (acquisition time and running time) are acquired according to the current time, and can be acquired by writing a script.
2. Writing a script to read the CSV file: some devices report large data amount and need to keep files for storage, at this time, the data can be stored in a CSV file, and then the corresponding data in the CSV is read through a script as a reporting parameter. There are two cases of data generation in a CSV file: (1) The data volume is not large, or specific data is needed, but the data has no specific rule, the code is not well realized, and the code can be directly input manually; (2) The data volume is large, the data changes at any time, the data generation rule can be defined first, and then the CSV file is written in through the script.
3. Writing a script database and obtaining: the basic data or the collected data of the equipment can be stored in a data table corresponding to the database after the equipment is configured successfully, and the data can be obtained by directly writing a script from the database, so that the obtained data is quick and accurate.
Aiming at different data service types reported by different devices, the acquisition modes of request parameter data are different, so that before a script is written, the acquisition modes of each parameter are defined, and the design of the script is convenient.
Although the application has been described herein with reference to the above-described illustrative embodiments thereof, the foregoing embodiments are merely preferred embodiments of the present application, and it should be understood that the embodiments of the present application are not limited to the above-described embodiments, and that numerous other modifications and embodiments can be devised by those skilled in the art that will fall within the scope and spirit of the principles of this disclosure.

Claims (2)

1. An automated testing method based on multi-type equipment simulation report data is characterized by comprising the following steps:
step S1, a production intelligent system is built, wherein the production intelligent system comprises a server, a device management system communicated with the server, a data acquisition system, a production manufacturing system and quality analysis data management;
Step S2, configuring basic data information of equipment in an equipment management system, wherein the basic data information comprises equipment data and acquisition data; the equipment data comprises an equipment ID, an IP address, an equipment brand, an equipment type and an acquisition mode, and the acquisition data comprises an acquisition address, a data name, a data type, a service type corresponding to the data name, a fault detail code and a fault detail code acquisition address; storing the configuration into a data table of a database;
Step S3, acquiring basic data information of the equipment from the equipment management system, acquiring required reporting data, acquiring a reporting interface from the equipment acquisition system, acquiring script test data according to the service type and the data type of the reporting data, and writing a reporting data automation script;
S4, calling a corresponding reporting interface according to the acquisition mode of the equipment when executing the reporting data automation script, executing the reporting data to the server, and storing the reporting data in a data table defined by the equipment data acquisition system;
S5, testing a production manufacturing system, an equipment management system and quality analysis data management by using the reported data;
The acquisition mode for acquiring script test data comprises the following steps:
A. Randomly generating by using script codes according to preset rules;
B. writing corresponding data in a CSV file of script reading equipment;
C. The script is written and retrieved from the database.
2. The automated testing method based on multi-type device simulation report data according to claim 1, wherein the report data automated script sets timing execution according to service requirements.
CN202111573768.4A 2021-12-21 2021-12-21 Automatic test method based on simulation report data of multi-type equipment Active CN114253854B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202111573768.4A CN114253854B (en) 2021-12-21 2021-12-21 Automatic test method based on simulation report data of multi-type equipment

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202111573768.4A CN114253854B (en) 2021-12-21 2021-12-21 Automatic test method based on simulation report data of multi-type equipment

Publications (2)

Publication Number Publication Date
CN114253854A CN114253854A (en) 2022-03-29
CN114253854B true CN114253854B (en) 2024-05-14

Family

ID=80793813

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202111573768.4A Active CN114253854B (en) 2021-12-21 2021-12-21 Automatic test method based on simulation report data of multi-type equipment

Country Status (1)

Country Link
CN (1) CN114253854B (en)

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101098259A (en) * 2006-06-30 2008-01-02 中兴通讯股份有限公司 Automatized test method and system for implementing large data impact
JP2009288954A (en) * 2008-05-28 2009-12-10 Mitsubishi Electric Corp Actual machine simulation data simulator device
CN103634154A (en) * 2013-12-17 2014-03-12 北京邮电大学 Simulation system and simulation method for network state
CN111382080A (en) * 2020-03-16 2020-07-07 深圳市吉祥腾达科技有限公司 Stability test method for equipment cloud management platform system
CN112035357A (en) * 2020-08-31 2020-12-04 平安医疗健康管理股份有限公司 Intelligent test method, device, equipment and storage medium
CN113419946A (en) * 2021-05-31 2021-09-21 西南电子技术研究所(中国电子科技集团公司第十研究所) Ice interface test case and test script automatic generation method

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113641460A (en) * 2017-09-30 2021-11-12 甲骨文国际公司 API repository implementing microservice configuration and management

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101098259A (en) * 2006-06-30 2008-01-02 中兴通讯股份有限公司 Automatized test method and system for implementing large data impact
JP2009288954A (en) * 2008-05-28 2009-12-10 Mitsubishi Electric Corp Actual machine simulation data simulator device
CN103634154A (en) * 2013-12-17 2014-03-12 北京邮电大学 Simulation system and simulation method for network state
CN111382080A (en) * 2020-03-16 2020-07-07 深圳市吉祥腾达科技有限公司 Stability test method for equipment cloud management platform system
CN112035357A (en) * 2020-08-31 2020-12-04 平安医疗健康管理股份有限公司 Intelligent test method, device, equipment and storage medium
CN113419946A (en) * 2021-05-31 2021-09-21 西南电子技术研究所(中国电子科技集团公司第十研究所) Ice interface test case and test script automatic generation method

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
Data- and model-driven digital twins for design and logistics control of product distribution;Mihai Stan等;《 2021 23rd International Conference on Control Systems and Computer Science (CSCS)》;20210626;1-8 *
工业数据采集网关的研制及其在能源管理***中的应用;邹稳;《中国优秀硕士学位论文全文数据库 工程科技Ⅱ辑》;20210115;C039-78 *

Also Published As

Publication number Publication date
CN114253854A (en) 2022-03-29

Similar Documents

Publication Publication Date Title
WO2016090929A1 (en) Method, server and system for software system fault diagnosis
CN105389256A (en) Unit testing method and system
CN112052172B (en) Rapid test method and device for third-party channel and electronic equipment
CN109947641A (en) Automated testing method and device
CN103678093A (en) Automatic testing framework and testing method
CN107678942A (en) A kind of API automated testing methods
CN112115058A (en) Test method and device, test case generation method and device and test system
CN107193730A (en) A kind of interface test method of automation
CA2939510A1 (en) Systems and methods for component failure-mode surveillance
CN110990289B (en) Method and device for automatically submitting bug, electronic equipment and storage medium
CN114253854B (en) Automatic test method based on simulation report data of multi-type equipment
CN114036034A (en) Performance test method applied to real-time streaming computation
CN105117347A (en) Test data simulation method and system and automation test method and system
CN111767218B (en) Automatic test method, equipment and storage medium for continuous integration
WO2009016090A1 (en) A method and relative device for the management of technological recipe information to aid in defining process flows, in particular for the development and production of micro- and nanotechnology devices in cleanroom laboratories
CN116527553A (en) Processing method, system and storage medium for automatic test report of switch
CN116228263A (en) Production detection integrated automatic debugging method, system and storage medium applied to fusion terminal
CN113495831B (en) Method, system, equipment and medium for generating test case based on keywords
CN110188034A (en) A kind of method for testing software based on information sharing
CN112650815B (en) Method and device for synchronizing environment data, storage medium and electronic device
CN107729046A (en) A kind of software version automation dissemination method and device
CN109976269B (en) Method for monitoring manufacturing execution process information of rolling and packing workshop
CN113656210A (en) Processing method and device for error reporting information, server and readable storage medium
Wen-Hong et al. The software quality evaluation method based on software testing
CN111931017A (en) Intelligent configuration method and system suitable for coal preparation plant

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
GR01 Patent grant
GR01 Patent grant