backend/check_job_data.py

import asyncio
import os
from supabase import create_client
from dotenv import load_dotenv

load_dotenv()

SUPABASE_URL = os.environ.get("SUPABASE_URL")
SUPABASE_KEY = os.environ.get("SUPABASE_SERVICE_ROLE_KEY") or os.environ.get("SUPABASE_KEY")
client = create_client(SUPABASE_URL, SUPABASE_KEY)

async def check_job():
    job_id = "45bcca29-4e12-45bf-97d4-0b77ff55472f"
    res = client.table("job_embeddings").select("*").eq("job_id", job_id).execute()
    if not res.data:
        print("Job not found in job_embeddings")
        return
        
    data = res.data[0]
    print(f"Data for Job {job_id}:")
    for k, v in data.items():
        if k in ['job_id', 'created_at', 'updated_at']: continue
        print(f"  - {k}: {'POPULATED' if v else 'NULL'}")

if __name__ == "__main__":
    asyncio.run(check_job())