[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[taler-exchange] branch master updated: -misc fixes
From: |
gnunet |
Subject: |
[taler-exchange] branch master updated: -misc fixes |
Date: |
Sat, 22 Apr 2023 02:54:58 +0200 |
This is an automated email from the git hooks/post-receive script.
grothoff pushed a commit to branch master
in repository exchange.
The following commit(s) were added to refs/heads/master by this push:
new 76b934b2 -misc fixes
76b934b2 is described below
commit 76b934b219b6ec82f58a7e95cbc6fff4f4ed0ebf
Author: Christian Grothoff <christian@grothoff.org>
AuthorDate: Sat Apr 22 02:54:55 2023 +0200
-misc fixes
---
src/exchangedb/exchange_do_reserves_in_insert.sql | 54 +++++++++++------------
1 file changed, 25 insertions(+), 29 deletions(-)
diff --git a/src/exchangedb/exchange_do_reserves_in_insert.sql
b/src/exchangedb/exchange_do_reserves_in_insert.sql
index dd202a2a..6cd5847d 100644
--- a/src/exchangedb/exchange_do_reserves_in_insert.sql
+++ b/src/exchangedb/exchange_do_reserves_in_insert.sql
@@ -145,14 +145,12 @@ LANGUAGE plpgsql
AS $$
DECLARE
curs_reserve_exist REFCURSOR;
+DECLARE
+ k INT8;
DECLARE
curs_transaction_exist REFCURSOR;
DECLARE
i RECORD;
-DECLARE
- r RECORD;
-DECLARE
- k INT8;
BEGIN
transaction_duplicate0 = TRUE;
transaction_duplicate1 = TRUE;
@@ -228,35 +226,33 @@ BEGIN
OPEN curs_transaction_exist FOR
WITH reserve_transaction AS (
- INSERT INTO reserves_in
- (reserve_pub
- ,wire_reference
- ,credit_val
- ,credit_frac
- ,exchange_account_section
- ,wire_source_h_payto
- ,execution_date)
- VALUES
- (in0_reserve_pub
- ,in0_wire_ref
- ,in0_credit_val
- ,in0_credit_frac
- ,in0_exchange_account_name
- ,in0_wire_source_h_payto
- ,in0_execution_date),
- (in1_reserve_pub
- ,in1_wire_ref
- ,in1_credit_val
- ,in1_credit_frac
- ,in1_exchange_account_name
- ,in1_wire_source_h_payto
- ,in1_execution_date)
+ INSERT INTO reserves_in
+ (reserve_pub
+ ,wire_reference
+ ,credit_val
+ ,credit_frac
+ ,exchange_account_section
+ ,wire_source_h_payto
+ ,execution_date)
+ VALUES
+ (in0_reserve_pub
+ ,in0_wire_ref
+ ,in0_credit_val
+ ,in0_credit_frac
+ ,in0_exchange_account_name
+ ,in0_wire_source_h_payto
+ ,in0_execution_date),
+ (in1_reserve_pub
+ ,in1_wire_ref
+ ,in1_credit_val
+ ,in1_credit_frac
+ ,in1_exchange_account_name
+ ,in1_wire_source_h_payto
+ ,in1_execution_date)
ON CONFLICT DO NOTHING
RETURNING reserve_pub)
SELECT reserve_pub FROM reserve_transaction;
- FETCH FROM curs_transaction_exist INTO r;
-
k=0;
<<loop_transaction>> LOOP
FETCH FROM curs_transaction_exist INTO i;
--
To stop receiving notification emails like this one, please contact
gnunet@gnunet.org.