首頁猿問 Django 過濾外鍵項(xiàng)

Django 過濾外鍵項(xiàng)

Python

料青山看我應(yīng)如是 2023-10-31 15:58:09

我制作簡(jiǎn)單的日常清潔檢查應(yīng)用程序。該應(yīng)用程序很簡(jiǎn)單，用戶觀察某些區(qū)域并檢查這些區(qū)域是否干凈。經(jīng)過所有檢查后，用戶需要向批準(zhǔn)其日常清潔工作的當(dāng)局報(bào)告。這里的權(quán)威機(jī)構(gòu)是創(chuàng)建者、檢查者和簽名者。這里的 cln_daily 模型代表日常清潔工作，將有來自用戶模型的制造者、檢查者和簽名者。我有一個(gè)名為user的應(yīng)用程序，它在model.py中對(duì)用戶模型進(jìn)行了定制class User(AbstractUser): username = models.CharField(max_length=50, unique=True) email = models.EmailField(_('email address'), unique=True) phone = models.IntegerField(_('phone number'), unique=True, blank=True, null=True)該用戶與組查詢集具有多對(duì)多關(guān)系：創(chuàng)建者、檢查者、簽名者>>> print(Group.objects.all()) <QuerySet [<Group: maker>, <Group: checker>, <Group: signer>]>在另一個(gè)名為clean的應(yīng)用程序中，我有cln_daily模型，該模型與基于其組的用戶模型具有外鍵關(guān)系。class cln_daily(models.Model): . . user_maker = models.ForeignKey(User,verbose_name="Maker's Signature",on_delete=models.CASCADE, related_name="makerSignature", blank=True, null=True,) user_checker = models.ForeignKey(User, verbose_name="Checker's Signature",on_delete=models.CASCADE, related_name="checkerSignature", blank=True, null=True) user_signer = models.ForeignKey(User, verbose_name="Signer's Signature",on_delete=models.CASCADE, related_name="signerSignature", blank=True, null=True)所以我的意思是user_maker查詢集具有僅屬于組maker 的用戶。user_checker具有僅屬于組checker 的用戶，而user_signer查詢集具有僅屬于組signer 的用戶。如何在該model.py中表達(dá)過濾后的用戶模型？

查看完整描述

3 回答

繁星淼淼

TA貢獻(xiàn)1775條經(jīng)驗(yàn) 獲得超11個(gè)贊

經(jīng)過長(zhǎng)時(shí)間的尋找。我通過用表格解決它來欺騙它

class MCSForm(forms.ModelForm):

class Meta:

model = cln_daily

fields = ("__all__")

def __init__(self, *args, **kwargs):

super().__init__(*args, **kwargs)

self.fields['user_maker'].queryset = User.objects.filter(groups__name='maker')

self.fields['user_checker'].queryset = User.objects.filter(groups__name='checker')

self.fields['user_signer'].queryset = User.objects.filter(groups__name='signer')

反對(duì) 回復(fù) 2023-10-31

茅侃侃

TA貢獻(xiàn)1842條經(jīng)驗(yàn) 獲得超22個(gè)贊

我想我了解了您的問題，您想以簡(jiǎn)單的方式連接表格，對(duì)吧？，我建議看看這個(gè)和這個(gè)

并以這種方式修復(fù)這些模型關(guān)系，因?yàn)榈綍r(shí)候這將是一個(gè)問題：

class cln_daily(models.Model):

.

user_maker = models.ForeignKey(User,verbose_name="Maker's Signature",on_delete=models.CASCADE, related_name="makerSignature", blank=True, null=True,)

^^^^

user_checker = models.ForeignKey(User, verbose_name="Checker's Signature",on_delete=models.CASCADE, related_name="checkerSignature", blank=True, null=True)

^^^^^

user_signer = models.ForeignKey(User, verbose_name="Signer's Signature",on_delete=models.CASCADE, related_name="signerSignature", blank=True, null=True)

^^^^

最好不要使用in User，或者使用此模式作為 str （因?yàn)槟惚仨毾葘⑺鼘?dǎo)入到你的代碼中）：ForeignKeyFieldget_user_model()

class cln_daily(models.Model):

.

user_maker = models.ForeignKey('myapp.User',verbose_name="Maker's Signature",on_delete=models.CASCADE, related_name="makerSignature", blank=True, null=True,)

user_checker = models.ForeignKey('myapp.User', verbose_name="Checker's Signature",on_delete=models.CASCADE, related_name="checkerSignature", blank=True, null=True)

user_signer = models.ForeignKey('myapp.User', verbose_name="Signer's Signature",on_delete=models.CASCADE, related_name="signerSignature", blank=True, null=True)

因?yàn)槿绻闶?django 的新手，遲早會(huì)出現(xiàn)遷移問題

反對(duì) 回復(fù) 2023-10-31

尚方寶劍之說

TA貢獻(xiàn)1788條經(jīng)驗(yàn) 獲得超4個(gè)贊

我有更好的答案，而不是用形式來欺騙他們。在 FKField 中使用limit_choices_to

User = get_user_model()

class cln_daily(models.Model):

.

user_maker = models.ForeignKey(User,verbose_name="Maker's Signature",on_delete=models.CASCADE, related_name="makerSignature", blank=True, null=True,limit_choices_to={'groups__name':'maker'})

user_checker = models.ForeignKey(User, verbose_name="Checker's Signature",on_delete=models.CASCADE, related_name="checkerSignature", blank=True, null=True,limit_choices_to={'groups__name':'checker'})

user_signer = models.ForeignKey(User, verbose_name="Signer's Signature",on_delete=models.CASCADE, related_name="signerSignature", blank=True, null=True,limit_choices_to={'groups__name':'signer'})

反對(duì) 回復(fù) 2023-10-31