Automatic script generation method and device, electronic equipment and storage medium

A technology of automatic generation and scripting, which is applied in the field of data processing, can solve problems such as no guarantee of correctness and slow script writing efficiency, and achieve the effects of slow solution efficiency, no guarantee of correctness and increased accuracy

Pending Publication Date: 2021-06-01
ONE CONNECT SMART TECH CO LTD SHENZHEN
View PDF4 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The present invention provides a script automatic generation method, device and computer-readable storage mediu

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Automatic script generation method and device, electronic equipment and storage medium
  • Automatic script generation method and device, electronic equipment and storage medium
  • Automatic script generation method and device, electronic equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0050] It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0051] An embodiment of the present application provides a method for automatically generating scripts. The execution subject of the automatic script generation method includes but is not limited to at least one of electronic devices such as a server and a terminal that can be configured to execute the method provided by the embodiment of the present application. In other words, the script automatic generation method can be executed by software or hardware installed on the terminal device or server device, and the software can be a block chain platform. The server includes, but is not limited to: a single server, a server cluster, a cloud server or a cloud server cluster, and the like.

[0052] refer to figure 1 As shown, it is a schematic flowchart of a method for automatically generating scripts provided by an emb...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention relates to a data processing technology, and discloses an automatic script generation method. The method comprises the following steps: performing file type identification on a to-be-processed file, and performing file content extraction on the to-be-processed file according to the file type to obtain a file content set; performing field type reading on the file content set to obtain a field type; performing data length verification on the data content in the file content set; when the length verification is passed, performing matching verification on the data content according to the field type, and storing the data content passing the matching verification into a data text; loading the data text into a preset sql template, obtaining an initial sql script, extracting a storage identifier of the initial sql script for script information processing, and obtaining a standard sql script. The invention further relates to a blockchain technology, and the field type can be stored in a node of a blockchain. The invention further provides an automatic script generation device, electronic equipment and a storage medium. The problems that the script writing efficiency is low and the correctness is not guaranteed can be solved.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a script automatic generation method, device, electronic equipment and computer-readable storage medium. Background technique [0002] In work, it is often encountered that a batch of data needs to be manually inserted into the database. At this time, the data in the file needs to be converted into sql scripts, and then the correctness of the sql scripts is verified in the test database, and finally Execute said sql script in the database. [0003] There are two basic ways to write scripts. The first is to write directly when the amount of data is small, which is not only slow in efficiency but also has no guarantee of correctness; the other is to write a small function when the amount of data is relatively large. Read the file, convert the data in the file into a sql script, and then verify the correctness of the sql script. This method is not very scalable and compatib...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F16/16G06F16/182
CPCG06F16/164G06F16/182
Inventor 颜赛云
Owner ONE CONNECT SMART TECH CO LTD SHENZHEN
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products