Python DoExcel Examples

Example #1

File: test_api.py Project: zyanwei2011/Automated-Testing

class TestApi(unittest.TestCase):
    def setUp(self):
        self.t = DoExcel(project_path.test_cases_path,
                         sheet_name)  #创建一个Excel操作实例
        self.logger = MyLog()  #实例
        self.logger.info("开始测试了")

    @data(*test_data)
    def test_api(self, data_item):
        global COOKIES  #声明是全局变量
        self.logger.info("正在运行第{0}条用例：{1}".format(data_item['id'],
                                                  data_item['description']))
        self.logger.info("测试数据是:{0}".format(data_item['param']))
        #请求之前 是不是要判断下 是否有loan_id 去数据库
        if data_item['param'].find('${loan_id}') != -1:
            wb = load_workbook(project_path.test_cases_path)
            sheet = wb['info']
            member_id = sheet.cell(4, 2).value
            #怎么去改写代码 灵活处理呢？  1)麻烦一点  2）都可以写到配置文件文件
            sql = 'select max(id) from loan where memberid={0}'.format(
                member_id)
            loan_id = DoMysql().do_mysql(sql)[0][0]
            param = data_item['param'].replace('${loan_id}',
                                               str(loan_id))  #数字转为字符串
            sheet.cell(5, 2).value = loan_id  #写回查询到的loan_id到excel
            #保存
            wb.save(project_path.test_cases_path)
        else:
            param = data_item['param']
        #进行HTTP请求
        res = HttpRequest().http_request(data_item['url'], eval(param),
                                         data_item['HttpMethod'],
                                         COOKIES)  #全局变量
        #可以获取到cookie吗？
        if res.cookies:  #任何非空数据的布尔值都为True  cookies是一个类字典的格式
            COOKIES = res.cookies  #如果cookies不为空 就替换全局变量的COOKIES 修改全局变量

        self.logger.info("测试结果是：{0}".format(res.json()))
        #加断言
        try:
            self.assertEqual(str(data_item['ExpectedResult']),
                             str(res.json()['code']))  #res.json()['code']
            TestResult = 'PASS'
        except AssertionError as e:  #断言异常
            TestResult = 'Failed'
            self.logger.error("请求出错了，错误是{0}".format(e))
            raise e  #对异常处理完毕之后 要记得抛出
        finally:  #最终都要写回到Excel
            self.t.write_back(data_item['id'] + 1,
                              res.json()['code'], TestResult)

    def tearDown(self):
        self.logger.info("结束这个用例的测试")

Example #2

class TestApi(unittest.TestCase):
    def setUp(self):
        self.logger = MyLog()  #实例
        self.logger.info("开始测试了")

    @data(*test_data)
    def test_api(self, data_item):
        self.t = DoExcel(project_path.test_cases_path)  #创建一个Excel操作实例
        self.logger.info("正在运行第{0}条用例：{1}".format(data_item['id'],
                                                  data_item['description']))
        self.logger.info("测试数据是:{0}".format(data_item['param']))
        #请求之前 是不是要判断下 是否有loan_id 去数据库
        if data_item['param'].find('${loan_id}') != -1:
            sql = 'select max(id) from loan where memberid={0}'.format(
                GetInfoData.member_id)
            loan_id = DoMysql().do_mysql(sql)[0][0]  #从数据库里面查的
            param = data_item['param'].replace('${loan_id}',
                                               str(loan_id))  #数字转为字符串
            setattr(GetInfoData, 'loan_id', loan_id)  #反射
        else:
            param = data_item['param']
        res = HttpRequest().http_request(data_item['url'], eval(param),
                                         data_item['HttpMethod'],
                                         GetInfoData.COOKIES)  #全局变量
        #可以获取到cookie吗？
        if res.cookies:  #任何非空数据的布尔值都为True  cookies是一个类字典的格式
            setattr(GetInfoData, 'COOKIES',
                    res.cookies)  #如果cookies不为空 就替换全局变量的COOKIES 修改全局变量

        self.logger.info("测试结果是：{0}".format(res.json()))
        #加断言
        try:
            self.assertEqual(str(data_item['ExpectedResult']),
                             str(res.json()['code']))  #res.json()['code']
            TestResult = 'PASS'
        except AssertionError as e:  #断言异常
            TestResult = 'Failed'
            self.logger.error("请求出错了，错误是{0}".format(e))
            raise e  #对异常处理完毕之后 要记得抛出
        finally:  #最终都要写回到Excel
            self.t.write_back(data_item['sheet_name'], data_item['id'] + 1,
                              res.json()['code'], TestResult)

    def tearDown(self):
        self.logger.info("结束这个用例的测试")

Example #3

class TestApi(unittest.TestCase):
    def setUp(self):
        self.t = DoExcel(project_path.test_cases_path)  #创建一个Excel操作实例
        logger.info("开始测试了")

    @data(*test_data)
    def test_api(self, data_item):
        global COOKIES  #声明是全局变量
        logger.info("正在运行第{0}条用例：{1}".format(data_item['id'],
                                             data_item['description']))
        logger.info("测试数据是:{0}".format(data_item['param']))
        #进行HTTP请求
        res = HttpRequest().http_request(data_item['url'],
                                         eval(data_item['param']),
                                         data_item['HttpMethod'],
                                         COOKIES)  #全局变量
        #可以获取到cookie吗？
        if res.cookies:  #任何非空数据的布尔值都为True  cookies是一个类字典的格式
            COOKIES = res.cookies  #如果cookies不为空 就替换全局变量的COOKIES 修改全局变量

        logger.info("测试结果是：{0}".format(res.json()))
        #加断言
        try:
            self.assertEqual(str(data_item['ExpectedResult']),
                             str(res.json()['code']))  #res.json()['code']
            TestResult = 'PASS'
        except AssertionError as e:  #断言异常
            TestResult = 'Failed'
            logger.error("请求出错了，错误是{0}".format(e))
            raise e  #对异常处理完毕之后 要记得抛出
        finally:  #最终都要写回到Excel
            self.t.write_back(data_item['id'] + 1,
                              res.json()['code'], TestResult)

    def tearDown(self):
        logger.info("结束这个用例的测试")

Example #4

File: test_api.py Project: zyanwei2011/Automated-Testing

 def setUp(self):
     self.t = DoExcel(project_path.test_cases_path,
                      sheet_name)  #创建一个Excel操作实例
     self.logger = MyLog()  #实例
     self.logger.info("开始测试了")

Example #5

File: test_api.py Project: zyanwei2011/Automated-Testing

from API_Frame_Work_1019.common import project_path
from API_Frame_Work_1019.common.http_request import HttpRequest
from API_Frame_Work_1019.common.do_excel import DoExcel
from API_Frame_Work_1019.common.read_config import ReadConfig
from API_Frame_Work_1019.common.my_log import MyLog
from API_Frame_Work_1019.common.do_mysql import DoMysql

#从配置文件里面获取button和case_id_list的值
button = ReadConfig().read_config(project_path.case_config_path, 'CASECONFIG',
                                  'button')
case_id_list = ReadConfig().read_config(project_path.case_config_path,
                                        'CASECONFIG', 'case_id_list')
sheet_name = ReadConfig().read_config(project_path.case_config_path,
                                      'CASECONFIG', 'sheet_name')
#获取测试数据
test_data = DoExcel(project_path.test_cases_path,
                    sheet_name).get_data(button, case_id_list)

#全局变量
COOKIES = None


@ddt
class TestApi(unittest.TestCase):
    def setUp(self):
        self.t = DoExcel(project_path.test_cases_path,
                         sheet_name)  #创建一个Excel操作实例
        self.logger = MyLog()  #实例
        self.logger.info("开始测试了")

    @data(*test_data)
    def test_api(self, data_item):

Example #6

File: test_register.py Project: zyanwei2011/Automated-Testing

 def setUp(self):
     self.t = DoExcel(project_path.test_cases_path,
                      'register')  #创建一个Excel操作实例
     self.logger = MyLog()  #实例
     self.logger.info("开始测试了")

Example #7

File: test_register.py Project: zyanwei2011/Automated-Testing

# @Time    : 2018/10/17 21:10
# @Author  : lemon_huahua
# @Email   : [email protected]
# @File    : test_api.py
#引入ddt
import unittest
from openpyxl import load_workbook
from ddt import ddt, data
from API_Frame_Work_1019.common import project_path
from API_Frame_Work_1019.common.http_request import HttpRequest
from API_Frame_Work_1019.common.do_excel import DoExcel
from API_Frame_Work_1019.common.my_log import MyLog
from API_Frame_Work_1019.common.do_mysql import DoMysql

#获取测试数据
test_data = DoExcel(project_path.test_cases_path, 'register').get_data()
#全局变量
COOKIES = None


@ddt
class TestApi(unittest.TestCase):
    def setUp(self):
        self.t = DoExcel(project_path.test_cases_path,
                         'register')  #创建一个Excel操作实例
        self.logger = MyLog()  #实例
        self.logger.info("开始测试了")

    @data(*test_data)
    def test_api(self, data_item):
        global COOKIES  #声明是全局变量

Example #8

File: test_login.py Project: zyanwei2011/Automated-Testing

# @Time    : 2018/10/17 21:10
# @Author  : lemon_huahua
# @Email   : [email protected]
# @File    : test_api.py
#引入ddt
import unittest
from openpyxl import load_workbook
from ddt import ddt, data
from API_Frame_Work_1019.common import project_path
from API_Frame_Work_1019.common.http_request import HttpRequest
from API_Frame_Work_1019.common.do_excel import DoExcel
from API_Frame_Work_1019.common.my_log import MyLog
from API_Frame_Work_1019.common.do_mysql import DoMysql

#获取测试数据
test_data = DoExcel(project_path.test_cases_path, 'login').get_data()
#全局变量
COOKIES = None


@ddt
class TestApi(unittest.TestCase):
    def setUp(self):
        self.t = DoExcel(project_path.test_cases_path, 'login')  #创建一个Excel操作实例
        self.logger = MyLog()  #实例
        self.logger.info("开始测试了")

    @data(*test_data)
    def test_api(self, data_item):
        global COOKIES  #声明是全局变量
        self.logger.info("正在运行第{0}条用例：{1}".format(data_item['id'],

Example #9

 def setUp(self):
     self.t = DoExcel(project_path.test_cases_path)  #创建一个Excel操作实例
     logger.info("开始测试了")

Example #10

# @Time    : 2018/10/17 21:10
# @Author  : lemon_huahua
# @Email   : [email protected]
# @File    : test_api.py
#引入ddt
import unittest
from openpyxl import load_workbook
from ddt import ddt,data
from API_Frame_Work_1019.common import project_path
from API_Frame_Work_1019.common.http_request import HttpRequest
from API_Frame_Work_1019.common.do_excel import DoExcel
from API_Frame_Work_1019.common.my_log import  MyLog
from API_Frame_Work_1019.common.do_mysql import DoMysql

#获取测试数据
test_data=DoExcel(project_path.test_cases_path,'business').get_data()
#全局变量
COOKIES=None

@ddt
class TestApi(unittest.TestCase):
    def setUp(self):
        self.t=DoExcel(project_path.test_cases_path,'business')#创建一个Excel操作实例
        self.logger=MyLog()#实例
        self.logger.info("开始测试了")

    @data(*test_data)
    def test_api(self,data_item):
        global COOKIES#声明是全局变量
        self.logger.info("正在运行第{0}条用例：{1}".format(data_item['id'],data_item['description']))
        #请求之前 是不是要判断下 是否有loan_id 去数据库

Example #11

# @Time    : 2018/10/17 21:10
# @Author  : lemon_huahua
# @Email   : [email protected]
# @File    : test_api.py
#引入ddt
import unittest
from openpyxl import load_workbook
from ddt import ddt, data
from API_Frame_Work_1019.common import project_path
from API_Frame_Work_1019.common.http_request import HttpRequest
from API_Frame_Work_1019.common.do_excel import DoExcel
from API_Frame_Work_1019.common.my_log import MyLog
from API_Frame_Work_1019.common.do_mysql import DoMysql
from API_Frame_Work_1019.common.get_info_data import GetInfoData
#获取测试数据
test_data = DoExcel(project_path.test_cases_path).get_data()


@ddt
class TestApi(unittest.TestCase):
    def setUp(self):
        self.logger = MyLog()  #实例
        self.logger.info("开始测试了")

    @data(*test_data)
    def test_api(self, data_item):
        self.t = DoExcel(project_path.test_cases_path)  #创建一个Excel操作实例
        self.logger.info("正在运行第{0}条用例：{1}".format(data_item['id'],
                                                  data_item['description']))
        self.logger.info("测试数据是:{0}".format(data_item['param']))
        #请求之前 是不是要判断下 是否有loan_id 去数据库