Context Navigation

Changes between Version 1 and Version 2 of Ticket #32449, comment 3

-              v1
+              v2
 {{{
 #!python
 # nodes/models.py
+# graph/models.py
 class Node(models.Model):
 …
 # b_qs is a really complex 'B' queryset
 b_qs = b_qs.objects.select_related('A').annotate(graph_child_count=RawSQL("""
     WITH RECURSIVE graph_children(id) AS (
+b_qs = b_qs.objects.select_related('a').annotate(graph_child_count=RawSQL("""
+    WITH RECURSIVE children(id) AS (
         SELECT "e"."child_id"
           FROM "nodes_edge" AS "e"
          WHERE "e"."parent_id" = "nodes_a"."node_id"
+          FROM "graph_edge" AS "e"
+         WHERE "e"."parent_id" = "graph_a"."node_id"
          UNION
         SELECT "e"."child_id"
           FROM "nodes_edge" AS "e", "graph_children"
          WHERE "e"."parent_id" = "graph_children"."id"
+          FROM "graph_edge" AS "e", "children"
+         WHERE "e"."parent_id" = "children"."id"
     ) SELECT COUNT(*) FROM "graph_children"
 """, [])).filter(graph_child_count__lt=10).count()