2 """approved [flags] args...
5 -c text... Comment to use
8 -v List emails as processed
10 Args is a list of email addresses.
13 import datetime, mysql.connector, os, re, subprocess, sys
19 'password': open('rwpass.txt').read().strip(),
22 conn = mysql.connector.connect(**dbconfig)
23 cursor = conn.cursor()
29 opts, args = getopt.getopt(sys.argv[1:], "c:hrv")
41 q = 'SELECT uid FROM users WHERE email = %s'
42 update = ("UPDATE users SET date_replied=%s, reply=%s, comment=%s"
44 today = datetime.datetime.today().date()
47 cursor.execute(q, (email,))
49 cursor.execute(update, (today, reply, comment, uid[0]))