Login

QLeftOuterJoins

Author:
dottedmag
Posted:
June 10, 2007
Language:
Python
Version:
.96
Tags:
q query join left outer
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. Left Outer join Q object by karsu 7 years, 10 months ago
  2. Get derived model instance by werehuman 1 year, 6 months ago
  3. Self Join Possible? by slacy 4 years, 4 months ago
  4. Q marshaller by SpikeekipS 7 years ago
  5. QSerializer with default to JSON input and output by asfaltboy 1 year, 4 months ago

Comments

Please login first before commenting.