CN109522216A - Team's interface exploitation cooperative system and method based on API testing tool export data - Google Patents

Team's interface exploitation cooperative system and method based on API testing tool export data Download PDF

Info

Publication number
CN109522216A
CN109522216A CN201811195542.3A CN201811195542A CN109522216A CN 109522216 A CN109522216 A CN 109522216A CN 201811195542 A CN201811195542 A CN 201811195542A CN 109522216 A CN109522216 A CN 109522216A
Authority
CN
China
Prior art keywords
interface
data
api
testing tool
api testing
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN201811195542.3A
Other languages
Chinese (zh)
Inventor
邬孟琛
范渊
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Hangzhou Dbappsecurity Technology Co Ltd
Original Assignee
Hangzhou Dbappsecurity Technology Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Hangzhou Dbappsecurity Technology Co Ltd filed Critical Hangzhou Dbappsecurity Technology Co Ltd
Priority to CN201811195542.3A priority Critical patent/CN109522216A/en
Publication of CN109522216A publication Critical patent/CN109522216A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/36Preventing errors by testing or debugging software
    • G06F11/3668Software testing
    • G06F11/3672Test management
    • G06F11/3688Test management for test execution, e.g. scheduling of test suites

Abstract

The present invention relates to computer interface interworking technologies, it is desirable to provide a kind of team's interface exploitation cooperative system and method based on API testing tool export data.The system includes sequentially connected first conversion module, memory module and the second conversion module;Wherein, the first conversion module has the interface that can be adapted to different API testing tools, is converted into unified data structure according to setting rule for receiving the interface data information from upstream API testing tool, and by it;Second conversion module has and can be adapted to the interfaces of different API testing tools, for converting the API data for storing in a storage module to downstream API testing tool type to matched interface data information.The present invention converts the data of unified format for the derived interface message data of different developers/difference API testing tool and stores and integrate using database, facilitate developer to safeguard each interface of project, saves the time overhead that developer integrates other developer's interfaces.

Description

Team's interface exploitation cooperative system and method based on API testing tool export data
Technical field
The present invention relates to computer interface interworking technologies, in particular to the team based on API testing tool export data connects Mouth exploitation cooperative system and method.
Background technique
Front and back end separation interface development mode is current development mode all the fashion, when there is multiple rear end developers When, each rear end developer respectively develops the interface that test is individually assigned to, and so just needs the interface between each developer Information integration.Interface modes are developed under environment, it is necessary to solve the problems, such as that interface message integrates intercommunication between developer, otherwise may lead Developer team is caused to need the ancillary cost plenty of time in integrated interface.
In general, would ordinarily be encountered following trouble when interface message is integrated:
(1) developer A has been used a tool (such as insomnia), and developer B has used b tool (such as postman), because Using the difference of tool, interface integration can not be carried out.If developer A wants to carry out joint debugging using the interface of developer B, have in a A time interface message is set again in tool (insomnia), and developer B is also in this way, greatly reducing working efficiency.
(2) developer is integrated using same testing tool, when exporting import feature using tool is included, difference exploitation The interface data of person can generate respective interface data set, lack the process for concluding integration, it is desired nonetheless to which developer is again whole Reason.
(3) when some interface message of developer's self-responsibility is updated, it is also necessary to other developers be notified to carry out Synchronized update carries out above-mentioned integrated operation again, and the expense for causing interface to be integrated further increases.
Chinese invention patent application CN201710375291.6 disclose a kind of interface testing use-case based on Postman from It is dynamic to generate system and method, including Postman interface testing tool, Postman parsing module and scheduling execution module, Postman interface testing tool for being responsible for joint debugging interface and providing the interface testing data of json format, survey by Postman interface The interface testing data of json format are exported to json file and are transmitted to Postman parsing module by trial work tool;Postman solution For parsing json file derived from Postman interface testing tool institute and generating interface testing use-case, scheduling executes analysis module Module is used to execute interface requests according to interface testing use-case and asserts processing.The present invention is sharp before carrying out interface automatic test With Postman interface testing tool joint debugging total interface, the json file of Postman is then exported, it is automatic as further interface The test data for changing test, ensures that the accuracy of test data in this way.Json file based on Postman, which automatically generates, to be connect Mouth test case, improves the efficiency of interface testing use-case exploitation.But the technical solution is based only on Postman tool, exists Limitation.Also, program main purpose is to improve test case development efficiency, does not carry out each Team Member's interface message Integration management, and when unresolved team collaboration, the synchronous problem of interface message.
Therefore, expense brought by integrated interface information under interface exploitation mode how is reduced, becomes and has to solution Problem.
Summary of the invention
The technical problem to be solved by the present invention is to overcome deficiency in the prior art, provide a kind of based on API testing tool Export the team's interface exploitation cooperative system and method for data.
In order to solve the above technical problems, the solution that the present invention uses is:
A kind of team's interface exploitation cooperative system based on API testing tool export data is provided, including sequentially connected First conversion module, memory module and the second conversion module;Wherein,
First conversion module has the interface that can be adapted to different API testing tools, tests work from upstream API for receiving The interface data information of tool, and unified data structure is converted according to setting rule by it;
Memory module is used to for the API data after conversion being stored in correspondence database table;
Second conversion module has the interface that can be adapted to different API testing tools, for that will store in a storage module API data is converted into downstream API testing tool type to matched interface data information.
Invention further provides team's interface exploitations based on API testing tool export data using aforementioned system The method of cooperation, comprising the following steps:
(1) first conversion module obtains interface data information derived from upstream API testing tool, and according to the rule of setting Convert these data to unified data structure;
(2) memory module records API survey using the tables of data of the database creation affiliated project of upstream API testing tool The version number of trial work tool and every API information, and the API data after conversion is stored in correspondence database table;
(3) second conversion modules are according to the corresponding structural body type of API testing tool type adaptation in downstream, and according to setting Fixed rule converts the API data being stored in database table to the interface data information of adaptation, is then transferred to downstream API testing tool.
In the present invention, the step (2) is specifically included:
A, tables of data is created or selected according to the project name filled in when importing;
B, unified data-interface field: field and the one-to-many association of field attribute is stored with perpendicular sheet form, field with connect Mouth multi-to-multi association, the value of interface field is stored in middle table, so as to the expansion of uniform data structure;
C, with interface name and version number and querying condition, uniqueness verifying is carried out to interface;
D, the API data after conversion is existed with interface and then updates corresponding interface.
In the present invention, in the step (2), when the API data after conversion to be stored in correspondence database table, such as API testing tool belongs to same version, is just updated to API duplicate in tables of data, is otherwise increased newly.
Inventive principle description:
To reduce expense brought by integrated interface information under current interface exploitation mode, the present invention provides one kind to be based on API testing tool exports team's interface exploitation cooperative system of data, and the principle of the invention is that the difference for using developer connects Mouth testing tool is integrated into Uniform data format and storage management.The key point of the invention is the different tool export data of integration. The present invention generates import modul, distinct interface is tested by analyzing interface message data structure derived from different testing tools The data of tool are converted into unified data structure, integrate and version number is arranged and be stored in interface team cooperative system, in turn Developer is facilitated to safeguard interface message.Again by corresponding export module, the interface data after integration is exported to certain The data format of kind testing tool, is easy to use the developer of the testing tool to import.It saves developer and carries out interface integration Expense, to provide team's interface exploitation efficiency.
Compared with prior art, the solution have the advantages that:
1, the derived interface message data of different developers/difference API testing tool are converted unified lattice by the present invention The data of formula are simultaneously stored and are integrated using database.Developers are facilitated to safeguard each interface of project.
2, the testing tool that the present invention can convert the interface data after integration to developer's needs imports data format, side Just developer imports, and saves the time overhead that developer integrates other developer's interfaces.
Detailed description of the invention
Fig. 1 is realization process example figure of the invention.
Specific embodiment
It is that one kind of computer technology is specific the present invention relates to computer interface interworking technology firstly the need of explanation Using.During realization of the invention, the application of multiple software function modules can be related to.It is applicant's understanding that such as careful After Reading of Application Documents, accurate understanding realization principle and goal of the invention of the invention, the case where combining existing well-known technique Under, the software programming technical ability that those skilled in the art can grasp completely with it realizes the present invention.Aforementioned software functional module Including but not limited to: the first conversion module, memory module and second conversion module etc., the category that all the present patent application files refer to This scope, applicant will not enumerate.
It is explained and illustrated, implements below with reference to technical solution of the embodiment of the present invention attached drawing to the embodiment of the present invention Mode is exemplary, and embodiment for explaining the present invention can not be interpreted as the limitation to embodiments of the present invention.
The part term used in embodiment or the explanation of abbreviation: API --- application programming interface; Insomnia --- one of common interfaces testing tool;Postman --- one of common interfaces testing tool;Mysql --- often With one of database.
In Fig. 1, respectively using insomnia and postman as the common API testing tool example of developer, based on such Team collaboration's system of testing tool export data;Specific implementation step is as follows:
Step 1: the importing and conversion of API testing tool data:
(1) data information derived from an API testing tool interface is obtained first
(2) conversion processing is carried out according to setting rule to export data acquired in step (1) as the first conversion module, it will Interface data information is converted into unified data structure.Mainly include:
A, project, version number and tool types belonging to the API testing tool that setting upstream imports;
B, it is imported data to according to tool types using corresponding structural body;
C, data will be imported and is converted into preset Uniform data format.
Step 2: carrying out data storage using memory module:
(1) using the tables of data of the database creation affiliated project of API testing tool, the version number of API testing tool is recorded And every API information.
(2) transformed API data is stored in correspondence database table;If API testing tool belongs to same version, just API duplicate in tables of data is updated, is otherwise increased newly.
Steps are as follows for specific example:
A, database uses mysql.
B, tables of data is created or selected according to the project name filled in when importing.
C, unified data-interface field is with perpendicular sheet form storage: field and the one-to-many association of field attribute, field with connect Mouth multi-to-multi association, the value of interface field are stored in middle table.To facilitate the expansion of uniform data structure.
D, with interface name and version number and querying condition, uniqueness verifying is carried out to interface.
E, the API data after conversion is existed with interface and then updates corresponding interface, there is no then newly-increased rule store to In corresponding project table.
Step 3: the conversion and export of API testing tool data:
(1) derived API tool types (i.e. the API testing tool type in downstream) are wanted in selection;
(2) according to the corresponding structural body type of setting rule selection tool type adaptation, to execute corresponding conversion;
(3) the API testing tool for converting downstream for the interface data information of storage using the second conversion module is specific Data structure.
Steps are as follows for specific example:
A, selected interface data are inquired from database.
B, the data inquired are converted to the structural body of corresponding tool.
C, derived type structure volume data.

Claims (4)

1. a kind of team's interface exploitation cooperative system based on API testing tool export data, which is characterized in that including successively connecting The first conversion module, memory module and the second conversion module connect;Wherein,
First conversion module has the interface that can be adapted to different API testing tools, for receiving from upstream API testing tool Interface data information, and unified data structure is converted according to setting rule by it;
Memory module is used to for the API data after conversion being stored in correspondence database table;
Second conversion module has the interface that can be adapted to different API testing tools, for that will store API number in a storage module According to being converted into downstream API testing tool type to matched interface data information.
2. the method for team's interface exploitation cooperation based on API testing tool export data using system described in claim 1, Characterized by comprising the following steps:
(1) first conversion module obtains interface data information derived from upstream API testing tool, and according to the regular by this of setting A little data are converted into unified data structure;
(2) memory module records API test work using the tables of data of the database creation affiliated project of upstream API testing tool The version number of tool and every API information, and the API data after conversion is stored in correspondence database table;
(3) second conversion modules are according to the corresponding structural body type of API testing tool type adaptation in downstream, and according to setting Rule converts the API data being stored in database table to the interface data information of adaptation, and the API for being then transferred to downstream is surveyed Trial work tool.
3. the method according to claim 1, wherein the step (2) specifically includes:
A, tables of data is created or selected according to the project name filled in when importing;
B, unified data-interface field: field and the one-to-many association of field attribute is stored with perpendicular sheet form, field and interface are more To more associations, the value of interface field is stored in middle table, so as to the expansion of uniform data structure;
C, with interface name and version number and querying condition, uniqueness verifying is carried out to interface;
D, the API data after conversion is existed with interface and then updates corresponding interface.
4. the method according to claim 1, wherein being deposited in the step (2) by the API data after conversion When being stored in correspondence database table, if API testing tool belongs to same version, just API duplicate in tables of data is updated, Otherwise it is increased newly.
CN201811195542.3A 2018-10-15 2018-10-15 Team's interface exploitation cooperative system and method based on API testing tool export data Pending CN109522216A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201811195542.3A CN109522216A (en) 2018-10-15 2018-10-15 Team's interface exploitation cooperative system and method based on API testing tool export data

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201811195542.3A CN109522216A (en) 2018-10-15 2018-10-15 Team's interface exploitation cooperative system and method based on API testing tool export data

Publications (1)

Publication Number Publication Date
CN109522216A true CN109522216A (en) 2019-03-26

Family

ID=65771909

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201811195542.3A Pending CN109522216A (en) 2018-10-15 2018-10-15 Team's interface exploitation cooperative system and method based on API testing tool export data

Country Status (1)

Country Link
CN (1) CN109522216A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110442465A (en) * 2019-08-07 2019-11-12 北京技德系统技术有限公司 A kind of more desktop environment shear plate share frameworks and its method

Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH11110361A (en) * 1997-10-03 1999-04-23 Fujitsu Ltd Information retrieval system for network system
US20080295076A1 (en) * 2007-05-23 2008-11-27 Microsoft Corporation Graphical user interface testing
CN104461884A (en) * 2014-12-05 2015-03-25 北京奇虎科技有限公司 Method and device for generating input data of test tools
CN105159951A (en) * 2015-08-17 2015-12-16 成都中科大旗软件有限公司 Open tourism multi-source heterogeneous data fusion method and system
CN106503274A (en) * 2016-12-22 2017-03-15 北京览群智数据科技有限责任公司 A kind of Data Integration and searching method and server
CN107168871A (en) * 2017-04-28 2017-09-15 安徽四创电子股份有限公司 A kind of method of the fast debugging in RESTful interface exploitations
CN107608951A (en) * 2017-09-22 2018-01-19 上海金智晟东电力科技有限公司 Report form generation method and system
CN108153665A (en) * 2016-12-02 2018-06-12 北京奇虎科技有限公司 Data test method and device

Patent Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH11110361A (en) * 1997-10-03 1999-04-23 Fujitsu Ltd Information retrieval system for network system
US20080295076A1 (en) * 2007-05-23 2008-11-27 Microsoft Corporation Graphical user interface testing
CN104461884A (en) * 2014-12-05 2015-03-25 北京奇虎科技有限公司 Method and device for generating input data of test tools
CN105159951A (en) * 2015-08-17 2015-12-16 成都中科大旗软件有限公司 Open tourism multi-source heterogeneous data fusion method and system
CN108153665A (en) * 2016-12-02 2018-06-12 北京奇虎科技有限公司 Data test method and device
CN106503274A (en) * 2016-12-22 2017-03-15 北京览群智数据科技有限责任公司 A kind of Data Integration and searching method and server
CN107168871A (en) * 2017-04-28 2017-09-15 安徽四创电子股份有限公司 A kind of method of the fast debugging in RESTful interface exploitations
CN107608951A (en) * 2017-09-22 2018-01-19 上海金智晟东电力科技有限公司 Report form generation method and system

Non-Patent Citations (3)

* Cited by examiner, † Cited by third party
Title
CHRISTOPH MOLITOR 等: "MESCOS—A Multienergy System Cosimulator for City District Energy Systems", 《IEEE TRANSACTIONS ON INDUSTRIAL INFORMATICS》 *
李贺 等: "基于信息资源整合的企业异构数据源集成研究", 《图书情报工作》 *
韩应升 等: "ATE测试数据分析与转换", 《国外电子测量技术》 *

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110442465A (en) * 2019-08-07 2019-11-12 北京技德系统技术有限公司 A kind of more desktop environment shear plate share frameworks and its method
CN110442465B (en) * 2019-08-07 2024-01-09 北京技德系统技术有限公司 Multi-desktop environment shear plate sharing architecture and method thereof

Similar Documents

Publication Publication Date Title
CN102637214B (en) Method and system for synchronizing general data among database services
CN110245078A (en) A kind of method for testing pressure of software, device, storage medium and server
CN101976220B (en) Unit test system
CN106951576B (en) Simulation test evaluation system and evaluation method
US9864346B2 (en) Method for connecting a substation automation device according to IEC61850 to any industry automation field bus
US7725524B2 (en) Process automation system and method having a hierarchical architecture with multiple tiers
CN103744891A (en) Method and system for data query
CN111061696B (en) Method and device for analyzing transaction message log
CN101958987A (en) Method and system for dynamically converting telecommunications service data
CN110222124A (en) Multidimensional data processing method and system based on OLAP
CN111125440B (en) Monad-based persistent layer composite condition query method and storage medium
CN112286806A (en) Automatic testing method and device, storage medium and electronic equipment
CN103116500A (en) Method and device for structural body definition and structure output
CN112181854A (en) Method, device, equipment and storage medium for generating flow automation script
CN116089126A (en) Method, device and equipment for acquiring data in real time and readable storage medium
CN109522216A (en) Team's interface exploitation cooperative system and method based on API testing tool export data
CN114238527A (en) Data processing method and data processing device based on object relation mapping
CN111090803A (en) Data processing method and device, electronic equipment and storage medium
CN110262978A (en) It is a kind of based on long process automation test interface retry method and data flow
CN101183306A (en) Universal Tuxedo configuring method with across platforms and transplant
CN116932649A (en) Database synchronization method, database synchronization device, and readable storage medium
CN111176995A (en) Test method and test system based on big data test case
CN100465959C (en) Localized data acquisition method and system
CN115617773A (en) Data migration method, device and system
Cornish et al. An open source software framework for the implementation of an open systems architecture, run-time system

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
RJ01 Rejection of invention patent application after publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20190326