1101_数据处理优化

用例与用例直接的依赖关系（耦合关系）

方法一:

　　在 初始化中 处理共用的数据  （充值cookie的处理方法）

import unittes
from API_AUTO.http_requests import HttpRequest
class TestLogin(unittest.TestCase):
    def setUp(self):
        self.url_login = 'http://119.23.241.154:8080/futureloan/mvc/api/member/login'
        self.login_data = {"mobilephone": "18688773467", "pwd": "123456"}
        self.url_recharge = 'http://119.23.241.154:8080/futureloan/mvc/api/member/recharge'
        self.cookies=HttpRequest().http_requests(self.url_login,self.login_data,'post').cookies
    #正常登录
    def testLogin_Correct(self):
        login_data = {"mobilephone": "18688773467", "pwd": "123456"}
        res = HttpRequest().http_requests(self.url_login,login_data,'post')
        try:
            self.assertIn('10001',res.json()['code'])
        except AssertionError as e:
            print('登录出错了%s' %e)
        return res
    def testRecharge_Correct(self):
        recharge_data = {"mobilephone": "18688773467", "amount": "1000"}
        res_recharge = HttpRequest().http_requests(self.url_recharge,recharge_data,'get',self.cookies)
        try:
            self.assertIn('10001',res_recharge.json()['code'])
        except AssertionError as e:
            print('不正常充值%s' %e)

if __name__ == '__main__':
    unittest.main()

方法二:

　　使用 全局变量 处理共用的数据  （充值cookie的处理方法）

import unittest
from API_AUTO.http_requests import HttpRequest
global CCOOKIE
class TestLogin(unittest.TestCase):
    def setUp(self):
        self.url_login = 'http://119.23.241.154:8080/futureloan/mvc/api/member/login'
        self.url_recharge = 'http://119.23.241.154:8080/futureloan/mvc/api/member/recharge'
    #正常登录
    def testLogin_Correct(self):
        global COOKIE #申明全局变量
        login_data = {"mobilephone": "18688773467", "pwd": "123456"}
        res = HttpRequest().http_requests(self.url_login,login_data,'post')
        if res.cookies: #如果cookie有的话，那么就更新COOKIE
            COOKIE=res.cookies
        try:
            self.assertIn('10001',res.json()['code'])
        except AssertionError as e:
            print('登录出错了%s' %e)
            raise e
    #正常充值
    def testRecharge_Correct(self):
        global COOKIE
        recharge_data = {"mobilephone": "18688773467", "amount": "1000"}
        res_recharge = HttpRequest().http_requests(self.url_recharge,recharge_data,'get',COOKIE)
        try:
            self.assertIn('10001',res_recharge.json()['code'])
        except AssertionError as e:
            print('不正常充值%s' %e)
            raise e
if __name__ == '__main__':
    unittest.main()

方法三:

　　1）放射方法介绍：

class GetData:
    Cookie='小郭'
setattr(GetData,'Cookie','小黄') #可以直接把类里面的属性值做修改
hasattr(GetData,'Cookie') #判断是否有值
getattr(GetData,'Cookie') #获取它的值

print(GetData.Cookie)
print(hasattr(GetData,'Cookie'))
print(getattr(GetData,'Cookie'))

delattr(GetData,'Cookie') #删除这个属性
print(hasattr(GetData,'Cookie'))

   结果：

小黄
True
小黄
False

　　

　　2）使用 反射 处理共用的数据  （充值cookie的处理方法）

import unittest
from API_AUTO.http_requests import HttpRequest
from class_1101.read_me import GetData
class TestLogin(unittest.TestCase):
    def setUp(self):
        self.url_login = 'http://119.23.241.154:8080/futureloan/mvc/api/member/login'
        self.url_recharge = 'http://119.23.241.154:8080/futureloan/mvc/api/member/recharge'
    #正常登录
    def testLogin_Correct(self):
        login_data = {"mobilephone": "18688773467", "pwd": "123456"}
        res = HttpRequest().http_requests(self.url_login,login_data,'post')
        if res.cookies: #如果cookie有的话，那么就更新COOKIE
            setattr(GetData,'Cookie',res.cookies)
        try:
            self.assertIn('10001',res.json()['code'])
        except AssertionError as e:
            print('登录出错了%s' %e)
            raise e
        return res
    #正常充值
    def testRecharge_Correct(self):
        global COOKIE
        recharge_data = {"mobilephone": "18688773467", "amount": "1000"}
        res_recharge = HttpRequest().http_requests(self.url_recharge,recharge_data,'get',getattr(GetData,'Cookie'))
        try:
            self.assertIn('10001',res_recharge.json()['code'])
        except AssertionError as e:
            print('不正常充值%s' %e)
           raise e
if __name__ == '__main__':
    unittest.main()

 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

最后的结果：

class_011.py

import unittest
from API_AUTO.http_requests import HttpRequest
from class_1101.read_me import GetData

class TestLogin(unittest.TestCase):
    def setUp(self):
        pass
    def __init__(self,methodName,url,data,method,expected):
        super(TestLogin,self).__init__(methodName) #继承了父类的方法
        self.url= url
        self.data= data
        self.method=method
        self.expected=expected
    #正常登录
    def test_api(self):
        res = HttpRequest().http_requests(self.url,self.data,self.method,getattr(GetData,'Cookie'))
        if res.cookies: #如果cookie有的话，那么就更新COOKIE
            setattr(GetData,'Cookie',res.cookies)
        try:
            self.assertIn(self.expected,res.json()['code'])
        except AssertionError as e:
            print('登录出错了%s' %e)
            raise e
        return res
if __name__ == '__main__':
    unittest.main()

class_022.py

import unittest
import HTMLTestRunner
from unit1030.class_011 import TestLogin #具体到类名
test_data=[{'url':'http://119.23.241.154:8080/futureloan/mvc/api/member/login',
           'data':{"mobilephone": "18688773467", "pwd": "123456"},'expected':'10001','method':'post'},
           {'url':'http://119.23.241.154:8080/futureloan/mvc/api/member/recharge',
            'data':{"mobilephone": "18688773467", "amount": "1000"},'expected':'10001','method':'get'
}]
#存储
suite = unittest.TestSuite()
#加载
loader = unittest.TestLoader()
for item in test_data:
    suite.addTest(TestLogin('test_api',item['url'],item['data'],item['method'],item['expected']))

#输出
with open('test_report.html','wb') as file:
    runner = HTMLTestRunner.HTMLTestRunner(stream=file,verbosity=2,title='框架学习练习',tester='GYP测试')
    runner.run(suite)

read_me.py

class GetData:
    Cookie=None #存储cookie  初始值None
if __name__ == '__main__':

 3、操作Excel了

from openpyxl import load_workbook
#手动创建Excel然后，打开Excel
wb=load_workbook('test.xlsx')
sheet=wb['python']#传表单名 返回一个表单对象
#定位单元格 行列值
res=sheet.cell(1,1).value
print('最大行%s'%sheet.max_row)
print('最大列%s'%sheet.max_column)
print(res)
#PS:excle中的数据出了int，就是str

 使用Excel数据驱动

http_requests.py

import requests
class HttpRequest:
    def http_requests(self,method,url,data,cookie=None):
        if method =='get':
            res = requests.get(url,data,cookies=cookie)
        else:
            res = requests.post(url,data,cookies=cookie)
        return res
if __name__ == '__main__':
    url_login = 'http://119.23.241.154:8080/futureloan/mvc/api/member/login'
    url_recharge = 'http://119.23.241.154:8080/futureloan/mvc/api/member/recharge'
    login_data = {"mobilephone": "18688773467", "pwd": "123456"}
    recharge_data = {"mobilephone": "18688773467", "amount": "1000"}
    #登录
    res = HttpRequest().http_requests(url_login,login_data,'post')
    print("登录结果是：",res.json())
    #充值
    recharge_res = HttpRequest().http_requests(url_recharge,recharge_data,'get',res.cookies)
    print("充值结果是：",recharge_res.json())

gyp1101.py

# -*- conding:utr-8 -*-
#@Time  :2018/11/2 15:25
#@Author:GYP测试
#@File  :gyp1101.py
from openpyxl import load_workbook
class datedd:
    def __init__(self,file_name,sheet_name):
        self.file_name=file_name
        self.sheet_name=sheet_name
    def shuju(self):
        wb=load_workbook(self.file_name)
        sheet=wb[self.sheet_name]
        list1=[]
        for j in range(1,sheet.max_row+1):
            dct1={}
            # re=sheet.cell(1,1).value
            dct1['method']=sheet.cell(j,1).value
            dct1['url']=sheet.cell(j,2).value
            dct1['data']=sheet.cell(j,3).value
            dct1['expected']=sheet.cell(j,4).value
            list1.append(dct1)
        # print(list1)
        return list1
if __name__ == '__main__':
    datedd('xg.xlsx','python1').shuju()

read_me.py

# -*- conding:utr-8 -*-
#@Time  :2018/11/1 20:11
#@Author:GYP测试
#@File  :read_me.py

#地址  测试数据 断言 期望值

class GetData:
    Cookie=None #存储cookie  初始值None
if __name__ == '__main__':

    setattr(GetData,'Cookie','小黄') #可以直接把类里面的属性值做修改
    hasattr(GetData,'Cookie') #判断是否有值
    getattr(GetData,'Cookie') #获取它的值

    print(GetData.Cookie)
    print(hasattr(GetData,'Cookie'))
    print(getattr(GetData,'Cookie'))

    delattr(GetData,'Cookie') #删除这个属性
    print(hasattr(GetData,'Cookie'))

class_011.py

import unittest
from API_AUTO.http_requests import HttpRequest
from class_1101.read_me import GetData

class TestLogin(unittest.TestCase):
    def setUp(self):
        pass

    def __init__(self,methodName,url,data,method,expected):
        super(TestLogin,self).__init__(methodName) #继承了父类的方法
        self.url= url
        self.data= data
        self.method=method
        self.expected=expected
    #正常登录
    def test_api(self):
        res = HttpRequest().http_requests(self.method,self.url,self.data,getattr(GetData,'Cookie'))
        if res.cookies: #如果cookie有的话，那么就更新COOKIE
            setattr(GetData,'Cookie',res.cookies)
        try:
            self.assertIn(self.expected,res.json()['code'])
        except AssertionError as e:
            print('登录出错了%s' %e)
            raise e
        print(res.json())
        return res
    def tearDown(self):
        pass
if __name__ == '__main__':
    unittest.main()

class_022.py

import unittest
import HTMLTestRunner
from unit1030.class_011 import TestLogin #具体到类名
from class_1101.gyp1101 import datedd

#存储
suite = unittest.TestSuite()
#加载
loader = unittest.TestLoader()
res =datedd('xg.xlsx','python1').shuju()
for item in res:
    suite.addTest(TestLogin('test_api',item['url'],eval(item['data']),item['method'],str(item['expected'])))
#输出
with open('test_report.html','wb') as file:
    runner = HTMLTestRunner.HTMLTestRunner(stream=file,verbosity=2,title='框架学习练习',tester='GYP测试')
    runner.run(suite)

 另外处理数据的方法：方法二

do_excel.py 对应gyp1101.py

# -*- conding:utr-8 -*-
#@Time  :2018/11/5 10:53
#@Author:GYP测试
#@File  :do_excel.py
from openpyxl import load_workbook
class datedd:
    def __init__(self,file_name,sheet_name):
        self.file_name=file_name
        self.sheet_name=sheet_name
        self.sheet_obj=load_workbook(self.file_name)[self.sheet_name]#获取表单对象
        self.max_row=self.sheet_obj.max_row
    def get_data(self,i,j):
        # print(self.sheet_obj.max_row)
        return self.sheet_obj.cell(i,j).value

if __name__ == '__main__':
    res =datedd('xg.xlsx','python1').get_data(1,1)
    print(res)

test_suite_2.py 对应class_022.py

# -*- conding:utr-8 -*-
#@Time  :2018/11/5 11:11
#@Author:GYP测试
#@File  :test_suite_2.py
import unittest
import HTMLTestRunner
from class_1103.class_011 import TestLogin #具体到类名
from class_1103.do_excel import datedd

#存储
suite = unittest.TestSuite()
#加载

t=datedd('xg.xlsx','python1')

for i in range(1,t.max_row+1):
    suite.addTest(TestLogin('test_api',t.get_data(i,1),t.get_data(i,2),eval(t.get_data(i,3)),str(t.get_data(i,4))))
#输出
with open('test_report.html','wb') as file:
    runner = HTMLTestRunner.HTMLTestRunner(stream=file,verbosity=2,title='框架学习练习',tester='GYP测试')
    runner.run(suite)

do_excel.py 再次优化 个人觉得是 参数化最好的一种方法，建议使用

# -*- conding:utr-8 -*-
#@Time  :2018/11/2 15:25
#@Author:GYP测试
#@File  :gyp1101.py
from openpyxl import load_workbook
class datedd:
    def __init__(self,file_name,sheet_name):
        self.file_name=file_name
        self.sheet_name=sheet_name
    def get_header(self):
        wb = load_workbook(self.file_name)
        sheet = wb[self.sheet_name]
        header=[]
        for i in range(1,sheet.max_column+1):
            header.append(sheet.cell(1,i).value)
        # print(header)
        return header
    def get_data(self):
        wb=load_workbook(self.file_name)
        sheet=wb[self.sheet_name]
        header=self.get_header()
        test_data=[]
        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)
        print(test_data)
        return test_data
if __name__ == '__main__':
    datedd('xg.xlsx','python1').get_data()
    # datedd('xg.xlsx','python1').get_header()