菁英科技(卓目鸟学苑)- 专注软件测试菁英教育
标题: selenium--贺威栋-2021.03.02 [打印本页]
作者: I5029 时间: 2021-3-2 19:54
标题: selenium--贺威栋-2021.03.02
from email.mime.multipart import MIMEMultipart
from email.mime.text import MIMEText
import smtplib
# 设置邮件服务器地址
smtpserver = 'smtp.163.com'
# 设置邮件服务器端口号
port = 25
# 发件人地址
sender = 'jingying0037@163.com'
# 密码或授权码
password = 'AVNCNFWSUJQEALFA'
# 收件人
receivers = 'BLN1632498232@163.com'
# 创建邮件对象
mail = MIMEMultipart()
# 初始化发件人
mail['from'] = sender
# 添加收件人
mail['to'] = receivers
# 添加主题
mail['subject'] = 'Ranzhi自动化测试报告'
# 读取附件
path = 'selenium/ranzhi/report/report_2021-03-02_16-35-57.html'
with open(path, 'rb') as file:
report = file.read()
# 对附件进行编码
attachment = MIMEText(report, 'base64','utf-8')
# 设置附件的类型
attachment['Content-Type'] = 'application/octet-stream'
# 设置附件的处理方式
attachment['Content-Disposition'] = 'attachment;filename=%s'%path.split('/')[-1]
# 添加附件
mail.attach(attachment)
# 生成邮件正文
# 对邮件正文进行编码
body = MIMEText(content,'html','utf-8')
# 添加正文
mail.attach(body)
# 创建SMTP对象
smtp = smtplib.SMTP()
# 连接服务器
smtp.connect(smtpserver,port)
# 登录服务器
smtp.login(sender,password)
# 发送邮件
smtp.sendmail(sender,receivers.split(';'),mail.as_string())
# 关闭服务器
smtp.close()
print('邮件发送完毕!')
import openpyxl
# 打开工作部workbook
workbook = openpyxl.load_workbook(r'selenium\ranzhi\data\data.xlsx')
# 获取指定的工作表worksheet
worksheet = workbook['login_success']
# 方法一
# a = []
# for row in worksheet:
# r = []
# for c in row:
# # c.value 获取单元格的内容
# r.append(c.value)
# a.append(tuple(r))
# print(a)
# 方法二:列表生成式
a = [tuple(c.value for c in row) for row in worksheet]
print(a)
from page.adduser_page import AddUserPage
from page.login_page import LoginPage
from base.util import BoxDriver
class AddUserTest:
'''添加用例'''
def test(self):
driver = BoxDriver('http://localhost/ranzhi/www/sys/admin/')
addUserPage = AddUserPage(driver)
addUserPage.login()
addUserPage.add_user()
if __name__ == '__main__':
AddUserTest().test()
from page.login_page import LoginPage
from base.util import BoxDriver,GetExcel
import unittest
from parameterized import parameterized
class LoginTest(unittest.TestCase):
@classmethod
def setUpClass(self):
self.driver = BoxDriver('http://localhost/ranzhi/www/sys/user-login.html')
self.page = LoginPage(self.driver)
@classmethod
def tearDownClass(self):
self.driver.quit()
@parameterized.expand(GetExcel().get(r'selenium\ranzhi\data\data.xlsx','login_success'))
def test_login_successful(self,user,pwd):
'''登陆成功测试用例'''
self.page.login(user,pwd)
# 断言
realname = self.page.get_realname()
self.assertEqual(realname,user,'登陆失败')
self.page.logout()
def test_login_fail(self):
'''登陆失败测试用例'''
# self.page.login('user1','1234567')
# self.page.confirm()
# self.page.login('user2','1234567')
# self.page.confirm()
# self.page.login('user3','1234567')
# self.page.confirm()
pass
if __name__ == "__main__":
unittest.main()
from base.HTMLTestRunner import HTMLTestRunner
import unittest,time
class TestRunner:
def runner(self):
# 实例化测试套件
suite = unittest.TestSuite()
# 添加测试用例
suite.addTests(unittest.TestLoader().discover('selenium/ranzhi/test/',pattern='login_test.py'))
# 创建一个时间戳
pre = time.strftime("%Y-%m-%d_%H-%M-%S")
# 创建报告文件
report = open('selenium/ranzhi/report/report_%s.html'%pre,mode='wb')
# 创建用例运行器
test_runner = HTMLTestRunner(stream=report,title='Ranzhi自动化测试报告',description='报告的详细内容...')
# 运行报告
test_runner.run(suite)
# 发送报告
if __name__ == '__main__':
TestRunner().runner()
欢迎光临 菁英科技(卓目鸟学苑)- 专注软件测试菁英教育 (http://www.zmnxy.com/) |
Powered by Discuz! X3.4 |