diff options
| -rw-r--r-- | tests/unit/db/test_species.py | 6 |
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" ) |