python 数据库查询结果邮件提醒_python读取postgresql数据库并发送相关提醒邮件

代码如下：

#！/usr/bin/env python

import smtplib

from email.mime.text import MIMEText

import psycopg2

import datetime

from time import *

mail_host= "smtp.XXX.com"

mail_user= "XXX"

mail_pass=  "XXX"

mail_postfix="XXX.com"

def send_mail(to_list,sub,content):

me="Remind Email"+""

msg = MIMEText(content,_subtype='plain',_charset='gb2312')

msg['Subject'] = sub

msg['From'] = me

msg['To'] = ";".join(to_list)

try:

server = smtplib.SMTP()

server.CONNECT(mail_host)

server.login(mail_user,mail_pass)

server.sendmail(me, to_list, msg.as_string())

server.close()

return True

except Exception, e:

print str(e)

return False

## 取本地时间与数据库项目时间作比较 ##

today=strftime('%Y-%m-%d',localtime())

today_date=datetime.datetime.strptime(today,'%Y-%m-%d')

## 与postgresql数据库链接 ##

pgdb_conn = psycopg2.CONNECT(database = 'test',user = 'username', password = '123456', host = '1.1.1.1')

pg_cursor = pgdb_conn.cursor()

sql_desc = "select * from tbl_product3"

pg_cursor.execute(sql_desc)

for row in pg_cursor:

date=row[0]

to_list=row[1]

sub=row[2]

content=row[3]

Other_date=datetime.datetime(date,'%Y-%m-%d')

delta=Other_date-today_date

if delta.days == 1:

send_mail(to_list,sub,content)

pg_cursor.close()

pgdb_conn.close()