merchant

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

select_category.c (3399B)

      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/select_category.c
     18  * @brief Implementation of the select_category 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 "merchant-database/select_category.h"
     26 #include "helper.h"
     27 
     28 
     29 enum GNUNET_DB_QueryStatus
     30 TALER_MERCHANTDB_select_category (struct TALER_MERCHANTDB_PostgresContext *pg,
     31                                   const char *instance_id,
     32                                   uint64_t category_id,
     33                                   struct TALER_MERCHANTDB_CategoryDetails *cd,
     34                                   size_t *num_products,
     35                                   char **products)
     36 {
     37   struct GNUNET_PQ_QueryParam params[] = {
     38     GNUNET_PQ_query_param_string (instance_id),
     39     GNUNET_PQ_query_param_uint64 (&category_id),
     40     GNUNET_PQ_query_param_end
     41   };
     42 
     43   if (NULL == cd)
     44   {
     45     struct GNUNET_PQ_ResultSpec rs_null[] = {
     46       GNUNET_PQ_result_spec_end
     47     };
     48 
     49     check_connection (pg);
     50     return GNUNET_PQ_eval_prepared_singleton_select (
     51       pg->conn,
     52       "select_category",
     53       params,
     54       rs_null);
     55   }
     56   else
     57   {
     58     struct GNUNET_PQ_ResultSpec rs[] = {
     59       GNUNET_PQ_result_spec_string ("category_name",
     60                                     &cd->category_name),
     61       TALER_PQ_result_spec_json ("category_name_i18n",
     62                                  &cd->category_name_i18n),
     63       GNUNET_PQ_result_spec_array_string (pg->conn,
     64                                           "products",
     65                                           num_products,
     66                                           products),
     67       GNUNET_PQ_result_spec_end
     68     };
     69 
     70     PREPARE (pg,
     71              "select_category",
     72              "SELECT"
     73              " category_name"
     74              ",category_name_i18n::TEXT"
     75              ",t.product_array AS products"
     76              " FROM merchant_categories mc"
     77              " JOIN merchant_instances inst"
     78              "   USING (merchant_serial)"
     79              ",LATERAL ("
     80              "   SELECT ARRAY ("
     81              "     SELECT "
     82              "         mi.product_id AS product_id"
     83              "       FROM merchant_product_categories mpc"
     84              "       JOIN merchant_inventory mi"
     85              "          USING (product_serial)"
     86              "      WHERE mpc.category_serial = mc.category_serial"
     87              "   ) AS product_array"
     88              " ) t"
     89              " WHERE inst.merchant_id=$1"
     90              "   AND mc.category_serial=$2");
     91     check_connection (pg);
     92     return GNUNET_PQ_eval_prepared_singleton_select (
     93       pg->conn,
     94       "select_category",
     95       params,
     96       rs);
     97   }
     98 }