# Create your views here.

from django.http import HttpResponse

from django.utils.simplejson import dumps 

from django.contrib.csrf.middleware import csrf_exempt

import django.forms as forms

from django.db import connection

from django.http import HttpResponse,Http404

from sphinxcomment.models import Comment, Element

from django.shortcuts import get_object_or_404, render_to_response

from django.template import Context

from django.template.loader import get_template

from django.utils.simplejson import dumps 

def dump_queries():

    # requires settings.DEBUG to be set to True in order to work

    if len(connection.queries) == 1:

        print connection.queries

    else:

        qs = {}

        for q in connection.queries:

            qs[q['sql']] = qs.setdefault(q['sql'], 0) + 1

        for q in sorted(qs.items(), key=lambda x: x[1], reverse=True):

            print q

        print len(connection.queries)

class CommentForm(forms.Form):

    name = forms.CharField(max_length=64)

    url = forms.URLField(max_length=128, required=False)

    comment = forms.CharField(widget=forms.Textarea(attrs={

        'rows': 8, 'cols': 60

        }))

    remember = forms.BooleanField(initial=True, required=False)

def comments_by_chapter(chapter):

     objs = {}

def chapter_count(request,chapter_name):

    print chapter_name

    chapter_name=chapter_name.split('.')[0]

    comment_objs = comments_by_chapter(chapter_name)

    resp={}

    temp_dict={}

    for elt, comments in comment_objs.iteritems():

        temp_dict[elt]=len(comments)

    resp['count']=temp_dict

    print resp

    return HttpResponse(dumps(resp), mimetype='application/json')

def single(request,paragraph_id, form=None, newid=None):

    queryset = Comment.objects.filter(element=paragraph_id)

    if form is None:

        form = CommentForm(initial={

            'paragraph_id': paragraph_id,

            'name': request.session.get('name', ''),

            })

    try:

        error = form.errors[0]

    except:

        error = ''

    print form.errors

    return render_to_response('comment.html', {

        'paragraph_id': paragraph_id,

        'form': form,

        'length': len(queryset),

        'query': queryset,

        'newid': newid or True,

        'error': error,

        })

def submit(request, paragraph_id):

    try:

        element = get_object_or_404(Element, paragraph_id=paragraph_id)

    except Http404:

        chapter_id='_'.join(paragraph_id.split('_')[0:-1])

        element=Element(chapter_name=chapter_name,paragraph_id=paragraph_id)

        element.save()

    print element.chapter_name

    form = None

    newid = None

    if request.method == 'POST':

        form = CommentForm(request.POST)

        print form.errors

        if form.is_valid():

            print form.cleaned_data

            data = form.cleaned_data

            if data.get('remember'):

                request.session['name'] = data['name']

                request.session['url'] = data['url']

            else:

                request.session.pop('name', None)

                request.session.pop('url', None)

            c = Comment(element=element,

                        comment=data['comment'],

                        submitter_name=data['name'],

                        submitter_url=data['url'],

                        ip=request.META.get('REMOTE_ADDR'))

            print c

            c.save()

            form = None

    return single(request, paragraph_id, form,)

def test(request):

    print request

    string="<p>test comment</p>"

    return HttpResponse(string,mimetype="text/plain")

#return HttpResponse(dumps(string),mimetype="text/plain")

#test= csrf_exempt(test)