libeufin

commit c8890e15a04d96522952e68f2ae8d3076266c6b4
parent 3bbe7b976764c31bf9a9b4ee1cad520ac76c09ab
Author: Antoine A <>
Date:   Wed,  8 Jan 2025 14:47:22 +0100

bank: fix migration

Diffstat:
M
database-versioning/libeufin-bank-0012.sql
 | 
4
+---
M
testbench/src/test/kotlin/MigrationTest.kt
 | 
5
+++++

2 files changed, 6 insertions(+), 3 deletions(-)
diff --git a/database-versioning/libeufin-bank-0012.sql b/database-versioning/libeufin-bank-0012.sql
@@ -23,9 +23,7 @@ ALTER TABLE taler_withdrawal_operations ADD COLUMN no_amount_to_wallet BOOLEAN D
 
 -- Better polymorphism schema
 ALTER TABLE taler_exchange_incoming ADD COLUMN metadata BYTEA;
-INSERT INTO taler_exchange_incoming (metadata)
-  SELECT COALESCE (reserve_pub, account_pub, wad_id)
-  FROM taler_exchange_incoming;
+UPDATE taler_exchange_incoming SET metadata=COALESCE(reserve_pub, account_pub, wad_id);
 ALTER TABLE taler_exchange_incoming
   DROP CONSTRAINT incoming_polymorphism,
   DROP COLUMN reserve_pub,
diff --git a/testbench/src/test/kotlin/MigrationTest.kt b/testbench/src/test/kotlin/MigrationTest.kt
@@ -41,7 +41,12 @@ class MigrationTest {
             INSERT INTO bank_accounts (internal_payto_uri, owning_customer_id) VALUES
                 ('payto_0', 1), ('payto_1', 2);
             INSERT INTO bank_account_transactions(creditor_payto_uri, creditor_name, debtor_payto_uri, debtor_name, subject, amount, transaction_date, direction, bank_account_id) VALUES
+                ('payto_0', 'account_0', 'payto_1', 'account_1', 'subject', (0, 0)::taler_amount, 42, 'credit'::direction_enum, 1),
+                ('payto_0', 'account_0', 'payto_1', 'account_1', 'subject', (0, 0)::taler_amount, 42, 'credit'::direction_enum, 1),
                 ('payto_0', 'account_0', 'payto_1', 'account_1', 'subject', (0, 0)::taler_amount, 42, 'credit'::direction_enum, 1);
+            INSERT INTO taler_exchange_incoming(reserve_pub, bank_transaction) VALUES
+                ('\x6ca1ab1a76a484d7424064c51c49c1947405f42f7d185d052dbf6718d845ec6b'::bytea, 1),
+                ('\xa605637a4852684e4957e6177f41311eacf8661a6a74b90178c487fe347b9918'::bytea, 2);
             INSERT INTO challenges(code, creation_date, expiration_date, retry_counter) VALUES
                 ('secret_code', 42, 42, 42),
                 ('secret_code', 42, 42, 42);