python - Django Rest 框架 - 外键上的 NOT NULL 约束

Question

我有这个错误:

IntegrityError at /api/post_flight_schedule/
NOT NULL constraint failed: flights_tailnumber.aircraft_type_id

当我尝试通过 http://127.0.0.1:8000/api/pos_flight_schedule 将新的 PosFlightSchedule 对象添加到数据库时(网站/APIView)

我有以下序列化器:

class PosFlightScheduleModelSerializer(ModelSerializer):
    class Meta:
        model = PosFlightSchedule
        fields = ['pos_route_id', 'tail_number', 'pos_flight_number', 'pos_flight_departure_time', 'pos_flight_date',
              'pax_count']


class PosFlightScheduleSerializer(serializers.Serializer):
    pos_route_id = serializers.CharField(source='pos_route_id.route_id', read_only=False)
    tail_number = serializers.CharField(source='tail_number.tail_number', read_only=False)
    pos_flight_number = serializers.CharField(source='pos_flight_number.flight_number', read_only=False)
    pos_flight_departure_time = serializers.CharField(source='pos_flight_departure_time.flight_departure_time', allow_null=True,
                                                  read_only=False)
    pos_flight_date = serializers.CharField(source='pos_flight_date.flight_date', read_only=False)
    pax_count = serializers.IntegerField(read_only=False)

    def create(self, validated_data):
        tail_number_data = validated_data.pop("tail_number")
        tail_number = TailNumber.objects.create(**tail_number_data)
        flight_number_data = validated_data.pop("pos_flight_number")
        flight_number = FlightSchedule.objects.create(**flight_number_data)
        flight_departure_time_data = validated_data.pop("pos_flight_departure_time")
        print "DEP_TIME" + str(flight_departure_time_data)
        flight_departure_time = FlightSchedule.objects.create(**flight_departure_time_data)
        route_id_data = validated_data.pop("pos_route_id")
        route_id = FlightScheduleDetail.objects.create(**route_id_data)
        flight_date_data = validated_data.pop("pos_flight_date")
        flight_date = FlightScheduleDetail.objects.create(**flight_date_data)
        pax_count = validated_data.pop("pax_count")

        schedule_obj = PosFlightSchedule.objects.create(**validated_data)
        # if tail_number:
        schedule_obj.set_tail_number(tail_number)
        schedule_obj.set_pos_flight_number(flight_number)
        schedule_obj.set_pos_flight_departure_time(flight_departure_time)
        schedule_obj.set_pos_route_id(route_id)
        schedule_obj.set_pos_flight_date(flight_date)
        schedule_obj.set_pax_count(pax_count)
        schedule_obj.save()

        return schedule_obj

    def update(self, instance, validated_data):
        tail_number = validated_data.pop("tail_number")
        flight_number = validated_data.pop("pos_flight_number")
        flight_departure_time = validated_data.pop("pos_flight_departure_time")
        route_id = validated_data.pop("pos_route_id")
        flight_date = validated_data.pop("pos_flight_date")
        pax_count = validated_data.pop("pax_count")
        instance.__dict__.update(validated_data)
        if tail_number:
            instance.set_tail_number(tail_number)
        if flight_number:
            instance.set_pos_flight_number(flight_number)
        if flight_departure_time:
            instance.set_pos_flight_departure_time(flight_departure_time)
        if route_id:
            instance.set_pos_route_id(route_id)
        if flight_date:
            instance.set_pos_flight_date(flight_date)
        if pax_count:
            instance.set_pax_count(pax_count)
        instance.save()
        return instance

给出错误的字段模型如下所示:

class TailNumber(models.Model):
    tail_number_id = models.AutoField(null=False, primary_key=True)
    tail_number = models.CharField(max_length=20, null=False, blank=False, unique=True)
    aircraft_type = models.ForeignKey(AircraftType, null=False, blank=False)

    def __unicode__(self):
        return u'%s' % self.tail_number

    class Meta:
        verbose_name_plural = "Tail Numbers"

我不明白这里出了什么问题。

Answer 1

您收到的错误可能是由于字典tail_number_data不包含关键字aircraft_type，这是TailNumber.objects所期望的code> 在数据库中创建行，因为您定义的行不可能为空

aircraft_type = models.ForeignKey(AircraftType, null=False, blank=False)
                                                     ^^^^^

检查字典tail_number_data中是否存在键“aircraft_type”，或者允许它为空。此外，如果您考虑后一个选项并且该信息应该来自 UI，您可能还希望允许 aircraft_type 为空。请参阅 differentiate null=True, blank=True in django 了解详情。