exchange

commit aa35163a1efa8fcfcfcb988e7a87e47093c98c23
parent a6a25936f3df04f5690426b3c7ed5363bd7a558a
Author: Christian Grothoff <christian@grothoff.org>
Date:   Sun,  5 Jan 2025 23:10:51 +0100

implement select_all_kyc_attributes

Diffstat:
M
src/exchangedb/pg_select_all_kyc_attributes.c
 | 
135
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++--

1 file changed, 133 insertions(+), 2 deletions(-)
diff --git a/src/exchangedb/pg_select_all_kyc_attributes.c b/src/exchangedb/pg_select_all_kyc_attributes.c
@@ -25,6 +25,100 @@
 #include "pg_select_all_kyc_attributes.h"
 #include "pg_helper.h"
 
+/**
+ * Closure for #get_all_attributes_cb().
+ */
+struct GetAttributesContext
+{
+  /**
+   * Function to call per result.
+   */
+  TALER_EXCHANGEDB_AllAttributesCallback cb;
+
+  /**
+   * Closure for @e cb.
+   */
+  void *cb_cls;
+
+  /**
+   * Plugin context.
+   */
+  struct PostgresClosure *pg;
+
+  /**
+   * Flag set to #GNUNET_OK as long as everything is fine.
+   */
+  enum GNUNET_GenericReturnValue status;
+
+};
+
+/**
+ * Invoke the callback for each result.
+ *
+ * @param cls a `struct GetAttributesContext *`
+ * @param result SQL result
+ * @param num_results number of rows in @a result
+ */
+static void
+get_attributes_cb (void *cls,
+                   PGresult *result,
+                   unsigned int num_results)
+{
+  struct GetAttributesContext *ctx = cls;
+
+  for (unsigned int i = 0; i < num_results; i++)
+  {
+    uint64_t rowid;
+    struct GNUNET_TIME_Timestamp collection_time;
+    struct GNUNET_TIME_Timestamp expiration_time;
+    struct TALER_NormalizedPaytoHashP h_payto;
+    json_t *properties = NULL;
+    size_t enc_attributes_size;
+    void *enc_attributes;
+    char *provider;
+    struct GNUNET_PQ_ResultSpec rs[] = {
+      GNUNET_PQ_result_spec_string ("provider_name",
+                                    &provider),
+      GNUNET_PQ_result_spec_uint64 ("kyc_attributes_serial_id",
+                                    &rowid),
+      GNUNET_PQ_result_spec_allow_null (
+        TALER_PQ_result_spec_json ("jproperties",
+                                   &properties),
+        NULL),
+      GNUNET_PQ_result_spec_timestamp ("collection_time",
+                                       &collection_time),
+      GNUNET_PQ_result_spec_timestamp ("expiration_time",
+                                       &expiration_time),
+      GNUNET_PQ_result_spec_auto_from_type ("h_payto",
+                                            &h_payto),
+      GNUNET_PQ_result_spec_variable_size ("encrypted_attributes",
+                                           &enc_attributes,
+                                           &enc_attributes_size),
+      GNUNET_PQ_result_spec_end
+    };
+
+    if (GNUNET_OK !=
+        GNUNET_PQ_extract_result (result,
+                                  rs,
+                                  i))
+    {
+      GNUNET_break (0);
+      ctx->status = GNUNET_SYSERR;
+      return;
+    }
+    ctx->cb (ctx->cb_cls,
+             rowid,
+             &h_payto,
+             provider,
+             collection_time,
+             expiration_time,
+             properties,
+             enc_attributes_size,
+             enc_attributes);
+    GNUNET_PQ_cleanup_result (rs);
+  }
+}
+
 
 enum GNUNET_DB_QueryStatus
 TEH_PG_select_all_kyc_attributes (
@@ -32,6 +126,43 @@ TEH_PG_select_all_kyc_attributes (
   TALER_EXCHANGEDB_AllAttributesCallback cb,
   void *cb_cls)
 {
-  GNUNET_break (0); // FIXME-#9053: not implemented
-  return -2;
+  struct PostgresClosure *pg = cls;
+  struct GNUNET_PQ_QueryParam params[] = {
+    GNUNET_PQ_query_param_end
+  };
+  struct GetAttributesContext ctx = {
+    .cb = cb,
+    .cb_cls = cb_cls,
+    .pg = pg,
+    .status = GNUNET_OK
+  };
+  enum GNUNET_DB_QueryStatus qs;
+
+  PREPARE (pg,
+           "select_all_kyc_attributes",
+           "SELECT "
+           " lp.provider_name"
+           ",ka.h_payto"
+           ",ka.kyc_attributes_serial_id"
+           ",lo.jproperties"
+           ",ka.collection_time"
+           ",ka.expiration_time"
+           ",ka.encrypted_attributes"
+           " FROM kyc_attributes ka"
+           " JOIN legitimization_processes lp"
+           "   ON (ka.legitimization_serial = lp.legitimization_process_serial_id)"
+           " LEFT JOIN legitimization_outcomes lo"
+           "   ON (ka.h_payto = lo.h_payto)"
+           /* **IF** we joined with 'lo', the lo must be active */
+           " WHERE COALESCE(lo.is_active,TRUE)"
+           );
+  qs = GNUNET_PQ_eval_prepared_multi_select (
+    pg->conn,
+    "select_all_kyc_attributes",
+    params,
+    &get_attributes_cb,
+    &ctx);
+  if (GNUNET_OK != ctx.status)
+    return GNUNET_DB_STATUS_HARD_ERROR;
+  return qs;
 }