python - 我无法根据对另一个模型的一对一字段引用中的字段进行过滤

Question

我希望能够在 Student 中过滤电子邮件。就像我这样做:Student.objects.get(email="k@gmail.com")

学生有 email="k@gmail.com"的行被返回。

我试过使用以下版本，但出现了这个错误:

ValueError: invalid literal for int() with base 10: 'kkk@gmail.com'

我也试过打印出类型:

View .py

for l in ll:
        print(type(l.email.email)). # got <class 'str'>
        print(type(l.language_to_learn))

print(type(l.email)) # got <class 'users.models.CustomUser'>


def profile_list(request):
    profile=Student.objects.get(email=request.user.email)
    return render(request,'view_profile.html',{'profile':profile})

模型.py

class Student(models.Model):
          email=models.OneToOneField(CustomUser,on_delete=models.CASCADE,primary_key=True,)
      language_to_learn=models.CharField(max_length=20,choices=Language_Choices,default='English',)
    REQUIRED_FIELDS=['language_to_learn',]

class CustomUser(AbstractUser):
    username = None
    email = models.EmailField('email address' ,unique=True,blank=False, null=False) 
    USERNAME_FIELD = 'email'
    fullname=models.CharField('Full name',max_length=50,null=True)
    REQUIRED_FIELDS = [] # removes email from REQUIRED_FIELDS
    objects = UserManager()

Answer 1

首先，您应该将 models.py email 字段更改为 user 而不是 email 以避免混淆。

class Student(models.Model):      
  user=models.OneToOneField(CustomUser, on_delete=models.CASCADE, primary_key=True)

然后查询like。

profile=Student.objects.get(user__email=request.user.email)

If you don't want to change the field name. Then you should do like below coz email is a field of related OneToOneField of CustomUser.

profile=Student.objects.get(email__email=request.user.email)