Line data Source code
1 : /*
2 : This file is part of TALER
3 : Copyright (C) 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/get_kyc_limits.c
18 : * @brief Implementation of the get_kyc_limits function for Postgres
19 : * @author Christian Grothoff
20 : */
21 : #include "platform.h"
22 : #include <taler/taler_pq_lib.h>
23 : #include "merchant-database/get_kyc_limits.h"
24 : #include "helper.h"
25 :
26 :
27 : enum GNUNET_DB_QueryStatus
28 4 : TALER_MERCHANTDB_get_kyc_limits (
29 : struct TALER_MERCHANTDB_PostgresContext *pg,
30 : struct TALER_FullPayto merchant_account_uri,
31 : const char *instance_id,
32 : const char *exchange_url,
33 : bool *kyc_ok,
34 : bool *no_access_token,
35 : json_t **jlimits)
36 : {
37 4 : struct GNUNET_PQ_QueryParam params[] = {
38 4 : GNUNET_PQ_query_param_string (merchant_account_uri.full_payto),
39 4 : GNUNET_PQ_query_param_string (exchange_url),
40 : GNUNET_PQ_query_param_end
41 : };
42 4 : struct GNUNET_PQ_ResultSpec rs[] = {
43 4 : GNUNET_PQ_result_spec_bool ("kyc_ok",
44 : kyc_ok),
45 4 : GNUNET_PQ_result_spec_bool ("no_access_token",
46 : no_access_token),
47 4 : GNUNET_PQ_result_spec_allow_null (
48 : TALER_PQ_result_spec_json ("jaccount_limits",
49 : jlimits),
50 : NULL),
51 : GNUNET_PQ_result_spec_end
52 : };
53 :
54 4 : GNUNET_assert (NULL != pg->current_merchant_id);
55 4 : GNUNET_assert (0 == strcmp (instance_id,
56 : pg->current_merchant_id));
57 4 : TMH_PQ_prepare_anon (pg,
58 : "SELECT"
59 : " mk.kyc_ok"
60 : ",mk.jaccount_limits::TEXT"
61 : ",mk.access_token IS NULL AS no_access_token"
62 : " FROM merchant_kyc mk"
63 : " WHERE mk.exchange_url=$2"
64 : " AND mk.account_serial="
65 : " (SELECT account_serial"
66 : " FROM merchant_accounts"
67 : " WHERE payto_uri=$1);");
68 4 : *jlimits = NULL;
69 4 : return GNUNET_PQ_eval_prepared_singleton_select (pg->conn,
70 : "",
71 : params,
72 : rs);
73 : }
|