#!/usr/bin/env python
# -*- coding: utf-8 -*-
"""
@File : Test_08_解除用户绑定.py
@Time : 2020/06/18
@Author : xxx
@Email : xxx
"""
import json
import subprocess
import pytest
import allure
import requests
import pandas as pd
def GetExcelValue(filepath, sheet_name):
"""
keep_default_na : bool, default True
如果指定na_values参数，并且keep_default_na=False，那么默认的NaN将被覆盖，否则添加。
:param filepath: Excel地址
:param sheet_name: sheet名称
:return: 返回表格内容
"""
data = pd.read_excel(filepath, sheet_name=sheet_name, keep_default_na=False)
return data
@allure.step("获取userid值: 第{0}行, 第{1}列")
def GetUserId(x, y):
data = GetExcelValue("D:/QCC_NewApiAutomation/DataSource/RemoveWechatNotice.xlsx", "RemoveWechatNotice")
userId = data.iloc[x, y]
allure.attach(userId, "userId值", allure.attachment_type.TEXT)
return userId
@allure.step("接口请求开始")
def check_result(x, y):
baseurl = "http://xxxxxx/Risk/removeWechatNotice"
# 添加URL信息
allure.attach(baseurl, "URL地址", allure.attachment_type.TEXT)
# 传值列表
params = {"userId": GetUserId(x, y)}
new_params = json.dumps(params, ensure_ascii=False)
# 添加参数信息
allure.attach(new_params, "参数列表", allure.attachment_type.JSON)
# 将url和params进行http传递，发送请求
# post(url, data=None, json=None, **kwargs)
res = requests.post(url=baseurl, data=params)
# JSON文件转为字典格式
resp_data = json.loads(res.text)
return resp_data
@allure.feature("解除用户绑定")
class TestRemoveWechatNotice:
@allure.tag('userId')
@allure.title('解除用户绑定: userid为空')
@allure.story('userid为空')
@allure.severity(allure.severity_level.CRITICAL)
def test_01_RemoveWechatNotice(self, enter, start):
"""
用例描述：userid为空
:return:
"""
with allure.step("查看接口返回值"):
# 获取接口返回值，字典格式展示
data = check_result(0, 2)
# 字典转为JSON格式，作为附件内容加入报告中
new_data_value = json.dumps(data, ensure_ascii=False)
allure.attach(new_data_value, "返回值内容", allure.attachment_type.JSON)
with allure.step("查看status状态值"):
# json格式数据转换为字典,获取返回值中的status值
status_value = json.loads(new_data_value, strict=False)["status"]
data = {"status": status_value}
new_data = json.dumps(data, ensure_ascii=False)
allure.attach("500", "status期望值", allure.attachment_type.TEXT)
allure.attach(new_data, "status实际值", allure.attachment_type.JSON)
with allure.step("查看message信息值"):
# json格式数据转换为字典,获取返回值中的message值
message_value = json.loads(new_data_value)["message"]
# 字典转为JSON格式，作为附件内容加入报告中
# json.dumps()：将汉字转为unicode编码
# json默认会进行字符转换,添加ensure_ascii=False,让汉字不转为unicode编码
data = json.dumps(message_value, ensure_ascii=False)
# 添加日志信息
allure.attach("userId是必填项", "message期望值", allure.attachment_type.TEXT)
allure.attach(data, "message实际值", allure.attachment_type.JSON)
# 判断状态是否一致
with allure.step("判断状态是否一致"):
assert status_value == 500
# 判断必填项的提示信息是否存在
with allure.step("判断是否有必填项的提示信息"):
assert message_value == "userId是必填项"
@allure.tag('userId')
@allure.title('解除用户绑定: userid传值')
@allure.story('userid传值')
@allure.severity(allure.severity_level.CRITICAL)
def test_02_RemoveWechatNotice(self, enter, start):
"""
用例描述：userid传值
:return:
"""
with allure.step("查看接口返回值"):
# 获取接口返回值，字典格式展示
data = check_result(1, 2)
# 字典转为JSON格式，作为附件内容加入报告中
new_data_value = json.dumps(data, ensure_ascii=False)
allure.attach(new_data_value, "返回值内容", allure.attachment_type.JSON)
with allure.step("查看status状态值"):
# json格式数据转换为字典,获取返回值中的status值
status_value = json.loads(new_data_value, strict=False)["Status"]
data = {"status": status_value}
new_data = json.dumps(data, ensure_ascii=False)
allure.attach("200", "status期望值", allure.attachment_type.TEXT)
allure.attach(new_data, "status实际值", allure.attachment_type.JSON)
# 判断状态是否一致
with allure.step("判断状态是否一致"):
assert status_value == 200
if __name__ == '__main__':
pytest.main(['--alluredir=D:/QCC_NewApiAutomation/Result/allure_results'])
subprocess.check_output("allure serve allure_report")
