Method and system for offline reading of database functions of sql statement automatic generation tool

Abstract

The invention provides an off-line reading method of a database function of a sql statement automatic generation tool, which includes obtaining the table structure information of the table to be queried and the function information of all supported built-in functions from the database, and saving the table structure information as the first text file, save the function information as a second text file; modify the format of the first text file and the second text file; read the first text file and the second text file, and save them according to the specified format; The data types of the text file and the second text file are matched, and a random algorithm is used to automatically generate a sql query statement, and output the sql query statement to generate an executable file. The advantages of the present invention: it can realize the generation of sql query statements using the sql query statement automatic generation tool under the situation of being separated from the database; at the same time, it unifies the input and output of the sql query statement automatic generation tool, is applicable to most databases, and has high compatibility powerful.

Description

technical field [0001] The invention relates to the field of databases, in particular to a database function off-line reading method and system of a SQL statement automatic generation tool. Background technique [0002] Database (Database) is a warehouse that organizes, stores and manages data according to the data structure. It was produced more than 60 years ago. With the development of information technology and the market, especially after the 1990s, data management It is no longer just storing and managing data, but has transformed into various data management methods required by users. [0003] In recent years, with the development of big data, there are more and more types of databases, the syntax and usage of SQL are also different, and the requirements for functions and performance are getting higher and higher. The tool for automatically generating sql query statements is a tool that is often used when testing database functions and performance. However, the exist...

AI Technical Summary

Problems solved by technology

The tool for automatically generating sql query statements is a tool that is often used when testing database functions and performance. However, the existing tools for automatically generating sql query statements for databases need to interact with the database. If the database driver is not installed, the sql query statement automatic generation tool cannot be used; and for different database types, the existing technology needs to use different sql query statement automatic generation tools for processing, so the compatibility is poor, and the unification of tools cannot be realized In addition, for the function update of some non-open source databases, the existing sql query statement automatic generation tools cannot update the extended function synchronously, because this will cause the omission of test cases

Images