Skip to main content

Django Custom Chainable QuerySets

How to reuse custom defined 'models.Manager' QuerySets

Django recommends to define custom query sets on your sublcassed models.Manager, there is one problem however that these are not chainable, that is you can only call your custom queryset once - assuming I have defined an '.active()' queryset the following will not work:

Traceback (most recent call last):
  File "", line 1, in 
AttributeError: 'PaymentTermManager' object has no attribute 'active'

Current solutions on the web involve creating a subclassed 'models.Manager' and a custom 'QuerySet' which do work but are to code verbose for my linking. I believe the below approach is simpler, cleaner and more succinct.

class OfferManager(models.Manager):
  (STATUS_DISABLED, "Disabled"),
  (STATUS_ENABLED, "Enabled"),
  (STATUS_NEGOTIATED, "Negotiated"),
  (STATUS_ARCHIVED, "Archived"),
  def get_query_set(self):
   """ Assing a modified QuerySet to include our chainable QuerySets """
   class OfferManagerQuerySet(QuerySet): # clone QuerySet
  # explictly copy our QuerySet methods
  OfferManagerQuerySet.public = self.public =

  return QuerySetDynamicallyCreated(self.model, using=self._db)
 def public(self):
  """ Returns all entries accessible through front end site"""
  return self.all().filter(**OfferManager.QUERYSET_PUBLIC_KWARGS)
 public.chainable = True
 def active(self):
  """ returns offers that are open to negotiation """
  return self.public().filter(**OfferManager.QUERYSET_ACTIVE_KWARGS)


Django patch for model.Manager chainable QuerySets

Please take a look at Django Ticket #20625 with a github Django branch for new proposed method for defining chainable filters based on this idea which works through a 'chainable == True' attribute as shown below:

class OfferManager(models.Manager):

    def public(self):
        """ Returns all entries accessible through front end site"""
        return self.all().filter(...)
    public.chainable = True     # instructs to dynamically tranplat this method onto
                                # returned QuerySet as .public(...) 
                                # effectively providing chainable custom QuerySets

    def active(self):
        """ Returns offers that are open to negotiation """
        return self.public().filter(**OfferManager.QUERYSET_ACTIVE_KWARGS)
                                    # an example of how to reffer to OfferManager
                                    # constants as 'self' context changes
    active.chainable = True

As always feel free to comment or follow me on twitter @danielsokolowski


Popular posts from this blog

Opera SOCKS Proxy Setup Issues

SOCKS error: Connection closed by remote server When setting up SOCKS only proxy in Opera web browser make sure to specify the IP address instead of your fully qualified domain name (FQDN). Using a host name will not work and Opera simply fails to connect to the proxy server. Sample working setup screen shot with a Dante proxy server , note that HTTP, HTTPS, FTP, SSH options are left blank. Bug DSK-364301 has been filled with Opera, if it has been a while since this post and the issue still not fixed feel free to add your word of encouragement by emailing :)

Storing passwords in PuTTY

How to save SSH username/password for auto login in PuTTy The answer is you can't do least in plain PuTTy. However there is an awesome fork with that let's you store the username and password and other additional features called KiTTy.

So grab yourself a copy and +1 this if you do, thanks.

How to child proof a fireplace

DIY - Do it yourself fireplace child guard Our wonderful 8.5 month old Sofia has become a crawling race car with an untamed thirst for exploration. And so with the cold nights approaching we needed to child proof the fireplace. This however proved to be more difficult than would reasonably expect, I've checked the local Toys "R" Us, Walmart, and even a Canadian Tire with no success for a ready to use product. Internet search was more fruitful and returned a few online stores one could order from, however in all honestly they didn't look too sturdy to me. So I build my own relatively quickly and inexpensively. Materials needed is a privacy plastic lattice - the smallest hole pattern - a few screws and anchors; tools needed are a drill, and a handsaw if you don't have the lattice cut at the store - that’s it. The construction consits of screwing the lattice into the wall and the final product is easiest explained through following pictures. Feel free to +1 this po…