Skip to main content
This is a pre-production deployment of Warehouse. Changes made here affect the production instance of PyPI (
Help us improve Python packaging - Donate today!

Facility of complex sql expressions for Django orm.

Project Description

Django by default, provides a wide range of field types and generic lookups for queries. This in many cases is more than enough. But there are cases where you need to use types defined for yourself and search operators that are not defined in django lookups and another important case is to make searches requiring the execution of some function in WHERE clause.

In django, for these last two cases, it requires writing SQL statements. djorm-ext-expressions introduces the method manager.where() and some class’es (SqlExpression, SqlFunction, AND, OR, …) to facilite sql construction for advanced cases.

Simple usage

Imagine some django model with postgresql integer array field. You need to find objects in the field containing a set of group numbers.

NOTE: array field is part of django orm extensions package and is located on djorm-ext-pgarray submodule.

Example model definition

from django.db import models
from djorm_expressions.models import ExpressionManager
from .somefiels import ArrayField

class Register(models.Model):
    name = models.CharField(max_length=200)
    points = ArrayField(dbtype="int")

    objects = ExpressionManager()

With this model definition, we can do this searches:

from djorm_expressions.base import SqlExpression, AND, OR

# search all register items that points field contains [2,3]

qs = Register.manager.where(
    SqlExpression("points", "@>", [2,3])

# search all register items that points fields contains [2,3] or [5,6]

expression = OR(
    SqlExpression("points", "@>", [2,3]),
    SqlExpression("points", "@>", [5,6]),

qs = Register.objects.where(expression)

Also, we can use functions to construct a expression:

from djorm_expressions.base import SqlFunction

class BitLength(SqlFunction):
    sql_function = "bit_length"

# search all registers items that bit_length(name) > 20.
qs = Register.objects.where(
    SqlExpression(BitLength("name"), ">", 20)

I finally can redefine the behavior “SqlExpression” and make it more “object oriented”:

class ArrayExpression(object):
    def __init__(self, field):
        self.field = field

    def contains(self, value):
        return SqlExpression(self.field, "@>", value)

    def overlap(self, value):
        return SqlExpression(self.field, "&&", value)

# search all register items that points field contains [2,3]
qs = Register.objects.where(

Release History

This version
History Node


History Node


History Node


History Node


History Node


History Node


History Node


Download Files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

File Name & Hash SHA256 Hash Help Version File Type Upload Date
(5.8 kB) Copy SHA256 Hash SHA256
Source Nov 7, 2013

Supported By

WebFaction WebFaction Technical Writing Elastic Elastic Search Pingdom Pingdom Monitoring Dyn Dyn DNS Sentry Sentry Error Logging CloudAMQP CloudAMQP RabbitMQ Heroku Heroku PaaS Kabu Creative Kabu Creative UX & Design Fastly Fastly CDN DigiCert DigiCert EV Certificate Rackspace Rackspace Cloud Servers DreamHost DreamHost Log Hosting