libeufin

commit d66b43e756f2b9f39e720b466fa34b25d0a7d522
parent 92d10fc076e807cfbbf40a7f846e0d3c1764c545
Author: Sebastian <sebasjm@gmail.com>
Date:   Tue,  9 Jan 2024 18:38:59 -0300

forget about pending cashout before running migration script

Diffstat:
M
database-versioning/libeufin-bank-0002.sql
 | 
6
++++--

1 file changed, 4 insertions(+), 2 deletions(-)
diff --git a/database-versioning/libeufin-bank-0002.sql b/database-versioning/libeufin-bank-0002.sql
@@ -18,6 +18,9 @@ BEGIN;
 SELECT _v.register_patch('libeufin-bank-0002', NULL, NULL);
 SET search_path TO libeufin_bank;
 
+-- forget about all pending operations
+DELETE FROM cashout_operations WHERE local_transaction IS NULL;
+
 -- TODO drop pending cashout operations
 ALTER TABLE cashout_operations 
   DROP COLUMN challenge,
@@ -62,4 +65,4 @@ COMMENT ON COLUMN tan_challenges.retry_counter IS 'How many tries are left for t
 COMMENT ON COLUMN tan_challenges.tan_channel IS 'TAN channel to use, if null use customer configured one';
 COMMENT ON COLUMN tan_challenges.tan_info IS 'TAN info to use, if null use customer configured one';
 
-COMMIT;
-\ No newline at end of file
+COMMIT;