Release · v3.11.2
One-click workflow to prune the 7 dead *-Encoded…
chore(db): one-click workflow to prune the 7 dead *-Encoded document rows
Details
Adds a manually-triggered GitHub Action ("Prune dead document rows") and a
REST-based prune script so the cleanup can run without local psql/.env.db.
It mirrors migrations/prune_dead_encoded_documents.sql: deletes only rows whose
title ends in "-Encoded" AND whose public_url carries the double-encoded "2520"
marker (verified to match exactly the 7 dead rows, zero collateral, against live
data). Self-guarding and idempotent; dry-run by default (type "prune" +
dry_run=false to delete). Uses the existing SUPABASE_URL /
SUPABASE_SERVICE_ROLE_KEY repo secrets.
Co-Authored-By: Claude Opus 4.8 <noreply@anthropic.com>
Claude-Session: https://claude.ai/code/session_01HShRpQUmDUttxD5F89ziDu
Files changed (3)
| .github/workflows/prune-documents.yml | +68 | −0 |
| backend/supabase_db/migrations/README.md | +4 | −1 |
| backend/supabase_db/scripts/prune_dead_encoded_documents.py | +104 | −0 |