How to convert a list in to queryset django

Question

I have a queryset(which is filtered actually) as below

posts = [<Post: published>, <Post: needs>, <Post: be>, <Post: issues>, <Post: to>, <Post: tags>]

But i need to filter the above queryset manually with the some field coming from another table/place etc.

so i had filtered something like below

custom_list = []

for rec in posts:
    if 'string_or_field' in rec.tags.all():
        custom_list.extend(rec)

        or

custom_list = [rec for rec in posts if 'string_or_field' in rec.tags.all()]

So as we can observe above we are creating a list by filtering a queryset, but i want the result as a queryset.

So is there any way to convert the list to queryset object ?

Why exactly do you need an actual queryset? The point of duck-typing is that you should be able to use any list-like construct. — Daniel Roseman, Sep 04 '13 at 08:38
yes actually i need a queryset to perform some operations since it is an object, but i got a list as above , so want to convert the resultant list to queryset — Shiva Krishna Bavandla, Sep 04 '13 at 13:03

score 17 · Answer 1 · answered Sep 04 '13 at 07:43

17

Actually i had found one way by googling, but this may take a lot of time for querying/generating results if there are huge number of records

custom_list = [rec.id for rec in posts if 'string_or_field' in rec.tags.all()]

querset = MyModel.objects.filter(id__in=custom_list)

answered Sep 04 '13 at 07:43

Shiva Krishna Bavandla

25,548
75
193
313

this is exactly what he asked, this shoud be accepted answer – oruchkin Aug 30 '22 at 20:04

score 17 · Accepted Answer · answered Sep 04 '13 at 09:43

17

You can query the Tag object first and filter Post with those ids:

tags = Tag.objects.filter(field_name='string_or_field')
posts = Post.objects.filter(tags__in=tags)

answered Sep 04 '13 at 09:43

Paulo Almeida

7,803
28
36

If you need the queryset to be sorted in the same order as the list, see https://stackoverflow.com/a/61686789/303056 – Leopd Sep 06 '22 at 23:54

score 6 · Answer 3 · answered Oct 31 '19 at 09:46

6

The previous answers are correct if each list item already exists in the database, but sometimes this is not the case. In this case you can create a queryset stub based on the list and implement queryset-methods and queryset-properties as needed.

class ListAsQuerySet(list):

    def __init__(self, *args, model, **kwargs):
        self.model = model
        super().__init__(*args, **kwargs)

    def filter(self, *args, **kwargs):
        return self  # filter ignoring, but you can impl custom filter

    def order_by(self, *args, **kwargs):
        return self

qs = ListAsQuerySet(custom_list, model=Post)

answered Oct 31 '19 at 09:46

Ilya Petukhov

682
7
12

This doesn't work. For a start you can't pass `model` to a class. – alias51 Feb 10 '20 at 14:31
1

Why? This works for me. Give me more information to resolve your problem. – Ilya Petukhov Feb 11 '20 at 11:33
1

To pass this to a `formset` add an `ordered` method to the class. – Samuel Kazeem Feb 25 '22 at 16:45

score 4 · Answer 4 · answered Feb 10 '20 at 14:34

Here's a simple util that you can run to produce a QS from a list:

def list_to_queryset(model, data):
    from django.db.models.base import ModelBase

    if not isinstance(model, ModelBase):
        raise ValueError(
            "%s must be Model" % model
        )
    if not isinstance(data, list):
        raise ValueError(
            "%s must be List Object" % data
        )

    pk_list = [obj.pk for obj in data]
    return model.objects.filter(pk__in=pk_list)

How to convert a list in to queryset django

4 Answers4

Linked