Spaces:
Sleeping
Sleeping
File size: 2,781 Bytes
bbeedce | 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 | """
Better Auth session verification for FastAPI backend
"""
from fastapi import HTTPException, status, Request
from sqlalchemy import text
from datetime import datetime
import os
from dotenv import load_dotenv
from urllib.parse import unquote
load_dotenv()
def verify_better_auth_session(request: Request) -> str:
"""
Verify Better Auth session from cookie
Returns user_id (TEXT) if valid
"""
# Get session token from cookie
session_cookie = request.cookies.get("better-auth.session_token")
print(f"[DEBUG] Raw cookie value: {session_cookie}")
if not session_cookie:
print("[DEBUG] No session cookie found")
raise HTTPException(
status_code=status.HTTP_401_UNAUTHORIZED,
detail="Not authenticated"
)
# URL decode the cookie value
session_token = unquote(session_cookie)
print(f"[DEBUG] Decoded session token: {session_token}")
# Better Auth cookie format: sessionId.signature
# We need just the sessionId part (before the first dot)
if '.' in session_token:
session_id = session_token.split('.')[0]
else:
session_id = session_token
print(f"[DEBUG] Extracted session ID: {session_id}")
# Query the database to verify the session
from ..database import engine
try:
with engine.connect() as conn:
result = conn.execute(
text("""
SELECT "userId", "expiresAt"
FROM session
WHERE id = :session_id
"""),
{"session_id": session_id}
)
row = result.fetchone()
if not row:
print(f"[DEBUG] No session found in database for ID: {session_id}")
raise HTTPException(
status_code=status.HTTP_401_UNAUTHORIZED,
detail="Invalid session"
)
user_id, expires_at = row
print(f"[DEBUG] Found session - User ID: {user_id}, Expires: {expires_at}")
# Check if session is expired
if expires_at < datetime.utcnow():
print(f"[DEBUG] Session expired")
raise HTTPException(
status_code=status.HTTP_401_UNAUTHORIZED,
detail="Session expired"
)
print(f"[DEBUG] Session valid, returning user_id: {user_id}")
return user_id
except HTTPException:
raise
except Exception as e:
print(f"[DEBUG] Session verification error: {e}")
import traceback
traceback.print_exc()
raise HTTPException(
status_code=status.HTTP_401_UNAUTHORIZED,
detail="Session verification failed"
)
|