test_db.py

import os
from supabase import create_client
from dotenv import load_dotenv

load_dotenv('/workspaces/govbridge/.env')
sb = create_client(os.getenv('SUPABASE_URL'), os.getenv('SUPABASE_KEY'))

res = sb.table('schemes').select('id, title').execute()
to_delete = []
for r in res.data:
    t = r['title'].lower()
    if "something went wrong" in t or "sign out" in t or "accessibility" in t or "ministry of " in t:
        to_delete.append(r['id'])

for id in to_delete:
    up_res = sb.table('schemes').update({'is_active': False, 'title': f'DELETED_GHOST_{id}'}).eq('id', id).execute()
    print(f"Disabled {id}")