On 3 Dez., 18:43, "Karen Tracey" <[EMAIL PROTECTED]> wrote:
> I don't know how to go from raw sql to a QuerySet. My own custom managers > start with a model's default QuerySet and modify it using the standard > exclude(), etc. Can you describe your views in terms of regular Django > operations on a model's QuerySet? Note there's a lot you can do with > extra(). That's the first way I'd try to approach it, rather than trying to > turn the results of raw sql into a QuerySet. That's as far as I know not possible in my case because I'm joining about seven tables which use several count() and some if(). So the version with raw SQL would be preferred due to performance reasons (it's annoying to wait ~5-6 seconds until the page is loaded;) On 3 Dez., 18:55, "James Bennett" <[EMAIL PROTECTED]> wrote: > There are two ways to go from raw SQL to Django model objects. One > results in a QuerySet, and is based around actually doing two queries: > first fetch the primary key values from the rows you're interested in, > then feed those to a Django API method to get a QuerySet. This version will generate the SELECT-query etc. by itself and get the information from the view like it's now, won't it? > The other is to select the full list of values and then pass the > resulting rows one at a time into the model's constructor, which > doesn't get you a QuerySet but does get you model objects. Under the > hood, this is how QuerySet spits back objects when you ask for them. That works so far but it would be great to use the select_related() and other methods. Is there nothing like a QuerySet/model which takes custom queries and puts them back into the Django ORM? Wouldn't that be interesting? May be I'll give it a try;) Thanks a lot so far for your support! Adrian --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
