From 858df45c81bf80b1e7ab8bee9c835f7a99b7b76d Mon Sep 17 00:00:00 2001
From: Munyoki Kilyungi
Date: Tue, 18 Mar 2025 17:12:38 +0300
Subject: Order species by species id.

Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
---
 gn3/db/wiki.py | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/gn3/db/wiki.py b/gn3/db/wiki.py
index 2e12230..7565f05 100644
--- a/gn3/db/wiki.py
+++ b/gn3/db/wiki.py
@@ -101,7 +101,7 @@ def get_categories(cursor) -> Dict[str, int]:
 
 def get_species(cursor) -> Dict[str, str]:
     """Get all species"""
-    cursor.execute("SELECT Name, SpeciesName from Species")
+    cursor.execute("SELECT Name, SpeciesName from Species ORDER BY Species.Id")
     raw_species = cursor.fetchall()
     dict_cats = dict(raw_species)
     return dict_cats
-- 
cgit 1.4.1