From b3cf6ff7943356f5c227d85d19ce413dbfe230aa Mon Sep 17 00:00:00 2001
From: zsloan
Date: Mon, 20 Mar 2023 01:25:13 +0000
Subject: Fix get_all_species test

---
 tests/unit/db/test_species.py | 6 +++++-
 1 file changed, 5 insertions(+), 1 deletion(-)

(limited to 'tests')

diff --git a/tests/unit/db/test_species.py b/tests/unit/db/test_species.py
index e883b21..073931e 100644
--- a/tests/unit/db/test_species.py
+++ b/tests/unit/db/test_species.py
@@ -51,5 +51,9 @@ class TestChromosomes(TestCase):
             cursor.fetchall.return_value = ()
             self.assertEqual(get_all_species(db_mock), ())
             cursor.execute.assert_called_once_with(
-                "SELECT Name, MenuName FROM Species ORDER BY OrderId"
+                "SELECT Name, MenuName, IFNULL(Family, 'None') "
+                "FROM Species "
+                "ORDER BY IFNULL(FamilyOrderId, SpeciesName) ASC, "
+                "IFNULL(Family, SpeciesName) ASC, "
+                "OrderId ASC"
             )
-- 
cgit v1.2.3