anastasis

Credential backup and recovery protocol and service
Log | Files | Refs | Submodules | README | LICENSE

anastasis-db_lookup_challenge_payment.c (2881B)

      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/anastasis-db_lookup_challenge_payment.c
     18  * @brief Anastasis database: lookup challenge payment
     19  * @author Christian Grothoff
     20  */
     21 #include "platform.h"
     22 #include "anastasis-db_pg.h"
     23 #include "anastasis/anastasis-database/lookup_challenge_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  * Lookup pending payment for a certain challenge.
     31  *
     32  * @param truth_uuid identification of the challenge
     33  * @param[out] payment_secret set to the challenge payment secret
     34  * @return transaction status
     35  */
     36 enum GNUNET_DB_QueryStatus
     37 ANASTASIS_DB_lookup_challenge_payment (
     38   const struct ANASTASIS_CRYPTO_TruthUUIDP *truth_uuid,
     39   struct ANASTASIS_PaymentSecretP *payment_secret)
     40 {
     41   struct GNUNET_TIME_Absolute now = GNUNET_TIME_absolute_get ();
     42   struct GNUNET_TIME_Timestamp recent
     43     = GNUNET_TIME_absolute_to_timestamp (
     44         GNUNET_TIME_absolute_subtract (now,
     45                                        ANASTASIS_CHALLENGE_OFFER_LIFETIME));
     46   struct GNUNET_PQ_QueryParam params[] = {
     47     GNUNET_PQ_query_param_auto_from_type (truth_uuid),
     48     GNUNET_PQ_query_param_timestamp (&recent),
     49     GNUNET_PQ_query_param_end
     50   };
     51   struct GNUNET_PQ_ResultSpec rs[] = {
     52     GNUNET_PQ_result_spec_auto_from_type ("payment_identifier",
     53                                           payment_secret),
     54     GNUNET_PQ_result_spec_end
     55   };
     56 
     57   PREPARE ("challenge_pending_payment_select",
     58            "SELECT"
     59            " creation_date"
     60            ",payment_identifier"
     61            ",amount"
     62            " FROM anastasis_challenge_payment"
     63            " WHERE"
     64            "  paid=FALSE"
     65            " AND"
     66            "  refunded=FALSE"
     67            " AND"
     68            "  truth_uuid=$1"
     69            " AND"
     70            "  creation_date > $2;");
     71   return GNUNET_PQ_eval_prepared_singleton_select (pg->conn,
     72                                                    "challenge_pending_payment_select",
     73                                                    params,
     74                                                    rs);
     75 }
     76 
     77 
     78 /* end of anastasis-db_lookup_challenge_payment.c */