Line data Source code
1 : /*
2 : This file is part of TALER
3 : Copyright (C) 2022, 2024, 2025 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_reserves_get_origin.c
18 : * @brief Implementation of the reserves_get_origin 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_reserves_get_origin.h"
26 : #include "pg_helper.h"
27 :
28 :
29 : enum GNUNET_DB_QueryStatus
30 75 : TEH_PG_reserves_get_origin (
31 : void *cls,
32 : const struct TALER_ReservePublicKeyP *reserve_pub,
33 : struct TALER_FullPaytoHashP *h_payto,
34 : struct TALER_FullPayto *payto_uri)
35 : {
36 75 : struct PostgresClosure *pg = cls;
37 75 : struct GNUNET_PQ_QueryParam params[] = {
38 75 : GNUNET_PQ_query_param_auto_from_type (reserve_pub),
39 : GNUNET_PQ_query_param_end
40 : };
41 75 : struct GNUNET_PQ_ResultSpec rs[] = {
42 75 : GNUNET_PQ_result_spec_auto_from_type (
43 : "wire_source_h_payto",
44 : h_payto),
45 75 : GNUNET_PQ_result_spec_string (
46 : "payto_uri",
47 : &payto_uri->full_payto),
48 : GNUNET_PQ_result_spec_end
49 : };
50 :
51 75 : PREPARE (pg,
52 : "get_h_wire_source_of_reserve",
53 : "SELECT"
54 : " rt.wire_source_h_payto"
55 : ",wt.payto_uri"
56 : " FROM reserves_in rt"
57 : " JOIN wire_targets wt"
58 : " ON (rt.wire_source_h_payto = wt.wire_target_h_payto)"
59 : " WHERE rt.reserve_pub=$1");
60 75 : return GNUNET_PQ_eval_prepared_singleton_select (
61 : pg->conn,
62 : "get_h_wire_source_of_reserve",
63 : params,
64 : rs);
65 : }
|