Как связать 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