database.py

import sys
import os


sys.path.append(os.path.abspath(os.path.join(os.path.dirname(__file__), '../')))

import os
from dotenv import load_dotenv
from supabase import create_client, Client
from dotenv import load_dotenv
load_dotenv(dotenv_path=".env")  # ✅ Explicitly load the .env file
from config import SUPABASE_URL, SUPABASE_KEY


# Load environment variables
load_dotenv()

# Read Supabase credentials
SUPABASE_URL = os.getenv("SUPABASE_URL")
SUPABASE_KEY = os.getenv("SUPABASE_KEY")

# Initialize Supabase client
supabase: Client = create_client(SUPABASE_URL, SUPABASE_KEY)