SQL test script generation method

Abstract

The invention provides an SQL (Structured Query Language) test script generation method which comprises the following steps: S1, constructing a test script case writing language for a writer to writea use case conveniently; S2, analyzing the written use case by utilizing an editor, and translating the written use case into a required target language case code; and S3, if the target language generated in the S2 is a compiled language, compiling the use case code of the target language generated in the S2 to obtain a test program, executing the test program for testing, and if the target language generated in the S2 is an interpreted language, directly executing the use case code generated in the S2. According to the SQL test script generation method, a use case writer can express contentsexpressed by dozens of or even hundreds of lines of codes in a general programming language by using several lines of statements, and meanwhile, multiple target languages are written at one time for execution, so that the efficiency is greatly improved.

Description

technical field [0001] The invention belongs to the field of databases, in particular to a method for generating SQL test scripts. Background technique [0002] SQL testing is one of the core tests of database systems. There are many traditional SQL testing methods, but most of them choose a general-purpose programming language and use standard database connection interfaces such as JDBC and ODBC to access the database. Usually with this method, a test case may have to write dozens to hundreds of lines of code depending on the complexity of the use case. It is difficult to avoid cross-calling between codes. Most of the code has nothing to do with the test intent. There are more and more use cases. The test code will become more and more complex, more and more difficult to maintain, difficult to transfer, difficult to add new use cases, and it is almost impossible to quickly migrate use cases to another language. At the same time, with the development of technology, a variet...

AI Technical Summary

Problems solved by technology

Usually with this method, a test case may have to write dozens to hundreds of lines of code depending on the complexity of the use case. It is difficult to avoid cross-calling between codes. Most of the code has nothing to do with the test intent. There are more and more use cases. The test code will become more and more complex, more and more difficult to maintain, difficult to handover, difficult to add new use cases, and almost impossible to quickly migrate use cases to another language

At the same time, with the development of technology, a variety of programming languages ​​have flourished. Many languages ​​need to use databases. For database manufacturers, they need to provide connection support for multiple languages, and they need to pass tests to verify that they pass each language. Connectors can work normally when executing SQL, which requires a set of test codes for each language, and the cost of use case development, maintenance costs and efficiency are not high

Images