Sql automatic execution method and system for database sql statement automatic generation tool

Abstract

The present invention provides a sql automatic execution method for a database sql statement automatic generation tool. The method comprises that: the sql query statement automatic generation tool isinterconnected with the database; table structure information of a to-be-queried table and function information of all supported built-in functions are obtained from the database; the database sql statement automatic generation tool reads the table structure information and the function information, and uses the random algorithm to generate sql query statements; the database sql statement automatic generation tool calls an interface function connected with the database to automatically execute the sql query statements, and outputs the generated log in the execution process to a log file in real time; and after executing the sql query statements, the execution results are automatically counted and output. The present invention also provides a system corresponding to the method. The advantages of the technical scheme of the present invention are that the sql query statement generated by the sql query statement automatic generation tool can be automatically run in the database, so that the link between the script and the execution can be eliminated, and the test time is saved.

Description

technical field [0001] The invention relates to the field of databases, in particular to a SQL automatic execution method and system of a database 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, different SQL syntax and usage methods, and higher and higher requirements for functions and performance. The sql query statement automatic generation tool is a tool that is often used when testing database functions and performance. However, the existing database sql statement automati...

AI Technical Summary

Problems solved by technology

The sql query statement automatic generation tool is a tool that is often used when testing database functions and performances. However, after the existing database sql statement automatic generation tools generate sql script files, the generated sql script files need to be manually executed by the tester. sql script file, and the log cannot be generated and output during execution. Therefore, not only the test efficiency is relatively low, but also it is inconvenient for testers to locate the bug location

Images