import unittest from public import base testcasefile = 'get_params_headers_test_data.xlsx' AllData = base.get_data( testcasefile, 'AllData') # 获取测试用例文件 testcasefile,并进一步取到该文件的sheet名,即AllData TestData = base.get_data( testcasefile, 'TestData') # 获取测试用例文件 testcasefile,并进一步取到该文件的sheet名,即TestData # 怎么获得endpoint信息呢? #先打印一下AllData 和 TestData,看看这两个的内容,然后再从它俩内容中获取endpoint信息 print(AllData) print(TestData) # 1、取endpoint EndPoint = AllData[1][1] # 取到endpiont信息,并赋值给Endpoint # 2、取Method RequestMethod = AllData[1][2] # 3、取DataAll DataAll = TestData[1][1] #DataAll是从TestData这个sheet里面取的。 # 4、取预期结果 从TestData这个sheet里取 expectedresult = TestData[1][2] class GetParamsHeadersTest(unittest.TestCase): '''Get有params和headers测试''' def setUp(self): # endpoint = 'get' 由于本文件上面 已经把endpoint已经取到,所以endpoint = EndPoint即可,不用再直接把‘get’赋给endpoint endpoint = EndPoint self.url = base.get_url(endpoint) def test_params_headers(self):
#!/usr/bin/env.python #coding:utf-8 from public import base #from public import HttpService import unittest testcasefile = 'post_json_test_data.xlsx' AllData = base.get_data(testcasefile, 'AllData') TestData = base.get_data(testcasefile, 'TestData') EndPoint = AllData[1][1] RequestMethod = AllData[1][2] Sn = TestData[1][0] RequestData = TestData[1][1] Expectedresult = TestData[1][2] class PostJsonTest(unittest.TestCase): def setUp(self): # endpoint = 'post' # self.url = base.get_url(endpoint) self.url = base.get_url(EndPoint) def test_post_json(self): # params={'show_env':1} # json={"info":{"code":1,"sex":"男","id":1900,"name":"黄爱华"}, # "code":1, # "name":"huangaihau黄爱华huangaihau黄爱华黄爱华 ","sex":"女", # "data":[{"code":1,"sex":"男","id":1900,"name":"黄爱华"},{"code":1,"sex":"女","id":1900,"name":"黄爱华"}], # "id":1900
import unittest import os from public import HttpService from public import base from public import Config from ddt import ddt, data, unpack testcasefile = 'get_params_headers_data.xlsx' AllData = base.get_data(testcasefile, 'AllData') print(AllData) TestData = base.get_data(testcasefile, 'TestData') Endpoint = AllData[1][1] dataall = TestData[1][2] expectresult = TestData[1][3] filelist = base.get_data(testcasefile, 'filelist') filefortest = filelist[1:] print('@@@@@@@@@@@@') print(filefortest) @ddt #装饰器在使用前需要将ddt给类使用,!!如果引入的ddt,需要@ddt.ddt class PostParams(unittest.TestCase): def setUp(self): endpoint = '/nbfile/upload' self.url = base.request_url(endpoint) print(self.url) @data(['1.doc'], ['1.docx']) #@data (['1.doc'],['1.docx'],['1.pdf'],['1.ppt'],['1.txt'],['1.wps'],['1.xlsx'],['1.aac'],['1.m4a'],['1.mp3'],['1.wav'],['1.bmp'],['1.gif'],['1.jpg'],['1.png'],['1.psd'],['1.asf'],['1.avi'],['1.flv'],['1.mkv'],['1.mov'],['1.mp4'],['1.rmvb'],['1.vob'],['1.wmv'],['1.rar'],['1.zip']) #['1.ppt'],['1.pdf'],['1.jpg'],['1.gif'],['1.png'],['1.bmp'],['1.psd'] #['1.doc'],['1.docx'],['1.pdf'],['1.ppt'],['1.txt'],['1.wps'],['1.xlsx'],['1.rar'],['1.zip']