This is fixed in Django 1.8. See the fifth item in
https://docs.djangoproject.com/en/dev/releases/1.8/#models.
On Friday, March 27, 2015 at 5:38:15 PM UTC-4, Gergely Polonkai wrote:
>
> Hello,
>
> I’d like to execute the following code:
>
> Booking.objects.filter(start_ts__isnull = False, end_ts__isnull =
> False).extra(select = {'amount': "strftime('%s', end_ts) - strftime('%s',
> start_ts)"})
>
> However, in the shell, I get the following error:
>
> Traceback (most recent call last): File "<console>", line 1, in <module>
> File
> "/home/polesz/Projects/duckbook/venv/lib/python3.4/site-packages/django/db/models/query.py",
>
> line 835, in extra clone.query.add_extra(select, select_params, where,
> params, tables, order_by) File
> "/home/polesz/Projects/duckbook/venv/lib/python3.4/site-packages/django/db/models/sql/query.py",
>
> line 1744, in add_extra entry_params.append(next(param_iter)) StopIteration
>
> I have tried doubling the percent signs (%%s) and escaping them with a
> backslash (\%s), but neither helped. I also looked at this answer
> <http://stackoverflow.com/a/18143147/1305139>[1], but that solution
> doesn’t work with QuerySet.extra() (or I just miss the point).
>
> What is the correct way to solve this?
>
> I also tried to use select_params like this:
>
> Booking.objects.filter(start_ts__isnull = False, end_ts__isnull =
> False).extra(select = {'amount': "strftime('%s', end_ts) - strftime(%s,
> start_ts)"}, select_params = ['%s', '%s'])
>
> but regardless the usage of quote signs, the resulting query has \'%s\',
> which gives an SQL error, of course.
>
> Best,
> Gergely
>
> [1] http://stackoverflow.com/a/18143147/1305139
>
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/fa509ee1-6bb2-43c8-a1a1-e12ad70a123f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
