about summary refs log tree commit diff
path: root/gn3/db/wiki.py
diff options
context:
space:
mode:
authorMunyoki Kilyungi2025-03-18 17:12:38 +0300
committerBonfaceKilz2025-03-18 17:18:38 +0300
commit858df45c81bf80b1e7ab8bee9c835f7a99b7b76d (patch)
tree3970f0f19a1d6df90322746f927473da56d4a0f3 /gn3/db/wiki.py
parent4e9bfd1b134eae4de365d1c2b22a97dd676b45b9 (diff)
downloadgenenetwork3-858df45c81bf80b1e7ab8bee9c835f7a99b7b76d.tar.gz
Order species by species id.
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
Diffstat (limited to 'gn3/db/wiki.py')
-rw-r--r--gn3/db/wiki.py2
1 files changed, 1 insertions, 1 deletions
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