Method and system for preparing interface testing data

A technology of interface testing and data, applied in the field of testing, can solve the problems of high error rate, long time-consuming, cumbersome interface test data methods, etc., and achieve the effect of low error rate, short time-consuming, and ensure accuracy

Active Publication Date: 2013-06-19
ALIBABA GRP HLDG LTD
View PDF2 Cites 14 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0007] This application provides a method and system for preparing interface test data to solve the problems of cumbersome methods, long time consumption and high error rate in the storage of interface test data

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
  • Method and system for preparing interface testing data
  • Method and system for preparing interface testing data
  • Method and system for preparing interface testing data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] In order to make the above objects, features and advantages of the present application more obvious and comprehensible, the present application will be further described in detail below in conjunction with the accompanying drawings and specific implementation methods.

[0028] Itest is an interface testing framework. It uses junit as the basic framework of the entire test, uses dbunit as a tool for automatically managing the database, and encapsulates dbunit's test data-related content to complete data generation and verification. Itest uses excel as the data carrier to load data through POI, and finally uses the annotation mechanism of unitils to make the entire data and the input and output process of excel transparent. It supports the use of data in excel files to perform logical operations such as insertion, comparison, and deletion on the database.

[0029] Among them, POI is a Java open source toolkit, which is dedicated to parsing and generating file types relate...

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 provides a method and a system for preparing interface testing data. The method comprises the steps that when a test case is executed for the first time, a structured query language (SQL) statement in the test case is monitored and intercepted; the operation type of the SQL statement is analyzed, and the SQL statement is analyzed according to the operation type; when the SQL statement is analyzed to be a querying statement, relative data are searched through execution of the query statement and relative configuration information between data and data is automatically stored into an excel table; then the test case is executed again, and the data in the excel table is restored into a data base automatically; if the SQL statement is analyzed to be a deleting statement, the deleting statement is stored into a corresponding property profile; then the test case is executed again, and the property profile is called automatically to execute deleting operation. Automatic interception of the SQL statement can be realized, the relevant data are automatically stored and configured, time consumption is little, efficiency is high, and error rate is low.

Description

technical field [0001] The present application relates to the technical field of testing, in particular to a method and system for preparing interface test data. Background technique [0002] Interface testing is a test for testing the interfaces between system components, and is mainly used to detect the interaction points between external systems and internal subsystems. [0003] In interface testing, when executing test cases, you can use SQL statements to perform operations such as query and update on data in the database. At this time, you need to call the data required for testing from the database, and then perform corresponding operations. Since the system is often upgraded and maintained, it is necessary to continuously execute the same test case to test whether there is a problem with the system. After the test case is executed, the data will be changed due to operations such as updates, but each time the test case is executed, it needs to be retrieved from the dat...

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/267G06F17/30
Inventor 葛媛金争争盛雁童建芬李松源
Owner ALIBABA GRP HLDG 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