aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorzsloan2023-03-20 01:25:13 +0000
committerzsloan2023-03-20 01:29:50 +0000
commitb3cf6ff7943356f5c227d85d19ce413dbfe230aa (patch)
treee992a260e4d8a89af5284caa4337c141e408e579
parentf7b27947495b4dc928f6c257286bcb6a7112dbed (diff)
downloadgenenetwork3-b3cf6ff7943356f5c227d85d19ce413dbfe230aa.tar.gz
Fix get_all_species test
-rw-r--r--tests/unit/db/test_species.py6
1 files changed, 5 insertions, 1 deletions
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"
)