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")
