python读取文件参数_Python 通过配置文件 读取参数进行

#runtest.py

importsmtplibimportunittestimporttimeimportxlrdimportosfrom HTMLTestRunner importHTMLTestRunnerfrom email.header importHeaderfrom email.mime.text importMIMEText

#导入baseinfoimportbaseinfofrom email.mime.multipart importMIMEMultipartdefget_sender():

filePath= os.path.join(os.getcwd(),‘user_info‘)print("get_sender")print(filePath)

fileName= filePath + ‘\Mail_info.xlsx‘

print(fileName)

readExcel=xlrd.open_workbook(fileName)

sender= readExcel.sheet_by_name(‘sender‘)

get_sender= sender.row_values(1)#print(get_sender)

returnget_senderdefget_Receiver():

filePath= os.path.join(os.getcwd(),‘user_info‘)

fileName= filePath + ‘\Mail_info.xlsx‘

print("get_Receiver()")print(fileName)

readExcel=xlrd.open_workbook(fileName)

receiver_sheet= readExcel.sheet_by_name(‘receiver‘)

receiver_temp=receiver_sheet.col_values(0)

getReceiver= receiver_temp[1:]print(getReceiver)print(type(getReceiver))returngetReceiverdefget_NewReport(testreport):

dirs=os.listdir(testreport)

dirs.sort()

newreportname= dirs[-1]print(‘The new report name: {0}‘.format(newreportname))

file_new=os.path.join(testreport, newreportname)print(file_new)returnfile_newdefsend_Mail(file_new):

f= open(file_new, ‘rb‘)#读取测试报告正文

mail_body =f.read()

f.close()

try:

#通过 baseinfo 引用 __init__ 初始化的参数值

smtp= smtplib.SMTP(baseinfo.Smtp_Server, 25)

sender=baseinfo.Smtp_Sender

password=baseinfo.Smtp_Sender_Password

receiver=baseinfo.Smtp_Receiver

smtp.login(sender, password)

msg=MIMEMultipart()#编写html类型的邮件正文，MIMEtext()用于定义邮件正文

#发送正文

text= MIMEText(mail_body, ‘html‘, ‘utf-8‘)

text[‘Subject‘] = Header(‘自动化测试报告‘, ‘utf-8‘)

msg.attach(text)#发送附件

#Header()用于定义邮件标题

msg[‘Subject‘] = Header(‘自动化测试报告‘, ‘utf-8‘)

msg_file= MIMEText(mail_body, ‘html‘, ‘utf-8‘)

msg_file[‘Content-Type‘] = ‘application/octet-stream‘msg_file["Content-Disposition"] = ‘attachment; filename="TestReport.html"‘msg.attach(msg_file)#定义发件人，如果不写，发件人为空

msg[‘From‘] =sender#定义收件人，如果不写，收件人为空

msg[‘To‘] = ",".join(receiver)

tmp =smtp.sendmail(sender, receiver, msg.as_string())print(receiver)

print(tmp)

smtp.quit()returnTrueexceptsmtplib.SMTPException as e:print(str(e))returnFalseif __name__ == ‘__main__‘:

test_dir= os.path.join(os.getcwd(),‘test_case‘)print(test_dir)

report_dir= os.path.join(os.getcwd(),‘report‘)

test_discover= unittest.defaultTestLoader.discover(test_dir,pattern=‘test*.py‘)print("test_discover")

now= time.strftime("%Y-%m-%d-%H_%M_%S")

filename= report_dir+‘/result-‘+now+‘.html‘fp= open(filename, ‘wb‘)

runner= HTMLTestRunner(stream = fp, title = ‘UI自动化测试报告‘, description = ‘用例执行情况‘)#runner = unittest.TextTestRunner()

runner.run(test_discover)

fp.close()

new_report=get_NewReport(report_dir)

mail=send_Mail(new_report)ifmail:print("发送成功！")else:print("发送失败！")