Subversion Repositories SmartDukaan
(root)//trunk/profitmandi-dao/src/main/resources/sql/add_web_offer_per_model.sql – Rev 37581
Rev 37578 | Compare with Previous | Directory listing | Details | Blame | View Log | RSS feed
Last modification
- Rev 37581 – 27 d 7 h
- Author: amit
- Log message:
- web offer sync: retire the pre-consolidation badges instead of deleting them
The sync now deactivates any CIRCULAR row with a NULL circular_offer_key on its next
run. A row-keyed badge is a fragment of what a consolidated badge says, so leaving it
active would show a partner the same offer twice - once whole and once in pieces.
That removes the DELETE from the migration entirely, which is strictly better:
* nothing is destroyed, so a bad sync is one UPDATE away from being undone
* web_offer_product has NO foreign key to web_offer, so the DELETE had to clear its
532 rows separately or strand them as orphans
* no window where a circular has no badges at all - the old ones stay live until the
new ones exist
The migration is now purely additive: one ALTER, safe to run ahead of the deploy, which
is how it was applied to prod.
