Database sql query statement automatic generation apparatus

• Main Authors: LIN YINFENG, WU YOUYING, FANG CHAO, CAI SHIPING
• Format: Patent
• Language: Chinese; English
• Published: 10.08.2018
• Subjects: CALCULATING; COMPUTING; COUNTING; ELECTRIC DIGITAL DATA PROCESSING; PHYSICS

The invention provides a database sql query statement automatic generation apparatus. The apparatus comprises a table and function processing module used for obtaining table structure information of tables to be queried and function information of all supported built-in functions from a database, performing type matching on the table structure information and the function information and storing the table structure information and the function information same in type, a query total generation module used for randomly selecting column sum functions from the stored table structure information and function information by utilizing a random algorithm to generate required query statements and nesting and splicing the required query statements into a complete sql query statement, and an executable text generation module used for outputting the complete sql query statement, generating an executable script file and executing the generated executable script file in the database. Through the apparatus, automatic gener