merchant

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

pg_check_report.c (2355B)

      1 /*
      2    This file is part of TALER
      3    Copyright (C) 2025 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_check_report.c
     18  * @brief Implementation of the check_report 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_check_report.h"
     26 #include "pg_helper.h"
     27 
     28 enum GNUNET_DB_QueryStatus
     29 TMH_PG_check_report (void *cls,
     30                      uint64_t report_id,
     31                      const struct TALER_MERCHANT_ReportToken *report_token,
     32                      const char *mime_type,
     33                      char **instance_id,
     34                      char **data_source)
     35 {
     36   struct PostgresClosure *pg = cls;
     37   struct GNUNET_PQ_QueryParam params[] = {
     38     GNUNET_PQ_query_param_uint64 (&report_id),
     39     GNUNET_PQ_query_param_auto_from_type (report_token),
     40     GNUNET_PQ_query_param_string (mime_type),
     41     GNUNET_PQ_query_param_end
     42   };
     43   struct GNUNET_PQ_ResultSpec rs[] = {
     44     GNUNET_PQ_result_spec_string ("merchant_id",
     45                                   instance_id),
     46     GNUNET_PQ_result_spec_string ("data_source",
     47                                   data_source),
     48     GNUNET_PQ_result_spec_end
     49   };
     50 
     51   check_connection (pg);
     52   PREPARE (pg,
     53            "check_report",
     54            "SELECT"
     55            "  mi.merchant_id"
     56            " ,mr.data_source"
     57            " FROM merchant_reports mr"
     58            " JOIN merchant_instances mi"
     59            "   USING (merchant_serial)"
     60            " WHERE mr.report_serial=$1"
     61            "   AND mr.report_token=$2"
     62            "   AND mr.mime_type=$3;");
     63   return GNUNET_PQ_eval_prepared_singleton_select (
     64     pg->conn,
     65     "check_report",
     66     params,
     67     rs);
     68 }