如何使用ORM对一到许多关系表执行查询？

Question

请求中的数据

city_name = 'Nashik'
tags = ['tag 1','tag 2', 'tag 3']

我

ws = WorkSamplesModel.objects.filter(business_account__serviceareasmodel__city_name=city_name,
        business_account__professiontagsmodel__tag_name__in=tags_list,
        is_business_card_image=True).distinct()

现在尝试business_title，business_description，status，status，note从businessAccountmodel和 work_sample_image，work_sample_description，is_business_card_image来自WorksamPlemodel和 user_name，profile_pic来自usermodel

如何为其创建序列化器？

模型 我想使用city_name和标签找到特定的businessAccountmodel 然后为每个BusinessAccountModel一个Works示例模型。

class BusinessAccountModel(models.Model):
    business_title = models.CharField(max_length=70)
    business_description = models.CharField(max_length=500)
    status = models.CharField(max_length=100)
    note = models.CharField(max_length=200)
    user = models.OneToOneField(UserModel,on_delete=models.CASCADE)

    class Meta:
        db_table = 'wp_business_acc'


class ProfessionTagsModel(models.Model):
    tag_name = models.CharField(max_length=20)
    business_account = models.ForeignKey(BusinessAccountModel,on_delete=models.CASCADE)

    class Meta:
        db_table = 'profession_tags'


class ServiceAreasModel(models.Model):
    city_name = models.CharField(max_length=20)
    business_account = models.ForeignKey(BusinessAccountModel,on_delete=models.CASCADE)
    
    class Meta:
        db_table = 'service_areas'


class WorkSamplesModel(models.Model):
    work_sample_image = models.ImageField(blank=True,null=True,upload_to="work_samples")
    work_sample_description = models.CharField(max_length=1000)
    is_business_card_image = models.BooleanField(default=False)
    business_account = models.ForeignKey(BusinessAccountModel,on_delete=models.CASCADE)

    class Meta:
        db_table = 'work_samples'

BusinessAccountModel -PortyTagsModel：1：M

BusinessAccountModel- ServiceAreasModel：1：M

BusinessAccountModel -WorksamplesModel：1：M

Answer 1

ws = WorkSamplesModel.objects.filter(business_account__serviceareasmodel__city_name=city_name,
        business_account__professiontagsmodel__tag_name__in=tags_list,
        is_business_card_image=True).distinct()

序列化器

class SearchWorkingProgessionalsSerializers(serializers.Serializer):
    business_title = serializers.CharField(source='business_account.business_title')
    business_description = serializers.CharField(source='business_account.business_description')
    status = serializers.CharField(source='business_account.status')
    note = serializers.CharField(source='business_account.note')
    work_sample_image = serializers.ImageField()
    work_sample_description = serializers.CharField(max_length=1000)