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

Database testing method and device, equipment and storage medium

A test method and database technology, applied in the computer field, can solve problems such as database correctness and compatibility methods that cannot meet requirements, and achieve the effects of reducing complexity, ensuring accuracy, and reducing workload

Inactive Publication Date: 2019-05-07
SHANGHAI DAMENG DATABASE
View PDF4 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The method for detecting the correctness and compatibility of the database in the prior art cannot meet the requirements

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
  • Database testing method and device, equipment and storage medium
  • Database testing method and device, equipment and storage medium
  • Database testing method and device, equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0040] figure 1 It is a flow chart of the database testing method in Embodiment 1 of the present invention. This embodiment is applicable to the situation of implementing database testing. The method can be executed by a database testing device, and the device can use software and / or hardware. To achieve, the device can be configured in a device, for example, the device can be a smart phone, a tablet, or a computer. Such as figure 1 As shown, the method may specifically include:

[0041] S110. Obtain a test case corresponding to the current function to be tested in the target database, where the test case includes a test statement, configuration information and expected parameters.

[0042] Wherein, the target database may be any type of database, for example, the target database may be a homogeneous database or a heterogeneous database. The function to be tested is any one of the various functions included in the database. In this embodiment, the specific function to be te...

Embodiment 2

[0054] figure 2 It is a flowchart of the testing method of the database in the second embodiment of the present invention. In this embodiment, on the basis of the foregoing embodiments, the method for testing the foregoing database is further specified. Correspondingly, such as figure 2 As shown, the method of this embodiment specifically includes:

[0055] S201. Obtain a test case corresponding to the current function to be tested in the target database.

[0056] Wherein, the target database may be any type of database, for example, the target database may be a homogeneous database or a heterogeneous database. The function to be tested is any one of various functions included in the database, and the specific function to be tested is not limited in this embodiment. The test case includes pre-stored test sentences, configuration information and expected parameters, and the test case includes pre-stored test sentences, configuration information and expected parameters.

...

Embodiment 3

[0098] Figure 4 It is a schematic structural diagram of the database testing device in the third embodiment of the present invention, and this embodiment is applicable to the situation of realizing the database testing. The database testing device provided in the embodiment of the present invention can execute the database testing method provided in any embodiment of the present invention, and has corresponding functional modules and beneficial effects for executing the method. The device specifically includes a test case module 310, a test execution module 320 and a test result module 330, wherein:

[0099] The test case module 310 is used to obtain the test case corresponding to the current function to be tested in the target database, and the test case includes test statements, configuration information and expected parameters;

[0100] The test execution module 320 is used to execute the test statement to obtain the test parameters if it is determined that the test case ...

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 embodiment of the invention discloses a database test method and device, equipment and a storage medium, and the method comprises the steps: obtaining a test case corresponding to a current to-be-tested function in a target database, the test case comprising a test statement, configuration information and an expected parameter; If it is determined that the test case meets the test requirementsof the target database based on the configuration information, executing the test statement to obtain test parameters; And comparing the test parameter with the expected parameter to obtain a test result of the current to-be-tested function. According to the embodiment of the invention, the function of judging the compatibility and accuracy of the database can be realized by comparing the test parameters obtained during the test with the expected parameters in the preset test case, so that the workload caused by the replacement or upgrading of the database is reduced, the complexity is reduced, and the accuracy is ensured.

Description

technical field [0001] The embodiment of the present invention relates to the field of computer technology, and in particular to a database testing method, device, equipment and storage medium. Background technique [0002] Databases and software are widely used in the computer industry. Most software needs to use databases to store data, so the requirements for correctness and compatibility of databases are very high, otherwise it will lead to unpredictable occurrences of upper-level software using databases. mistake. [0003] For software developers, database compatibility is a concern. If the software is upgraded or the database is replaced, it is necessary to ensure a certain degree of compatibility between the two databases, otherwise the database cannot be migrated seamlessly, which requires modification and adaptation of the software, which increases a certain amount of work. Therefore, database compatibility testing is very important for software developers, and ca...

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
IPC IPC(8): G06F11/36
Inventor 郑靖博杨超
Owner SHANGHAI DAMENG DATABASE
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