獲取NOTNULL約束失敗：DRF中的locations_location.city_id

當我嘗試通過我的 api 中的 DRF serailizers 創建物件時，出現錯誤NOT NULL constraint failed: locations_location.city_id。

我在這里查看了類似的內容，提供的解決方案似乎正是我必須開始的。

我的模型：

class City(models.Model):
    code = models.CharField(max_length=4, default="", blank=False, unique=True)
    name = models.CharField(max_length=40, default="", blank=False, unique=True)
    time_added = models.DateTimeField(auto_now_add=True)

    def __str__(self):
        return f"{self.name}, ({self.code})"

    class Meta:
        verbose_name = "City"
        verbose_name_plural = "Cities"


class Location(models.Model):
    status_choice = (
        ("Available", "Available"),
        ("Unavailable", "Unavailable"),
        ("Active", "Active"),
    )
    city = models.ForeignKey(City, on_delete=models.CASCADE, related_name="locations")
    name = models.CharField(max_length=256, default="", blank=True)
    rent = models.DecimalField(max_digits=7, decimal_places=2)
    email = models.EmailField(max_length=64)
    phone = models.CharField(max_length=20, default="", blank=True)
    lon = models.DecimalField(max_digits=7, decimal_places=5, blank=True, null=True)
    lat = models.DecimalField(max_digits=7, decimal_places=5, blank=True, null=True)
    street_number = models.CharField(max_length=50, null=True)
    street_name = models.CharField(max_length=50, null=True)
    postal_code = models.CharField(max_length=50, null=True)
    status = models.CharField(max_length=50, choices=status_choice, default="Available")
    time_added = models.DateTimeField(auto_now_add=True)

    def __str__(self):
        return f"{self.name} {self.status}"

我的serailizers：

class CitySerializer(serializers.ModelSerializer):
    locations = serializers.PrimaryKeyRelatedField(many=True, read_only=True)

    class Meta:
        model = City
        fields = "__all__"

    def create(self, validated_data):
        return City.objects.create(**validated_data)


class LocationSerializer(serializers.ModelSerializer):
    location_events = serializers.PrimaryKeyRelatedField(many=True, read_only=True)
    booked_days = serializers.PrimaryKeyRelatedField(many=True, read_only=True)

    class Meta:
        model = Location
        fields = "__all__"
        depth = 1

    def create(self, validated_data):
        city = serializers.PrimaryKeyRelatedField(  # noqa
            many=False, queryset=City.objects.all()
        )
        return Location.objects.create(**validated_data)

這是在 POST 請求中傳遞給 api 的假測驗資料：

{
 "name": "Darmstadt Hotel", 
 "city": 1,
 "email": "[email protected]", 
 "phone": " 49(0)7219 993238", 
 "rent": 275.38, 
 "lat": 52.9427, 
 "lon": 12.1076, 
 "street_name": "Eimerstra\\u00dfe", 
 "street_number": "34", 
 "postal_code": "80843", 
 "status": "Available"
}

資料庫中存在一個 id 為 1 的城市，可通過 api 訪問。

uj5u.com熱心網友回復：

首先，你LocationSerializer的create方法里面有city欄位，那一定是錯誤的吧？它應該是下面的行booked_days = ...。但是，我不確定這會解決問題。

class LocationSerializer(serializers.ModelSerializer):
    location_events = serializers.PrimaryKeyRelatedField(many=True, read_only=True)
    booked_days = serializers.PrimaryKeyRelatedField(many=True, read_only=True)
    city = serializers.PrimaryKeyRelatedField(  # noqa
        many=False, queryset=City.objects.all()
    ) # Move it here

    class Meta:
        model = Location
        fields = "__all__"
        depth = 1

    def create(self, validated_data):
        return Location.objects.create(**validated_data)

標籤：Python 姜戈 接口 连载 Django 休息框架

上一篇：std::vector和移動語意

下一篇：獲取序列化程式中外鍵欄位為x的物件數