Database testing method and system

A testing method and testing system technology, applied in the field of database, to achieve the effect of automatic testing

Inactive Publication Date: 2018-04-06
PING AN TECH (SHENZHEN) CO LTD
View PDF8 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] In view of this, the object of the present invention is to provide a kind of database test method and system, to solve the problem of how to carry out the package test of Oracle database automatically

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 system
  • Database testing method and system
  • Database testing method and system

Examples

Experimental program
Comparison scheme
Effect test

no. 1 example

[0039] Such as figure 1 As shown, the first embodiment of the present invention proposes a database testing method, which includes the following steps:

[0040] S100, establishing a test framework for a stored procedure or function in a package of an Oracle database.

[0041] Specifically, an Oracle database application environment is built, and a corresponding test framework for stored procedures or functions in a package of the Oracle database is established for the system architecture of the specific application environment. The specific topology is as close as possible to the actual application.

[0042] S102, setting an automated test script, calling a stored procedure or function in a package of the background Oracle database to perform database testing.

[0043] Specifically, an automated test script is set, and the prepareCall method of ISQLServerConnection in Java is used to call the stored procedure or function in the package of the background Oracle database. The...

no. 2 example

[0048] Such as figure 2 As shown, the second embodiment of the present invention proposes a database testing method. In the second embodiment, the steps of the database testing method are similar to those in the first embodiment, the main difference is that step S204 is added on the basis of the first embodiment. The method specifically includes the following steps:

[0049] S200, establishing a test framework for a stored procedure or function in a package of the Oracle database.

[0050] Specifically, an Oracle database application environment is built, and a corresponding test framework for stored procedures or functions in a package of the Oracle database is established for the system architecture of the specific application environment. The specific topology is as close as possible to the actual application.

[0051] S202, setting an automated test script, calling a stored procedure or function in a package of the background Oracle database to perform database testing...

no. 3 example

[0060] Such as image 3 As shown, the third embodiment of the present invention proposes a database testing method. In the third embodiment, the steps of the database testing method are similar to those in the second embodiment, the main difference is that step S303 and step S308 are added on the basis of the second embodiment. The method specifically includes the following steps:

[0061] S300, establishing a test framework for a stored procedure or function in a package of the Oracle database.

[0062] Specifically, an Oracle database application environment is built, and a corresponding test framework for stored procedures or functions in a package of the Oracle database is established for the system architecture of the specific application environment. The specific topology is as close as possible to the actual application.

[0063] S302, setting an automated test script, calling a stored procedure or function in a package of the background Oracle database to perform da...

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 discloses a database testing method and system. The method comprises the steps of establishing a test structure of a stored procedure or function in a package of a database; setting an automated test script and calling the stored procedure or function in the package of the database to perform a database package test; running the automated test script to acquire test results. The automated testing of the database package can be achieved by means of the database testing method.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a database testing method and system. Background technique [0002] Most of the business logic of the traditional life insurance system is in the package of the background Oracle database, that is, stored procedures are used to process the complex business logic of the system. The front page (web) is only for displaying data or downloading reports. Some stored procedures in the package of the Oracle database in the background cannot be called on the front page or have no interface display after calling, and the results cannot be visually verified. Moreover, manually calling stored procedures or functions in the Oracle database will consume a lot of manpower and seriously affect the test progress. [0003] Therefore, an automated Oracle database package testing method is needed, and the test results can be seen quickly and intuitively. Contents of the invention [0004] In ...

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
CPCG06F11/3684G06F11/3688
Inventor 李国文
Owner PING AN TECH (SHENZHEN) CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap