~doyle/blocks.ls.git

author	Jordan Doyle <jordan@doyle.la>	2022-12-10 15:51:00.0 +00:00:00
committer	Jordan Doyle <jordan@doyle.la>	2022-12-10 15:51:00.0 +00:00:00
commit	aff1586411b05a9235e6f799117967ce82b448c3 [patch]
tree	63ee542ce47116f2cf227d3c47cca118fed001f6
parent	a0e64ad96ccbaf26f2132579fc866b6e2f089c17
download	aff1586411b05a9235e6f799117967ce82b448c3.tar.gz

Fix ordering of latest blocks

Diff

 web-api/src/database/blocks.rs | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/web-api/src/database/blocks.rs b/web-api/src/database/blocks.rs
index 0bb608b..5b8d1b8 100644
--- a/web-api/src/database/blocks.rs
+++ b/web-api/src/database/blocks.rs
@@ -52,8 +52,8 @@ pub async fn fetch_latest_blocks(
    let query = "
        SELECT
            blocks.*,
            tx.count,
            tx.weight,
            tx.count AS tx_count,
            tx.weight AS tx_weight,
            (
                SELECT script
                FROM transactions
@@ -71,7 +71,7 @@ pub async fn fetch_latest_blocks(
            FROM transactions
            WHERE transactions.block_id = blocks.id
        ) tx ON true
        ORDER BY blocks.height
        ORDER BY blocks.height DESC
        LIMIT $1 OFFSET $2
    ";