Line data Source code
1 : /*
2 : This file is part of TALER
3 : Copyright (C) 2022 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_get_coin_denomination.c
18 : * @brief Implementation of the get_coin_denomination 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_get_coin_denomination.h"
26 : #include "pg_helper.h"
27 :
28 : enum GNUNET_DB_QueryStatus
29 42 : TEH_PG_get_coin_denomination (
30 : void *cls,
31 : const struct TALER_CoinSpendPublicKeyP *coin_pub,
32 : uint64_t *known_coin_id,
33 : struct TALER_DenominationHashP *denom_hash)
34 : {
35 42 : struct PostgresClosure *pg = cls;
36 42 : struct GNUNET_PQ_QueryParam params[] = {
37 42 : GNUNET_PQ_query_param_auto_from_type (coin_pub),
38 : GNUNET_PQ_query_param_end
39 : };
40 42 : struct GNUNET_PQ_ResultSpec rs[] = {
41 42 : GNUNET_PQ_result_spec_auto_from_type ("denom_pub_hash",
42 : denom_hash),
43 42 : GNUNET_PQ_result_spec_uint64 ("known_coin_id",
44 : known_coin_id),
45 : GNUNET_PQ_result_spec_end
46 : };
47 :
48 42 : GNUNET_log (GNUNET_ERROR_TYPE_DEBUG,
49 : "Getting coin denomination of coin %s\n",
50 : TALER_B2S (coin_pub));
51 :
52 : /* Used in #postgres_get_coin_denomination() to fetch
53 : the denomination public key hash for
54 : a coin known to the exchange. */
55 42 : PREPARE (pg,
56 : "get_coin_denomination",
57 : "SELECT"
58 : " denominations.denom_pub_hash"
59 : ",known_coin_id"
60 : " FROM known_coins"
61 : " JOIN denominations USING (denominations_serial)"
62 : " WHERE coin_pub=$1"
63 : " FOR SHARE;");
64 :
65 42 : return GNUNET_PQ_eval_prepared_singleton_select (pg->conn,
66 : "get_coin_denomination",
67 : params,
68 : rs);
69 : }
|