django.db.utils.IntegrityError: UNIQUE constraint failed:

Question

I am making review api with django, but I have a problem.

models.py

from django.db import models
import uuid

# Create your models here.
from django.utils.text import slugify

class buildingData(models.Model):
    building_name = models.CharField(max_length=50, unique=True)
    slug = models.SlugField(unique=True, default=uuid.uuid1)
    building_loc = models.CharField(max_length=50)
    building_call = models.CharField(max_length=20)
    building_time = models.CharField(max_length=50)

    def save(self, *args, **kwargs):
        self.slug = slugify(self.building_name)
        return super().save(*args, **kwargs)
        

class reviewData(models.Model):
    building = models.ForeignKey(buildingData, related_name='reviews', on_delete=models.CASCADE, null=False, blank=False)
    review_content = models.TextField()
    star_num = models.FloatField()

urls.py

from django.contrib import admin
from django.urls import path
from crawling_data.views import ReviewListAPI
from crawling_data.views import BuildingInfoAPI

urlpatterns = [
    path('admin/', admin.site.urls),
    path('api/buildingdata/', BuildingInfoAPI.as_view()),
    path('api/buildingdata/<slug:slug>/', ReviewListAPI.as_view())
]

I am collecting data with crawling, but...

django.db.utils.IntegrityError: UNIQUE constraint failed: crawling_data_buildingdata.slug

This error occurs.

I've tried deleting migrate file and migration again, but still doesn't work.

Is there any problem on my code or is there other way to solve this?

When does this error occur? When you try to migrate to the database? — , Oct 11 '21 at 14:40
It occurs when I save data that I collected with crawling program @bichanna — JYH, Oct 11 '21 at 14:43

mrash · Answer 1 · 2021-10-11T15:44:01.503

1

That is because the uuid1 is generated from your machine ID and time stamp and the machine ID in your case remains constant, that's why they look pretty similar at the end. You may use uuid4() to get a random unique UUID.

Answer from @ZdaR in this answer

You should change the first model to this:

class buildingData(models.Model):
    building_name = models.CharField(max_length=50, unique=True)
    slug = models.SlugField(unique=True, default=uuid.uuid4)
    building_loc = models.CharField(max_length=50)
    building_call = models.CharField(max_length=20)
    building_time = models.CharField(max_length=50)

Also you can use your slug as primary key with this:

slug = models.UUIDField(primary_key=True, default=uuid.uuid4, editable=False)

Edited:

I see your save function. in your save function you should remove the slug assignment. Or change it to self.slug = None. If you want to have a slug from the building name you must use TextField or CharField in the model:

slug = models.TextField(unique=True, default=uuid.uuid4)

edited Oct 11 '21 at 15:44

answered Oct 11 '21 at 14:43

mrash

883
7
18

django.core.exceptions.ValidationError: ['“” is not a valid UUID.'] This error occurs. How to fix it? – JYH Oct 11 '21 at 14:59
dear @T1JYH, I think you assign an empty string to slug when you create it. `item.slug = ""` is wrong. you should leave it or using None. `item.slug = None` is correct. – mrash Oct 11 '21 at 15:16
I've tried first thing instead, but uuid4 still occurs same error with uuid1. Hmm... Those two solutions occur different errors – JYH Oct 11 '21 at 15:28
I edit my answer! – mrash Oct 11 '21 at 15:41
Uh still didn't fixed... I should try tomorrow. Well I must use building name for review api url. – JYH Oct 11 '21 at 15:59
Ok, I will be happy to know the result. – mrash Oct 11 '21 at 16:02

django.db.utils.IntegrityError: UNIQUE constraint failed:

1 Answers1

Edited: