- #coding=utf-8
- from uliweb.orm import *
- import smtplib
- #SERVER = "localhost"
- db=get_connection("mysql://root:root@localhost/email?charset=utf8")
- class spider_mail(Model):
- mail = Field(str)
- status = Field(str)
- def get_new_email():
- n = spider_mail.get(spider_mail.c.status == '0')
- # n = spider_mail.filter()
- if n:
- # for i in n:
- # print i
- return n.mail
- else:
- print "木有新邮箱"
- def update_email(mail):
- n = spider_mail.get(spider_mail.c.mail == mail)
- n.status = '1'
- n.save()
- def save_email(mail):
- n = spider_mail.get(spider_mail.c.mail == mail)
- if n:
- return
- n = spider_mail()
- n.mail = mail
- n.status = "0"
- n.save()
- db.metadata.create_all()
- #db.metadata.drop_all()
- save_email("1248389788@qq.com")
- count = 0
- def send_email(a,b,c):
- FROM = 'jeapedu001@gmail.com'
- TO = ['591508750@qq.com'] # must be a list
- SUBJECT = b#"wo shi jiangning wo zai ceshi cengxun!"
- # count = count + 1
- TEXT = c
- # Prepare actual message
- message = """\\
- From: %s
- To: %s
- Subject: %s
- %s
- """ % (FROM, ", ".join(TO), SUBJECT, TEXT)
- # Send the mail
- server = smtplib.SMTP('smtp.gmail.com',587)
- server.ehlo()
- server.starttls()
- server.login(FROM,"jn691121")
- server.sendmail(FROM, TO, message)
- server.quit()
- b = raw_input("input your title:")
- c = raw_input("input your content:")
- while 1:
- a = get_new_email()
- print a
- if a == None:
- break
- send_email(a,b,c)
- update_email(a)
- #该片段来自于http://www.codesnippet.cn/detail/090920135739.html
来源: http://www.codesnippet.cn/detail/090920135739.html