# supabase_client.py
from supabase import create_client
import os

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

supabase = create_client(SUPABASE_URL, SUPABASE_KEY)

def listar_metas(user_id):
    response = supabase.table("metas").select("*").eq("user_id", user_id).execute()
    return response

def adicionar_meta(user_id, meta, descricao, status):
    data = {
        "user_id": user_id,
        "meta": meta,
        "descricao": descricao,
        "status": status
    }
    response = supabase.table("metas").insert(data).execute()
    return response