donau

commit e01cc09c344f8011700c4a8406fb002bd9894b2d
parent 8790397efb684cf5a5fbc8994d95d4f464855e08
Author: Matyja Lukas Adam <lukas.matyja@students.bfh.ch>
Date:   Mon, 15 Apr 2024 21:40:00 +0200

[donaudb] some changes

Diffstat:
M
src/donaudb/0002-donau_receipts_issued.sql
 | 
6
++----

1 file changed, 2 insertions(+), 4 deletions(-)
diff --git a/src/donaudb/0002-donau_receipts_issued.sql b/src/donaudb/0002-donau_receipts_issued.sql
@@ -37,7 +37,6 @@ CREATE OR REPLACE FUNCTION transaction_save_issue_receipts_request(
   ,IN new_total_amount taler_amount -- new total amount of a charity
   ,OUT out_receipt_id BIGINT
 )
---RETURNS VOID
 LANGUAGE plpgsql
 AS $$
 BEGIN
@@ -45,10 +44,9 @@ BEGIN
 UPDATE charity SET receipts_to_date = new_total_amount;
 -- Insert into the table receipts_issued
 INSERT INTO receipts_issued (/*blinded_sig,*/ charity_id, receipt_hash, amount) VALUES (/*'blinded_sig',*/ 'charity_id', 'receipts_hash', 'amount');
+-- Get the receipts id
+SELECT receipt_id into out_receipt_id FROM receipts_issued;
 -- Commit the transaction if everything is successful
---SELECT receipt_id into out_receipt_id FROM receipt_id FROM receipts_issued;
-out_receipt_id=1;
-
 END $$;
 COMMIT;