lekss361
  • Joined on 2026-05-15
lekss361 commented on issue lekss361/gendesign#1336 2026-06-15 11:12:27 +00:00
(critical) SRID: геометрия кварталов и зданий из rosreestr2coord (WGS84) ошибочно ST_Transform'ится из 3857 → коллапс к Null Island

🔍 week ревью 1 — верификация (ПОДТВЕРЖДЕНО)

Текущее состояние кода: backend/app/workers/tasks/nspd_geo.py:154 (_save_quarter) и…

lekss361 created pull request lekss361/gendesign#1296 2026-06-13 08:27:28 +00:00
feat(tradein): scheduler-источник cian_city_sweep (newbuilding Phase 4), seed dormant (#973)
lekss361 deleted branch fix/tradein-segment-guards from lekss361/gendesign 2026-06-12 09:06:30 +00:00
lekss361 merged pull request lekss361/gendesign#1192 2026-06-12 09:06:29 +00:00
fix(tradein): guard listing_segment во всех оценочных читателях listings — novostroyki вне comps (#1186)
lekss361 pushed to main at lekss361/gendesign 2026-06-12 09:06:29 +00:00
d64a57cfcd Merge pull request 'fix(tradein): guard listing_segment во всех оценочных читателях listings — novostroyki вне comps (#1186)' (#1192) from fix/tradein-segment-guards into main
a9a489bba5 refactor(tradein): убрать dead listing_segment param из _fetch_anchor_comps + негативные guard-asserts (review fixup, #1186)
b70ae46885 fix(tradein): guard listing_segment во всех читателях listings — novostroyki вне comps (#1186)
Compare 3 commits »
lekss361 deleted branch feat/market-grant-listings-reader from lekss361/gendesign 2026-06-12 09:06:21 +00:00
lekss361 closed issue lekss361/gendesign#1191 2026-06-12 09:06:20 +00:00
[market-слой] F: GRANT listings для gendesign_reader — unit-level квартиры доступны Site Finder'у запросом
lekss361 pushed to main at lekss361/gendesign 2026-06-12 09:06:20 +00:00
6d4dbd3e9d Merge pull request 'feat(market): GRANT listings + offer_price_history → gendesign_reader (#1191)' (#1193) from feat/market-grant-listings-reader into main
9ffadb9ea6 feat(market): GRANT listings → gendesign_reader — unit-level доступ SF (#1191)
Compare 2 commits »
lekss361 merged pull request lekss361/gendesign#1193 2026-06-12 09:06:19 +00:00
feat(market): GRANT listings + offer_price_history → gendesign_reader (#1191)
lekss361 closed issue lekss361/gendesign#976 2026-06-12 09:06:05 +00:00
[SF-v2 #950] 950-E5: Cross-load ETL tradein→gendesign newbuilding
lekss361 commented on issue lekss361/gendesign#976 2026-06-12 09:05:56 +00:00
[SF-v2 #950] 950-E5: Cross-load ETL tradein→gendesign newbuilding

QA PASS — закрываю (прод-верификация qa-tester, 2026-06-12 ~12:10):

  • Прод на 9b06377 (merge PR #1185); миграция 101 в _schema_migrations,…
lekss361 created pull request lekss361/gendesign#1193 2026-06-12 09:05:50 +00:00
feat(market): GRANT listings + offer_price_history → gendesign_reader (#1191)
lekss361 created pull request lekss361/gendesign#1192 2026-06-12 09:01:59 +00:00
fix(tradein): guard listing_segment во всех оценочных читателях listings — novostroyki вне comps (#1186)
lekss361 opened issue lekss361/gendesign#1191 2026-06-12 08:40:37 +00:00
[market-слой] F: GRANT listings для gendesign_reader — unit-level квартиры доступны Site Finder'у запросом
lekss361 opened issue lekss361/gendesign#1190 2026-06-12 08:40:27 +00:00
[tradein] E (backlog): N1 — режим первички (отдельный URL-паттерн)
lekss361 opened issue lekss361/gendesign#1189 2026-06-12 08:40:21 +00:00
[tradein] D: QA полной загрузки сегментов на проде — counts, стабильность estimator, EXPLAIN → решение об индексе
lekss361 opened issue lekss361/gendesign#1188 2026-06-12 08:40:10 +00:00
[tradein] C: API-параметр segment=vtorichka
lekss361 opened issue lekss361/gendesign#1187 2026-06-12 08:40:04 +00:00
[tradein] B: Полная загрузка всех сегментов — secondary_only=False (cian/yandex), верификация avito
lekss361 opened issue lekss361/gendesign#1186 2026-06-12 08:39:23 +00:00
[tradein] A: Query-side guard вторички — estimator/asking_to_sold/matview не должны читать novostroyki из listings
lekss361 commented on issue lekss361/gendesign#976 2026-06-12 08:31:30 +00:00
[SF-v2 #950] 950-E5: Cross-load ETL tradein→gendesign newbuilding

Ручные шаги из предыдущего коммента уже выполнены (2026-06-12, по указанию Anton, через ssh):

  • TRADEIN_READER_PASSWORD