From 0a372d651f8cdb8ab5f0442060104caef8319f18 Mon Sep 17 00:00:00 2001 From: Arnaud Delcasse Date: Wed, 12 Sep 2012 11:33:01 +0200 Subject: [PATCH] Reminder every week before the end of the vote --- reminder.py | 11 ++++++++++- 1 file changed, 10 insertions(+), 1 deletion(-) diff --git a/reminder.py b/reminder.py index 1dd6de4..007487f 100644 --- a/reminder.py +++ b/reminder.py @@ -18,7 +18,16 @@ for vote in c.execute('select id, id_group, date_end, title from votes where is_ date_today = datetime.today() date_begin_reminder = date_end_vote + timedelta(days=-3) - if date_today >= date_begin_reminder and date_today <= date_end_vote: + date_cursor = date_today + is_anniversary = False + while not is_anniversary and date_cursor <= date_end_vote: + date_cursor = date_cursor + timedelta(days=7) + print date_cursor + if date_cursor >= date_end_vote and date_cursor <= date_end_vote + timedelta(days=1): + print "Is anniversary" + is_anniversary = True + + if date_today >= date_begin_reminder and date_today <= date_end_vote or is_anniversary: voting_group = (vote[1],) for user in c.execute('select users.id, users.email, users.name from users join user_group on users.id=user_group.id_user where user_group.id_group = ?', voting_group).fetchall(): userchoice_request = (user[0], vote[0],) -- 2.20.1