python+selenium封装UI自动化框架

seleinum框架

框架的思想：

解决我们测试过程中的问题：大量的重复步骤，用自动化来实现

1）配置和程序的分离

2）测试数据和程序的分离

3）不懂编程的人员可以方便使用：使用的时候不需要写程序

4）有日志功能，实现无人值守

5）自动发报告

6）框架中不要有重复的代码，实现高度的封装和复用

推荐使用关键字驱动、混合驱动

为什么要编写程序呢？

通用性的东西满足不了个性化的需求

测试的工具：python+selenium

接口测试用例：excel

一、搭建自动化测试的目录结构

分层如下：

1、Action包： 放置关键字文件

2、Config目录： 所有配置文件，日志的配置文件；把所有的项目相关的配置均放到这里，用python支持较好的配置文件格式ini进行配置。实现配置与代码的分离

3、Projvar包：项目所有的公共变量，如：目录、自定义变量名称；

4、ScreenCapture目录：存放截屏目录，按照年月日小时来建目录；

5、TestData目录：放测试将数据文件，可以把所有的testcase的参数化相关文件放在这里，一般采用xlsx、xml等格式。实现数据与代码分离；

6、TestScript包：测试脚本，主程序

7、Util包：封装的公共的类，包括读取config的类，写log的类，读取excel、xml

的类、生成报告的类（如HTMLTestRunner）、数据库的连接、发送邮件等类和方法，都在这里

8、ReadMe.txt（加个说明性文件，告诉团队框架需要使用的环境及方法）

二、搭建步骤

1. 在ProjVar包创建一个var.py用来存放公共变量

import os

#浏览器驱动存放的位置

firefoxDriverFilePath = "e:\\geckodriver"

chromeDriverFilePath = "e:\\chromedriver"

ieDriverFilePath = "e:\\IEDriverServer"

# 当前文件所在目录的父目录的绝对路径

ProjDirPath = os.path.dirname(os.path.dirname(os.path.abspath(__file__)))

test_step_id_col_no = 0

test_step_result_col_no = 8

test_step_error_info_col_no = 9

test_step_capture_pic_path_col_no = 10

test_case_id_col_no= 0

test_case_sheet_name=2

test_case_is_executed_flag_col_no= 3

test_case_is_hybrid_test_data_sheet_col_no=4

test_case_start_time_col_no= 6

test_case_end_time_col_no= 7

test_case_elapsed_time_col_no= 8

test_case_result_col_no = 9

if __name__=="__mian__":

print(ProjDirPath)

2、在Utli包里面创建公共的类、函数

2.1封装excel的类

2. from openpyxl import *

3. import os.path

4. from openpyxl.styles import NamedStyle,Font, colors

5. from ProjVar.var import *

6. from Util.FromatTime import *

8. class Excel:

9. def __init__(self,excel_file_path):

10. if os.path.exists(excel_file_path):

11. self.excel_file_path = excel_file_path

12. self.wb = load_workbook(self.excel_file_path)

13. else:

14. print("%s e文件的路劲不存在，请重新设定！" %excel_file_path)

16. #通过sheet名字来获取操作的sheet

17. def set_sheet_by_name(self,sheet_name):

18. if sheet_name in self.wb.sheetnames:

19. self.sheet = self.wb[sheet_name]

20. else:

21. print("%s sheet不存在，请重新指定！" %sheet_name)

23. #通过序号来获取操作的sheet

24. def set_sheet_by_index(self,index):

25. if isinstance(index,int) and 1<= index <= len(self.get_all_sheet_names()):

26. sheet_name = self.get_all_sheet_names()[index-1]

27. self.sheet = self.wb[sheet_name]

28. else:

29. print("%s sheet 序号不存在，请重新设定" %index)

31. #获取当前sheet和title的名称

32. def get_current_sheet_name(self):

33. return self.sheet.title

35. #获取所有sheet的名称

36. def get_all_sheet_names(self):

37. return self.wb.sheetnames

39. #获取sheet的总行数，从0开始，返回list

40. def get_rows_object(self):

41. return list(self.sheet.rows)

43. #获取sheet的总列数，从0开始，返回list

44. def get_cols_object(self):

45. return list(self.sheet.columns)

47. #获取某行的对象，第一行从0开始

48. def get_row(self,row_no):

49. return self.get_rows_object()[row_no]

51. #获取某一列对象，第一列从0开始

52. def get_col(self,col_no):

53. return self.get_cols_object()[col_no]

55. #获取某个单元格对象

56. def get_cell_value(self,row_no,col_no):

57. if isinstance(row_no,int) and isinstance(col_no,int) and \

58. 1<=row_no<=len(self.get_rows_object()) and \

59. 1 <= row_no <= len(self.get_cols_object()):

60. return self.sheet.cell(row=row_no, column=col_no).value

61. else:

62. print("%s,%s 行号或者列号不存在，请重新设定行号或者列表读取！" % (row_no,col_no))

64. #给某一个单元格写入指定内容，行号、列号从1开始

65. #调用此方法时，excel不要处于打开状态

66. def write_cell_value(self,row_no,col_no,value,color = None):

67. if isinstance(row_no,int) and isinstance(col_no,int):

68. if color is None:

69. font = Font(bold=False, size=10, color=colors.BLACK)

70. self.sheet.cell(row=row_no, column=col_no).font = font

71. self.sheet.cell(row=row_no, column=col_no).value = value

72. elif color == "green":

73. font = Font(bold=True, size=13, color=colors.GREEN)

74. self.sheet.cell(row=row_no, column=col_no).font = font

75. self.sheet.cell(row=row_no, column=col_no).value = value

76. elif color == "red":

77. font = Font(bold=True, size=13, color=colors.RED)

78. self.sheet.cell(row=row_no, column=col_no).font = font

79. self.sheet.cell(row=row_no, column=col_no).value = value

80. self.wb.save(self.excel_file_path)

81. else:

82. print("%s,%s 行号或者列号不是数字，请重新设定行号或者列表读取！" % (row_no, col_no))

84. def write_current_time(self,row_no,col_no):

85. if isinstance(row_no, int) and isinstance(col_no, int):

86. self.sheet.cell(row=row_no, column=col_no).value = get_current_date_and_time()

87. self.wb.save(self.excel_file_path)

89. if __name__ == "__main__":

90. excel_file_path = ProjDirPath+r"\TestData\126邮箱联系人.xlsx"

91. #print(excel_file_path )

92. excel_obj = Excel(excel_file_path)

93. #Excel("e:\\a.xlsx") #测试路劲不存在的情况

94. # excel_obj.set_sheet_by_name("测试邮件")

95. # excel_obj.set_sheet_by_name("测试邮件1111")

96. excel_obj.set_sheet_by_index(1)

97. # print(excel_obj.get_current_sheet_name())

98. #excel_obj.set_sheet_by_index(5)

99. #print(excel_obj.get_rows_object())

100. #print(excel_obj.get_cols_object())

101. #print(excel_obj.get_row(2))

102. print(excel_obj.get_cell_value(2,2))

103. print(excel_obj.write_cell_value(5,7,"hello~~"))

104. print(excel_obj.write_current_time(6,8))

2.2 封装获取页面元素的类

1. from selenium.webdriver.support.ui import WebDriverWait

2. import time

4. #获取单个页面元素对象

5. def getElement(driver,localtorType,localtorExpression):

6. try:

7. element = WebDriverWait(driver,5).until(lambda x:x.find_element(by = localtorType,value=localtorExpression))

8. return element

9. except Exception as e:

10. raise e

12. #获取多个页面元素对象

13. def getElement(driver,localtorType,localtorExpression):

14. try:

15. elements = WebDriverWait(driver,5).until(lambda x:x.find_elements(by=localtorType,value=localtorExpression))

16. return elements

17. except Exception as e:

18. raise e

20. if __name__ =="__main__":

21. from selenium import webdriver

22. #进行单元测试

23. driver = webdriver.Firefox(executable_path="e:\\geckodriver")

24. driver.maximize_window()

25. driver.get("https://mail.126.com/")

26. time.sleep(2)

27. lb = getElement(driver,"id","lbNormal")

28. print(lb)

29. driver.quit()

2.3 封装获取当前日期、时间的类

1. import time

2. import datetime

3. import locale

5. # 获取当前的日期

6. def get_current_date():

7. time_tup = time.localtime()

8. current_date = str(time_tup.tm_year) + "年" + \

9. str(time_tup.tm_mon) + "月" + str(time_tup.tm_mday)+"日"

10. return current_date

12. # 获取当前的时间

13. def get_current_time():

14. time_str = datetime.datetime.now()

15. locale.setlocale(locale.LC_CTYPE, 'chinese')

16. now_time = time_str.strftime('%H点%M分钟%S秒')

17. return now_time

19. # 获取当前的时间

1. def get_current_hour():

2. time_str = datetime.datetime.now()

3. now_hour = time_str.strftime('%H')

4. return now_hour

6. def get_current_date_and_time():

7. return get_current_date()+" "+get_current_time()

9. if __name__ == "__main__":

10. print( get_current_date())

11. print(get_current_time())

12. print(get_current_hour())

13. print(get_current_date_and_time())

2.4 封装创建目录的类

14. import os

15. from Util.FromatTime import *

16. from ProjVar.var import *

17. def make_dir(dir_path):

18. if not os.path.exists(dir_path):

19. try:

20. os.mkdir(dir_path)

21. except Exception as e:

22. print("创建%s目录失败" %dir_path)

23. raise e

25. def make_current_date_dir(default_dir_path = None):

26. if default_dir_path is None:

27. dir_path = get_current_date()

28. else:

29. dir_path = os.path.join(default_dir_path,get_current_date())

30. if not os.path.exists(dir_path):

31. try:

32. os.mkdir(dir_path)

33. except Exception as e:

34. print("创建%s目录失败" % dir_path)

35. raise e

36. return dir_path

38. def make_current_hour_dir(default_dir_path = None):

39. if default_dir_path is None:

40. dir_path = get_current_hour()

41. else:

42. dir_path = os.path.join(default_dir_path,get_current_hour())

43. if not os.path.exists(dir_path):

44. try:

45. os.mkdir(dir_path)

46. except Exception as e:

47. print("创建%s目录失败" % dir_path)

48. raise e

49. return dir_path

51. if __name__ == "__main__":

52. make_dir(ProjDirPath+"\\"+"ScreenCapture\\"+"pic")

53. dir_path = make_current_date_dir(ProjDirPath+"\\"+"ScreenCapture\\")

54. dir_path=make_current_hour_dir(dir_path+"\\")

55. print(dir_path)

2.5 封装日志的类

1. #encoding=utf-8

2. import logging.config

3. import logging

4. from ProjVar.var import ProjDirPath

6. print(ProjDirPath+"\\Conf\\"+"Logger.conf")

8. #读取日志配置文件

9. logging.config.fileConfig(ProjDirPath+"\\Conf\\"+"Logger.conf")

11. #选择一个日志格式

12. logger = logging.getLogger("example01")

14. def debug(message):

15. print ("debug")

16. logger.debug(message)

18. def info(message):

19. logger.info(message)

21. def error(message):

22. print("error")

23. logger.error(message)

25. def warning(message):

26. logger.warning(message)

28. if __name__=="__main__":

29. debug("hi")

30. info("gloryroad")

31. warning("hello")

32. error("something error!")

2.6 封装显示等待的类

1. #encoding=utf-8

2. from selenium.webdriver.support.ui import WebDriverWait

3. from selenium.webdriver.common.by import By

4. from selenium.webdriver.support import expected_conditions as EC

6. class WaitUtil(object):

7. def __init__(self,driver):

8. self.locationTypeDict = {

9. "xpath":By.XPATH,

10. "id":By.ID,

11. "name":By.NAME,

12. "css_selector":By.CSS_SELECTOR,

13. "class_name":By.CLASS_NAME,

14. "tag_name":By.TAG_NAME,

15. "link_text":By.LINK_TEXT,

16. "partial_link_text":By.PARTIAL_LINK_TEXT,

17. }

18. self.driver = driver

19. self.wait = WebDriverWait(driver,30)

21. def presenceOfElementLocated(self,locatorMethod,locatorExpression,*args):

22. """显式等待页面元素出现在DOM中，但并不一定可见，存在则返回该页面元素"""

23. try:

24. #if self.locationTypeDict.has_key(locatorMethod.lower()):

25. if locatorMethod.lower() in self.locationTypeDict:

26. self.wait.until(EC.presence_of_element_located((self.locationTypeDict[locatorMethod.lower()],locatorExpression)))

27. else:

28. raise Exception(u"未找到定位方式，请确认定位方式是否书写正确")

29. except Exception as e:

30. raise e

32. def frameToBeAvailableAndSwitchToIt(self,locationType,locatorExpression,*args):

33. """检查frame是否存在，存在则切换进frame控件中"""

34. try:

35. self.wait.until(EC.frame_to_be_available_and_switch_to_it((self.locationTypeDict[locationType.lower()],locatorExpression)))

36. except Exception as e:

37. raise e

39. def visibilityOfElementLocated(self,locationMethod,locatorExperssion,*args):

40. """显式等待页面元素出现在DOM中，并且可见，存在则返回该页面元素对象"""

41. try:

42. self.wait.until(EC.visibility_of_element_located((self.locationTypeDict[locationMethod.lower()],locatorExperssion)))

43. except Exception as e:

44. raise e

46. if __name__ == "__main__":

47. from selenium import webdriver

48. driver = webdriver.Firefox(executable_path = "e:\\geckodriver")

49. driver.get("https://mail.126.com/")

50. waitUtil = WaitUtil(driver)

51. driver.find_element_by_id("lbNormal").click()

52. # waitUtil.presenceOfElementLocated("id","lbNormal")

53. waitUtil.frameToBeAvailableAndSwitchToIt("xpath",'//iframe[contains(@id,"x-URS-iframe")]')

54. waitUtil.visibilityOfElementLocated("xpath","//input[@name='email']")

55. waitUtil.presenceOfElementLocated("xpath","//input[@name='email']")

56. driver.quit()

## 根据需求如果还用其他的类，封装好后放在此目下面 ##

3、在action包里面，创建关键字函数

1. #encoding=utf-8

2. from selenium import webdriver

3. from ProjVar.var import *

4. from Util.find import *

5. from Util.KeyBoardUtil import KeyBoardKeys

6. from Util.ClipboardUtil import Clipboard

7. from Util.WaitUtil import WaitUtil

8. from selenium.webdriver.firefox.options import Options

9. from selenium.webdriver.chrome.options import Options

10. import time

11. from Util.FromatTime import *

13. #定义全局变量driver

14. driver = None

15. #定义全局的等待类实例对象

16. waitUtil = None

18. def open(browserName):

19. #打开浏览器

20. global driver,waitUtil

21. try:

22. if browserName.lower() == "ie":

23. driver = webdriver.Ie(executable_path = ieDriverFilePath)

24. elif browserName.lower == "chrome":

25. #创建Chrome浏览器的一个Options实例对象

26. chrome_options = Options()

27. #添加屏蔽--ignore--certificate--errors提示信息的设置参数项

28. chrome_options.add_experimental_option("excludeSwitches",["ignore-certificate-errors"])

29. driver = webdriver.Chrome(executable_path = chromeDriverFilePath,chrome_options = chrome_options)

30. else:

31. driver = webdriver.Firefox(executable_path = firefoxDriverFilePath)

32. #driver对象创建成功后，创建等待类实例对象

33. waitUtil = WaitUtil(driver)

34. except Exception as e:

35. raise e

37. def visit(url):

38. #访问某个网站

39. global driver

40. try:

41. driver.get(url)

42. except Exception as e:

43. raise e

45. def close_browser():

46. #关闭浏览器

47. global driver

48. try:

49. driver.quit()

50. except Exception as e:

51. raise e

53. def sleep(sleepSeconds):

54. #强制等待

55. try:

56. time.sleep(int(sleepSeconds))

57. except Exception as e:

58. raise e

60. def clear(locationType,locatorExpression):

61. #清空输入框默认内容

62. global driver

63. try:

64. getElement(driver,locationType,locatorExpression).clear()

65. except Exception as e:

66. raise e

68. def input_string(locationType,locatorExpression,inputContent):

69. #在页面输入框中输入数据

70. global driver

71. try:

72. getElement(driver,locationType,locatorExpression).send_keys(inputContent)

73. except Exception as e:

74. raise e

76. def click(locationType,locatorExpression,*args):

77. #点击页面元素

78. global driver

79. try:

80. getElement(driver,locationType,locatorExpression).click()

81. except Exception as e:

82. raise e

84. def assert_string_in_pagesource(assertString,*args):

85. #断言页面源码是否存在某个关键字或关键字符串

86. global driver

87. try:

88. assert assertString in driver.page_source,u"%s not found in page source!" % assertString

89. except AssertionError as e:

90. raise AssertionError(e)

91. except Exception as e:

92. raise e

94. def assert_title(titleStr,*args):

95. #断言页面标题是否存在给定的关键字符串

96. global driver

97. try:

98. assert titleStr in driver.title,u"%s not found in page title!" % titleStr

99. except AssertionError as e:

100. raise AssertionError(e)

101. except Exception as e:

102. raise e

104. def getTitle(*args):

105. #获取页面标题

106. global driver

107. try:

108. return driver.title

109. except Exception as e:

110. raise e

112. def getPageSource(*args):

113. #获取页面源码

114. global driver

115. try:

116. return driver.page_source

117. except Exception as e:

118. raise e

120. def switch_to_frame(locationType,frameLocatorExpressoin,*args):

121. #切换进frame

122. global driver

123. try:

124. driver.switch_to.frame(getElement(driver,locationType,frameLocatorExpressoin))

125. except Exception as e:

126. print("frame error!")

127. raise e

129. def switch_to_default_content(*args):

130. #切换妯frame

131. global driver

132. try:

133. driver.switch_to.default_content()

134. except Exception as e:

135. raise e

137. def paste_string(pasteString,*args):

138. #模拟Ctrl+V操作

139. try:

140. Clipboard.setText(pasteString)

141. #等待2秒，防止代码执行过快，而未成功粘贴内容

142. time.sleep(2)

143. KeyBoardKeys.twoKeys("ctrl","v")

144. except Exception as e:

145. raise e

147. def press_tab_key(*args):

148. #模拟tab键

149. try:

150. KeyBoardKeys.oneKey("tab")

151. except Exception as e:

152. raise e

154. def press_enter_key(*args):

155. #模拟enter键

156. try:

157. KeyBoardKeys.oneKey("enter")

158. except Exception as e:

159. raise e

161. def maximize(*args):

162. #窗口最大化

163. global driver

164. try:

165. driver.maximize_window()

166. except Exception as e:

167. raise e

169. def capture(file_path):

170. try:

171. driver.save_screenshot(file_path)

172. except Exception as e:

173. raise e

175. def waitPresenceOfElementLocated(locationType,locatorExpression,*args):

176. """显式等待页面元素出现在DOM中，但不一定可见，存在则返回该页面元素对象"""

177. global waitUtil

178. try:

179. waitUtil.presenceOfElementLocated(locationType,locatorExpression)

180. except Exception as e:

181. raise e

183. def waitFrameToBeAvailableAndSwitchToIt(locationType,locatorExprssion,*args):

184. """检查frame是否存在，存在则切换进frame控件中"""

185. global waitUtil

186. try:

187. waitUtil.frameToBeAvailableAndSwitchToIt(locationType,locatorExprssion)

188. except Exception as e:

189. raise e

191. def waitVisibilityOfElementLocated(locationType,locatorExpression,*args):

192. """显式等待页面元素出现在Dom中，并且可见，存在返回该页面元素对象"""

193. global waitUtil

194. try:

195. waitUtil.visibilityOfElementLocated(locationType,locatorExpression)

196. except Exception as e:

197. raise e

4、在Config目录下存放所有配置文件，比如：日志的配置文件；把所有的项目相关的配置均放到这里，实现配置与代码的分离

日志配置文件

1. [loggers]

2. keys=root,example01,example02

3. [logger_root]

4. level=DEBUG

5. handlers=hand01,hand02

6. [logger_example01]

7. handlers=hand01,hand02

8. qualname=example01

9. propagate=0

10. [logger_example02]

11. handlers=hand01,hand03

12. qualname=example02

13. propagate=0

14. ###############################################

15. [handlers]

16. keys=hand01,hand02,hand03

17. [handler_hand01]

18. class=StreamHandler

19. level=DEBUG

20. formatter=form01

21. args=(sys.stderr,)

22. [handler_hand02]

23. class=FileHandler

24. level=DEBUG

25. formatter=form01

26. args=('AutoTestLog.log', 'a')

27. [handler_hand03]

28. class=handlers.RotatingFileHandler

29. level=INFO

30. formatter=form01

31. args=('AutoTestLog.log', 'a', 10*1024*1024, 5)

32. ###############################################

33. [formatters]

34. keys=form01,form02

35. [formatter_form01]

36. format=%(asctime)s %(filename)s[line:%(lineno)d] %(levelname)s %(message)s

37. datefmt=%Y-%m-%d %H:%M:%S

38. [formatter_form02]

39. format=%(name)-12s: %(levelname)-8s %(message)s

40. datefmt=%Y-%m-%d %H:%M:%S

5、在ProjVar包里面存放项目所有的公共变量，如：目录、自定义变量名称；

1. import os

3. #浏览器驱动存放的位置

4. firefoxDriverFilePath = "e:\\geckodriver"

5. chromeDriverFilePath = "e:\\chromedriver"

6. ieDriverFilePath = "e:\\IEDriverServer"

8. # 当前文件所在目录的父目录的绝对路径

9. ProjDirPath = os.path.dirname(os.path.dirname(os.path.abspath(__file__)))

11. test_step_id_col_no = 0

12. test_step_result_col_no = 8

13. test_step_error_info_col_no = 9

14. test_step_capture_pic_path_col_no = 10

16. test_case_id_col_no= 0

17. test_case_sheet_name=2

18. test_case_is_executed_flag_col_no= 3

19. test_case_is_hybrid_test_data_sheet_col_no=4

21. test_case_start_time_col_no= 6

22. test_case_end_time_col_no= 7

23. test_case_elapsed_time_col_no= 8

24. test_case_result_col_no = 9

26. if __name__=="__mian__":

27. print(ProjDirPath)

6、ScreenCapture目录：所有生成的日志、截屏报告均放在这里

7、TestData目录：存放测试文件

126邮箱联系人.xlsx

8、TestScript包用来创建测试脚本，主程序

1. #encoding=utf-8

3. import re

4. from Util.dir_opration import make_current_date_dir, make_current_hour_dir

5. from Util.Excel import *

6. from Action.PageAction import *

7. import traceback

8. from Util.log import *

10. def get_test_case_sheet(test_cases_excel_path):

11. test_case_sheet_names = []

12. excel_obj = Excel(test_cases_excel_path)

13. excel_obj.set_sheet_by_index(1)

14. test_case_rows = excel_obj.get_rows_object()[1:]

15. for row in test_case_rows:

16. if row[3].value=='y':

17. print(row[2].value)

18. test_case_sheet_names.append((int(row[0].value)+1,row[2].value))

19. return test_case_sheet_names

21. #print(get_test_case_sheet(ProjDirPath+"\\TestData\\126邮箱联系人.xlsx"))

23. def execute(test_cases_excel_path,row_no,test_case_sheet_name):

24. excel_obj = Excel(test_cases_excel_path)

25. excel_obj.set_sheet_by_name(test_case_sheet_name)

26. #获取除第一行之外的所有行对象

27. test_step_rows = excel_obj.get_rows_object()[1:]

28. #拼接开始时间：当前年月日+当前时间

29. start_time = get_current_date_and_time()

30. #开始计时

31. start_time_stamp = time.time()

32. #设置默认用例时执行成功的，如果抛异常则说明用例执行失败

33. test_result_flag = True

34. for test_step_row in test_step_rows:

35. if test_step_row[6].value == "y":

36. test_action = test_step_row[2].value

37. locator_method = test_step_row[3].value

38. locator_exp = test_step_row[4].value

39. test_value = test_step_row[5].value

40. print(test_action,locator_method,locator_exp,test_value)

41. if locator_method is None:

42. if test_value is None:

43. command = test_action + "()"

44. else:

45. command = test_action + "('%s')" %test_value

46. else:

47. if test_value is None:

48. command = test_action + "('%s','%s')" %(locator_method,locator_exp)

49. else:

50. command = test_action + "('%s','%s','%s')" %(locator_method,locator_exp,test_value)

51. print(command)

52. eval(command)

53. #处理异常

54. try:

55. info(command)

56. eval(command)

57. excel_obj.write_cell_value(int(test_step_row[0].value) + 1, test_step_result_col_no, "执行成功")

58. excel_obj.write_cell_value(int(test_step_row[0].value) + 1, test_step_error_info_col_no, "")

59. excel_obj.write_cell_value(int(test_step_row[0].value) + 1, test_step_capture_pic_path_col_no, "")

60. info("执行成功") # 加入日志信息

61. except Exception as e:

62. test_result_flag = False

63. traceback.print_exc()

64. error(command + ":" + traceback.format_exc()) # 加入日志信息

65. excel_obj.write_cell_value(int(test_step_row[0].value) + 1, test_step_result_col_no, "失败", "red")

66. excel_obj.write_cell_value(int(test_step_row[0].value) + 1, test_step_error_info_col_no, \

67. command + ":" + traceback.format_exc())

68. dir_path = make_current_date_dir(ProjDirPath + "\\" + "ScreenCapture\\")

69. dir_path = make_current_hour_dir(dir_path + "\\")

70. pic_path = os.path.join(dir_path, get_current_time() + ".png")

71. capture(pic_path)

72. excel_obj.write_cell_value(int(test_step_row[0].value) + 1, test_step_capture_pic_path_col_no, pic_path)

73. # 拼接结束时间：年月日+当前时间

74. end_time = get_current_date() + " " + get_current_time()

75. # 计时结束时间

76. end_time_stamp = time.time()

77. # 执行用例时间等于结束时间-开始时间；需要转换数据类型int()

78. elapsed_time = int(end_time_stamp - start_time_stamp)

79. # 将时间转换成分钟；整除60

80. elapsed_minutes = int(elapsed_time // 60)

81. # 将时间转换成秒；除60取余

82. elapsed_seconds = elapsed_time % 60

83. # 拼接用例执行时间；分+秒

84. elapsed_time = str(elapsed_minutes) + "分" + str(elapsed_seconds) + "秒"

85. # 判断用例是否执行成功

86. if test_result_flag:

87. test_case_result = "测试用例执行成功"

88. else:

89. test_case_result = "测试用例执行失败"

90. # 需要写入的时第一个sheet

91. excel_obj.set_sheet_by_index(1)

92. # 写入开始时间

93. excel_obj.write_cell_value(int(row_no), test_case_start_time_col_no, start_time)

94. # 写入结束时间

95. excel_obj.write_cell_value(int(row_no), test_case_end_time_col_no, end_time)

96. # 写入执行时间

97. excel_obj.write_cell_value(int(row_no), test_case_elapsed_time_col_no, elapsed_time)

98. # 写入执行结果；

99. if test_result_flag:

100. # 用例执行成功，写入执行结果

101. excel_obj.write_cell_value(int(row_no), test_case_result_col_no, test_case_result)

102. else:

103. # 用例执行失败，用red字体写入执行结果

104. excel_obj.write_cell_value(int(row_no), test_case_result_col_no, test_case_result, "red")

106. # 清理excel记录的结果数据

107. def clear_test_data_file_info(test_data_excel_file_path):

108. excel_obj = Excel(test_data_excel_file_path)

109. excel_obj.set_sheet_by_index(1)

110. test_case_rows = excel_obj.get_rows_object()[1:]

111. for test_step_row in test_case_rows:

112. excel_obj.set_sheet_by_index(1)

113. if test_step_row[test_case_is_executed_flag_row_no].value == "y":

114. excel_obj.write_cell_value(

115. int(test_step_row[test_case_id_col_no].value) + 1, test_case_start_time_col_no, "")

116. excel_obj.write_cell_value(

117. int(test_step_row[test_case_id_col_no].value) + 1, test_case_end_time_col_no, "")

118. excel_obj.write_cell_value(

119. int(test_step_row[test_case_id_col_no].value) + 1, test_case_elapsed_time_col_no, "")

120. excel_obj.write_cell_value(

121. int(test_step_row[test_case_id_col_no].value) + 1, test_case_result_col_no, "")

123. excel_obj.set_sheet_by_name(test_step_row[test_case_sheet_name].value)

124. test_step_rows = excel_obj.get_rows_object()[1:]

125. for test_step_row in test_step_rows:

126. if test_step_row[test_step_id_col_no].value is None:

127. continue

128. excel_obj.write_cell_value(

129. int(test_step_row[test_step_id_col_no].value) + 1, test_step_result_col_no, "")

130. excel_obj.write_cell_value(

131. int(test_step_row[test_step_id_col_no].value) + 1, test_step_error_info_col_no, "")

132. excel_obj.write_cell_value(

133. int(test_step_row[test_step_id_col_no].value) + 1, test_step_capture_pic_path_col_no, "")

135. if __name__ == "__main__":

136. test_data_excel_file_path = ProjDirPath + "\\TestData\\126邮箱联系人.xlsx"

137. print(get_test_case_sheet(test_data_excel_file_path))

138. execute(test_data_excel_file_path,2,"登录")文章来源地址https://www.toymoban.com/news/detail-487794.html