Как связать 3 модели / таблицы и фильтровать по значению в django

В моей базе данных есть три таблицы:

счет.клиент с полем "id"

account_customer_groups с полем "group_id"

auth_group с полем "имя"

как связать с object.filter эти 3 модели для выбора поля "name" таблицы auth_group, которое имеет значение "myvalue"

my accounts/models.py

from django.contrib.auth.models import AbstractBaseUser, BaseUserManager, PermissionsMixin
from django.db import models


class CustomUserManager(BaseUserManager):
    def create_user(self, email, password):
        if not email:
            raise ValueError('Vous devez entrer une adresse email.')
        email = self.normalize_email(email)
        user = self.model(email=email)
        user.set_password(password)
        user.save()
        return user

    def create_superuser(self, email, password):
        user = self.create_user(email=email, password=password)
        user.is_staff = True
        user.is_admin = True
        user.save()
        return user


class CustomUser(AbstractBaseUser, PermissionsMixin):
    email = models.EmailField(
        max_length=255,
        unique=True,
        blank=False
    )
    nom = models.CharField(max_length=50, blank=False, unique=True)

    is_active = models.BooleanField(default=True)
    is_staff = models.BooleanField(default=False)
    is_admin = models.BooleanField(default=False)

    objects = CustomUserManager()

    USERNAME_FIELD = "email"

    def has_perm(self, perm, obj=None):
        return True

    def has_module_perms(self, app_label):
        "Does the user have permissions to view the app `app_label`?"

        return True

    def __str__(self):
        return self.email

и мой catalog/views.py

from django.shortcuts import render

from catalog.models import Book, Author, BookInstance, Genre
from accounts.models import CustomUser

from django.views.generic import ListView, DetailView

from django.contrib.auth.models import Group



class BookDetailView(DetailView):
    """Generic class-based detail view for a book."""
    model = Book


class AuthorListView(ListView):
    """Generic class-based list view for a list of authors."""
    model = Author
    paginate_by = 10


class AuthorDetailView(DetailView):
    """Generic class-based detail view for an author."""
    model = Author
Вернуться на верх