接口自动化第二阶段代码

目标：

一：完成手机号码的自加，new_do_excl.py

二：集成单元测试,ddt，http请求、写回到excl,并且生成测试报告

三、增加配置文件，实现测试用例可配置

new_do_excl.py （手机号码自加）

from openpyxl import load_workbook


class DoExcl:
    def __init__(self, file_name):
        self.file_name = file_name

    def get_data(self, button, case_id_list):
        file = load_workbook(self.file_name)
        sheet = file["testcase"]

        test_data = []
        new_tel = file["tel"].cell(1, 1).value # 整数、浮点数、从Excle里面去出是整数、浮点数，字符串，列表，字典，从excl里面取出是字符串

        for i in range(2, sheet.max_row+1):  # +1取左不取右,max_clumn

            sub_data = {}
            sub_data["id"] = sheet.cell(i, 1).value
            sub_data["HttpMethod"] = sheet.cell(i, 2).value
            sub_data["module"] = sheet.cell(i, 3).value
            sub_data["description"] = sheet.cell(i, 4).value
            sub_data["url"] = sheet.cell(i, 5).value
            if sheet.cell(i, 6).value.find('${tel}') != -1:
                sub_data['param'] = sheet.cell(i, 6).value.replace('${tel}', str(new_tel))
            else:
                sub_data["param"] = sheet.cell(i, 6).value

            sub_data["ExpectedResult"] = sheet.cell(i, 7).value
            test_data.append(sub_data)
            file["tel"].cell(1, 1).value = new_tel+1
            file.save(self.file_name)
        if button == 'on':
            finally_data = test_data
        else:
            finally_data = []
            for item in test_data:
                if item['id'] in eval(case_id_list):
                    finally_data.append(item)

        # print(test_data)
        return finally_data

    def write_back(self, row, ActualResult, TestResult):
        wb = load_workbook(self.file_name)
        sheet = wb["testcase"]
        sheet.cell(row, 8).value = ActualResult
        sheet.cell(row, 9).value = TestResult
        wb.save(self.file_name)


# if __name__ == '__main__':
#     test_data = DoExcl('api.xlsx').get_data()
#     print("测试数据是:{}".format(test_data))
test_api.py（集成单元测试，ddt装饰,读取配置文件实现用例执行可以配置，批量写回结果）

import unittest

from ddt import ddt, data
from class_2019_API_unnitest.new_do_excle import DoExcl
from class_2019_API_unnitest.http_request import HttpMethod
from class_2019_API_unnitest.read_config import ReadConfig
button = ReadConfig().read_config("case.config", "CONFIG", "button")
case_id_list = ReadConfig().read_config("case.config", "CONFIG", "case_id_list")
test_data = DoExcl("api.xlsx").get_data(button, case_id_list)

# 读取配置控制执行哪条测试用例，实际上是对测试数据的读取进行配置

@ddt
class TestApi(unittest.TestCase):

    def setUp(self):

        self.t = DoExcl("api.xlsx")
        print("开始测试")

    @data(*test_data)
    def test_api(self, data_item):
        print("正在执行第{0}条测试用例{1}".format(data_item['id'],data_item['description']))
        print("测试数据是{0}".format(data_item['param']))
        url = 'http://47.107.168.87:8080/futureloan/mvc/api/member/register'
        res = HttpMethod().http_request(url, eval(data_item['param']), data_item['HttpMethod'])  # eval()函数将字符串转换成字典

        try:
            self.assertEqual(str(data_item["ExpectedResult"]),res['code'])
            TestResult = 'PASS'
        except AssertionError as e:
            TestResult = 'failed'
            raise e
        finally:
            self.t.write_back(data_item["id"]+1, res['code'], TestResult) # 将结果批量写回到excl

    def tearDown(self):
        print("测试结束了")

http_request.py

import requests

class HttpMethod:

    def http_request(self,url,param,http_method):
        if http_method.upper() =='POST':
            try:
                res = requests.post(url, param)
            except Exception as e:
                print("post注册请求出错，错误是{}".format(e))
        else:
            try:
                res = requests.get(url, param)
            except Exception as e:
                print("post注册请求出错，错误是{}".format(e))

        print("http请求的结果是{}".format(res.json()))
        return res.json()  # 增加返回值，在请求正常的情况下有返回值

read_config.py

from configparser import ConfigParser


class ReadConfig:

    def read_config(self, filename, section, option):

        cf = ConfigParser()
        cf.read(filename)
        value = cf.get(section, option)
        return value


if __name__ == '__main__':

    ReadConfig().read_config("case.config", "CONFIG", "button")

case.config

[CONFIG]
button=on
case_id_list=[1,3]

run.py(单元测试执行测试用例）

import unittest
from class_2019_API_unnitest.common import test_api
import HTMLTestRunnerNew

suite = unittest.TestSuite()#测试容器
loader = unittest.TestLoader()# 执行测试用例
suite.addTest(loader.loadTestsFromModule(test_api)) #按照模块执行
with open ('test_result.html', "wb+") as file:  # 测试报告
    runner = HTMLTestRunnerNew.HTMLTestRunner(file, title='测试报告', description='软件测试', tester='林越')
    runner.run(suite)