5 from datetime
import time
, date
, timedelta
12 conn
= sqlite3
.connect(DATABASE
)
15 for vote
in c
.execute('select id, id_group, date_end, title from votes where is_open=1 and is_terminated=0'):
17 date_end_vote
= date
.fromtimestamp(vote
[2])
18 date_today
= date
.today
19 date_begin_reminder
= date_end_vote
+ timedelta(days
=-3)
21 if date_today
>= date_begin_reminder
and date_today
<= date_end_vote
:
22 voting_group
= (vote
[1],)
23 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
):
24 userchoice_request
= (user
[0], vote
[1],)
25 userchoice
= c
.executequery('select * from user_choice where id_user = ? and id_vote = ?', userchoice_request
)
26 if userchoice
is None:
28 link
= "http://vote.ffdn.org/vote/%d" % vote
[0]
32 "Subject: [Cavote] Vote reminder",
33 "Date: %s" % time
.strftime("%a, %d %b %Y %H:%M:%S +0000", time
.gmtime()).decode('utf-8'),
34 "X-Mailer: %s" % VERSION
,
36 "A vote concerns you and is going to finish on %s : %s" % vote
[2]%vote
[3],
38 "This link will bring you to the form where you will be able to participate :",
41 "If you think this mail is not for you, please ignore and delete it."
43 server
= smtplib
.SMTP(SMTP_SERVER
)
44 server
.sendmail(EMAIL
, user
[1], BODY
)