Pls How can I save the full url of an uploaded file from cloudinary in my postgres database?
Anytime I upload a file, in my api, i get the full url of the uploaded file from cloudinary, eg : https://res.cloudinary.com/dug5dj4uz/image/upload/nun_p9jduh".
But in my database, the image is stored as " image/upload/v1694654259/nun_p9jduhf.jpg "
i want to be able to save the full url of the uploaded file from cloudinary in my database
This is my code
models.py
class Posts(models.Model):
id = models.UUIDField(default=uuid.uuid4, primary_key=True, editable=False)
user = models.ForeignKey(User, on_delete=models.CASCADE)
files = CloudinaryField(resource_type='auto', folder='Insagram_Posts', default='')
description = models.TextField(blank=True)
created = models.DateTimeField(default=timezone.now)
serializers.py
class PostsSerializer(serializers.ModelSerializer):
class Meta:
model = Posts
fields = ['id', 'files', 'description']
def to_representation(self, instance):
representation = super().to_representation(instance)
representation['files'] = f'https://res.cloudinary.com/dug5dj4uz/{representation["files"]}'
return representation
views.py
class PostListCreateView(generics.ListCreateAPIView):
permission_classes = (IsAuthorOrReadOnly, )
authentication_classes = (TokenAuthentication, )
queryset = Posts.objects.all()
serializer_class = ReadPostsSerializer
def post(self, request, format=None, *args, **kwargs):
serializer = PostsSerializer(data=request.data)
# if the new serialized post is valid, then save
if serializer.is_valid():
# This line checks if the user is authorized to make a post
serializer.validated_data['user'] = request.user
post = serializer.save()
# Getting the auther of the post
user_serializer = UserSerializer(request.user)
post.save()
data = {
'user': user_serializer.data,
'id': post.id,
'description': post.description,
'files': post.files,
}
return Response(data, status=status.HTTP_201_CREATED)
else:
return Response(serializer.errors, status=status.HTTP_400_BAD_REQUEST)
Answers
-
Hey @Kevin. Thanks for getting in touch with your question. I'm not a Python expert, so I shall answer in a broader context:
When saving information about an asset in your database, it's a good practice to save the different parameters you require, and then build out the URL upon delivery, rather than just saving a delivery URL. A delivery URL is made up of https://res.cloudinary.com/
cloud_name/asset_type/delivery_type/transformations/version/public_id.extension. Your cloud name will remain constant, but the other parameters will vary, and should be saved into your database for later retrieval. The easiest way to do this would be to read the parameters from the upload response (example available here) and save the relevant fields into your DB.If you're trying to import data into your database for assets already on your account, you can use the Admin API to list all assets in your account. and then parse the response into your database.
I hope this helps, but feel free to raise a support ticket if you need any further assistance.
Kind regards,
-Danny
0
