← back to Nationalrealestate

db/migrations/016_source_ingest_run_partial.sql

11 lines

-- TK-10155 Cycle-2 (Cody gate): allow a third ingest mode 'partial'.
-- A 'full' adapter that only covered a fraction of its known listings (flaky/truncated rescan)
-- is downgraded by the ingest engine to 'partial' so it does NOT arm gone-from-feed withdrawal
-- (the detector only treats mode='full' as establishing absence). Prevents fabricated withdrawals.
-- Idempotent: safe to re-run.

ALTER TABLE source_ingest_run DROP CONSTRAINT IF EXISTS source_ingest_run_mode_check;
ALTER TABLE source_ingest_run
  ADD CONSTRAINT source_ingest_run_mode_check
  CHECK (mode IN ('full','incremental','partial'));