from fastapi import APIRouter, HTTPException, Depends from datetime import datetime, timedelta from typing import Optional from pydantic import BaseModel from core.utils.auth_utils import verify_and_get_user_id_from_jwt from core.services.supabase import DBConnection from core.utils.logger import logger router = APIRouter(tags=["file-uploads"]) class RegenerateLinkRequest(BaseModel): file_upload_id: Optional[str] = None storage_path: Optional[str] = None bucket_name: Optional[str] = "file-uploads" class RegenerateLinkResponse(BaseModel): success: bool signed_url: str expires_at: str message: str @router.post("/file-uploads/regenerate-link") async def regenerate_signed_link( request: RegenerateLinkRequest, user_id: str = Depends(verify_and_get_user_id_from_jwt) ): try: db = DBConnection() client = await db.client account_result = await client.schema("basejump").table('account_user').select('account_id').eq('user_id', user_id).execute() if not account_result.data: raise HTTPException(status_code=403, detail="User not found in any account") user_account_ids = [acc['account_id'] for acc in account_result.data] if request.file_upload_id: file_upload_result = await client.table('file_uploads').select('*').eq('id', request.file_upload_id).execute() if not file_upload_result.data: raise HTTPException(status_code=404, detail="File upload not found") file_upload = file_upload_result.data[0] if file_upload['account_id'] not in user_account_ids: raise HTTPException(status_code=403, detail="Access denied to this file") bucket_name = file_upload['bucket_name'] storage_path = file_upload['storage_path'] file_id_to_update = request.file_upload_id elif request.storage_path: bucket_name = request.bucket_name or "file-uploads" storage_path = request.storage_path account_id_from_path = storage_path.split('/')[0] if account_id_from_path not in user_account_ids: raise HTTPException(status_code=403, detail="Access denied to this file") file_upload_result = await client.table('file_uploads').select('id').eq('storage_path', storage_path).eq('bucket_name', bucket_name).execute() file_id_to_update = file_upload_result.data[0]['id'] if file_upload_result.data else None else: raise HTTPException(status_code=400, detail="Either file_upload_id or storage_path must be provided") expires_in = 24 * 60 * 60 signed_url_response = await client.storage.from_(bucket_name).create_signed_url( storage_path, expires_in ) signed_url = signed_url_response.get('signedURL') if not signed_url: raise HTTPException(status_code=500, detail="Failed to generate signed URL") url_expires_at = datetime.now() + timedelta(seconds=expires_in) if file_id_to_update: await client.table('file_uploads').update({ 'signed_url': signed_url, 'url_expires_at': url_expires_at.isoformat() }).eq('id', file_id_to_update).execute() return RegenerateLinkResponse( success=True, signed_url=signed_url, expires_at=url_expires_at.strftime('%Y-%m-%d %H:%M:%S UTC'), message=f"Secure URL regenerated successfully. Expires in 24 hours." ) except HTTPException: raise except Exception as e: logger.error(f"Failed to regenerate signed link: {str(e)}") raise HTTPException(status_code=500, detail=f"Failed to regenerate link: {str(e)}") @router.get("/file-uploads/{file_upload_id}") async def get_file_upload( file_upload_id: str, user_id: str = Depends(verify_and_get_user_id_from_jwt) ): try: db = DBConnection() client = await db.client file_upload_result = await client.table('file_uploads').select('*').eq('id', file_upload_id).execute() if not file_upload_result.data: raise HTTPException(status_code=404, detail="File upload not found") file_upload = file_upload_result.data[0] account_result = await client.schema("basejump").table('account_user').select('account_id').eq('user_id', user_id).execute() if not account_result.data: raise HTTPException(status_code=403, detail="User not found in any account") user_account_ids = [acc['account_id'] for acc in account_result.data] if file_upload['account_id'] not in user_account_ids: raise HTTPException(status_code=403, detail="Access denied to this file") return file_upload except HTTPException: raise except Exception as e: logger.error(f"Failed to get file upload: {str(e)}") raise HTTPException(status_code=500, detail=f"Failed to get file upload: {str(e)}")