2 """Arguments is a list of SQL paterns (will get wrapped in wildcards, %),
3 display uid email and name
7 import datetime, os, re, subprocess, sys, string, random
10 'user': 'licensereader',
11 'password': open('ropass.txt').read().strip(),
14 conn = mysql.connector.connect(**dbconfig)
15 cursor = conn.cursor()
16 raw = open("request-approval.txt").read()
18 # Get dict of matching users
19 for email in sys.argv[1:]:
20 q = ('SELECT users.uid,email,reply,name,count(log.uid) FROM users'
21 ' LEFT JOIN log ON log.uid = users.uid'
22 ' WHERE email like %s GROUP BY email' );
23 pat = '%' + email + '%'
24 cursor.execute(q, (pat,))
26 uid,email,reply,name,count = row
29 print '%d, %s, %s, %d, "%s"' % (uid, email, reply, count, name)