lekss361
  • Joined on 2026-05-15
lekss361 deleted branch feat/price-history-trigger-and-lastseen-index from lekss361/gendesign 2026-06-16 16:49:00 +00:00
lekss361 pushed to main at lekss361/gendesign 2026-06-16 16:49:00 +00:00
e46867fa7f feat(tradein/db): derived price-history trigger (avito/yandex) + last_seen_at deactivate index (#1559)
lekss361 merged pull request lekss361/gendesign#1559 2026-06-16 16:48:59 +00:00
feat(tradein/db): derived price-history trigger (avito/yandex) + last_seen_at deactivate index
lekss361 created pull request lekss361/gendesign#1559 2026-06-16 16:44:44 +00:00
feat(tradein/db): derived price-history trigger (avito/yandex) + last_seen_at deactivate index
lekss361 commented on pull request lekss361/gendesign#1558 2026-06-16 16:09:33 +00:00
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
lekss361 pushed to main at lekss361/gendesign 2026-06-16 16:09:20 +00:00
91f9a95f93 feat(scrapers): segment-aware generic deactivate_stale for yandex/cian (#1558)
lekss361 merged pull request lekss361/gendesign#1558 2026-06-16 16:09:20 +00:00
feat(scrapers): segment-aware generic deactivate_stale for yandex/cian
lekss361 commented on pull request lekss361/gendesign#1557 2026-06-16 16:04:29 +00:00
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…

lekss361 created pull request lekss361/gendesign#1558 2026-06-16 15:59:06 +00:00
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
lekss361 pushed to main at lekss361/gendesign 2026-06-16 12:59:49 +00:00
496af12c9c Merge pull request 'fix(scrapers): deactivate pre-#753 ghost duplicate listings (dedup correctness)' (#1557) from fix/deactivate-ghost-duplicate-listings into main
6b7391ba93 fix(db): deactivate pre-#753 ghost duplicate listings (167 rows)
Compare 2 commits »
lekss361 merged pull request lekss361/gendesign#1557 2026-06-16 12:59:47 +00:00
fix(scrapers): deactivate pre-#753 ghost duplicate listings (dedup correctness)
lekss361 created pull request lekss361/gendesign#1557 2026-06-16 12:41:16 +00:00
fix(scrapers): deactivate pre-#753 ghost duplicate listings (dedup correctness)
lekss361 created pull request lekss361/gendesign#1556 2026-06-16 11:56:06 +00:00
chore(scrapers): убрать устаревший n1-скраппер (n1.ru → cian), сохранить историч. данные
lekss361 created pull request lekss361/gendesign#1555 2026-06-16 11:40:51 +00:00
fix(scrapers): cian detail — извлечение kitchen_area_m2 (part of #1553)
lekss361 created pull request lekss361/gendesign#1554 2026-06-16 11:14:52 +00:00
feat(scrapers): yandex detail-enrichment — save + ночной backfill через прокси (part of #1553)
lekss361 commented on issue lekss361/gendesign#1553 2026-06-16 10:50:14 +00:00
Yandex detail-enrichment не реализован: нет save + detail не fetch'ится в свипе (area_m2 23%, repair 1%)

Уточнение по реализации (снижает scope)

Yandex-свип уже fetch'ит detail-страницу — Phase 3 address-enrich в run_yandex_city_sweep

lekss361 opened issue lekss361/gendesign#1553 2026-06-16 10:48:45 +00:00
Yandex detail-enrichment не реализован: нет save + detail не fetch'ится в свипе (area_m2 23%, repair 1%)
lekss361 commented on issue lekss361/gendesign#1551 2026-06-16 10:44:27 +00:00
Avito detail-enrichment backfill для legacy listings (detail_enriched_at IS NULL) — прокси уже есть

Задеплоено + verified на проде 2026-06-16 (PR #1552)

  • Миграция 112 применена, scrape_schedules.avito_detail_backfill enabled, окно 9-12 UTC, next_run…