#!/usr/local/bin/python
#coding=utf-8

#imports
import praw
import time
from time import gmtime, strftime
from collections import defaultdict
import csv
import re
import pandas
import sys
reload(sys)
sys.setdefaultencoding("utf-8")

currentcounter = 1
subreddit = "pokemon"
username = "bigslothonmyface"
password = ""
print "User Flair Update Time: " + strftime("%Y-%m-%d %H:%M:%S", gmtime())
r = praw.Reddit(user_agent=subreddit+' Flair Counter')
r.login(username,password)
sub = r.get_subreddit(subreddit)
f = open('current'+subreddit+str(currentcounter)+'.csv', 'w')
i = 0
listlength = 0
flairlist = []
d = defaultdict(int)
for item in  sub.get_flair_list(limit=None):
 i += 1
 if(i%1000==0):print(i)
 try:
  user = item['user'].encode('utf8')
 except:
  user = str(item['user'])
 try:
  flair_text = item['flair_text'].encode('utf8').replace("&","&")
 except:
  flair_text = str(item['flair_text'])
  flair_text = flair_text.replace("&","&")
 try:
  css_class = item['flair_css_class'].encode('utf8')
 except:
  css_class = str(item['flair_css_class'])
 if css_class == "None" or css_class == "text":
  newflair = ""
  newcss = ""
 else:
  flair = css_class
  d[flair] += 1
  newcss = flair
  newflair = flair_text
 f.write(user + "," + newflair + "," +  newcss + "\n")
f.close()
with open('numflairs.csv', 'wb') as f:
 for key, value in sorted(d.iteritems(), key=lambda (k,v): (v,k), reverse=True):
  f.write(key + "," + str(value) + "\n")