flat values() in querysets - Django developers

Message from discussion flat values() in querysets

Daniel Poelzleithner

More options Aug 3 2006, 2:15 pm

From: Daniel Poelzleithner <goo...@poelzi.org>

Date: Thu, 03 Aug 2006 20:15:20 +0200

Local: Thurs, Aug 3 2006 2:15 pm

Subject: flat values() in querysets

  Reply to author
  |
  Forward
  | Print
  | View thread
  | Show original
  | Report this message
  | Find messages by this author
  

Hi,

Currently it's kinda verbose to get just a list of id's from a query to
put it in a bulk_in or process it further.

example:

>>> NetworkState.objects.all().order_by("-stopdate")[:5].values("id")

[{'id': 2738}, {'id': 2737}, {'id': 2736}, {'id': 2735}, {'id': 2734}]

Then i have to unpack it to get a [2738, 2737,...] list, which is what I
wanted in the first place.

I suggest Object.objects.all().values("id", flat=True). Flat as a
optional argument, which is only allowed when only one field is
requested and returns a list with only the values.

Any better ideas ?

kindly regards
Daniel

Reply to author Forward