merchant

Merchant backend to process payments, run by merchants
Log | Files | Refs | Submodules | README | LICENSE

pg_account_kyc_set_status.c (4309B)

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