summaryrefslogtreecommitdiffstats
path: root/aurweb/scripts/tuvotereminder.py
diff options
context:
space:
mode:
Diffstat (limited to 'aurweb/scripts/tuvotereminder.py')
-rwxr-xr-xaurweb/scripts/tuvotereminder.py28
1 files changed, 28 insertions, 0 deletions
diff --git a/aurweb/scripts/tuvotereminder.py b/aurweb/scripts/tuvotereminder.py
new file mode 100755
index 00000000..97b1d12e
--- /dev/null
+++ b/aurweb/scripts/tuvotereminder.py
@@ -0,0 +1,28 @@
+#!/usr/bin/python3
+
+import subprocess
+import time
+
+import aurweb.config
+import aurweb.db
+
+notify_cmd = aurweb.config.get('notifications', 'notify-cmd')
+
+
+def main():
+ conn = aurweb.db.Connection()
+
+ now = int(time.time())
+ filter_from = now + 500
+ filter_to = now + 172800
+
+ cur = conn.execute("SELECT ID FROM TU_VoteInfo " +
+ "WHERE End >= ? AND End <= ?",
+ [filter_from, filter_to])
+
+ for vote_id in [row[0] for row in cur.fetchall()]:
+ subprocess.Popen((notify_cmd, 'tu-vote-reminder', str(vote_id))).wait()
+
+
+if __name__ == '__main__':
+ main()