lookup_product.c (8196B)
1 /* 2 This file is part of TALER 3 Copyright (C) 2022, 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/lookup_product.c 18 * @brief Implementation of the lookup_product function for Postgres 19 * @author Iván Ávalos 20 */ 21 #include "platform.h" 22 #include <taler/taler_pq_lib.h> 23 #include "merchant-database/lookup_product.h" 24 #include "helper.h" 25 26 27 enum GNUNET_DB_QueryStatus 28 TALER_MERCHANTDB_lookup_product ( 29 struct TALER_MERCHANTDB_PostgresContext *pg, 30 const char *instance_id, 31 const char *product_id, 32 struct TALER_MERCHANTDB_ProductDetails *pd, 33 size_t *num_categories, 34 uint64_t **categories) 35 { 36 struct GNUNET_PQ_QueryParam params[] = { 37 GNUNET_PQ_query_param_string (product_id), 38 GNUNET_PQ_query_param_end 39 }; 40 41 GNUNET_assert (NULL != pg->current_merchant_id); 42 GNUNET_assert (0 == strcmp (instance_id, 43 pg->current_merchant_id)); 44 TMH_PQ_prepare_anon (pg, 45 "SELECT" 46 " mi.description" 47 ",mi.description_i18n::TEXT" 48 ",mi.product_name" 49 ",mi.unit" 50 ",mi.price_array" 51 ",mi.taxes::TEXT" 52 ",mi.total_stock" 53 ",mi.total_stock_frac" 54 ",mi.allow_fractional_quantity" 55 ",mi.fractional_precision_level" 56 ",mi.total_sold" 57 ",mi.total_sold_frac" 58 ",mi.total_lost" 59 ",mi.total_lost_frac" 60 ",mi.total_locked" 61 ",mi.total_locked_frac" 62 ",mi.image" 63 ",mi.address::TEXT" 64 ",mi.next_restock" 65 ",mi.minimum_age" 66 ",mi.product_group_serial" 67 ",mi.money_pot_serial" 68 ",mi.price_is_net" 69 ",t.category_array AS categories" 70 " FROM merchant_inventory mi" 71 ",LATERAL (" 72 " SELECT ARRAY (" 73 " SELECT mpc.category_serial" 74 " FROM merchant_product_categories mpc" 75 " WHERE mpc.product_serial = mi.product_serial" 76 " ) AS category_array" 77 " ) t" 78 " WHERE mi.product_id=$1" 79 ); 80 if (NULL == pd) // FIXME: is this case needed? For now yes: delete-private-products-PRODUCT_ID uses it! 81 { 82 struct GNUNET_PQ_ResultSpec rs_null[] = { 83 GNUNET_PQ_result_spec_end 84 }; 85 86 check_connection (pg); 87 return GNUNET_PQ_eval_prepared_singleton_select (pg->conn, 88 "", 89 params, 90 rs_null); 91 } 92 else 93 { 94 char *my_name = NULL; 95 char *my_description = NULL; 96 json_t *my_description_i18n = NULL; 97 char *my_unit = NULL; 98 char *my_image = NULL; 99 json_t *my_address = NULL; 100 json_t *my_taxes = NULL; 101 uint64_t *my_categories = NULL; 102 struct TALER_Amount *my_price_array = NULL; 103 size_t my_price_array_length = 0; 104 struct GNUNET_PQ_ResultSpec rs[] = { 105 GNUNET_PQ_result_spec_string ("description", 106 &my_description), 107 TALER_PQ_result_spec_json ("description_i18n", 108 &my_description_i18n), 109 GNUNET_PQ_result_spec_string ("product_name", 110 &my_name), 111 GNUNET_PQ_result_spec_string ("unit", 112 &my_unit), 113 TALER_PQ_result_spec_array_amount_with_currency (pg->conn, 114 "merchant", 115 "price_array", 116 &my_price_array_length, 117 &my_price_array), 118 TALER_PQ_result_spec_json ("taxes", 119 &my_taxes), 120 GNUNET_PQ_result_spec_uint64 ("total_stock", 121 &pd->total_stock), 122 GNUNET_PQ_result_spec_uint32 ("total_stock_frac", 123 &pd->total_stock_frac), 124 GNUNET_PQ_result_spec_bool ("allow_fractional_quantity", 125 &pd->allow_fractional_quantity), 126 GNUNET_PQ_result_spec_uint32 ("fractional_precision_level", 127 &pd->fractional_precision_level), 128 GNUNET_PQ_result_spec_uint64 ("total_sold", 129 &pd->total_sold), 130 GNUNET_PQ_result_spec_uint32 ("total_sold_frac", 131 &pd->total_sold_frac), 132 GNUNET_PQ_result_spec_uint64 ("total_lost", 133 &pd->total_lost), 134 GNUNET_PQ_result_spec_uint32 ("total_lost_frac", 135 &pd->total_lost_frac), 136 GNUNET_PQ_result_spec_uint64 ("total_locked", 137 &pd->total_locked), 138 GNUNET_PQ_result_spec_uint32 ("total_locked_frac", 139 &pd->total_locked_frac), 140 GNUNET_PQ_result_spec_string ("image", 141 &my_image), 142 TALER_PQ_result_spec_json ("address", 143 &my_address), 144 GNUNET_PQ_result_spec_timestamp ("next_restock", 145 &pd->next_restock), 146 GNUNET_PQ_result_spec_uint32 ("minimum_age", 147 &pd->minimum_age), 148 GNUNET_PQ_result_spec_array_uint64 (pg->conn, 149 "categories", 150 num_categories, 151 &my_categories), 152 GNUNET_PQ_result_spec_allow_null ( 153 GNUNET_PQ_result_spec_uint64 ("product_group_serial", 154 &pd->product_group_id), 155 NULL), 156 GNUNET_PQ_result_spec_allow_null ( 157 GNUNET_PQ_result_spec_uint64 ("money_pot_serial", 158 &pd->money_pot_id), 159 NULL), 160 GNUNET_PQ_result_spec_bool ("price_is_net", 161 &pd->price_is_net), 162 GNUNET_PQ_result_spec_end 163 }; 164 enum GNUNET_DB_QueryStatus qs; 165 166 check_connection (pg); 167 pd->product_group_id = 0; 168 pd->money_pot_id = 0; 169 qs = GNUNET_PQ_eval_prepared_singleton_select (pg->conn, 170 "", 171 params, 172 rs); 173 pd->product_name = my_name; 174 pd->description = my_description; 175 pd->description_i18n = my_description_i18n; 176 pd->unit = my_unit; 177 pd->taxes = my_taxes; 178 pd->image = my_image; 179 pd->image_hash = NULL; 180 pd->address = my_address; 181 pd->price_array = my_price_array; 182 pd->price_array_length = my_price_array_length; 183 *categories = my_categories; 184 /* Clear original pointers to that cleanup_result doesn't squash them */ 185 my_name = NULL; 186 my_description = NULL; 187 my_description_i18n = NULL; 188 my_unit = NULL; 189 my_taxes = NULL; 190 my_image = NULL; 191 my_address = NULL; 192 my_price_array = NULL; 193 my_price_array_length = 0; 194 my_categories = NULL; 195 GNUNET_PQ_cleanup_result (rs); 196 return qs; 197 } 198 }