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

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: 2015-07-01
ALIBABA GRP HLDG LTD
View PDF2 Cites 0 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 objectives, features and advantages of the application more obvious and understandable, the application will be further described in detail below in conjunction with the drawings and specific implementations.

[0028] Itest is an interface testing framework. It uses junit as the basic framework for the entire test, uses dbunit as a tool to automatically manage the database, and encapsulates the content related to dbunit's test data to complete data generation and verification. Itest uses excel as the data carrier to load data through POI, and finally makes the entire data and the input and output process of excel transparent through the annotation mechanism of unitils. It supports using the data in the excel file to perform logical operations such as inserting, comparing, and deleting to the database.

[0029] Among them, POI is a Java open source toolkit, dedicated to parsing and generating file types related to Microsoft OLE2, such as word, excel...

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] This application relates to the field of testing technology, and in particular to a method and system for preparing interface test data. Background technique [0002] Interface test is a test to test the interface between system components. It is mainly used to detect the interaction points between external systems and systems and between internal subsystems. [0003] In the interface test, when the test case is executed, SQL statements can be used to query and update the data in the database. At this time, you need to call the data required for the test from the database, and then perform the corresponding operations. Because the system is constantly being 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 execution of the test case, the update and other operations will cause the data to change, but each time the test case is executed, the database needs to be down...

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 Patents(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 Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products