my input query is
query = "select * from tab1 left join tab2 on tab2.patient_id =tab1.patient_id ,tab3 left join tab4 on tab4.patient_id =tab3.patient_id"
data = model_name.objects.raw(query)
How do you retrieve values from a RawQuerySet?
-
See this stackoverflow.com/questions/5931586/…Sudipta– Sudipta2013-12-02 09:52:34 +00:00Commented Dec 2, 2013 at 9:52
Add a comment
|
1 Answer
The result obtained by making raw queries using raw method of Manager generates instances similar to instances generated using get or filter method. To get a field simply do obj_name.attr.
For eg:
class Tab(models.Model):
field1 = models.BooleanField()
field2 = models.PositiveIntegerField()
query = "select * from app_name_tab"
objs = Tab.objects.raw(query)
for obj in objs:
print obj.field1, obj.field2
For more info, refer to https://docs.djangoproject.com/en/dev/topics/db/sql/
3 Comments
Ashish Kumar Saxena
thank for your reply.. i want to access all fields data. i don't know column name since join query generating dynamically...
Arpit
You could use
tab._meta.fields to get the list of all fields in the table. Iterate over them and use getattr method get values like this: for f in obj._meta.fields: print getattr(obj, f)
Lym
I had a RawQuerySet object and needed to know how to retrieve values of attributes contained as collections within the object. This answer is exactly what I needed. I don't understand why it had been down-voted in the first place.