On 15-8-2012 23:01, Callum Bonnyman wrote:
>
>
> I am creating a popular page for my app and for the most part this is just
> to gain an understanding.
>
> The idea is to divide the number of views by the days old, now i don't know
> if this will be successful or even working but like I said its go get an
> idea of how queries work...
>
> My fields are named: views and created. Below is an idea of what I'm
> thinking of.
>
> (now - created) / views
You probably want views / (now - created) which means the average number
of views over time. Your function above calculates the average time
between views.
> popular_posts = Post.objects.all().order_by('-id')[:50]
The problem isn't the calculation. The problem is that you want the
result of the calculation and the ability to sort with it. If you want
to keep this independent of the database backend I highly suggest you
calculate the value in python and store it in the database.
Otherwise, I don't see a way to avoid using the extra method:
<https://docs.djangoproject.com/en/1.4/ref/models/querysets/#extra>
--
Melvyn Sopacua
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
