python接口自动化1

组织架构：

　　包括配置文件，反射、文件路径、Excel操作、测试报告生成

                        

case.config

[MODE]
file_name=case_data.xlsx
mode={"register":'all',"login":'all',"recharge":'all'}

tools文件夹里的东西

do_config.py

# -*- conding:utr-8 -*-
#@Time  :2018/11/17 11:21
#@Author:GYP测试
#@File  :do_config.py

import configparser
class ReadConfig:
    def read_config(self,file_name,section,option):
        cf=configparser.ConfigParser()
        cf.read(file_name,encoding='utf-8')
        return cf.get(section,option)
if __name__ == '__main__':
    res=ReadConfig().read_config('case.config','MODE','file_name')
    print(res)

do_excel.py

# -*- conding:utr-8 -*-
#@Time  :2018/11/17 14:05
#@Author:GYP测试
#@File  :do_excel.py
from openpyxl import load_workbook
from tools.do_config import ReadConfig
from tools.project_path import *

class Do_Excle:
    def __init__(self):
        self.file_name = test_data_path
        self.sheet_names = eval(ReadConfig().read_config(case_config_path, 'MODE', 'mode'))
    def get_header(self):
        wb = load_workbook(self.file_name)
        for sheet_name in self.sheet_names:
            sheet=wb[sheet_name]
            header=[]
            for i in range(1,sheet.max_column+1):
                header.append(sheet.cell(1,i).value)
        return header
    def Read_Excle(self):
        wb = load_workbook(self.file_name)
        test_data = []
        for sheet_name in self.sheet_names:
            sheet = wb[sheet_name]
            header = self.get_header()
            if self.sheet_names[sheet_name]=='all':
                for i in range(2,sheet.max_row+1):
                    sub_data={}
                    for j in range(1,sheet.max_column+1):
                        sub_data[header[j-1]]=sheet.cell(i,j).value
                    test_data.append(sub_data)
            else:
                for case_id in self.sheet_names[sheet_name]:
                    sub_data={}
                    for j in range(1,sheet.max_column+1):
                        sub_data[header[j-1]]=sheet.cell(case_id+1,j).value
                    test_data.append(sub_data)
        return test_data
    @staticmethod
    def write_excel(fiel_name,sheet_name,i,ActaulResult):
        wb=load_workbook(fiel_name)
        sheet=wb[sheet_name]
        sheet.cell(i,8).value=ActaulResult
        wb.save(fiel_name)
if __name__ == '__main__':
    res=Do_Excle().Read_Excle()
    print(res)
    print(len(res))

  get_data.py

# -*- conding:utf-8 -*-
#@Time  :2018/11/19 11:37
#@Author:GYP测试
#@File  :get_data.py

class Get_Data:

    cookie=None

http_requests.py

# -*- conding:utr-8 -*-
#@Time  :2018/11/16 21:50
#@Author:GYP测试
#@File  :http_requests.py

import requests
class Http_Request:
    def request(self,method,url,data,cookie=None):
        try:
            if method == 'post':
                res=requests.post(url,data,cookies=cookie)
            else:
                res=requests.get(url,data,cookies=cookie)
        except Exception as e:
            print("非法请求，请检查{0}".format(e))
            raise e
        return res

http_test.py

# -*- conding:utr-8 -*-
#@Time  :2018/11/18 15:00
#@Author:GYP测试
#@File  :http_test.py


import unittest  #单元测试框架

from tools.do_excel import Do_Excle   #数据读写
from tools.project_path import *   #文件路径
from ddt import ddt,data  #数据处理框架
from tools.get_data import Get_Data  #反射
from tools.http_requests import Http_Request

test_data=Do_Excle().Read_Excle()  #读取数据
@ddt
class TestHttp(unittest.TestCase):
    @data(*test_data)
    def test_api(self,item):
        res=Http_Request().request(item['method'],item['url'],eval(item['data']),getattr(Get_Data,'cookie'))
        if res.cookies:  #利用反射获取cookie的值
            setattr(Get_Data,'cookie',res.cookies)
        try:
            self.assertEqual(str(item['ExpectedResult']),res.json()['code'])
            ActaulResult='Pass'
        except AssertionError as e:
            print('执行用例失败，请检查%s' %e)
            ActaulResult = 'Faile'
            print("获取到的结果是：{0}".format(res.json()))
        finally:
            # print(item['case_id'])
            Do_Excle.write_excel(test_data_path,item['module'],item['case_id']+1,ActaulResult)

project_path.py

# -*- conding:utr-8 -*-
#@Time  :2018/11/17 13:46
#@Author:GYP测试
#@File  :project_path.py

import os
from tools.do_config import ReadConfig

# class Get_Path:
#     def get_path(self):
path=os.path.split(os.path.split(os.path.realpath(__file__))[0])[0]


case_config_path=os.path.join(path,'conf','case.config')

data_file_name=ReadConfig().read_config(case_config_path,'MODE','file_name')
test_data_path=os.path.join(path,'test_data',data_file_name)
html_repot_path=os.path.join(path,'test_result','html_report','test_api.html')
print(case_config_path)
print(html_repot_path)

run.py

# -*- conding:utr-8 -*-
#@Time  :2018/11/16 21:36
#@Author:GYP测试
#@File  :run.py

import unittest
import HTMLTestRunner
from tools.project_path import *

from tools.http_test import TestHttp
suite=unittest.TestSuite()


loader=unittest.TestLoader()

suite.addTest(loader.loadTestsFromTestCase(TestHttp))

with open(html_repot_path,'wb')  as file:
    runner=HTMLTestRunner.HTMLTestRunner(
        stream=file,
        title='这个是接口自动化的测试报告',
        description='我来测试哦！',
        tester='GYP')
    runner.run(suite)