from selenium import webdriver
import unittest
import sys
sys.path.append(‘D:\selenium+python\imooc_selenium\yiyou\Tecrm’)
from tecrmBusiness.refundBusiness import RefundBusiness
import time
import HTMLTestRunner
import os
import ddt
from util.exce_util import ExcelUtil
ex = ExcelUtil()
data = ex.get_data()
@ddt.ddt
class Test_CreateDdtCase(unittest.TestCase):
def setUp(self):
self.driver = webdriver.Chrome()
self.driver.get(’’)
self.driver.maximize_window()
time.sleep(5)
self.refund_B = RefundBusiness(self.driver,‘BL’)
def tearDown(self):
for method_name,error in self._outcome.errors:
if error:
case_name = self._testMethodName
file_time = time.strftime(r'%Y%m%d_%H%M%S')
file_name = os.path.join(os.getcwd() + '/yiyou/Tecrm/tecrmReport/' + file_time + case_name + '第五章.png')
self.driver.save_screenshot(file_name)
self.driver.quit()
@ddt.data(*data)
def test_excel_success_print(self,data):
epasspord,lastname,fristname,amounts,account_type,account_number,flatratetype = data
print_num = self.refund_B.refund_function(epasspord,lastname,fristname,amounts,account_type,account_number,flatratetype)
self.assertEqual('1',print_num,'税单创建失败')
if name == “main”:
file_date = time.strftime(r'%Y%m%d_%H%M%S')
file_path = os.path.join(os.getcwd() + '/yiyou/Tecrm/tecrmReport/数据驱动' + file_date + '第五章.html')
f = open(file_path,'wb')
suite = unittest.TestLoader().loadTestsFromTestCase(Test_CreateDdtCase)
#suite.addTest(Test_CreateDdtCase('test_success_print'))
runner = HTMLTestRunner.HTMLTestRunner(stream=f,title='数据驱动测试报高',description='数据驱动的校验',verbosity=2)
runner.run(suite)
'''
unittest.main()
'''

麻烦老师帮忙看一下,Excel里是有多行的,但每次运行都只运行第一行,不管是否成功都只运行第一行的