aboutsummaryrefslogtreecommitdiff
path: root/src/backenddb
diff options
context:
space:
mode:
authorChristian Blättler <blatc2@bfh.ch>2024-04-30 22:28:08 +0200
committerChristian Blättler <blatc2@bfh.ch>2024-04-30 22:28:08 +0200
commit4a3145fca389fca1bbfc7ba61b7cafd1156ef656 (patch)
treef95de17dcb3e20036dc3b6c0046cf5a2b18cc935 /src/backenddb
parent5d9db0012144cbad9ba90b654fdfff17b55b6af9 (diff)
work on tokens
Diffstat (limited to 'src/backenddb')
-rw-r--r--src/backenddb/pg_lookup_token_family_key.c5
1 files changed, 3 insertions, 2 deletions
diff --git a/src/backenddb/pg_lookup_token_family_key.c b/src/backenddb/pg_lookup_token_family_key.c
index 33fc0b27..a0a5fab1 100644
--- a/src/backenddb/pg_lookup_token_family_key.c
+++ b/src/backenddb/pg_lookup_token_family_key.c
@@ -131,11 +131,12 @@ TMH_PG_lookup_token_family_key (void *cls,
" LEFT JOIN merchant_token_family_keys"
" ON merchant_token_families.token_family_serial = merchant_token_family_keys.token_family_serial"
" AND merchant_token_family_keys.valid_after >= $3"
- " AND merchant_token_family_keys.valid_after < $4"
+ " AND merchant_token_family_keys.valid_after <= $4" /* TODO: Should this be < instead of <=? */
" JOIN merchant_instances"
" USING (merchant_serial)"
" WHERE merchant_instances.merchant_id=$1"
" AND slug=$2"
+ " ORDER BY merchant_token_family_keys.valid_after ASC"
" LIMIT 1");
enum GNUNET_DB_QueryStatus qs;
qs = GNUNET_PQ_eval_prepared_singleton_select (pg->conn,
@@ -161,4 +162,4 @@ TMH_PG_lookup_token_family_key (void *cls,
}
return qs;
-} \ No newline at end of file
+}