class GetData: def __init__(self): self.excel = ExcelUtil("/Users/qing.li/Desktop/thrid_case.xlsx") def get_excel_data(self): # 去掉表头 result = self.excel.get_data()[1:] return result
sys.path.append('D:/pythonWork/autoTest') from case.login_keyword_cases import LoginKeywordCases import ddt import unittest import os from business.examination_place_business import ExaminationPlaceBusiness from business.examination_room_business import ExaminationRoomBusiness from business.examination_envir_business import ExaminationEnvirBusiness from util.excel_util import ExcelUtil from util.table_util import TableUtil # 获取数据 ex = ExcelUtil( excel_path=r"D:\pythonWork\autoTest\data\examinationMachineDdtCase.xls") data = ex.get_data() # 测试类前加修饰@ddt.ddt @ddt.ddt class ExaminationMachineDdtCase(unittest.TestCase): # 所有case执行之前的装饰器---前置条件 @classmethod def setUpClass(cls): print('所有case执行的前置条件') lkc = LoginKeywordCases() lkc.run_keyword_excel_cases() cls.driver = getattr(getattr(lkc, 'lk'), 'driver') cls.driver.maximize_window() cls.EPb = ExaminationPlaceBusiness(cls.driver) cls.Tu = TableUtil(cls.driver)
from business.loginbusiness import LoginBusiness from business.add_munberbusiness import AddMenBusiness from selenium import webdriver import time import ddt import unittest import os import HTMLTestRunner from util.excel_util import ExcelUtil amex = ExcelUtil('D:\Kuban\config\mendata.xls') login_data = amex.get_data() @ddt.ddt class AddMen(unittest.TestCase): def setUp(self): self.driver = webdriver.Chrome() # self.driver.maximize_window() self.driver.get('https://mgmt.ent-dev.kuban.io/') self.amb = AddMenBusiness(self.driver) self.lb = LoginBusiness(self.driver) def tearDown(self): for method_name, error in self._outcome.errors: if error: case_name = self._testMethodName file_path = os.path.abspath( os.path.dirname(os.getcwd()) + '\image' + '\pic_' + case_name + '.png') self.driver.save_screenshot(file_path)
import os import sys sys.path.append('C:\\Users\\Administrator\\PycharmProjects\\moco') import time import HTMLTestRunner from selenium import webdriver from business.register_business import RegisterBusiness from util.excel_util import ExcelUtil from util.read_ini import ReadIni import ddt import unittest exl = ExcelUtil() data = exl.get_data() @ddt.ddt class FirstDateCase(unittest.TestCase): @classmethod def setUpClass(cls): get_element = ReadIni() # cls.file_name = "C:/Users/Administrator/PycharmProjects/moco/moco_selenium/image/test001.png" # cls.file_name = get_element.get_value("code_image_url") def setUp(self): #self.driver = webdriver.Chrome("C:\Program Files (x86)\python\chromedriver.exe") self.driver = webdriver.Chrome("C:\\Users\\Administrator\\AppData\\Local\\Google\\Chrome\\Application" "\\chromedriver.exe")
from business.loginbusiness import LoginBusiness from business.location_admin_add_staff_business import LocationAdminAddStaffBusiness from selenium import webdriver from util.excel_util import ExcelUtil import ddt import time import unittest import os import HTMLTestRunner ex = ExcelUtil('D:\Kuban\config\staffdata.xls') staff_data = ex.get_data() @ddt.ddt class LocationAdminAddStaff(unittest.TestCase): def setUp(self) -> None: self.driver = webdriver.Chrome() self.driver.get('https://mgmt.ent-dev.kuban.io/') self.lab = LocationAdminAddStaffBusiness(self.driver) self.lb = LoginBusiness(self.driver) def tearDown(self) -> None: for method_name, error in self._outcome.errors: if error: case_name = self._testMethodName file_path = os.path.abspath( os.path.dirname(os.getcwd()) + '\image' + '\pic_' + case_name + '.png') self.driver.save_screenshot(file_path) self.driver.close()
def export_success(self): #self.handle.export() #获取导出文件信息 ex = ExcelUtil("C:\\Users\\sunH\\Downloads\\待提交_20191206.xls") value = ex.get_data() return value
''' This is a simple case for Data-Driven Test ''' import ddt import unittest import xlrd import sys sys.path.append("C:\\work\\vcPyTest\\WebTest") from util.excel_util import ExcelUtil ex = ExcelUtil() testData = ex.get_data() @ddt.ddt class DataTest(unittest.TestCase): @classmethod def setUpClass(cls): print("===============Start to Run ! =============") @classmethod def tearDownClass(cls): print("=============== End the run ! ==============") def setUp(self): print("This is the setUp case") def tearDown(self): print("This is the teardown case") @ddt.data(*testData)
# coding=utf-8 #import HTMLTestRunner from util.htmltestrunner.HTMLTestRunner import HTMLTestRunner from util.HTMLTestRunner_PY3.HTMLTestRunner_PY3 import HTMLTestRunner import sys import time from handle.examination_envir_handle import ExaminationeEnvirHandle sys.path.append('D:/pythonWork/autoTest') from case.login_keyword_cases import LoginKeywordCases import ddt import unittest import os from business.examination_place_business import ExaminationPlaceBusiness from business.examination_room_business import ExaminationRoomBusiness from business.examination_envir_business import ExaminationEnvirBusiness from util.excel_util import ExcelUtil from util.table_util import TableUtil # 获取数据 ex = ExcelUtil(excel_path=r"D:\pythonWork\autoTest\data\examinationPhotoDdtCase.xls") data = ex.get_data() # 测试类前加修饰@ddt.ddt @ddt.ddt class ExaminationPhotoDdtCase(unittest.TestCase): # 所有case执行之前的装饰器---前置条件 @classmethod def setUpClass(cls): print('所有case执行的前置条件') lkc = LoginKeywordCases() lkc.run_keyword_excel_cases()
# coding=utf-8 from selenium import webdriver from business.register_ddt_business import RegisterDDTBusiness import unittest from util.html_test_runner import HTMLTestRunner from ddt import * from util.excel_util import ExcelUtil from util.path_util import PathUtil excel_util = ExcelUtil(PathUtil.get_file_path("conf/case.xls")) datas = excel_util.get_data() @ddt class RegisterDDTCase(unittest.TestCase): def setUp(self): self.driver = webdriver.Chrome() self.driver.get("http://www.yundama.com/index/reg") self.driver.maximize_window() self.register_business = RegisterDDTBusiness(self.driver) def tearDown(self): self.driver.close() @data(*datas) def test_register_success(self, datas): username, password, password2, email, answer, code, assert_text = datas self.assertTrue( self.register_business.register_main(username, password, password2, email, answer, code, assert_text), assert_text)
#coding=utf-8 import ddt import sys sys.path.append(r"D:\project_selenium3") #将工程路径加入到Python的搜索路径中 from business.register_business import RegisterBusiness from selenium import webdriver import unittest import HTMLTestRunner import os import time from util.excel_util import ExcelUtil ex = ExcelUtil() data = ex.get_data() #取出excel文件中的数据 @ddt.ddt class FirstDataCase(unittest.TestCase): def setUp(self): self.driver = webdriver.Chrome() #因为driver在其他函数中要使用,所以加上self使其变为全局的 self.driver.get("http://www.5itest.cn/register") self.driver.maximize_window() self.login = RegisterBusiness(self.driver) def tearDown(self): time.sleep(2) for method_name,error in self._outcome.errors: if error: case_name = self._testMethodName #获取case的名字,用于后续的截图 screenshot_name = case_name+'.png' #截图图片的名字 dir_path = os.path.dirname(os.getcwd()) #获取上一级目录,即工程目录