Subversion Repositories SmartDukaan

Last modification

• Rev 37578 – 27 d 9 h
• Author: amit

• Log message:

  web offer sync: read what the circular grants each MODEL, not each row
  
  selectModelOffers returns one row per (catalog_id, benefit), carrying the context that
  qualifies it - the banks it applies to, its tenures and their scheme, the timing and
  the window. Consolidation happens in the service; this is the read it needs.
  
  LEFT JOIN on the benefit, because a scheme-only offer carries no cashback and dropping
  it here would lose the NCE/LCE badge entirely.
  
  Content-keyed writes alongside: selectSyncedByKey, insertKeyedWebOffer,
  replaceProducts, deactivateMissingKeys. A badge is now identified by a sha256 of its
  terms, so models with identical terms share one and a model appears in exactly one.
  
  Migration add_web_offer_per_model.sql adds circular_offer_key + its unique key, and
  drops the row-keyed CIRCULAR badges - one of those is a fragment of what a
  content-keyed badge says and there is no mapping from five fragments to one whole, so
  they are regenerated by the next ingest.
  
  ⚠️ web_offer_product has NO foreign key to web_offer, so its rows do not cascade and
  are deleted explicitly or they are orphaned. web_offer_sync_shadow does cascade.
  source='CIRCULAR' only - the 3,850 hand-authored rows are never touched.