Spaces:
Sleeping
Sleeping
File size: 2,697 Bytes
f374654 | 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 | # conversation_manager.py
import os
from supabase import create_client, Client
from typing import List, Dict, Any, Optional
import logging
logger = logging.getLogger(__name__)
class ConversationManager:
def __init__(self):
"""Initializes the Supabase client."""
supabase_url = os.getenv("SUPABASE_URL")
supabase_key = os.getenv("SUPABASE_KEY")
if not supabase_url or not supabase_key:
raise ValueError("Supabase URL and Key must be set in environment variables.")
self.supabase: Client = create_client(supabase_url, supabase_key)
self.table_name = "conversations"
logger.info("ConversationManager initialized with Supabase client.")
def get_history(self, session_id: str) -> List[Dict[str, Any]]:
"""
Retrieves conversation history for a given session_id.
Returns an empty list if no history is found.
"""
try:
response = self.supabase.table(self.table_name)\
.select("history")\
.eq("session_id", session_id)\
.limit(1)\
.execute()
if response.data:
return response.data[0].get("history", [])
return []
except Exception as e:
logger.error(f"Error fetching history for session {session_id}: {e}")
return []
def save_history(self, session_id: str, history: List[Dict[str, Any]]) -> None:
"""
Saves or updates the conversation history for a session_id.
Uses 'upsert' to create a new record or update an existing one.
"""
try:
self.supabase.table(self.table_name).upsert({
"session_id": session_id,
"history": history
}).execute()
logger.info(f"History for session {session_id} saved successfully.")
except Exception as e:
logger.error(f"Error saving history for session {session_id}: {e}")
def delete_history(self, session_id: str) -> bool:
"""
Deletes the conversation history for a given session_id.
Returns True on success, False on failure.
"""
try:
self.supabase.table(self.table_name)\
.delete()\
.eq("session_id", session_id)\
.execute()
logger.info(f"History for session {session_id} deleted successfully.")
return True
except Exception as e:
logger.error(f"Error deleting history for session {session_id}: {e}")
return False |