supabase/database.py

import os
from supabase import create_client, Client
from dotenv import load_dotenv
from pathlib import Path

# Find .env file and upload
env_path = Path(__file__).resolve().parent.parent.parent / '.env'
load_dotenv(dotenv_path=env_path)

class SupabaseManager:
    def __init__(self):
        self.url = os.getenv("SUPABASE_URL")
        self.key = os.getenv("SUPABASE_SERVICE_ROLE_KEY")
        self.client: Client = create_client(self.url, self.key)

db = SupabaseManager().client