insert_product.c (4758B)
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/insert_product.c 18 * @brief Implementation of the insert_product function for Postgres 19 * @author Christian Grothoff 20 * @author Iván Ávalos 21 */ 22 #include "platform.h" 23 #include <taler/taler_error_codes.h> 24 #include <taler/taler_dbevents.h> 25 #include <taler/taler_pq_lib.h> 26 #include "merchant-database/insert_product.h" 27 #include "helper.h" 28 29 30 enum GNUNET_DB_QueryStatus 31 TALER_MERCHANTDB_insert_product (struct TALER_MERCHANTDB_PostgresContext *pg, 32 const char *instance_id, 33 const char *product_id, 34 const struct TALER_MERCHANTDB_ProductDetails *pd, 35 size_t num_cats, 36 const uint64_t *cats, 37 bool *no_instance, 38 bool *conflict, 39 ssize_t *no_cat, 40 bool *no_group, 41 bool *no_pot) 42 { 43 struct GNUNET_PQ_QueryParam params[] = { 44 GNUNET_PQ_query_param_string (instance_id), 45 GNUNET_PQ_query_param_string (product_id), 46 GNUNET_PQ_query_param_string (pd->description), 47 TALER_PQ_query_param_json (pd->description_i18n), /* $4 */ 48 GNUNET_PQ_query_param_string (pd->unit), 49 GNUNET_PQ_query_param_string (pd->image), 50 TALER_PQ_query_param_json (pd->taxes), /* $7 */ 51 TALER_PQ_query_param_array_amount_with_currency ( 52 pd->price_array_length, 53 pd->price_array, 54 pg->conn), /* $8 */ 55 GNUNET_PQ_query_param_uint64 (&pd->total_stock), /* $9 */ 56 GNUNET_PQ_query_param_uint32 (&pd->total_stock_frac), /* $10 */ 57 GNUNET_PQ_query_param_bool (pd->allow_fractional_quantity), 58 GNUNET_PQ_query_param_uint32 (&pd->fractional_precision_level), 59 TALER_PQ_query_param_json (pd->address), /* $13 */ 60 GNUNET_PQ_query_param_timestamp (&pd->next_restock), 61 GNUNET_PQ_query_param_uint32 (&pd->minimum_age), 62 GNUNET_PQ_query_param_array_uint64 (num_cats, 63 cats, 64 pg->conn), /* $16 */ 65 GNUNET_PQ_query_param_string (pd->product_name), 66 (0 == pd->product_group_id) 67 ? GNUNET_PQ_query_param_null () 68 : GNUNET_PQ_query_param_uint64 (&pd->product_group_id), /* $18 */ 69 (0 == pd->money_pot_id) 70 ? GNUNET_PQ_query_param_null () 71 : GNUNET_PQ_query_param_uint64 (&pd->money_pot_id), /* $19 */ 72 GNUNET_PQ_query_param_bool (pd->price_is_net), /* $20 */ 73 GNUNET_PQ_query_param_end 74 }; 75 uint64_t ncat; 76 bool cats_found = true; 77 struct GNUNET_PQ_ResultSpec rs[] = { 78 GNUNET_PQ_result_spec_bool ("conflict", 79 conflict), 80 GNUNET_PQ_result_spec_bool ("no_instance", 81 no_instance), 82 GNUNET_PQ_result_spec_allow_null ( 83 GNUNET_PQ_result_spec_uint64 ("no_cat", 84 &ncat), 85 &cats_found), 86 GNUNET_PQ_result_spec_bool ("no_group", 87 no_group), 88 GNUNET_PQ_result_spec_bool ("no_pot", 89 no_pot), 90 GNUNET_PQ_result_spec_end 91 }; 92 enum GNUNET_DB_QueryStatus qs; 93 94 check_connection (pg); 95 PREPARE (pg, 96 "insert_product", 97 "SELECT" 98 " out_conflict AS conflict" 99 ",out_no_instance AS no_instance" 100 ",out_no_cat AS no_cat" 101 ",out_no_group AS no_group" 102 ",out_no_pot AS no_pot" 103 " FROM merchant_do_insert_product" 104 "($1, $2, $3, $4::TEXT::JSONB, $5, $6, $7::TEXT::JSONB, $8" 105 ",$9, $10, $11, $12, $13::TEXT::JSONB, $14, $15, $16" 106 ",$17, $18, $19, $20);"); 107 qs = GNUNET_PQ_eval_prepared_singleton_select (pg->conn, 108 "insert_product", 109 params, 110 rs); 111 GNUNET_PQ_cleanup_query_params_closures (params); 112 *no_cat = (cats_found) ? -1 : (ssize_t) ncat; 113 return qs; 114 }