Hi, Any pointers as to where I could find any info about performing a SQL CASE statement using Django? Even more fundamental... is there really no way of doing a LEFT OUTER JOIN in Django (other than terribly sloppy role your own hacks)? Does anyone know of any more complete model/queryset docs out there, other than the 3 pages Django offers?
Also, am I alone in being a bit wary of the django ORM after reading... 'By default, a QuerySet will not eliminate duplicate rows. In practice, this is rarely a problem, because simple queries such as Blog.objects.all() don't introduce the possibility of duplicate result rows. However, if your query spans multiple tables...' Is someone out there really serious in assuming that using DISTINCT is 'rarely a problem' due to most queries not needing to go beyond 'Blog.objects.all()'? Maybe I'm odd, but rarely do I have much use for a single table query... not the other way around... Not trying to be negative, but I'm struggling with making the ORM useful beyond quite simple (almost trivial) queries. The ORM seems to inevitably produce some seriously sloppy SQL under the covers. Since these queries are so abstracted and hidden, I could see many nasty scaling issues hit people in the face. Does SQL Alchemy allow going beyond the basics? I'm hoping I'm missing some key piece of info, but losing faith that I am... and yes, I've read the docs MANY times. Thanks for pointing me towards any useful resources which I may be missing. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
