# -*- coding: utf-8 -*-
from django.template import RequestContext
from django.shortcuts import render_to_response
from django.http import HttpResponseRedirect
from models import Task
import MySQLdb

DB_USER = 'root'
DB_PASS = '14121988'
DB_BASE = 'Decanat'

def index(request):
    cont = {}

    if not request.user.is_authenticated():
		return HttpResponseRedirect('/accounts/login/')

	if request.method == "POST"
		if 'sqlcode' in request.POST
			t=request.POST['sqlcode']
			db_conn = MySQLdb.connect(user=DB_USER, passwd=DB_PASS, db=DB_BASE)
			cursor = db_conn.cursor(cursorclass=MySQLdb.cursors.DictCursor)
			cursor.execute(t)
			res = cursor.fetchall()
			resdate = res
			cont['result'] = resdate
	return render_to_response("index.html",cont, context_instabce=RequestContext(request))