def setupHandlers(self):
try:
self.mailBuffer = MailSender.MailSender()
except:
QtGui.QMessageBox.information(
self, "Warning",
"Could not enstablish SMTP connection. Check your port routing."
)
time.sleep(1.5)
QtGui.qApp.quit()
self.checkBox_2.setChecked(True)
self.settings = self.initLines()
self.mailingList = self.updateMailingList()
self.agentsData = sorted(self.getLists(), key=lambda tup: tup[3])
self.filtered = []
displayAll = lambda: self.displayAgents(self.agentsData)
sendMail = lambda: self.sendMessage(self.treeWidget.selectedItems())
self.retranslateUi(MainWindow)
QtCore.QMetaObject.connectSlotsByName(MainWindow)
self.pushButton_8.clicked.connect(displayAll)
self.pushButton_3.clicked.connect(sendMail)
self.lineEdit.textChanged.connect(self.filterSort) # type
self.lineEdit_2.textChanged.connect(self.filterSort) # days
self.lineEdit_3.textChanged.connect(self.filterSort) # days
self.lineEdit_4.textChanged.connect(self.filterSort) # date
self.lineEdit_5.textChanged.connect(self.filterSort) # job
self.lineEdit_6.textChanged.connect(self.filterSort) # name
self.pushButton_7.clicked.connect(self.sendAllMessages)
self.checkBox.stateChanged.connect(self.filterSort)
self.commandLinkButton.clicked.connect(self.openExcelFile)
self.actionExit.triggered.connect(app.quit)
self.checkBox_2.stateChanged.connect(self.filterSort)
self.filterSort(31)
def insert_data():
ins = InsertData()
ins.delte_data_by_collect_date(g_date)
fileList = os.listdir('.')
outList = list()
attList = list()
for file in fileList:
if file.endswith(".csv") and file.startswith(g_date):
attList.append(file)
pFile = open(file, 'r')
contentList = pFile.readlines()
for item in contentList:
if '数据来源' in item:
continue
tmpList = item.strip().split(',')
outList.append([
tmpList[0], tmpList[1], tmpList[2], tmpList[3], tmpList[4],
tmpList[5]
])
ins.insert_data(outList)
ins.close_db()
#发送邮件
mail_sender = MailSender()
mail_list = ['*****@*****.**'] #收件人(列表)
mail_sender.send(mail_list, "每日手机价格数据自动推送", attList)
def monitoringSendMail( rulesResult ):
mailSender=MailSender()
mailSender.setReportMail(config.reportMail)
mailSender.setMailFrom(config.mailFrom)
mailSender.setMailServer(config.mailServer)
mailSender.setMailPort(config.mailPort)
mailSender.setMailUser(config.mailUser)
mailSender.setMailPassword(config.mailPassword)
mailSender.send('Monitoring report', startTime+"\n"+rulesResult+"\n"+log.getAll())
return
def send_mail():
fileList = os.listdir('.')
attList = list()
for file in fileList:
if file.endswith(".csv") and file.startswith(g_date):
attList.append(file)
#发送邮件
mail_sender = MailSender()
mail_list = ['*****@*****.**'] #收件人(列表)
mail_sender.send(mail_list, '每周美的价格数据自动推送', attList)
def sendMessageHelper(self, item):
agent = item[0]
name = agent.text(0)
date = agent.text(2)
delta = agent.text(3)
type = agent.text(4)
if type.__contains__("Annual"):
type += " Review"
if not self.mailBuffer:
self.mailBuffer = MailSender.MailSender()
message = "Agent " + name + " is due for his/hers " + type + " in " + delta + " days." \
"The review is scheduled for " + date
for i in self.mailingList:
self.mailBuffer.sendEmail(name, delta, str(message), i)
def __init__(self, dbName=None):
QRunnable.__init__(self)
if (dbName):
self.db=dbName
else:
self.db = "BoLa"
self.projectPath = os.path.dirname(os.path.dirname(os.path.abspath(__file__)))
self.categories = {"ALTA": 1, "MEDIA": 1, "BAJA": 1}
self.categoriesPath = self.projectPath+"/Categories"
self.setDb(self.db)
if not os.path.exists(self.categoriesPath):
os.makedirs(self.categoriesPath)
self.signals = HaploSignal()
self.option="compare"
self.newDb=None
self.mailsvc = Mail.MailSender()
def DuplicateFileRemoval(path, mid, starttime):
dire = os.path.abspath("MADS")
if os.path.isdir(dire) == False:
os.makedirs(dire)
filename = os.path.join(dire, "Logfile%s.txt" % time.time())
fobj = open(filename, 'w')
dup = {}
for folder, subfolder, files in os.walk(path):
for fname in files:
fname = os.path.join(folder, fname)
checksum = hashfile(fname)
if checksum in dup:
dup[checksum].append(fname)
else:
dup[checksum] = [fname]
result = list(filter(lambda x: len(x) > 1, dup.values()))
fcnt = 0
icnt = 0
dfile = 0
if len(result) == 0:
fobj.write("No Duplicate files")
else:
fobj.write("Duplicate files are :" + "\n")
for s in result:
icnt = 0
for f in s:
fcnt += 1
icnt += 1
if icnt > 1:
dfile += 1
fobj.write(f + "\n\n")
os.remove(f)
fobj.close()
body = """Hello ,Starting time of scanning: %s. Total number of files scanned: %s. Total number of duplicate files found: %s """ % (
starttime, fcnt, dfile)
if is_connected():
MailSender(mid, filename, body, starttime)
else:
print("Internet connection is off")
def event_trigger(event):
"""
event trigger function. trigger event information, judge whether
is happened.
trigger time interval get from event.time_trigger, global variable
time_trigger or 60 seconds.
:param event: object init from class EventBase
:return: None
"""
while True:
event.pre_step()
try:
is_happened = event.is_event_happened()
if is_happened:
event.create_email_msg()
if dry_run is False:
ms = MailSender.MailSender()
ms.mail_send(event.msg, event.user_to, event.user_cc,
event.attachment)
except Exception as e:
logger.error("error happened when trigger event[%s], error %s.",
event.name, e)
is_happened = True
event.err_msg = e
finally:
event.post_step()
if is_happened:
if event.err_msg == "":
logger.info("Event[%s] trigger.", event.name)
if event.err_msg != "" or not event.re_trigger:
return
if event.time_interval is not None:
time.sleep(event.time_interval)
elif time_interval is not None:
time.sleep(time_interval)
else:
time.sleep(60)
import web_search
import MailSender
proba = MailSender.MailSender()
proba.sendmail('pajton', 'cao ja sam pajtonnn', '*****@*****.**')
def setUp(self):
self.ms = MailSender.MailSender()
