pg_update_donau_instance_receipts_amount.c (2003B)
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 backenddb/pg_update_donau_instance_receipts_amount.c 18 * @brief Implementation of the update_donau_instance_receipts_amount 19 * function for Postgres 20 * @author Bohdan Potuzhnyi 21 * @author Vlada Svirsh 22 */ 23 #include "platform.h" 24 #include <taler/taler_error_codes.h> 25 #include <taler/taler_dbevents.h> 26 #include <taler/taler_pq_lib.h> 27 #include "pg_update_donau_instance_receipts_amount.h" 28 #include "pg_helper.h" 29 30 enum GNUNET_DB_QueryStatus 31 TMH_PG_update_donau_instance_receipts_amount ( 32 void *cls, 33 uint64_t *donau_instances_serial, 34 const struct TALER_Amount *new_amount) 35 { 36 struct PostgresClosure *pg = cls; 37 struct GNUNET_PQ_QueryParam params[] = { 38 GNUNET_PQ_query_param_uint64 (donau_instances_serial), 39 TALER_PQ_query_param_amount_with_currency (pg->conn, 40 new_amount), 41 GNUNET_PQ_query_param_end 42 }; 43 44 check_connection (pg); 45 46 PREPARE (pg, 47 "update_donau_instance_receipts", 48 "UPDATE merchant_donau_instances " 49 "SET charity_receipts_to_date = $2 " 50 "WHERE donau_instances_serial = $1;"); 51 52 return GNUNET_PQ_eval_prepared_non_select (pg->conn, 53 "update_donau_instance_receipts", 54 params); 55 }