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 src/backenddb/insert_kyc_status.c
18 : * @brief Implementation of the insert_kyc_status function for Postgres
19 : * @author Iván Ávalos
20 : * @author Christian Grothoff
21 : */
22 : #include "platform.h"
23 : #include <taler/taler_dbevents.h>
24 : #include <taler/taler_pq_lib.h>
25 : #include "merchant-database/insert_kyc_status.h"
26 : #include "helper.h"
27 :
28 :
29 : enum GNUNET_DB_QueryStatus
30 39 : TALER_MERCHANTDB_insert_kyc_status (
31 : struct TALER_MERCHANTDB_PostgresContext *pg,
32 : const char *merchant_id,
33 : const struct TALER_MerchantWireHashP *h_wire,
34 : const char *exchange_url,
35 : struct GNUNET_TIME_Timestamp timestamp,
36 : struct GNUNET_TIME_Absolute next_time,
37 : struct GNUNET_TIME_Relative kyc_backoff,
38 : unsigned int exchange_http_status,
39 : enum TALER_ErrorCode exchange_ec_code,
40 : uint64_t rule_gen,
41 : const struct TALER_AccountAccessTokenP *access_token,
42 : const json_t *jlimits,
43 : bool in_aml_review,
44 : bool kyc_ok)
45 : {
46 39 : struct TALER_MERCHANTDB_MerchantKycStatusChangeEventP ev = {
47 39 : .header.size = htons (sizeof (ev)),
48 39 : .header.type = htons (TALER_DBEVENT_MERCHANT_EXCHANGE_KYC_STATUS_CHANGED),
49 : .merchant_pub = pg->current_merchant_pub,
50 : .h_wire = *h_wire
51 : };
52 39 : struct TALER_MERCHANTDB_InstanceKycStatusChangeEventP hdr = {
53 39 : .header.size = htons (sizeof (hdr)),
54 39 : .header.type = htons (TALER_DBEVENT_MERCHANT_KYC_STATUS_CHANGED),
55 : .merchant_pub = pg->current_merchant_pub
56 : };
57 : char *notify_s
58 39 : = GNUNET_PQ_get_event_notify_channel (&ev.header);
59 : char *notify2_s
60 39 : = GNUNET_PQ_get_event_notify_channel (&hdr.header);
61 39 : uint32_t http_status32 = (uint32_t) exchange_http_status;
62 39 : uint32_t ec_code32 = (uint32_t) exchange_ec_code;
63 39 : struct GNUNET_PQ_QueryParam params[] = {
64 39 : GNUNET_PQ_query_param_auto_from_type (h_wire),
65 39 : GNUNET_PQ_query_param_string (exchange_url),
66 39 : GNUNET_PQ_query_param_timestamp (×tamp),
67 39 : GNUNET_PQ_query_param_uint32 (&http_status32),
68 39 : GNUNET_PQ_query_param_uint32 (&ec_code32),
69 : NULL != access_token
70 7 : ? GNUNET_PQ_query_param_auto_from_type (access_token)
71 39 : : GNUNET_PQ_query_param_null (),
72 : NULL != jlimits
73 7 : ? TALER_PQ_query_param_json (jlimits)
74 39 : : GNUNET_PQ_query_param_null (),
75 39 : GNUNET_PQ_query_param_bool (in_aml_review),
76 39 : GNUNET_PQ_query_param_bool (kyc_ok),
77 39 : GNUNET_PQ_query_param_string (notify_s),
78 39 : GNUNET_PQ_query_param_string (notify2_s),
79 39 : GNUNET_PQ_query_param_uint64 (&rule_gen),
80 39 : GNUNET_PQ_query_param_absolute_time (&next_time),
81 39 : GNUNET_PQ_query_param_relative_time (&kyc_backoff),
82 : GNUNET_PQ_query_param_end
83 : };
84 : bool no_account;
85 39 : struct GNUNET_PQ_ResultSpec rs[] = {
86 39 : GNUNET_PQ_result_spec_bool ("no_account",
87 : &no_account),
88 : GNUNET_PQ_result_spec_end
89 : };
90 : enum GNUNET_DB_QueryStatus qs;
91 :
92 39 : GNUNET_assert (NULL != pg->current_merchant_id);
93 39 : GNUNET_assert (0 == strcmp (merchant_id,
94 : pg->current_merchant_id));
95 39 : TMH_PQ_prepare_anon (pg,
96 : "SELECT "
97 : " out_no_account AS no_account"
98 : " FROM merchant_do_account_kyc_set_status"
99 : "($1, $2, $3, $4, $5, $6, $7::TEXT::JSONB"
100 : ",$8, $9, $10, $11, $12, $13, $14);");
101 39 : qs = GNUNET_PQ_eval_prepared_singleton_select (
102 : pg->conn,
103 : "",
104 : params,
105 : rs);
106 39 : GNUNET_free (notify_s);
107 39 : GNUNET_free (notify2_s);
108 39 : if (qs <= 0)
109 : {
110 0 : GNUNET_break (GNUNET_DB_STATUS_SOFT_ERROR != qs);
111 0 : GNUNET_break (GNUNET_DB_STATUS_HARD_ERROR != qs);
112 0 : GNUNET_break (GNUNET_DB_STATUS_SUCCESS_NO_RESULTS != qs);
113 0 : return qs;
114 : }
115 39 : GNUNET_break (! no_account);
116 39 : return qs;
117 : }
|