aboutsummaryrefslogtreecommitdiff
path: root/src/exchangedb/pg_select_purse.c
diff options
context:
space:
mode:
authorChristian Grothoff <christian@grothoff.org>2022-12-29 11:48:57 +0100
committerChristian Grothoff <christian@grothoff.org>2022-12-29 11:48:57 +0100
commit26aa9d985e2f9ba6ce3895e7e2625226e2008bfb (patch)
tree951a3d49375a225103c363f005bd0399a195eed4 /src/exchangedb/pg_select_purse.c
parentfa840f7071da56c4794c887b813ca2a6f491f836 (diff)
downloadexchange-26aa9d985e2f9ba6ce3895e7e2625226e2008bfb.tar.xz
expand DB API with AML functions, fix purse refund calculations in libtalerexchange
Diffstat (limited to 'src/exchangedb/pg_select_purse.c')
-rw-r--r--src/exchangedb/pg_select_purse.c28
1 files changed, 14 insertions, 14 deletions
diff --git a/src/exchangedb/pg_select_purse.c b/src/exchangedb/pg_select_purse.c
index 9143e8721..6496d4a28 100644
--- a/src/exchangedb/pg_select_purse.c
+++ b/src/exchangedb/pg_select_purse.c
@@ -66,20 +66,20 @@ TEH_PG_select_purse (
PREPARE (pg,
"select_purse",
"SELECT "
- " merge_pub"
- ",purse_creation"
- ",purse_expiration"
- ",h_contract_terms"
- ",amount_with_fee_val"
- ",amount_with_fee_frac"
- ",balance_val"
- ",balance_frac"
- ",merge_timestamp"
- ",purse_sig IS NOT NULL AS purse_deleted"
- " FROM purse_requests"
- " LEFT JOIN purse_merges USING (purse_pub)"
- " LEFT JOIN purse_deletion USING (purse_pub)"
- " WHERE purse_pub=$1;");
+ " pr.merge_pub"
+ ",pr.purse_creation"
+ ",pr.purse_expiration"
+ ",pr.h_contract_terms"
+ ",pr.amount_with_fee_val"
+ ",pr.amount_with_fee_frac"
+ ",pr.balance_val"
+ ",pr.balance_frac"
+ ",pm.merge_timestamp"
+ ",pd.purse_sig IS NOT NULL AS purse_deleted"
+ " FROM purse_requests pr"
+ " LEFT JOIN purse_merges pm ON (pm.purse_pub = pr.purse_pub)"
+ " LEFT JOIN purse_deletion pd ON (pd.purse_pub = pr.purse_pub)"
+ " WHERE pr.purse_pub=$1;");
*merge_timestamp = GNUNET_TIME_UNIT_FOREVER_TS;
return GNUNET_PQ_eval_prepared_singleton_select (pg->conn,
"select_purse",