Hi list!
I'm looking for a way to have the number of objects for each date in
the date_list object for the generic view date_based.archive_index.
For example:
- 2009: 12 objects
- 2008: 10 objects
I saw that the generic view is using the method
mymodel.objects.dates(), maybe I can override it. But how?
For now, I'm stick with a static method in my model Class. This method
uses raw sql.
@staticmethod
def years():
from django.db import connection
cursor = connection.cursor()
cursor.execute(" \
SELECT p.published_date, COUNT(*) \
FROM phog_photo p \
WHERE p.is_published = 1 AND p.published_date <= '%s' \
GROUP BY YEAR(published_date) \
ORDER BY 1 DESC" % datetime.now().strftime("%Y-%m-%d
%H:%M:%S")) result_list = []
for row in cursor.fetchall():
y = (row[0], row[1])
result_list.append(y)
return result_list
Is there a better and more elegant way to do this? I would like to
avoid raw sql as far as possible.
Thanks.
--
Laurent Meunier <laur...@deltalima.net>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
