Line data Source code
1 : /*
2 : This file is part of TALER
3 : Copyright (C) 2022 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_insert_template.c
18 : * @brief Implementation of the insert_template 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_insert_template.h"
26 : #include "pg_helper.h"
27 :
28 :
29 : enum GNUNET_DB_QueryStatus
30 12 : TMH_PG_insert_template (void *cls,
31 : const char *instance_id,
32 : const char *template_id,
33 : uint64_t otp_serial_id,
34 : const struct TALER_MERCHANTDB_TemplateDetails *td)
35 : {
36 12 : struct PostgresClosure *pg = cls;
37 12 : struct GNUNET_PQ_QueryParam params[] = {
38 12 : GNUNET_PQ_query_param_string (instance_id),
39 12 : GNUNET_PQ_query_param_string (template_id),
40 12 : GNUNET_PQ_query_param_string (td->template_description),
41 12 : (0 == otp_serial_id)
42 10 : ? GNUNET_PQ_query_param_null ()
43 12 : : GNUNET_PQ_query_param_uint64 (&otp_serial_id),
44 12 : TALER_PQ_query_param_json (td->template_contract),
45 12 : (NULL == td->editable_defaults)
46 12 : ? GNUNET_PQ_query_param_null ()
47 12 : : TALER_PQ_query_param_json (td->editable_defaults),
48 : GNUNET_PQ_query_param_end
49 : };
50 :
51 12 : check_connection (pg);
52 12 : PREPARE (pg,
53 : "insert_template",
54 : "INSERT INTO merchant_template"
55 : "(merchant_serial"
56 : ",template_id"
57 : ",template_description"
58 : ",otp_device_id"
59 : ",template_contract"
60 : ",editable_defaults"
61 : ")"
62 : " SELECT merchant_serial,"
63 : " $2, $3, $4, $5::TEXT::JSONB, $6::TEXT::JSONB"
64 : " FROM merchant_instances"
65 : " WHERE merchant_id=$1");
66 12 : return GNUNET_PQ_eval_prepared_non_select (pg->conn,
67 : "insert_template",
68 : params);
69 : }
|