Login

QLeftOuterJoins

Author:
dottedmag
Posted:
June 10, 2007
Language:
Python
Version:
.96
Score:
6 (after 6 ratings)

This hack replaces all INNER JOINs inside to the LEFT OUTER JOINs (see http://code.djangoproject.com/ticket/3592 for explanation).

Use: QLeftOuterJoins(Q(...) | Q(...) & (Q(...) | ....)).

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
from django.db.models.query import Q, QAnd, QOr

class QLeftOuterJoins(Q):
    "Replaces all INNER JOINs with LEFT OUTER JOINs inside"
    def __init__(self, q):
        self.q = q

    def __and__(self, other):
        return QAnd(self, other)

    def __or__(self, other):
        return QOr(self, other)

    def get_sql(self, opts):
        joins, where, params = self.q.get_sql(opts)
        for join_name, join in joins.iteritems():
            joins[join_name] = (join[0], "LEFT OUTER JOIN", join[2])
        return joins, where, params

More like this

  1. FileField having auto upload_to path by junaidmgithub 1 month ago
  2. LazyPrimaryKeyRelatedField by LLyaudet 1 month, 1 week ago
  3. CacheInDictManager by LLyaudet 1 month, 1 week ago
  4. MYSQL Full Text Expression by Bidaya0 1 month, 1 week ago
  5. Custom model manager chaining (Python 3 re-write) by Spotted1270 1 month, 2 weeks ago

Comments

Please login first before commenting.