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

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...

AI Technical Summary

Problems solved by technology

[0004] The present invention provides a script automatic generation method, device and computer-readable storage medium, the main purpose of which is to solve the problem of slow script writing efficiency and no guarantee of correctness

Images