首页 \ 问答 \ Django Rest框架 - 在序列化程序中获取相关模型字段(Django Rest Framework - Get related model field in serializer)

Django Rest框架 - 在序列化程序中获取相关模型字段(Django Rest Framework - Get related model field in serializer)

 我正在尝试从Django Rest框架返回一个HttpResponse，包括来自2个链接模型的数据。 模型是：  
class Wine(models.Model):

    color = models.CharField(max_length=100, blank=True)
    country = models.CharField(max_length=100, blank=True)
    region = models.CharField(max_length=100, blank=True)
    appellation = models.CharField(max_length=100, blank=True)

class Bottle(models.Model):

    wine = models.ForeignKey(Wine, null=False)
    user = models.ForeignKey(User, null=False, related_name='bottles')
 
 我想要一个瓶子模型的序列化器，其中包括相关葡萄酒的信息。  
 我试过了：  
class BottleSerializer(serializers.HyperlinkedModelSerializer):
    wine = serializers.RelatedField(source='wine')

    class Meta:
        model = Bottle
        fields = ('url', 'wine.color', 'wine.country', 'user', 'date_rated', 'rating', 'comment', 'get_more')
 
 这不行。  
 有什么想法我该怎么做？  
 谢谢 ：） 

I'm trying to return a HttpResponse from Django Rest Framework including data from 2 linked models. The models are: 
class Wine(models.Model):

    color = models.CharField(max_length=100, blank=True)
    country = models.CharField(max_length=100, blank=True)
    region = models.CharField(max_length=100, blank=True)
    appellation = models.CharField(max_length=100, blank=True)

class Bottle(models.Model):

    wine = models.ForeignKey(Wine, null=False)
    user = models.ForeignKey(User, null=False, related_name='bottles')
 
I'd like to have a serializer for the Bottle model which includes information from the related Wine. 
I tried: 
class BottleSerializer(serializers.HyperlinkedModelSerializer):
    wine = serializers.RelatedField(source='wine')

    class Meta:
        model = Bottle
        fields = ('url', 'wine.color', 'wine.country', 'user', 'date_rated', 'rating', 'comment', 'get_more')
 
which doesn't work. 
Any ideas how I could do that? 
Thanks :)

原文：https://stackoverflow.com/questions/20633313

更新时间：2023-07-13 15:07

最满意答案

Declare @Transaction table (UserID int,TransDate Date,UserBalance int)
Insert into @Transaction Select 33782,'2016-05-13',233
Insert into @Transaction Select 33783,'2016-05-13',143
Insert into @Transaction Select 30070,'2016-05-20',572
Insert into @Transaction Select 30071,'2016-05-20',888

Declare @Calendar table (UserID int,BalanceDate date)
Insert into @Calendar Select 33782,'2016-05-13'
Insert into @Calendar Select 33783,'2016-05-13' 
Insert into @Calendar Select 30070,'2016-05-13'
Insert into @Calendar Select 30071,'2016-05-13' 
Insert into @Calendar Select 33782,'2016-05-20'  
Insert into @Calendar Select 33783,'2016-05-20'  
Insert into @Calendar Select 30070,'2016-05-20'  
Insert into @Calendar Select 30071,'2016-05-20'  



Select A.*,UserBalance=isnull((Select top 1 UserBalance From @Transaction Where UserID=A.UserID and TransDate<=A.BalanceDate Order by TransDate Desc),0)
 From (
        Select UserID,balanceDate
         From (Select Distinct UserID from @Calendar) U
         Join (Select Distinct balanceDate  from @Calendar) C on 1=1
      ) A
 Order by 2,1 Desc
 
 返回  
UserID  balanceDate UserBalance
33783   2016-05-13  143
33782   2016-05-13  233
30071   2016-05-13  0
30070   2016-05-13  0
33783   2016-05-20  143
33782   2016-05-20  233
30071   2016-05-20  888
30070   2016-05-20  572

Declare @Transaction table (UserID int,TransDate Date,UserBalance int)
Insert into @Transaction Select 33782,'2016-05-13',233
Insert into @Transaction Select 33783,'2016-05-13',143
Insert into @Transaction Select 30070,'2016-05-20',572
Insert into @Transaction Select 30071,'2016-05-20',888

Declare @Calendar table (UserID int,BalanceDate date)
Insert into @Calendar Select 33782,'2016-05-13'
Insert into @Calendar Select 33783,'2016-05-13' 
Insert into @Calendar Select 30070,'2016-05-13'
Insert into @Calendar Select 30071,'2016-05-13' 
Insert into @Calendar Select 33782,'2016-05-20'  
Insert into @Calendar Select 33783,'2016-05-20'  
Insert into @Calendar Select 30070,'2016-05-20'  
Insert into @Calendar Select 30071,'2016-05-20'  



Select A.*,UserBalance=isnull((Select top 1 UserBalance From @Transaction Where UserID=A.UserID and TransDate<=A.BalanceDate Order by TransDate Desc),0)
 From (
        Select UserID,balanceDate
         From (Select Distinct UserID from @Calendar) U
         Join (Select Distinct balanceDate  from @Calendar) C on 1=1
      ) A
 Order by 2,1 Desc
 
Returns 
UserID  balanceDate UserBalance
33783   2016-05-13  143
33782   2016-05-13  233
30071   2016-05-13  0
30070   2016-05-13  0
33783   2016-05-20  143
33782   2016-05-20  233
30071   2016-05-20  888
30070   2016-05-20  572

Django Rest框架 - 在序列化程序中获取相关模型字段(Django Rest Framework - Get related model field in serializer)

最满意答案

相关问答

绘制我的帐户余额的Excel折线图(Draw an Excel Line Chart of my account balance)[2023-09-05]

在SQL Server 2012中触发以更新帐户余额(Trigger in SQL Server 2012 to Update Account Balance)[2022-06-19]

SQL帐户余额表(SQL Account Balance Table)[2023-08-03]

数据库设计：计算账户余额(Database design: Calculating the Account Balance)[2023-06-09]

平均每月帐户余额(Average Monthly Balance of Accounts)[2023-07-29]

当“余额”表仅在余额更改的那些日期具有条目时，创建显示每天帐户余额的视图(Creating a view that shows the balance of accounts on every day, when the “balance” table only has entries on those days where the balance changes)[2023-09-06]

用于帐户余额的DynamoDB原子计数器(DynamoDB atomic counter for account balance)[2023-04-07]

获取Paypal账户的余额(Get balance of Paypal account)[2022-09-01]

账户余额系统与条纹(Account balance system with Stripe)[2022-10-22]

用django更新帐户余额(updating account balance with django)[2021-10-28]

相关文章

最新问答