Movatterモバイル変換


[0]ホーム

URL:


CN110096434A - Interface testing method and device - Google Patents

Interface testing method and device
Download PDF

Info

Publication number
CN110096434A
CN110096434ACN201910242338.0ACN201910242338ACN110096434ACN 110096434 ACN110096434 ACN 110096434ACN 201910242338 ACN201910242338 ACN 201910242338ACN 110096434 ACN110096434 ACN 110096434A
Authority
CN
China
Prior art keywords
test
template
target
file
target test
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
CN201910242338.0A
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.)
MIGU Culture Technology Co Ltd
Original Assignee
MIGU Culture 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 MIGU Culture Technology Co LtdfiledCriticalMIGU Culture Technology Co Ltd
Priority to CN201910242338.0ApriorityCriticalpatent/CN110096434A/en
Publication of CN110096434ApublicationCriticalpatent/CN110096434A/en
Pendinglegal-statusCriticalCurrent

Links

Classifications

Landscapes

Abstract

Translated fromChinese

本发明实施例提供一种接口测试方法及装置,其中方法包括获取预先存储有测试文件的excel文件,其中所述测试文件包括测试模板文件和与所述测试模板文件中每个测试模板相对应的测试数据文件,且所述测试模板文件存储在所述excel文件中的至少一个第一工作表sheet页中,所述测试数据文件存储在所述excel文件中的至少一个第二sheet页中;从第一sheet页中获取目标测试模板,并从所述第二sheet页中获取与所述目标测试模板相对应的目标测试数据文件;根据所述目标测试模板和所述目标测试数据文件,对http接口进行测试。本发明实施例实现了测试模板和测试数据的分离,降低了测试用例的维护成本。

Embodiments of the present invention provide an interface testing method and device, wherein the method includes acquiring an excel file pre-stored with a test file, wherein the test file includes a test template file and a test template corresponding to each test template in the test template file a test data file, and the test template file is stored in at least one first worksheet sheet page in the excel file, and the test data file is stored in at least one second sheet page in the excel file; from The target test template is obtained from the first sheet page, and the target test data file corresponding to the target test template is obtained from the second sheet page; according to the target test template and the target test data file, the http interface for testing. The embodiment of the present invention realizes the separation of the test template and the test data, and reduces the maintenance cost of the test case.

Description

Translated fromChinese
一种接口测试方法及装置Interface testing method and device

技术领域technical field

本发明实施例涉及软件测试技术领域,尤其涉及一种接口测试方法及装置。Embodiments of the present invention relate to the technical field of software testing, and in particular, to an interface testing method and device.

背景技术Background technique

在现有的接口测试工作中,存在大量的http接口测试场景。其中,目前在对http接口进行自动化测试时,通常借助自动化测试框架(如robot framework)进行测试,而这需要用户学习框架的测试用例制作规范,在框架内编写测试用例,必要时还需要编写少量的脚本代码,然后在制作完测试用例后,由框架批量执行用例得到测试结果。In the existing interface testing work, there are a large number of http interface testing scenarios. Among them, when the http interface is automatically tested, it is usually tested with the help of an automated test framework (such as robot framework), which requires users to learn the test case production specification of the framework, write test cases in the framework, and write a small amount of test cases if necessary. After the test case is made, the framework executes the test case in batches to obtain the test result.

但是,该种测试方式学习成本较高,测试用例编写较为耗时,且测试用例可读性较差,测试用例维护成本较高。However, this test method has high learning cost, time-consuming test case writing, poor test case readability, and high test case maintenance cost.

发明内容SUMMARY OF THE INVENTION

本发明实施例提供一种接口测试方法及装置,以解决现有技术中在对http接口进行自动化测试时测试用例维护成本较高的问题。Embodiments of the present invention provide an interface testing method and device, so as to solve the problem of high maintenance cost of test cases in the prior art when an http interface is automatically tested.

为了解决上述技术问题,第一方面,本发明实施例提供一种接口测试方法,所述方法包括:In order to solve the above technical problems, in a first aspect, an embodiment of the present invention provides an interface testing method, the method includes:

获取预先存储有测试文件的excel文件,其中所述测试文件包括测试模板文件和与所述测试模板文件中每个测试模板相对应的测试数据文件,且所述测试模板文件存储在所述excel文件中的至少一个第一工作表sheet页中,所述测试数据文件存储在所述excel文件中的至少一个第二sheet页中;Obtain an excel file pre-stored with a test file, wherein the test file includes a test template file and a test data file corresponding to each test template in the test template file, and the test template file is stored in the excel file. In at least one first worksheet sheet page, the test data file is stored in at least one second sheet page in the excel file;

从第一sheet页中获取目标测试模板,并从所述第二sheet页中获取与所述目标测试模板相对应的目标测试数据文件;Obtain the target test template from the first sheet page, and obtain the target test data file corresponding to the target test template from the second sheet page;

根据所述目标测试模板和所述目标测试数据文件,对http接口进行测试。Test the http interface according to the target test template and the target test data file.

第二方面,本发明实施例提供一种接口测试装置,所述装置包括:In a second aspect, an embodiment of the present invention provides an interface testing device, the device comprising:

第一获取模块,用于获取预先存储有测试文件的excel文件,其中所述测试文件包括测试模板文件和与所述测试模板文件中每个测试模板相对应的测试数据文件,且所述测试模板文件存储在所述excel文件中的至少一个第一工作表sheet页中,所述测试数据文件存储在所述excel文件中的至少一个第二sheet页中;The first acquisition module is used to acquire an excel file pre-stored with a test file, wherein the test file includes a test template file and a test data file corresponding to each test template in the test template file, and the test template The file is stored in at least one first worksheet sheet page in the excel file, and the test data file is stored in at least one second sheet page in the excel file;

第二获取模块,用于从第一sheet页中获取目标测试模板,并从所述第二sheet页中获取与所述目标测试模板相对应的目标测试数据文件;A second acquisition module, configured to acquire a target test template from the first sheet page, and acquire a target test data file corresponding to the target test template from the second sheet page;

测试模块,用于根据所述目标测试模板和所述目标测试数据文件,对http接口进行测试。The test module is used to test the http interface according to the target test template and the target test data file.

第三方面,本发明实施例提供一种电子设备,包括存储器、处理器及存储在存储器上并可在处理器上运行的计算机程序,所述处理器执行所述计算机程序时实现所述的接口测试方法的步骤。In a third aspect, an embodiment of the present invention provides an electronic device, including a memory, a processor, and a computer program stored in the memory and running on the processor, where the processor implements the interface when executing the computer program Steps of the test method.

第四方面,本发明实施例提供一种非暂态计算机可读存储介质,其上存储有计算机程序,该计算机程序被处理器执行时实现所述的接口测试方法的步骤。In a fourth aspect, an embodiment of the present invention provides a non-transitory computer-readable storage medium on which a computer program is stored, and when the computer program is executed by a processor, implements the steps of the interface testing method.

本发明实施例提供的接口测试方法及装置中,通过将测试文件中的测试模板文件存储在excel文件中的第一sheet页,并将测试数据文件存储在同一excel文件中的第二sheet页中,使得在对http接口进行测试时,能够从第一sheet页中获取目标测试模板,并从第二sheet页中获取与目标测试模板相对应的目标测试数据文件,然后根据目标测试模板和目标测试数据文件,对http接口进行测试,从而实现了基于测试模板和测试数据的分离存储,使得测试文件具有较好的可读性,并且使得测试模板能够得到更好的维护,降低了在对http接口进行自动化测试时测试用例的维护成本。In the interface testing method and device provided by the embodiments of the present invention, the test template file in the test file is stored in the first sheet page of the excel file, and the test data file is stored in the second sheet page in the same excel file , so that when testing the http interface, the target test template can be obtained from the first sheet page, and the target test data file corresponding to the target test template can be obtained from the second sheet page, and then according to the target test template and target test Data files, test the http interface, thus realizing the separate storage based on the test template and test data, making the test file more readable, and making the test template better maintained, reducing the need for the http interface. The maintenance cost of test cases when doing automated testing.

附图说明Description of drawings

为了更清楚地说明本发明实施例或现有技术中的技术方案,下面将对实施例或现有技术描述中所需要使用的附图作一简单地介绍,显而易见地,下面描述中的附图是本发明的一些实施例,对于本领域普通技术人员来讲,在不付出创造性劳动的前提下,还可以根据这些附图获得其他的附图。In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the following briefly introduces the accompanying drawings that need to be used in the description of the embodiments or the prior art. Obviously, the accompanying drawings in the following description These are some embodiments of the present invention. For those of ordinary skill in the art, other drawings can also be obtained according to these drawings without creative efforts.

图1表示本发明实施例中接口测试方法的步骤流程图;Fig. 1 represents the step flow chart of the interface testing method in the embodiment of the present invention;

图2表示本发明实施例中接口测试装置的模块框图;Fig. 2 shows the module block diagram of the interface testing device in the embodiment of the present invention;

图3表示本发明实施例中电子设备的实体结构示意图。FIG. 3 is a schematic diagram of a physical structure of an electronic device in an embodiment of the present invention.

具体实施方式Detailed ways

为使本发明实施例的目的、技术方案和优点更加清楚,下面将结合本发明实施例中的附图,对本发明实施例中的技术方案进行清楚、完整地描述,显然,所描述的实施例是本发明一部分实施例,而不是全部的实施例。基于本发明中的实施例,本领域普通技术人员在没有作出创造性劳动前提下所获得的所有其他实施例,都属于本发明保护的范围。In order to make the purposes, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments These are some embodiments of the present invention, but not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative efforts shall fall within the protection scope of the present invention.

如图1所示,为本发明实施例中接口测试方法的步骤流程图,该方法包括如下步骤:As shown in FIG. 1, it is a flowchart of steps of an interface testing method in an embodiment of the present invention, and the method includes the following steps:

步骤101:获取预先存储有测试文件的excel文件。Step 101: Acquire an excel file pre-stored with a test file.

具体的,测试文件包括测试模板文件和与测试模板文件中每个测试模板相对应的测试数据文件,且测试模板文件存储在excel文件中的至少一个工作表(sheet)页中,测试数据文件存储在excel文件中的至少一个第二sheet页中。即测试文件包括excel测试模板文件和excel测试数据文件,且excel测试模板文件和excel测试数据文件均以sheet页的形式存在于同一excel测试表格中。Specifically, the test file includes a test template file and a test data file corresponding to each test template in the test template file, and the test template file is stored in at least one sheet page in the excel file, and the test data file stores In at least one second sheet page in the excel file. That is, the test file includes an excel test template file and an excel test data file, and both the excel test template file and the excel test data file exist in the same excel test form in the form of sheet pages.

这样实现了通过excel文件中的sheet页,将测试模板文件和测试数据文件相分离,从而使得在编写测试用例时只需要选择合适的测试模板,然后仅在测试数据文件所在的sheet页内进行数据编写即可,简化了编写过程,并且使得测试模板具有很好的可维护性,进而实现了高效率的测试用例编写和测试用例的良好可读性和可维护性。In this way, the test template file and the test data file are separated through the sheet page in the excel file, so that when writing a test case, only the appropriate test template needs to be selected, and then the data is only carried out in the sheet page where the test data file is located. It can be written, which simplifies the writing process, and makes the test template have good maintainability, thereby realizing efficient test case writing and good readability and maintainability of test cases.

步骤102:从第一sheet页中获取目标测试模板,并从第二sheet页中获取与目标测试模板相对应的目标测试数据文件。Step 102: Acquire the target test template from the first sheet, and acquire the target test data file corresponding to the target test template from the second sheet.

在本步骤中,具体的,在获取到预先存储有测试文件的excel文件之后,可以从第一sheet页中获取目标测试模板,并从第二sheet页中获取与目标测试模板相对应的目标测试数据文件,以实现将目标测试模板和目标测试数据文件合成一目标测试用例,并对http接口进行测试。In this step, specifically, after obtaining the excel file pre-stored with the test file, the target test template can be obtained from the first sheet page, and the target test corresponding to the target test template can be obtained from the second sheet page data file, so as to combine the target test template and the target test data file into a target test case, and test the http interface.

步骤103:根据目标测试模板和目标测试数据文件,对http接口进行测试。Step 103: Test the http interface according to the target test template and the target test data file.

在本步骤中,具体的,在确定目标测试模板和与目标测试模板相对应的目标测试数据文件之后,可以根据目标测试模板和目标测试数据文件,对http接口进行测试。In this step, specifically, after the target test template and the target test data file corresponding to the target test template are determined, the http interface can be tested according to the target test template and the target test data file.

这样,本实施例通过将测试文件中的测试模板文件存储在excel文件中的第一sheet页,并将测试数据文件存储在同一excel文件中的第二sheet页中,使得在对http接口进行测试时,能够从第一sheet页中获取目标测试模板,并从第二sheet页中获取与目标测试模板相对应的目标测试数据文件,然后根据目标测试模板和目标测试数据文件,对http接口进行测试,从而实现了基于测试模板和测试数据的分离存储,使得测试文件具有较好的可读性,并且使得测试模板能够得到更好的维护,降低了在对http接口进行自动化测试时测试用例的维护成本。In this way, in this embodiment, the test template file in the test file is stored in the first sheet page of the excel file, and the test data file is stored in the second sheet page in the same excel file, so that the http interface is tested when , the target test template can be obtained from the first sheet page, and the target test data file corresponding to the target test template can be obtained from the second sheet page, and then the http interface can be tested according to the target test template and the target test data file. , thus realizing the separate storage based on the test template and test data, making the test file more readable, and making the test template better maintained, reducing the maintenance of test cases during automated testing of the http interface cost.

此外,在此对测试文件中的测试模板文件和测试数据文件进行介绍说明。In addition, the test template file and test data file in the test file are introduced and explained here.

其中,测试模板文件中的每一测试模板均包括用例模板编号、http请求类型、默认统一资源定位符(简称URL)、http请求头、http请求体和断言字段,其中所述http请求体中包括有至少一个变更主体参数,且所述用例模板编号、http请求类型、默认URL、http请求头、http请求体和断言字段分别位于所述第一sheet页内的不同列中。Wherein, each test template in the test template file includes a use case template number, http request type, default Uniform Resource Locator (URL for short), http request header, http request body and assertion fields, wherein the http request body includes There is at least one change body parameter, and the use case template number, http request type, default URL, http request header, http request body and assertion fields are respectively located in different columns in the first sheet page.

另外,与每一测试模板相对应的测试数据文件均包括测试描述数据和测试参数数据。In addition, the test data file corresponding to each test template includes test description data and test parameter data.

其中,所述测试描述数据至少包括用例模板编号、请求URL和测试期望返回值,且所述用例模板编号、请求URL和测试期望返回值分别位于所述第二sheet页第一预设区域内的不同列中;所述测试参数数据包括位于所述第二sheet页第二预设区域内所有列中的参数值,其中所述第二预设区域内的列数与第一http请求体中至少一个变更主体参数的数量相同,且每列参数值的列名分别为第一http请求体中一变更主体参数的参数名,所述第一http请求体为与所述测试数据文件相对应的测试模板中的http请求体。The test description data includes at least a use case template number, a request URL, and an expected test return value, and the use case template number, request URL, and test expected return value are located in the first preset area of the second sheet page, respectively. different columns; the test parameter data includes parameter values located in all columns in the second preset area of the second sheet page, wherein the number of columns in the second preset area is at least the same as the first http request body. The number of parameters of a change body is the same, and the column name of each column parameter value is the parameter name of a change body parameter in the first http request body, and the first http request body is the test corresponding to the test data file. The http request body in the template.

此外,在此需要说明的是,所述第一预设区域为所述第二sheet页内除所述第二预设区域之外的区域,且所述第二sheet页内每行中的测试描述数据和测试参数数据为一组测试数据。In addition, it should be noted here that the first preset area is an area other than the second preset area in the second sheet page, and the test in each row in the second sheet page The description data and the test parameter data are a set of test data.

下面分别对测试模板文件中的测试模板的内容以及测试数据文件的内容进行说明。The content of the test template in the test template file and the content of the test data file are described below respectively.

在此先对测试模板中的内容进行介绍:Let's first introduce the content in the test template:

具体的,用例模板编号为测试模板的编号,用于标识不同的测试模板,例如可以为0001、0002和0003等。Specifically, the number of the use case template is the number of the test template, which is used to identify different test templates, and may be, for example, 0001, 0002, and 0003.

此外,http请求类型所对应的列名可以为Method,且可以包括POST和GET等请求类型。In addition, the column name corresponding to the http request type can be Method, and can include request types such as POST and GET.

此外,http请求头所对应的列名可以为Header,且http请求头可以包含若干个属性,格式为“属性名:属性值”。例如,http请求头可以为“Content type=application/json;token=wrurhfnf jfkfkfkfk”。In addition, the column name corresponding to the http request header can be Header, and the http request header can contain several attributes in the format of "attribute name:attribute value". For example, the http request header may be "Content type=application/json; token=wrurhfnf jfkfkfkfk".

此外,默认URL为测试模板所对应的默认http地址,即在未对测试模板的http地址进行指定时,该默认URL即为测试模板所对应的http地址。In addition, the default URL is the default http address corresponding to the test template, that is, when the http address of the test template is not specified, the default URL is the http address corresponding to the test template.

此外,http请求体所对应的列名可以为模板内容,且http请求体中包含有至少一个变更主体参数,其中变更主体参数可以用${}代替,且本实施例可以采用第二sheet页中的测试数据替换变更主体参数,构成完成的http请求报文体。例如,变更主体参数可以为"AccountCode":"${AccountCode}","SourceCode":"${SourceCode}","ChannelCode":"${ChannelCode}","Phone_Num":"${Phone_Num}","operate_Type":${operate_Type},"CooperateCode":"${CooperateCode}","ContentCode":"${ContentCode}"或者"ProductCode":"${ProductCode}"。In addition, the column name corresponding to the http request body can be the template content, and the http request body contains at least one change body parameter, wherein the change body parameter can be replaced by ${}, and in this embodiment, the second sheet page can be used. The test data replaces the change body parameters to form the completed http request message body. For example, the change body parameter can be "AccountCode":"${AccountCode}","SourceCode":"${SourceCode}","ChannelCode":"${ChannelCode}","Phone_Num":"${Phone_Num}" ,"operate_Type":${operate_Type},"CooperateCode":"${CooperateCode}","ContentCode":"${ContentCode}" or "ProductCode":"${ProductCode}".

此外,断言字段所对应的列名可以为assert_field,其中断言字段为http测试返回报文中的关键字段,且本实施例可以通过测试引擎自动提取该断言字段,用于判断测试用例是否执行成功。当然,在此需要说明的是,若该断言字段为空,则测试引擎会根据http测试返回报文中的http返回码是否为200,判断测试用例是否执行成功。In addition, the column name corresponding to the assertion field may be assert_field, where the assertion field is a key field in the http test return message, and the assertion field may be automatically extracted by the test engine in this embodiment to determine whether the test case is successfully executed . Of course, it should be noted here that if the assertion field is empty, the test engine will determine whether the test case is successfully executed according to whether the http return code in the http test return message is 200.

具体的,测试模板文件在excel文件第一sheet页内的表现形式可以如下面表1所示:Specifically, the expression of the test template file in the first sheet page of the excel file can be as shown in Table 1 below:

表1Table 1

此外,在此对测试数据文件的内容进行说明:In addition, the content of the test data file is explained here:

具体的,每个测试模板均对应有一个测试数据文件,且测试模板和相对应的测试数据文件通过用例模板编号相关联。此外,测试数据文件所在的第二sheet页包括第一预设区域和第二预设区域两个区域,且每个测试数据数据文件中的测试描述数据位于第一预设区域内,测试参数数据位于第二预设区域内。这样,基于第二预设区域内的列数为定值,且第二sheet页内除第二预设区域之外的区域均为第一预设区域,实现了第一预设区域中的列数无限制,从而使得用户可以根据需求在第一预设区域内添加更多列的测试描述数据,例如版本号、测试人员等,提高了测试数据文件编写的灵活性,进而使得测试文件具有更高的自主性和灵活性。Specifically, each test template corresponds to a test data file, and the test template and the corresponding test data file are associated by a use case template number. In addition, the second sheet page where the test data file is located includes two areas: a first preset area and a second preset area, and the test description data in each test data data file is located in the first preset area, and the test parameter data in the second preset area. In this way, based on the fact that the number of columns in the second preset area is a fixed value, and the areas on the second sheet page other than the second preset area are the first preset area, the columns in the first preset area are realized. There is no limit to the number of test data files, so that users can add more columns of test description data in the first preset area according to their needs, such as version number, tester, etc., which improves the flexibility of test data file writing and makes the test file more flexible. High autonomy and flexibility.

此外,具体的,针对一测试数据文件而言,测试描述数据中的用例模板编号和与该测试数据文件相对应的测试模板中的用例模板编号相同,这使得本实施例能够通过用例模板编号获取相对应的测试模板和测试数据文件。In addition, specifically, for a test data file, the use case template number in the test description data is the same as the use case template number in the test template corresponding to the test data file, which enables this embodiment to obtain the use case template number through the use case template number. Corresponding test templates and test data files.

此外,用户根据实际需求在请求URL列中填写请求URL,此时本实施例可以将请求URL替换测试模板中的默认URL。当然在此需要说明的是,当请求URL列中没有数据时,则默认http地址为默认URL所对应的地址。In addition, the user fills in the request URL in the request URL column according to actual requirements. In this embodiment, the request URL may be replaced by the default URL in the test template. Of course, it should be noted here that when there is no data in the request URL column, the default http address is the address corresponding to the default URL.

此外,测试期望返回值为用户根据实际情况设定的预设值,该值用于与http测试返回报文中的测试返回值相比较,以对测试结果进行判定。In addition, the expected return value of the test is a preset value set by the user according to the actual situation, and the value is used for comparing with the test return value in the http test return message to judge the test result.

此外,第二预设区域内的列数与第一http请求体中的变更主体参数的数量相同,且第二预设区域内每列的列名分别为第一http请求体中一变更主体参数的参数名,这使得在具有对应关系的测试模板和测试数据文件中,测试数据文件中的测试参数数据能够与测试模板中http请求体内的变更主体参数相对应,从而使得能够从测试数据文件中查询到测试模板http请求体中每个变更主体参数所对应的参数值,进而使得能够将http请求体中的变更主体参数替换为所对应的参数值,得到完整的http请求报文体。In addition, the number of columns in the second preset area is the same as the number of change body parameters in the first http request body, and the column name of each column in the second preset area is a change body parameter in the first http request body respectively The parameter name of the test template and the test data file with the corresponding relationship, the test parameter data in the test data file can correspond to the change body parameter in the http request body in the test template, so that it can be retrieved from the test data file. The parameter value corresponding to each change body parameter in the http request body of the test template is queried, so that the change body parameter in the http request body can be replaced with the corresponding parameter value, and a complete http request message body can be obtained.

另外,在此需要说明的是,第二预设区域内的所有列均为相邻列,以便于对参数值的查找。In addition, it should be noted here that all columns in the second preset area are adjacent columns, so as to facilitate the search for parameter values.

具体的,单个测试数据文件在excel文件第二sheet页内的表现形式可以如下面表2所示:Specifically, the expression of a single test data file in the second sheet page of the excel file can be as shown in Table 2 below:

表2Table 2

具体的,在上述表格中,AccountCode列、SourceCode列、ChannelCode列、Phone_Num列和Operate_Type列组成第二预设区域,且该些列内的数据为测试参数数据;其余列所在区域为第一预设区域,且该些列内的数据为测试描述数据。Specifically, in the above table, the AccountCode column, the SourceCode column, the ChannelCode column, the Phone_Num column and the Operate_Type column form the second preset area, and the data in these columns is the test parameter data; the areas where the other columns are located are the first preset area area, and the data in these columns are test description data.

当然,还在此进行说明的是,在上述表格中同一行中的测试描述数据和测试参数数据构成一组测试数据。Of course, it is also explained here that the test description data and test parameter data in the same row in the above table constitute a set of test data.

此外,具体的,当第二sheet页中存在多个测试数据文件时,多个测试数据文件之间以空行相间隔,以增强测试数据文件的可读性和可维护性。In addition, specifically, when there are multiple test data files in the second sheet page, the multiple test data files are separated by blank lines, so as to enhance the readability and maintainability of the test data files.

这样,本实施例通过在excel文件第一sheet页中存储测试模板文件,在第二sheet页中存储与每个测试模板相对应的测试数据文件,且测试模板包括用例模板编号和http请求体,测试数据文件中包括有用例模板编号和与http请求体中变更主体参数相对应的参数值,使得能够将测试模板和测试数据文件合成一个整体的测试用例对http接口进行测试,并且使得在对测试用例进行编写时,只需要编写测试数据文件即可,实现了高效率的测试用例编写;此外,通过不同的sheet页分别记录测试模板和测试数据文件,增强了测试用例的可读性和可维护性。In this way, in this embodiment, the test template file is stored in the first sheet page of the excel file, and the test data file corresponding to each test template is stored in the second sheet page, and the test template includes the use case template number and the http request body, The test data file includes the use case template number and the parameter value corresponding to the change body parameter in the http request body, so that the test template and the test data file can be combined into a whole test case to test the http interface, and make the test When writing test cases, you only need to write test data files, which realizes efficient test case writing; in addition, the test templates and test data files are recorded separately through different sheet pages, which enhances the readability and maintainability of test cases. sex.

此外,进一步地,在步骤102中,从第一sheet页中获取目标测试模板,并从所述第二sheet页中获取与所述目标测试模板相对应的目标测试数据文件时,可以包括如下子步骤:In addition, further, in step 102, when the target test template is obtained from the first sheet page, and the target test data file corresponding to the target test template is obtained from the second sheet page, the following subsections may be included step:

步骤A:按照预设顺序对所述第一sheet页内的用例模板编号进行依次遍历,并将当前遍历到的用例模板编号确定为目标用例模板编号。Step A: The use case template numbers in the first sheet page are sequentially traversed in a preset order, and the currently traversed use case template number is determined as the target use case template number.

在本步骤中,具体的,预设顺序可以为第一sheet页内由上到下的顺序,或者由下到上的顺序,即在此并不对预设顺序进行限定。In this step, specifically, the preset sequence may be a top-to-bottom sequence or a bottom-to-top sequence in the first sheet, that is, the preset sequence is not limited herein.

此外,本实施例在按照预设顺序对第一sheet页内的用例模板编号进行依次遍历时,可以将当前遍历到的用例模板编号确定为目标用例模板编号。在此可以结合表1进行说明。In addition, in this embodiment, when sequentially traversing the use case template numbers in the first sheet page in a preset order, the currently traversed use case template number may be determined as the target use case template number. This can be described in conjunction with Table 1.

例如,假设表1为第一sheet页,则当按照排序为由上到下的预设顺序对第一sheet页内的用例模板编号进行依次遍历时,首先遍历到表1中第一行的用例模板编号0001,此时可以将当前遍历到的用例模板编号0001确定为目标用例模板编号;此外,若按照预设顺序遍历到表1中第二行的用例模板编号0002时,则将当前遍历到的用例模板编号0002确定为目标用例模板编号。For example, assuming that Table 1 is the first sheet page, when the use case template numbers in the first sheet page are sequentially traversed in the preset order from top to bottom, the use case in the first row in Table 1 is first traversed The template number is 0001. At this time, the currently traversed use case template number 0001 can be determined as the target use case template number; in addition, if the use case template number 0002 in the second row in Table 1 is traversed in the preset order, The use case template number 0002 is determined as the target use case template number.

步骤B:根据所述目标用例模板编号,从所述第一sheet页内获取所述目标用例模板编号所对应的测试模板,并将所述目标用例模板编号所对应的测试模板确定为所述目标测试模板,以及,根据所述目标用例模板编号,从所述第二sheet页内获取所述目标用例模板编号所对应的所有组测试数据,并将所述目标用例模板编号所对应的所有组测试数据确定为所述目标测试数据文件。Step B: According to the target use case template number, obtain the test template corresponding to the target use case template number from the first sheet page, and determine the test template corresponding to the target use case template number as the target test template, and, according to the target use case template number, obtain all groups of test data corresponding to the target use case template number from the second sheet page, and test all groups corresponding to the target use case template number Data is identified as the target test data file.

在本步骤中,具体的,由于第一sheet页中存储的测试模板文件中每个测试模板均包括位于不同列中的用例模板编号、http请求类型和默认URL,因此在获取到目标用例模板编号时,可以获取到该目标用例模板编号所在行的所有数据,即获取到该目标用例模板编号所对应的测试模板,并可以将该测试模板确定为目标测试模板。在此可以以表1进行说明。In this step, specifically, since each test template in the test template file stored in the first sheet page includes the use case template number, http request type and default URL located in different columns, the target use case template number is obtained when the test template number is obtained. When , all data of the row where the target use case template number is located can be obtained, that is, the test template corresponding to the target use case template number can be obtained, and the test template can be determined as the target test template. Here can be described with Table 1.

例如,假设目标用例模板编号为0001,则可以将表1中用例模板编号0001所在行的所有数据组成的测试模板,确定为目标测试模板。For example, assuming that the target use case template number is 0001, the test template composed of all the data in the row where the use case template number 0001 in Table 1 is located can be determined as the target test template.

此外,具体的,由于第二sheet页中存储的每个测试数据文件中均包括测试描述数据和测试参数数据,且测试描述数据中包括用例模板编号,因此在获取到目标用例模板编号时,可以获取到该目标用例模板编号所在行的所有数据,即获取到该目标用例模板编号所对应的所有组测试数据,并可以将所有组测试数据确定为目标测试数据文件。在此可以以表2进行说明。In addition, specifically, since each test data file stored in the second sheet page includes test description data and test parameter data, and the test description data includes the use case template number, when the target use case template number is obtained, you can Obtaining all the data in the row where the target use case template number is located, that is, obtaining all the test data groups corresponding to the target use case template number, and determining all the test data groups as the target test data file. Here can be explained with Table 2.

例如,假设目标用例模板编号为0001,则可以获取表2中用例模板编号为0001的所有行中的测试数据,并将所有行中的测试数据,即所有组测试数据确定为目标测试数据文件。For example, assuming that the target use case template number is 0001, the test data in all rows of the use case template number 0001 in Table 2 can be obtained, and the test data in all rows, that is, all groups of test data, can be determined as the target test data file.

当然,在此需要说明的是,本实施例可以根据目标用例模板编号,先获取目标测试模板或者目标测试数据文件,还可以同时获取目标测试模板和目标测试数据文件,即本实施例对目标测试模板和目标测试数据的获取顺序并不进行具体限定。Of course, it should be noted here that in this embodiment, the target test template or the target test data file may be obtained first according to the target use case template number, and the target test template and the target test data file may also be obtained at the same time. The acquisition order of templates and target test data is not specifically limited.

这样,基于第一sheet页中每个测试模板均包括用例模板编号,且第二sheet页中每个测试数据文件均包括用例模板编号,使得能够通过用例模板编号,实现测试模板与测试数据文件之间的映射,进而为根据测试模板和测试数据文件之间的对应关系,得到完整的测试用例提供了基础。In this way, each test template in the first sheet page includes a use case template number, and each test data file in the second sheet page includes a use case template number, so that the test template and the test data file can be connected by the use case template number. The mapping between test templates and test data files provides a basis for obtaining complete test cases according to the corresponding relationship between test templates and test data files.

另外,进一步地,在步骤103中,在根据目标测试模板和目标测试数据文件,对http接口进行测试时,可以包括如下步骤:In addition, further, in step 103, when testing the http interface according to the target test template and the target test data file, the following steps may be included:

步骤一:对所述目标测试模板和所述目标测试数据文件进行合成处理,得到目标测试用例。Step 1: Synthesize the target test template and the target test data file to obtain a target test case.

在本步骤中,具体的,在对目标测试模板和目标测试数据文件进行合成处理时,可以根据所述目标测试数据文件中的每组测试数据中的参数值,修改所述目标测试模板内http请求体中的变更主体参数,得到http请求报文体,并当检测到所述目标测试数据文件中的请求URL列中记录有请求URL时,根据所述请求URL,修改所述目标测试模板中的默认URL;然后将修改后的所述目标测试模板确定为所述目标测试用例。In this step, specifically, when the target test template and the target test data file are synthesized, the http in the target test template can be modified according to the parameter values in each group of test data in the target test data file. Change the body parameters in the request body, obtain the http request message body, and when it is detected that the request URL is recorded in the request URL column in the target test data file, according to the request URL, modify the target test template. Default URL; then determine the modified target test template as the target test case.

当然,本实施例在对目标测试模板和目标测试数据进行合成处理时,可以先修改变更主体参数或者先修改默认URL,当然也可以同时修改变更主体参数和默认URL,在此并不对目标测试模板中http参数的修改顺序进行具体限定。Of course, when synthesizing the target test template and the target test data in this embodiment, the main body parameters can be modified or the default URL can be modified first. Of course, the main parameters and the default URL can also be modified at the same time. The target test template is not modified here. The modification order of the http parameters in the above is specifically limited.

具体的,在根据所述目标测试数据文件中的每组测试数据中的参数值,修改所述目标测试模板内http请求体中的变更主体参数,得到http请求报文体时,可以获取所述目标测试模板中的http请求体,并解析得到所述http请求体中的变更主体参数;然后根据目标测试模板中变更主体参数的参数名与目标测试数据文件中参数值的列名之间的对应关系,从所述目标测试数据文件的测试数据中获取与所述目标测试模板中每个变更主体参数相对应的参数值;最后将所述目标测试模板中每个变更主体参数修改为相对应的参数值,得到http请求报文体。Specifically, according to the parameter values in each group of test data in the target test data file, modify the change body parameters in the http request body in the target test template to obtain the http request message body, the target can be obtained. Test the http request body in the template, and parse to obtain the change body parameters in the http request body; then according to the corresponding relationship between the parameter name of the change body parameter in the target test template and the column name of the parameter value in the target test data file , obtain the parameter value corresponding to each change subject parameter in the target test template from the test data of the target test data file; finally, modify each change subject parameter in the target test template to the corresponding parameter value to get the HTTP request body.

在此结合上述表1和表2,对合成得到目标测试用例的过程进行说明。The process of synthesizing and obtaining the target test case is described here in conjunction with Table 1 and Table 2 above.

假设目标测试模板为表1中用例模板编号0001所对应的测试模板,则目标测试数据文件为表1中的所有组测试数据。此时获取表1中目标测试模板中的http请求体,即表1中的模板内容列,然后解析得到http请求体中的变更主体参数:AccountCode、SourceCode、ChannelCode、Phone_Num和operate_Type。此外,基于表1中http请求体列中的变更主体参数的参数名与表2中各列参数值的列名相同,此时可以根据解析得到的变更主体参数,从表2中的每行的测试数据中获取与解析得到的上述变更主体参数相对应的参数值。当然在此需要说明的是,在获取与上述变更主体参数相对应的参数值时,需要从同一测试数据中同时获取,以保证所获得的参数值的正确性。例如,从表2中获取到的与上述变更主体参数相对应的参数值可以分别为第一组测试数据中的371、90001、222000、A和1,还可以为第二组测试数据中的371、80001、402920、A和2,依次类推,与上述变更主体参数相对应的参数值可以为每组测试数据中相对应的参数值。Assuming that the target test template is the test template corresponding to the use case template number 0001 in Table 1, the target test data file is all groups of test data in Table 1. At this time, obtain the http request body in the target test template in Table 1, that is, the template content column in Table 1, and then parse to obtain the change body parameters in the http request body: AccountCode, SourceCode, ChannelCode, Phone_Num, and operate_Type. In addition, based on the parameter name of the change body parameter in the http request body column in Table 1 is the same as the column name of the parameter value of each column in Table 2, at this time, according to the change body parameter obtained by analysis, from each row in Table 2 The parameter value corresponding to the above-mentioned change subject parameter obtained by analysis is obtained from the test data. Of course, it should be noted here that, when acquiring the parameter value corresponding to the above-mentioned change subject parameter, it needs to be acquired from the same test data at the same time, so as to ensure the correctness of the acquired parameter value. For example, the parameter values obtained from Table 2 corresponding to the above-mentioned change subject parameters may be 371, 90001, 222000, A, and 1 in the first set of test data, and may also be 371 in the second set of test data , 80001, 402920, A, and 2, and so on, the parameter values corresponding to the above-mentioned change subject parameters can be the corresponding parameter values in each set of test data.

当然,在此还需要说明的是,http请求体中可以设置任意数量的变更主体参数,本实施例可以通过测试引擎,采用正则匹配的方式取出所有的变更主体参数的参数名,从而在第二sheet页中解析哪些是测试参数数据的列,进而得到每个变更主体参数所对应的参数值。此外,用户可以在第二sheet页中追加任意额外的测试描述数据,测试描述数据与测试用例的生成无关。Of course, what also needs to be explained here is that any number of parameters to change the main body can be set in the http request body. In this embodiment, the test engine can use regular matching to extract all the parameter names of the main parameters to be changed, so that in the second In the sheet page, analyze which columns are the test parameter data, and then get the parameter value corresponding to each change subject parameter. In addition, the user can append any additional test description data in the second sheet page, and the test description data is not related to the generation of the test case.

另外,当获取到与上述变更主体参数相对应的参数值之后,可以采用与每个变更主体参数相对应的参数值替换掉该变更主体参数,从而得到实际的http请求报文体。当然,由于表2中的请求URL列为空,即用户未指定请求URL,则可以认为http请求报文体所对应的请求URL即为目标测试模板中的默认URL。这样,http请求报文体与目标测试模板中的其他http参数组合成一个最终的http测试用例实体,即修改后的模板测试模板为目标测试用例。In addition, after the parameter value corresponding to the above-mentioned change body parameter is obtained, the parameter value corresponding to each change body parameter can be used to replace the change body parameter, so as to obtain the actual http request message body. Of course, since the request URL column in Table 2 is empty, that is, the user does not specify the request URL, it can be considered that the request URL corresponding to the http request message body is the default URL in the target test template. In this way, the http request message body and other http parameters in the target test template are combined into a final http test case entity, that is, the modified template test template is the target test case.

这样,本实施例通过上述采用目标测试数据文件中的参数值替换掉目标测试模板中的变更主体参数,且在存在请求URL时,采用目标测试数据文件中的请求URL替换掉目标测试模板中的默认URL的方式,实现了目标测试模板和目标测试数据文件的合成处理,进而实现了得到完整的目标测试用例。In this way, in this embodiment, the parameter value in the target test data file is used to replace the change subject parameter in the target test template, and when there is a request URL, the request URL in the target test data file is used to replace the parameter in the target test template. The default URL method realizes the synthetic processing of the target test template and the target test data file, and then achieves the complete target test case.

步骤二:通过所述目标测试用例,对所述http接口进行测试,得到测试结果。Step 2: Test the http interface through the target test case to obtain a test result.

在本步骤中,在通过目标测试用例,对http接口进行测试时,可以先通过所述目标测试用例,对所述http接口进行测试,得到http测试返回报文;然后根据所述目标测试用例中的断言字段,对所述http测试返回报文进行解析,得到测试返回值,并从所述目标测试数据文件中获取所述目标测试用例所对应的目标测试期望返回值;然后检测所述测试返回值与所述目标测试期望返回值是否相同,得到检测结果,并根据所述检测结果,确定对所述http接口的测试是否成功。In this step, when the http interface is tested through the target test case, the http interface can be tested first through the target test case to obtain the http test return message; and then according to the target test case The assertion field, parses the http test return message, obtains the test return value, and obtains the target test expected return value corresponding to the target test case from the target test data file; then detects that the test returns Whether the value is the same as the expected return value of the target test, a detection result is obtained, and according to the detection result, it is determined whether the test of the http interface is successful.

具体的,当所述测试返回值与所述目标测试期望返回值相同时,确定对所述http接口的测试成功,当所述测试返回值与所述目标测试期望返回值不同时,确定对所述http接口的测试失败。Specifically, when the test return value is the same as the expected return value of the target test, it is determined that the test of the http interface is successful, and when the test return value is different from the expected return value of the target test, it is determined that the test of the http interface is successful. The test of the http interface described above failed.

在此继续结合表1和表2,对上述得到测试结果的过程进行说明。Continuing to combine Table 1 and Table 2, the above process of obtaining the test results will be described.

具体的,第二sheet页中的每一行测试数据与第一sheet页中的每个测试模板关联后都能够得到一个完整的测试用例,此时可以采用每个测试用例,逐个执行http接口调用,得到http测试返回报文。Specifically, after each row of test data in the second sheet page is associated with each test template in the first sheet page, a complete test case can be obtained. At this time, each test case can be used to execute http interface calls one by one. Get the http test return message.

例如,假设表1中用例模板编号为0001所对应的目标测试模板和表2中第一行的目标测试数据组成目标测试用例,当采用该目标测试用例执行http接口调用,得到http测试返回值之后,可以从表2中第一行的测试数据中获取测试期望返回值“0003”,其中该测试期望返回值“0003”为目标测试用例所对应的目标测试期望返回值。然后,可以检测测试返回值与该目标测试期望返回值“0003”是否相同,当然,若相同,则确定对http接口的测试成功,若不同,则确定对http接口的测试失败。For example, assuming that the target test template corresponding to the use case template number 0001 in Table 1 and the target test data in the first row of Table 2 form a target test case, when the http interface call is executed using the target test case, the return value of the http test is obtained. , the test expected return value "0003" can be obtained from the test data in the first row of Table 2, where the test expected return value "0003" is the target test expected return value corresponding to the target test case. Then, it can be detected whether the test return value is the same as the expected return value "0003" of the target test. Of course, if they are the same, it is determined that the test of the http interface is successful; if they are different, it is determined that the test of the http interface has failed.

此外,具体的,http接口的描述可以如下表3所示:In addition, the specific description of the http interface can be shown in Table 3 below:

表3table 3

测试要求构造不同的http请求报文体,并验证查询结果是否成功。当然,在此需要说明的是,本实施例可以依次通过多个目标测试用例进行测试,且在每个目标测试用例测试完毕后,需要及时的回收内存资源,然后进入下一个目标测试用例的测试。The test requires constructing different http request message bodies and verifying whether the query result is successful. Of course, it should be noted here that this embodiment can be tested through multiple target test cases in sequence, and after each target test case is tested, the memory resources need to be recovered in time, and then the next target test case can be tested. .

这样,本实施例通过合成得到的目标测试用例,对http接口进行测试,得到测试结果,实现了通过excel文件中分别存储的测试模板文件和测试数据文件,对http接口的测试,进而提高了http接口测试过程中的测试用例的可读性和可维护性。In this way, in this embodiment, the http interface is tested through the synthesized target test case, and the test result is obtained, which realizes the test of the http interface through the test template file and the test data file respectively stored in the excel file, and further improves the http interface. Readability and maintainability of test cases during interface testing.

另外,进一步地,本实施例在通过所述目标测试用例,对随时http接口进行测试,得到测试结果之后,还可以根据所述测试结果,生成excel格式测试报告;其中,在所述excel格式测试报告中包括有所述http请求报文体、http测试返回报文、测试返回值、测试结果以及所述目标测试数据文件中的测试数据。In addition, further, in this embodiment, after testing the http interface at any time through the target test case, and obtaining the test result, an excel format test report can also be generated according to the test result; wherein, in the excel format test The report includes the http request message body, the http test return message, the test return value, the test result and the test data in the target test data file.

具体的,第一sheet页每一行的测试数据执行完毕后,相当于第一sheet页中追加了http请求报文体、http测试返回报文、测试返回值和测试结果四个字段,此时本实施例通过测试引擎生成一个新的excel文件,即excel格式测试报告。当然,在生成excel格式报告时,可以将第一sheet页映射为sheet页,输出到excel格式测试报告中,再添加上述四个字段,得到测试结果明细文件。同时,还可以在每个测试用例执行过程中更新统计结果表,例如更新测试用例数、用例执行成功数、用例执行失败数以及总耗时等。Specifically, after the test data of each row of the first sheet page is executed, it is equivalent to adding four fields: http request message body, http test return message, test return value and test result to the first sheet page. For example, a new excel file is generated by the test engine, that is, the test report in excel format. Of course, when generating a report in excel format, you can map the first sheet page to a sheet page, output it to the excel format test report, and then add the above four fields to get the detailed test result file. At the same time, the statistical result table can also be updated during the execution of each test case, such as updating the number of test cases, the number of successful test cases, the number of failed test cases, and the total time-consuming.

具体的,每个测试模板对应的测试用例文件执行过程中都会更新统计结果表,并当执行完所有测试用例文件后,将统计结果表输出到测试结果汇总文件中。Specifically, the statistical result table is updated during the execution of the test case file corresponding to each test template, and after all the test case files are executed, the statistical result table is output to the test result summary file.

当然,在此需要说明的是,执行测试测试前的excel文件和执行测试后的excel文件均具有存储路径。Of course, it should be noted here that the excel file before the test is executed and the excel file after the test is executed both have storage paths.

其中,执行测试前excel文件的存储路径可以如下所示:Among them, the storage path of the excel file before executing the test can be as follows:

其中,执行测试后生成的excel格式测试报告可以如下所示:Among them, the excel format test report generated after the test is executed can be as follows:

即目录层级可以如下所示:That is, the directory hierarchy can look like this:

+WORK_DIR/+WORK_DIR/

----+case_dir1/----+case_dir1/

-----------------测试模板1对应测试用例v1.xls-----------------Test template 1 corresponds to test case v1.xls

-----------------测试模板1对应测试用例v2.xls-----------------Test template 1 corresponds to test case v2.xls

----+case_dir2/----+case_dir2/

-----------------测试模板2对应测试用例v1.xls-----------------Test template 2 corresponds to test case v1.xls

-----------------测试模板2对应测试用例v2.xls-----------------Test template 2 corresponds to test case v2.xls

----+result_case_dir1/----+result_case_dir1/

-----------------result_测试模板1对应测试用例v1.xls-----------------result_test template 1 corresponds to test case v1.xls

-----------------result_测试模板1对应测试用例v2.xls-----------------result_test template 1 corresponds to test case v2.xls

----+result_case_dir2/----+result_case_dir2/

-----------------result_测试模板2对应测试用例v1.xls-----------------result_test template 2 corresponds to test case v1.xls

-----------------result_测试模板2对应测试用例v2.xls-----------------result_test template 2 corresponds to test case v2.xls

----testRobot.exe----testRobot.exe

通过上述示例可以得到,excel文件的工作目录下必须有testRobot.exe测试引擎文件,且测试用例文件可放在工作目录下的根目录或子目录中;此外,测试用例文件的文件名可以随意任命,但不能以result开头;另外,测试结果文件名为:result_${对应测试用例文件名},例如测试用例文件test_case/module_first_cas.xls对应的测试结果文件为:result_test_case/result_module_first_cas.xls。It can be obtained from the above example that the testRobot.exe test engine file must exist in the working directory of the excel file, and the test case file can be placed in the root directory or subdirectory of the working directory; in addition, the file name of the test case file can be arbitrarily appointed , but cannot start with result; in addition, the test result file name is: result_${corresponding test case file name}, for example, the test result file corresponding to the test case file test_case/module_first_cas.xls is: result_test_case/result_module_first_cas.xls.

这样,通过将测试结果以excel格式测试报告的形式输出,增强了测试结果的可读性。In this way, the readability of the test results is enhanced by outputting the test results in the form of a test report in excel format.

本发明实施例通过excel的sheet页,将测试模板文件和测试数据文件相分离,实现了高效率的测试用例编写,同时使得测试用例具备很好的可读性和可维护性。此外,本实施例基于excel的测试用例文件作为输入,重新翻译测试用例,执行http接口测试,最终以excel的形式输出测试结果,增强了测试结果的可读性。In the embodiment of the present invention, the test template file and the test data file are separated through the sheet page of excel, so as to realize efficient test case writing, and at the same time, the test case has good readability and maintainability. In addition, this embodiment uses the test case file of excel as input, retranslates the test case, executes the http interface test, and finally outputs the test result in the form of excel, which enhances the readability of the test result.

此外,如图2所示,为本发明实施例中接口测试装置的模块框图,该装置包括:In addition, as shown in FIG. 2 , it is a block diagram of an interface testing device in an embodiment of the present invention, and the device includes:

第一获取模块201,用于获取预先存储有测试文件的excel文件,其中所述测试文件包括测试模板文件和与所述测试模板文件中每个测试模板相对应的测试数据文件,且所述测试模板文件存储在所述excel文件中的至少一个第一工作表sheet页中,所述测试数据文件存储在所述excel文件中的至少一个第二sheet页中;The first acquisition module 201 is configured to acquire an excel file pre-stored with a test file, wherein the test file includes a test template file and a test data file corresponding to each test template in the test template file, and the test The template file is stored in at least one first worksheet sheet page in the excel file, and the test data file is stored in at least one second sheet page in the excel file;

第二获取模块202,用于从第一sheet页中获取目标测试模板,并从所述第二sheet页中获取与所述目标测试模板相对应的目标测试数据文件;A second obtaining module 202, configured to obtain a target test template from the first sheet page, and obtain a target test data file corresponding to the target test template from the second sheet page;

测试模块203,用于根据所述目标测试模板和所述目标测试数据文件,对http接口进行测试。The test module 203 is configured to test the http interface according to the target test template and the target test data file.

可选地,所述测试模板文件中的每一测试模板均包括用例模板编号、http请求类型、默认统一资源定位符URL、http请求头、http请求体和断言字段,其中所述http请求体中包括有至少一个变更主体参数,且所述用例模板编号、http请求类型、默认URL、http请求头、http请求体和断言字段分别位于所述第一sheet页内的不同列中;Optionally, each test template in the test template file includes a use case template number, an http request type, a default Uniform Resource Locator URL, an http request header, an http request body and an assertion field, wherein the http request body contains At least one change body parameter is included, and the use case template number, http request type, default URL, http request header, http request body and assertion fields are respectively located in different columns in the first sheet page;

与每一测试模板相对应的测试数据文件均包括测试描述数据和测试参数数据;其中,The test data file corresponding to each test template includes test description data and test parameter data; wherein,

所述测试描述数据至少包括用例模板编号、请求URL和测试期望返回值,且所述用例模板编号、请求URL和测试期望返回值分别位于所述第二sheet页第一预设区域内的不同列中;所述测试参数数据包括位于所述第二sheet页第二预设区域内所有列中的参数值,其中所述第二预设区域内的列数与第一http请求体中至少一个变更主体参数的数量相同,且每列参数值的列名分别为第一http请求体中一变更主体参数的参数名,所述第一http请求体为与所述测试数据文件相对应的测试模板中的http请求体;The test description data includes at least a use case template number, a request URL, and a test expected return value, and the use case template number, request URL, and test expected return value are located in different columns in the first preset area of the second sheet page, respectively. ; the test parameter data includes parameter values located in all columns in the second preset area of the second sheet page, wherein the number of columns in the second preset area is changed from at least one of the first http request body The number of body parameters is the same, and the column name of each column parameter value is the parameter name of a change body parameter in the first http request body, and the first http request body is in the test template corresponding to the test data file. The http request body;

其中,所述第一预设区域为所述第二sheet页内除所述第二预设区域之外的区域,且所述第二sheet页内每行中的测试描述数据和测试参数数据为一组测试数据。The first preset area is an area other than the second preset area in the second sheet page, and the test description data and test parameter data in each row in the second sheet page are: A set of test data.

可选地,所述第二获取模块202包括:Optionally, the second obtaining module 202 includes:

第一确定单元,用于按照预设顺序对所述第一sheet页内的用例模板编号进行依次遍历,并将当前遍历到的用例模板编号确定为目标用例模板编号;a first determining unit, configured to sequentially traverse the use case template numbers in the first sheet page in a preset order, and determine the currently traversed use case template number as the target use case template number;

第二确定单元,用于根据所述目标用例模板编号,从所述第一sheet页内获取所述目标用例模板编号所对应的测试模板,并将所述目标用例模板编号所对应的测试模板确定为所述目标测试模板,以及,根据所述目标用例模板编号,从所述第二sheet页内获取所述目标用例模板编号所对应的所有组测试数据,并将所述目标用例模板编号所对应的所有组测试数据确定为所述目标测试数据文件。The second determination unit is configured to obtain the test template corresponding to the target use case template number from the first sheet page according to the target use case template number, and determine the test template corresponding to the target use case template number For the target test template, and, according to the target use case template number, obtain all groups of test data corresponding to the target use case template number from the second sheet page, and assign the target use case template number corresponding to the All sets of test data identified as the target test data file.

可选地,所述测试模块203包括:Optionally, the testing module 203 includes:

第一获取单元,用于对所述目标测试模板和所述目标测试数据文件进行合成处理,得到目标测试用例;a first acquiring unit, configured to synthesize the target test template and the target test data file to obtain a target test case;

第二获取单元,用于通过所述目标测试用例,对所述http接口进行测试,得到测试结果。The second obtaining unit is configured to test the http interface through the target test case to obtain a test result.

可选地,所述第一获取单元包括:Optionally, the first obtaining unit includes:

修改子单元,用于根据所述目标测试数据文件中的每组测试数据中的参数值,修改所述目标测试模板内http请求体中的变更主体参数,得到http请求报文体,并当检测到所述目标测试数据文件中的请求URL列中记录有请求URL时,根据所述请求URL,修改所述目标测试模板中的默认URL;The modifying subunit is used for modifying the change body parameters in the http request body in the target test template according to the parameter values in each group of test data in the target test data file, so as to obtain the http request message body, and when detecting When recording the request URL in the request URL column in the target test data file, modify the default URL in the target test template according to the request URL;

确定子单元,用于将修改后的所述目标测试模板确定为所述目标测试用例。A determination subunit is used to determine the modified target test template as the target test case.

可选地,所述修改子单元用于,获取所述目标测试模板中的http请求体,并解析得到所述http请求体中的变更主体参数;根据目标测试模板中变更主体参数的参数名与目标测试数据文件中参数值的列名之间的对应关系,从所述目标测试数据文件的测试数据中获取与所述目标测试模板中每个变更主体参数相对应的参数值;将所述目标测试模板中每个变更主体参数修改为相对应的参数值,得到http请求报文体。Optionally, the modification subunit is used to obtain the http request body in the target test template, and parse to obtain the change body parameter in the http request body; according to the parameter name of the change body parameter in the target test template and the The correspondence between the column names of parameter values in the target test data file, the parameter values corresponding to each change subject parameter in the target test template are obtained from the test data of the target test data file; Each change body parameter in the test template is modified to the corresponding parameter value, and the HTTP request message body is obtained.

可选地,所述第二获取单元包括:Optionally, the second obtaining unit includes:

第一获取子单元,用于通过所述目标测试用例,对所述http接口进行测试,得到http测试返回报文;The first acquisition subunit is used to test the http interface through the target test case, and obtain the http test return message;

第二获取子单元,用于根据所述目标测试用例中的断言字段,对所述http测试返回报文进行解析,得到测试返回值,并从所述目标测试数据文件中获取所述目标测试用例所对应的目标测试期望返回值;The second obtaining subunit is configured to parse the http test return message according to the assertion field in the target test case, obtain a test return value, and obtain the target test case from the target test data file The corresponding target test expects the return value;

检测子单元,用于检测所述测试返回值与所述目标测试期望返回值是否相同,得到检测结果,并根据所述检测结果,确定对所述http接口的测试是否成功;其中,A detection subunit, configured to detect whether the test return value is the same as the expected return value of the target test, obtain a detection result, and determine whether the test of the http interface is successful according to the detection result; wherein,

当所述测试返回值与所述目标测试期望返回值相同时,确定对所述http接口的测试成功,当所述测试返回值与所述目标测试期望返回值不同时,确定对所述http接口的测试失败。When the test return value is the same as the expected return value of the target test, it is determined that the test of the http interface is successful, and when the test return value is different from the expected return value of the target test, it is determined that the http interface is tested successfully test failed.

可选地,所述装置还包括:Optionally, the device further includes:

生成模块,用于根据所述测试结果,生成excel格式测试报告;其中,在所述excel格式测试报告中包括有所述http请求报文体、http测试返回报文、测试返回值、测试结果以及所述目标测试数据文件中的测试数据。The generating module is used to generate an excel format test report according to the test result; wherein, the excel format test report includes the http request message body, the http test return message, the test return value, the test result and all the Describe the test data in the target test data file.

这样,本实施例提供的接口测试装置,通过第一获取模块获取预先存储有测试文件的excel文件,并通过第二获取模块从第一sheet页中获取目标测试模板,并从第二sheet页中获取与目标测试模板相对应的目标测试数据文件,最后通过测试模块根据目标测试模板和目标测试数据文件,对http接口进行测试,基于测试文件中的测试模板文件存储在excel文件中的第一sheet页,测试数据文件存储在同一excel文件中的第二sheet页中,使得测试文件具有较好的可读性,且增强了测试文件在测试过程中的可维护性。In this way, the interface testing device provided in this embodiment obtains the excel file pre-stored with the test file through the first obtaining module, obtains the target test template from the first sheet page through the second obtaining module, and obtains the target test template from the second sheet page through the second obtaining module. Obtain the target test data file corresponding to the target test template, and finally test the http interface according to the target test template and the target test data file through the test module, and store the first sheet in the excel file based on the test template file in the test file page, the test data file is stored in the second sheet page in the same excel file, which makes the test file have better readability and enhances the maintainability of the test file in the testing process.

此外,如图3所示,为本发明实施例提供的电子设备的实体结构示意图,该电子设备可以包括:处理器(processor)310、通信接口(Communications Interface)320、存储器(memory)330和通信总线340,其中,处理器310,通信接口320,存储器330通过通信总线340完成相互间的通信。处理器310可以调用存储在存储器330上并可在处理器310上运行的计算机程序,以执行上述各实施例提供的方法,例如包括:获取预先存储有测试文件的excel文件,其中所述测试文件包括测试模板文件和与所述测试模板文件中每个测试模板相对应的测试数据文件,且所述测试模板文件存储在所述excel文件中的至少一个第一工作表sheet页中,所述测试数据文件存储在所述excel文件中的至少一个第二sheet页中;从第一sheet页中获取目标测试模板,并从所述第二sheet页中获取与所述目标测试模板相对应的目标测试数据文件;根据所述目标测试模板和所述目标测试数据文件,对http接口进行测试。In addition, as shown in FIG. 3 , which is a schematic diagram of an entity structure of an electronic device provided by an embodiment of the present invention, the electronic device may include: a processor (processor) 310, a communications interface (Communications Interface) 320, a memory (memory) 330, and a communication The bus 340, wherein the processor 310, the communication interface 320, and the memory 330 complete the communication with each other through the communication bus 340. The processor 310 may call a computer program stored on the memory 330 and run on the processor 310 to execute the methods provided in the above embodiments, for example, including: acquiring an excel file pre-stored with a test file, wherein the test file Including a test template file and a test data file corresponding to each test template in the test template file, and the test template file is stored in at least one first sheet page in the excel file, the test The data file is stored in at least one second sheet page in the excel file; the target test template is obtained from the first sheet page, and the target test corresponding to the target test template is obtained from the second sheet page data file; test the http interface according to the target test template and the target test data file.

此外,上述的存储器330中的逻辑指令可以通过软件功能单元的形式实现并作为独立的产品销售或使用时,可以存储在一个计算机可读取存储介质中。基于这样的理解,本发明的技术方案本质上或者说对现有技术做出贡献的部分或者该技术方案的部分可以以软件产品的形式体现出来,该计算机软件产品存储在一个存储介质中,包括若干指令用以使得一台计算机设备(可以是个人计算机,服务器,或者网络设备等)执行本发明各个实施例所述方法的全部或部分步骤。而前述的存储介质包括:U盘、移动硬盘、只读存储器(ROM,Read-Only Memory)、随机存取存储器(RAM,Random Access Memory)、磁碟或者光盘等各种可以存储程序代码的介质。In addition, the above-mentioned logic instructions in the memory 330 may be implemented in the form of software functional units and may be stored in a computer-readable storage medium when sold or used as an independent product. Based on such understanding, the technical solution of the present invention can be embodied in the form of a software product in essence, or the part that contributes to the prior art or the part of the technical solution. The computer software product is stored in a storage medium, including Several instructions are used to cause a computer device (which may be a personal computer, a server, or a network device, etc.) to execute all or part of the steps of the methods described in the various embodiments of the present invention. The aforementioned storage medium includes: U disk, removable hard disk, Read-Only Memory (ROM, Read-Only Memory), Random Access Memory (RAM, Random Access Memory), magnetic disk or optical disk and other media that can store program codes .

本发明实施例还提供一种非暂态计算机可读存储介质,其上存储有计算机程序,该计算机程序被处理器执行时实现以执行上述各实施例提供的方法,例如包括:获取预先存储有测试文件的excel文件,其中所述测试文件包括测试模板文件和与所述测试模板文件中每个测试模板相对应的测试数据文件,且所述测试模板文件存储在所述excel文件中的至少一个第一工作表sheet页中,所述测试数据文件存储在所述excel文件中的至少一个第二sheet页中;从第一sheet页中获取目标测试模板,并从所述第二sheet页中获取与所述目标测试模板相对应的目标测试数据文件;根据所述目标测试模板和所述目标测试数据文件,对http接口进行测试。Embodiments of the present invention further provide a non-transitory computer-readable storage medium, on which a computer program is stored, and when the computer program is executed by a processor, is implemented to execute the methods provided in the foregoing embodiments, for example, comprising: obtaining a pre-stored an excel file of test files, wherein the test file includes a test template file and a test data file corresponding to each test template in the test template file, and the test template file is stored in at least one of the excel files In the sheet page of the first worksheet, the test data file is stored in at least one second sheet page in the excel file; the target test template is obtained from the first sheet page, and obtained from the second sheet page A target test data file corresponding to the target test template; according to the target test template and the target test data file, the http interface is tested.

以上所描述的装置实施例仅仅是示意性的,其中所述作为分离部件说明的单元可以是或者也可以不是物理上分开的,作为单元显示的部件可以是或者也可以不是物理单元,即可以位于一个地方,或者也可以分布到多个网络单元上。可以根据实际的需要选择其中的部分或者全部模块来实现本实施例方案的目的。本领域普通技术人员在不付出创造性的劳动的情况下,即可以理解并实施。The device embodiments described above are only illustrative, wherein the units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in One place, or it can be distributed over multiple network elements. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution in this embodiment. Those of ordinary skill in the art can understand and implement it without creative effort.

通过以上的实施方式的描述,本领域的技术人员可以清楚地了解到各实施方式可借助软件加必需的通用硬件平台的方式来实现,当然也可以通过硬件。基于这样的理解,上述技术方案本质上或者说对现有技术做出贡献的部分可以以软件产品的形式体现出来,该计算机软件产品可以存储在计算机可读存储介质中,如ROM/RAM、磁碟、光盘等,包括若干指令用以使得一台计算机设备(可以是个人计算机,服务器,或者网络设备等)执行各个实施例或者实施例的某些部分所述的方法。From the description of the above embodiments, those skilled in the art can clearly understand that each embodiment can be implemented by means of software plus a necessary general hardware platform, and certainly can also be implemented by hardware. Based on this understanding, the above-mentioned technical solutions can be embodied in the form of software products in essence or the parts that make contributions to the prior art, and the computer software products can be stored in computer-readable storage media, such as ROM/RAM, magnetic A disc, an optical disc, etc., includes several instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to perform the methods described in various embodiments or some parts of the embodiments.

最后应说明的是:以上实施例仅用以说明本发明的技术方案,而非对其限制;尽管参照前述实施例对本发明进行了详细的说明,本领域的普通技术人员应当理解:其依然可以对前述各实施例所记载的技术方案进行修改,或者对其中部分技术特征进行等同替换;而这些修改或者替换,并不使相应技术方案的本质脱离本发明各实施例技术方案的精神和范围。Finally, it should be noted that: the above embodiments are only used to illustrate the technical solutions of the present invention, but not to limit them; although the present invention has been described in detail with reference to the foregoing embodiments, those of ordinary skill in the art should understand: it can still be Modifications are made to the technical solutions described in the foregoing embodiments, or some technical features thereof are equivalently replaced; and these modifications or replacements do not make the essence of the corresponding technical solutions depart from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims (11)

the test description data at least comprises a case template number, a request URL and a test expected return value, and the case template number, the request URL and the test expected return value are respectively positioned in different columns in a first preset area of the second sheet page; the test parameter data comprises parameter values in all columns in a second preset area of the second sheet page, wherein the number of the columns in the second preset area is the same as the number of at least one change main body parameter in the first http request body, the column name of each column of the parameter values is the parameter name of one change main body parameter in the first http request body, and the first http request body is an http request body in the test template corresponding to the test data file;
CN201910242338.0A2019-03-282019-03-28Interface testing method and devicePendingCN110096434A (en)

Priority Applications (1)

Application NumberPriority DateFiling DateTitle
CN201910242338.0ACN110096434A (en)2019-03-282019-03-28Interface testing method and device

Applications Claiming Priority (1)

Application NumberPriority DateFiling DateTitle
CN201910242338.0ACN110096434A (en)2019-03-282019-03-28Interface testing method and device

Publications (1)

Publication NumberPublication Date
CN110096434Atrue CN110096434A (en)2019-08-06

Family

ID=67444054

Family Applications (1)

Application NumberTitlePriority DateFiling Date
CN201910242338.0APendingCN110096434A (en)2019-03-282019-03-28Interface testing method and device

Country Status (1)

CountryLink
CN (1)CN110096434A (en)

Cited By (17)

* Cited by examiner, † Cited by third party
Publication numberPriority datePublication dateAssigneeTitle
CN110781070A (en)*2019-09-062020-02-11平安科技(深圳)有限公司Big data test verification method and device, computer equipment and storage medium
CN110955600A (en)*2019-11-272020-04-03中国银行股份有限公司Interface test method and device
CN111427797A (en)*2020-04-122020-07-17广州通达汽车电气股份有限公司Automatic interface testing method and device, electronic equipment and storage medium
CN111581083A (en)*2020-04-262020-08-25北京字节跳动网络技术有限公司Interface testing method and device, electronic equipment and storage medium
CN111694736A (en)*2020-05-292020-09-22新华三大数据技术有限公司Parameter acquisition method, computer equipment and storage medium
CN111782117A (en)*2020-06-302020-10-16京东数字科技控股有限公司 Interface display method and device, storage medium, and electronic device
CN112131123A (en)*2020-09-272020-12-25平安国际智慧城市科技股份有限公司Test case generation method and device, terminal device and storage medium
CN112463534A (en)*2020-11-262021-03-09歌尔科技有限公司Daily newspaper generating method, device, equipment and medium
CN113326208A (en)*2021-08-032021-08-31深圳市维度数据科技股份有限公司Interface test method and device
CN113722208A (en)*2021-06-042021-11-30深圳希施玛数据科技有限公司Project progress verification method and device for software test report
CN113760775A (en)*2021-09-302021-12-07唯品会(广州)软件有限公司Automatic message testing method and device
CN113806150A (en)*2021-08-162021-12-17济南浪潮数据技术有限公司Method, system, equipment and storage medium for remote testing of storage server
CN114297080A (en)*2021-12-312022-04-08百瑞互联集成电路(上海)有限公司Software implementation method, device, medium and equipment for automatic testing
CN114625629A (en)*2020-12-142022-06-14大唐移动通信设备有限公司Interface testing method, terminal and device
CN114647621A (en)*2022-03-312022-06-21中国银行股份有限公司Batch processing method and device for test data
CN115374018A (en)*2022-10-262022-11-22四川蜀天信息技术有限公司Automatic interface testing method and device
CN118377724A (en)*2024-06-212024-07-23中电云计算技术有限公司Automatic testing method and related device for load balancing software

Citations (7)

* Cited by examiner, † Cited by third party
Publication numberPriority datePublication dateAssigneeTitle
CN104636254A (en)*2015-01-162015-05-20北京创毅视讯科技有限公司Method and device for generating test case, testing method and testing equipment
WO2015088316A1 (en)*2013-12-092015-06-18Mimos BerhadFunctional test automation framework using user defined ontology
US20160342501A1 (en)*2015-05-182016-11-24Hcl Technologies LimitedAccelerating Automated Testing
CN107729243A (en)*2017-10-122018-02-23上海携程金融信息服务有限公司API automated testing method, system, equipment and storage medium
CN109144869A (en)*2018-08-162019-01-04平安科技(深圳)有限公司Automated testing method, device, computer equipment and storage medium
CN109189684A (en)*2018-08-282019-01-11四川长虹电器股份有限公司Automatic interface testing method based on Python
CN109408381A (en)*2018-10-102019-03-01四川新网银行股份有限公司A kind of product data automatic Verification platform and method based on data check template

Patent Citations (7)

* Cited by examiner, † Cited by third party
Publication numberPriority datePublication dateAssigneeTitle
WO2015088316A1 (en)*2013-12-092015-06-18Mimos BerhadFunctional test automation framework using user defined ontology
CN104636254A (en)*2015-01-162015-05-20北京创毅视讯科技有限公司Method and device for generating test case, testing method and testing equipment
US20160342501A1 (en)*2015-05-182016-11-24Hcl Technologies LimitedAccelerating Automated Testing
CN107729243A (en)*2017-10-122018-02-23上海携程金融信息服务有限公司API automated testing method, system, equipment and storage medium
CN109144869A (en)*2018-08-162019-01-04平安科技(深圳)有限公司Automated testing method, device, computer equipment and storage medium
CN109189684A (en)*2018-08-282019-01-11四川长虹电器股份有限公司Automatic interface testing method based on Python
CN109408381A (en)*2018-10-102019-03-01四川新网银行股份有限公司A kind of product data automatic Verification platform and method based on data check template

Cited By (26)

* Cited by examiner, † Cited by third party
Publication numberPriority datePublication dateAssigneeTitle
CN110781070B (en)*2019-09-062024-08-23平安科技(深圳)有限公司Big data test verification method and device, computer equipment and storage medium
CN110781070A (en)*2019-09-062020-02-11平安科技(深圳)有限公司Big data test verification method and device, computer equipment and storage medium
CN110955600A (en)*2019-11-272020-04-03中国银行股份有限公司Interface test method and device
CN110955600B (en)*2019-11-272023-11-10中国银行股份有限公司Interface testing method and device
CN111427797B (en)*2020-04-122023-12-05广州通达汽车电气股份有限公司Automatic interface testing method and device, electronic equipment and storage medium
CN111427797A (en)*2020-04-122020-07-17广州通达汽车电气股份有限公司Automatic interface testing method and device, electronic equipment and storage medium
CN111581083B (en)*2020-04-262024-02-09抖音视界有限公司Interface testing method and device, electronic equipment and storage medium
CN111581083A (en)*2020-04-262020-08-25北京字节跳动网络技术有限公司Interface testing method and device, electronic equipment and storage medium
CN111694736A (en)*2020-05-292020-09-22新华三大数据技术有限公司Parameter acquisition method, computer equipment and storage medium
CN111782117A (en)*2020-06-302020-10-16京东数字科技控股有限公司 Interface display method and device, storage medium, and electronic device
CN111782117B (en)*2020-06-302021-11-09京东数字科技控股有限公司Interface display method and device, storage medium and electronic device
CN112131123A (en)*2020-09-272020-12-25平安国际智慧城市科技股份有限公司Test case generation method and device, terminal device and storage medium
CN112131123B (en)*2020-09-272024-04-02深圳赛安特技术服务有限公司Method and device for generating test case, terminal equipment and storage medium
CN112463534A (en)*2020-11-262021-03-09歌尔科技有限公司Daily newspaper generating method, device, equipment and medium
CN112463534B (en)*2020-11-262022-11-11歌尔科技有限公司Daily newspaper generating method, device, equipment and medium
CN114625629A (en)*2020-12-142022-06-14大唐移动通信设备有限公司Interface testing method, terminal and device
CN113722208B (en)*2021-06-042023-09-05深圳希施玛数据科技有限公司Project progress verification method and device for software test report
CN113722208A (en)*2021-06-042021-11-30深圳希施玛数据科技有限公司Project progress verification method and device for software test report
CN113326208A (en)*2021-08-032021-08-31深圳市维度数据科技股份有限公司Interface test method and device
CN113806150A (en)*2021-08-162021-12-17济南浪潮数据技术有限公司Method, system, equipment and storage medium for remote testing of storage server
CN113806150B (en)*2021-08-162024-02-13济南浪潮数据技术有限公司Method, system, equipment and storage medium for remote test of storage server
CN113760775A (en)*2021-09-302021-12-07唯品会(广州)软件有限公司Automatic message testing method and device
CN114297080A (en)*2021-12-312022-04-08百瑞互联集成电路(上海)有限公司Software implementation method, device, medium and equipment for automatic testing
CN114647621A (en)*2022-03-312022-06-21中国银行股份有限公司Batch processing method and device for test data
CN115374018A (en)*2022-10-262022-11-22四川蜀天信息技术有限公司Automatic interface testing method and device
CN118377724A (en)*2024-06-212024-07-23中电云计算技术有限公司Automatic testing method and related device for load balancing software

Similar Documents

PublicationPublication DateTitle
CN110096434A (en)Interface testing method and device
CN107665171B (en)Automatic regression testing method and device
CN109508420B (en)Method and device for cleaning attributes of knowledge graph
CN114328276B (en)Test case generation method and device, and test case display method and device
CN109101415A (en)Interface test method, system, equipment and the storage medium compared based on database
CN113704083B (en)Test case generation method and device, storage medium and electronic equipment
CN107741903A (en)Application compatibility method of testing, device, computer equipment and storage medium
JP2016149127A (en)Device and method for determining entity attribute value
CN113032580A (en)Associated file recommendation method and system and electronic equipment
CN112511384B (en)Flow data processing method and device, computer equipment and storage medium
CN108170594A (en)A kind of test method of neural network model, device and equipment
CN112527676A (en)Model automation test method, device and storage medium
CN116016270A (en) A switch test management method, device, electronic equipment and storage medium
CN115391188A (en)Scene test case generation method, device, equipment and storage medium
CN114661686A (en)Message extraction method, device, equipment, medium and program product of log file
CN111078564B (en) A UI test case management method, device, computer equipment and computer-readable storage medium
CN104750604B (en)The generation method and device of browser compatibility test cases
CN114218261A (en)Data query method and device, storage medium and electronic equipment
CN117313683A (en)Metadata processing method, device, server and storage medium
CN114706589B (en) Repeat code scanning method, device and electronic device
CN107085553B (en) A kind of input box testing method and device
CN117251202A (en)Business scene dependency graph generation method and computer equipment
CN114528013B (en) Text generation method, device, electronic device, storage medium and product
CN116483344A (en)Code generation method and device, terminal equipment and computer readable storage medium
CN116860636A (en)Unit test code generation method, device, equipment and storage medium

Legal Events

DateCodeTitleDescription
PB01Publication
PB01Publication
SE01Entry into force of request for substantive examination
SE01Entry into force of request for substantive examination
RJ01Rejection of invention patent application after publication
RJ01Rejection of invention patent application after publication

Application publication date:20190806


[8]ページ先頭

©2009-2025 Movatter.jp