models.py

from django.db import models

from outer_join import WritableOuterJoin, OuterJoinInterceptor
from outer_join.extra.models import AbstractDeleteRecord
from outer_join.extra.queryset import exclude_exact


class B0(models.Model):
    key = models.IntegerField(unique=True)

    val = models.IntegerField()


class B1(AbstractDeleteRecord):
    _save_check_fields = ('key',)

    key = models.IntegerField(unique=True)

    val = models.IntegerField(null=True)


class B(models.Model):
    key = models.IntegerField(primary_key=True)

    val = models.IntegerField(null=True)

    is_deleted = models.BooleanField(null=True)

    class Meta:
        managed = False
        base_manager_name = 'base_objects'

    outer_join = WritableOuterJoin(
        B1, B0,
        on='key',
    )
    objects = outer_join.get_manager(
        filter_initial_queryset=exclude_exact('is_deleted', True),
    )()
    base_objects = outer_join.get_manager()()


class A(models.Model):
    key = models.IntegerField(unique=True)
    b = models.ForeignKey(
        B, related_name='a_set', on_delete=models.SET_NULL,
        # IMPORTANT: cannot have db_constraint since it's not referencing a real table
        db_constraint=False,
        null=True,
    )
    models.ManyToManyField(B, db_constraint=False)

    val = models.IntegerField()

    class Meta:
        base_manager_name = 'objects'

    interceptor = OuterJoinInterceptor()
    objects = interceptor.get_manager()()