able to return nested dictionary using values? django

Question

let's say if I have a model named Blog and this is how the value works

>>> Blog.objects.values()
[{'id': 1, 'name': 'Beatles Blog', 'tagline': 'All the latest Beatles news.'}],
>>> Blog.objects.values('id', 'name')
[{'id': 1, 'name': 'Beatles Blog'}]

but let's say if I want to make the name into another dict and get such in return

[{'id': 1, 'blog': { 'name': 'Beatles Blog'}}]

is the above possible by using value or something similiar?

I know I can do something like which would work

[{'id': blog.pk, 'blog': {'name': blog.name}} for blog in blogs]

Thanks in advance for my curiosity

Check out this solution: Nested dictionary using values

Sammrafi
– Sammrafi

2024-05-09 04:22:32 +00:00
Commented May 9, 2024 at 4:22 — Sammrafi
– Sammrafi, Commented May 9, 2024 at 4:22

roob · Accepted Answer · 2018-08-02 20:46:00Z

5

This is not possible using values.

The method you suggested works well.

If you have a lot of extra fields on your model, and only need those two, a performance improvement would be to first load just the fields you need using values, then perform the list comprehension on them to reformat it as you specified.

This avoids unnecessarily querying the database for fields you do not need.

edited Aug 2, 2018 at 20:46

answered Aug 2, 2018 at 1:27

roob

2,5593 gold badges29 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

stackPusher Over a year ago

Actually values() doesn't load the data into memory, it returns a QuerySet object, akin to a sql statement. It isn't until you iterate over the queryset (in this case the for blog in blogs part) that the query is executed and the data is loaded. Water malooooooone

roob Over a year ago

@stackPusher You are correct. I have updated the answer with the incorrect information removed.

Dora Over a year ago

@WaterMalone got it, thx thx for the info, this is really helpful. But I am wondering as mentioned above saying query is not executed until we iterate over the queryset, you are saying it will not hit the database at this point until I do something like for blog in blogs?

roob Over a year ago

@Dora Yes that is right. And my point is, if you only specify the subset of fields that you need, it will be a more efficient database query.

nuts · Accepted Answer · 2024-01-17 11:57:57Z

1

Ever since Django 3.2, this is possible using JSONObject.

So in your case, you'd do:

from django.db.models.functions import JSONObject


Blog.objects.annotate(blog=JSONObject(name='name')).values('id', 'blog')

which should yield exactly what you're asking for: [{'id': 1, 'blog': { 'name': 'Beatles Blog'}}]

answered Jan 17, 2024 at 11:57

nuts

80310 silver badges23 bronze badges

Collectives™ on Stack Overflow

able to return nested dictionary using values? django

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related