about summary refs log tree commit diff
path: root/wqflask/tests
diff options
context:
space:
mode:
Diffstat (limited to 'wqflask/tests')
-rw-r--r--wqflask/tests/unit/wqflask/api/test_gen_menu.py7
1 files changed, 4 insertions, 3 deletions
diff --git a/wqflask/tests/unit/wqflask/api/test_gen_menu.py b/wqflask/tests/unit/wqflask/api/test_gen_menu.py
index cc666f0c..57eb1650 100644
--- a/wqflask/tests/unit/wqflask/api/test_gen_menu.py
+++ b/wqflask/tests/unit/wqflask/api/test_gen_menu.py
@@ -244,10 +244,11 @@ class TestGenMenu(unittest.TestCase):
             "ProbeFreeze, InbredSet, Tissue, Species WHERE " +
             "Species.Name = 'Mouse' AND Species.Id = " +
             "InbredSet.SpeciesId AND InbredSet.Name = 'HLC' AND " +
-            "ProbeSetFreeze.ProbeFreezeId = ProbeFreeze.Id and " +
+            "ProbeSetFreeze.ProbeFreezeId = ProbeFreeze.Id AND " +
             "Tissue.Name = 'mRNA' AND ProbeFreeze.TissueId = " +
-            "Tissue.Id and ProbeFreeze.InbredSetId = InbredSet.Id " +
-            "ORDER BY ProbeSetFreeze.OrderList DESC")
+            "Tissue.Id AND ProbeFreeze.InbredSetId = InbredSet.Id AND " +
+            "ProbeSetFreeze.public > 0 " +
+            "ORDER BY -ProbeSetFreeze.OrderList DESC, ProbeSetFreeze.CreateTime DESC")
 
     @mock.patch('wqflask.api.gen_menu.build_datasets')
     @mock.patch('wqflask.api.gen_menu.g')