Implement Backend for User Avatar Management

[mahid797]

Description

Develop the backend functionality to support user avatar management. This includes creating a new Supabase bucket for storing avatars, updating the database schema to associate avatars with users, and implementing API endpoints for fetching and uploading avatars. These updates will allow seamless integration with the frontend for displaying and updating user avatars.

---

Tasks

• Supabase Bucket Setup:

  • Create a dedicated Supabase bucket for storing user avatars.
  • Configure appropriate access policies for the bucket to ensure secure and controlled access.

• Database Schema Update:

  • Add an avatar_url field to the User table in schema.prisma:
    • avatar_url: Optional field to store the public URL of the user's avatar.
  • Run the necessary database migration to apply schema changes.

• API Endpoints:

  • Create a GET endpoint for fetching a user's avatar:
    • Fetch the avatar_url field from the database.
    • Return the avatar URL or a default placeholder URL if no avatar exists.
  • Create a POST endpoint for uploading/updating a user's avatar:
    • Accept an image file from the frontend.
    • Validate the file type and size.
    • Upload the image to the Supabase bucket and retrieve the public URL.
    • Update the avatar_url field in the database.
    • Delete the previous avatar from the bucket, if applicable.
  • Ensure authentication and authorization for both endpoints to allow access only to the authenticated user.

• Error Handling and Logging:

  • Implement error handling for file validation failures, Supabase upload errors, and database update issues.
  • Add logs for critical operations (e.g., upload success, failed validations).

---

Notes

• The avatar_url field should be optional to account for users who do not upload an avatar.
• Use default avatar URLs for users without a custom avatar.
• Ensure the backend integrates seamlessly with the existing Profile API for user data updates.