Line data Source code
1 : /*
2 : This file is part of TALER
3 : Copyright (C) 2022, 2024 Taler Systems SA
4 :
5 : TALER is free software; you can redistribute it and/or modify it under the
6 : terms of the GNU General Public License as published by the Free Software
7 : Foundation; either version 3, or (at your option) any later version.
8 :
9 : TALER is distributed in the hope that it will be useful, but WITHOUT ANY
10 : WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
11 : A PARTICULAR PURPOSE. See the GNU General Public License for more details.
12 :
13 : You should have received a copy of the GNU General Public License along with
14 : TALER; see the file COPYING. If not, see <http://www.gnu.org/licenses/>
15 : */
16 : /**
17 : * @file exchangedb/pg_profit_drains_get_pending.c
18 : * @brief Implementation of the profit_drains_get_pending function for Postgres
19 : * @author Christian Grothoff
20 : */
21 : #include "taler/platform.h"
22 : #include "taler/taler_error_codes.h"
23 : #include "taler/taler_dbevents.h"
24 : #include "taler/taler_pq_lib.h"
25 : #include "pg_profit_drains_get_pending.h"
26 : #include "pg_helper.h"
27 :
28 :
29 : enum GNUNET_DB_QueryStatus
30 0 : TEH_PG_profit_drains_get_pending (
31 : void *cls,
32 : uint64_t *serial,
33 : struct TALER_WireTransferIdentifierRawP *wtid,
34 : char **account_section,
35 : struct TALER_FullPayto *payto_uri,
36 : struct GNUNET_TIME_Timestamp *request_timestamp,
37 : struct TALER_Amount *amount,
38 : struct TALER_MasterSignatureP *master_sig)
39 : {
40 0 : struct PostgresClosure *pg = cls;
41 0 : struct GNUNET_PQ_QueryParam params[] = {
42 : GNUNET_PQ_query_param_end
43 : };
44 0 : struct GNUNET_PQ_ResultSpec rs[] = {
45 0 : GNUNET_PQ_result_spec_uint64 ("profit_drain_serial_id",
46 : serial),
47 0 : GNUNET_PQ_result_spec_auto_from_type ("wtid",
48 : wtid),
49 0 : GNUNET_PQ_result_spec_string ("account_section",
50 : account_section),
51 0 : GNUNET_PQ_result_spec_string ("payto_uri",
52 : &payto_uri->full_payto),
53 0 : GNUNET_PQ_result_spec_timestamp ("trigger_date",
54 : request_timestamp),
55 0 : TALER_PQ_RESULT_SPEC_AMOUNT ("amount",
56 : amount),
57 0 : GNUNET_PQ_result_spec_auto_from_type ("master_sig",
58 : master_sig),
59 : GNUNET_PQ_result_spec_end
60 : };
61 : /* Used in #postgres_profit_drains_get_pending() */
62 0 : PREPARE (pg,
63 : "get_ready_profit_drain",
64 : "SELECT"
65 : " profit_drain_serial_id"
66 : ",wtid"
67 : ",account_section"
68 : ",payto_uri"
69 : ",trigger_date"
70 : ",amount"
71 : ",master_sig"
72 : " FROM profit_drains"
73 : " WHERE NOT executed"
74 : " ORDER BY trigger_date ASC;");
75 0 : return GNUNET_PQ_eval_prepared_singleton_select (pg->conn,
76 : "get_ready_profit_drain",
77 : params,
78 : rs);
79 : }
|