И это всё МОЁ
class Gender(models.Model):
name = models.TextField()
class Meta:
verbose_name = "Person gender"
verbose_name_plural = "Person gender's"
indexes = [
models.Index(fields=["name",]),
]
def __str__(self):
return "name: %s" % (self.name)
class GenderName(models.Model):
name_id = models.ForeignKey(Gender, on_delete=models.PROTECT, related_name='gender_data')
name_trans = models.TextField(verbose_name="Перевод"
lang = models.CharField(
max_length=2, choices=settings.LANGUAGES, verbose_name="Язык перевода"
)
class Meta:
verbose_name = "Person gender name"
verbose_name_plural = "Person gender name's"
indexes = [
models.Index(fields=["name_trans",]),
models.Index(fields=["lang",]),
]
def __str__(self):
return "| name_id: %s| name_trans: %s | lang: %s |" % (self.name_id or None, self.name_trans, self.lang)
class PersonProfile(models.Model):
gender = models.ForeignKey(
Gender, on_delete=models.PROTECT, related_name="person_gender", blank=True, null=True
)
Как зарезольвить в queryset PersonProfile поле gender по GenderName.lang?