Line data    Source code

       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_lookup_product_image.c
      18              :  * @brief Implementation of the lookup_product_image_by_hash function for Postgres
      19              :  * @author Bohdan Potuzhnyi
      20              :  */
      21              : #include "platform.h"
      22              : #include <taler/taler_error_codes.h>
      23              : #include <taler/taler_pq_lib.h>
      24              : #include "pg_lookup_product_image.h"
      25              : 
      26              : 
      27              : enum GNUNET_DB_QueryStatus
      28            4 : TMH_PG_lookup_product_image_by_hash (void *cls,
      29              :                                      const char *instance_id,
      30              :                                      const char *image_hash,
      31              :                                      char **image)
      32              : {
      33            4 :   struct PostgresClosure *pg = cls;
      34            4 :   struct GNUNET_PQ_QueryParam params[] = {
      35            4 :     GNUNET_PQ_query_param_string (instance_id),
      36            4 :     GNUNET_PQ_query_param_string (image_hash),
      37              :     GNUNET_PQ_query_param_end
      38              :   };
      39              : 
      40            4 :   check_connection (pg);
      41            4 :   PREPARE (
      42              :     pg,
      43              :     "lookup_product_image_by_hash",
      44              :     "SELECT"
      45              :     "  mi.image"
      46              :     " FROM merchant_inventory mi"
      47              :     " JOIN merchant_instances inst"
      48              :     "   USING (merchant_serial)"
      49              :     " WHERE inst.merchant_id=$1"
      50              :     "   AND mi.image_hash=$2");
      51              : 
      52            4 :   *image = NULL;
      53              :   {
      54            4 :     struct GNUNET_PQ_ResultSpec rs[] = {
      55            4 :       GNUNET_PQ_result_spec_string ("image",
      56              :                                     image),
      57              :       GNUNET_PQ_result_spec_end
      58              :     };
      59              : 
      60            4 :     return GNUNET_PQ_eval_prepared_singleton_select (
      61              :       pg->conn,
      62              :       "lookup_product_image_by_hash",
      63              :       params,
      64              :       rs);
      65              :   }
      66              : }