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 backenddb/pg_lookup_contract_terms.c
18 : * @brief Implementation of the lookup_contract_terms function for Postgres
19 : * @author Iván Ávalos
20 : * @author Christian Grothoff
21 : */
22 : #include "platform.h"
23 : #include <taler/taler_error_codes.h>
24 : #include <taler/taler_dbevents.h>
25 : #include <taler/taler_pq_lib.h>
26 : #include "pg_lookup_contract_terms.h"
27 : #include "pg_helper.h"
28 :
29 :
30 : enum GNUNET_DB_QueryStatus
31 94 : TMH_PG_lookup_contract_terms (
32 : void *cls,
33 : const char *instance_id,
34 : const char *order_id,
35 : json_t **contract_terms,
36 : uint64_t *order_serial,
37 : struct TALER_ClaimTokenP *claim_token)
38 : {
39 94 : struct PostgresClosure *pg = cls;
40 : enum GNUNET_DB_QueryStatus qs;
41 : struct TALER_ClaimTokenP ct;
42 94 : struct GNUNET_PQ_QueryParam params[] = {
43 94 : GNUNET_PQ_query_param_string (instance_id),
44 94 : GNUNET_PQ_query_param_string (order_id),
45 : GNUNET_PQ_query_param_end
46 : };
47 94 : struct GNUNET_PQ_ResultSpec rs[] = {
48 : /* contract_terms must be first! */
49 94 : TALER_PQ_result_spec_json ("contract_terms",
50 : contract_terms),
51 94 : GNUNET_PQ_result_spec_uint64 ("order_serial",
52 : order_serial),
53 94 : GNUNET_PQ_result_spec_auto_from_type ("claim_token",
54 : &ct),
55 : GNUNET_PQ_result_spec_end
56 : };
57 :
58 94 : check_connection (pg);
59 94 : PREPARE (pg,
60 : "lookup_contract_terms",
61 : "SELECT"
62 : " contract_terms::TEXT"
63 : ",order_serial"
64 : ",claim_token"
65 : " FROM merchant_contract_terms"
66 : " WHERE order_id=$2"
67 : " AND merchant_serial="
68 : " (SELECT merchant_serial"
69 : " FROM merchant_instances"
70 : " WHERE merchant_id=$1)");
71 94 : qs = GNUNET_PQ_eval_prepared_singleton_select (pg->conn,
72 : "lookup_contract_terms",
73 : params,
74 : (NULL != contract_terms)
75 : ? rs
76 : : &rs[1]);
77 94 : if (NULL != claim_token)
78 0 : *claim_token = ct;
79 94 : return qs;
80 : }
|