[taler-donau] branch master updated: [donaudb] small changes

[gnunet]

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

lukas-matyja pushed a commit to branch master
in repository donau.

The following commit(s) were added to refs/heads/master by this push:
     new f811e37  [donaudb] small changes
f811e37 is described below

commit f811e37f7dcd93137b8c96323a0f48c0536a2d19
Author: Matyja Lukas Adam <lukas.matyja@students.bfh.ch>
AuthorDate: Wed Apr 17 11:01:55 2024 +0200

    [donaudb] small changes
---
 src/donaudb/0002-donau_receipts_issued.sql | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/src/donaudb/0002-donau_receipts_issued.sql 
b/src/donaudb/0002-donau_receipts_issued.sql
index 859b15a..ea144d4 100644
--- a/src/donaudb/0002-donau_receipts_issued.sql
+++ b/src/donaudb/0002-donau_receipts_issued.sql
@@ -32,7 +32,7 @@ COMMENT ON COLUMN receipts_issued.receipt_hash
 CREATE OR REPLACE FUNCTION transaction_save_issue_receipts_request(
    IN charity_id BIGINT -- charity id which made the issue receitps request
   --,IN blinded_sig BYTEA[] -- blinded signatures
-  ,IN receipt_hash BYTEA -- hash over all budi key pairs (primary key)
+  ,IN receipt_h BYTEA -- hash over all budi key pairs (primary key)
   ,IN amount taler_amount -- total amount of the requested receipts
   ,IN new_total_amount taler_amount -- new total amount of a charity
   ,OUT out_receipt_id BIGINT
@@ -43,9 +43,9 @@ BEGIN
 -- Update table charity
 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');
+INSERT INTO receipts_issued (/*blinded_sig,*/ charity_id, receipt_h, amount) 
VALUES (/*'blinded_sig',*/ 'charity_id', 'receipts_hash', 'amount');
 -- Get the receipts id
-SELECT receipt_id into out_receipt_id FROM receipts_issued;
+SELECT receipt_id into out_receipt_id FROM receipts_issued WHERE 
receipt_hash=receipt_h;
 -- Commit the transaction if everything is successful
 END $$;
 COMMIT;

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