2 ms·
You just deal with it. Manually if need be, sending someone a spreadsheet. Not that hard, just a right pita. Tbh the article's actual example is stupid, if I d
by mattmanser 2y ago
You just deal with it. Manually if need be, sending someone a spreadsheet. Not that hard, just a right pita.
Tbh the article's actual example is stupid, if I desperately need to rollback that change I'd just take a backup of that table and change the new types back to the main payment method, 'Stripe'. When we've got it fixed and redeploy the changes, change them back.
Problem solved in two SQL queries.
Not sure if the author's never had to deal with a problem like this before, but his 'impossible' problem's got a bloody obvious solution.
SELECT * INTO _paymentsbackup FROM payments WHERE PaymentType in (3, 4)
UPDATE payments SET PayemntType = 1 WHERE PaymentType in (3, 4)
- prng2021 2y agoLol. Your solution is to change a bunch of recorded money transactions? Oh shoot I messed up. Let me just change all these cash transactions temporarily to stripe. Oh shoot I also messed up my sales tax for these geographic regions. Let me just change all the dollar amounts temporarily. That’s hilarious.