我究竟做錯了什么？

Django 模型：

用戶模型

class User(AbstractUser):

    # DEFINE MODEL FIELDS
    related_person  = models.OneToOneField(Person, on_delete=models.CASCADE, default='')
    user_id         = models.BigAutoField(verbose_name='User ID', primary_key=True, serialize=False, auto_created=True)
    email           = models.EmailField(verbose_name='Email', max_length=80, blank=False, unique=True, null=False, default='')
    is_verified     = models.BooleanField(verbose_name='Email Verified', blank=False, default=False)
    date_joined     = models.DateField(verbose_name='date joined', auto_now_add=True, null=True)
    last_login      = models.DateField(verbose_name='last login', auto_now=True, null=True)
    is_active       = models.BooleanField(default=True)
    is_admin        = models.BooleanField(default=False)
    is_staff        = models.BooleanField(default=False)
    is_superuser    = models.BooleanField(default=False)
    first_name      = None
    last_name       = None
    username        = None

    # IMPORT MODEL MANAGER CLASS
    objects = UserManager()

    # SET LOGIN FIELD
    USERNAME_FIELD = 'email'

# SET REQUIRED FIELDS
REQUIRED_FIELDS = ['is_verified']

人物模型

class Person(models.Model):

    class Titles(models.TextChoices):
        MR = 'Mr', _('Mr')
        MRS = 'Mrs', _('Mrs')
        MISS = 'Miss', _('Miss')
        MS = 'Ms', _('Ms')
        DR = 'Dr', _('Dr')

    related_entity  = models.OneToOneField(Entity, on_delete=models.CASCADE)
    person_id       = models.BigAutoField(verbose_name='Person ID', primary_key=True, serialize=False, auto_created=True)
    first_name      = models.CharField(verbose_name='First Name', max_length=50, blank=False, null=False)
    last_name       = models.CharField(verbose_name='Last Name', max_length=50, blank=False, null=False)
    title           = models.CharField(verbose_name='Title', max_length=4, choices=Titles.choices, blank=True, null=False, default='')
    alias           = models.CharField(verbose_name='Alias', max_length=150, blank=True, null=False)

物體模型

class Entity(models.Model):

    class EntityTypes(models.TextChoices):
        PERSON = 'Person', _('Person')
        COMPANY = 'Company', _('Company')

    entity_type = models.CharField(
                verbose_name='Legal Entity Type', 
                max_length=7, 
                choices=EntityTypes.choices, 
                default=EntityTypes.PERSON, 
                blank=False, 
                null=False)

我有一個注冊表單，將一個人的電子郵件保存到用戶模型，并將密碼保存到用戶模型，在檢查電子郵件不存在后，密碼（當輸入兩次時）匹配。但是當我保存表單時出現此錯誤：

null value in column "related_person_id" of relation "customauth_user" violates not-null constraint
DETAIL:  Failing row contains (1, pbkdf2_sha256$320000$Ipsu5kX2Opd2a1j9996ReS$uPR4GCbSxS7 9 0KIAaE..., sachin@cantab.net, f, 2022-02-28, 2022-02-28, t, f, f, f, null).

有任何想法嗎？

模型背后的總體想法是允許某人通過用戶模型使用電子郵件和密碼進行注冊。然后，一旦他們登錄，他們就可以在Person模型中輸入他們的名字、姓氏、頭銜、別名等。

uj5u.com熱心網友回復：

您的用戶模型不允許將null設定為列的值related_person（Django 的 ORM 將其轉換related_person_id為 SQL）

默認情況下，這會導致SQL在該列上放置一個Null-Constraint。

但是，您可以通過簡單地將附加引數決議為Model的受影響列來阻止Django實作這樣的Constraint。null = True

因此，您可以簡單地將模型更改為：

class User(AbstractUser):

    # DEFINE MODEL FIELDS
    related_person  = models.OneToOneField(Person, on_delete=models.CASCADE, default='', null=True) # allowing null-values
    user_id         = models.BigAutoField(verbose_name='User ID', primary_key=True, serialize=False, auto_created=True)
    email           = models.EmailField(verbose_name='Email', max_length=80, blank=False, unique=True, null=False, default='')
    is_verified     = models.BooleanField(verbose_name='Email Verified', blank=False, default=False)
    date_joined     = models.DateField(verbose_name='date joined', auto_now_add=True, null=True)
    last_login      = models.DateField(verbose_name='last login', auto_now=True, null=True)
    is_active       = models.BooleanField(default=True)
    is_admin        = models.BooleanField(default=False)
    is_staff        = models.BooleanField(default=False)
    is_superuser    = models.BooleanField(default=False)
    first_name      = None
    last_name       = None
    username        = None

    # IMPORT MODEL MANAGER CLASS
    objects = UserManager()

    # SET LOGIN FIELD
    USERNAME_FIELD = 'email'

# SET REQUIRED FIELDS
REQUIRED_FIELDS = ['is_verified']

# ...

標籤：Python sql django PostgreSQL

上一篇：創建新帳戶時重新上傳默認影像

下一篇：如何使用條件連接串列中的專案