diff options
author | Christian Grothoff <christian@grothoff.org> | 2023-11-12 14:18:06 +0100 |
---|---|---|
committer | Christian Grothoff <christian@grothoff.org> | 2023-11-12 14:18:06 +0100 |
commit | ac8144bb553605ef310962d152cf4cad4338f51f (patch) | |
tree | 32140966210d4ac59d15f18fb83fce3ac790258e /src/exchangedb/pg_get_pending_kyc_requirement_process.c | |
parent | efb7a46b786807994a66040f2d9c831e790b92a1 (diff) | |
download | exchange-ac8144bb553605ef310962d152cf4cad4338f51f.tar.gz exchange-ac8144bb553605ef310962d152cf4cad4338f51f.tar.bz2 exchange-ac8144bb553605ef310962d152cf4cad4338f51f.zip |
keep redirect_url in KYC table to improve idempotency of GET
Diffstat (limited to 'src/exchangedb/pg_get_pending_kyc_requirement_process.c')
-rw-r--r-- | src/exchangedb/pg_get_pending_kyc_requirement_process.c | 63 |
1 files changed, 63 insertions, 0 deletions
diff --git a/src/exchangedb/pg_get_pending_kyc_requirement_process.c b/src/exchangedb/pg_get_pending_kyc_requirement_process.c new file mode 100644 index 000000000..2a5808ff3 --- /dev/null +++ b/src/exchangedb/pg_get_pending_kyc_requirement_process.c @@ -0,0 +1,63 @@ +/* + This file is part of TALER + Copyright (C) 2023 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 <http://www.gnu.org/licenses/> + */ +/** + * @file exchangedb/pg_get_pending_kyc_requirement_process.c + * @brief Implementation of the get_pending_kyc_requirement_process function for Postgres + * @author Christian Grothoff + */ +#include "platform.h" +#include "taler_error_codes.h" +#include "taler_dbevents.h" +#include "taler_pq_lib.h" +#include "pg_get_pending_kyc_requirement_process.h" +#include "pg_helper.h" + + +enum GNUNET_DB_QueryStatus +TEH_PG_get_pending_kyc_requirement_process ( + void *cls, + const struct TALER_PaytoHashP *h_payto, + const char *provider_section, + char **redirect_url) +{ + struct PostgresClosure *pg = cls; + struct GNUNET_PQ_QueryParam params[] = { + GNUNET_PQ_query_param_string (provider_section), + GNUNET_PQ_query_param_auto_from_type (h_payto), + GNUNET_PQ_query_param_end + }; + struct GNUNET_PQ_ResultSpec rs[] = { + GNUNET_PQ_result_spec_string ("redirect_url", + redirect_url), + GNUNET_PQ_result_spec_end + }; + + PREPARE (pg, + "get_pending_kyc_requirement_process", + "SELECT" + " redirect_url" + " FROM legitimization_processes" + " WHERE provider_section=$1" + " AND h_payto=$2" + " AND NOT finished" + " ORDER BY start_time DESC" + " LIMIT 1"); + return GNUNET_PQ_eval_prepared_singleton_select ( + pg->conn, + "get_pending_kyc_requirement_process", + params, + rs); +} |