lekss361
deleted branch feat/price-history-trigger-and-lastseen-index from lekss361/gendesign
2026-06-16 16:49:00 +00:00
feat(tradein/db): derived price-history trigger (avito/yandex) + last_seen_at deactivate index
feat(tradein/db): derived price-history trigger (avito/yandex) + last_seen_at deactivate index
feat(scrapers): segment-aware generic deactivate_stale for yandex/cian
Deep review — APPROVE + merged (squash).
Verified at head 0267d517:
- SQL param safety: both UPDATE variants use bound params, CAST(:ttl_days
lekss361
deleted branch feat/deactivate-stale-generic-segment-aware from lekss361/gendesign
2026-06-16 16:09:21 +00:00
feat(scrapers): segment-aware generic deactivate_stale for yandex/cian
fix(scrapers): deactivate pre-#753 ghost duplicate listings (dedup correctness)
Deep review (post-hoc — PR was already squash-merged by lekss361 at 12:59Z; not re-merged).
Verdict: APPROVE. Migration is correct, idempotent, atomic, and verified clean on prod.
Checks…
feat(scrapers): segment-aware generic deactivate_stale for yandex/cian
lekss361
deleted branch fix/deactivate-ghost-duplicate-listings from lekss361/gendesign
2026-06-16 12:59:50 +00:00
fix(scrapers): deactivate pre-#753 ghost duplicate listings (dedup correctness)
fix(scrapers): deactivate pre-#753 ghost duplicate listings (dedup correctness)
chore(scrapers): убрать устаревший n1-скраппер (n1.ru → cian), сохранить историч. данные
Yandex detail-enrichment не реализован: нет save + detail не fetch'ится в свипе (area_m2 23%, repair 1%)
Уточнение по реализации (снижает scope)
Yandex-свип уже fetch'ит detail-страницу — Phase 3 address-enrich в run_yandex_city_sweep…
Yandex detail-enrichment не реализован: нет save + detail не fetch'ится в свипе (area_m2 23%, repair 1%)
Avito detail-enrichment backfill для legacy listings (detail_enriched_at IS NULL) — прокси уже есть
Задеплоено + verified на проде 2026-06-16 (PR #1552)
- Миграция 112 применена,
scrape_schedules.avito_detail_backfillenabled, окно 9-12 UTC, next_run…