django-querysetsequence
django-querysetsequence copied to clipboard
Chain multiple (disparate) QuerySets in Django
Django QuerySetSequence #######################
.. image:: https://img.shields.io/pypi/v/django-querysetsequence.svg :target: https://pypi.org/project/django-querysetsequence/
.. image:: https://github.com/clokep/django-querysetsequence/actions/workflows/main.yml/badge.svg :target: https://github.com/clokep/django-querysetsequence/actions/workflows/main.yml
.. image:: https://readthedocs.org/projects/django-querysetsequence/badge/?version=latest :target: https://django-querysetsequence.readthedocs.io/en/latest/?badge=latest :alt: Documentation Status
.. include-start
django-querysetsequence adds helpers for treating multiple disparate QuerySet
obejcts as a single QuerySet
. This is useful for passing into APIs that only
accepted a single QuerySet
.
The QuerySetSequence
wrapper is used to combine multiple QuerySet
instances.
Overview
QuerySetSequence
aims to provide the same behavior as Django's |QuerySets|_,
but applied across multiple QuerySet
instances.
.. |QuerySets| replace:: QuerySets
.. _QuerySets: https://docs.djangoproject.com/en/dev/ref/models/querysets/
Supported features:
- Methods that take a list of fields (e.g.
filter()
,exclude()
,get()
,order_by()
) must use fields that are common across all sub-QuerySets
. - Relationships across related models work (e.g.
'foo__bar'
,'foo'
, or'foo_id'
). syntax). - The sub-
QuerySets
are evaluated as late as possible (e.g. during iteration, slicing, pickling,repr()
/len()
/list()
/bool()
calls). - Public
QuerySet
API methods that are untested/unimplemented raiseNotImplementedError
.
Getting Started
Install the package using pip.
.. code-block:: bash
pip install --upgrade django-querysetsequence
Basic Usage
.. code-block:: python
# Import QuerySetSequence
from queryset_sequence import QuerySetSequence
# Create QuerySets you want to chain.
from .models import SomeModel, OtherModel
# Chain them together.
query = QuerySetSequence(SomeModel.objects.all(), OtherModel.objects.all())
# Use query as if it were a QuerySet! E.g. in a ListView.
Project Information
django-querysetsequence is released under the ISC license, its documentation lives
on Read the Docs
, the code on GitHub
, and the latest release on PyPI
. It
supports Python 3.7+, Django 3.2/4.0/4.1, and is optionally compatible with
Django REST Framework
3.11+.
.. _Read the Docs: https://django-querysetsequence.readthedocs.io/ .. _GitHub: https://github.com/clokep/django-querysetsequence .. _PyPI: https://pypi.org/project/django-querysetsequence/ .. _Django REST Framework: http://www.django-rest-framework.org/
Some ways that you can contribute:
- Check for open issues or open a fresh issue to start a discussion around a feature idea or a bug.
- Fork the repository on GitHub to start making your changes.
- Write a test which shows that the bug was fixed or that the feature works as expected.
- Send a pull request and bug the maintainer until it gets merged and published.