2 """finduser [flags] pattern...
7 Arguments is a list of SQL paterns (will get wrapped in wildcards, %),
8 by default display full information as CSV.
11 import mysql.connector
12 import datetime, os, re, subprocess, sys, string, random
16 'user': 'licensereader',
17 'password': open('ropass.txt').read().strip(),
20 conn = mysql.connector.connect(**dbconfig)
21 cursor = conn.cursor()
24 opts, args = getopt.getopt(sys.argv[1:], "1")
32 q = ('SELECT users.uid,email,reply,name,count(log.uid) FROM users'
33 ' LEFT JOIN log ON log.uid = users.uid'
34 ' WHERE email like %s GROUP BY email' )
36 pat = '%' + email + '%'
37 cursor.execute(q, (pat,))
39 uid,email,reply,name,count = row
45 print '%d, %s, %s, %d, "%s"' % (uid, email, reply, count, name)