diff options
| author | Christian Grothoff <grothoff@gnunet.org> | 2021-11-05 13:20:14 +0100 |
|---|---|---|
| committer | Christian Grothoff <grothoff@gnunet.org> | 2021-11-05 13:20:14 +0100 |
| commit | 766922f7e9bd5570fd12b663e61f8bd622e51c78 (patch) | |
| tree | f4075d021a19f960d8582522f91a91063e0e4e8a /src/exchangedb/plugin_exchangedb_postgres.c | |
| parent | 1408e1587b57903d817e93cdafc2de3156af9e43 (diff) | |
implement missing SQL statement
Diffstat (limited to 'src/exchangedb/plugin_exchangedb_postgres.c')
| -rw-r--r-- | src/exchangedb/plugin_exchangedb_postgres.c | 17 |
1 files changed, 15 insertions, 2 deletions
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); |