commit 64de346638975b02493c65e9297b61544a17c6af parent 34aede1405f4d76484a17ac84f1bf1a65baa9894 Author: Joel-Haeberli <haebu@rubigen.ch> Date: Tue, 4 Jun 2024 16:47:03 +0200 fix: wire-gateway-api Diffstat:
| M | c2ec/db-postgres.go | | | 10 | +++++----- |
1 file changed, 5 insertions(+), 5 deletions(-)
diff --git a/c2ec/db-postgres.go b/c2ec/db-postgres.go @@ -98,25 +98,25 @@ const PS_CONFIRMED_TRANSACTIONS_ASC = "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" + " 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)); 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" + " 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)); 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 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) 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) + "')" 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 $2" //(SELECT MIN(" + WITHDRAWAL_FIELD_NAME_CONFIRMED_ROW_ID + ") FROM " + WITHDRAWAL_TABLE_NAME +" WHERE " + WITHDRAWAL_FIELD_NAME_STATUS + "='" + string(CONFIRMED) + "' AND )" + " 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) + "' AND )" const PS_GET_TRANSFERS_ASC = "SELECT * FROM " + TRANSFER_TABLE_NAME + " ORDER BY " + TRANSFER_FIELD_NAME_ROW_ID + " ASC" + @@ -511,7 +511,7 @@ func (db *C2ECPostgres) GetConfirmedWithdrawals(start int, delta int, since time } limit := int(math.Abs(float64(delta))) - offset := start - 1 + offset := start if delta < 0 { offset = start - int(limit) }