From 766922f7e9bd5570fd12b663e61f8bd622e51c78 Mon Sep 17 00:00:00 2001 From: Christian Grothoff Date: Fri, 5 Nov 2021 13:20:14 +0100 Subject: implement missing SQL statement --- src/exchangedb/plugin_exchangedb_postgres.c | 17 +++++++++++++++-- 1 file changed, 15 insertions(+), 2 deletions(-) (limited to 'src/exchangedb') diff --git a/src/exchangedb/plugin_exchangedb_postgres.c b/src/exchangedb/plugin_exchangedb_postgres.c index 66bad461b..3340a70d6 100644 --- a/src/exchangedb/plugin_exchangedb_postgres.c +++ b/src/exchangedb/plugin_exchangedb_postgres.c @@ -1885,6 +1885,19 @@ prepare_statements (struct PostgresClosure *pg) " FROM denominations" " WHERE denom_pub_hash=$2);", 2), + /* used in #postgres_select_withdraw_amounts_by_account() */ + GNUNET_PQ_make_prepare ( + "select_above_date_by_reserves_out", + "SELECT" + " amount_with_fee_val" + ",amount_with_fee_frac" + " FROM reserves_out" + " WHERE reserve_uuid=" + " (SELECT reserve_uuid" + " FROM reserves" + " WHERE reserve_pub=$1)" + " AND execution_date > $2;", + 2), /* used in #postgres_lookup_wire_fee_by_time() */ GNUNET_PQ_make_prepare ( "lookup_wire_fee_by_time", @@ -4937,7 +4950,7 @@ withdraw_amount_by_account_cb (void *cls, { struct TALER_Amount val; struct GNUNET_PQ_ResultSpec rs[] = { - TALER_PQ_RESULT_SPEC_AMOUNT ("val", + TALER_PQ_RESULT_SPEC_AMOUNT ("amount_with_fee", &val), GNUNET_PQ_result_spec_end }; @@ -4995,7 +5008,7 @@ postgres_select_withdraw_amounts_by_account ( qs = GNUNET_PQ_eval_prepared_multi_select ( pg->conn, - "select_XXX_FIXME", + "select_above_date_by_reserves_out", params, &withdraw_amount_by_account_cb, &wac); -- cgit v1.2.3