Randol
2020-12-23T05:54:41+00:00
from selenium import webdriver
from selenium.webdriver.common.action_chains import ActionChains
from time import sleep
import pymouse
from collections import Counter
import smtplib
from email.mime.text import MIMEText
from selenium.webdriver.chrome.options import Options
import time
import pykeyboard
from selenium.common.exceptions import NoSuchElementException
import logging
import os
logger = logging.getLogger()
logger.setLevel(logging.DEBUG)
rq = time.strftime('%Y-%m-%d-%H-%M-%S',time.localtime(time.time()))
log_path = os.getcwd() + '/Logs/'
log_name = log_path + rq + '.log'
filehandler = logging.FileHandler(log_name)
filehandler.setLevel(logging.INFO)
streamhandler = logging.StreamHandler()
streamhandler.setLevel(logging.INFO)
formatter = logging.Formatter('%(asctime)s - %(filename)s[line:%(lineno)s] - %(levelname)s : %(message)s')
filehandler.setFormatter(formatter)
streamhandler.setFormatter(formatter)
logger.addHandler(filehandler)
logger.addHandler(streamhandler)
while 1>0:
driver = webdriver.Chrome()
driver.implicitly_wait(30)
driver.get('https://xxxxxxxx/company/participant_projects?from=left_tree2')
pm = pymouse.PyMouse()
pk = pykeyboard.PyKeyboard()
actions = ActionChains(driver)
host = 'smtp.qq.com'
user = 'xxxx@qq.com'
password = 'xxxx'
sender = 'xxxx@qq.com'
recevier = 'xxxx@qq.com'
driver.find_element('id','username').send_keys('xxxx')
driver.find_element('id','password_input').send_keys("xxxx")
driver.find_element('id','tcloud_login_button').click()
driver.get('https://xxxxxxxx/21711231/bugtrace/bugreports/my_view?filter=true&conf_id=1121711231001015619&data[Filter][status][]=resolved&data[Filter][status][]=rejected&data[Filter][reporter]=%5B1121711231001000003%5D%3B&qksearch=true&qksearch=true')
#bugs = driver.find_elements('css selector','[class="rowNOTdone"]')
conductor = driver.find_elements('xpath', '//tr[@class="rowNOTdone"]/td[13]/span')
try:
driver.find_element('xpath', '//tr[@class="rowNOTdone"]/td[13]/span')
except NoSuchElementException as e:
conductor = []
logger.info('找不到任何未完成的工作条目'+str(e))
conductor_list = []
if len(conductor) > 0:
for i in conductor:
conductor_list.append(i.get_attribute('title'))
rq = time.strftime('%m/%d %H:%M',time.localtime(time.time()))
conductor_dict = dict(Counter(conductor_list))
msg = MIMEText(str(conductor_dict),'plain','utf-8')
msg['Subject'] = rq + ' ' + '尽快执行未完成的工作'
msg['From'] = sender
msg['To'] = recevier
try:
smtp = smtplib.SMTP()
smtp.connect(host)
smtp.login(user,password)
smtp.sendmail(sender,recevier,msg.as_string())
smtp.quit()
logger.info('成功发送了邮件')
except smtplib.SMTPException as e:
logger.error('发送邮件失败')
driver.quit()
sleep(1200)
from selenium.webdriver.common.action_chains import ActionChains
from time import sleep
import pymouse
from collections import Counter
import smtplib
from email.mime.text import MIMEText
from selenium.webdriver.chrome.options import Options
import time
import pykeyboard
from selenium.common.exceptions import NoSuchElementException
import logging
import os
logger = logging.getLogger()
logger.setLevel(logging.DEBUG)
rq = time.strftime('%Y-%m-%d-%H-%M-%S',time.localtime(time.time()))
log_path = os.getcwd() + '/Logs/'
log_name = log_path + rq + '.log'
filehandler = logging.FileHandler(log_name)
filehandler.setLevel(logging.INFO)
streamhandler = logging.StreamHandler()
streamhandler.setLevel(logging.INFO)
formatter = logging.Formatter('%(asctime)s - %(filename)s[line:%(lineno)s] - %(levelname)s : %(message)s')
filehandler.setFormatter(formatter)
streamhandler.setFormatter(formatter)
logger.addHandler(filehandler)
logger.addHandler(streamhandler)
while 1>0:
driver = webdriver.Chrome()
driver.implicitly_wait(30)
driver.get('https://xxxxxxxx/company/participant_projects?from=left_tree2')
pm = pymouse.PyMouse()
pk = pykeyboard.PyKeyboard()
actions = ActionChains(driver)
host = 'smtp.qq.com'
user = 'xxxx@qq.com'
password = 'xxxx'
sender = 'xxxx@qq.com'
recevier = 'xxxx@qq.com'
driver.find_element('id','username').send_keys('xxxx')
driver.find_element('id','password_input').send_keys("xxxx")
driver.find_element('id','tcloud_login_button').click()
driver.get('https://xxxxxxxx/21711231/bugtrace/bugreports/my_view?filter=true&conf_id=1121711231001015619&data[Filter][status][]=resolved&data[Filter][status][]=rejected&data[Filter][reporter]=%5B1121711231001000003%5D%3B&qksearch=true&qksearch=true')
#bugs = driver.find_elements('css selector','[class="rowNOTdone"]')
conductor = driver.find_elements('xpath', '//tr[@class="rowNOTdone"]/td[13]/span')
try:
driver.find_element('xpath', '//tr[@class="rowNOTdone"]/td[13]/span')
except NoSuchElementException as e:
conductor = []
logger.info('找不到任何未完成的工作条目'+str(e))
conductor_list = []
if len(conductor) > 0:
for i in conductor:
conductor_list.append(i.get_attribute('title'))
rq = time.strftime('%m/%d %H:%M',time.localtime(time.time()))
conductor_dict = dict(Counter(conductor_list))
msg = MIMEText(str(conductor_dict),'plain','utf-8')
msg['Subject'] = rq + ' ' + '尽快执行未完成的工作'
msg['From'] = sender
msg['To'] = recevier
try:
smtp = smtplib.SMTP()
smtp.connect(host)
smtp.login(user,password)
smtp.sendmail(sender,recevier,msg.as_string())
smtp.quit()
logger.info('成功发送了邮件')
except smtplib.SMTPException as e:
logger.error('发送邮件失败')
driver.quit()
sleep(1200)
[img]https://img.nga.178.com/attachments/mon_202012/31/-7Q5-bzf0KfT3cSq1-42.jpg[/img]
[img]https://img.nga.178.com/attachments/mon_202012/31/-7Q5-248yK7T3cSsg-11.jpg[/img]