diff options
| author | Christian Grothoff <christian@grothoff.org> | 2022-10-03 23:54:12 +0200 |
|---|---|---|
| committer | Christian Grothoff <christian@grothoff.org> | 2022-10-03 23:54:12 +0200 |
| commit | 856b8e26c2b83ebce31eb35c9fc9f23641187be9 (patch) | |
| tree | 534951703f78a785702d0d2d82a43b425684ca60 /src/exchangedb/pg_iterate_reserve_close_info.c | |
| parent | 4a487b179c013886721c4aa06af9c75e9aad508c (diff) | |
| download | exchange-856b8e26c2b83ebce31eb35c9fc9f23641187be9.tar.xz | |
-more work on new DB logic
Diffstat (limited to 'src/exchangedb/pg_iterate_reserve_close_info.c')
| -rw-r--r-- | src/exchangedb/pg_iterate_reserve_close_info.c | 23 |
1 files changed, 12 insertions, 11 deletions
diff --git a/src/exchangedb/pg_iterate_reserve_close_info.c b/src/exchangedb/pg_iterate_reserve_close_info.c index c5ff61322..f1b2d452b 100644 --- a/src/exchangedb/pg_iterate_reserve_close_info.c +++ b/src/exchangedb/pg_iterate_reserve_close_info.c @@ -68,7 +68,7 @@ iterate_reserve_close_info_cb (void *cls, struct TALER_Amount amount; struct GNUNET_TIME_Absolute ts; struct GNUNET_PQ_ResultSpec rs[] = { - GNUNET_PQ_result_spec_absolute_time ("timestamp", + GNUNET_PQ_result_spec_absolute_time ("execution_date", &ts), TALER_PQ_RESULT_SPEC_AMOUNT ("amount", &amount), @@ -115,14 +115,15 @@ TEH_PG_iterate_reserve_close_info ( "SELECT" " amount_val" ",amount_frac" - ",timestamp" - " FROM FIXME" - " WHERE h_payto=$1" - " AND timestamp >= $2" - " ORDER BY timestamp DESC"); - return GNUNET_PQ_eval_prepared_multi_select (pg->conn, - "iterate_reserve_close_info", - params, - &iterate_reserve_close_info_cb, - &ic); + ",execution_date" + " FROM reserves_close" + " WHERE wire_target_h_payto=$1" + " AND execution_date >= $2" + " ORDER BY execution_date DESC"); + return GNUNET_PQ_eval_prepared_multi_select ( + pg->conn, + "iterate_reserve_close_info", + params, + &iterate_reserve_close_info_cb, + &ic); } |