I posted this on django-users, but didn't get much feedback. It seems
like a pretty important problem, so I'm reposting here:
My current model looks like this:
class Article(models.Model):
title = models.CharField(maxlength=64)
slug = models.SlugField(prepopulate_from=("title",))
author = models.ForeignKey(User)
text = models.TextField()
pub_date = models.DateField()
public = models.BooleanField()
def get_absolute_url(self):
return "/articles/%s/%s/" %
(self.pub_date.strftime("%Y/%m/%d"), self.slug)
I was using the date_based generic views when I noticed that something
was quite wrong. Whenever I used the archive_day or object_detail, no
results were being returned!
As an example, I created an entry in the Admin with a Date of
2006-01-16 and a slug of "foo". If I went to
/articles/2006/01/
then I would see my entry in the object_list.
However, if I go to /articles/2006/01/16/ or
/articles/2006/01/16/foo, it doesn't work (I get a 404 error)
I've dug a little deeper, and got the following worrying results in the shell:
ln [14]:x = Article.objects.all()
In [15]:x.filter(pub_date__range= (datetime.datetime(2006,1,16,0,0),
datetime.datetime(2006,1,16,23,59,59,999999)))
Out[15]:[]
In [16]:x.filter(pub_date__range=
(datetime.datetime(2006,1,15,23,59,59,999999),
datetime.datetime(2006,1,16,0,0,0,0)))
Out[16]:[<Article: foo bar blah>]
That query on line 15 is the exact same query that archive_day uses.
So my article, with a pub_date of 2006-01-16 does NOT show up in the
results of the first query, but does in the second. Looks like the
comparison code somewhere is broken.
Note, I'm using sqlite3.
Jay P.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django developers" group.
To post to this group, send email to django-developers@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-developers
-~----------~----~----~----~------~----~------~--~---
