From ed210a3988c9182f818221bbea7d63346bb2d3c5 Mon Sep 17 00:00:00 2001 From: Arnaud Delcasse Date: Wed, 12 Sep 2012 08:07:55 +0200 Subject: [PATCH] Remind nonvoters --- reminder.py | 45 +++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 45 insertions(+) create mode 100644 reminder.py diff --git a/reminder.py b/reminder.py new file mode 100644 index 0000000..5b66d8f --- /dev/null +++ b/reminder.py @@ -0,0 +1,45 @@ +import os +import hashlib +import smtplib +import string +from datetime import time, date, timedelta + +from settings import * + + +import sqlite3 + +conn = sqlite3.connect(DATABASE) +c = conn.cursor() + +for vote in c.execute('select id, id_group, date_end, title from votes where is_open=1 and is_terminated=0'): + print vote[0] + date_end_vote = date.fromtimestamp(vote[2]) + date_today = date.today + date_begin_reminder = date_end_vote + timedelta(days=-3) + + if date_today >= date_begin_reminder and date_today <= date_end_vote: + voting_group = (vote[1],) + for user in c.executequery('select user.id, users.email, users.name from users join user_group on users.id=user_group.id_user where user_group.id_group = ?', voting_group): + userchoice_request = (user[0], vote[1],) + userchoice = c.executequery('select * from user_choice where id_user = ? and id_vote = ?', userchoice_request) + if userchoice is None: + #user didn't vote yet + link = "http://vote.ffdn.org/vote/%d" % vote[0] + BODY = string.join(( + "From: %s" % EMAIL, + "To: %s" % user[1], + "Subject: [Cavote] Vote reminder", + "Date: %s" % time.strftime("%a, %d %b %Y %H:%M:%S +0000", time.gmtime()).decode('utf-8'), + "X-Mailer: %s" % VERSION, + "", + "A vote concerns you and is going to finish on %s : %s" % vote[2]%vote[3], + "", + "This link will bring you to the form where you will be able to participate :", + link, + "", + "If you think this mail is not for you, please ignore and delete it." + ), "\r\n") + server = smtplib.SMTP(SMTP_SERVER) + server.sendmail(EMAIL, user[1], BODY) + server.quit() -- 2.20.1