Re: IntegrityError: null value in column "user_id" violates not-null constraint

Thanks a lot @obastephen it worked.

On Friday, July 31, 2020 at 12:32:47 AM UTC+5:30 obast...@gmail.com wrote:

irst in your UploadSerializer fields use fields = "__all__"

Then you can use this in your views:

def post(self, request, format=None):

        upload_file = request.data.get("upload_file")

        upload_date = request.data.get("upload_date")

        user = request.user
        data = {'upload_file': upload_file, 'upload_date': upload_date, 'user': user}

        serializer = UploadSerializer(data=data)

        if serializer.is_valid():
            serializer.save()
            return Response(serializer.data, status=status.HTTP_201_CREATED)
        return Response(serializer.errors, status=status.HTTP_400_BAD_REQUEST)

On Thu, Jul 30, 2020 at 5:59 PM Dinolin yp job <dinoli...@gmail.com> wrote:

I don't have forms.py since I'm creating only the endpoints using rest framework. I've done it earlier and it has worked but earlier the foreign key was to refer the default User model but now I have customized User model by extending AbstractBaseUser.

uploads/views.py

class UploadView(APIView):
    def post(self, request, format=None):
        serializer = UploadSerializer(data=request.data)
        if serializer.is_valid():
            serializer.save()
            return Response(serializer.data, status=status.HTTP_201_CREATED)
        return Response(serializer.errors, status=status.HTTP_400_BAD_REQUEST)

uploads/serializers.py

class UploadSerializer(serializers.ModelSerializer):
    class Meta:
        model = Upload
        fields = ('upload_file', 'upload_date')

users/models.py

class User(AbstractBaseUser):
    user_id = models.AutoField(primary_key=True)
    username = models.CharField(max_length=50, unique=True)
    first_name = models.CharField(max_length=50)
    last_name = models.CharField(max_length=50)
    company_name = models.CharField(max_length=100)
    email = models.EmailField(max_length=150, unique=True)
    is_active = models.BooleanField(default=True)
    is_superuser = models.BooleanField(default=False)
   
    objects = UserManager()

    USERNAME_FIELD = 'username'
    REQUIRED_FIELDS = ['first_name', 'last_name', 'company_name', 'email']

    def get_full_name(self):
        return self.first_name + self.last_name

On Thursday, July 30, 2020 at 7:59:38 PM UTC+5:30 obast...@gmail.com wrote:

You can create an upload form with an Image field, then when saving the for set the User field to request.user.

Do you have an UploadForm already in your forms.py? if yes, show me with the view that handles.

On Thu, Jul 30, 2020 at 11:59 AM Dinolin yp job <dinoli...@gmail.com> wrote:

It worked but user_id column in uploads_upload table is empty. How to solve this issue?

On Thursday, July 30, 2020 at 3:31:21 PM UTC+5:30 obast...@gmail.com wrote:

From the error, it states that you are trying to add an upload object to the database without a user. And from your model.py, the User foreign key does not have a null=True, and blank=True. So you can't save a null value for that user field. 

On Thu, Jul 30, 2020 at 10:52 AM Dinolin yp job <dinoli...@gmail.com> wrote:

I'm trying to save image in postgres database. I have upload model which has a foreign key reference to the extended custom user model. But it shows the following error

uploads/model.py

from django.db import models
from django.contrib.auth import get_user_model

User = get_user_model()

class Upload(models.Model):
    upload_file = models.ImageField(upload_to='uploads/')
    upload_date = models.DateTimeField(auto_now_add =True)
    user = models.ForeignKey(User, on_delete=models.CASCADE)

What am I missing? Thanks in advance

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/bddd1f92-895c-4e23-8f08-976c0f178f17o%40googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/e3462364-f867-4187-80bd-abfaa09d86b8n%40googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/0ce310b5-7bf5-4200-8ddd-e679c160669dn%40googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/2f7bbe82-5a4b-431a-86d5-fec8a7773fa2n%40googlegroups.com.