models/supabase_models.py

from pydantic_settings import BaseSettings
from dotenv import load_dotenv
from supabase import create_client
from functools import lru_cache
import os
from google.colab import userdata
load_dotenv()

@lru_cache(maxsize=1)
class Supabase_Settings(BaseSettings):

    # keys: BaseSettings = Keys()

    SUPABASE_URL: str = userdata.get("SUPABASE_URL")
    SUPABASE_ANON_KEY: str = userdata.get("SUPABASE_ANON_KEY")
    SUPABASE_SERVICE_KEY: str = userdata.get("SUPABASE_SERVICE_KEY")



@lru_cache(maxsize=1)
class Supabase_Clients:
    values = Supabase_Settings()
    anon_supabase = create_client(values.SUPABASE_URL, values.SUPABASE_ANON_KEY)
    service_supabase = create_client(values.SUPABASE_URL, values.SUPABASE_SERVICE_KEY)