full-stack-todo / src /auth /better_auth.py
umarwaqar's picture
pushing code
bbeedce
Raw History Blame Contribute Delete
2.78 kB
"""
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"
)