On May 23, 9:35 am, wierob83 <wiero...@googlemail.com> wrote: > Hi, > > how can I obtain a QuerySet from a raw SQL query? > > I want to use some generic views (objects list, object detail). > Unfortunately, all examples I've seen require a QuerySet (e.g. > MyModel.objects.all()). I'm using an existing database and already > have SQL queries that I want to use. So how can I get a QuerySet from > the SQL query? > > Thanks in advance. > > kind regards > robert
That depends on what your SQL query is returning. If it's a list of IDs, you can make another query via the ORM to get the objects you need: queryset = MyModel.objects.filter(id__in=[list_of_ids]) If it's returning all the columns in the model, you can simply instantiate the objects using that data: queryset = [MyModel(*row) for row in results] Here, *row passes the list of columns in the 'row' variable to the constructor for MyModel. This is basically what the Django internals do anyway. To make this work, the columns have to be in the same order as in the model definition. -- DR. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
