views.py (Not Working: Added annotate(num =
Count('choice')).filter(num__gt=1))
class IndexView(generic.ListView):
template_name = 'polls/index.html'
context_object_name = 'latest_question_list'
def get_queryset(self):
"""Return the last five published questions."""
return Question.objects.annotate(num =
Count('choice')).filter(num__gt=1).filter(pub___lte=timezone.now()).order_by('-pub_date')[:5]
Error:
Traceback (most recent call last): File
"C:\Users\hmnsh\repos\DjangoApp\mysite\polls\tests.py", line 80, in
test_past_question [''] File "C:\ProgramData\Anaconda3\envs\django\lib
\site-packages\django\test\testcases.py", line 940, in assertQuerysetEqual
return self.assertEqual(list(items), values, msg=msg) AssertionError:
Lists differ: [] != ['']
--
Ticket URL: <https://code.djangoproject.com/ticket/29325>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
* status: new => closed
* resolution: => invalid
Old description:
> In polls application I added annotation to check one to many relationship
> between Question and Choice models such that, Index only return questions
> with more than one choices to be displayed but my testcase fails all the
> time with annotation where both query returns same data.
>
> views.py (Not Working: Added annotate(num =
> Count('choice')).filter(num__gt=1))
>
> class IndexView(generic.ListView):
> template_name = 'polls/index.html'
> context_object_name = 'latest_question_list'
>
> def get_queryset(self):
> """Return the last five published questions."""
> return Question.objects.annotate(num =
> Count('choice')).filter(num__gt=1).filter(pub___lte=timezone.now()).order_by('-pub_date')[:5]
>
> Error:
>
> Traceback (most recent call last): File
> "C:\Users\hmnsh\repos\DjangoApp\mysite\polls\tests.py", line 80, in
> test_past_question [''] File "C:\ProgramData\Anaconda3\envs\django\lib
> \site-packages\django\test\testcases.py", line 940, in
> assertQuerysetEqual return self.assertEqual(list(items), values, msg=msg)
> AssertionError: Lists differ: [] != ['']
New description:
In polls application I added annotation to check one to many relationship
between Question and Choice models such that, Index only return questions
with more than one choices to be displayed but my testcase fails all the
time with annotation where both query returns same data.
views.py (Not Working: Added `annotate(num =
Count('choice')).filter(num__gt=1))`
{{{
class IndexView(generic.ListView):
template_name = 'polls/index.html'
context_object_name = 'latest_question_list'
def get_queryset(self):
"""Return the last five published questions."""
return Question.objects.annotate(num =
Count('choice')).filter(num__gt=1).filter(pub___lte=timezone.now()).order_by('-pub_date')[:5]
}}}
Error:
{{{
Traceback (most recent call last): File
"C:\Users\hmnsh\repos\DjangoApp\mysite\polls\tests.py", line 80, in
test_past_question ['']
File "C:\ProgramData\Anaconda3\envs\django\lib\site-
packages\django\test\testcases.py", line 940, in assertQuerysetEqual
return self.assertEqual(list(items), values, msg=msg) AssertionError:
Lists differ: [] != ['']
}}}
--
Comment:
Please see TicketClosingReasons/UseSupportChannels for ways to get help.
--
Ticket URL: <https://code.djangoproject.com/ticket/29325#comment:1>
* cc: hgamit (added)
* status: closed => new
* resolution: invalid =>
Comment:
@Tim Graham: I am really stuck around testcases and queryset. What is the
solution for this issue? What do you mean by invalid? Do you need more
info?
--
Ticket URL: <https://code.djangoproject.com/ticket/29325#comment:2>
* status: new => closed
* resolution: => invalid
Comment:
Hello hgamit,
This ticket tracker should be used to keep track of Django bugs and
feature requests and isn't a support channel per se.
The link Tim pointed you to contains reference to mailing lists and IRC
channels where you should be able to find support for your issue.
--
Ticket URL: <https://code.djangoproject.com/ticket/29325#comment:3>