#7707: DateField/DateTimeField `in` lookup support
--------------------------------------------+-------------------------------
Reporter: alexkoshelev | Owner: nobody
Status: new | Milestone: 1.0
Component: Core framework | Version: SVN
Keywords: DateField DateTimeField lookup | Stage: Unreviewed
Has_patch: 1 |
--------------------------------------------+-------------------------------
ORM doesn't support 'in' lookups for DateField/DateTimeField fields.
Example from test:
{{{
#!python
class Article(models.Model):
headline = models.CharField(max_length=100)
pub_date = models.DateTimeField()
class Meta:
ordering = ('-pub_date', 'headline')
def __unicode__(self):
return self.headline
Article.objects.filter(pub_date__in=[datetime(2005, 7, 26), datetime(2005,
7, 28)])
}}}
And it produces wrong SQL:
{{{
('SELECT `lookup_article`.`id`, `lookup_article`.`headline`,
`lookup_article`.`pub_date` FROM `lookup_article` WHERE
`lookup_article`.`pub_date`
IN (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s,
%s, %s, %s, %s, %s, %s,
%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s,
%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s,
%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s,
%s, %s, %s, %s, %s, %s)
ORDER BY `lookup_article`.`pub_date` DESC, `lookup_article`.`headline`
ASC',
(u'[', u'd', u'a', u't', u'e',u't', u'i', u'm', u'e', u'.', u'd', u'a',
u't', u'e', u't', u'i', u'm', u'e',
u'(', u'2', u'0', u'0', u'5', u',', u' ', u'7', u',', u' ', u'2', u'6',
u',', u' ', u'0', u',', u' ', u'0', u')', u',', u' ',
u'd', u'a', u't', u'e', u't', u'i', u'm', u'e', u'.', u'd', u'a', u't',
u'e', u't', u'i', u'm', u'e', u'(', u'2',
u'0', u'0', u'5', u',', u' ', u'7', u',', u' ', u'2', u'8', u',', u' ',
u'0', u',', u' ', u'0', u')', u']'))
}}}
--
Ticket URL: <http://code.djangoproject.com/ticket/7707>
Django Code <http://code.djangoproject.com/>
The web framework for perfectionists with deadlines
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-updates?hl=en
-~----------~----~----~----~------~----~------~--~---
