Python DoExcel Examples

Example #1

 def setUp(self):  # 测试之前的准备工作
     self.t = DoExcel(project_path.case_path, 'recharge')  # 写入测试结果的对象

Example #2

 def setUp(self):  # 测试之前的准备工作
     warnings.simplefilter(
         "ignore", ResourceWarning
     )  # 为解决出现“ResourceWarning: Enable tracemalloc to get the object allocation traceback”
     self.t = DoExcel(project_path.case_path, 'add_loan')  # 写入测试结果的对象

Example #3

# -*- coding: utf-8 -*-
# @Time    : 2019/3/13 20:09
# @Author  : lemon_huahua
# @Email   : [email protected]
# @File    : test_cases.py
import unittest
from ddt import ddt, data
from API_7.common.my_log import MyLog
from API_7.common.http_request import HttpRequest
from API_7.common.do_excel import DoExcel
from API_7.common import project_path
from API_7.common.get_data import GetData
from API_7.common.do_mysql import DoMysql

# 测试充值
test_data = DoExcel(project_path.case_path,
                    'recharge').read_data('RechargeCASE')  # 获取测试数据
my_log = MyLog()

# COOKIES=None#设置cookies的初始值为None


@ddt
class TestCases(unittest.TestCase):
    def setUp(self):  # 测试之前的准备工作
        self.t = DoExcel(project_path.case_path, 'recharge')  # 写入测试结果的对象

    def tearDown(self):
        pass

    # 写用例
    @data(*test_data)

Example #4

 def setUp(self):  # 测试之前的准备工作
     self.t = DoExcel(project_path.case_path, 'add_loan')  # 写入测试结果的对象

Example #5

import unittest
from ddt import ddt, data
from API_7.common.my_log import MyLog
from API_7.common.http_request import HttpRequest
from API_7.common.do_excel import DoExcel
from API_7.common import project_path
from API_7.common.get_data import GetData
from API_7.common.do_pymysql import DoMysql
from API_7.common import get_data
import warnings

# 测试充值
test_data = DoExcel(project_path.case_path,
                    'add_loan').read_case('AddLoanCASE')  # 获取测试数据
my_log = MyLog()

# COOKIES=None#设置cookies的初始值为None


@ddt
class TestCases(unittest.TestCase):
    def setUp(self):  # 测试之前的准备工作
        warnings.simplefilter(
            "ignore", ResourceWarning
        )  # 为解决出现“ResourceWarning: Enable tracemalloc to get the object allocation traceback”
        self.t = DoExcel(project_path.case_path, 'add_loan')  # 写入测试结果的对象

    def tearDown(self):
        pass

    # 写用例

Example #6

File: test_register.py Project: lyyusheng/API_test7

import json
import unittest
from API_7.common.do_excel import DoExcel
from API_7.common import project_path
from API_7.common.http_request import HttpRequest
from API_7.common.my_log import MyLog
from ddt import ddt, unpack, data
TestResult = None
my_log = MyLog()
test_data = DoExcel(project_path.case_path,
                    'register').read_case('RegisterCase')
print(test_data)


@ddt
class TestCase(unittest.TestCase):  # 光标要移到最底下执行
    def setUp(self):  # 每條用例執行之前執行
        self.t = DoExcel(project_path.case_path,
                         'register')  # 赋值给对象属性self.t,在整个类里面都可以调用
        print('開始執行新一條測試了')  # 準備工作

    def tearDown(self):  # 每條用例執行之後執行
        print('一條測試用例執行完畢')  # 清場工作，把占用的環境資源關掉

    @data(*test_data)
    def test_send_request(self, case):
        global TestResult
        method = case['Method']
        url = case['Url']
        param = eval(case['Params'])  # 讀出來是個字符串，必須eval()變回原來字典類型
        my_log.info('-----正在测试{}模块里面第{}条测试用例：{},'.format(

Example #7

File: test_register.py Project: lyyusheng/API_test7

 def setUp(self):  # 每條用例執行之前執行
     self.t = DoExcel(project_path.case_path,
                      'register')  # 赋值给对象属性self.t,在整个类里面都可以调用
     print('開始執行新一條測試了')  # 準備工作

Example #8

File: test_register.py Project: randy5919/interface_project

# -*- coding: utf-8 -*-
# @Time    : 2019/3/13 20:09
# @Author  : lemon_huahua
# @Email   : [email protected]
# @File    : test_cases.py
import unittest
from ddt import ddt, data
from API_7.common.my_log import MyLog
from API_7.common.http_request import HttpRequest
from API_7.common.do_excel import DoExcel
from API_7.common import project_path

#测试注册--传参
test_data = DoExcel(project_path.case_path,
                    'register').read_data('RegisterCASE')  #获取测试数据
my_log = MyLog()


@ddt
class TestCases(unittest.TestCase):
    def setUp(self):  #测试之前的准备工作
        self.t = DoExcel(project_path.case_path, 'register')  #写入测试结果的对象

    def tearDown(self):
        pass

    #写用例
    @data(*test_data)
    # @unpack
    def test_cases(self, case):
        global TestResult  #全局变量

Example #9

# @Email   : [email protected]
# @File    : test_cases.py
import unittest
import warnings

from ddt import ddt, data
from API_7.common.my_log import MyLog
from API_7.common.do_excel import DoExcel
from API_7.common import project_path
from API_7.common.get_data import GetData
from API_7.common.do_pymysql import DoMysql

from API_7.common.http_request import HttpRequest

# 测试充值
test_data = DoExcel(project_path.case_path,
                    'invest').read_case('InvestCASE')  # 获取测试数据
my_log = MyLog()

# COOKIES=None#设置cookies的初始值为None


@ddt
class TestCases(unittest.TestCase):
    def setUp(self):  # 测试之前的准备工作
        warnings.simplefilter(
            "ignore", ResourceWarning
        )  # 为解决出现“ResourceWarning: Enable tracemalloc to get the object allocation traceback”
        self.t = DoExcel(project_path.case_path, 'invest')  # 写入测试结果的对象

    def tearDown(self):
        pass

Example #10

import unittest
from API_7.common.do_excel import DoExcel
from API_7.common import project_path
from API_7.common.http_request import HttpRequest
from API_7.common.my_log import MyLog
from API_7.common.get_data import GetData
from ddt import ddt, unpack, data
from API_7.common.do_pymysql import DoMysql

# 这是获取cookies的第二种方法，使用映射获取cookies，不用全局变量
# 发起测试
my_log = MyLog()
test_data = DoExcel(project_path.case_path,
                    'recharge').read_case('RechargeCase')
TestResult = None  # 声明一些，颜色不一样看着烦
null = None  # 为了解决出现“NameError: name ‘null’ is not defined”
print(test_data)


@ddt
class TestCase(unittest.TestCase):  # 光标要移到最底下执行
    def setUp(self):  # 每條用例執行之前執行
        self.t = DoExcel(project_path.case_path,
                         'recharge')  # 赋值给对象属性self.t,在整个类里面都可以调用
        print('開始執行新一條測試了')  # 準備工作

    def tearDown(self):  # 每條用例執行之後執行
        print('一條測試用例執行完畢')  # 清場工作，把占用的環境資源關掉

    @data(*test_data)
    def test_send_request(self, case):

Example #11

File: test_invest.py Project: randy5919/interface_project

 def setUp(self):  # 测试之前的准备工作
     self.t = DoExcel(project_path.case_path, 'invest')  # 写入测试结果的对象

Example #12

File: test_recharge.py Project: lyyusheng/API_test7

 def setUp(self):  # 每條用例執行之前執行
     warnings.simplefilter("ignore",
                           ResourceWarning)  # 为解决出现“ResourceWarning: Enable tracemalloc to get the object allocation traceback”
     self.t = DoExcel(project_path.case_path, 'recharge')  # 赋值给对象属性self.t,在整个类里面都可以调用
     print('開始執行新一條測試了')  # 準備工作