django-hitcount: simple app to count hits/views for an object
django-hitcount: a simply django application that allows you to count hits/views on a per object basis. This app came about as an answer to my own question at stackoverflow.com. Am hoping that others will find it useful.
Documentation at: http://django-hitcount.rtfd.org
Source code at: https://github.com/thornomad/django-hitcount
Issues at: https://github.com/thornomad/django-hitcount/issues
i have been trying to implement this app and viewing comments in this thread shows its very easy one too.
i have followed your tutorial with each step clearly done.
I have a Model named Package for which i want to implement this app.
everything works fine but the hitcount are not increasing on multiple access of same package eventhough the limit is set to 0. i have even tried it 10 or other numbers as well.
pls help!
Getting RuntimeWarning: DateTimeField received a naive datetime.
I would like to request an enhancement to make the app datetime aware.
https://docs.djangoproject.com/en/dev/topics/i18n/timezones/#code
[…] trying to use the django-hitcount module to save the number of times a tutorial is accessed by different […]
Thanx a lot, nice app!
You should check Pull request from zaebee on github, it solve csrf problem on latest django release.
I followed your instructions but im getting this error:
‘str’ object has no attribute ‘_meta’
dont know where i went wrong.
same prob here
just figured it out.
u need to change the ‘object’ in
{% get_hit_count_javascript for object %} to an actual object.
Hi!
One little detail, depicted with an screenshot: http://www.diigo.com/item/image/26vn9/3uih
:)
Nice post!
Heh – nice catch. Thanks.
Praca za granic?…
[…]django-hitcount: simple app to count hits/views for an object « damontimm.com[…]…
Can’t seem to get this to work on Mezzanine. Can someone please explain what I should substitute in for the “object”? How do I find that variable or whatever it is. An object means several different things in Django so it’s confusing.
A real world example using the actual word rather then placeholder “object” word might help.
Figured it out.
You have to put custom urls above the:
(“^”, include(“mezzanine.urls”)),
pattern that is included in the mezzanine urls.py
Sorry mi english is bad! :)
I’ve problem when I add into:
{% load hitcount_tags %}
Look error:
http://ftp.yayabolinux.ssp.co.cu/Pack-Extras/django-hicount.png
With django-hicount I can see the number of visits to the site?
example: example.com <—— hitcount show visits to this site
Easiest app I’ve installed. :). Thanks for the hard work!
To render 1 page hitcount makes 2 identical SQL queries:
First to render js:
and second to get hitcount for object:
{% get_hit_count for object as hit_count %}
How can I reduce the number of queries?)
How would I order my counted objects by hits in a view? I really can’t get my head around these generic relations!
Use something like this:
actions = Action.objects.all().extra(
select={
‘hit_count’: ‘SELECT hits FROM hitcount_hit_count as t \
WHERE t.content_type_id = 13 \
AND t.object_pk = actions_action.id’,
},).order_by(“hit_count”)
It works =)
Hey Dmitry,
Thanks for your reply, but I still don’t really get it. I have a model called Card, how would your code look like then?
For Example:
sorted_cards = Card.objects.all().extra(…).order_by(…)
I’m quite new to all this and don’t have a clue about sql and things like that. Your help is really appreciated.
Best
JacquesKnie
This app should integrate django as it is really handy.
I’m using django 1.3.
I think the problem of getting a top-hits list of objects is already solved because the hitcount.models.HitCount has a content_object field, which returns the target object.
All I did was:
qs = models.HitCount.objects.order_by(‘-hits’)
qs[i].content_object refers to the object instance.
You can always use Model.objects.values_list() to get an actual list of your objects:
qs = models.HitCount.objects.values_list(‘content_object’, flat=True).order_by(‘-hits’)
I know nothing has been posted here for a while, but I’ve just started using this. It’s very useful, but the AJAX calls will fail when the CsrfViewMIddleware is installed in MIDDLEWARE_CLASSES (which it is by default in Django).
To solve this, you need to make sure you include the appropriate CSRF Header in every AJAX request, which can be done as shown in the Django documentation.
Which version of Django does this fail with? I haven’t updated my web site that utilizes this lately so I may be behind in the Django parlance — in fact, haven’t done anything with this for a bit! Feel bad too – need to get on that.
I’m using 1.2.5 – however, it’s easily fixed by using the Javascript given on that Django page I linked originally. I hadn’t realised that the function posted there overrides every AJAX POST and adds in the appropriate header, thus solving the problem!
Nice app, works fine!
Can you tell, how to make query (in views i suggest) to display 50 items on page, each item must have number of views
If i use template tag “get_hit_count for [object] as [var]” i get too many sql queries
Can i use something like select_related() to get all statistics in one query?
Thanks!
self.answer:
objects.extra + query.join
Would you expand a bit more on your response? thanks
Why do you include the ajax call? Wouldn’t it be much simpler to just update your db via the template tag? It seems that including a POST request is unnecessary.
You could do that – however, the AJAX approach is just one way to try and counter ‘false counts’ … if it was triggered by a database hit (or page load) all the web crawlers and bots would set off hits every time the page read … which would be a lot. AJAX, hopefully, helps to ensure that only real computer users are triggering a hit.
Hmmm I guess that makes sense…although for bots one step could be to check the user-agent string. It wouldn’t prevent people purposefully spamming, but then neither would the ajax method.
As far as bot checking goes, it looks like you could either run the UA past all of the known bot UA strings (http://www.pgts.com.au/pgtsj/pgtsj0208d.html) or just check for the major browsers.
That’s a great idea!
I would love to implement some alternative methods to recording a Hit … if you look under the
views.pyyou’ll see I separated the base Hit processing method [_update_hit_count(request, hitcount)] from the ajax method.If you wanted to fork the project and add another view method that utilizes the UA list and doesn’t require javascript, I would be happy to test it and merge it into the master branch. I think it would be useful for people who aren’t already using jQuery.
If you aren’t up for it, I will try and add that feature when I have a chance … contact via github if you are interested.
Thanks for the idea!
I opened a ticket:
http://github.com/thornomad/django-hitcount/issues/#issue/3
Comment there with input. Shouldn’t be that hard to implement … importing the list of UA’s will be the major work … if it can be called that.
I’m interested in using this to count impressions of adds not just requests for them. I want my advertisers to know when there add has been “seen” not just requested. I’m planing on attaching the hit count to 2 js events – when the add in in visible range and when an add has been display in a fading group of adds. this will be perfect! thanks :)
I haven’t tried this out yet, I’m planning on implementing it tonight. It’s exactly what I was looking for. I hope it works out wells. Cheers.
Let me know how it works – it isn’t as full-featured as I would like, yet, but seems to get the job done so far. If you have any contributions to make would love to incorporate them.
Hi Damon. So far so good. I’m actually fairly new to Django and had a question. I’m making a video site and am using this to keep track of video views. Lets say I wanted to display the last 2 videos that recorded a view, could I do that using your app? I’m having trouble figuring it out (this is the first website I’m actually programming, so I don’t know too much..). If you have some sort of answer to that, feel free to email me as well. Thank you!
Well, every time a Hit is saved the associated HitCount objects
modifiedvalue is updated. So, you could get the last two like so:>>> from hitcount.models import HitCount >>> for hc in HitCount.objects.order_by('-modified')[:2]: ... hc.content_object ... <Video: Stars & Stripes FOREVER! [HD]> <Video: The Muppets Bohemian Rhapsody> >>>That should get you started …
Amazing, man. Works out of the box!
Thanks a lot!!
Nice, thanks for this. You forgot to add the following command templates:
{% load hitcount_tags %}Thanks for pointing that out and hope you find it useful.