class LaGou(unittest.TestCase):
def setUp(self):
self.obj = Method()
self.p = IsAssert()
def statusCode(self, r):
self.assertEqual(r.status_code, 200)
self.assertEqual(r.json()['code'], 0)
def isContent(self, r, row):
self.statusCode(r=r)
self.assertTrue(self.p.isContent(row=row, str2=r.text))
def lltest_laGou_001(self):
r = self.obj.post(1)
self.isContent(row=1, r=r)
def test_laGou_002(self):
'''拉钩:测试关键字的职位搜索'''
r = self.obj.post(row=1, data=setSo('架构师'))
list1 = []
for i in range(0, 15):
positionId = r.json(
)['content']['positionResult']['result'][i]['positionId']
list1.append(positionId)
writePositionId(json.dumps(list1))
print(list1)
def test_laGou_003(self):
'''测试搜索Python开发工程师查看第一页第一个公司的招聘信息'''
r = self.obj.post(row=2, data=setpositionInfo(row=2))
print(r.text)
class test_AirlineConfirmForecast(unittest.TestCase):
def setUp(self):
self.obj = Method()
def test_AirlineConfirmForecast_001(self):
'''航班确认预报：请求参数正确，预报成功'''
r = self.obj.post(row=86)
isIn(self, r=r, row=86)
def test_AirlineConfirmForecast_002(self):
'''航班确认预报：预报渠道未配置，预报失败'''
r = self.obj.post(row=87)
isIn(self, r=r, row=87)
def test_AirlineConfirmForecast_003(self):
'''航班确认预报：必填参数为空，预报失败'''
r = self.obj.post(row=88)
isIn(self, r=r, row=88)
def test_AirlineConfirmForecast_004(self):
'''航班确认预报：校验码不正确，预报失败'''
r = self.obj.post(row=89)
isIn(self, r=r, row=89)
def test_AirlineConfirmForecast_005(self):
'''航班确认预报：客户不存在，预报失败'''
r = self.obj.post(row=90)
isIn(self, r=r, row=90)
class test_WarehouseQuery(unittest.TestCase):
def setUp(self):
self.obj=Method()
def test_WarehouseQuery_001(self):
'''查询转运单信息：参数正确，查询美东仓成功'''
r = self.obj.post(row=1)
print(r.text)
isIn(self,r=r,row=1)
def test_WarehouseQuery_002(self):
'''查询转运单信息：参数正确，查询ECDC仓成功'''
r = self.obj.post(row=2)
print(r.text)
isIn(self,r=r,row=2)
def test_WarehouseQuery_003(self):
'''查询转运单信息：仓库代码为空，查询到所有仓成功'''
r = self.obj.post(row=3)
print(r.text)
isIn(self,r=r,row=3)
def test_WarehouseQuery_004(self):
'''查询转运单信息：仓库代码不存在，查询到所有仓成功'''
r = self.obj.post(row=4)
print(r.text)
isIn(self,r=r,row=4)
class houselist(unittest.TestCase):
def setUp(self):
self.Method=Method()
self.IsAssert=IsAssert()
'''二手房列表页接口是否正常'''
def test_houselist(self):
r = self.Method.post(1)
self.assertEqual(r.status_code,200)
self.assertTrue(self.IsAssert.isContent(1,r.text))
'''二手房列表页title是否存在'''
def test_housetitle(self):
r = self.Method.post(1)
'''列表页价格是够存在'''
def test_houseprince(self):
'''列表页委托中介是否存在'''
def test_housecompany(self):
''''''
if __name__ == '__main__':
unittest.main()
class test_AirlineForecast(unittest.TestCase):
def setUp(self):
self.obj=Method()
def test_AirlineForecast_001(self):
'''航班预报：单个包裹预报,请求参数正确，预报成功'''
r = self.obj.post(row=81)
isIn(self,r=r,row=81)
def test_AirlineForecast_002(self):
'''航班预报：预报渠道未配置，预报失败'''
r = self.obj.post(row=82)
isIn(self,r=r,row=82)
def test_AirlineForecast_003(self):
'''航班预报：必填参数为空，预报失败'''
r = self.obj.post(row=83)
isIn(self,r=r,row=83)
def test_AirlineForecast_004(self):
'''航班预报：校验码不正确，预报失败'''
r = self.obj.post(row=84)
isIn(self,r=r,row=84)
def test_AirlineForecast_005(self):
'''航班预报：客户不存在，预报失败'''
r = self.obj.post(row=85)
isIn(self,r=r,row=85)
class test_SignInBags(unittest.TestCase):
def setUp(self):
self.obj = Method()
def test_SignInBags_001(self):
'''袋子签入：正常签入'''
r = self.obj.post(row=5)
isIn(self, r=r, row=5)
self.obj.db.update(
'update transfer_bag_mapping set check_in="N",check_in_time= NULL,check_in_by =null WHERE bag_id in(select bag_id from bag_infos where rf_id="313930353034303030303337");'
)
def test_SignInBags_002(self):
'''袋子签入：袋号已签入'''
r = self.obj.post(row=6)
isIn(self, r=r, row=6)
def test_SignInBags_003(self):
'''袋子签入：仓库代码不传'''
r = self.obj.post(row=7)
isIn(self, r=r, row=7)
def test_SignInBags_004(self):
'''袋子签入：袋号不存在'''
R = 11
r = self.obj.post(row=R)
isIn(self, r=r, row=R)
class LaGou(unittest.TestCase):
def setUp(self):
self.obj=Method()
self.p=IsContent()
self.execl=OperationExcel()
self.operationJson=OperationJson()
def statusCode(self,r):
self.assertEqual(r.status_code, 200)
self.assertEqual(r.json()['code'], 0)
def isContent(self,r,row):
self.statusCode(r=r)
self.assertTrue(self.p.isContent(row=row,str2=r.text))
def test_laGou_001(self):
'''拉钩:测试翻页'''
r = self.obj.post(row=1,data=self.operationJson.getRequestsData(1))
self.isContent(r=r,row=1)
self.execl.writeResult(1,'pass')
def test_laGou_002(self):
'''拉钩:测试关键字的职位搜索'''
r =self.obj.post(row=1,data=setSo('Python开发工程师'))
list1=[]
for i in range(0,15):
positionId=r.json()['content']['positionResult']['result'][i]['positionId']
list1.append(positionId)
writePositionId(json.dumps(list1))
def test_lgGou_003(self):
'''访问搜索到的每个职位的详情页信息'''
for i in range(15):
r=self.obj.get(url=getUrl()[i])
self.assertTrue(self.p.isContent(34,r.text))
class CcZct(unittest.TestCase):
def setUp(self):
self.obj = Method()
self.p = IsAssert()
self.excel = OperationExcel()
def statusCode(self, r):
"""正确的返回状态"""
self.assertEqual(r.status_code, 200)
self.assertEqual(r.json()['statuscode'], 1)
def errstausCode(self, r):
"""错误的返回状态嘛"""
self.assertEqual(r.status_code, 200)
self.assertEqual(r.json()['statuscode'], -1)
def errstausCode1(self, r):
'''错误状态码为-100001'''
self.assertEqual(r.status_code, 200)
self.assertEqual(r.json()['statuscode'], -100001)
def test_dengl_001(self):
'''输入未注册的手机号，密码登录'''
r = self.obj.post(row=8,
data=setSo(user_account='18161328888',
password='******',
row=8))
self.errstausCode(r=r)
def test_dengl_002(self):
'''输入错误格式的手机号，密码登录'''
r = self.obj.post(row=8,
data=setSo(user_account='1816132888',
password='******',
row=8))
self.errstausCode1(r=r)
def test_dengl_003(self):
'''输入正确的手机号，密码错误'''
r = self.obj.post(row=8,
data=setSo(user_account='15002803902',
password='******',
row=8))
self.errstausCode(r=r)
def test_dengl_004(self):
'''输入正确的手机号以及密码'''
r = self.obj.post(row=8,
data=setSo(user_account='15002803902',
password='******',
row=8))
self.statusCode(r=r)
class LaGou(unittest.TestCase):
def setUp(self):
self.obj=Method()
self.p=IsContent()
self.excel=OperationExcel()
self.json=OperationJson()
def statusCode(self,r):
self.assertEqual(r.status_code,200)
self.assertEqual(r.json()['code'],0)
def isContent(self,r,row):
self.statusCode(r) # 注意要给statusCode传数据
self.assertTrue(self.p.isContent(row=row,str2=r.text))
def test_laGou_001(self):
'''拉勾：测试翻页,第一页'''
r=self.obj.post(row=1,data=self.json.getRequestData(row=1)) #obj这种写法的原理是什么,见setup方法
print(r.text)
self.isContent(r=r,row=1) #为什么不是写成self.p.isContent(r=r,row=1)???
self.excel.writeResult(1,'pass')
def test_laGou_002(self,row=2):
'''拉勾：测试翻页，第二页'''
r=self.obj.post(2) #obj这种写法的原理是什么,见setup方法
self.isContent(r=r,row=row)
self.excel.writeResult(2,'pass') #如果上面的断言失败了，pass就不会被写进文件中了
def test_laGou_003(self, row=3):
'''拉勾：测试翻页，传入不同类型的搜索关键字，替换json中的数据进行测试'''
r = self.obj.post(row=3,data=setSo('性能测试工程师'))
print(r.text)
list1=[]
for i in range(0,15): # 0< <16
positionId=r.json()['content']['positionResult']['result'][i]['positionId']
list1.append(positionId)
writePositionId(json.dumps(list1))
print(list1)
# self.isContent(r=r, row=row)
def test_laGou_004(self, row=4):
'''拉勾：访问搜索‘性能测试工程师’查看每个职位的详情信息'''
for item in getPositionId():
r=self.obj.get(url=getUrl(positionId=item))
# print(r.url)
print(r.text) #因为返回的详情页面是html的，所以没有响应状态码，只需要断言数据就行
self.assertTrue(self.p.isContent(row=4,str2=r.text)) #要么写成(row=4,str2=r.text)，要么写成(4,r.text),否则报错
class XSZC(unittest.TestCase):
def setUp(self):
self.obj = Method()
self.excel = OperationExcel()
self.operationJson = OperationJson()
def statusCode(self, r):
self.assertEqual(r.status_code, 200)
self.assertEqual(r.json()['code'], 200)
def isContent(self, r, row):
self.statusCode(r=r)
self.assertTrue(self.obj.isContent(row=row, str2=r.text))
def test_017(self):
u"新增促销政策"
r = self.obj.post(row=17,
data=self.operationJson.getRequestsData(row=17))
self.isContent(r=r, row=17)
self.excel.writeResult(17, 'pass')
def test_018(self):
u"新增销售价格"
data = self.operationJson.getRequestsData(row=18)
r = self.obj.post(row=18, data=data)
self.isContent(r=r, row=18)
self.excel.writeResult(18, 'pass')
def test_019(self):
u"新增销售订单"
data = self.operationJson.getRequestsData(row=19)
r = self.obj.post(row=19, data=data)
self.isContent(r=r, row=19)
self.excel.writeResult(19, 'pass')
def test_020(self):
u"新增销售出库单（直接新增商品）"
data = self.operationJson.getRequestsData(row=20)
r = self.obj.post(row=20, data=data)
self.isContent(r=r, row=20)
self.excel.writeResult(20, 'pass')
def test_021(self):
u"新增销售退货"
data = self.operationJson.getRequestsData(row=21)
r = self.obj.post(row=21, data=data)
self.isContent(r=r, row=21)
self.excel.writeResult(21, 'pass')
class LaGou(unittest.TestCase):
def setUp(self):
self.obj = Method()
self.p = IsContent()
self.execl = OperationExcel()
self.operationJson = OperationJson()
def statusCode(self, r):
# self.assertEqual(r.status_code, 200)
print(r.json()['code'])
self.assertEqual(r.json()['code'], '1001')
def isContent(self, r, row):
self.statusCode(r=r)
self.assertTrue(self.p.isContent(row=row, str2=r.text))
def test_laGou_001(self):
"sign为空"
r = self.obj.post(row=1, data=set_so_keyword(userPhone="18821768014"))
print("test_laGou_004 is:", r.text)
self.isContent(r=r, row=1)
self.execl.writeResult(1, 'pass')
# print (set_so_keyword(app_id=20180829170725138653,sign='8C7DF610ECB03AEA0DA6AA64F6D8C572'))p_id=20180829170725138653,sign='8C7DF610ECB03AEA0DA6AA64F6D8C572'))
class CcZct(unittest.TestCase):
def setUp(self):
self.obj=Method()
self.p=IsAssert()
self.excel=OperationExcel()
def statusCode(self,r):
"""正确的返回状态"""
self.assertEqual(r.status_code,200)
self.assertEqual(r.json()['statuscode'],1)
def errstausCode(self,r):
"""错误的返回状态嘛"""
self.assertEqual(r.status_code,200)
self.assertEqual(r.json()['statuscode'],-1)
def test_cczct_001(self):
'''获取csrf'''
r=self.obj.get(1)
csrf=r.headers['Set-Cookie'].split(";")[0]
# writeheadCsrf(filename='csrf',content=csrf)
self.excel.get_writexcel(filename='writehead.xls',row=1,col=0,content=csrf)
def test_cczct_002(self):
'''验证是否跳转到登录页面'''
r=self.obj.gethd(2)
self.assertTrue(self.p.isContent(row=2,str2=r.text))
def test_cczct_003(self):
'''输入电话号码点击发送验证码'''
writefile(filename='phonenumber', content=phonenumber())
data=get_user_account(3)
r = self.obj.post(row=3, data=data)
ci_session = r.headers['Set-Cookie'].split(";")[3].split(", ")[1]
self.excel.get_writexcel(filename='writehead.xls', row=1, col=1, content=ci_session)
phone = get_values(4, dict=data)
if r.json()['statuscode']==1:
r=self.obj.postci(row=4,data=phone)
view = r.json()['data']['view_code']
self.excel.get_writexcel(filename='writehead.xls', row=1, col=2, content=view)
self.statusCode(r=r)
def test_cczct_004(self):
'''输入错误的验证码'''
r=self.obj.postci(row=5,data=geterr_code(5))
self.errstausCode(r=r)
def test_cczct_005(self):
'''输入正确的验证码'''
r=self.obj.postci(row=6,data=get_code(6))
phone = r.json()['data']['phone']
self.excel.get_writexcel(filename='writehead.xls', row=1, col=3, content=phone)
self.statusCode(r=r)
def test_cczct_006(self):
'''注册后登陆'''
r=self.obj.postci(7,data=get_zhucdengl(row=7))
self.assertEqual(r.status_code,200)
class LaGou(unittest.TestCase):
def setUp(self):
self.obj = Method()
self.p = IsAssert()
self.excel = OperationExcel()
self.operationJson = OperationJson()
def tearDown(self):
pass
def statusCode(self, r):
self.assertEqual(r.status_code, 200)
# self.assertEqual(r.json()['code'], 0)
def isContent(self, r, row):
self.statusCode(r)
self.assertTrue(self.p.isContent(row=row, str2=r.text))
def test_laGou_001(self):
r = self.obj.post(row=1, data=self.operationJson.getRequestsData(1))
self.statusCode(r)
print(r.text)
self.isContent(r=r, row=1)
self.excel.writeResult(1, 'pass')
# self.assertTrue(self.p.isContent(1, str2=r.text))
def test_laGou_002(self):
"""测试关键字职位搜索"""
r = self.obj.post(row=1, data=setSo('性能测试工程师'))
# self.statusCode(r)
print(r.text)
# self.assertTrue(self.p.isContent(1, str2=r.text))
list1 = []
for i in range(1, 15):
positionId = r.json(
)['content']['positionResult']['result'][i]['positionId']
list1.append(positionId)
writePositionId(json.dumps(list1))
print(list1)
def test_laGou_003(self):
"""访问搜索到的每个职位的详细信息"""
for i in range(14):
print("item:%s" % (i))
r = self.obj.get(url=getUrl()[i])
self.assertTrue(self.p.isContent(row=2, str2=r.text))
class LoginTest(unittest.TestCase): def setUp(self): self.obj=Method() self.p=IsContent() self.execl=OperationExcel() self.operationJson=OperationJson() self.log=MyLog() def isContent(self,r,row): self.assertEqual(r.status_code, 200) self.assertTrue(self.p.isContent(row=row,str2=r.text)) def test_login_01(self): '''正确的账号密码登录''' r = self.obj.post(1,data=setSo()) self.isContent(r,1) self.execl.writeResult(1,'pass') #测试结果写到excel #cookies= requests.utils.dict_from_cookiejar(r.cookies) #把cookies转为字典类型 #提取sessionid并写入文件中 writeDatafile(fileName='sessionid.md',content=r.cookies['juooo_sessionid']) def test_login_02(self): '''正确的账号错误的密码登录''' r=self.obj.post(2,data=setSo(password=1230)) self.isContent(r,2) self.execl.writeResult(2, 'pass') def test_login_03(self): '''错误的账号正确密码登录''' r=self.obj.post(3,data=setSo(username='******')) self.isContent(r,3) self.execl.writeResult(3, 'pass') def test_login_04(self): '''错误的账号错误的密码登录''' r=self.obj.post(4,data=setSo(username='******',password=123)) self.isContent(r,4) self.execl.writeResult(4, 'pass') def test_login_05(self): '''账号密码为空登录''' r=self.obj.post(5,data=setSo(username='',password='')) self.isContent(r,5) self.execl.writeResult(5, 'pass')
class LaGou(unittest.TestCase):
# log = Log()
def setUp(self):
self.obj = Method()
self.p = IsContent()
self.execl = OperationExcel()
self.operationJson = OperationJson()
self.log = Log()
def tearDown(self):
pass
def statusCode(self, r):
self.assertEqual(r.status_code, 200)
print(r.status_code)
# print(r.json()['code'])
# self.assertEqual(r.json ()['code'], 200)
def isContent(self, r, row):
self.statusCode(r=r)
self.assertTrue(self.p.isContent(row=row, str2=r.text))
def test_post_001(self):
"""测试post接口-直接请求"""
print("test_laGou_001方法执行")
self.log.info("------测试post接口-直接请求：start!---------")
# print(check_user(user=jp_user,name=18821768014))
"sign为空"
r = self.obj.post(row=1,
data=self.operationJson.getRequestsData(row=1))
print("test_laGou_001 is:", r.text)
self.log.info("获取请求结果：%s" % r.text)
self.isContent(r=r, row=1)
self.execl.writeResult(1, 'pass')
def test_post_002(self):
print("test_laGou_002方法执行")
"测试post接口-参数化请求"
self.log.info("------测试post接口-参数化请求：start!---------")
r = self.obj.post(row=1, data=set_so_keyword1(phone='18821768014'))
print("test_laGou_002 is:", r.text)
self.isContent(r=r, row=1)
self.execl.writeResult(1, 'pass')
class LaGou(unittest.TestCase):
def setUp(self):
self.obj=Method()
self.p=IsAssert()
def statusCode(self,r):
self.assertEqual(r.json()['code'],0)
self.assertEqual(r.status_code,200)
def test_lagou_001(self):
'''拉钩：测试翻页'''
r=self.obj.post(1)
self.statusCode(r=r)
self.assertTrue(self.p.isContent(row=1,str2=r.text))
def test_lagou_002(self):
'''拉钩：测试性能自动化测试功能'''
r=self.obj.post(1,data=setso(kd='性能自动化测试'))
self.statusCode(r=r)
self.assertTrue(self.p.isContent(row=1,str2=r.text))
class login(unittest.TestCase):
def setUp(self):
self.Method = Method()
self.IsAssert = IsAssert()
'''登录接口是否正常'''
def test_login(self):
r = self.Method.post(1)
print(r.text)
class XSGL(unittest.TestCase):
def setUp(self):
self.obj = Method()
self.excel = OperationExcel()
self.operationJson = OperationJson()
def statusCode(self, r):
self.assertEqual(r.status_code, 200)
self.assertEqual(r.json()['code'], 0)
def isContent(self, r, row):
self.statusCode(r=r)
self.assertTrue(self.obj.isContent(row=row, str2=r.text))
def test_001(self):
"采购订单管理"
# 如果是传data,header="data_form" ，如果传json，header="json"
#data的内容，放在data目录下的requestData中
r = self.obj.post(row=1,
data=self.operationJson.getRequestsData(row=1),
header="data_form")
print(r.json())
self.isContent(r=r, row=1)
self.excel.writeResult(1, "pass")
def test_002(self):
"采购计划单管理"
r = self.obj.post(row=2,
data=self.operationJson.getRequestsData(row=2),
header="data_form")
print(r.json())
self.isContent(r=r, row=2)
self.excel.writeResult(2, "pass")
def test_003(self):
"采购出库管理"
r = self.obj.post(row=3,
data=self.operationJson.getRequestsData(row=3),
header="data_form")
print(r.json())
self.isContent(r=r, row=3)
self.excel.writeResult(3, "pass")
class LaGou(unittest.TestCase):
def setUp(self):
self.obj=Method()
self.p=IsContent()
self.execl=OperationExcel()
self.operationJson=OperationJson()
# def statusCode(self,r):
# # self.assertEqual(r.status_code, 200)
# self.assertEqual(r.json()['result_code'], 401)
def isContent(self,r,row):
# self.statusCode(r=r)
self.assertTrue(self.p.isContent(row=row,str2=r.text))
def test_laGou_001(self):
'''测试1'''
# r = self.obj.post(row=1,data=self.operationJson.getRequestsData(1))
r = self.obj.post (row=1, data=set_so_keyword (app_id='20180829170725138653', sign='8C7DF610ECB03AEA0DA6AA64F6D8C572'))
print ("test_laGou_001 is:", r.text)
self.assertEqual(r.json()['result_code'], 200)
self.isContent(r=r,row=1)
self.execl.writeResult(1,'pass')
def test_laGou_002(self):
'''错误测试'''
r = self.obj.post(row=2,data=self.operationJson.getRequestsData(2))
self.assertEqual(r.json()['result_code'], 403)
print ("test_laGou_001 is:", r.text)
self.isContent (r=r, row=2)
self.execl.writeResult (2, 'pass')
def test_laGou_004(self):
"sign为空"
r = self.obj.post(row=3,data=set_so_keyword(app_id=201808291707251386534444))
print ("test_laGou_002 is:", r.text)
self.assertEqual(r.json()['result_code'], 403)
self.isContent (r=r, row=3)
self.execl.writeResult (3,'pass')
class LaGou(unittest.TestCase):
def setUp(self):
self.obj=Method()
self.p=IsContent()
self.execl=OperationExcel()
self.operationJson=OperationJson()
def statusCode(self,r):
self.assertEqual(r.status_code, 200)
self.assertEqual(r.json()['result_code'], 200)
def isContent(self,r,row):
self.statusCode(r=r)
self.assertTrue(self.p.isContent(row=row,str2=r.text))
def test_laGou_001(self):
'''测试1'''
r = self.obj.post(row=1,data=self.operationJson.getRequestsData(1))
print ("test_laGou_001 is:", r.text)
self.isContent(r=r,row=1)
self.execl.writeResult(1,'pass')
class Test_Pytest():
log = Log()
def setup_class(self):
print('类前面,我爱你')
self.obj = Method()
self.p = IsContent()
self.execl = OperationExcel()
self.operationJson = OperationJson()
self.log = Log()
def teardown_class(self):
print('类之后')
def setup_method(self):
print('方法前面')
#
def teardown_method(self):
print('方法后')
# def isContent(self,r,row):
# # self.statusCode(r=r)
# assert self.p.isContent(row=row, str2=r.text)
@pytest.mark.usefixtures("del_title")
def test_addCategory_001(self):
"""添加商品分类校验"""
print("test_laGou_001方法执行")
self.log.info("-------添加商品分类：start!---------")
r = self.obj.post(row=1,
data=self.operationJson.getRequestsData(row=1))
print("添加商品分类 is:", r.text)
self.log.info("获取请求结果：%s" % r.text)
# self.isContent(r=r, row=1)
self.execl.writeResult(1, 'pass')
assert r.status_code == 200
assert str(r.json()["msg"]) == "成功"
print("test_addCategory_0000001 is:", r.json()["data"]["id"])
class LaGou(unittest.TestCase):
def setUp(self):
self.obj = Method()
self.p = IsContent()
self.execl = OperationExcel()
self.operationJson = OperationJson()
def statusCode(self, r):
# self.assertEqual(r.status_code, 200)
self.assertEqual(r.json()['result_code'], 1006)
def isContent(self, r, row):
self.statusCode(r=r)
self.assertTrue(self.p.isContent(row=row, str2=r.text))
def test_laGou_004(self):
"sign为空"
r = self.obj.post(row=3,
data=set_so_keyword(app_id="20180829170725138653"))
print("test_laGou_004 is:", r.text)
self.isContent(r=r, row=3)
self.execl.writeResult(3, 'pass')
class login(unittest.TestCase):
def setUp(self):
self.obj = Method()
self.p = IsContent()
self.excel = OperationExcel()
def test_admin_01(self):
"""后台登录接口-01,商城密码登录-02，
后台grant_type=password，前台grant_type=mall,
前台登录名要以 PWD@ 开头"""
r = self.obj.post(data=Login('coco',
111111,
grant_type='password',
row=1),
row=1)
data = r.json()
header = {
"Authorization": "Bearer " + data["access_token"],
"Content-Type": "application/json;charset=UTF-8"
}
tokenfile = writesupplierID(content=header,
data='data',
filename='token.json')
print(r.text)
class Admin(unittest.TestCase):
def setUp(self):
self.obj = Method()
self.p = IsContent()
self.excel = OperationExcel()
def statusCode(self, r):
"""断言协议状态码和JSON 文件的关键字"""
self.assertEqual(r.status_code, 200)
self.assertEqual(r.json()['code'], 1)
def isContent(self, r, row):
'''断言业务状态码和参数预期结果是否一致'''
self.statusCode(r=r)
self.assertTrue(self.p.isContent(row=row, str2=r.text))
def test_admin_001(self):
"""登录接口"""
r = self.obj.post(data=Login('PWD@15618824739',
111111,
grant_type='mall',
row=2),
row=2)
data = r.json()
with open("../data/token.json", "w") as f:
header = {
'Authorization': 'Bearer ' + data['access_token'],
'Content-Type': 'application/json;charset=UTF-8'
}
json.dump(header, f)
print(r.text)
def test_admin_002(self):
"""供应商信息搜索接口,并将id写入到supplierid文件中"""
r = self.obj.get(params=detail(1, 50, row=3), row=3)
print(r.text)
supplierid = ''
for i in range(0, 50):
supplierid = str(
r.json()['data']['records'][i]['id']) + ',' + supplierid
writesupplierID(supplierid)
self.assertTrue(self.p.isContent(str2=r.text, row=2))
self.isContent(r=r, row=2)
self.excel.writeResult(row=2, content='pass')
# @unittest.skip('pass')
def test_admin_003(self):
"""新增日志"""
r = self.obj.post(data=json.dumps(
Logs(content='自动化测试用例', logType='QR', overstockId=120, row=3)),
row=3)
print(r.text)
self.isContent(r=r, row=3)
self.excel.writeResult(row=3, content='pass')
# @unittest.skip('pass')
def test_admin_004(self):
'''删除供应商接口'''
# list=getSupplierid().split(",")
# supplierid=list[2]
r = self.obj.delete(url=geturl(row=4, id=soSupplierid()), row=4)
print('supplierid:', soSupplierid())
print(r.text)
self.assertTrue(self.p.isContent(row=4, str2=r.text))
self.excel.writeResult(row=4, content='pass')
# @unittest.skip('pass')
def test_admin_005(self):
'''添加供应商信息'''
r = self.obj.post(data=add_supplier(phone=15616624736, id=None, row=5),
row=5)
print(r.text)
def test_admin_006(self):
'''修改供应商信息'''
r = self.obj.put(add_supplier(phone=15614597456, id=47, row=6), row=6)
print(r.text)
def test_admin_007(self):
'''修改供应商临时周期'''
r = self.obj.put(updateTime(id=soSupplierid(),
cycleType='MONTH',
updateCycle=10,
row=7),
row=7)
print(r.text)
# @unittest.skip('pass')
def test_admin_008(self):
'''分配'''
r = self.obj.post(distributeSu(operatingId=14,
list=[40, 41, 43, 45],
row=8),
row=8)
print(r.text)
# @unittest.skip('pass')
def test_admin_009(self):
'''更新供应商的呆料'''
r = self.obj.put(url=geturl(id=62, row=9), row=9)
print(r.text)
# @unittest.skip('pass')
def test_admin_10(self):
'''类目列表'''
r = self.obj.get(row=10)
print(r.text)
# @unittest.skip('pass')
def test_admin_11(self):
'''类目保存'''
r = self.obj.post(category(name='test-005', parentId=5, sort=1,
row=11),
row=11)
print(r.text)
# @unittest.skip('pass')
def test_admin_12(self):
'''类目修改'''
r = self.obj.put(category(name='test-3',
parentId=0,
sort=1,
id=2,
status='Y',
row=11),
row=11)
print(r.text)
# @unittest.skip('pass')
def test_admin_13(self):
'''估价单列表'''
r = self.obj.get(params=detail(page=1, pageSize=10, row=13), row=13)
print(r.text)
evaluationid = ''
for i in range(0, 20):
evaluationid = str(
r.json()['data']['records'][i]['id']) + ',' + evaluationid
writesupplierID(evaluationid)
@unittest.skip('pass')
def test_admin_14(self):
pass
# '''新增估价单'''
#@unittest.skip('pass')
def test_admin_15(self):
'''估价单详情'''
r = self.obj.get(url=geturl(id=20, row=15), row=15)
print(r.text)
# @unittest.skip('pass')
def test_admin_16(self):
'''删除估价单'''
r = self.obj.delete(geturl(id=40, row=16), row=16)
print(r.text)
# @unittest.skip('pass')
def test_admin_17(self):
'''确认估价'''
r = self.obj.patch(url=geturl(id=57, row=17), row=17)
print(r.text)
# @unittest.skip('pass')
def test_admin_18(self):
'''重新爬取'''
r = self.obj.get(url=geturl(id=55, row=18), row=18)
print(r.text)
# @unittest.skip('pass')
def test_admin_19(self):
'''下载估价单'''
r = self.obj.get(url=geturl(id=55, row=19), row=19)
print(r.text)
@unittest.skip('pass')
def test_admin_20(self):
'''上传指导价'''
pass
# @unittest.skip('pass')
def test_admin_21(self):
'''生成呆料单'''
r = self.obj.post(data=evaOverstock(address='南京',
delivery="CN",
evaluateId=54,
factoryId=31,
invType='TL',
name='测试',
premium='2.3',
isRfq='Y',
row=21),
row=21)
print(r.text)
def test_admin_22(self):
'''修正估价价格'''
r = self.obj.patch(data=overStockpart(partsId=1370,
updatePrice=1.3,
row=22),
row=22)
print(r.text)
def test_admin_23(self):
'''删除选中物料'''
r = self.obj.delete(url=partList(id=39,
partsIds=[1318, 1319, 1321, 1320],
row=23),
row=23)
print(r.text)
def test_admin_24(self):
'''一键删除冷门料'''
r = self.obj.delete(url=geturl(id=55, row=24), row=24)
print(r.text)
@unittest.skip('pass')
def test_admin_25(self):
pass
# '''上传出价'''
# r = self.obj.delete(url=geturl(id=55, row=25), row=25)
# print(r.text)
def test_admin_26(self):
'''报价预览'''
r = self.obj.get(url=geturl(id=132, row=26), row=26)
print(r.text)
def test_admin_27(self):
'''下载出价表格'''
r = self.obj.get(url=geturl(id=132, row=27), row=27)
print(r.text)
def test_admin_28(self):
'''标记删除|取消标记'''
r = self.obj.patch(data=markId(id=11707, status='Y', row=28), row=28)
print(r.text)
def test_admin_29(self):
'''预览生成订单----D'''
r = self.obj.post(url=geturl(id=132, row=29),
data=overOrder(customerId=85,
entityId=[25524, 22525, 25526],
row=29),
row=29)
print(r.text)
def test_admin_30(self):
'''修改原表----D'''
r = self.obj.patch(url=geturl(id=205, row=30),
data=partprice(partId=11707, row=30),
row=30)
print(r.text)
def test_admin_31(self):
'''删除日志'''
r = self.obj.delete(url=geturl(id=424, row=31), row=31)
print(r.text)
def test_admin_32(self):
'''查看沟通日志'''
r = self.obj.get(url=geturl(id=205, row=32), row=32)
print(r.text)
def test_admin_33(self):
'''呆料单列表'''
r = self.obj.get(params=detail(page=1, pageSize=100, row=33), row=33)
print(r.text)
def test_admin_34(self):
'''新增呆料单----D'''
r = self.obj.post(data=evaOverstock(address="",
delivery="HK",
factoryId=15,
invType="ZB",
name="这是自动化上传的单子",
isRfq="N",
row=34),
row=34)
print(r.text)
def test_admin_35(self):
'''呆料单编辑详情'''
r = self.obj.get(url=geturl(id=205, row=35), row=35)
print(r.text)
def test_admin_36(self):
'''编辑呆料单----D'''
r = self.obj.post(url=geturl(id=205, row=36),
data=evaOverstock(address="苏州",
delivery="HK",
factoryId=92,
invType="TL",
name="这是自动化上传的单子",
id=205,
isRfq='N',
row=36),
row=36)
print(r.text)
def test_admin_37(self):
'''删除呆料单'''
r = self.obj.delete(url=geturl(id=205, row=37), row=37)
print(r.text)
def test_admin_38(self):
'''下载呆料单原表'''
r = self.obj.get(url=geturl(id=215, row=38), row=38)
print(r.text)
def test_admin_39(self):
'''工厂(供应商)下拉框'''
r = self.obj.get(params=factorySO(keyword="上海", row=39), row=39)
print(r.text)
def test_admin_40(self):
'''呆料单列表-更多'''
r = self.obj.get(params=detail(page=1, pageSize=100, row=40), row=40)
print(r.text)
def test_admin_41(self):
'''更新状态(上架、下架)'''
r = self.obj.patch(data=overStatus(id=215, status="N", row=41), row=41)
print(r.text)
def test_admin_42(self):
'''下载呆料模板'''
r = self.obj.get(params=None, url=None, row=42)
print(r.text)
def test_admin_43(self):
'''置顶、取消置顶'''
r = self.obj.patch(overStatus(id=214, status='Y', row=43), row=43)
print(r.text)
def test_admin_44(self):
'''品牌列表,有分页'''
r = self.obj.get(detail(page=1, pageSize=100, key='HPV', row=44),
row=44)
print(r.text)
def test_admin_45(self):
'''保存'''
r = self.obj.post(brand(linkIds=4063,
shortName=100,
name='HPV',
row=45),
row=45)
print(r.text)
def test_admin_46(self):
'''修改'''
r = self.obj.post(brand(linkIds=4063,
shortName=100,
name='CVB',
id=4063,
row=46),
row=46)
print(r.text)
def test_admin_47(self):
'''删除'''
r = self.obj.delete(geturl(id=4810, row=47), row=47)
print(r.text)
def test_admin_48(self):
'''品牌列表无分页'''
r = self.obj.get(row=48)
print(r.text)
def test_admin_49(self):
'''客户信息搜索'''
r = self.obj.get(params=detail(page=1, pageSize=100, key="上海", row=49),
row=49)
print(r.text)
def test_admin_50(self):
'''添加客户信息'''
r = self.obj.post(data=customerAdd(company="sisi-0023",
name="mumu-0023",
phone=15623145698,
row=50),
row=50)
print(r.text)
def test_admin_51(self):
'''修改客户信息'''
r = self.obj.put(data=customerAdd(company="sisi-0023",
name="tes-001",
phone=15618822221,
row=51,
id=83),
row=51)
print(r.text)
def test_admin_52(self):
'''客户详情'''
r = self.obj.get(url=geturl(id=83, row=52), row=52)
print(r.text)
def test_admin_53(self):
'''删除'''
r = self.obj.delete(url=geturl(id=83, row=53), row=53)
print(r.text)
def test_admin_54(self):
'''客户为新的标识取消'''
r = self.obj.delete(url=partList(id=128, partsIds=4, row=54), row=54)
print(r.text)
def test_admin_55(self):
'''分配'''
r = self.obj.post(data=distributeSu(operatingId=128,
list=[128, 117, 114, 113],
row=55),
row=55)
print(r.text)
def test_admin_56(self):
'''客户信息下拉框'''
r = self.obj.get(params=detail(page=1, pageSize=10, key='上海', row=56),
row=56)
print(r.text)
def test_admin_57(self):
'''客户信息下拉框'''
r = self.obj.get(row=57)
print(r.text)
def test_admin_58(self):
'''数据中心id号(58-71)'''
r = self.obj.get(orderover(cycleType='weeks',
endTime='2019-06-23 23:59:59',
startTime='2019-06-17 23:59:59',
type='customer',
row=58),
row=70)
print(r.text)
def test_admin_59(self):
'''数据字典列表有分页'''
r = self.obj.get(detail(page=1, pageSize=100, row=72), row=72)
print(r.text)
def test_admin_60(self):
'''添加字典'''
r = self.obj.post(data=dict(flagName="客户类型",
flagType="CUSTOMERTYPE",
kvList={
"LDS": "料单商",
"MUX": "目录型"
},
row=73),
row=73)
print(r.text)
def test_admin_61(self):
'''修改字典的键值'''
r = self.obj.put(data=dictValue(id=101, dictValue="cszy", row=74),
row=74)
print(r.text)
def test_admin_62(self):
'''删除'''
r = self.obj.delete(url=geturl(id=101, row=75), row=75)
print(r.text)
def test_admin_63(self):
'''数据字典列表无分页'''
r = self.obj.get(row=76)
print(r.text)
def test_admin_64(self):
'''数据字典类型列表'''
r = self.obj.get(row=77)
print(r.text)
# def test_admin_65(self):
# '''素材列表'''
# r = self.obj.get(params=detail(page=1,pageSize=100,row=72),row=78)
# print(r.text)
def test_admin_66(self):
'''活动、供应商、合作伙伴'''
r = self.obj.get(params=detail(page=1, pageSize=2, row=72), row=82)
print(r.text)
def test_admin_67(self):
'''添加banner、活动、供应商、合作伙伴---D'''
r = self.obj.post(data=friend(link="javascript:;",
materialFile="",
row=83),
row=83)
print(r.text)
def test_admin_68(self):
'''删除banner、活动、供应商、合作伙伴'''
r = self.obj.delete(url=geturl(id=66, row=84), row=84)
print(r.text)
# def test_admin_69(self):
# '''vadas动态'''
# r = self.obj.get(params=detail(pageSize=100,page=1,row=72), row=84)
# print(r.text)
# #
# def test_admin_70(self):
# ''''''
# r = self.obj.post(data=News(content='这是自动化测试',source='',row=86,title='这是自动化测试'), row=86)
# print(r.text)
def test_admin_89(self):
'''编辑banner、活动、供应商、合作伙伴'''
r = self.obj.post(data=friend(id=25,
link='/pool',
name='测试',
type="BA",
row=89),
row=89)
print(r.text)
def test_admin_90(self):
'''用户反馈列表'''
r = self.obj.get(params=detail(page=1, pageSize=100, row=72), row=90)
print(r.text)
def test_admin_91(self):
'''咨询反馈红点'''
r = self.obj.get(row=91)
print(r.text)
def test_admin_92(self):
'''取消咨询反馈红点'''
r = self.obj.post(data=feedbackType(type='SQGYS', row=92), row=92)
print(r.text)
def test_admin_93(self):
'''用户呆料列表'''
r = self.obj.get(params=detail(page=1, pageSize=100, row=72), row=93)
print(r.text)
def test_admin_94(self):
'''更新状态'''
r = self.obj.post(url=geturl(id=1, row=72), row=94)
print(r.text)
def test_admin_95(self):
'''申请供应商列表'''
r = self.obj.get(params=detail(page=1, pageSize=100, row=72), row=95)
print(r.text)
def test_admin_96(self):
'''更新状态'''
r = self.obj.post(url=geturl(id=53, row=96), data=None, row=96)
print(r.text)
def mcc(self):
'''MCC物料列表'''
r = self.obj.get(params=detail(page=1, pageSize=100, row=72), row=110)
print(r.text)
