cashless2ecash

commit 7213c6a528bb17a43d591746a4623dff6c97ea25
parent 055b86ddb2b969167e632234a422b1f581479115
Author: Joel-Haeberli <haebu@rubigen.ch>
Date:   Mon,  6 May 2024 21:04:48 +0200

fix: wire gateway queries

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
@@ -108,14 +108,14 @@ const PS_CONFIRMED_TRANSACTIONS_ASC_MAX = "SELECT * FROM " + WITHDRAWAL_TABLE_NA
 	" ORDER BY " + WITHDRAWAL_FIELD_NAME_ID + " ASC" +
 	" LIMIT $1" +
 	" OFFSET ((SELECT COUNT(*) FROM " + WITHDRAWAL_TABLE_NAME +
-	" WHERE " + WITHDRAWAL_FIELD_NAME_STATUS + "=" + string(CONFIRMED) + ")-1)" // TODO (-time since request)
+	" WHERE " + WITHDRAWAL_FIELD_NAME_STATUS + "='" + string(CONFIRMED) + "')-1)" // TODO (-time since request)
 
 const PS_CONFIRMED_TRANSACTIONS_DESC_MAX = "SELECT * FROM " + WITHDRAWAL_TABLE_NAME +
 	" WHERE " + WITHDRAWAL_FIELD_NAME_STATUS + "='" + string(CONFIRMED) + "'" +
 	" ORDER BY " + WITHDRAWAL_FIELD_NAME_ID + " DESC" +
 	" LIMIT $1" +
 	" OFFSET ((SELECT COUNT(*) FROM " + WITHDRAWAL_TABLE_NAME +
-	" WHERE " + WITHDRAWAL_FIELD_NAME_STATUS + "=" + string(CONFIRMED) + ")-1)" // TODO (-time since request)
+	" WHERE " + WITHDRAWAL_FIELD_NAME_STATUS + "='" + string(CONFIRMED) + "')-1)" // TODO (-time since request)
 
 const PS_GET_TRANSFERS_ASC = "SELECT * FROM " + TRANSFER_TABLE_NAME +
 	" ORDER BY " + TRANSFER_FIELD_NAME_ROW_ID + " ASC" +