Question: how to get a list of values from a queryset?

[bolinocroustibat]

I want to get the list of records ids with a filtered attribute (to be able to pick a random one among them later).

In Django ORM, I would do something like:
records = Item.objects.filter(attribute=1).values_list('id', flat=True)

In SQL Alchemy, something like https://stackoverflow.com/questions/24560945/sqlalchemy-get-list-of-ids-from-a-query

How to do that with Ormar? Thanks!

[collerek]

Right now there is no way to return the raw data from a query bypassing the model -> sounds like an enhancement idea.

So for now you would have to do [x.id for x in await Item.objects.filter(attribute=1).all()] (I assume id is unique here as it looks like pk, otherwise use set comprehension instead of list). SO it's still gonna parse the models which you do not need in this case, but that will work.

Note that if you have other fields optional you can select only id i.e. Item.objects.filter(attribute=1).fields("id").all()

[bolinocroustibat]

Thanks. And yes, that would be definitely a good enhancement.

[collerek]

Created enhancement issue

[collerek]

since 0.10.11 you can records = await Item.objects.filter(attribute=1).values_list('id', flatten=True)

[collerek]

Added in 0.10.11