[libeufin] 24/37: forget about pending cashout before running migration script

[gnunet]

This is an automated email from the git hooks/post-receive script.

antoine pushed a commit to branch master
in repository libeufin.

commit d66b43e756f2b9f39e720b466fa34b25d0a7d522
Author: Sebastian <sebasjm@gmail.com>
AuthorDate: Tue Jan 9 18:38:59 2024 -0300

    forget about pending cashout before running migration script
---
 database-versioning/libeufin-bank-0002.sql | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

diff --git a/database-versioning/libeufin-bank-0002.sql 
b/database-versioning/libeufin-bank-0002.sql
index 3c7f270c..8092f1e1 100644
--- 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;

-- 
To stop receiving notification emails like this one, please contact
gnunet@gnunet.org.