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

Question

I'm new in Django rest framework and I'm trying do a unit test using Token for my API, but it kept throwing IntegrityError. I've researched many blogs to find the solution but couldn't find. Please help me solve this. Thanks in advance.

Here is the code that I've tried

from django.contrib.auth.models import User
from rest_framework.test import APITestCase, APIRequestFactory, force_authenticate
from rest_framework.authtoken.models import Token

from myapp.api.views import UserViewSet


class UserTestCase(APITestCase):
    def setUp(self):
        self.superuser = User.objects.create_user(username='superuser', email='[email protected]',
                                                  password='superuser',
                                                  is_staff=True)
        self.factory = APIRequestFactory()

        self.token = Token.objects.create(user=self.superuser)
        self.token.save()

    def test_list(self):
        request = self.factory.get('/api/users/')
        force_authenticate(request, user=self.superuser, token=self.token)
        response = UserViewSet.as_view({'get': 'list'})(request)
        self.assertEqual(response.status_code, 200)

You seem to insert the same user multiple times with your Token.objects.create(..) — willeM_ Van Onsem
– willeM_ Van Onsem, Commented Aug 27, 2019 at 10:38
on which line exactly is this error happening? if you don't know, please show the entire error trace. — dirkgroten
– dirkgroten, Commented Aug 27, 2019 at 10:58
Its when creating token Token.objects.create(user=self.superuser), I gave a try by removing self.token.save() and I've also tried to put the token creation code in setUpClass() classmethod but it's still throwing the IntegrityError — Roshan Maharjan
– Roshan Maharjan, Commented Aug 27, 2019 at 11:04

Roshan Maharjan · Accepted Answer · 2019-08-27 11:51:41Z

3

Finally, I got it. I didn't notice that I had created Token in signals wherein each User creation Token was created. Thanks @Willem Van Onsem

answered Aug 27, 2019 at 11:51

Roshan Maharjan

3223 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Junaid Girkar · Accepted Answer · 2020-09-26 13:22:05Z

3

unique constraint failed: authtoken_token.user_id This error is coming because token already exists for this user in database. So when it tries to create new token with same user_id it gives an error

If you look at the admin token already exists for users

This is referenced from https://excellencetechnologies.in/blog/django-rest-api-authentication-part5/:

Do a try-except function:


class UserAuth(APIView):

   # Manager User Login and other things
    

    def post(self, request):
        
        # login
       
        user = authenticate(
            username=request.data.get("username"),
            password=request.data.get("password")
            )
        if user is not None:
            # A backend authenticated the credentials

            try:
                token = Token.objects.get(user_id=user.id)

            except Token.DoesNotExist:
                token = Token.objects.create(user=user)

            return Response(token.key)

        else:
            # No backend authenticated the credentials
            return Response([], status=status.HTTP_401_UNAUTHORIZED)

edited Sep 26, 2020 at 13:22

answered Sep 25, 2020 at 9:46

Junaid Girkar

314 bronze badges

3 Comments

Nozim Over a year ago

thanks for your answer Junaid Girkar, I suppose little update of code section would help to make it more readable ;)

Junaid Girkar Over a year ago

@Nozim Have made some edits to improve the readability of the code. Feel free to mention any other ways I can improve. Am new to Stackoverflow and am always willing to correct my mistakes.

Nozim Over a year ago

Welcome to the community! Thanks for the modifications. It's looks much better now.

Collectives™ on Stack Overflow

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

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related