Because django offers a nice ORM that makes it easy to do most queries, especially one-liners like this one.
And refactoring raw SQL is a royal PITA. Cheers, AT On Wed, Mar 21, 2012 at 3:14 PM, Python_Junkie < software.buy.des...@gmail.com> wrote: > Use straight sql. > > There are always potentially limitations with an abstraction such as the > ORM. > > Why try to fit a square peg into a round whole. > > > On Wednesday, March 21, 2012 4:41:32 AM UTC-4, diafygi wrote: >> >> There is an old thread that didn't end in a resolution about >> preventing joins in a filter(foreign_key=None) scenario. >> >> http://groups.google.com/**group/django-users/browse_** >> thread/thread/61ee2fb22deae326<http://groups.google.com/group/django-users/browse_thread/thread/61ee2fb22deae326> >> >> I'd like to bring it up again and ask if there is now a way to prevent >> joins from a query. >> >> An example: >> class Blog(model.Models): >> editor = models.ForeignKey(User, null=True) >> >> # find all the blogs with no editors >> >>> Blog.objects.filter(editor=**None) >> DEBUG:django.db.backends:(0.**039) SELECT `myapp_blog`.`id` FROM >> `myapp_blog` LEFT OUTER JOIN `myapp_user` ON (`myapp_blog`.`editor_id` >> = `myapp_user`.`id`) WHERE `myapp_user`.`id` IS NULL; >> >> # Is there a way to do this query? >> >>> Blog.objects.filter(editor=**None) >> DEBUG:django.db.backends:(0.**039) SELECT `myapp_blog`.`id` FROM >> `myapp_blog` WHERE `myapp_blog`.`editor_id` IS NULL; >> >> Thanks! >> Daniel > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/django-users/-/NfvXnYxnHBkJ. > > To post to this group, send email to django-users@googlegroups.com. > To unsubscribe from this group, send email to > django-users+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/django-users?hl=en. > -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
