app/supabase_client.py

import os
import requests
from dotenv import load_dotenv

load_dotenv()

SUPABASE_URL = os.getenv("SUPABASE_URL")
SUPABASE_API_KEY = os.getenv("SUPABASE_API_KEY")

HEADERS = {
    "apikey": SUPABASE_API_KEY,
    "Authorization": f"Bearer {SUPABASE_API_KEY}",
    "Content-Type": "application/json"
}

def get_user_by_email(email):
    params = {"email": f"eq.{email}"}
    res = requests.get(f"{SUPABASE_URL}/rest/v1/users", headers=HEADERS, params=params)
    if res.status_code == 200:
        return res.json()
    return None

def create_user(email, password_hash):
    data = {
        "email": email,
        "password": password_hash
    }
    res = requests.post(f"{SUPABASE_URL}/rest/v1/users", headers=HEADERS, json=data)
    return res