web/hgbook/reviewers.py
changeset 2 52d12eb31c30
parent 1 672eaaab9204
child 3 6cee07c589cb
--- a/web/hgbook/reviewers.py	Fri Feb 05 23:42:24 2010 +0530
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,81 +0,0 @@
-#!/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])