get dictionary from queryset

Question

I have below query where I want to fetch 'specs' which is a dictionary but the type of envi_dict is a Queryset class. How do I fetch the dictionary from this queryset? Any help is much appreciated.

envi_dict = Environment.objects.values('specs')

Result

<QuerySet [({u'CPU Model': u'Dell', u'RAM': 1000, u'CPU': 400},), ({u'CPU Model': u'Dell', u'RAM': 1000, u'CPU': 400},)]>, <class 'django.db.models.query.QuerySet'>, )

I tried Environment.objects.filter(title=item.title).values('specs') and also Environment.objects.get('specs') but I am still getting a queryset.

Edit: Below is models.py

class CommonModel(models.Model):

    author = models.ForeignKey('auth.User',)
    title = models.CharField(max_length=400)
    comments = models.TextField(blank=True)
    requirements = JSONField(default = {})
    specs = JSONField(default= {})
    created_date = models.DateTimeField(default=timezone.now)
    updated_date = models.DateTimeField(blank=True, null=True)

    class Meta:
       abstract = True

    def update(self):
        self.updated_date = timezone.now()
        self.save()

    def __str__(self):
        return self.title

class Estimate(CommonModel):

    gp_code = models.TextField(default='Unknown')
    inputs = models.TextField(blank=True)
    ...
    def __str__(self):
        return self.title

class Environment(CommonModel):

    estimate = models.ForeignKey(Estimate,related_name='environments')
    logic = PythonCodeField(blank=True, null=True)
    ...

@Sayse, for the type of requirement we have, json fits well (for now atleast) since we may add more parameters in future. — Heenashree Khandelwal, Dec 05 '17 at 07:32
@AvinashRaj mentioned the right answer. I guess you can use this one as well. `Environment.objects.values('specs')` and after loop the same. — Vijesh Venugopal, Dec 05 '17 at 09:18
If you want a dictionary of a single model object use the inbuild Django method model_to_dict method. Using this you construct list of dictionary representing each object in a queryset. Checkout my answer https://stackoverflow.com/a/62073213/9384511 — ABN, Oct 20 '22 at 09:59
Checkout my answer at https://stackoverflow.com/a/62073213/9384511 — ABN, Jun 10 '23 at 04:17

score 10 · Accepted Answer · answered Dec 05 '17 at 09:08

10

Build a list of dicts with model instance.title as key and the specs as value by iterating over all Environment model instances.

[{i.title: i.specs} for i in Environment.objects.all()]

answered Dec 05 '17 at 09:08

Avinash Raj

172,303
28
230
274

3

if you want one dict object then it will be: `{i.title: i.specs for i in Environment.objects.all()}` without adding the comma. – elsadek Dec 28 '21 at 16:15

CbeDroid1614 · Answer 2 · 2022-10-30T06:41:23.133

Use Django model_to_dict

If you need to convert a single queryset into a dictionary, use model_to_dict.
If you need to convert all querysets into a dictionary use Model.objects.values() or django.core.serializer

using model_to_dict

from django.forms.models import model_to_dict
 
qs = Environment.objects.filter(title=item.title)
 
if qs.exists():
  qs_dict = model_to_dict(qs) # {id:1,'estimate':'some-estimate-data','logic':'some-logic-data'}
  # Do something here with qs_dict
else:
  # qs=None -- do some here when qs is not found

get dictionary from queryset

2 Answers2

Use Django model_to_dict