2 """finduser [flags] pattern...
6 -f Also print the comment
8 Arguments is a list of SQL paterns (will get wrapped in wildcards, %),
9 by default display full information as CSV.
12 import mysql.connector
13 import datetime, os, re, subprocess, sys, string, random
17 'user': 'licensereader',
18 'password': open('ropass.txt').read().strip(),
21 conn = mysql.connector.connect(**dbconfig)
22 cursor = conn.cursor()
26 opts, args = getopt.getopt(sys.argv[1:], "1f")
36 q = ('SELECT users.uid,email,reply,name,count(log.uid),comment FROM users'
37 ' LEFT JOIN log ON log.uid = users.uid'
38 ' WHERE email like %s GROUP BY email' )
40 pat = '%' + email + '%'
41 cursor.execute(q, (pat,))
43 uid,email,reply,name,count,comment = row
49 print '%d, %s, %s, %d, "%s"' % (uid, email, reply, count, name)