Link is not working in django

Question

<a href = "{% url 'ngraph' %}">Customer Count</a>

When I click on customer count it works only once and to make it work I have to run the program again, what is the problem here ? And what I have noticed is once the link localhost:8000/graph is (customer count) clicked, works but makes busy to localhost:8000 and doesn't work that link. How to solve it ?

views.py

def graph(request):
    age = ['below 20', '20-22','22-24','24-26','26-28','28-30','30-40','above 40']
    avg_call_group =  [0, 0, 0, 0, 0, 0, 0, 0]

    cursor = connection.cursor()
    cursor.execute("select p.age_group,sum(c.avg_duration) as age_avg_dur from demo p,(select  card_no as card_n, avg(duration) as avg_duration from call_details where service_key = 1 and card_no =calling_no group by card_no) as c where p.card_no = c.card_n group by p.age_group ")
    numrows = int(cursor.rowcount)
    for x in range(numrows):
        row = cursor.fetchone()
        avg_call_group[x] =  row[1]

    cursor.close()

    import matplotlib.pyplot as plt
    f=plt.figure(figsize = (3,3))
    exploding = [.04, .04, .04, .04 , .04, .04, .04, .04]
    age = ['below 20', '20-22','22-24','24-26','26-28','28-30','30-40','40-50']
    plt.pie(avg_call_group, labels= age, autopct='%1.3f%%', explode = exploding)
    canvas = FigureCanvasAgg(f)
    response = HttpResponse(content_type='image/png')
    canvas.print_png(response)
    return response

urls.py

from django.conf.urls import patterns, include, url
from welcome.views import *
from django.contrib import admin
admin.autodiscover()

urlpatterns = patterns('',
    url(r'^admin/', include(admin.site.urls)),
    url(r'^hello/', hello, name = 'nhello'),
    url(r'^graph/', graph, name = 'ngraph'),
)

home.html

<div >
<a href = "{% url 'ngraph' %}">Customer Count</a>
</div>

Alternative source code location: click here

Have you disabled the browser cache? http://stackoverflow.com/questions/2095520/fighting-client-side-caching-in-django — dwxw, Jul 01 '13 at 13:06
probably the view that link calls throws an exception and your server dies, have you access to the server log/output? — DRC, Jul 01 '13 at 13:19
@DRC yes, I have accessed to the server log/output but have no idea ? — Bishnu Bhattarai, Jul 01 '13 at 15:39

score 1 · Answer 1 · edited Jul 03 '13 at 07:36

1

In the return of your views code, do a redirect. Something like:-

return render_to_response('graph.html', context_instance=RequestContext(request))

edited Jul 03 '13 at 07:36

nKandel

2,543
1
29
47

answered Jul 02 '13 at 12:30

Nikhil

143
2
7

score 1 · Accepted Answer · answered Aug 09 '13 at 12:40

1

I don't know if you still need an answer but I solved the exact problem like this:

matplotlib.use('Agg') # After you import


# And these lines at the end

fig.clf()
plt.close()
plt.clf()
del var_grid
gc.collect()

answered Aug 09 '13 at 12:40

Murat Ayan

575
4
19

Link is not working in django

views.py

urls.py

home.html

2 Answers2