insert_denominations_without_sigs.c (2319B)
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 #include "taler/taler_pq_lib.h" 17 #include "pg_helper.h" 18 #include "auditor-database/insert_denominations_without_sigs.h" 19 20 21 enum GNUNET_DB_QueryStatus 22 TALER_AUDITORDB_insert_denominations_without_sigs (struct 23 TALER_AUDITORDB_PostgresContext 24 * 25 ctx, 26 const struct 27 TALER_AUDITORDB_DenominationsWithoutSigs 28 *dc) 29 { 30 struct GNUNET_PQ_QueryParam params[] = { 31 GNUNET_PQ_query_param_auto_from_type (&dc->denompub_h), 32 TALER_PQ_query_param_amount (ctx->conn, &dc->value), 33 GNUNET_PQ_query_param_absolute_time (&dc->start_time), 34 GNUNET_PQ_query_param_absolute_time (&dc->end_time), 35 GNUNET_PQ_query_param_end 36 }; 37 38 PREPARE (ctx, 39 "auditor_denominations_without_sigs_insert", 40 "INSERT INTO auditor_denominations_without_sigs " 41 "(denompub_h," 42 " value," 43 " start_time," 44 " end_time" 45 ") VALUES ($1,$2,$3,$4)" 46 " ON CONFLICT (denompub_h) DO UPDATE" 47 " SET value = excluded.value," 48 " start_time = excluded.start_time," 49 " end_time = excluded.end_time," 50 " suppressed = false" 51 ); 52 return GNUNET_PQ_eval_prepared_non_select (ctx->conn, 53 "auditor_denominations_without_sigs_insert", 54 params); 55 }