get_recdoc_payment.c (3355B)
1 /* 2 This file is part of Anastasis 3 Copyright (C) 2020-2022 Anastasis SARL 4 5 Anastasis is free software; you can redistribute it and/or modify it under the 6 terms of the GNU Affero General Public License as published by the Free Software 7 Foundation; either version 3, or (at your option) any later version. 8 9 Anastasis 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 Affero General Public License for more details. 12 13 You should have received a copy of the GNU Affero General Public License along with 14 Anastasis; see the file COPYING.GPL. If not, see <http://www.gnu.org/licenses/> 15 */ 16 /** 17 * @file stasis/get_recdoc_payment.c 18 * @brief Anastasis database: get recdoc payment 19 * @author Christian Grothoff 20 */ 21 #include "platform.h" 22 #include "anastasis-db_pg.h" 23 #include "anastasis/anastasis-database/get_recdoc_payment.h" 24 #include "anastasis/anastasis-database/transaction.h" 25 #include "anastasis/anastasis-database/preflight.h" 26 #include <taler/taler_pq_lib.h> 27 28 29 /** 30 * Check payment identifier. Used to check if a payment identifier given by 31 * the user is valid (existing and paid). 32 * 33 * @param account_pub account the payment must belong to 34 * @param payment_secret payment secret which the user must provide with every upload 35 * @param[out] paid bool value to show if payment is paid 36 * @param[out] valid_counter bool value to show if post_counter is > 0 37 * @param[out] creation_date when was the payment record created 38 * @return transaction status 39 */ 40 enum GNUNET_DB_QueryStatus 41 ANASTASIS_DB_get_recdoc_payment ( 42 const struct ANASTASIS_CRYPTO_AccountPublicKeyP *account_pub, 43 const struct ANASTASIS_PaymentSecretP *payment_secret, 44 bool *paid, 45 bool *valid_counter, 46 struct GNUNET_TIME_Timestamp *creation_date) 47 { 48 struct GNUNET_PQ_QueryParam params[] = { 49 GNUNET_PQ_query_param_auto_from_type (account_pub), 50 GNUNET_PQ_query_param_auto_from_type (payment_secret), 51 GNUNET_PQ_query_param_end 52 }; 53 struct GNUNET_PQ_ResultSpec rs[] = { 54 GNUNET_PQ_result_spec_bool ("paid", 55 paid), 56 GNUNET_PQ_result_spec_bool ("valid_counter", 57 valid_counter), 58 GNUNET_PQ_result_spec_timestamp ("creation_date", 59 creation_date), 60 GNUNET_PQ_result_spec_end 61 }; 62 63 *creation_date = GNUNET_TIME_UNIT_ZERO_TS; 64 /* The payment identifier is chosen by the client, so it is only meaningful 65 together with the account it was issued for: without the user_id an 66 identifier belonging to one account would be accepted as credit for 67 another, and a lookup would answer with a row that the caller then goes 68 on to treat as its own. */ 69 PREPARE ("get_recdoc_payment", 70 "SELECT" 71 " creation_date" 72 ",post_counter > 0 AS valid_counter" 73 ",paid" 74 " FROM anastasis_recdoc_payment" 75 " WHERE user_id=$1" 76 " AND payment_identifier=$2;"); 77 return GNUNET_PQ_eval_prepared_singleton_select (pg->conn, 78 "get_recdoc_payment", 79 params, 80 rs); 81 } 82 83 84 /* end of get_recdoc_payment.c */