cashless2ecash

commit d99f17c546b2ba144b6ce9f2abfff5254af5b16e
parent 509868d70b885f585f11c1e10f2ddaf6c858103d
Author: Joel-Haeberli <haebu@rubigen.ch>
Date:   Tue,  4 Jun 2024 21:44:28 +0200

fix: wire-gateway-api

Diffstat:
M
c2ec/db-postgres.go
 | 
4
++--

1 file changed, 2 insertions(+), 2 deletions(-)
diff --git a/c2ec/db-postgres.go b/c2ec/db-postgres.go
@@ -104,13 +104,13 @@ const PS_CONFIRMED_TRANSACTIONS_DESC = "SELECT * FROM " + WITHDRAWAL_TABLE_NAME 
 	" WHERE " + WITHDRAWAL_FIELD_NAME_STATUS + "='" + string(CONFIRMED) + "'" +
 	" ORDER BY " + WITHDRAWAL_FIELD_NAME_CONFIRMED_ROW_ID + " DESC" +
 	" LIMIT $1" +
-	" OFFSET ($2 - ((SELECT MAX(confirmed_row_id) FROM c2ec.withdrawal)-(SELECT COUNT(*) FROM c2ec.withdrawal)))" // SELECT * FROM c2ec.withdrawal WHERE withdrawal_status='confirmed' ORDER BY confirmed_row_id ASC LIMIT 920 OFFSET (103 - ((SELECT MAX(confirmed_row_id) FROM c2ec.withdrawal)-(SELECT COUNT(*) FROM c2ec.withdrawal));
+	" OFFSET $2" // SELECT * FROM c2ec.withdrawal WHERE withdrawal_status='confirmed' ORDER BY confirmed_row_id ASC LIMIT 920 OFFSET (103 - ((SELECT MAX(confirmed_row_id) FROM c2ec.withdrawal)-(SELECT COUNT(*) FROM c2ec.withdrawal));
 
 const PS_CONFIRMED_TRANSACTIONS_ASC_MAX = "SELECT * FROM " + WITHDRAWAL_TABLE_NAME +
 	" WHERE " + WITHDRAWAL_FIELD_NAME_STATUS + "='" + string(CONFIRMED) + "'" +
 	" ORDER BY " + WITHDRAWAL_FIELD_NAME_CONFIRMED_ROW_ID + " ASC" +
 	" LIMIT $1" +
-	" OFFSET ($2 - ((SELECT MAX(confirmed_row_id) FROM c2ec.withdrawal)-(SELECT COUNT(*) FROM c2ec.withdrawal)))" // (SELECT MIN(" + WITHDRAWAL_FIELD_NAME_CONFIRMED_ROW_ID + ") FROM " + WITHDRAWAL_TABLE_NAME + " WHERE " + WITHDRAWAL_FIELD_NAME_STATUS + "='" + string(CONFIRMED) + "')"
+	" OFFSET ($2 - (SELECT MAX(confirmed_row_id)))" // (SELECT MIN(" + WITHDRAWAL_FIELD_NAME_CONFIRMED_ROW_ID + ") FROM " + WITHDRAWAL_TABLE_NAME + " WHERE " + WITHDRAWAL_FIELD_NAME_STATUS + "='" + string(CONFIRMED) + "')"
 
 const PS_CONFIRMED_TRANSACTIONS_DESC_MAX = "SELECT * FROM " + WITHDRAWAL_TABLE_NAME +
 	" WHERE " + WITHDRAWAL_FIELD_NAME_STATUS + "='" + string(CONFIRMED) + "'" +