merchant

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

select_category.c (2954B)

      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_pq_lib.h>
     23 #include "merchant-database/select_category.h"
     24 #include "helper.h"
     25 
     26 
     27 enum GNUNET_DB_QueryStatus
     28 TALER_MERCHANTDB_select_category (
     29   struct TALER_MERCHANTDB_PostgresContext *pg,
     30   const char *instance_id,
     31   uint64_t category_id,
     32   struct TALER_MERCHANTDB_CategoryDetails *cd,
     33   size_t *num_products,
     34   char **products)
     35 {
     36   struct GNUNET_PQ_QueryParam params[] = {
     37     GNUNET_PQ_query_param_uint64 (&category_id),
     38     GNUNET_PQ_query_param_end
     39   };
     40   struct GNUNET_PQ_ResultSpec rs[] = {
     41     GNUNET_PQ_result_spec_string ("category_name",
     42                                   &cd->category_name),
     43     TALER_PQ_result_spec_json ("category_name_i18n",
     44                                &cd->category_name_i18n),
     45     GNUNET_PQ_result_spec_array_string (pg->conn,
     46                                         "products",
     47                                         num_products,
     48                                         products),
     49     GNUNET_PQ_result_spec_end
     50   };
     51 
     52   GNUNET_assert (NULL != pg->current_merchant_id);
     53   GNUNET_assert (0 == strcmp (instance_id,
     54                               pg->current_merchant_id));
     55   check_connection (pg);
     56   TMH_PQ_prepare_anon (pg,
     57                        "SELECT"
     58                        " category_name"
     59                        ",category_name_i18n::TEXT"
     60                        ",t.product_array AS products"
     61                        " FROM merchant_categories mc"
     62                        ",LATERAL ("
     63                        "   SELECT ARRAY ("
     64                        "     SELECT "
     65                        "         mi.product_id AS product_id"
     66                        "       FROM merchant_product_categories mpc"
     67                        "       JOIN merchant_inventory mi"
     68                        "          USING (product_serial)"
     69                        "      WHERE mpc.category_serial = mc.category_serial"
     70                        "   ) AS product_array"
     71                        " ) t"
     72                        " WHERE mc.category_serial=$1");
     73   return GNUNET_PQ_eval_prepared_singleton_select (
     74     pg->conn,
     75     "",
     76     params,
     77     rs);
     78 }