Line data Source code
1 : /*
2 : This file is part of TALER
3 : Copyright (C) 2026 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/get_denomination_pub_by_serial.c
18 : * @brief Implementation of the get_denomination_pub_by_serial function for Postgres
19 : * @author Özgür Kesim
20 : */
21 : #include "platform.h"
22 : #include "taler/taler_error_codes.h"
23 : #include "taler/taler_dbevents.h"
24 : #include "exchangedb_lib.h"
25 : #include "taler/taler_pq_lib.h"
26 : #include "exchange-database/get_denomination_pub_by_serial.h"
27 : #include "helper.h"
28 :
29 :
30 : enum GNUNET_DB_QueryStatus
31 2 : TALER_EXCHANGEDB_get_denomination_pub_by_serial (
32 : struct TALER_EXCHANGEDB_PostgresContext *pg,
33 : uint64_t denom_serial,
34 : struct TALER_DenominationPublicKey *denom_pub)
35 : {
36 2 : struct GNUNET_PQ_QueryParam params[] = {
37 2 : GNUNET_PQ_query_param_uint64 (&denom_serial),
38 : GNUNET_PQ_query_param_end
39 : };
40 2 : struct GNUNET_PQ_ResultSpec rs[] = {
41 2 : TALER_PQ_result_spec_denom_pub ("denom_pub",
42 : denom_pub),
43 : GNUNET_PQ_result_spec_end
44 : };
45 :
46 2 : PREPARE (pg,
47 : "get_denomination_pub_by_serial",
48 : "SELECT"
49 : " denom_pub"
50 : " FROM denominations"
51 : " WHERE denominations_serial=$1;");
52 2 : return GNUNET_PQ_eval_prepared_singleton_select (
53 : pg->conn,
54 : "get_denomination_pub_by_serial",
55 : params,
56 : rs);
57 : }
|