System and method for constructing complex sql statement by utilizing python grammatical semantics

Abstract

The invention discloses a system for constructing a complex sql statement by utilizing python syntax semantics, and belongs to the technical field of script programming and structured query language.The system comprises a decomposition unit, an assignment unit and a series unit. The decomposition unit is used for decomposing the complex sql query statement to obtain clauses in various forms; theassignment unit is used for assigning the clauses in various forms obtained by decomposition to a python variable; and the serial connection unit is used for serially connecting and combining the clauses in various forms obtained by decomposition together according to the assigned python variable to generate a complex sql statement. According to the system for constructing the complex sql statement by utilizing the python syntax semantics, the flexibility of logic processing of a programming language is utilized, the original complex logic is split and processed, the complex problem is simplified, and compared with the prior art, the readability of a program is improved, the later expandability is also improved, and the maintenance cost is reduced.

Description

technical field [0001] The invention relates to the technical fields of script programming and structured query language, and more specifically relates to a system and method for constructing complex SQL statements by using python syntax and semantics. Background technique [0002] At present, the parsing for sql usually focuses on the splicing of sql statements directly. This method will lead to the complexity and redundancy of sql statements when dealing with complex relational queries, which is not conducive to later maintenance. Contents of the invention [0003] The purpose of the present invention is to provide a system and method for constructing complex sql statements using python syntax and semantics, in order to solve the technical problems in the background technology, mainly aimed at complex queries of relational databases under the many-to-many model The problem of difficult identification and maintenance of query statements is dealt with. The defect of the pr...

AI Technical Summary

Problems solved by technology

[0003] The purpose of the present invention is to provide a system and method for constructing complex sql statements using python syntax and semantics, in order to solve the technical problems in the background technology, mainly aimed at complex queries of relational databases under the many-to-many model The problem of difficult identification and maintenance of query statements is dealt with. The defect of the problem is mainly due to the limitation of the language of the structured query language itself. Increased maintenance costs

Images