Line data Source code
1 : /*
2 : This file is part of TALER
3 : Copyright (C) 2023 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_account.c
18 : * @brief Implementation of the update_account function for Postgres
19 : * @author Christian Grothoff
20 : */
21 : #include "platform.h"
22 : #include <taler/taler_error_codes.h>
23 : #include <taler/taler_dbevents.h>
24 : #include <taler/taler_pq_lib.h>
25 : #include "pg_update_account.h"
26 : #include "pg_helper.h"
27 :
28 :
29 : enum GNUNET_DB_QueryStatus
30 0 : TMH_PG_update_account (
31 : void *cls,
32 : const char *id,
33 : const struct TALER_MerchantWireHashP *h_wire,
34 : const char *credit_facade_url,
35 : const json_t *credit_facade_credentials)
36 : {
37 0 : struct PostgresClosure *pg = cls;
38 0 : struct GNUNET_PQ_QueryParam params[] = {
39 0 : GNUNET_PQ_query_param_string (id),
40 0 : GNUNET_PQ_query_param_auto_from_type (h_wire),
41 : NULL == credit_facade_url
42 0 : ? GNUNET_PQ_query_param_null ()
43 0 : : GNUNET_PQ_query_param_string (credit_facade_url),
44 : NULL == credit_facade_credentials
45 0 : ? GNUNET_PQ_query_param_null ()
46 0 : : TALER_PQ_query_param_json (credit_facade_credentials),
47 : GNUNET_PQ_query_param_end
48 : };
49 :
50 0 : check_connection (pg);
51 0 : PREPARE (pg,
52 : "update_account",
53 : "UPDATE merchant_accounts SET"
54 : " credit_facade_url=$3"
55 : ",credit_facade_credentials="
56 : " COALESCE($4::TEXT::JSONB, credit_facade_credentials)"
57 : " WHERE h_wire=$2"
58 : " AND merchant_serial="
59 : " (SELECT merchant_serial"
60 : " FROM merchant_instances"
61 : " WHERE merchant_id=$1);");
62 0 : return GNUNET_PQ_eval_prepared_non_select (pg->conn,
63 : "update_account",
64 : params);
65 : }
|