1 | from types import MethodType
|
---|
2 | from django.db import models
|
---|
3 | from django.db.models.query import QuerySet
|
---|
4 | from django.db.models.query import EmptyQuerySet
|
---|
5 |
|
---|
6 | class ManagerQuerySetDecorator(models.Manager):
|
---|
7 | """
|
---|
8 | Extends the operation methods of the manager on subqueries QuerySet objects.
|
---|
9 |
|
---|
10 | The "standard manager" you can only like this:
|
---|
11 | SomeModel.object.some_method_manager().all().filter(...). ...
|
---|
12 |
|
---|
13 | But this does not work:
|
---|
14 | SomeModel.object.all().some_method_manager()
|
---|
15 |
|
---|
16 | And this it works with the use of this class / patches:
|
---|
17 | SomeModel.object.all().some_method_manager().filter(...).some_method_manager2(). ...
|
---|
18 | SomeModel.object.some_method_manager().some_method_manager2().some_method_manager3(). ...
|
---|
19 |
|
---|
20 | Extension of the methods manager on all child objects "QuerySeth".
|
---|
21 |
|
---|
22 | Example:
|
---|
23 |
|
---|
24 | class Animals(models.Model):
|
---|
25 | type = models.CharField('Type of animal') # dog, cat, elephant
|
---|
26 | color = models.CharField('Colour Name')
|
---|
27 |
|
---|
28 | objects = AnimalsManager()
|
---|
29 |
|
---|
30 | class AnimalsManager(ManagerQuerySetDecorator):
|
---|
31 |
|
---|
32 | def get_dogs(self):
|
---|
33 | return self.get_query_set().filter(type='dog')
|
---|
34 | get_dogs.queryset_method = True
|
---|
35 |
|
---|
36 | def get_cats(self):
|
---|
37 | return self.get_query_set().filter(type='cat')
|
---|
38 | get_cats.queryset_method = True
|
---|
39 |
|
---|
40 | def get_white_animals(self):
|
---|
41 | return self.get_query_set().filter(color='white')
|
---|
42 | get_white_animals.queryset_method = True
|
---|
43 |
|
---|
44 | def get_black_animals(self):
|
---|
45 | return self.get_query_set().filter(color='black')
|
---|
46 | get_black_animals.queryset_method = True
|
---|
47 |
|
---|
48 | def get_brown_animals(self):
|
---|
49 | return self.get_query_set().filter(color='black')
|
---|
50 |
|
---|
51 |
|
---|
52 | Animals(type='dog', color='black').save()
|
---|
53 | Animals(type='dog', color='bown').save()
|
---|
54 | Animals(type='dog', color='white').save()
|
---|
55 | Animals(type='cat', color='black').save()
|
---|
56 | Animals(type='cat', color='bown').save()
|
---|
57 | Animals(type='cat', color='white').save()
|
---|
58 |
|
---|
59 | animals = Animals.objects.get_black_animals().get_dogs()
|
---|
60 | # return list black dogs
|
---|
61 |
|
---|
62 | animals = Animals.objects.get_white_animals().get_cats()
|
---|
63 | # return list white cats
|
---|
64 |
|
---|
65 | # When ffff equals False, or not defined (as it is in
|
---|
66 | # the original model manager), we can not perform such an operation:
|
---|
67 | animals = Animals.objects.get_cats().get_brown_animals()
|
---|
68 | # return:
|
---|
69 | # AttributeError: 'QuerySet' object has no attribute 'get_brown_animals'
|
---|
70 |
|
---|
71 | # but:
|
---|
72 | animals = Animals.objects.get_brown_animals().get_cats()
|
---|
73 | # return brown cats, because get_cat() present in all parent object instances.
|
---|
74 | """
|
---|
75 |
|
---|
76 | def _get_queryset_class(self):
|
---|
77 | class ManagerQuerySet(QuerySet):
|
---|
78 | def none(self):
|
---|
79 | """
|
---|
80 | Returns an empty QuerySet.
|
---|
81 | """
|
---|
82 | klass = type(
|
---|
83 | "_InstrumentedEmptyQuerySet_%s" % self.__class__.__name__,
|
---|
84 | (EmptyQuerySet, self.__class__), {})
|
---|
85 | return self._clone(klass=klass)
|
---|
86 | for attrib_name in dir(self):
|
---|
87 | attrib = self.__getattribute__(attrib_name)
|
---|
88 | if isinstance(attrib, MethodType) and hasattr(attrib, 'queryset_method') and attrib.queryset_method:
|
---|
89 | setattr(ManagerQuerySet, attrib_name, attrib)
|
---|
90 | return ManagerQuerySet
|
---|
91 |
|
---|
92 | def get_query_set(self):
|
---|
93 | return self._get_queryset_class()(self.model, using=self._db)
|
---|
94 |
|
---|
95 |
|
---|