# THIS CODE WORKS #
import os
from supabase import create_client
import logging

from dotenv import load_dotenv
load_dotenv()

# Configure logging
logging.basicConfig(level=logging.INFO)
logger = logging.getLogger(__name__)

url = os.environ.get("SUPABASE_URL")
key = os.environ.get("SUPABASE_KEY") 
supabase_client = create_client(url, key)

logger.info(f"Supabase client: {supabase_client}")

response = (
    supabase_client.table("playlist_songs")
    .select("*")
    .execute()
)

logger.info(f"Response: {response}")