Method, apparatus, computer device and storage medium for automatically generating insert statement

Abstract

The invention discloses a method, a device, a computer device and a storage medium for automatically generating an insert statement. The target requirement document is parsed based on the document type identification, and the target configuration table identification and configuration parameters of the target requirement document are obtained. The method comprises querying a basic code block configuration table based on a target configuration table identifier; obtaining a basic code block corresponding to the basic configuration table identifier if there is a basic configuration table identifier matching with the target configuration table identifier in the basic code block configuration table; based on the underlying code block and configuration parameters, the corresponding insert statement being generated. The technical proposal of the invention achieves the effect of improving the efficiency of generating insert statements by adopting the method of automatically generating insert statements based on the configuration parameters and the basic code blocks, thereby effectively improving the reusability of the basic code blocks.

Description

technical field [0001] The invention relates to the field of computer software, in particular to a method, device, computer equipment and storage medium for automatically generating insert sentences. Background technique [0002] The insert statement is an insert statement of Structured Query Language (SQL, Structured Query Language), and is used to insert new data into a table. In the computer field, many system developments will be based on relational databases, so SQL technology is basically used to operate databases. If a new row needs to be inserted into the database, an insert statement needs to be written to insert the configuration parameters into the corresponding configuration table of the database. [0003] In the reinsurance system of the insurance industry, when adding new products into the system, it is necessary to add multiple configuration tables for each new product, which requires writing multiple insert statements. When the amount of data is large, it i...

AI Technical Summary

Problems solved by technology

When the amount of data is large, it is necessary to repeatedly write the insert statement, which will increase the workload, and the efficiency of writing the insert statement is relatively low

Images