Sql automatic execution method and system for database sql statement automatic generation tool
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 i...
Gespeichert in:
Hauptverfasser: | , , , |
---|---|
Format: | Patent |
Sprache: | chi ; eng |
Schlagworte: | |
Online-Zugang: | Volltext bestellen |
Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
Zusammenfassung: | 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 schem |
---|