#!/usr/bin/env PYTHONPATH="/var/hostings/05pcon0912/us.pycon.org/apps07" DJANGO_SETTINGS_MODULE="pycon.conf.settings" python2.4
print "before imports"
import sys
sys.path.insert(0, "/var/hostings/05pcon0912/us.pycon.org/apps07")
from django.conf import settings
from pycon.conf import settings as pycon_settings
#settings.configure(default_settings=pycon_settings)

from django.template import RequestContext, Context, loader
from pycon.core import mail
from pycon.propmgr.models import *
from pycon.core import mail

EMAIL_TO = [
    'pycon-organizers@python.org',
    'pycon-pc@python.org']
#    'pycon@dougma.com' ]

def send_stats():
    print "loading template"
    t = loader.get_template("propmgr/email/proposal_stats.txt")
    print "before queries"
    c = {
        'prop_count': Proposal.objects.count(),
        'sub_count': Group.objects.get(name='Submitters').user_set.count(),
        'auth_count': Group.objects.get(name='Authors').user_set.count(),
        'rev_count': Group.objects.get(name='Reviewers').user_set.count(),
        'vote_count': Review.objects.count(),
        'comment_count': Comment.objects.count(),
    }
    print "rendering"
    message = t.render(Context(c))
    print "sending messages"
    mail.send_mail('PyCon 2007 Final Talk Proposal Stats',
                   message, settings.PROPMGR_EMAIL,
                   EMAIL_TO)
    print "Sent:\n", message

if __name__ == '__main__':
    send_stats()