1 #-*- coding=utf-8 -*-
2 __author__ = 'Fighter.Lu'
3
4 import xlrd
5 import logging,os
6
7 class Helper(object):
8
9 def readExcles(self,rowx):
10 '''
11 rowx是行数
12 :param rowx:
13 :return: 返回的每一个行的行数
14 '''
15 book = xlrd.open_workbook(r'D:projectPOdatainfo.xlsx', 'r')
16 table = book.sheet_by_index(0)
17 return table.row_values(rowx)
18
19 def readusername(self,rowx):
20 '''
21 rowx返回的是第几行的用户名
22 :param rowx:
23 :return:
24 '''
25 return str(self.readExcles(rowx)[0])
26
27 def readpassword(self,rowx):
28 '''
29 rowx返回的是第几行的密码
30 :param rowx:
31 :return:
32 '''
33 return self.readExcles(rowx)[1]
34
35 def exceptText(self,rowx):
36 '''
37 rowx返回的第几行的预期结果
38 :param rowx:
39 :return:
40 '''
41 return self.readExcles(rowx)[2]
42
43 def dirname(self,filename,filepath='data'):
44 '''
45 :param filename:文件名字
46 :param filepath: 文件路径
47 :return:
48 '''
49 return os.path.join(os.path.dirname(os.path.dirname(__file__)),filepath,filename)
50
51
52 def log(self,log_content):
53 '''定义log日志级别'''
54 # 定义文件
55 logFile = logging.FileHandler(self.dirname('logData.txt'), 'a',encoding='utf-8')
56 # log格式
57 fmt = logging.Formatter(fmt='%(asctime)s-%(name)s-%(levelname)s-%(module)s:%(message)s')
58 logFile.setFormatter(fmt)
59 # 定义日志
60 logger1 = logging.Logger('logTest',level=logging.DEBUG)
61 logger1.addHandler(logFile)
62 logger1.info(log_content)
63 logFile.close()