#!/usr/bin/env python
# -*- coding: utf-8 -*-

import os, sys
sys.path.append(os.path.dirname(__file__))
import dbutil

conn = dbutil.connect()
c = conn.cursor()

c.execute('''select submitter_name from comments_comment''')

reviewers = {}

mappings = {
    u'alejandro "tab-lover" dubrovsky': u'Alejandro Dubrovsky',
    u'alex hirzel <ahirzel@mtu.edu>': u'Alex Hirzel',
    u'anonymous coward': u'Anonymous',
    u'arthur van leeuwen': u'Arthur van Leeuwen',
    u'augustss': u'Lennart Augustsson',
    u'ed t': u'Anonymous',
    u'geogre moschovitis': u'George Moschovitis',
    u'george m': u'George Moschovitis',
    u'haskell newb': u'Anonymous',
    u'j. pablo fernandez': u'J. Pablo Fernández',
    u'kamal al-marhoobi': u'Kamal Al-Marhubi',
    u'kevin w.': u'Kevin Watters',
    u'max cantor (#haskell - mxc)': u'Max Cantor',
    u'michael campbell': u'Michael Campbell',
    u'mike btauwerman': u'Mike Brauwerman',
    u'no credit necessary': u'Anonymous',
    u'nykänen, matti': u'Matti Nykänen',
    u'omar antolin camarena': u'Omar Antolín Camarena',
    u'ryan t mulligan': u'Ryan T. Mulligan',
    u'sengan baring-gould': u'Sengan Baring-Gould',
    u'some guy': u'Anonymous',
    u'tomas janousek': u'Tomáš Janoušek',
    u'william halchin': u'William N. Halchin',
    }

def fixup(s):
    try:
        return s.encode('ascii')
    except UnicodeEncodeError:
        def f(c):
            o = ord(c)
            if o < 128:
                return c
            return '&#%d;' % o
        return ''.join(map(f, s))

total = 0
for r in c.fetchall():
    r = r[0].decode('utf-8')
    if r in ("Bryan O'Sullivan",):
        continue
    total += 1
    m = mappings.get(r.lower())
    if m:
        r = m
    elif len(r) < 2 or ' ' not in r:
        r = 'Anonymous'
    reviewers.setdefault(r, 0)
    reviewers[r] += 1

reviewers = sorted(reviewers.iteritems(), key=lambda x: x[0])

cohorts = [(.01,1),(.002,.01)]

for (lo,hi) in cohorts:
    lo = total * lo
    hi = total * hi
    for r in [n for n in reviewers if lo <= n[1] < hi]:
        if r[1] > 3:
            print '%s,' % fixup(r[0])
    print

lo = total * .002
for n in reviewers:
    if n[1] < lo:
        print '%s,' % fixup(n[0])
