X-Git-Url: http://git.cyclocoop.org/?p=cavote.git;a=blobdiff_plain;f=reminder.py;h=ff75f99c03ac27dd916daf83c93cc047897b7478;hp=5d2ea7b05e0a37344d572508de8b410667cf05b0;hb=473c73474dbf1dc5b789a847e924599f313c6fcd;hpb=30803d5fea0865639ac79298c0820f6165608ff6 diff --git a/reminder.py b/reminder.py index 5d2ea7b..ff75f99 100644 --- a/reminder.py +++ b/reminder.py @@ -32,7 +32,7 @@ for vote in c.execute('select id, id_group, date_end, title from votes where is_ 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],) userchoice = c.execute('select * from user_choice join choices on user_choice.id_choice = choices.id where id_user = ? and id_vote = ?', userchoice_request).fetchone() - print "Checking if user %s already voted %s" % (user[1], vote[3].encode('utf-8')) + print "Checking if user %s already voted %s" % (user[1].encode('utf-8'), vote[3].encode('utf-8')) print userchoice if userchoice is None: #user didn't vote yet @@ -45,7 +45,7 @@ for vote in c.execute('select id, id_group, date_end, title from votes where is_ "Content-type: text/plain; charset=utf-8", "X-Mailer: %s" % VERSION, "", - "%s %s : %s" % (gettext(u"A vote concerns you and is going to terminate on"), vote[2], vote[3].encode('utf-8')), + "%s %s : %s" % (gettext(u"A vote concerns you and is going to terminate on"), vote[2].encode('utf-8'), vote[3].encode('utf-8')), gettext(u"You still didn't take part to it !"), "", gettext(u"This link will bring you to the form where you will be able to participate :"), @@ -68,7 +68,7 @@ for vote in c.execute('select id, id_group, date_end, title from votes where is_ "Content-type: text/plain; charset=utf-8", "X-Mailer: %s" % VERSION, "", - "%s %s : %s" % (gettext(u"A vote concerns you and is going to terminate on "), vote[2], vote[3].encode('utf-8')), + "%s %s : %s" % (gettext(u"A vote concerns you and is going to terminate on "), vote[2].encode('utf-8'), vote[3].encode('utf-8')), gettext(u"You have already voted but you can still modify your choice"), "", gettext(u"This link will bring you to the form where you will be able to participate :"),