def check_file(self): reportpath = os.path.join(getPath.get_basepath(), 'result', 'report.html') if os.path.isfile(reportpath) and not os.stat(reportpath) == 0: return True else: return False
def __init__(self): global logPath, resultPath, proDir proDir = getPath.get_basepath() resultPath = os.path.join(proDir, "result") # create result file if it doesn't exist if not os.path.exists(resultPath): os.mkdir(resultPath) # defined test result file name by localtime logPath = os.path.join(resultPath, str(datetime.now().strftime("%Y%m%d%H%M%S"))) # create test result file if it doesn't exist if not os.path.exists(logPath): os.mkdir(logPath) # defined logger self.logger = logging.getLogger() # defined log level self.logger.setLevel(logging.INFO) # defined handler handler = logging.FileHandler(os.path.join(logPath, "out.log")) # defined formatter formatter = logging.Formatter( '%(asctime)s - %(name)s - %(levelname)s - %(message)s') # defined formatter handler.setFormatter(formatter) # add handler self.logger.addHandler(handler)
def config_file(self): #如果有文件,就配置邮件附件 filename 用英文形式,如果用中文 需要改动 if self.check_file(): htmlpath = os.path.join(getPath.get_basepath(),'result','report.html') html = open(htmlpath,'rb').read() filehtml = MIMEText(html,'base64','utf-8') filehtml['Content-Type'] = 'application/octet-stream' filehtml['Content-Disposition'] = 'attachment; filename="test.html"' self.msg.attach(filehtml)
import os import getPath from xlrd import open_workbook basepath = getPath.get_basepath() class ReadExcel(): def get_xls(self,xls_name,sheet_name): cls = [] #拼接文件路径 xlsPath = os.path.join(basepath,'test_file','case',xls_name) #打开文件 login.xls file = open_workbook(xlsPath) #获取sheet 也就是 login.xls文件的 sheet名字 sheet = file.sheet_by_name(sheet_name) #获取行数 nrows = sheet.nrows for i in range(nrows): if sheet.row_values(i)[0] != u'case_name': #获取整行 整列的值 返回必须是数字 所以上面有空的 cls数组 cls.append(sheet.row_values(i)) return cls
import os import configparser import getPath as getpath #获取文件路径 basepath = getpath.get_basepath() config_path = os.path.join(basepath, 'config\config.ini') config = configparser.ConfigParser() config.read(config_path) class ReadConfig(): #获取名字为 [HTTP] 的属性值 def get_http(self, name): value = config.get('HTTP', name) return value def get_email(self, name): value = config.get('EMAIL', name) return value def get_database(self, name): value = config.get('DATABASE', name) return value