From 9f77032ba60a7d98f3dd38672cd957d1ea8d02e6 Mon Sep 17 00:00:00 2001
From: Guillaume Pellerin <yomguy@parisson.com>
Date: Fri, 26 Apr 2013 15:26:24 +0200
Subject: [PATCH] add new query manager

---
 postman/query.py | 98 ++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 98 insertions(+)
 create mode 100644 postman/query.py

diff --git a/postman/query.py b/postman/query.py
new file mode 100644
index 0000000..92252cd
--- /dev/null
+++ b/postman/query.py
@@ -0,0 +1,98 @@
+from __future__ import unicode_literals
+import new
+from types import MethodType
+
+from django.db.models.sql.query import Query
+
+class Proxy(object):
+    """
+    Code base for an instance proxy.
+    """
+
+    def __init__(self, target):
+        self._target = target
+
+    def __getattr__(self, name):
+        target = self._target
+        f = getattr(target, name)
+        if isinstance(f, MethodType):
+            # print name,'()'
+            return new.instancemethod(f.im_func, self, target.__class__)
+        else:
+            # print name
+            return f
+
+    def __setattr__(self, name, value):
+        # print name, '=', value
+        if name != '_target':
+            setattr(self._target, name, value)
+        else:
+            object.__setattr__(self, name, value)
+
+class CompilerProxy(Proxy):
+    """
+    A proxy to a compiler.
+    """
+
+    # @Override
+    def as_sql(self, *args, **kwargs):
+        sql, params = self._target.as_sql(*args, **kwargs)
+        # mimics compiler.py/SQLCompiler/get_from_clause() and as_sql()
+        qn = self.quote_name_unless_alias
+        qn2 = self.connection.ops.quote_name
+        alias = self.query.tables[0]
+        name, alias, join_type, lhs, lhs_col, col, nullable = self.query.alias_map[alias]
+        alias_str = (alias != name and ' {0}'.format(alias) or '')
+        clause = 'FROM {0}{1}'.format(qn(name), alias_str)
+        index = sql.index(clause) + len(clause)
+        extra_table, extra_params = self.union(self.query.pm_get_extra())
+        # print extra_table, extra_params
+        new_sql = [
+            sql[:index],
+            ' {0} ({1}) {2} ON ({3}.{4} = {2}.{5})'.format(
+                self.query.INNER, extra_table, self.query.pm_alias_prefix, qn(alias), qn2('id'), qn2('id')),
+        ]
+        if index < len(sql):
+            new_sql.append(sql[index:])
+        new_sql = ''.join(new_sql)
+        # print new_sql
+        return new_sql, extra_params + params
+
+    def union(self, querysets):
+        """
+        Join several querysets by a UNION clause. Returns the SQL string and the list of parameters.
+        """
+        result_sql, result_params = [], []
+        for qs in querysets:
+            sql, params = qs.query.sql_with_params()
+            result_sql.append(sql)
+            result_params.extend(params)
+        return ' UNION '.join(result_sql), tuple(result_params)
+
+class PostmanQuery(Query):
+    """
+    A custom SQL query.
+    """
+    pm_alias_prefix = 'PM'
+
+    # @Override
+    def __init__(self, *args, **kwargs):
+        super(PostmanQuery, self).__init__(*args, **kwargs)
+        self._pm_table = None
+
+    # @Override
+    def clone(self, *args, **kwargs):
+        obj = super(PostmanQuery, self).clone(*args, **kwargs)
+        obj._pm_table = self._pm_table
+        return obj
+
+    # @Override
+    def get_compiler(self, *args, **kwargs):
+        compiler = super(PostmanQuery, self).get_compiler(*args, **kwargs)
+        return CompilerProxy(compiler)
+
+    def pm_set_extra(self, table):
+        self._pm_table = table
+
+    def pm_get_extra(self):
+        return self._pm_table
-- 
2.39.5