Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

SQL statement test method and system, storage medium and computer equipment

A test method and test system technology, applied in storage media and computer equipment, SQL statement test method, system field, can solve problems such as single SQL statement, single test scene, etc., to achieve comprehensive, maximize test effect and high efficiency And the effect of automatic construction

Pending Publication Date: 2021-11-16
HANGZHOU ANHENG INFORMATION TECH CO LTD
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The embodiment of the present application provides a test method, system, storage medium and computer equipment for SQL statements, which solves the disadvantages of single test scenarios and single executed SQL statements in the current execution of SQL statement tests

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • SQL statement test method and system, storage medium and computer equipment
  • SQL statement test method and system, storage medium and computer equipment
  • SQL statement test method and system, storage medium and computer equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0061] In order to make the purpose, technical solutions and advantages of the present application clearer, the present application will be described and illustrated below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present application, and are not intended to limit the present application. Based on the embodiments provided in the present application, all other embodiments obtained by persons of ordinary skill in the art without creative efforts shall fall within the protection scope of the present application.

[0062] Obviously, the accompanying drawings in the following description are only some examples or embodiments of the present application, and those skilled in the art can also apply the present application to other similar scenarios. In addition, it can also be understood that although such development efforts may be complex and lengthy, for those of ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention relates to an SQL statement test method and system, a storage medium and computer device. The SQL statement test method comprises the steps: creating a component pool of a simulation application system; organizing a first set of component combinations in the simulation application system; reading a component combination configured in the first set, and selecting the component combination to be combined with the components configured in the component pool so as to construct the simulation application system; constructing a SQL statement system adaptive to the simulation application system; mapping each component combination of the simulation application system with an SQL statement configured by the SQL statement system to obtain a mapping table; and executing the mapping table to automatically pull up the Web service, and simulating the Web application to execute the SQL statement. According to the method, the defects that the test scene is single and the executed SQL statement is single in the current SQL statement execution test are overcome, the comprehensiveness of the environment case and the operation case is realized, the maximization of the scene and SQL statement test effect is achieved, and the Web component system can be quickly, efficiently, automatically and completely established.

Description

technical field [0001] The present application relates to the technical field of wed testing system, in particular to a testing method, system, storage medium and computer equipment of an SQL statement. Background technique [0002] Current database traffic products, including database auditing and database firewalls, all need to audit or block the executed SQL statements. Before the product is released to the customer's site for use, it is necessary to perform a self-test on these database traffic products, usually by executing SQL statements for testing. Structured Query Language (Structured Query Language) referred to as SQL, Structured Query Language is a database query and programming language, used to access data and query, update and manage relational database systems; SQL statement is a kind of database operation language. [0003] At present, the test method of database traffic products is often to directly connect to the application system manually, and execute S...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F11/36
CPCG06F11/3684G06F11/3688
Inventor 吴雅琴范渊刘博
Owner HANGZHOU ANHENG INFORMATION TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products