Spaces:
Running
Running
Commit History
-
feat(phase12): Supabase persistent store + Row Level Security
Saibalaji NamburiSchema (supabase/migrations/001_initial_schema.sql): - tenants: B2B customer organisations - tickets: persistent triage results (status, priority, category, scores) - constitutional_violations: audit log of every safety rule violation - kb_articles: per-tenant knowledge base for RAG grounding - audit_log: immutable append-only event log (RLS: service role INSERT only) - RLS policies on all tenant-scoped tables (app.tenant_id context var) - Auto-updated_at triggers on mutable tables - Indexes: tenant+status, tenant+created, priority, hitl_required Repository layer (src/db/repository.py): - TicketRepository: create, update_status, get, list_recent, log_violation, write_audit - TenantRepository: get_by_slug, create - RepositoryError: typed exception wrapping Supabase errors - RLS double-check at app layer (eq tenant_id on every query) - Non-fatal audit log writes (never crash triage on audit failure) Tests: 18 new tests, all passingaf62db2