Django: Key (slug)=(*) already exists

Question

I'm pretty new to Django and python and I'd like to learn more about how to populating my Postgres database.

Here is my current model: models.py

from django.template.defaultfilters import slugify

class Skill(models.Model):
    name = models.TextField()
    slug = models.TextField(unique = True)
    def __unicode__(self):
        return "%s" % self.name

and my views: views.py

r = r.json()

try:
    Skills = r['data']['skills']
except:
    pass

for skill in Skills:
    skill = Skill.objects.create(name=skill['name'],slug=slugify(skill['name']))

I'm getting the error: Exception Type: IntegrityError

DETAIL: Key (slug)=(systems-engineering) already exists.

I've been reading a similar post although still haven't been able to solve my problem. objects.create() will shows an error when the object already exists in the database, but I was getting error with the code above. Could "unique = True" be causing the error? and how do you fix this?

Follow up

My problem is simpler than I thought. I was able to run psql interactive terminal and see my data populating. I wasn't able to see it on the admin site because I missed out registering the models on admin.py

"skills": [ { "name": "systems engineering" }, { "name": "consumer electronics" }, { "name": "product development" }, ... ] — Jade Dhangwattanotai, Feb 21 '18 at 03:35
Here is my full [traceback](http://dpaste.com/10TCE11) Thank you! — Jade Dhangwattanotai, Feb 21 '18 at 18:50

score 1 · Accepted Answer · answered Feb 21 '18 at 03:40

1

When you provide unique=True, the field will be unique throughout the table. Hence, when you try to add a data which is already in DB, it will raise an error. See this official doc for more details

answered Feb 21 '18 at 03:40

JPG

82,442
19
127
206

My problem is the data haven't been added and yet it recognizes the data as duplicate. I tried doing `try` & `except` although it never executes the objects.create – Jade Dhangwattanotai Feb 21 '18 at 03:52
are you sure that it is never executed to the database? `objects.create()` always create an instance. You need to check it in your db if it really doesnt exist. – Shift 'n Tab Feb 21 '18 at 04:15
I looked into database and saw the objects now.! – Jade Dhangwattanotai Feb 21 '18 at 05:35

Django: Key (slug)=(*) already exists

1 Answers1

Linked