backend/supabase_api.py

from supabase import create_client, Client
import os
from dotenv import load_dotenv
load_dotenv()

url = os.environ.get("SUPABASE_URL", "")
key = os.environ.get("SUPABASE_KEY", "")
supabase: Client = create_client(url, key)

def insert_blog_post(data: dict):
    try:
        response = supabase.table("blog_posts").insert(data).execute()
        print("Data inserted successfully:", response)
    except Exception as e:
        print("Error inserting data:", e)

def fetch_reddit_data():
    try:
        response = supabase.table("blog_posts").select("*").execute()
        print("Data fetched successfully:", response.data)
        return response.data
    except Exception as e:
        print("Error fetching data:", e)
        return None