Python DoExcel Beispiele

Beispiel #1

Datei: test_bidLoan.py Projekt: LeesonY/API

# -*- coding: utf-8 -*-
# @Time : 2019/3/10 16:35
# @Author : 小雨点
# @Email: [email protected]
# @File : test_cases.py
import unittest
from ddt import ddt, data
from pythonLX.week10.API_5.common.my_log import MyLog
from pythonLX.week10.API_5.common.http_request import HttpRequest
from pythonLX.week10.API_5.common.do_excel import DoExcel
from pythonLX.week10.API_5.common import project_path
from pythonLX.week10.API_5.common.do_mysql import DoMysql
from pythonLX.week10.API_5.common.get_data import GetData
from pythonLX.week10.API_5.common import get_data
'''测试投资、加标'''
test_data = DoExcel(project_path.case_path, 'bidLoan').readexcel('BidLoadCASE')
my_log = MyLog()
COOKIES = None  #设置cookies的初始值为None


@ddt
class TestCases(unittest.TestCase):
    def setUp(self):
        self.t = DoExcel(project_path.case_path, 'bidLoan')  #写入测试结果的对象

    def tearDown(self):
        pass

    #写用例
    @data(*test_data)
    def test_cases(self, case):

Beispiel #2

Datei: test_bidLoan.py Projekt: LeesonY/API

 def setUp(self):
     self.t = DoExcel(project_path.case_path, 'bidLoan')  #写入测试结果的对象

Beispiel #3

 def setUp(self):
     self.t = DoExcel(project_path.case_path, 'register')  #写入测试结果的对象

Beispiel #4

Datei: test_login.py Projekt: LeesonY/API

# -*- coding: utf-8 -*-
# @Time : 2019/3/10 16:35
# @Author : 小雨点
# @Email: [email protected]
# @File : test_cases.py
import unittest
from ddt import ddt, data
from pythonLX.week10.API_5.common.my_log import MyLog
from pythonLX.week10.API_5.common.http_request import HttpRequest
from pythonLX.week10.API_5.common.do_excel import DoExcel
from pythonLX.week10.API_5.common import project_path
from pythonLX.week10.API_5.common import get_data
'''测试登陆'''
test_data = DoExcel(project_path.case_path, 'login').readexcel('LoginCASE')
my_log = MyLog()
COOKIES = None  #设置cookies的初始值为None


@ddt
class TestCases(unittest.TestCase):
    def setUp(self):
        self.t = DoExcel(project_path.case_path, 'login')  #写入测试结果的对象

    def tearDown(self):
        pass

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

Beispiel #5

# -*- coding: utf-8 -*-
# @Time : 2019/3/10 16:35
# @Author : 小雨点
# @Email: [email protected]
# @File : test_cases.py
import unittest
from ddt import ddt, data
from pythonLX.week10.API_5.common.my_log import MyLog
from pythonLX.week10.API_5.common.http_request import HttpRequest
from pythonLX.week10.API_5.common.do_excel import DoExcel
from pythonLX.week10.API_5.common import project_path
from pythonLX.week10.API_5.common import get_data
'''测试注册'''
test_data = DoExcel(project_path.case_path,
                    'register').readexcel('RegisterCASE')
my_log = MyLog()
COOKIES = None  #设置cookies的初始值为None


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

    def tearDown(self):
        pass

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

Beispiel #6

Datei: test_withdraw.py Projekt: LeesonY/API

 def setUp(self):
     self.t = DoExcel(project_path.case_path, 'withdraw')  #写入测试结果的对象

Beispiel #7

Datei: test_withdraw.py Projekt: LeesonY/API

# -*- coding: utf-8 -*-
# @Time : 2019/3/10 16:35
# @Author : 小雨点
# @Email: [email protected]
# @File : test_cases.py
import unittest
from ddt import ddt, data
from pythonLX.week10.API_5.common.my_log import MyLog
from pythonLX.week10.API_5.common.http_request import HttpRequest
from pythonLX.week10.API_5.common.do_excel import DoExcel
from pythonLX.week10.API_5.common import project_path
from pythonLX.week10.API_5.common import get_data
'''测试提现'''
test_data = DoExcel(project_path.case_path,
                    'withdraw').readexcel('WithdrawCASE')
my_log = MyLog()
COOKIES = None  #设置cookies的初始值为None


@ddt
class TestCases(unittest.TestCase):
    def setUp(self):
        self.t = DoExcel(project_path.case_path, 'withdraw')  #写入测试结果的对象

    def tearDown(self):
        pass

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

Beispiel #8

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

Beispiel #9

# -*- coding: utf-8 -*-
# @Time : 2019/3/10 16:35
# @Author : 小雨点
# @Email: [email protected]
# @File : test_cases.py
import unittest
from ddt import ddt,data
from pythonLX.week10.API_5.common.my_log import MyLog
from pythonLX.week10.API_5.common.http_request import HttpRequest
from pythonLX.week10.API_5.common.do_excel import DoExcel
from pythonLX.week10.API_5.common import project_path
from pythonLX.week10.API_5.common.do_mysql import DoMysql
from pythonLX.week10.API_5.common  import get_data
'''充值'''
test_data=DoExcel(project_path.case_path,'recharge').readexcel('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)
    def test_cases(self,case):
        global TestResult#全局变量
        global COOKIES#声明全局变量