commit a4e4fecc43026e754364d4f1e4383c331e664d2c
parent 7bee8268c5185860dfe0299d5ef092953ab5a366
Author: Christian Grothoff <grothoff@gnunet.org>
Date: Sun, 12 Apr 2026 19:44:14 +0200
implement missing SQL function
Diffstat:
1 file changed, 10 insertions(+), 10 deletions(-)
diff --git a/src/exchangedb/select_reserve_close_request_info.c b/src/exchangedb/select_reserve_close_request_info.c
@@ -41,9 +41,9 @@ TALER_EXCHANGEDB_select_reserve_close_request_info (
struct GNUNET_PQ_ResultSpec rs[] = {
GNUNET_PQ_result_spec_auto_from_type ("reserve_sig",
reserve_sig),
- GNUNET_PQ_result_spec_timestamp ("request_timestamp",
+ GNUNET_PQ_result_spec_timestamp ("close_timestamp",
request_timestamp),
- TALER_PQ_result_spec_amount ("close_balance",
+ TALER_PQ_result_spec_amount ("close",
pg->currency,
close_balance),
TALER_PQ_result_spec_amount ("close_fee",
@@ -54,17 +54,17 @@ TALER_EXCHANGEDB_select_reserve_close_request_info (
GNUNET_PQ_result_spec_end
};
- // FIXME: this SQL query is still complete nonsense!
PREPARE (pg,
"select_reserve_close_request_info",
"SELECT "
- " r.current_balance"
- ",wt.payto_uri"
- " FROM reserves r"
- " LEFT JOIN reserves_in ri"
- " USING (reserve_pub)"
- " WHERE r.reserve_pub=$1"
- " AND r.row_id=$2;");
+ " cr.reserve_sig"
+ " ,cr.close_timestamp"
+ " ,cr.close"
+ " ,cr.close_fee"
+ " ,cr.payto_uri"
+ " FROM close_requests cr"
+ " WHERE cr.reserve_pub=$1"
+ " AND cr.row_id=$2;");
return GNUNET_PQ_eval_prepared_singleton_select (
pg->conn,
"select_reserve_close_request_info",