id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
17612	SQLite, filter, datefield, datetime no quotes around date in sql query	elmopl@…	nobody	"Model:

{{{
class StoreBill( Cost ):
    date            = models.DateField()
}}}

Query:

{{{
    ds = datetime.strptime(date, '%Y-%m-%d')
    de = ds + timedelta( days=1 )

    bills = StoreBill.objects.filter(date__gte = ds, date__lt = de)
}}}

resulting invalid where:
{{{
WHERE (""spendings_storebill"".""date"" >= 2012-01-19  AND ""spendings_storebill"".""date"" < 2012-01-20 )
}}}

This should be:

{{{
WHERE (""spendings_storebill"".""date"" >= '2012-01-19'  AND ""spendings_storebill"".""date"" < '2012-01-20' )
}}}

or even better:

{{{
WHERE (""spendings_storebill"".""date"" >= date('2012-01-19')  AND ""spendings_storebill"".""date"" < date('2012-01-20') )
}}}
"	Bug	closed	Database layer (models, ORM)	1.3	Normal	invalid	sqlite, filter, datefield, datetime		Unreviewed	0	0	0	0	0	0