Subversion Repositories SmartDukaan

Last modification

• Rev 37363 2026-08-19 20:32:53
• Author: amit

• Log message:

  Offer circular ingest: return affected rows so INSERT IGNORE cannot hide an FK failure
  
  insertBenefit/insertTenure/insertBank use INSERT IGNORE for idempotency, which also
  makes MySQL downgrade a foreign key violation to a warning. Production was bootstrapped
  without the bank / txn_mode / emi_scheme masters, so all 872 benefit and tenure inserts
  were silently discarded: the ingest reported PUBLISHED with 239 offers carrying no
  amounts, no tenures and no bank eligibility, and nothing anywhere said so.
  
  The three methods now return the affected row count (1 written, 0 discarded) so the
  caller can count what landed rather than what it attempted.