Django.db.utils.IntegrityError: UNIQUE constraint failed: account_workexperiance.id
Я получаю ошибку UNIQUE UNIQUE constraint failed: account_workexperiance.id
при обновлении списка объектов. До сих пор все работало нормально, и я не делал никаких изменений.
models.py:
class TutorUser(models.Model):
tutor_user = models.OneToOneField(settings.AUTH_USER_MODEL,
on_delete=models.CASCADE,
related_name='tutor')
full_name = models.CharField(max_length=255, blank=True)
phone_number = models.CharField(max_length=14, blank=True)
class WorkExperiance(models.Model):
tutor_work = models.ForeignKey(TutorUser,
related_name='tutor_work',
on_delete=models.CASCADE)
organization = models.CharField(max_length=255, blank=True)
start_year = models.IntegerField(null=True, blank=True)
serializers.py:
class WorkExperianceListSerializer(serializers.ListSerializer):
def update(self, instance, validated_data):
tutor_work_mapping = {tutor_work.id: tutor_work for tutor_work in instance}
data_mapping = {item['id']: item for item in validated_data}
ret = []
for tutor_work_id, data in data_mapping.items():
tutor_work = tutor_work_mapping.get(tutor_work_id, None)
if tutor_work is None:
ret.append(self.child.create(data))
else:
ret.append(self.child.update(tutor_work, data))
for tutor_work_id, tutor_work in tutor_work_mapping.items():
if tutor_work_id not in data_mapping:
tutor_work.delete()
class WorkExperianceSerializer(serializers.ModelSerializer):
id = serializers.IntegerField(read_only=False)
class Meta:
list_serializer_class = WorkExperianceListSerializer
model = WorkExperiance
fields = [
'id',
'organization',
'start_year',
]
def update(self, instance, validated_data):
instance.organization = validated_data.get('organization', instance.organization)
instance.start_year = validated_data.get('start_year', instance.start_year)
instance.save()
return instance
views:py
class TutorWorkExperiance(APIView):
def put(self, request):
tutor = TutorUser.objects.get(tutor_user__id=request.user.id)
tutor_work = WorkExperiance.objects.filter(tutor_work=tutor)
serializer = WorkExperianceSerializer(tutor_work, data = request.data, partial=True, many=True)
if serializer.is_valid(raise_exception=True):
serializer.save(tutor_work=tutor)
return Response(serializer.data)
Он работает для create()
, но не обновляется, я думаю, что он пытается create()
только вместо update()