/* This file is part of TALER Copyright (C) 2022 Taler Systems SA TALER is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 3, or (at your option) any later version. TALER is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with TALER; see the file COPYING. If not, see */ /** * @file backenddb/pg_update_contract_terms.c * @brief Implementation of the update_contract_terms function for Postgres * @author Iván Ávalos */ #include "platform.h" #include #include #include #include "pg_update_contract_terms.h" #include "pg_helper.h" enum GNUNET_DB_QueryStatus TMH_PG_update_contract_terms (void *cls, const char *instance_id, const char *order_id, json_t *contract_terms) { struct PostgresClosure *pg = cls; struct GNUNET_TIME_Timestamp pay_deadline; struct GNUNET_TIME_Timestamp refund_deadline; const char *fulfillment_url = NULL; struct TALER_PrivateContractHashP h_contract_terms; if (GNUNET_OK != TALER_JSON_contract_hash (contract_terms, &h_contract_terms)) { GNUNET_break (0); return GNUNET_DB_STATUS_HARD_ERROR; } { struct GNUNET_JSON_Specification spec[] = { GNUNET_JSON_spec_timestamp ("pay_deadline", &pay_deadline), GNUNET_JSON_spec_timestamp ("refund_deadline", &refund_deadline), GNUNET_JSON_spec_mark_optional ( GNUNET_JSON_spec_string ("fulfillment_url", &fulfillment_url), NULL), GNUNET_JSON_spec_end () }; enum GNUNET_GenericReturnValue res; res = TALER_MHD_parse_json_data (NULL, contract_terms, spec); if (GNUNET_OK != res) { GNUNET_break (0); return GNUNET_DB_STATUS_HARD_ERROR; } } check_connection (pg); { struct GNUNET_PQ_QueryParam params[] = { GNUNET_PQ_query_param_string (instance_id), GNUNET_PQ_query_param_string (order_id), TALER_PQ_query_param_json (contract_terms), GNUNET_PQ_query_param_auto_from_type (&h_contract_terms), GNUNET_PQ_query_param_timestamp (&pay_deadline), GNUNET_PQ_query_param_timestamp (&refund_deadline), (NULL == fulfillment_url) ? GNUNET_PQ_query_param_null () : GNUNET_PQ_query_param_string (fulfillment_url), GNUNET_PQ_query_param_end }; PREPARE (pg, "update_contract_terms", "UPDATE merchant_contract_terms SET" " contract_terms=$3" ",h_contract_terms=$4" ",pay_deadline=$5" ",refund_deadline=$6" ",fulfillment_url=$7" " WHERE order_id=$2" " AND merchant_serial=" " (SELECT merchant_serial" " FROM merchant_instances" " WHERE merchant_id=$1)"); return GNUNET_PQ_eval_prepared_non_select (pg->conn, "update_contract_terms", params); } }