SQL script generation method, device and computer device

A script generation and script technology, applied in the computer field, can solve the problems of consuming a lot of time for programmers to write scripts and low efficiency of SQL script writing, and achieve the effect of saving writing time, improving writing efficiency and simple operation.

Pending Publication Date: 2019-03-26
深圳平安医疗健康科技服务有限公司
View PDF0 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In view of this, the embodiment of the present invention provides a SQL script generation method, device and computer equipment to solve the prob

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
  • SQL script generation method, device and computer device
  • SQL script generation method, device and computer device
  • SQL script generation method, device and computer device

Examples

Experimental program
Comparison scheme
Effect test

Example Embodiment

[0056] Example 1

[0057] The embodiment of the present invention provides a method for generating an SQL script.

[0058] For details, please refer to figure 1 , which is a schematic flowchart of the method provided in the embodiment of the present invention, such as figure 1 As shown, the method includes the following steps:

[0059] 102. Acquire a preset spreadsheet, wherein the attribute information of the preset spreadsheet includes script parameters and a mapping relationship between the formula of the preset spreadsheet and the SQL script template.

[0060] In the present invention, the preset spreadsheet includes a header and a table data area, wherein the header of the preset spreadsheet includes the names of various script parameters corresponding to the SQL script; the table data area is the values ​​of various script parameters, In the preset spreadsheet, its table data area may be empty, that is, there is no assignment; or, the cells in the table data area may ...

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 embodiment of the invention provides a SQL script generation method, device and a computer device, which relate to the computer technical field. The embodiment of the invention obtains the presetspreadsheet, wherein, the attribute information of the preset spreadsheet comprises script parameters and the mapping relationship between the formula of the preset spreadsheet and the SQL script template; Thus, the first operation information of the user for the preset spreadsheet attribute information is obtained, and a target spreadsheet is generated based on the first operation information; Further, according to the target spreadsheet, a corresponding target SQL script is generated. Therefore, the technical proposal provided by the embodiment of the invention can solve the problem that SQLscript writing in the prior art needs a lot of time for programmers to write scripts, and the SQL script writing efficiency is low.

Description

【Technical field】 [0001] The invention relates to the technical field of computers, in particular to a SQL script generation method, device and computer equipment. 【Background technique】 [0002] SQL (Structured Query Language, Structured Query Language), is a special-purpose programming language, a database query and programming language, used to access data and query, update and manage relational database systems. An SQL script is a program written using SQL statements, which can implement certain logic control over a database. [0003] In the process of software development, it is usually necessary to write a large number of SQL scripts. Existing SQL script writing main programmer's book adopts manual way to write. Before writing in this way, a large number of database tables need to be created first, and then the programmer manually writes SQL scripts based on the created database. When the number of scripts to be written in this scripting method is relatively large, ...

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/245
Inventor 朱明奇
Owner 深圳平安医疗健康科技服务有限公司
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

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap