|
| 1 | +title: django.db.models.query EmptyQuerySet Example Code |
| 2 | +category: page |
| 3 | +slug: django-db-models-query-emptyqueryset-examples |
| 4 | +sortorder: 500011239 |
| 5 | +toc: False |
| 6 | +sidebartitle: django.db.models.query EmptyQuerySet |
| 7 | +meta: Python example code for the EmptyQuerySet class from the django.db.models.query module of the Django project. |
| 8 | + |
| 9 | + |
| 10 | +EmptyQuerySet is a class within the django.db.models.query module of the Django project. |
| 11 | + |
| 12 | + |
| 13 | +## Example 1 from django-wiki |
| 14 | +[django-wiki](https://github.com/django-wiki/django-wiki) |
| 15 | +([project documentation](https://django-wiki.readthedocs.io/en/master/), |
| 16 | +[demo](https://demo.django-wiki.org/), |
| 17 | +and [PyPI page](https://pypi.org/project/django-wiki/)) |
| 18 | +is a wiki system code library for [Django](/django.html) |
| 19 | +projects that makes it easier to create user-editable content. |
| 20 | +The project aims to provide necessary core features and then |
| 21 | +have an easy plugin format for additional features, rather than |
| 22 | +having every exhaustive feature built into the core system. |
| 23 | +django-wiki is a rewrite of an earlier now-defunct project |
| 24 | +named [django-simplewiki](https://code.google.com/p/django-simple-wiki/). |
| 25 | + |
| 26 | +The code for django-wiki is provided as open source under the |
| 27 | +[GNU General Public License 3.0](https://github.com/django-wiki/django-wiki/blob/master/COPYING). |
| 28 | + |
| 29 | +[**django-wiki / src/wiki / managers.py**](https://github.com/django-wiki/django-wiki/blob/master/src/wiki/./managers.py) |
| 30 | + |
| 31 | +```python |
| 32 | +# managers.py |
| 33 | +from django.db import models |
| 34 | +from django.db.models import Count |
| 35 | +from django.db.models import Q |
| 36 | +~~from django.db.models.query import EmptyQuerySet |
| 37 | +from django.db.models.query import QuerySet |
| 38 | +from mptt.managers import TreeManager |
| 39 | + |
| 40 | + |
| 41 | +class ArticleQuerySet(QuerySet): |
| 42 | + def can_read(self, user): |
| 43 | + if user.has_perm("wiki.moderator"): |
| 44 | + return self |
| 45 | + if user.is_anonymous: |
| 46 | + q = self.filter(other_read=True) |
| 47 | + else: |
| 48 | + q = self.filter( |
| 49 | + Q(other_read=True) |
| 50 | + | Q(owner=user) |
| 51 | + | (Q(group__user=user) & Q(group_read=True)) |
| 52 | + ).annotate(Count("id")) |
| 53 | + return q |
| 54 | + |
| 55 | + def can_write(self, user): |
| 56 | + if user.has_perm("wiki.moderator"): |
| 57 | + return self |
| 58 | + if user.is_anonymous: |
| 59 | + q = self.filter(other_write=True) |
| 60 | + else: |
| 61 | + q = self.filter( |
| 62 | + Q(other_write=True) |
| 63 | + | Q(owner=user) |
| 64 | + | (Q(group__user=user) & Q(group_write=True)) |
| 65 | + ) |
| 66 | + return q |
| 67 | + |
| 68 | + def active(self): |
| 69 | + return self.filter(current_revision__deleted=False) |
| 70 | + |
| 71 | + |
| 72 | +~~class ArticleEmptyQuerySet(EmptyQuerySet): |
| 73 | + def can_read(self, user): |
| 74 | + return self |
| 75 | + |
| 76 | + def can_write(self, user): |
| 77 | + return self |
| 78 | + |
| 79 | + def active(self): |
| 80 | + return self |
| 81 | + |
| 82 | + |
| 83 | +class ArticleFkQuerySetMixin: |
| 84 | + def can_read(self, user): |
| 85 | + if user.has_perm("wiki.moderate"): |
| 86 | + return self |
| 87 | + if user.is_anonymous: |
| 88 | + q = self.filter(article__other_read=True) |
| 89 | + else: |
| 90 | + q = self.filter( |
| 91 | + Q(article__other_read=True) |
| 92 | + | Q(article__owner=user) |
| 93 | + | (Q(article__group__user=user) & Q(article__group_read=True)) |
| 94 | + ).annotate(Count("id")) |
| 95 | + return q |
| 96 | + |
| 97 | + |
| 98 | + |
| 99 | +## ... source file abbreviated to get to EmptyQuerySet examples ... |
| 100 | + |
| 101 | + |
| 102 | + |
| 103 | + def can_read(self, user): |
| 104 | + return self.get_queryset().can_read(user) |
| 105 | + |
| 106 | + def can_write(self, user): |
| 107 | + return self.get_queryset().can_write(user) |
| 108 | + |
| 109 | + |
| 110 | +class ArticleFkManager(models.Manager): |
| 111 | + def get_empty_query_set(self): |
| 112 | + return self.get_queryset().none() |
| 113 | + |
| 114 | + def get_queryset(self): |
| 115 | + return ArticleFkQuerySet(self.model, using=self._db) |
| 116 | + |
| 117 | + def active(self): |
| 118 | + return self.get_queryset().active() |
| 119 | + |
| 120 | + def can_read(self, user): |
| 121 | + return self.get_queryset().can_read(user) |
| 122 | + |
| 123 | + def can_write(self, user): |
| 124 | + return self.get_queryset().can_write(user) |
| 125 | + |
| 126 | + |
| 127 | +~~class URLPathEmptyQuerySet(EmptyQuerySet, ArticleFkEmptyQuerySetMixin): |
| 128 | + def select_related_common(self): |
| 129 | + return self |
| 130 | + |
| 131 | + def default_order(self): |
| 132 | + return self |
| 133 | + |
| 134 | + |
| 135 | +class URLPathQuerySet(QuerySet, ArticleFkQuerySetMixin): |
| 136 | + def select_related_common(self): |
| 137 | + return self.select_related( |
| 138 | + "parent", "article__current_revision", "article__owner" |
| 139 | + ) |
| 140 | + |
| 141 | + def default_order(self): |
| 142 | + return self.order_by("article__current_revision__title") |
| 143 | + |
| 144 | + |
| 145 | +class URLPathManager(TreeManager): |
| 146 | + def get_empty_query_set(self): |
| 147 | + return self.get_queryset().none() |
| 148 | + |
| 149 | + def get_queryset(self): |
| 150 | + return URLPathQuerySet(self.model, using=self._db).order_by( |
| 151 | + self.tree_id_attr, self.left_attr |
| 152 | + Q(article__other_write=True) |
| 153 | + | Q(article__owner=user) |
| 154 | + | (Q(article__group__user=user) & Q(article__group_write=True)) |
| 155 | + ).annotate(Count("id")) |
| 156 | + return q |
| 157 | + |
| 158 | + def active(self): |
| 159 | + return self.filter(article__current_revision__deleted=False) |
| 160 | + |
| 161 | + |
| 162 | +class ArticleFkEmptyQuerySetMixin: |
| 163 | + def can_read(self, user): |
| 164 | + return self |
| 165 | + |
| 166 | + def can_write(self, user): |
| 167 | + return self |
| 168 | + |
| 169 | + def active(self): |
| 170 | + return self |
| 171 | + |
| 172 | + |
| 173 | +class ArticleFkQuerySet(ArticleFkQuerySetMixin, QuerySet): |
| 174 | + pass |
| 175 | + |
| 176 | + |
| 177 | +~~class ArticleFkEmptyQuerySet(ArticleFkEmptyQuerySetMixin, EmptyQuerySet): |
| 178 | + pass |
| 179 | + |
| 180 | + |
| 181 | +class ArticleManager(models.Manager): |
| 182 | + def get_empty_query_set(self): |
| 183 | + return self.get_queryset().none() |
| 184 | + |
| 185 | + def get_queryset(self): |
| 186 | + return ArticleQuerySet(self.model, using=self._db) |
| 187 | + |
| 188 | + def active(self): |
| 189 | + return self.get_queryset().active() |
| 190 | + |
| 191 | + |
| 192 | +## ... source file continues with no further EmptyQuerySet examples... |
| 193 | + |
| 194 | +``` |
| 195 | + |
0 commit comments