def test_11(self): # 代理商excel导出 Log().info("代理商excel导出") F = Funciton() request_info = F.get_request_info(46) actual_result = F.public_method("46").status_code # int expected_results = int(request_info[6]) # int F.result_assertion(expected_results, actual_result, "46") try: self.assertEqual(expected_results, actual_result) except Exception as msg: Log().info("Exception:" + F.public_method("46").json()['msg']) raise msg
def test_05(self): # 查询客户下可见商品详情(附带租户的课数) Log().info("查询客户下可见商品详情(附带租户的课数)") F = Funciton() request_info = F.get_request_info(12) actual_result = F.public_method("12").status_code # int expected_results = int(request_info[6]) # int F.result_assertion(expected_results, actual_result, "12") try: self.assertEqual(expected_results, actual_result) except Exception as msg: Log().info("Exception:" + F.public_method("12").json()['msg']) raise msg
def test_04(self): # 查看客户可见商品列表 Log().info("查看班课设置列表") F = Funciton() request_info = F.get_request_info(11) actual_result = F.public_method("11").status_code # int expected_results = int(request_info[6]) # int F.result_assertion(expected_results, actual_result, "11") try: self.assertEqual(expected_results, actual_result) except Exception as msg: Log().info("Exception:" + F.public_method("11").json()['msg']) raise msg
def test_07(self): # 客户购买课时 Log().info("客户购买课时") F = Funciton() request_info = F.get_request_info(14) actual_result = F.public_method("14").status_code # int expected_results = int(request_info[6]) # int F.result_assertion(expected_results, actual_result, "14") try: self.assertEqual(expected_results, actual_result) except Exception as msg: Log().info("Exception:" + F.public_method("14").json()['msg']) raise msg
def test_05(self): # 累计注册学校数 Log().info("新增激活用户数") Funciton().excel_value("40") F = Funciton() request_info = F.get_request_info(40) actual_result = F.public_method("40").status_code # int expected_results = int(request_info[6]) # int F.result_assertion(expected_results, actual_result, "40") try: self.assertEqual(expected_results, actual_result) except Exception as msg: Log().info("Exception:" + F.public_method("40").json()['msg']) raise msg
def test_02(self): # 添加新学生 Log().info("添加新学生") n = "21" json_data = [{ "userName": "******" + Funciton().randomnu + "", "realName": "zhengzhouxuesheng" + Funciton().randomnu + "", "nickName": "xuesheng" + Funciton().randomnu + "", "password": "******" }] current_time = time.strftime("%Y/%m/%d-%H:%M:%S") try: # 顺序依次:method、url、header、param(data) r = send_request( readExcel(Funciton().datainfo, self.sheetpage, "D" + n), Funciton().urltitle + readExcel(Funciton().datainfo, self.sheetpage, "E" + n), Funciton().header, json.dumps(json_data)) actual_result = r.status_code expected_results = int( readExcel(Funciton().datainfo, self.sheetpage, "G" + n)) Funciton().result_assertion(expected_results, actual_result, n) except: traceback.print_exc() finally: writeExcel(Funciton().datainfo, self.sheetpage, "J" + n, current_time)
def test_07(self): # 新增代理商管理员 Log().info("新增代理商管理员") F = Funciton() request_info = F.get_request_info(27) dict = json.loads(request_info[5]) dict["account"] = "yjgl" + self.randomnu + "-" + self.randomnu + "" str_dict = json.dumps(dict) # 这里转换不能直接用 str(dict),会使字典格式属性和值单双引号不一致 writeExcel("test_agent.xlsx", "F27", str_dict) request_info = F.get_request_info(27) actual_result = F.public_method("27").status_code # int expected_results = int(request_info[6]) # int F.result_assertion(expected_results, actual_result, "27") try: self.assertEqual(expected_results, actual_result) except Exception as msg: Log().info("Exception:" + F.public_method("27").json()['msg']) raise msg
def send_mail(mail_file): # 发送邮件 # 你的邮件内容 mail_content = { 'subject': '自动化测试报告!', # 邮件标题 'content_text': '测试报告结果查看!', # 邮件正文 'attachments': mail_file, # 附件:最好使用绝对路径 } # 使用你的邮件账户名和密码登录服务器 server = zmail.server('*****@*****.**', 'dy061951') # 发送邮件 server.send_mail('*****@*****.**', mail_content) # 给多个邮箱发送 # server.send_mail(['*****@*****.**','*****@*****.**'], mail_content) Log().info("邮件发送成功")
def test_01(self): # 新增客户 Log().info("新增客户") n="8" json_data={"name":"吉一客户"+Funciton().randomnu,"nickName":"吉一客户","realName":"吉林一级客户","code":"j"+Funciton().randomnu+"","contact":"吉林一级客户","email":"*****@*****.**", "password":"******","confirmPwd":"111111","mobile":"13323132313","province":"22","city":"2201","district":"220102","address":"南关", "account":"jilin1j-"+Funciton().randomnu+"-"+Funciton().randomnu+"","schoolType": "7"} current_time = time.strftime("%Y/%m/%d-%H:%M:%S") try: # 顺序依次:method、url、header、param(data) r = send_request(readExcel(Funciton().datainfo,self.sheetpage, "D" + n), Funciton().urltitle + readExcel(Funciton().datainfo,self.sheetpage, "E" + n), Funciton().header, json.dumps(json_data)) actual_result = r.status_code expected_results = int(readExcel(Funciton().datainfo,self.sheetpage, "G" + n)) Funciton().result_assertion(expected_results,actual_result, n) except: traceback.print_exc() finally: writeExcel(Funciton().datainfo,self.sheetpage, "J" + n, current_time)
def public_method(self, n): # 测试用例整体调用方法,n:rownum、current_time:获取当前时间 current_time = time.strftime("%Y/%m/%d-%H:%M:%S") header = Token().uat_agent_header url = Body().uat_url + readExcel(self.datainfo, "E" + n) try: # 顺序依次:method、url、header、param(data) self.r = send_request(readExcel(self.datainfo, "D" + n), url, header, readExcel(self.datainfo, "F" + n)) actual_result = self.r.status_code expected_results = int(readExcel(self.datainfo, "G" + n)) self.result_assertion(expected_results, actual_result, n) self.assertEqual(int(readExcel(self.datainfo, "G" + n)), actual_result) except: traceback.print_exc() Log().info("Exception:" + self.r.json()['msg']) finally: writeExcel(self.datainfo, "J" + n, current_time)
def test_03(self): # 新增客户管理员 Log().info("新增客户管理员") n = "23" json_data = { "email": "", "password": "******", "confirmPwd": "111111", "mobile": "13323132313", "userName": "******" + Funciton().randomnu + "-" + Funciton().randomnu + "", "tenantId": 268, "realName": "吉一级管员" + Funciton().randomnu, "nickName": "吉管" + Funciton().randomnu } current_time = time.strftime("%Y/%m/%d-%H:%M:%S") try: # 顺序依次:method、url、header、param(data) r = send_request( readExcel(Funciton().datainfo, self.sheetpage, "D" + n), Funciton().urltitle + readExcel(Funciton().datainfo, self.sheetpage, "E" + n), Funciton().header, json.dumps(json_data)) actual_result = r.status_code expected_results = int( readExcel(Funciton().datainfo, self.sheetpage, "G" + n)) Funciton().result_assertion(expected_results, actual_result, n) except: traceback.print_exc() finally: writeExcel(Funciton().datainfo, self.sheetpage, "J" + n, current_time)
def test_01(self): # 学情分析-上课进度 Log().info("学情分析-上课进度") Funciton().public_method("14")
def test_02(self): # 上课进度导出报表 Log().info("上课进度导出报表") Funciton().public_method("15")
def test_05(self): # 重置密码 Log().info("重置密码") Funciton().public_method("24")
def test_07(self): # 查看课时详情(课堂测验解析) Log().info("查看课时详情(课堂测验解析)") Funciton().public_method("12")
def test_10(self): # 查看消息通知列表 Log().info("查看消息通知列表") Funciton().public_method("30")
def test_03(self): # 添加学生-查看从机构拉取列表 Log().info("添加学生-查看从机构拉取列表") Funciton().public_method("22")
def test_06(self): # 查询代理商管理员列表 Log().info("查询代理商管理员列表") Funciton().public_method("26")
def test_05(self): # 学情分析-掌握知识点 Log().info("学情分析-掌握知识点") Funciton().public_method("18")
def test_04(self): # 修改客户管理员 Log().info("修改客户管理员") Funciton().public_method("24")
def test_05(self): # 客户重置密码 Log().info("客户重置密码") Funciton().public_method("25")
def test_08(self): # 修改代理商管理员 Log().info("修改代理商管理员") Funciton().public_method("28")
def test_02(self): # 新增客户管理员查询已有客户 Log().info("新增客户管理员查询已有客户") Funciton().public_method("22")
def test_01(self): # 查看客户账号列表 Log().info("查看客户账号列表") Funciton().public_method("21")
def test_03(self): # 学情分析-测验结果 Log().info("学情分析-测验结果") Funciton().public_method("16")
def test_01(self): # 查询学生信息列表 Log().info("查询学生信息列表") Funciton().public_method("20")
def test_04(self): # 测验结果导出报表 Log().info("测验结果导出报表") Funciton().public_method("17")
def test_08(self): # 查看课时详情(学生任务进度) Log().info("查看课时详情(学生任务进度)") Funciton().public_method("13")
def test_06(self): # 掌握知识点导出报表 Log().info("掌握知识点导出报表") Funciton().public_method("19")
def test_09(self): # 代理商重置密码 Log().info("代理商重置密码") Funciton().public_method("29")