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()) #获取上一级目录，即工程目录
