python - Why does the Django filter() adds items instead of removing them? -

-

i'm curious filter() method behaviour. read in documentation can chained. ok let's try:

# returns queryset of 2 objects : [<cliprofile: sven>, <cliprofile: david>] res = someclass.objects.all()  # returns queryset of 3 objects : [<cliprofile: sven>, <cliprofile: sven>, <cliprofile: david>] res2 = res.filter(some_attr__gte=a_datetime_object)

how possible? if initial queryset contains 2 objects, how possible filter() method makes queryset grow?

your filter applies related objects; <cliprofile: sven> 2 such objects matched, object listed twice.

add .distinct() call:

res2 = res.filter(some_attr__gte=a_datetime_object).distinct()

as documentation .distinct() states:

by default, queryset not eliminate duplicate rows. in practice, problem, because simple queries such blog.objects.all() don’t introduce possibility of duplicate result rows. however, if query spans multiple tables, it’s possible duplicate results when queryset evaluated. that’s when you’d use distinct().

emphasis mine.


Comments

Post a Comment

Popular posts from this blog

.htaccess - htaccess convert request to clean url and add slash at the end of the url -

-
ok , searched more 4 days , more 20 posts here in stach or in websites without kind of success first here htaccess file rewriteengine on rewriterule ^([a-za-z0-9_]+)/?$ index.php?page=$1 [nc] rewriterule ^([a-za-z0-9_]+)\/([a-za-z0-9_]+)\/?$ index.php?page=$1&action=$2 [nc] i tried many codes 1 worked me can call request , works me www.example.com/pagename => www.example.com/index.php?page=pagename here questions , please provide me information "in detail" understand code well 1- how convert request automatically www.example.com/index.php?page=pagename www.example.com/pagename 2- if tried add slash @ end shows me page without images or styling mean www.example.com/pagename => works www.example.com/pagename/ => doesn't work that's :) for first part need 301 rule this: rewritecond %{the_request} /index\.php\?page=([^\s&]+) [nc] rewriterule ^ /%1? [r=301,l] for second part use absolute path in css, js, images files r...
Read more

c++ - Visual Leak Detector detects leak on new blank MFC project -

-
i installed vld try , debug c++ mdi mfc application in visual studio 2008. vld reported memory leak , no matter did not correct issue, created brand new blank project (mdi mfc) , memory leak still showing up. modification made writing #include <vld.h> in main project.h file. documentation says doesn't matter file, here output after execution (simply selecting file/exit , doing nothing else). 'project.exe': loaded 'c:\users\masterhd\documents\visual studio 2008\projects\project\debug\project.exe', symbols loaded. 'project.exe': loaded 'c:\windows\syswow64\ntdll.dll' 'project.exe': loaded 'c:\windows\syswow64\kernel32.dll' 'project.exe': loaded 'c:\windows\syswow64\kernelbase.dll' 'project.exe': loaded 'c:\windows\winsxs\x86_microsoft.vc90.debugmfc_1fc8b3b9a1e18e3b_9.0.21022.8_none_9b54853441e399d5\mfc90ud.dll', symbols loaded. 'project.exe': loaded 'c:\windows\winsxs\x86_microso...
Read more

php - facebook and github login HWIOAuthBundle and FOSUserBundle in Symfony2.1 -

-
i have followed tutotial http://m2mdas.github.io/blog/2013/11/21/integrate-hwioauthbundle-with-fosuserbundle/ make github login work, seems working when clicked login land on github login page, , see 1 user registered on github application in github dashboard. not authencated in symfony. on symfony tool bar on bottom still says anonymous user, plus new row not added table fos_user. for facebook login, when click on generator login link facebook, gives me error "given url not permitted application configuration.: 1 or more of given urls not allowed app's settings. must match website url or canvas url, or domain must subdomain of 1 of app's domains." another doubt had in tutorial, in routing.yml says put, hwi_github_login: pattern: /secure_area/login/check-github as there no controller or resource specified, supposed put here controller action path or resource? config.yml fos_user: db_driver: orm # other valid values ...
Read more