File size: 5,265 Bytes
22087d0 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 | 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)}")
|