Django values list vs values

Question

In Django  what s the difference between the following two   Article objects values list  comment id   flat True  distinct     vs   Article objects values  comment id   distinct     My goal is to get a list of unique comment ids under each Article  I ve read the documentation  and in fact have used both approaches   The results overtly seem similar

User · Answer

values   Returns a QuerySet that returns dictionaries  rather than model instances  when used as an iterable  values list   Returns a QuerySet that returns list of tuples  rather than model instances  when used as an iterable  distinct   distinct are used to eliminate the duplicate elements  Example   gt  gt  gt  list Article objects values list  id   flat True     flat True will remove the tuples and return the list     1  2  3  4  5  6    gt  gt  gt  list Article objects values  id       id  1     id  2     id  3     id  4     id  5     id  6

User · Answer

The values   method returns a QuerySet containing dictionaries   lt QuerySet    comment id   1     comment id   2   gt   The values list   method returns a QuerySet containing tuples   lt QuerySet   1     2    gt   If you are using values list   with a single field  you can use flat True to return a QuerySet of single values instead of 1-tuples   lt QuerySet  1  2  gt

User · Answer

The best place to understand the difference is at the official documentation on values   values list  It has many useful examples and explains it very clearly  The django docs are very user freindly  Here s a short snippet to keep SO reviewers happy  values  Returns a QuerySet that returns dictionaries  rather than model instances  when used as an iterable   And read the section which follows it  value list  This is similar to values   except that instead of returning dictionaries  it returns tuples when iterated over

User · Answer

You can get the different values with   set Article objects values list  comment id   flat True

[django] Django values_list vs values

values()

values_list()

distinct()

Examples related to django

Examples related to django-models

Examples related to django-queryset

Examples related to django-orm