Python DoExcel示例

示例#1

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

from ddt import ddt, data

from API_6.common import project_path
from API_6.common.do_excel import DoExcel
from API_6.common.do_mysql import DoMysql
from API_6.common.get_data import GetData
from API_6.common.http_request import HttpRequest
from API_6.common.my_log import MyLog

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

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


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

    def tearDown(self):
        pass

    # 写用例
    @data(*test_data)

示例#2

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

示例#3

文件： test_recharge.py 项目： JayneCheng/Test

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

示例#4

文件： test_recharge.py 项目： JayneCheng/Test

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

from ddt import ddt, data

from API_6.common import project_path
from API_6.common.do_excel import DoExcel
from API_6.common.do_mysql import DoMysql
from API_6.common.get_data import GetData
from API_6.common.http_request import HttpRequest
from API_6.common.my_log import MyLog

# 测试充值
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)

示例#5

文件： test_addloan.py 项目： randy5919/interface_project

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

示例#6

文件： test_addloan.py 项目： 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_6.common.my_log import MyLog
from API_6.common.http_request import HttpRequest
from API_6.common.do_excel import DoExcel
from API_6.common import project_path
from API_6.common.get_data import GetData
from API_6.common.do_mysql import DoMysql

#测试充值
test_data = DoExcel(project_path.case_path,
                    'add_loan').read_data('AddLoanCASE')  #获取测试数据
my_log = MyLog()
# COOKIES=None#设置cookies的初始值为None


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

    def tearDown(self):
        pass

    #写用例
    @data(*test_data)
    # @unpack

示例#7

文件： test_register.py 项目： githubxuyan/API_TEST

# -*- 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_6.common.my_log import MyLog
from API_6.common.http_request import HttpRequest
from API_6.common.do_excel import DoExcel
from API_6.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  #全局变量