exchange

commit 1cee47a91e972db32893fccf377cf0d85a43dd91
parent 8f864e5c1ac21f30276c93e3704e9d6bec87d1ef
Author: Florian Dold <florian@dold.me>
Date:   Tue,  6 May 2025 20:26:05 +0200

fix aml_measures query

Diffstat:
M
src/exchangedb/pg_select_aml_measures.c
 | 
16
++++++++--------

1 file changed, 8 insertions(+), 8 deletions(-)
diff --git a/src/exchangedb/pg_select_aml_measures.c b/src/exchangedb/pg_select_aml_measures.c
@@ -125,8 +125,8 @@ TEH_PG_select_aml_measures (
   struct GNUNET_PQ_QueryParam params[] = {
     GNUNET_PQ_query_param_bool (NULL == h_payto),
     NULL == h_payto
-    ? GNUNET_PQ_query_param_null ()
-    : GNUNET_PQ_query_param_auto_from_type (h_payto),
+      ? GNUNET_PQ_query_param_null ()
+      : GNUNET_PQ_query_param_auto_from_type (h_payto),
     GNUNET_PQ_query_param_bool ((TALER_EXCHANGE_YNA_ALL ==
                                  finished_only)),
     GNUNET_PQ_query_param_bool ((TALER_EXCHANGE_YNA_YES ==
@@ -157,10 +157,10 @@ TEH_PG_select_aml_measures (
            " FROM wire_targets wt"
            " JOIN legitimization_measures lm"
            "   USING (access_token)"
-           " WHERE (outcome_serial_id > $5)"
+           " WHERE (legitimization_measure_serial_id > $5)"
            "   AND ($1 OR (wt.h_normalized_payto = $2))"
-           "   AND ($3 OR (lo.is_finished = $4))"
-           " ORDER BY lo.outcome_serial_id ASC"
+           "   AND ($3 OR (lm.is_finished = $4))"
+           " ORDER BY lm.legitimization_measure_serial_id ASC"
            " LIMIT $6");
   PREPARE (pg,
            "select_aml_measures_dec",
@@ -173,10 +173,10 @@ TEH_PG_select_aml_measures (
            " FROM wire_targets wt"
            " JOIN legitimization_measures lm"
            "   USING (access_token)"
-           " WHERE (outcome_serial_id < $5)"
+           " WHERE (legitimization_measure_serial_id < $5)"
            "   AND ($1 OR (wt.h_normalized_payto = $2))"
-           "   AND ($3 OR (lo.is_finished = $4))"
-           " ORDER BY lo.outcome_serial_id DESC"
+           "   AND ($3 OR (lm.is_finished = $4))"
+           " ORDER BY lm.legitimization_measure_serial_id DESC"
            " LIMIT $6");
   qs = GNUNET_PQ_eval_prepared_multi_select (pg->conn,
                                              stmt,