diff options
author | Christian Grothoff <christian@grothoff.org> | 2022-12-29 11:48:57 +0100 |
---|---|---|
committer | Christian Grothoff <christian@grothoff.org> | 2022-12-29 11:48:57 +0100 |
commit | 26aa9d985e2f9ba6ce3895e7e2625226e2008bfb (patch) | |
tree | 951a3d49375a225103c363f005bd0399a195eed4 /src/exchangedb/pg_select_purse.c | |
parent | fa840f7071da56c4794c887b813ca2a6f491f836 (diff) | |
download | exchange-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.c | 28 |
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", |