merchant

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

insert_report.c (3681B)

      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 src/backenddb/insert_report.c
     18  * @brief Implementation of the insert_report function for Postgres
     19  * @author Christian Grothoff
     20  */
     21 #include "platform.h"
     22 #include <taler/taler_error_codes.h>
     23 #include <taler/taler_dbevents.h>
     24 #include <taler/taler_pq_lib.h>
     25 #include "taler/taler_merchant_util.h"
     26 #include "merchant-database/insert_report.h"
     27 #include "helper.h"
     28 
     29 
     30 enum GNUNET_DB_QueryStatus
     31 TALER_MERCHANTDB_insert_report (
     32   struct TALER_MERCHANTDB_PostgresContext *pg,
     33   const char *instance_id,
     34   const char *report_program_section,
     35   const char *report_description,
     36   const char *mime_type,
     37   const char *data_source,
     38   const char *target_address,
     39   struct GNUNET_TIME_Relative frequency,
     40   struct GNUNET_TIME_Relative frequency_shift,
     41   uint64_t *report_id)
     42 {
     43   struct TALER_MERCHANT_ReportToken report_token;
     44   struct GNUNET_TIME_Timestamp start;
     45   struct GNUNET_PQ_QueryParam params[] = {
     46     GNUNET_PQ_query_param_string (report_program_section),
     47     GNUNET_PQ_query_param_string (report_description),
     48     GNUNET_PQ_query_param_string (mime_type),
     49     GNUNET_PQ_query_param_auto_from_type (&report_token),
     50     GNUNET_PQ_query_param_string (data_source),
     51     GNUNET_PQ_query_param_string (target_address),
     52     GNUNET_PQ_query_param_relative_time (&frequency),
     53     GNUNET_PQ_query_param_relative_time (&frequency_shift),
     54     GNUNET_PQ_query_param_timestamp (&start),
     55     GNUNET_PQ_query_param_end
     56   };
     57   struct GNUNET_PQ_ResultSpec rs[] = {
     58     GNUNET_PQ_result_spec_uint64 ("report_serial",
     59                                   report_id),
     60     GNUNET_PQ_result_spec_end
     61   };
     62 
     63   GNUNET_assert (NULL != pg->current_merchant_id);
     64   GNUNET_assert (0 == strcmp (instance_id,
     65                               pg->current_merchant_id));
     66   GNUNET_CRYPTO_random_block (&report_token,
     67                               sizeof (report_token));
     68   start =
     69     GNUNET_TIME_absolute_to_timestamp (
     70       GNUNET_TIME_absolute_add (
     71         GNUNET_TIME_absolute_round_down (GNUNET_TIME_absolute_get (),
     72                                          frequency),
     73         GNUNET_TIME_relative_add (frequency,
     74                                   frequency_shift)));
     75 
     76   TMH_PQ_prepare_anon (pg,
     77                        "INSERT INTO merchant_reports"
     78                        "(report_program_section"
     79                        ",report_description"
     80                        ",mime_type"
     81                        ",report_token"
     82                        ",data_source"
     83                        ",target_address"
     84                        ",frequency"
     85                        ",frequency_shift"
     86                        ",next_transmission)"
     87                        " VALUES ($1, $2, $3, $4,"
     88                        "   $5, $6, $7, $8, $9)"
     89                        " ON CONFLICT DO NOTHING;");
     90   return GNUNET_PQ_eval_prepared_singleton_select (pg->conn,
     91                                                    "",
     92                                                    params,
     93                                                    rs);
     94 }