# -*- coding: utf-8 -*-

# Filename      main.py
# First edited  22-03-2012 19:45
# Last edited   22-03-2012 20:01

import sqlite3
import os, sys
import collections

def export_messages():
    conn = sqlite3.connect("main.db")
    c = conn.cursor()
    logins = [x[4] for x in c.execute("SELECT * FROM messages ORDER BY id DESC").fetchall()]
    s = float(sum([x[1] for x in collections.Counter(logins).iteritems()]))
    for i in sorted(collections.Counter(logins).iteritems(), key=lambda x: x[1], reverse=True):
        print "Login: %s - Beskeder: %s - Procentvis: %.2f" % (i[0].ljust(25), str(i[1]).ljust(10), (i[1]/s)*100)
    #for i in c.execute("SELECT * FROM messages ORDER BY id DESC").fetchall():
        #try:
            #i[-19].encode('utf-8')#print i[4], i[-19].encode('utf8')
            #print "\n"
        #except AttributeError:
        #    print i

def main():
    export_messages()

if __name__ == '__main__':
    main()